Hi, did you get an answer on this? We have a Pervasive Database at work and I would like to be able to access it from ColdFusion. Now, I don't know how to create a DSN at the Coldfusion Administrator or how to access it without the DSN, just the database.
Hi, did you get an answer on this? We have a Pervasive Database at work and I would like to be able to access it from ColdFusion. Now, I don't know how to create a DSN at the Coldfusion Administrator or how to access it without the DSN, just the database.
I found a solution: I linked an Access database to the pervasive one. By doing this, I can query that access DB, which is only an image of the pervasive one.
I found out that my client's Timberline vendor is working on the same process. I was giving information on scheduling a Data Transfermation Service in MS SQL.
He did recommend updating Sage's ODBC driver to 9.02.55.20 if you have not do so.