OLE DB cna not connect

[john230873]

Trying to use the pervasive OLE DB component for data connection and it is not working. I have tried it in multiple applications (SQL DTS, DELPHI, .NET) and I seem to always get the same error (No such table).

Using Pervasive 2000i SP3 on Novell 5 servers/ win 2000 workstations

So this is what I do

Drop an OLE DB component on the screen
Open its properties
for data source I type in "\\PROD00\SYS\PVSW\DEMODATA\"
for location I type in "\\PROD00\SYS\PVSW\DEMODATA\"
This tests ok when the test button is used.

I have tried
for data source "DEMODATA"
for location in "PROD00" But this has not worked.


When I try to use this component even though the test has pasted I get an error of "No such table"

Any ideas as I haven't been able to find the answer?

Under the Pervasive Analyser the relational access to Pervasive.SQL 2000i is functional

 

[TomKane]

When we create connection string we always use microsoft data link or the properties of the ADODC control in VB. THis is the sort of thing that we get out of it:

As per the build connection string

DSN=Commercial;DATAPATH=o:\bmpc\data\branch01\iam;UID=;DDFPATH=o:\bmpc\data;BOB=;NullEnabled=no;FeaturesUsed=no;LoginScript=;AccessFriendly=no;DateFormat=mdy;

When I was finally able to open the file via notepad:

[oledb]
; Everything after this line is an OLE DB initstring
Provider=MSDASQL.1;Persist Security Info=False;Data Source=Commercial