I have a Pervasive SQL server that hosts our accounting software and I want to link it to a SQL server so that I can use SQL to generate some reports and pull some data
without taxing the pervasive server any more than it already is. So far I have been able to get the server to link and connect and I can see the tables and databases on the pervasive server but I am unable to select anything from the linked server. I
have a linked server set to access the demodata database that pervasive sets up automatically to test and it is named pvswdemodata and when I execute this command I get two errors. The query I am trying to run is
select * from pvswdemodata.demodata..course
Go to the complete details ...