Re: ODBC driver - Mailing list pgsql-odbc

From mlw
Subject Re: ODBC driver
Date
Msg-id 3D233476.91DFEA3E@mohawksoft.com
Whole thread Raw
In response to ODBC driver  (Annissa Melhenas <melhenas@cogenit.fr>)
Responses Re: ODBC driver
List pgsql-odbc
First, don't use template1, create a new database for what you want to do. Try
"createdb ldap"

Second, make sure you "createuser" for the username under which you will be
connecting to the database, use your name for now.

in odbcinst.ini (likely in /etc or /usr/local/etc depending on how you
installed it.), describe the PostgreSQL driver, as:

[PostgreSQL]
Description             = PostgreSQL ODBC Driver by unixODBC
Driver          = /usr/local/lib/libodbcpsql.so
Setup           = /usr/local/lib/libodbcpsqlS.so

(substitute your path for what I used.)

Now, in your .odbc.ini file in your home directory,

[ldap]
Description             = PostgreSQL
Driver          = PostgreSQL
Trace           = No
TraceFile               =
Database                = ldap
Servername              = localhost
UserName                = annissa
Password                =
Port            = 5432
Protocol                = 6.4
ReadOnly                = No
RowVersioning           = No
ShowSystemTables                = No
ShowOidColumn           = No
FakeOidIndex            = No
ConnSettings            =


You should then be able to connect, with the assumptions:
Your user name is "annissa."
The PG server is localhost.


Annissa Melhenas wrote:
>
>                         Hi all,
> I installed openldap, postgres, and I wanted to link the two of them. So I re-confiured both using the with-odbc
option.then, I installed the ODBC package, firs the source, then as some things went wrong, i thought I had done
somethingwrong with installation, so I re-installed everything, with RPMs. 
> filled my odbc.ini file :
>
> ;
> ; odbc.ini
> ;
> [ODBC Data Sources]
> test=template1
>
> [test]
> Driver=/usr/lib/libpsqlodbc.so
> Description=Sample PostgreSQL DSN
> DSN=template1
> Servername=192.168.4.20
> username=postgresql
> password=secret
> Database=PostgreSQL
> Readonly=No
> ;Servertype=postgres
> Port=5432
> FetchBufferSize=99
> ;ServerOptions=
> ;ConnectOptions=
> ;Options=
> ;Readonly=no
> ;Trace=1
>
> [Default]
> Driver=/usr/lib/libpsqlodbc.so
>
> [ODBC]
> InstallDir= /usr/lib/libiodbc.so
>
> and I checked the libpsqlodbc.so and libiodbc.so existed, and were in the good path.
> When I first launched an ldconfig after my installation, I had a error message
> saying there one of the libpsqlodbc lib, libpsqlodbc.so.0 (I had three :
> libpsqlodbc.so, libpsqlodbc.so.0, and libpsqlodbc.so.0.27), was not a symbolic
> link. so, I turned libpsqlodbc.so and ibpsqlodbc.so.0 into symbolic links to now point to libpsqlodbc.so.0.27.
>
> After all that, I launched an odbctest, but, when I do that, I have no DSN available in the array, though I added one
inthe odbc.ini.. 
>
> Is there something I forgot to do?
>
> Thanks for your help,
>
> --
> Annissa,
> The computer slayer
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster



pgsql-odbc by date:

Previous
From: Annissa Melhenas
Date:
Subject: ODBC driver
Next
From: Hiroshi Inoue
Date:
Subject: Re: ODBC driver