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.
| Author |
Topic |
|
erick
Starting Member
2 Posts |
 Posted - 2007-05-14 : 16:44:29
|
| I want to know if it is possible to connect from classic ASP to a SQL 2005 database, and if so, can someone provide a sample connection string, I'm not sure if it is my connection string or server config. Thanks, Ed. |
|
|
sshelper
Posting Yak Master
216 Posts |
|
|
erick
Starting Member
2 Posts |
Posted - 2007-05-22 : 17:00:15
|
| I have tried those connection strings without any luck, has anyone out there actually connected to SQL 2005 via a classic ASP web page? Is it even possible? |
 |
|
|
toast31
Starting Member
3 Posts |
Posted - 2007-05-22 : 17:35:53
|
| yes, we use classic asp and sql 2005. The connection string looks like this...<%dim conn, SQLStringQWERTYSet conn = Server.CreateObject("ADODB.Connection")conn.Open("Provider=SQLOLEDB; Data Source=xxx.xxx.x.x,xxxxx; Initial Catalog=testdb; " & "User Id=xxxx; Password=xxxx;") Dim day_no day_no = 300%>xxxx's are representing proprietary information... |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2007-05-23 : 02:50:16
|
| "Is it even possible?"I'm a bit worried that you think it wouldn't be possible!If you have a connection string to SQL 2000 in your Classic ASP application that should work, unchanged, with SQL 2005 (albeit that you may have to change the Data Source of course!)Kristen |
|
|
|
pootle_flump
1064 Posts |
Posted - 2007-05-23 : 07:48:38
|
| You are using ado right? |
|
|
|
|
|
|
ASP classic and SQL 2005?