Re: ODBC Version supporting specif databases?
От | Bruce McAlister |
---|---|
Тема | Re: ODBC Version supporting specif databases? |
Дата | |
Msg-id | 47C73CB5.3010806@blueface.ie обсуждение исходный текст |
Ответ на | Re: ODBC Version supporting specif databases? ("Luiz K. Matsumura" <luiz@planit.com.br>) |
Ответы |
Re: ODBC Version supporting specif databases?
|
Список | pgsql-odbc |
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.mcalister@blueface.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
В списке pgsql-odbc по дате отправления: