Connection String problem

I am having problems getting my connection stirng to work in my .net projects. For all of my older asp projects the connection string...

"Server=Adelphi.xxx.com/prod-sql"

works okay but it fails in .net. I am wondering if the /prod-sql needs to be seperated out somehow?

Does anyone have any idea how this is handled in vb.net? I am using the web.config to specify my connection string.

Thanks

I assume you are using a trusted connection. Try this:

"server=adelphi.xxx.com\prod-sql;Trusted_Connection=yes;Database=?;"

HTH,
Ryan

|||

Create a new text document and rename it whatever.udl

Choose your provider, connection properties and test the connection and clickOK.

Open your UDL in notepad and you'll have your connection string.

[oledb]
; Everything after this line is an OLE DB initstring
Provider=SQLOLEDB.1;Persist Security Info=False;User ID=user;Initial Catalog= prod-sql;DataSource= Adelphi.xxx.com

Hope this helps.

|||Thanks, got it!!|||

zoopnfunk wrote:

Thanks, got it!!

As a future reference, a nice site all about connection strings isConnectionStrings.com.