Registry free DB Connection.

#11

oakulkarni wrote:

Quote:

Hi,

My application needs database. We use SQLConnect to connect to
database through DSN. The SQLConnect uses the registry to look the DSN
entries. What i want to do is the, connect to the DB without registry.
We ship the database connection drivers with our product. I even tried
to use the SQLDriverConnect, in this i had provided all the connection
paramters but still it takes the Driver info from registry. Is it
possible to provide the whole path of the driver in the connection
string while connecting e.g. SQLDriverConnect(...,DRIVER="...../
odbc.dll,.....) I tried FileDSN but that also not working. FileDSN is
not actually registry free connection. It also looks for the DB
Driver in the registry.
Please, if anybody is having any info please let me know.

ODBC does not support "registry free" connections. There are two types
of ODBC registries: one for DSNs (Data Source Names) and one for
Drivers. You can have a DSN-less connection, but you must specify a
registered driver name instead. You do this with SQLDriverConnect()
and the DRIVER property. You can't use the path to the driver .dll to
connect.

--
Lee Fesperman, FFE Software, Inc. (http://www.firstsql.com)
================================================== ============
* The Ultimate DBMS is here!
* FirstSQL/J Object/Relational DBMS (http://www.firstsql.com)

#12

oakulkarni wrote:

Quote:

Hi,

My application needs database. We use SQLConnect to connect to
database through DSN. The SQLConnect uses the registry to look the DSN
entries. What i want to do is the, connect to the DB without registry.
We ship the database connection drivers with our product. I even tried
to use the SQLDriverConnect, in this i had provided all the connection
paramters but still it takes the Driver info from registry. Is it
possible to provide the whole path of the driver in the connection
string while connecting e.g. SQLDriverConnect(...,DRIVER="...../
odbc.dll,.....) I tried FileDSN but that also not working. FileDSN is
not actually registry free connection. It also looks for the DB
Driver in the registry.
Please, if anybody is having any info please let me know.

ODBC does not support "registry free" connections. There are two types
of ODBC registries: one for DSNs (Data Source Names) and one for
Drivers. You can have a DSN-less connection, but you must specify a
registered driver name instead. You do this with SQLDriverConnect()
and the DRIVER property. You can't use the path to the driver .dll to
connect.

--
Lee Fesperman, FFE Software, Inc. (http://www.firstsql.com)
================================================== ============
* The Ultimate DBMS is here!
* FirstSQL/J Object/Relational DBMS (http://www.firstsql.com)

#13

oakulkarni wrote:

Quote:

Hi,

My application needs database. We use SQLConnect to connect to
database through DSN. The SQLConnect uses the registry to look the DSN
entries. What i want to do is the, connect to the DB without registry.
We ship the database connection drivers with our product. I even tried
to use the SQLDriverConnect, in this i had provided all the connection
paramters but still it takes the Driver info from registry. Is it
possible to provide the whole path of the driver in the connection
string while connecting e.g. SQLDriverConnect(...,DRIVER="...../
odbc.dll,.....) I tried FileDSN but that also not working. FileDSN is
not actually registry free connection. It also looks for the DB
Driver in the registry.
Please, if anybody is having any info please let me know.

ODBC does not support "registry free" connections. There are two types
of ODBC registries: one for DSNs (Data Source Names) and one for
Drivers. You can have a DSN-less connection, but you must specify a
registered driver name instead. You do this with SQLDriverConnect()
and the DRIVER property. You can't use the path to the driver .dll to
connect.

--
Lee Fesperman, FFE Software, Inc. (http://www.firstsql.com)
================================================== ============
* The Ultimate DBMS is here!
* FirstSQL/J Object/Relational DBMS (http://www.firstsql.com)

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Registry free DB Connection.

comp.databases comp.databases

Re: Registry free DB Connection. - 10-23-2008 , 01:16 AM

Re: Registry free DB Connection. - 10-23-2008 , 01:16 AM

Re: Registry free DB Connection. - 10-23-2008 , 01:16 AM