0

I have a linked server to a pervasive sql 11 database from my sql server 2012 64bit using ODBC

I am able to see the databases on this server, but when I select * from any table I am getting this error:

OLE DB provider "MSDASQL" for linked server "kslap208" returned message "[Pervasive][ODBC Client Interface][LNA][Pervasive][ODBC Engine Interface][Data Record Manager]The MicroKernel cannot find the specified file(Btrieve Error 12)".
OLE DB provider "MSDASQL" for linked server "kslap208" returned message "[Pervasive][ODBC Client Interface][LNA][Pervasive][ODBC Engine Interface]Unable to open table: aactual.".
Msg 7306, Level 16, State 2, Line 1
Cannot open the table ""sbxc003"."aactual"" from OLE DB provider "MSDASQL" for linked server "kslap208".

How is it possible that I am able to test the connection succesfully and see all the databases; however, I cannot select?

Alex Gordon
  • 57,446
  • 287
  • 670
  • 1,062
  • You might want check your ODBC setting and make sure it was set correctly, the error message "The MicroKernel cannot find the specified file" lead me to think something in setup was wrong – Simon Wang Feb 08 '13 at 05:46
  • When you set up your ODBC did you test it? Are you certain that your login gives you access to this table? If you create a linked table in MS Access to this ODBC connection, what tables do you see? – Nick.Mc Feb 08 '13 at 05:54
  • @SimonWang thank you , but i did test the connecetion and everything seemed fine – Alex Gordon Feb 08 '13 at 05:56
  • @ElectricLlama thank you for the message. yes i did test the connection was good – Alex Gordon Feb 08 '13 at 05:57
  • please post a select statement that fails – paparazzo Feb 08 '13 at 14:41
  • @Blam select * from kslap208.sbxc003..aactual – Alex Gordon Feb 08 '13 at 17:15
  • Only a comment but try select * from kslap208.sbxc003.dbo.aactual (or the owner of the table) – paparazzo Feb 08 '13 at 17:23
  • thank you, i did try that already – Alex Gordon Feb 08 '13 at 17:23
  • How do you authenticate to linked server? Does that user have select authority? – paparazzo Feb 08 '13 at 17:56
  • i am succesfully linking to this linked server from a different server with sql server 2005 with the same username and no problems selecting – Alex Gordon Feb 08 '13 at 18:52
  • its some sort of funny memory issue or something. when i select more than a certain number of columns, i get the catastrophic error, otherwise it works – Alex Gordon Feb 08 '13 at 19:43
  • @SimonWang its some sort of funny memory issue or something. when i select more than a certain number of columns, i get the catastrophic error, otherwise it works – Alex Gordon Feb 08 '13 at 22:23
  • @ElectricLlama its some sort of funny memory issue or something. when i select more than a certain number of columns, i get the catastrophic error, otherwise it works – Alex Gordon Feb 08 '13 at 22:24
  • Sounds like you need to analyse it some more - exactly how many columns before it fails? is it a specific column? does it work if you type select 1 from kslap208.sbxc003..aactual – Nick.Mc Feb 10 '13 at 22:54

0 Answers0