Re: Registry free DB Connection.

oakulkarni <oakulkarni@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 Connections
http://www.accessmvp.com/djsteele/DSNLessLinks.html
ODBC DSN-Less Connection Tutorial Part I
http://www.amazecreations.com/datafast/GetFile.aspx?file=ODBCTutor01.htm&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/
.

Relevant Pages

  • RE: Microsoft Access versus Programmatic Data Access
    ... If you are actually attempting with the DSN, you are using a connection that ... to a connection string that points to the database instead of trying to use ... > I am accessing an Oracle database using a Microsoft Access front end,> making use of linked tables, via a DSN. ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Registry free DB Connection.
    ... The SQLConnect uses the registry to look the DSN ... What i want to do is the, connect to the DB without registry. ... We ship the database connection drivers with our product. ... paramters but still it takes the Driver info from registry. ...
    (comp.databases)
  • RE: Windows 2000 RRAS and ipSEC /L2TP VPN
    ... How to Configure a L2TP/IPSec Connection Using Pre-shared Key Authentication ... This article contains information about modifying the registry. ... , Windows 2000 is compliant with IKE RFC ...
    (microsoft.public.win2000.networking)
  • Re: Clients not able to ftp
    ... I already have a EnableRSS record in my registry. ... FTP site from command line but cannot access it from IE after you install ... for the connection and the hardware hash code for the connection do not ... Microsoft CSS Online Newsgroup Support ...
    (microsoft.public.windows.server.sbs)
  • RE: Problems to create a new internet conection
    ... You Cannot Create a Network Connection After You Restore Windows XP ... This article contains information about modifying the registry. ... You cannot create a remote access or Dial-Up Networking connection. ...
    (microsoft.public.windowsxp.help_and_support)