I keep getting this error when trying to connect to my Pervasive 7 

database using a DSN connection string or a DSN-less connection string 

("Driver={Pervasive Software ODBC-

32};DDFPATH=e:\pluswin\data\phgcom;DATAPATH=e:\pluswin\data\phgcom").  I 

have the newest Mdac installed (2.6) as well as the pervasive odbc client 

on the server.  Is there something I'm missing?  Here is my code:



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

  dsn = "Driver={Pervasive Software ODBC-

32};DDFPATH=e:\pluswin\data\phgcom;DATAPATH=e:\pluswin\data\phgcom"

  conn.Open dsn 'IT BARFS ON THIS LINE



    ' Queries the database for data

    Sql = "SELECT ICILOC.ITEMNO, ICILOC.LOCATION FROM ICILOC GROUP BY 

ICILOC.ITEMNO, ICILOC.LOCATION"

    Set rs = conn.Execute(Sql)



This is the post I already read, but with no results:



Did you even look on the manufacturer's website?!?

I found this in less than 20 seconds:



http://support.pervasive.com/eSupport/publisher.asp?id=c9f74fa5-f938-11d4-

b2

26-00508b5d6b61&resource=&number=0&isExternal=0



Cheers

Ken



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

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

From: "Mohd J. Alam" <alam@s...>

To: "ASP Web HowTo" <asp_web_howto@p...>

Sent: Thursday, June 07, 2001 3:21 AM

Subject: [asp_web_howto] How to connect to Pervasive SQL 7.0 -( Connection

String)





: Hello Everyone,

:

: I am trying to connect to a Pervasive SQL 7 database from my ASP pages. I

: created a DSN for the database. And try to use the following connection

: string to connect to it:

: StrConn = "DSN=PSQL;UID=MASTER;PWD=password"

:

:

: Is there a special connection string for Pervasive SQL Database?

:

: Any help would be appreciate?