ODBC Connection

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Alain - 20 Sep 2004 16:10 GMT

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

Reply to this Message

John Nurick - 20 Sep 2004 19:35 GMT

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.html
and
http://www.able-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
[quoted text clipped - 9 lines]
>
>Alain

--
John Nurick [Microsoft Access MVP]

Please respond in the newgroup and not by email.

Reply to this Message

- 21 Sep 2004 16:06 GMT

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,
[quoted text clipped - 5 lines]
>and
>http://www.able-

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
[quoted text clipped - 15 lines]
>Please respond in the newgroup and not by email.
>.

Reply to this Message

John Nurick - 22 Sep 2004 07:16 GMT

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#ODBCDriverFo
rSQLServer

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.

On Tue, 21 Sep 2004 08:06:03 -0700,

>Thanks John, I have look at it and tries some of the
>solutions but I am still getting the dialogbox asking for
[quoted text clipped - 39 lines]
>>Please respond in the newgroup and not by email.
>>.

--
John Nurick [Microsoft Access MVP]

Please respond in the newgroup and not by email.

Reply to this Message