Linking Access to Platinum for Windows...HELP!!!

[Aerowolf]

OK...I'd like to know if I can access Platinum's files from within an MS Access 2000 application I've written. My application right now requires that I enter the orders into it and then it generates production & shipping schedules, shipping paperwork, etc. I'd like to be able to pull the order information directly from the Platinum files to eliminate the need to re-enter the info into my application.

How do I do this? I've read about DNS & ODBC and I just can't figure it out.

The Platinum files are on a server called \\Netserver under the path Apps\Platinum\KDM. I've seen the Pervasive Control Center but don't know if that's what I need to use.

Sorry if this is basic knowledge to most, but I've never used DNS or ODBC before and I'd really like to be able to do this.

Thanks alot!

Edwin

 

[mirtheil]

Some good starting points:

http://www.pervasive.com/library/docs/psql/810/sgs/06dsndbn.html

http://www.pervasive.com/library/docs/psql/810/usrguide/control.html

http://www.pervasive.com/library/docs/psql/810/usrguide/using4.html

and

http://www.pervasive.com/library/docs/psql/810/usrguide/using9.html

(Accessing Data via ODBC From Other Applications)

Mirtheil
Certified Pervasive Developer
Certified Pervasive Technician
Custom VB and Btrieve development.

http://www.mirtheil.com

 

[Aerowolf]

OK...

I went to the server machine and created a System DSN using the engine driver. Now as I understand it, I need to create a System DSN on my machine using the client driver, right?

When I go to the ODBC administrator to add a new System DSN using the Pervasive ODBC Client interface, I enter \\Netserver as the server address and click the Get DSN List button. I get an error that says the following:

"Unable to retrieve DSNs on the specified remote server"...

What am I doing wrong?

Edwin

 

[mirtheil]

Probably a communication issue. Does PSA work to the remote server?


Mirtheil
Certified Pervasive Developer
Certified Pervasive Technician
Custom VB and Btrieve development.

http://www.mirtheil.com

 

[Aerowolf]

PSA??? I know that if I open PCC I can see the database files through the DSN engine I created on the server. I just can't seem to create the DSN on my machine.

Edwin