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
------------

"Derek Martin" <dm*****@DONTSPAMMEokstateDOT.edu> wrote in message
news:eI*************@tk2msftngp13.phx.gbl:

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

--
Outgoing mail is certified Virus Free.
Checked by AVG Anti-Virus (http://www.grisoft.com).
Version: 7.0.230 / Virus Database: 263.3.0 - Release Date: 6/12/2004

[Herfried K. Wagner [MVP]]

* "Derek Martin" <dm*****@DONTSPAMMEokstateDOT.edu> scripsit:

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:news://news.microsoft.com/microsoft.public.dotnet.framework.adonet>

Web interface:

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

--
Herfried K. Wagner [MVP]
<URL:http://dotnet.mvps.org/>

[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
"Herfried K. Wagner [MVP]" <hi***************@gmx.at> wrote in message
news:2j************@uni-berlin.de...

* "Derek Martin" <dm*****@DONTSPAMMEokstateDOT.edu> scripsit:

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:news://news.microsoft.com/microsoft.public.dotnet.framework.adonet>

Web interface:

<URL:http://msdn.microsoft.com/newsgroups....dotnet.framew
ork.adonet>
--
Herfried K. Wagner [MVP]
<URL:http://dotnet.mvps.org/>

[Derek Martin]

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

"Derek Martin" <dm*****@DONTSPAMMEokstateDOT.edu> wrote in message
news:eR**************@TK2MSFTNGP12.phx.gbl...

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
"Herfried K. Wagner [MVP]" <hi***************@gmx.at> wrote in message
news:2j************@uni-berlin.de...

* "Derek Martin" <dm*****@DONTSPAMMEokstateDOT.edu> scripsit:

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:news://news.microsoft.com/microsoft.public.dotnet.framework.adonet>

Web interface:

<URL:http://msdn.microsoft.com/newsgroups....dotnet.framew ork.adonet>

--
Herfried K. Wagner [MVP]
<URL:http://dotnet.mvps.org/>