1

I am using ODBC to connect to my remote postgresql. I am trying to connect to PG.VSAM database using isql. But it is connecting with default postgres database.

I ran below command -

isql PG.VSAM

it connected to the database but when I ran below query -

select current_database(); it gives 'postgres' as output

Any suggestion how can I connect to PG.VSAM in isql.

gaurav panwar
  • 21
  • 3

1 Answers1

0

You need to specify it in the odbc.ini file. Check http://docs.adaptivecomputing.com/mwm/7-0/Content/topics/databases/odbc (point #4).

and the try using: isql -v <connection string>.

Dharman
  • 30,962
  • 25
  • 85
  • 135
Coder
  • 1,415
  • 2
  • 23
  • 49