David Waldmann
Active Member
   

Live to work, or work to live?
Posts: 1919
Gender:
|
1. See if you have any DDF files in the Company Folder (NOT the DBAMFG root directory). If not, go to UT-A and run ODBCDDF.RUN. 2. On the server, go to the Control Panel and look for an applet called BDE Administrator, ODBC Administrator, Data Sources or something like that - it varies with Pervasive version and maybe OS. If it's the BDE Admin you'll have a list of databases and a menu across the top. Go to Object > ODBC Administrator and you will get to the ODBC Data Source Administrator. Under System DSN click Add and scroll down to Pervasive ODBC Server Engine. Click Finish. In the next box that comes up, give it a name. I use DBA followed by the company code so I can have more than one company and be able to easily tell the difference. You can call it whatever you want. Under Database Name, click Create. In the next box that pops up, give it a name - I use the same one as for the DSN. Then click Browse and select the folder where your data is. Save, OK, etc until everything is closed out. 3. On your workstation, find the same or equivalent ODBC Data Source Administrator. This time go to User DSN, Add, Pervasive ODBC Client Interface. Give it a name - I use the same as the Server DSN. Enter the Server Name under Address, then "Get DSN". If you don't see the one you just entered click the drop down box and select the one you want. Wouldn't hurt to test it, then save, ok etc your way out. That should do it.
|