Hello Ian,
The ODBC driver uses the DDF files to connect to the database. There must br
DDF files in the uni folder.
When you create a Pervasive DSN, Pervasive catalogues the ODBC database by
DSN name in the "DBNAMES.CFG" file located in the C:\Windows folder by
default.
The only way to connect to the database in the uni folder using SQL is to
ensure the DDF files are there, and structured correctly.
The DDF files contain the database structure information. Table names,
column names & types, and indexes. Typically there are 3 DDF files:
Field.ddf - File.ddf - Index.ddf
If you don't have DDF files, then you'll have to create them for your .dat
files.
Rick Sanders
> A non-Tango question, but the Pervasive experts used to be on this list.
>
> I need to connect to a Pervasive database that is not defined in the
normal
> fashion (it is not visible in the Control Center). There is a normal
> Pervasive database on the network, with another database in a sub-folder.
I
> need to open the database in a sub-folder of the current database that is
> opened.
>
> Ex: database is located at:
>
> o:\data\bicdat, I need to open o:\data\bicdat\uni
> o:\data\xyz, I need to open o:\data\xyz\uni
>
> The other database will always be in the uni sub-folder. I can connect via
> ODBC, but this doesn't let me dynamically connect to the appropriate
> database (varies with the Pervasive database that is opened). I assume I
> need the dsn-less connection, but what is the connection string I need
> (ADODB and/or .net)
>
> For my 'normal' database, I have a connect string of:
>
> cn.ConnectionString = "Driver={Pervasive ODBC Client Interface};
> ServerName=" + sServer + "; DBQ=" + sDBId (sDBId = BICDAT, BICTST etc
> depending on the database I want to open, and could be located anywhere on
> the network)
>
> How can I dynamically get to the database in the 'uni' sub-folder.
>
> ________________________________________________________________________
> TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
>
________________________________________________________________________
TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
