Velocity Reviews - Computer Hardware Reviews

Velocity Reviews > Newsgroups > Programming > ASP .Net > ASP General > connect string ASP / SQL EXPRESS

Reply
Thread Tools

connect string ASP / SQL EXPRESS

 
 
shank
Guest
Posts: n/a
 
      07-11-2009
What's the correct connect string for ASP classic and SQL Express installed
on the same web server? The web host has a control panel that generates the
below string. But I get this error:

Multiple-step OLE DB operation generated errors. Check each OLE DB status
value, if available. No work was done.
/teststate.asp, line 7 ... which is ... conn.open ConStr


<%
Dim ConStr
ConStr = "Data Source=(local)\sqlexpress;Network Library=;Connection
Timeout=15;Packet Size=4096;Integrated Security=no;User ID=sth;Encrypt=no;"

set conn = CreateObject("ADODB.Connection")
conn.open ConStr
sql = "SELECT DISTINCT Abbrev, State FROM States ORDER BY State"
%>

thanks


 
Reply With Quote
 
 
 
Reply

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
connect to SQL Server DB from VWD express Mike ASP .Net 0 07-09-2010 06:37 AM
Connect to remote db with SQL Mgt Express 2008 helveticus ASP .Net 1 04-29-2010 07:33 AM
Impossible to connect to SQL Server 2005 Express Gabriel ASP .Net 9 03-12-2007 01:25 PM
Deploying VWD Express App to IIS using SQL Express w/ Membership i =?Utf-8?B?Q2FybCBNLg==?= ASP .Net 4 08-07-2006 12:04 PM
Visual Web Developer 2005 Express and SQL 2005 Express Jake Henderson ASP .Net Web Services 0 03-10-2006 10:18 PM



Advertisments