Pervasive ODBC help

[sconant]

I'm trying to make an Access 2000 database with links to tables on a Pervasive 2000i server. The database is transfered from an old 6.15 database. So I believe that it's using the transactional engine.

I've got the directories set up in the Pervasive control center, and set up as DSNs for each directory/database.

I managed to get the Access database to attach the tables I want and I can get my results that I want. The trouble is that I would like to have multiple users accessing this database. On my workstations I set up ODBC the same as my development PC, but when I try to use the database in Access, I can't connect to the tables.

Please Help!!! I'm a newbie/rookie/andwhateverelseyouwanttocallme when it comes to databases, much less Access and Pervasive, but I'm trying to do whatever it takes.

Any recommended books to help me learn would be much appreciated.

 

[Vancouverite]

Try setting up a File DSN instead of a local DSN for your connection, and place the file somewhere on your network that everyone has access to. You should then be able to connect.

 

[sconant]

Ok..here's the dumb question: How does one do that?? I went into ODBC Administrator, clicked on the File DSN tab, clicked on add, selected the Pervasive ODBC Client Interface, selected the directory and filename on the file server I wanted to use, clicked finish then it tells me that "A connection could not be made using the file data source parameters entered. Save non-verified file DSN?"

If I click on Yes then it makes a file DSN. If I try to configure it, it asks for a Username and Password. I enter my credentials...and it says "General Error: Invalid file DSN 'C:\access\stock.dsn'"

There is nothing anywhere where I get a chance to configure the File DSN.

Thanks for the reply!

 

[Vancouverite]

I recall having this problem now (I have used the File DSN's for so long, I didn't remember it).

You need to manually edit the DSN file (any text editor will work - notepad is fine). This structure works well
-----------------------------
[ODBC]
DRIVER=Pervasive ODBC Client Interface
DSN=TestData
ServerName=DBSRVR2.1583
ServerDSN=TestData
ArrayFetchOn=1
ArrayBufferSize=8
TransportHint=SPX:TCP
DBQ=TestData
CODEPAGE=,6Ó;
TABLE=Password
----------------------
If I remember correctly, the key to making it work is to add the TABLE=<Some Table in your DB> line. Check your DSN. If it's missing some of these lines, then you may need to implement them. A detailed description of the file:

[ODBC]
DRIVER=Pervasive ODBC Client Interface <-- The Driver.. duh!
DSN=TestData <-- any name... I have one with BOB
ServerName=DBSRVR2.1583 <-- Server (in this case with SPX)
ServerDSN=TestData <-- The Engine DSN name on the server
ArrayFetchOn=1 <-- Leave these two as is
ArrayBufferSize=8 <--
TransportHint=SPX:TCP <-- Specify what to check for comm method
DBQ=TestData <-- The database name
CODEPAGE=,6Ó; <-- Leave this as is
TABLE=Password <-- A table in your DB