postgresql

[tinnitus]

Hello,

i have installed  LABSQL i can connect to the local .mdb base exemple using ODBC. 

Now, i would like to establish a connection to a postgre 8.4.5 database without using ODBC

i have posgreSQL driver 8.4.200   

i tried using this string and others variations without success

Provider=MSDASQL.1;
Extended Properties="DRIVER={PostgreSQL ANSI};
SERVER=aaaa.bbb.bbb.fr;
UID=name;                                                                      /////   name = schema
PWD=pass;
READONLY=0;
DATABASE=DIDB"

how can i add the 5432 port ? PORT=5432 ?

Regards

Tinnitus

[AdnanZ]

Is there a reason you don't want to use ODBC? How else are you planning to talk to the database? OLE DB?

[tinnitus]

Hello,

I tried to use odbc to acces a postgre database

opening connexion to database seems to be OK but i encounter an error wanting to open a table.

Someone has an idea ?

 Regards

Tinnitus

[John_M]

There's a postgresql odbc driver that I've used with great success

[RavensFan]

The function that is throwing the error looks like it wants to execute a query called "test", but you are trying to open a table.  ??

[Rodéric]

Hi tinnitus,

Are you using the NI database toolkit? 

Because the NI database toolkit works with PostGreSQL, if so, you can PM me and I'll send you an example program

Regards,

[Dennis_Knutson]

Why are you responding to a year old thread?