hiding or skipping DSN connection UID and password

[Jayson]

I'm currently using SQL Server 2000 as a database backbone for my ASP site, now when i need to establish a connection
i type something like:

oConn.Open "DRIVER={SQL Server};SERVER=SomeServerName; DATABASE=SomeDBName;UID=SomeGuestAccount;Password=SomePassword;"

I know that this whole line won't show up on a browser, but I just don't feel comfortable typing windows/sql server username and password, is there any syntax that i could use instead of this to connect to my SQL Server using the guest account "SomeGuestAccount"?

Thanks!

Jayson

 

[ToddWW]

I don't work with SQL Server, but I setup an actual DSN from Start>> Administrative Tools>> Data Sources (ODBC) for my Fox Pro database. I provided all of the authentication there and my connection strings look like this.

oConn.Open DSN=mydsnname

Does that help ??

TW

 

[Jayson]

Alrighty, i'll give that a try, thanks!

Jayson