Postgres Pro
Downloads
Home   >   mailing lists

postgresql ODBC - Mailing list pgsql-odbc

From allan d. go
Subject postgresql ODBC
Date
Msg-id 000e01c13a53$2acc1940$8a0dd5d2@tip.edu.ph
Whole thread Raw
List pgsql-odbc
Tree view
greetings,
 
i compiled postgresql 7.1.2 with odbc option
 
i created .odbc.ini on /home/pgsql    <--- directory of my postgres user
 
.odbc.ini                               
 
[ODBC Data Source]
Driver=/usr/lib/libpsqlodbc.so
Database=db1
Servername=localhost  <---- should i put the IP address?
Port=5432
 
i installed psqlODBC and setup on my Win OS
 
Datasource=postgresql
Database=db1
Server=10.2.1.1  <----- ip address of my postgresql box
post=5432
 
and i tried to connect via Visual Basic 6.0
 
VB6 Connection
 
DNS=postgresql
UID=postgres
DATABASE=db1
 
i'm having "ODBC Database Open Failed, Check connect Info" error
 
how can i check if i properly installed pgsql ODBC on my linux box?
 
i know my postgresql is working, cause i can retrieve data via PHP program on my Win OS
 
____________
 
another one, i copied the postgresql script of rpm to my compiled box and issued this command to start postgres
 
  echo -n "Starting postgresql service: "
  su -l postgres -c 'nohup postmaster -D /home/pgsql/data </dev/null >>server.log 2>&1 </dev/null &'
  sleep 1
  pid='pidof postmaster'
  if [$pid]
  then
    ...
    create pid file for postgres
    ....
  else
     echo failed
  fi   
 
  i can't start postgresql using this script
  but i can when i issue "nohup postmaster -D /home/pgsql/data </dev/null >>server.log 2>&1 </dev/null &'"
  on bash prompt using postgres user.
 
  something wrong with my script file?
 
 
just wondering...
 
        ^_^x
 

pgsql-odbc by date:

Previous
From: "Tamara D. Blum"
Date:
Subject: Sequence query
Next
From: Douglas Bates
Date:
Subject: Installation of pgAdmin