Specifying ODBC driver for PostgresSQL

Hello,

In attempting to access data stored in a PGSql database we used the following code in a user event. The purpose of this was to test a connection between flexsim and the target database table.

dbusername("postgres","password");
dbopen("postgres","select * from testing",1,0);

int testvalue=dbgettablenum(1,1);
string val =dbgettablestr(1,2);
pf(testvalue);
pr();
pt(val);
pr();

Firstly, we had some trouble configuring the dbopen command as it has four parameters required and not three (as specified in the commands help file, so we just added a ,0 for the final argument). Once we sorted that out we obtained the following error;

Data source name not found and no default driver specified

postgres

Driver: [Microsoft][ODBC Driver Manager]
ODBC Code: IM002
Flexsim Code: 2 - SQLConnect

I should also mention we have specific ODBC drivers for PGSql installed (called psqlODBC_x64 as we are using a 64 bit machine).

Any help would be greatly appreciated.
Thanks

Did you define a user DSN then? Just installing the ODBC drivers is not enough, you have to create a user DSN and in your case it should be called "postgres" and point to the database.

Your User DSN also needs to be a 32-bit data source. If you're using a 64-bit version of Windows, then the Data Sources shortcut in the Control Panel only allows you to edit 64-bit data sources. You can edit 32-bit data sources by running the following program: C:\Windows\SysWOW64\odbcad32.exe. I made a shortcut to that program in my Start Menu so that I can get to it easily.