Connect to SQL with DSN without uid adn password

[augustus]

Hi,

I'm trying to connect to SQL Server 2005 with SQL server driver (not
everyone in the company have the SQL Native Client driver) under ODBC, from
an Excel VBA spreadsheet.

I have setup a DSN connection, and did the test, everything is working.

Our SQL setup is authenticate by SQL Server.

My questions are

1) How to connect to the SQL server via DSN without username and password?
(I thought that if I have setup a DSN inside DSN, I shouldn't need to supply
a username and password inside the connection. I manage to connect to the SQL
server with uid and password.)

2) What I'm trying to do is connect to SQl without user requring to know thr
password/uid, and without having this info inside the VBA (after all, this
day, a file can be easily copied to anywhere). What options have I got?

Thanks in advance.

Regards
augustus108

 

[G Frazier]

Did you ever find the answer for this? I need to do the same thing, but make the connection from Visio and don't want to store the UID & password in the code.




augustu wrote:

Connect to SQL with DSN without uid adn password
24-Feb-09

Hi

I'm trying to connect to SQL Server 2005 with SQL server driver (not
everyone in the company have the SQL Native Client driver) under ODBC, from
an Excel VBA spreadsheet

I have setup a DSN connection, and did the test, everything is working

Our SQL setup is authenticate by SQL Server

My questions ar

1) How to connect to the SQL server via DSN without username and password?
(I thought that if I have setup a DSN inside DSN, I shouldn't need to supply
a username and password inside the connection. I manage to connect to the SQL
server with uid and password.

2) What I'm trying to do is connect to SQl without user requring to know thr
password/uid, and without having this info inside the VBA (after all, this
day, a file can be easily copied to anywhere). What options have I got

Thanks in advance

Regard
augustus108

Previous Posts In This Thread:

Connect to SQL with DSN without uid adn password
Hi

I'm trying to connect to SQL Server 2005 with SQL server driver (not
everyone in the company have the SQL Native Client driver) under ODBC, from
an Excel VBA spreadsheet

I have setup a DSN connection, and did the test, everything is working

Our SQL setup is authenticate by SQL Server

My questions ar

1) How to connect to the SQL server via DSN without username and password?
(I thought that if I have setup a DSN inside DSN, I shouldn't need to supply
a username and password inside the connection. I manage to connect to the SQL
server with uid and password.

2) What I'm trying to do is connect to SQl without user requring to know thr
password/uid, and without having this info inside the VBA (after all, this
day, a file can be easily copied to anywhere). What options have I got

Thanks in advance

Regard
augustus108


Submitted via EggHeadCafe - Software Developer Portal of Choice
..NET Web Services On Mobile Devices
http://www.eggheadcafe.com/tutorial...22-c05e14105eb5/net-web-services-on-mobi.aspx