Error Code ADO: 0x80004005 for postgressql

[Former Member]

I want a crystal reports 2011 (which is put on the windows 2008), connect to a database that postrgerssql on linux,

I put psqlodbc_09_02_0100-x64.zip from here http://www.postgresql.org/ftp/odbc/versions/msi/

to connect via OLE DB.

Later in start-up, administration, data source, ODBC, DSN user added

Driver PostgreSQL Unicode (x64) namely

Data Source-172.30.1.103

Database-erp

Server-172.30.1.103

Username-olap

Description-172.30.1.103

SSL Mode-allow

port-5432

password-12345

All the best test - connection successful

Next go to the crystall reports

I shook ctrl + N, to create a new connection, database, OLE DB (ADO), Microsoft OLE DB Provider for ODBC Drivers,

ODBC DSN: 172.130.1.103, then, login-olap, pass-12345, database erp, to complete, but

I get an error -

Failed to log into the system. Details: Error Code ADO: 0x80004005

Source: Microsoft OLE DB Provider for ODBC Drivers

Description: [Microsoft] [Driver Manager ODBC] In this DSN driver architecture

Applications do not match each other.

State of the SQL: IM014

Tell me what to do?

How to connect to the database?

[former_member11696 · Accepted solution]

First, don't use OLE DB to ODBC connector. No reason too, all you are doing is putting another DB Client layer on top of ODBC.

Second issue is CR is a 32 bit application so as the error indicates you need to use a 32 bit Client.

Don

[Former Member · Accepted solution]

I uninstall psqlodbc_09_02_0100-x64.zip

and install psqlodbc_09_02_0100.zip

but i no see

In the administration, data source ODBC, no DSN user

PostgreSQL driver (((

In crystal reports i press ctrl + N, create new connection, ODBC, enter connection string, next,

server - 172.130.1.103, login-olap, pass-12345, finish, but

I get an error - Unknow Database Conector Error.

Our company bought a crystal reports license.

Help me pliz.

[former_member11696 · Accepted solution]

Then if you don't see the driver you are using the 64 bit ODBC Administrator.

Go to c:\windows\syswow64\odbcad32.exe and run it, see if you see the driver listed now.

Or post to PostGre forums to assist getting a 32 bit driver running.

Don

[Former Member · Accepted solution]

I install psqlodbc_09_01_0100-1.zip

and i connect DB.

thanks Don Williams