Access To The Requested File Is Deniedbtrieve Error 46
the requested file is denied(Btrieve Error 46 [LNA][Pervasive][ODBC Engine Interface][Data Record Manager]Access to the requested file is denied(Btrieve Error 46 Last post 09-07-2012 7:05 AM by a.rao@nemsrl.it. 11 replies. Page 1 of 1 (12 items) Sort Posts: Oldest to newest Newest to oldest Previous Next 09-04-2012 9:17 AM a.rao@nemsrl.it Joined on 07-14-2011 Posts 7 [LNA][Pervasive][ODBC Engine Interface][Data Record Manager]Access to the requested file is denied(Btrieve Error 46 Reply Contact We have a db working with PSQLV7 under MS WIndows 2000 Server SP4. Now I try to move this db to a new server that runs MS Windows 2008 R2 Server and the latest PSQLV11 Sp2. I did this because it take part of an invoicing program that during an update change the version of the PSQL from V7 to V11. After the update I must reinitialized the DDF of this db, so I've lost the reference of some tables I added to this db after the update process. First of all I did the rebuild of these tables with the Rebuild utility of PSQLV11. And then I try to import the schema and the data with the sql command : CREATE TABLE xxxxx IN DICTIONARY USING 'xxxxx.mkd'. The creation works for a lot of tables but for the tables with indexes the PCC gives me the following error : "[LNA][Pervasive][ODBC Engine Interface][Data Record Manager]Access to the requested file is denied(Btrieve Error 46". Any help will be appreciated !Thanks in advanceAlessandro 09-04-2012 9:52 AM In reply to Linda84 Joined on 07-10-2007 Posts 764 Re: [LNA][Pervasive][ODBC Engine Interface][Data Record Manager]Access to the requested file is denied(Btrieve Error 46 Reply Contact Some of your data files may be in an older format. PSQL v11 can read from any format file, but can only write (insert/update/delete) if the file is version 6 or later. You can check the file version of your files by opening a command prompt, change directory to the location of your data files, and issue the command: BUTIL -STAT
6.x also returns this error if you try to write to file that http://www.nomad.ee/btrieve/errors/46.shtml you opened in Read-Only mode or is flagged as R/O by DOS or Netware. You also get this status if you do update, insert or delete on a file that has owner name which was not given at the time the file was opened. Back to index Copyright © Madis Kaal 2000-
Help Receive Real-Time Help Create a Freelance Project Hire for a Full Time Job Ways to Get Help Ask a Question Ask https://www.experts-exchange.com/questions/24550719/Pervasive-SQL-error-message.html for Help Receive Real-Time Help Create a Freelance Project Hire for http://www.tek-tips.com/viewthread.cfm?qid=1064694 a Full Time Job Ways to Get Help Expand Search Submit Close Search Login Join Today Products BackProducts Gigs Live Careers Vendor Services Groups Website Testing Store Headlines Experts Exchange > Questions > Pervasive SQL error message Want to Advertise Here? Solved access to Pervasive SQL error message Posted on 2009-07-07 Databases 1 Verified Solution 2 Comments 1,575 Views Last Modified: 2013-12-25 I am receiving the following error from a CREATE PROCEDURE statement being executed through Pervasive.Data.SqlClient.Dll version 2.10.1.2 against WGE 9.6 The statement works fine on other DSNs, and has also worked fine on this access to the DSN until today, super. I really need to know why this is happening, and ideally how to prevent it from randomly appearing on client machines after deployment. The exception is thrown on the "ExecuteNonQuery()" in my code snippit. Pervasive.Data.SqlClient.PsqlException was caught ErrorPosition=0 Message="Pervasive.Data.SqlClient.Lna.LnaException: [LNA][Pervasive][ODBC Engine Interface][Data Record Manager]Access to the requested file is denied(Btrieve Error 46)" Number=-4953 Source="Pervasive.Data.SqlClient" SQLState="0" StackTrace: at Pervasive.Data.SqlClient.Lna.LnaObject.CheckError(LnaResponse res) at Pervasive.Data.SqlClient.Lna.LnaStatement.Execute(ParamInfoSet pis) at Pervasive.Data.SqlClient.PsqlCommandImpl.execute(Boolean parseOnly, CommandBehavior behavior, Boolean needReader) at Pervasive.Data.SqlClient.PsqlCommandImpl.doExecuteNonQuery() at DDInt.Common.CommonCommandImpl.ExecuteNonQuery() at Pervasive.Data.SqlClient.PsqlCommand.ExecuteNonQuery() InnerException: Dim cmdCreateProc As Pervasive.Data.SqlClient.PsqlCommand = m_Connection.CreateCommand() cmdCreateProc.CommandText = strSql If cmdCreateProc.Connection.State <> ConnectionState.Open Then cmdCreateProc.Connection.Open() cmdCreateProc.ExecuteNonQuery() Select all Open in new window 0 Question by:GeekHipster Facebook Twitter LinkedIn Google LVL 18 Best Solution bymirtheil The definition of a status 46: 46: Access to the requested file is deni
Join INTELLIGENT WORK FORUMSFOR COMPUTER PROFESSIONALS Log In Come Join Us! Are you aComputer / IT professional?Join Tek-Tips Forums! Talk With Other Members Be Notified Of ResponsesTo Your Posts Keyword Search One-Click Access To YourFavorite Forums Automated SignaturesOn Your Posts Best Of All, It's Free! Join Us! *Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail. Posting Guidelines Promoting, selling, recruiting, coursework and thesis posting is forbidden.Tek-Tips Posting Policies Jobs Jobs from Indeed What: Where: jobs by Link To This Forum! Add Stickiness To Your Site By Linking To This Professionally Managed Technical Forum.Just copy and paste the BBCode HTML Markdown MediaWiki reStructuredText code below into your site. Pervasive: Pervasive.SQL Forum at Tek-Tips HomeForumsProgrammersDBMS PackagesPervasive: Pervasive.SQL Forum How to update record using Pervasive SQL? thread318-1064694 Forum Search FAQs Links MVPs How to update record using Pervasive SQL? How to update record using Pervasive SQL? ozero (Programmer) (OP) 22 May 05 08:41 I have installed the Pervasive SQL 8.6 trial and successto setup it and connect to my Peachtree data, which mean using select statement in browseing is OK. But I have problems when I try to update record with where statement.For example I am success to update the Chart table by using :"update Chart set LastYrPer12Net = 200"It updated all the field in Chart which mean the data isnot read only.However, when I run follow SQL which generated by SQL DataManager :"update Chart set LastYrPer12Net = 200 where AccountID = '10000'"or "UPDATE "Chart" SET "Chart"."LastYrPer11Net" = 200 WHERE ("Chart"."AccountID"='10000')"It have follow error :ODBC Error