Database Connection Error

werD420 · January 19th, 2005, 06:51 PM

Newb in trouble!
I would like for this page to display certain fields of my access database but seem to be stuck!
I receive the following error whrn trying to connect to my database
ADODB.Recordset error '800a0e7d'

The connection cannot be used to perform this operation. It is either closed or invalid in this context.

[path]/asp/dbman/search1.asp, line 8

Any help would be appreciated

Code:

<%@Language = "VbScript"%>
<%
dim objConn,objRec 
set objConn=Server.CreateObject("ADODB.Connection")
objConn.Provider="Microsoft.Jet.OLEDB.4.0"
objConn.Open "[path]//asp/temp/toast/data/cap.mdb"
 Set objRec = Server.CreateObject ("ADODB.Recordset")  
 objRec.Open "member"

  While NOT objRec.EOF 
  Response.Write objRec("ID") & ", " 
  Response.Write objRec("Fname") & ", " 
  Response.Write objRec("LName") & ", " 
  Response.Write objRec("Uname") & "<BR>" 
  objRec.MoveNext 
  Wend 
  %>
  <HTML>
  <HEAD>
  </HEAD>
  <Body>
  </Body>
  </HTML>

Thanks

rajanikrishna · January 19th, 2005, 09:02 PM

Hi,

Invalid arguments in the recordset open

Set objRec = Server.CreateObject ("ADODB.Recordset")
objRec.Open "member",objConn

-----------
Rajani

werD420 · January 20th, 2005, 12:20 PM

Thanks a bunch i am able to get into the script now but im receivinq an SQL error
Microsoft JET Database Engine error '80040e14'

Invalid SQL statement; expected 'DELETE', 'INSERT', 'PROCEDURE', 'SELECT', or 'UPDATE'.

Thoughts?

ChrisScott · January 20th, 2005, 12:24 PM

Try setting the options parameter to adCmdTable...

Code:

objRec.Open "member", objConn, , , adCmdTable

HTH,

Chris

werD420 · January 20th, 2005, 12:27 PM

Thanks for a quick response
I tried inputting this string but receive the same error thought?

ChrisScott · January 20th, 2005, 12:36 PM

Have you referenced the ado constants in your page?

werD420 · January 20th, 2005, 12:46 PM

Oops I had not but now that I have I get the following error
Microsoft JET Database Engine error '80040e14'

Syntax error in FROM clause.

[path]/Hot Topic.asp, line 14

The database was made from a comma delimited text document it is only a test database it was converted with access 2002

werD420 · January 20th, 2005, 01:14 PM

OK I created a new database with access but i am still getting this error
Microsoft JET Database Engine error '80040e14'

Syntax error in FROM clause.

[path]/Hot Topic.asp, line 14
here is my code line 14(objRec.Open "Hot%20topic",objConn, , , adCmdTable) seems to be the trouble?

Code:

<HTML>
  <HEAD>
  </HEAD>
  <Body>
  
<%@Language = "VbScript"%>

<%
dim objConn,objRec 
set objConn=Server.CreateObject("ADODB.Connection")
objConn.Provider="Microsoft.Jet.OLEDB.4.0"
objConn.Open "[path]/hot topics.mdb"
 Set objRec = Server.CreateObject ("ADODB.Recordset")  
 objRec.Open "Hot%20topic",objConn, , , adCmdTable
  While NOT objRec.EOF 
  Response.Write objRec("ID") & ", " 
  Response.Write objRec("Date") & ", " 
  Response.Write objRec("Control") & ", " 
  Response.Write objRec("Company") & ", " 
  Response.Write objRec("Comments") & "<BR>" 
  objRec.MoveNext 
  Wend 
  %>
  </Body>
  </HTML>

ChrisScott · January 20th, 2005, 01:20 PM

Do you have a table in your database called "Hot%20topic"?

werD420 · January 20th, 2005, 01:28 PM

Yes it is called Hot Topic but when I leave out the %20 it says no query or table found named "Hot"
I assumed I spelled a field wrong but they are all correct!

Thoughts