Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

vba sql server connection

Discussion in 'Information Technology' started by zuEgg, Jul 28, 2006.

  1. zuEgg

    zuEgg
    Expand Collapse
    Guest

    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
     
  2. Loading...

    Similar Threads Forum Date
    Microsoft Brings 64-Bit Perks in SQL Server 2000 Service Pack (Ziff Davis) Interfaith Dialogues May 7, 2005

  3. Norman Yuan

    Norman Yuan
    Expand Collapse
    Guest

    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
    is for current user).

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

    "zuEgg" <zuegg@hotmail.it> wrote in message
    news:1152629941.074431.202460@35g2000cwc.googlegroups.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
    > the data source definition.
    >
    > Thanks for any hint!
    >
    > Massimo
    >
     

Share This Page