Help on asp connection string

[jjones100]

Can someone tell me what the problem is with this connection string:
<%
Set adoCon = Server.CreateObject("ADODB.Connection")
adoCon.Open = "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" & Server.MapPath("Project.mdb")
Set rs=Server.CreateObject("ADODB.RecordSet")
rs.open "Tasks",adoCon,,adLockOptimistic,adCmdTable
%>

The table i am trying to update is called tasks in the project db. I keep getting the following error:

"ADODB.Recordset error '800a0bb9'
Arguments are of the wrong type, are out of acceptable range, or are in conflict with one another."

Any help would be appreciated. Thanks!

 

[gmmastros]

try removing the first equal sign from this line:

adoCon.Open [!]=[/!] "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" & Server.MapPath("Project.mdb")

When in doubt with connection strings, I always refer to:

http://www.connectionstrings.com

-George

Strong and bitter words indicate a weak cause. - Fortune cookie wisdom

 

[jjones100]

Thanks, but did not work. Same error message.

 

[Sheco]

Try adding the following for debugging purposes only:

<%
Set adoCon = Server.CreateObject("ADODB.Connection")
adoCon.Open = "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" & Server.MapPath("Project.mdb")
[red]
IF adoCon.State = 1 THEN
  Response.Write "<br>The ADO Connection is open<br>"
ELSE
  Response.Write "<br>The ADO Connection is closed<br>"
END IF
[/red]
Set rs=Server.CreateObject("ADODB.RecordSet")
rs.open "Tasks",adoCon,,adLockOptimistic,adCmdTable
%>

This should at least let you know if the connection is open.

 

[jjones100]

Thanks for suggestion. Connection shows to be open.

 

[DotNetGnat]

do you have adovbs.inc file included??

-DNG

 

[Sheco]

Oh good catch DNG, if not use 3 in place of adLockOptimistic and 2 in place of adCmdTable.

 

[Sheco]

You could also just see if this works:

<%
Set adoCon = Server.CreateObject("ADODB.Connection")
adoCon.Open = "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" & Server.MapPath("Project.mdb")
[red]
Set rs = adoCon.Execute("SELECT * FROM Tasks")[/red]
%>

 

[jjones100]

Thanks to everyone. Missing the adovbs.inc statement. Problem resolved.

 

[DotNetGnat]

no problem...glad to assist...

-DNG