vba sql server connection

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
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/information-technology/13010-vba-sql-server-connection.html
panel i set up the authentication with the SQL Server authentication
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=13010
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

 
Do share your immediate thoughts or reactions on this issue? We value your views! Login Now! or Sign Up Today! to share your views with us.. Gurfateh!

If you have enterd username/password when creating the DSN, you do not need
to supply them again in your VBA code's ConnectionString, the only thing you
need in your ConnectionString is the DSN:

cn.Open "MyDSN"

As long as the DSN is valid to current user (Systam DSN or an User DSN that
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=13010
is for current user).

BTW, this NG is for MS Access. You may get better response from other
appropriate NGs.

"zuEgg" wrote in message
news:1152629941.074431.202460@35g2000cwc.googlegro ups.com...
> 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
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=13010
> the data source definition.
>
> Thanks for any hint!
>
> Massimo
>