|
 |
asp_web_howto thread: Access to SQL Server
Message #1 by Raman Verma <f741r@u...> on Tue, 28 Aug 2001 10:33:27 -0300
|
|
Hello
I had a web using MS Access and want to upgrade it to SQL Server. I
transferred all tables, etc over to SQL no problem, but am having a lot
trouble connecting to the database.
It keeps giving me an error that access is denied. Does anyone know what the
connection string should be like? Maybe an example of some sort?
Thanks
Raman
Message #2 by "Bailey, Mark" <MBailey@m...> on Tue, 28 Aug 2001 09:36:02 -0400
|
|
Dim CN
Set CN = Server.CreateObject("ADODB.Connection")
CN.ConnectionString = _
"Provider=SQLOLEDB;Data Source=YourServerName;Initial
Catalog=DatabaseName;User Name=sa;Password="
CN.Open
-----Original Message-----
From: Raman Verma [mailto:f741r@u...]
Sent: Tuesday, August 28, 2001 9:33 AM
To: ASP Web HowTo
Subject: [asp_web_howto] Access to SQL Server
Hello
I had a web using MS Access and want to upgrade it to SQL Server. I
transferred all tables, etc over to SQL no problem, but am having a lot
trouble connecting to the database.
It keeps giving me an error that access is denied. Does anyone know what the
connection string should be like? Maybe an example of some sort?
Thanks
Raman
|
|
|
View Cart
