Microsoft VBScript runtime error '800a01b6' 
Author Message
 Microsoft VBScript runtime error '800a01b6'

Hi,

If any can help I will be grateful. I am getting the following error;

"Microsoft VBScript runtime error '800a01b6'

Object doesn't support this property or method: 'DbObj.Open'

/wroxproasp/nwind.asp, line 12"

Well, that's the error message I get when I try to connect to my test SQL
server from my client. The server is running IIS4 with the latest MDAC pack,
latest ASPs, latest Frontpage server extensions, etc.. It's begining to bug
me so any help would be appreciated.

My *.ASP VBScript code is below.

Thanks in advance,

Janek.

<html>

<head>
<title>Results</title>
</head>

<body bgcolor="yellow">
<%
SQL = "SELECT * FROM CUSTOMERS;"
SET DbObj = Server.CreateObject ("ADODB.Connection")
DbObj.Open = "DSN=NORTHWIND;UID=;PWD=;"
SET oRs =DBObj.Execute(SQL)
%>

<p>Customers</p>

<table BORDER="1">
<% WHILE NOT oRs.EOF %>
  <tr>
    <td><% =oRs.Fields("CUSTOMERID").Value %>
</td>
    <td><% =oRs.Fields("COMPANYNAME").Value %>
</td>
    <td><% =oRs.Fields("CONTACTNAME").Value %>
</td>
    <td><% = oRs.Fields("ADDRESS").Vallue %>
</td>
  </tr>
<% oRs.MoveNext %>
<% WEND %>
</table>
</body>
</html>



Mon, 05 Feb 2001 03:00:00 GMT  
 
 [ 1 post ] 

 Relevant Pages 

1. Microsoft VBScript runtime error '800a01b6'

2. Microsoft VBScript runtime error '800a01b6'

3. Runtime error ''800a01b6''

4. Microsoft VBScript runtime error '800a000d'

5. Microsoft VBScript runtime error '800a0007'

6. Microsoft VBScript runtime error '800a0e7d'

7. Microsoft VBScript runtime error '800a01a8'

8. Microsoft VBScript runtime error '800a000d'

9. Microsoft VBScript runtime error '800a01a8'

10. Microsoft VBScript runtime error '800a01a8'

11. Microsoft VBScript runtime error '800a000d'

12. Microsoft VBScript runtime error '800a0046'

 

 
Powered by phpBB® Forum Software