.dat file location change

[sleeplessnights]

Hi,
I have got a pervasive sql database with a table name
A0001 but 4 different file names for instance
A0001_01 ;A0001_02 ...
The problem is that the file location is not linked
when making the odbc connection
Is it possible to define the location in VB6 ADO
the reason for the different file name is for different
company database's for company 1 file = a0001_01

could enyone tell me how I could change the table location in VB6 prog using ADO and ODBC conection

Kind regards

Kevin

 

[mirtheil]

You're probably going to have to define multiple tables with the DDFs. ODBC (with Pervasive.SQL 2000 and later) uses a DSN and a Database Name. The Database Name defines where (path-wise) the DDFs and data files are located. Within the DDFs, the table name is linked to a specific file name (XF$LOC field in the X$FILE).


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

http://www.mirtheil.com