Posted by zuEgg on 07/12/06 08:13

Hi,

i need to connect to a SQL Server db using an odbc data source and SQL
Server authentication. When i create the data source from the control
panel i set up the authentication with the SQL Server authentication
providing my id and pass.

The problems comes when i open the connection in the vba macro in
excel. it doesn't retrieve the informations about user and pass from
the data source and i don't want to put user and pass in the macro code
for security reasons...

The code of the connection setup:

cn.Open "PROVIDER=MSDASQL; DSN=data_source_name; DATABASE=db_name;
UID=; PWD=;"<---- these parameters are needed even if i've put them in
the data source definition.

Thanks for any hint!

Massimo

[Back to original message]