Connecting to SQL 2005 - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

Transact-SQL (2005)

Connecting to SQL 2005

Author

Topic

enak
Starting Member

34 Posts

Posted - 2007-04-11 : 11:12:23

I have inherited and ASP application that currently connects to an Access database. I need to connect it to an SQL 2005 database. I have tried a couple different connection strings but they don't work. Any clues???

This is the string that I am using:

ConnString = "Provider=SQLOLEDB;Data Source=DBServer;Initial Catalog=DBName;UserId=username;Password=userpassword;"

Again, this is not a .net application so I know that I need to use a different connection string.

Thanks,
enak

khtan
In (Som, Ni, Yak)

17689 Posts

Posted - 2007-04-11 : 11:14:53

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