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-09-07 : 00:18:23
|
Imran writes "Hii
I have my website database in MS. Access and now i wanna switch to SQL so i have made the database in the SQL server but i dont know how to connect the database using a DSN LESS connection using a virtual directory ( the server.mappath) to my ASP . I have downloaded the connecttion code but i dont understand some things like :
' -- Create a Connection Object
Set Conn = Server.CreateObject("ADODB.Connection")
' -- Build the connection string
ConnectionString = "DRIVER=SQL Server;SERVER=MyServer;CATALOG=MyDatabase;UID=MyUser;PWD=MyPassword"
' -- Open the connection
Conn.Open ConnectionString
What should i put in the place of th SERVER ; CATALOG & what is the UID & PWD...
can u help me send a connection for my database called DATA.mdf & my site name is www.bomb-ed.com
I would be higly obliged if u mail this to me as soon as possible...
Bye
IMRAN" |
|
|
|
|
|
SQL Database Connections for ASP