Re: Snapshots - Mailing list pgsql-odbc

eter Eisentraut wrote:

>Rodrigo Carvalhaes wrote:
>
>
>>I tried to use with my application (developed in C++) the three
>>avaliable snapshots but no one worked... I tried because the last
>>stable version of the odbc driver have one bug concerning text
>>fields.
>>
>>There are so much changes? It shouldn't work or it's really unstable?
>>
>>
>
>We might be able to answer that if you told us what exact problem you
>are having.
>
>
>
Hi Peter!

Thanks for your promplty answer (and congratulations for your job!!!)
I am using ODBC with a commercial application (ERP software developed in
c++). It's strange what is happening .

Environment:
Conectiva Linux version 10
kernel 2.6.9
PostgreSQL 7.4.6 (compiled from the sources)

My steps:
1. Compiled unixodbc 2.2.10 from the sources without gui (as my server
don't have X)
2. Compiled psqlodbc_07.03.0200 from the source with the configure option:

/configure --prefix=/usr/local/psqlodbc_07.03.0200/ --with-unixodbc
-–with-odbcinst=/usr/local/etc/

3. Configured the odbc files as follow:

root@carbono/usr/local/etc> cat odbcinst.ini

[PostgreSQL]

Description = PostgreSQL driver for Linux & Win32

Trace = Yes

TraceFile = /tmp/sql.log

Driver = /usr/local/psqlodbc_07.03.0200/lib/psqlodbc.so

Setup = /usr/local/lib/libodbcpsqlS.so

UsageCount = 2

CommLog = 1


root@carbono/usr/local/etc> cat odbc.ini

[dadosadv]

Description = Microsiga

Driver = PostgreSQL

Trace = Yes

TraceFile = /tmp/sql.log

Database = dadosadv

Servername = localhost

UserName = postgres

Password =

Port = 5432

Protocol = 6.4

ReadOnly = No

RowVersioning = No

ShowSystemTables = No

ShowOidColumn = No

FakeOidIndex = No

ConnSettings =


root@carbono/usr/local/etc> cat /root/.odbc.ini

[dadosadv]

Description = Microsiga

Driver = PostgreSQL

Trace = Yes

TraceFile = /tmp/sql.log

Database = dadosadv

Servername = localhost

UserName = postgres

Password =

Port = 5432

Protocol = 6.4

ReadOnly = No

RowVersioning = No

ShowSystemTables = No

ShowOidColumn = No

FakeOidIndex = No

ConnSettings =



4. I had the symbolik link below ( I don't know why!!!) to the
application recocnize the ODBC:
ln -s /usr/local/psqlodbc_07.03.0200/lib/libpsqlodbc.so ->
/usr/lib/libodbcpsql.so

After this, everything was fine, working without problems. When I made
the same steps with any of the versions on the snapshot (3 avaliable)
the application don't recocnize the ODBC and I don't get any log, I only
receive error messages on the application "no connection".

Any idea? How can I "debug" what is happening? I don't have too much
experience with ODBC...

My problem in use the version 07.03.0200 it's that I am always having
problems with the type "text" and my pg log is always receiving error
messages ERROR: unrecognized configuration parameter "ksqo" due the
statements sent by the ODBC " set ksqo to on"


Cheers,

Rodrigo Carvalhaes