Registry free DB Connection.

[Database Administrator]

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.

Thanks,
Omkar

[Database Administrator]

oakulkarni wrote:

>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.

The following links are all for Access The key line in the first link is
tdfCurrent.Connect = "ODBC;DRIVER={sql server};DATABASE=" & _
DatabaseName & ";SERVER=" & ServerName & _
";Trusted_Connection=Yes;"
You will need to adapt that type of syntax to your programming language/environment
of course.

Using DSN-Less Connections
http://www.accessmvp.com/djsteele/DSNLessLinks.html
ODBC DSN-Less Connection Tutorial Part I
http://www.amazecreations.com/datafa...m&Article=true
HOWTO: Use "DSN-Less" ODBC Connections with RDO and DAO
http://support.microsoft.com/?id=147875
ODBC DSN Less
http://www.carlprothman.net/Default.aspx?tabid=81
Relink ODBC tables from code
http://www.mvps.org/access/tables/tbl0010.htm

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/

[Database Administrator]

On Oct 22, 2:22*am, "Tony Toews [MVP]" wrote:
> oakulkarni wrote:
> >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.
>
> The following links are all for Access * The key line in the first linkis
> * * tdfCurrent.Connect = "ODBC;DRIVER={sql server};DATABASE=" &_
> * * * * * * * * * * * * DatabaseName & ";SERVER=" & ServerName & _
> * * * * * * * * * * * * ";Trusted_Connection=Yes;"
> You will need to adapt that type of syntax to your programming language/environment
> of course.
>
> Using DSN-Less Connectionshttp://www.accessmvp.com/djsteele/DSNLessLinks.html
> ODBC DSN-Less Connection Tutorial Part Ihttp://www.amazecreations.com/datafast/GetFile.aspx?file=ODBCTutor01....
> HOWTO: Use "DSN-Less" ODBC Connections with RDO and DAOhttp://support.microsoft.com/?id=147875
> ODBC DSN Lesshttp://www.carlprothman.net/Default.aspx?tabid=81
> Relink ODBC tables from codehttp://www.mvps.org/access/tables/tbl0010.htm
>
> Tony
> --
> Tony Toews, Microsoft Access MVP
> * *Please respond only in the newsgroups so that others can
> read the entire thread of messages.
> * *Microsoft Access Links, Hints, Tips & Accounting Systems athttp://www.granite.ab.ca/accsmstr.htm
> * *Tony's Microsoft Access Blog -http://msmvps.com/blogs/access/

Thanks for your reply. But I dont know how does this solve my problem.
Actually we use sysbase database. They have there own drivers. What i
just need to do is While connecting to database, i want to provide all
the parameters needed to connect. connection string e.g. driver (here
driver would be the full path of the dll rather than just
"ODBC;DRIVER={sql server}"), it would be like this Driver=C:/program
files/dbms/abc.dll , database server name, password etc. All the links
which u have mentioned directly/indirectly depend on registry. What i
want to do is connect to db without registry. it would be possible
that we dont want to install the driver and just use it. Is it
possible? it should be just plug-in and play sort of.

Thanks

[Database Administrator]

oakulkarni wrote:

>Thanks for your reply. But I dont know how does this solve my problem.
>Actually we use sysbase database. They have there own drivers. What i
>just need to do is While connecting to database, i want to provide all
>the parameters needed to connect. connection string e.g. driver (here
>driver would be the full path of the dll rather than just
>"ODBC;DRIVER={sql server}"), it would be like this Driver=C:/program
>files/dbms/abc.dll , database server name, password etc. All the links
>which u have mentioned directly/indirectly depend on registry.

No, those links don't depend on the registry.. They all talk about how to set the
connection string in Access using VBA. Same idea for other apps.

>What i
>want to do is connect to db without registry. it would be possible
>that we dont want to install the driver and just use it. Is it
>possible? it should be just plug-in and play sort of.

Well, you're going to need drivers of some sort, be they built into the OS or
installed.

I'd suggest asking in a sysbase (or is that Sybase) newsgroup.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/

[Database Administrator]

oakulkarni wrote:
> 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)