OLE DB Error

[sandyas]

I am trying to connect to Pervasive SQL where I have all the tables. My code is

set conn = server.createobject("adodb.connection")
set rs = Server.CreateObject("ADODB.recordset")
ConnectionString = "DRIVER={Pervasive ODBC Client Interface};ServerDSN=Quantum;ServerName=ntserver;dbq=Quantum"
conn.open ConnectionString
rs.open "ArClient", conn
while not rs.EOF
For each item in rs.Fields
Response.Write item.Value & "<br>"
next
rs.MoveNext
wend
rs.close
set rs = nothing
Conn.close
Set conn = nothing

I get the following error when I try to open the table:
Microsoft OLE DB Provider for ODBC Drivers (0x80040E14)
[Pervasive][ODBC Client Interface][LNA][Pervasive][ODBC Engine Interface]Syntax Error: ArClien<< ??? >>t


Any help appreciated. Thanks

 

[macleod1021]

Change
rs.open "ArClient", conn

To:

rs.open "ArClient", conn,,,adCmdTable

And that should get ya runnin