Hi,

I have a visual basic application and the access to postgress is very slow.

If I run the query on PGadminII the answer is quite good but if I run the same query from the application it takes a long time (I debugged it). 11seconds .vs. 5 minutes.

I would like to know if I have a problem with my connection to postgres or my odbc.

The string connection is:

 

gobjBD.StringConexion = "Provider=MSDataShape.1;DRIVER={PostgreSQL};DATABASE=mydatabase;
SERVER=192.9.200.5;PORT=5432;UID=postgres;PWD="

 

I´ll really apreciate your help.

Thanks

Cecilia