Remote SQL connection

Hi,
I'm attempting tocreate a connection string that will work for my hosted sql 2000 server in any environment.
I have a local copy of my hosted db that I develop on and it usesODBC:

 

I think it's generally a good idea to avoid DSN's all together. My connection string (which works from any server) looks like this:

Server=mssql02.discountasp.net</font>;Database=DB_1234</font>;User ID=DB_1234_user</font>;Password=P@ssw0rd</font>;Trusted_Connection=False

The red</font> text is what you will have to change for your SQL server account.

 

I agree with JerSchneid, DSN's are not recommended, we provide DSN functionality within the control panel for backward compatibility with older applications.

A DSNless connection is the prefered connection style.

Connection string examples: http://www.carlprothman.net/Default.aspx?tabid=81


Joel Thoms

DiscountASP.NET
http://www.DiscountASP.NET