Registry free DB Connection.

#1

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

#2

oakulkarni <oakulkarni (AT) gmail (DOT) com> wrote:

Quote:

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/

#3

oakulkarni <oakulkarni (AT) gmail (DOT) com> wrote:

Quote:

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/

#4

oakulkarni <oakulkarni (AT) gmail (DOT) com> wrote:

Quote:

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/

#5

On Oct 22, 2:22*am, "Tony Toews [MVP]" <tto... (AT) telusplanet (DOT) net> wrote:

Quote:

oakulkarni <oakulka... (AT) gmail (DOT) com> 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

#6

On Oct 22, 2:22*am, "Tony Toews [MVP]" <tto... (AT) telusplanet (DOT) net> wrote:

Quote:

oakulkarni <oakulka... (AT) gmail (DOT) com> 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

#7

On Oct 22, 2:22*am, "Tony Toews [MVP]" <tto... (AT) telusplanet (DOT) net> wrote:

Quote:

oakulkarni <oakulka... (AT) gmail (DOT) com> 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

#8

oakulkarni <oakulkarni (AT) gmail (DOT) com> wrote:

Quote:

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.

Quote:

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/

#9

oakulkarni <oakulkarni (AT) gmail (DOT) com> wrote:

Quote:

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.

Quote:

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/

#10

oakulkarni <oakulkarni (AT) gmail (DOT) com> wrote:

Quote:

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.

Quote:

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/