I get the following error on my connection code:



ADODB.Recordset error '800a0e7d' 



I can't figure out why it is giving me this error.  Could someone help me?



Here's the code.



<%



dim objConn, rs

dim strConnect, strRS



	Set objConn = Server.CreateObject("ADODB.Connection") 

	

	strConnect = "Provider=SQLOLEDB;Data 

Source=online.scs.wsu.edu;UID=sa;PWD=recycler;DATABASE=level1_week3;DATABAS

E=Certification"

	objConn.open strConnect

	

	

	set rs=server.CreateObject("ADODB.Recordset")

	strRS="select * from employee"

	rs.CursorLocation=adUseServer

	rs.CursorType= adOpenKeyset

	rs.LockType = adLockOptimistic

	rs.Open strRS

	



%>



Thank you...



Derek

Get your connection string fixed up:

http://www.able-consulting.com/ADO_Conn.htm#OLEDBProviderForSQLServer



You are using the wrong parameter names.



Cheers

Ken

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

----- Original Message -----

From: <dap_1911@h...>

To: "ASP Database Setup" <asp_database_setup@p...>

Sent: Saturday, July 21, 2001 1:25 AM

Subject: [asp_database_setup] ADODB.Recordset error '800a0e7d'





: I get the following error on my connection code:

:

: ADODB.Recordset error '800a0e7d'

:

: I can't figure out why it is giving me this error.  Could someone help me?

:

: Here's the code.

:

: <%

:

: dim objConn, rs

: dim strConnect, strRS

:

: Set objConn = Server.CreateObject("ADODB.Connection")

:

: strConnect = "Provider=SQLOLEDB;Data

:

Source=online.scs.wsu.edu;UID=sa;PWD=recycler;DATABASE=level1_week3;DATABAS

: E=Certification"