ODBC Connection

  • Thread starter Thread starter Alain
  • Start date Start date
A

Alain

Hi to all, I want to programatically automate an odbc
connection to an externat SQL server, I would like to
know where I can find some good learning documentation (
tried ms knowledge base but too complex for me, my
english is not quite perfect) or if anyone can help me on
making a connection, I already have an ODBC connection
made in the system DSN and I just want to bypass the
dialog box asking foe the password everytime I need to
run some reports

Thanks

Alain
 
Thanks John, I have look at it and tries some of the
solutions but I am still getting the dialogbox asking for
the password. I am really in the clouds with this

Can you show me a step by step example of a connection

Thanks

-----Original Message-----
Hi Alain,

See http://www.able- consulting.com/MDAC/ADO/Connection/ODBC_DSN.htm#DSN

- but also consider using a connection without DSN, for which see
http://members.rogers.com/douglas.j.steele/DSNLessLinks.h tml
and
http://www.able-
Click to expand...
consulting.com/MDAC/ADO/Connection/ODBC_DSNLess.htm
Hi to all, I want to programatically automate an odbc
connection to an externat SQL server, I would like to
know where I can find some good learning documentation (
tried ms knowledge base but too complex for me, my
english is not quite perfect) or if anyone can help me on
making a connection, I already have an ODBC connection
made in the system DSN and I just want to bypass the
dialog box asking foe the password everytime I need to
run some reports

Thanks

Alain
Click to expand...

--
John Nurick [Microsoft Access MVP]

Please respond in the newgroup and not by email.
.
Click to expand...
 
Alain,

I have little experience with ODBC. When I need to use it I just look
for examples of connection strings and modify them until they work. For
SQL Server I'd start at
http://www.able-consulting.com/MDAC/ADO/Connection/ODBC_DSNLess.htm#ODBCDriverForSQLServer

If you can't get this to work, I suggest you post a new message here
(not a response to this one) and include the relevant part of your code
and the connection string you are using.



Thanks John, I have look at it and tries some of the
solutions but I am still getting the dialogbox asking for
the password. I am really in the clouds with this

Can you show me a step by step example of a connection

Thanks

-----Original Message-----
Hi Alain,

See http://www.able- consulting.com/MDAC/ADO/Connection/ODBC_DSN.htm#DSN

- but also consider using a connection without DSN, for which see
http://members.rogers.com/douglas.j.steele/DSNLessLinks.h tml
and
http://www.able-
Click to expand...
consulting.com/MDAC/ADO/Connection/ODBC_DSNLess.htm
Hi to all, I want to programatically automate an odbc
connection to an externat SQL server, I would like to
know where I can find some good learning documentation (
tried ms knowledge base but too complex for me, my
english is not quite perfect) or if anyone can help me on
making a connection, I already have an ODBC connection
made in the system DSN and I just want to bypass the
dialog box asking foe the password everytime I need to
run some reports

Thanks

Alain
Click to expand...

--
John Nurick [Microsoft Access MVP]

Please respond in the newgroup and not by email.
.
Click to expand...
Click to expand...
 
Back
Top