Tim Goldstein
Full Member
 

'Cause sooner or later everyone needs a chief geek
Posts: 212
Gender:
|
Penny, Here's what you do. First, on the server (or machine with the dataset) make sure there is a pervasive ODBC connection under system DSN (it's under admin tools on the server amd the workstations). if it doesn't, enter EVO/DBA go to the company you want to make available through ODBC. Under system tools, UT-A and run odbcddf.run. this makes complaint DDF files for windows. In ODBC, go to System DSN and choose add. Choose Pervasive ODBC Engine Interface and finish. On the next screen, click create, enter a name make sure Bound is checked, give it the locaion of the DDF files (the directory where the company B files are when you ran odbcddf.run) and choose add. choose OK and test the connection. Write down the name of the connection. On the workstation, Open ODBC, go to the System DSN tab and click add. For the driver choose Pervasive ODBC Client Interface and finish. On the next screen enter the data source name (this is the name the workstation is going to call the connection. I reccommend makeing itthe same as the server name you created earlier.) Enter the IP address or the UNC/Domain name for the server and click Get DSN list. The connection you created on the server should now show in the pull down. Choose it and click test. If everything works, click OK. ODBC is now setup for that client. Access it the way you would any other ODBC connection. If you need it on another workstation, follow the above starting at "Write down the name of the connection" This is for Pervasive 2000 only. it's a little different in Pervasive 9.5 on the server side. Hope it helps, Tim
|