Connection object have several ways to connect to the server. There is a way that gets user name and password in parameters. Probably you will need that one, or specify user as 'UID=..' and password as 'PWD=..' in the connection string.
>Hi all,
>I created an ADO Connection object and tried to open the connection by setting the ConnectionString property, Access Denied error occurred. Then I created a new ODBC DSN and tried to open the connection again by setting the ConnectionString property, everything worked out fine. My question is, does ODBC DSN required to make a ADO connection? TIA.
>
>Wan
Vlad Grynchyshyn, Project Manager, MCP
vgryn@yahoo.comICQ #10709245
The professional level of programmer could be determined by level of stupidity of his/her bugs
It is not appropriate to say that question is "foolish". There could be only foolish answers. Everybody passed period of time when knows nothing about something.