connection string to sql 2005

Dear,

I am trying to connect from a vb.net application (VS 2005) to a sql server 2005 database located remotely,
what is the connection string that I should use?
I used the same one that I was using for connecting to sql 2000 but it is not working.
Thanks.

you can refer to http://www.connectionstrings.com/|||

Hi Goodway,

Could you show us your connection string?

|||

Hi,

Here is an example.

If use windows authentication

Data Source=ServerName\InstanceName;Initial Catalog=DatabaseName;Integrated Security=True

If use SQL authentication

Data Source=ServerName\InstanceName;Initial Catalog=DatabaseName;User Id=username;Password=password

HTH. If this does not answer your question, please feel free to mark the post as Not Answered and reply. Thank you!