Thread: ODBC driver
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
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
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.
Did you add the --with-iodbc option ?
regards,
Hiroshi Inoue
http://w2422.nsk.ne.jp/~inoue/
> > You should then be able to connect, with the assumptions: > Your user name is "annissa." > The PG server is localhost. > I modified my odbc.ini, and odbcinst.ini, my odbctest still won't sho any DSN. And, I don't know which command I must useto connect to my new database, using my ODBC settings..And, I have one more question : musn't there be a line in the odbc.inito indicate the DSN? Thanks, -- Annissa, The computer slayer
Annissa Melhenas wrote: > > > > > You should then be able to connect, with the assumptions: > > Your user name is "annissa." > > The PG server is localhost. > > > I modified my odbc.ini, and odbcinst.ini, my odbctest still won't sho any DSN. And, I don't know which command I must useto connect to my new database, using my ODBC settings..And, I have one more question : musn't there be a line in the odbc.inito indicate the DSN? > > Thanks, If you used unixODBC, you should be able to see everything with the program "DataManager" Did you modify "odbc.ini" or "$HOME/.odbc.ini?"