Re: Registry free DB Connection.
- From: oakulkarni <oakulkarni@xxxxxxxxx>
- Date: Wed, 22 Oct 2008 09:16:25 -0700 (PDT)
On Oct 22, 2:22 am, "Tony Toews [MVP]" <tto...@xxxxxxxxxxxxxxx> wrote:
oakulkarni <oakulka...@xxxxxxxxx> 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 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
.
- Follow-Ups:
- Re: Registry free DB Connection.
- From: Tony Toews [MVP]
- Re: Registry free DB Connection.
- References:
- Registry free DB Connection.
- From: oakulkarni
- Re: Registry free DB Connection.
- From: Tony Toews [MVP]
- Registry free DB Connection.
- Prev by Date: Re: Normalizing a common ID type shared across tables
- Next by Date: Re: Registry free DB Connection.
- Previous by thread: Re: Registry free DB Connection.
- Next by thread: Re: Registry free DB Connection.
- Index(es):
Relevant Pages
|
