C/ODBC and Easysoft...

I have an asp site that communicates through an Easysoft ODBC-ODBC Bridge driver to the C/ODBC driver to Navsion 2.6. I receive the following intermittent error: 08004:1:1058:[Navision Software a/s][Navision Financials ODBC Driver] Data source rejected establishment of connection 01000:2:0:[Microsoft][ODBC Driver Manager] The driver doesn’t support the version of ODBC behavior that the application requested Any ideas what this error means and how I can research it? Thanks.

Did you set Easysoft to use multi-process? Note that this will use 1 database session per concurrent web user. http://www.easysoft.com/products/9999/faq_answer.phtml?ID=93&product=2002

Thanks for your reply. No I did not enable multiprocess because I don’t want to use one concurrent session per database user. I enabled connection pooling because I want many web users to have access and only take up one license.

It probably wants a 3.5 driver whereas C/ODBC is a 2.5 (more or less) driver.

I am using a 2.6 C/ODBC driver. Since the Navision application is 2.6, don’t I have to use the 2.6 C/ODBC driver or can I use a higher version C/ODBC driver?

Sorry, I don’t mean the version of Financials - I mean the ODBC specification version, which is at 3.5. C/ODBC complies to ODBC 2.5.

I checked the ‘About’ tab in the ODBC Data Source Administrator and all the versions are 3.5.

Set objRS = Server.CreateObject (“ADODB.RecordSet”) Is this connection string utilizing ADO or OLE DB?