Multiple-step OLE DB operation generated errors

Collapse
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • russ22
    New Member
    • Jun 2010
    • 2
    #1

    Multiple-step OLE DB operation generated errors

    Hi all,
    First time poster here so bear with me!
    Apologies if this has been asked before but I haven't come across a solution yet...

    I have a very simple java script code (not complete), just to test connection to an SQL server:

    Code:
    <%@LANGUAGE="JavaScript"%>
<HTML>
<BODY>
<%

var myConnect = "Provider=SQLOLEDB;Data Source=testserver;Initial Catalog=testDB;Integrated Security=yes";

var ConnectObj = new ActiveXObject("ADODB.Connection");

var RS = new ActiveXObject("ADODB.Recordset");

var sql = "SELECT value FROM tblMain;"; 

ConnectObj.Open (myConnect);

RS.Open(sql,ConnectObj,adOpenForwardOnly,adLockReadOnly,adCmdText);

Response.Write(RS("value"));

RS.Close();

ConnectObj.Close();

RS = null;

ConnectObj = null;
%>
</BODY>
</HTML>
    Which gives me the following error every time I execute it:

    Code:
    Error Type:
Provider (0x80040E21)
Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done.
/Dta/test.asp, line 14
    I have followed a few websites instructions but am no further to solving this problem. The database table in question does contain data with the right type of data, and I've checked out the registry 'fix' which was recommended and this already existed anyway within my registry.

    Any help would be greatfully appreciated! Thanks in advance
    Tags: None
    • russ22
      New Member
      • Jun 2010
      • 2
      #2
      Originally posted by russ22
      Hi all,
      First time poster here so bear with me!
      Apologies if this has been asked before but I haven't come across a solution yet...

      I have a very simple java script code (not complete), just to test connection to an SQL server:

      Code:
      <%@LANGUAGE="JavaScript"%>
<HTML>
<BODY>
<%

var myConnect = "Provider=SQLOLEDB;Data Source=testserver;Initial Catalog=testDB;Integrated Security=yes";

var ConnectObj = new ActiveXObject("ADODB.Connection");

var RS = new ActiveXObject("ADODB.Recordset");

var sql = "SELECT value FROM tblMain;"; 

ConnectObj.Open (myConnect);

RS.Open(sql,ConnectObj,adOpenForwardOnly,adLockReadOnly,adCmdText);

Response.Write(RS("value"));

RS.Close();

ConnectObj.Close();

RS = null;

ConnectObj = null;
%>
</BODY>
</HTML>
      Which gives me the following error every time I execute it:

      Code:
      Error Type:
Provider (0x80040E21)
Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done.
/Dta/test.asp, line 14
      I have followed a few websites instructions but am no further to solving this problem. The database table in question does contain data with the right type of data, and I've checked out the registry 'fix' which was recommended and this already existed anyway within my registry.

      Any help would be greatfully appreciated! Thanks in advance
      Update:
      I've tried to create the phrase to connect to the database with a UDL file.
      This results in the following:

      Code:
      Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=testDB;Data Source=testServer
      I read somewhere that Persist Secutiy Info is bad to declare, but in my original version I didn't do this.

      More confusion for a weekend incoming ! hehe :(

        Comment

        Previous template Next
        Working...