DB Connection String

[Derek Martin]

Hi there, I know this is bad, but let's say I had to do it anyways...is this
correct:
Public Shared conn As New SqlConnection("user id=domain\username;
password=thispassword; initial catalog=dbname; data source=dbserver")



Thanks,
Derek

 

[Cor Ligthert]

Hi Derek,

The first is the most sended page in this newsgroup.
http://www.connectionstrings.com/

Although I find the second much nicer
http://www.able-consulting.com/ADO_Conn.htm

I hope this helps?

Cor

 

[Ken Tucker [MVP]]

Hi,

Neglecting the security issues the connection string is correct.

Ken
------------

 

[Herfried K. Wagner [MVP]]

Public Shared conn As New SqlConnection("user id=domain\username;
password=thispassword; initial catalog=dbname; data source=dbserver")

In addition to the other replies:

<URL:
Web interface:

<URL:http://msdn.microsoft.com/newsgroups/?dg=microsoft.public.dotnet.framework.adonet>

 

[Derek Martin]

Thank you all, that is what I have been doing but I keep getting this error:
Login failed for user 'username' also I am pretty sure that I have set this
up correctly inside the DB.

Username has these permission at the database level in SQL 2000:
DB Access = Permit
Roles:
public
db_owner
db_datareader
db_datawriter

What else am I missing??? Thank you!

Derek

 

[Derek Martin]

BTW - When I set the user id to the sa account, it works...hmmmmmmm

Thank you all, that is what I have been doing but I keep getting this error:
Login failed for user 'username' also I am pretty sure that I have set this
up correctly inside the DB.

Username has these permission at the database level in SQL 2000:
DB Access = Permit
Roles:
public
db_owner
db_datareader
db_datawriter

What else am I missing??? Thank you!

Derek

In addition to the other replies:

<URL:
Web interface:

<URL:http://msdn.microsoft.com/newsgroups/?dg=microsoft.public.dotnet.framew