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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2000-11-27 : 00:05:23
|
Dave writes "I was wondering if you can tell me the way to connect to SQL Server database in ASP. I've been using MSAccess and had these lines in my ASP document
Const databaseDriver = "Microsoft Access Driver (*.mdb)"
Const databaseName = "cholesterol.mdb"
sData = "Driver=" & databaseDriver & "; DBQ=" & baseDirectory & databaseName & ";"
set objectConnection = server.createobject("ADODB.Connection")
objectConnection.Open sData
I was wondering if there is an easy way in which I can change these, so that I dont have to modify all the queries I've made throughout my document.
Thanks,
Dave" |
|
|
|
|
|
Connection in ASP