[unixODBC-support] Error while connecting through Postgres driverbuilt on Solaris Sparc 64 bit

Abhishek Srivastava abhishek_srivastava at persistent.co.in
Mon Sep 3 10:18:08 BST 2007

I can connect to postgres server through postgres ODBC driver that comes
with unixODBC.
When I try connecting through Postgre ODBC driver 8.2.4 built on solaris
Sparc -64, there is some connection request going to server, that I can read
from console output of server:
Here is the output on console of Postgres db:
bash-3.00$ DEBUG:  forked new backend, pid=15856 socket=7

LOG:  connection received: host= port=34774
LOG:  incomplete startup packet
DEBUG:  proc_exit(0)
DEBUG:  shmem_exit(0)
DEBUG:  exit(0)
DEBUG:  reaping dead processes
DEBUG:  server process (PID 15856) exited with exit code 0
I read somewhere that there was similar issue with DB2 and there was some
fix done in unixODBC, here is the snip from changelog:
* Allow decoupling of SQLHANDLES between application and driver, there is 
          a 64bit DB2 where the driver handles are int's but unixODBC uses
void *.
          There is a define for DRV_SQLHANDLE in
DriverManager/drivermanager.h that
          allows this choice at build time
I guess similar thing needs to be done here too..

I will try dlopen anyway and let u know.


-----Original Message-----
From: unixodbc-support-bounces at easysoft.com
[mailto:unixodbc-support-bounces at easysoft.com] On Behalf Of Nick Gorham
Sent: Monday, September 03, 2007 1:38 PM
To: Support for the unixODBC project
Subject: Re: [unixODBC-support] Error while connecting through Postgres
driverbuilt on Solaris Sparc 64 bit

Abhishek Srivastava wrote:

>I am using unixODBC-2.2.12 driver manager and built a postgres 8.02.0400
>psql odbc driver with 64 bit on Solaris Sparc. When I try connecting to
>database on the same machine, I get the following error:
>[IM005][unixODBC][Driver Manager]Driver's SQLAllocHandle on SQL_HANDLE_DBC
>I appreciate any help or pointer on this. 

Try using dlopen and see if you can open the driver lib and call the 
SQLAllocHandle entry point.

Nick Gorham
Easysoft Limited
http://www.easysoft.com, http://www.unixODBC.org

unixODBC-support mailing list
unixODBC-support at easysoft.com

This e-mail may contain privileged and confidential information which is the property of Persistent Systems Pvt. Ltd. It is intended only for the use of the individual or entity to which it is addressed. If you are not the intended recipient, you are not authorized to read, retain, copy, print, distribute or use this message. If you have received this communication in error, please notify the sender and delete all copies of this message. Persistent Systems Pvt. Ltd. does not accept any liability for virus infected mails.

More information about the unixODBC-support mailing list