The ddf files are there, it is a valid Pervasive database. I just don't know
where it is located. All I know is the database I am looking for is located
in a sub-folder of the currently open database. The currently open database
is loaded from the server engine, and could be located anywhere on the
network.
I don't think I can create the DSN, as it is fixed to a specific folder, and
the folder depends on what database the user has opened, and the physical
location of the database is stored on the server. [I also don't want to log
in to every user machine and create a DSN]
There must be a way of doing it, as the application that creates/maintains
the database does exactly this. If the current database is x:\xyz, Pervasive
DSN=xyz, it can create/maintain a database in x:\xyz\uni. All I know is the
user opened DBQ=xyz on the server, but I don't know where it is located on
the network.
----------------------------
From: "Rick Sanders" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Reply-To: [EMAIL PROTECTED]
Subject: Re: Witango-Talk: Pervasive drivers
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
________________________________________________________________________
TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
