PostgreSQL ODBC connection

Hi Folks,

I am using PostgreSQL( for the first time ) as an database ,i have set up an DSN connection .

I am trying to connect to the db by the following code


treenode current = ownerobject(c);
dbusername("postgres","password");
dbopen("kartik","output",0);



---------------------------
ODBC Error
---------------------------
Data source name not found and no default driver specified.

Driver: [Microsoft][ODBC SQL Server Driver]
ODBC Code:IM002
Flexsim Code: 2 - SQL - Connect
---------------------------
OK
---------------------------


Any ideas on how to avoid this error/popup to occur?

Thanks in advance!

Do you have the correct driver for PostgreSQL to set up your DSN or are you using the SQL Server one?

Hi Michael,
yes i have installed the correct driver for postgreSQL , No i am not using the SQL server driver.

I reckon that while using postgreSQL :

(a) dbusername() - we use this to connect to the database ( by giving the username ans password) .

(b) dbopen() - opens the database and accesses the tables

I have created an DSN , Do we require an additional query to access the PostgreSQL server ? ( which in turn uses dbusername and dbopen to access the databases present in the server)

For example : While Using Microsoft Access database

string ODBCname = "AccessFlexsimDB";

Cheers and Regards,

In the code above 'kartik' is your DSN. Is that what you have set up?

You put 0 for tablemode, yet entered "output" for the SQL statement, which isn't valid SQL. Is that a tablename?

Hi Jason,

Yes you are absolutely right,

Kartik = DSN setup
Output = Table name.

Thanks a ton for the quick reply .