Help to connect a PostGress database

Hi
I have a PostGres database and use it in pgAdmin III 1.10. I am trying to add me SQL Assistant to this program. I can connect to my PostGres database in the pgAdmin but the SQL Assistant connect can`t connect to my database.

The error is
"
5433
Connect: ODBC Error (0): SQLDriverConnect
Client: Client:
Server: Server:
[Micros [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified

;Serve ;Server=dkcphsqlfg03;Port=5433;Database=jordweb_test
jordwe jordweb_test;Uid=jordweb_test;Pwd=************;Connect_timeout=10;

OK
"
I have also tryed all the ADO.NET provideres but it is not working. Pls. help my out here

Best Regaards
Janus S. Andersen

It looks like the connect string contains extra characters. Is that just in the post or in the connection settings too

;Serve ;Server=dkcphsqlfg03;Port=5433;Database=jordweb_test
jordwe jordweb_test;Uid=jordweb_test;Pwd=************;Connect_timeout=10;

It was in the post. Sorry.

My connecting string is like
;
Server=dkcphsqlfg03;
Port=5433;
Database=jordweb_test
jordweb_test;
Uid=jordweb_test;
Pwd=*;

I just change the Password to *

It seems that you are missing DSN/Driver name, should be set to "Driver={PostgreSQL ANSI}" Of course the ODBC driver should be available on your system. In case you don't already have it, you can get a copy here http://psqlodbc.projects.postgresql.org/

The link is not working. I am missing the DSN that is true.

Pls. help me to make this.

Which link is not working? Did you mean the download link for Postgres ODBC driver? If you need that specific link, you can try this one https://www.enterprisedb.com/getfile.jsp?fileid=1190

Also, if you have a working ODBC connection and it appears in ODBC administrator tool, you can select it in DSN/Driver drop-down, instead of the driver name. That should work too.

Thanks this link is working fine.

I will try to install the software and give a feedback.

Hi
I tryed downloading the software from your URL but it was not working for me. I fund this URL http://www.postgresql.org/ftp/odbc/versions/msi/ with the software I needet and I am useing this.

Thanks for all your help.

Take care.