From: | Heiko Klein <Heiko(dot)Klein(at)met(dot)no> |
---|---|
To: | mark <mark(at)marklonsdale(dot)co(dot)uk> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: ODBC problem |
Date: | 2002-03-22 12:04:56 |
Message-ID: | 15515.7656.32252.424431@polar.oslo.dnmi.no |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hi,
last week, I had similar problems. First I couldn't get jdbc running
correctly with staroffice (I haven't found anybody who could), then I
didn't manage to connect anyhow with iodbc and then I had problems with
the postgres odbc driver in and unix-odbc.
But at the end (after two days), taking the unix-odbc driver included
with unix-odbc, I got a stable connection :-) to my pg7.2 server. And
even staroffice worked with it together.
Heiko
odbc.ini:
[Emep]
Description = Test to Postgres
Driver = PostgreSQL
Trace = Yes
TraceFile = /tmp/sql.log
Database = emep
Servername = localhost
UserName =
Password =
Port = 5432
Protocol = 7.2
ReadOnly = No
RowVersioning = No
ShowSystemTables = No
ShowOidColumn = No
FakeOidIndex = No
ConnSettings =
odbcinst.ini:
[PostgreSQL]
Description = PGSQL 7.2
Driver = /usr/emep/lib/libodbcpsql.so
Setup = /usr/emep/lib/libodbcpsqlS.so
FileUsage = 1
Debug = 0
mark writes:
>
>
>
> Hi
>
> Please help... Im trying to connect to postgresql via ODBC using the
> iodbc driver manager. As part of that package theres a odbctest
> program that can be ran, however it appears to be failing. Im kind of
> stumped as to where to go next as the error isn't too usefull.
>
> The error I am getting in the iodbc tracefile is..
>
> SQLDriverConnect( ... )
> SQL_NO_DATA_FOUND
>
> odbctest just exits with no usefull information..
>
> When I run odbctest I connect to it using the connect string :
> DSN=Postgres and It seems to be finding my odbc.ini file okay. My
> odbc.ini file looks like
>
> ;
> ; odbc.ini
> ;
> [ODBC Data Sources]
> Postgres = Postgres
>
> [Postgres]
> Driver = /usr/local/pgsql/lib/libpsqlodbc.so.0
> Host = localhost
> Database = marksdb
> TraceFile = /tmp/odbc.trace
> Trace = 1
>
> Im pretty new to this so its almost certainly an education problem. Is
> there any better documentation on ODBC installation/configuration at all
> for postgresql
>
> Mark
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
> (send "unregister YourEmailAddressHere" to majordomo(at)postgresql(dot)org)
From | Date | Subject | |
---|---|---|---|
Next Message | Luis Alberto Amigo Navarro | 2002-03-22 12:18:55 | Re: Huge Performance Difference on Similar Query in Pg7.2 |
Previous Message | Heiko Klein | 2002-03-22 11:58:14 | Re: Huge Performance Difference on Similar Query in Pg7.2 |