Re: ODBC Version supporting specif databases?

[Bruce McAlister <bruce(dot)mcalister(at)blueface(dot)ie>]

Hi Luiz,

I have attached the trace.log and there seems to be an issue in 
SQLAllocHandle.c.

I tried to enable commlog and debug but i cant seem to find the files 
that they are meant to generate. Just to verify, do I add the following 
parameters to the dsn in odbc.ini?

Debug = 1
CommLog = 1

Thanks
Bruce

Luiz K. Matsumura wrote:
> Hi Bruce
>
> I guess that you need first enable Mylog and commlog and send both files 
> to the list.
> This will help to trace the source code for errors.
>
>
> Bruce McAlister wrote:
> > Hi All,
> >
> > Does anyone have any ideas/tips on how I could further debug this 
> > problem?
> >
> > Thanks
> > Bruce
> >
> > Bruce McAlister wrote:
> > > Hi All,
> > >
> > > I am having connection issues with the 08.03.0100 version of the ODBC 
> > > driver.
> > >
> > > What happens is that when I attempt to connect to an 8.2.6 PostgreSQL 
> > > database, using the 08.3.0100 ODBC driver then i get an error 
> > > connecting during authentication as follows:
> > >
> > > ------------------------------------------------------------------------- 
> > >
> > > [28000][unixODBC]Communication error during authentication;
> > > Error while reading from the socket.
> > > [ISQL]ERROR: Could not SQLConnect
> > > ------------------------------------------------------------------------- 
> > >
> > >
> > > However, if I use the 08.01.0200 version to connect to the same DSN, 
> > > I am able to successfully connect?
> > >
> > > Is there a specific version of the ODBC driver that supports a 
> > > specific version of the PostgreSQL database.
> > >
> > > The way the above two ODBC drivers were built are as follows:
> > >
> > > OS: Solaris 10 Update 3
> > > ODBC Manager : unixODBC v1.2.12
> > >
> > > I'm not too sure which version of the libpq library was used, but I 
> > > know for certain that Solaris 10 Update 3 comes with a Sun built 
> > > version of PostgreSQL 8.1, the one on the system I am trying to build 
> > > on is version 8.1.10.
> > >
> > > Am I doing something wrong or are the versions of the odbc driver 
> > > just not compatible with the versions of libpq that i am using to 
> > > build with, and thus, unable to connect to the database, or, is it 
> > > something completely different.
> > >
> > > If you need any additional info, please dont hesitate to ask.
> > >
> > > Thanks
> > > Bruce

--
+-------------------------------------------------------+
| Bruce McAlister                          Blueface Ltd |
| <bruce(dot)mcalister(at)blueface(dot)ie>  http://www.blueface.ie |
+-------------------------------------------------------+

[ODBC][7248][__handles.c][447]
		Exit:[SQL_SUCCESS]
			Environment = 8067ac0
[ODBC][7248][SQLAllocHandle.c][358]
		Entry:
			Handle Type = 2
			Input Handle = 8067ac0
[ODBC][7248][SQLAllocHandle.c][476]
		Exit:[SQL_SUCCESS]
			Output Handle = 80680e8
[ODBC][7248][SQLConnect.c][3586]
		Entry:            
			Connection = 80680e8            
			Server Name = [blueface-services][length = 17 (SQL_NTS)]            
			User Name = [NULL]            
			Authentication = [NULL]
		UNICODE Using encoding ASCII 'ISO8859-1' and UNICODE 'UCS-2LE'

[ODBC][7248][SQLAllocHandle.c][331]Error: SQL_INVALID_HANDLE
[ODBC][7248][SQLConnect.c][1570]Error: IM005
[ODBC][7248][SQLError.c][476]Error: SQL_INVALID_HANDLE
[ODBC][7248][SQLError.c][424]
		Entry:                
			Connection = 80680e8                
			SQLState = 8047a00                
			Native = 80479fc                
			Message Text = 8047a10                
			Buffer Length = 500                
			Text Len Ptr = 80479fa
[ODBC][7248][SQLError.c][461]
		Exit:[SQL_SUCCESS]                    
			SQLState = IM005                    
			Native = 80479fc -> 0                    
			Message Text = [[unixODBC][Driver Manager]Driver's SQLAllocHandle on SQL_HANDLE_DBC failed]
[ODBC][7248][SQLError.c][424]
		Entry:                
			Connection = 80680e8                
			SQLState = 8047a00                
			Native = 80479fc                
			Message Text = 8047a10                
			Buffer Length = 500                
			Text Len Ptr = 80479fa
[ODBC][7248][SQLError.c][461]
		Exit:[SQL_NO_DATA]
[ODBC][7248][SQLError.c][504]
		Entry:                
			Environment = 8067ac0                
			SQLState = 8047a00                
			Native = 80479fc                
			Message Text = 8047a10                
			Buffer Length = 500                
			Text Len Ptr = 80479fa
[ODBC][7248][SQLError.c][541]
		Exit:[SQL_NO_DATA]
[ODBC][7248][SQLFreeHandle.c][273]
		Entry:
			Handle Type = 2
			Input Handle = 80680e8
[ODBC][7248][SQLFreeHandle.c][188]Error: SQL_INVALID_HANDLE
[ODBC][7248][SQLFreeHandle.c][324]
		Exit:[SQL_SUCCESS]
[ODBC][7248][SQLFreeHandle.c][206]
		Entry:
			Handle Type = 1
			Input Handle = 8067ac0