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=MSDAS QL; DSN=data_source _name; DATABASE=db_nam e;
UID=; PWD=;"<---- these parameters are needed even if i've put them in
the data source definition.
Thanks for any hint!
Massimo
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=MSDAS QL; DSN=data_source _name; DATABASE=db_nam e;
UID=; PWD=;"<---- these parameters are needed even if i've put them in
the data source definition.
Thanks for any hint!
Massimo