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

 

[mirtheil]

Your code should be:
rs.open "select * from ArClient", conn
Either that or you'll need to tell ADO you are using adCmdDirect (rather than adCmdText).

Mirtheil
Certified Pervasive Developer
Certified Pervasive Technician

http://www.mirtheil.com

 

[sandyas]

I myself fixed the error. Anyway thanks for the help