CODEWITHSUNDEEP
iisodbcdsnpervasivepervasive-sql
Saranraj Palanisamy
Saranraj Palanisamy

Reputation: 36

How to connect pervasive sql Database and Web Site using DSN

I am having an application that is running on IIS with Enabled 32 bit Application. In a remote server(connection available in local machine),i have installed Pervasive SQL. I have installed Pervasive SQL Driver in local machine and trying to connect the database "TestApplication" in Pervasive SQL.

For that I have created System DSN "DSNTEST", and tried with Windows Application.Its working fine.

But i couldnt connect to the database from Web Site.

An error occured "Error: ERROR [IM014] [Microsoft][ODBC Driver Manager] The specified DSN contains an architecture mismatch between the Driver and Application".

Can anyone please help me to resolve this?

Thanks in advance.

Upvotes: 0

Views: 877

Answers (1)

mirtheil
mirtheil

Reputation: 9192

It sounds like the ASP.NET application is trying to run as a 64 bit application. Because you're using PSQL v11, you can install the 64 bit ODBC driver which is part of the PSQL v11 64 bit client install (at http://www.pervasive.com/database/Home/Products/PSQLv11.aspx).
The other option is to make sure that the ASP.NET project is built with a target of x86 rather than x64 or AnyCPU.

Upvotes: 0

Related Questions