Author |
Message |
Janus S. Andersen
Joined: 09 Jun 2010 Posts: 5 Country: Denmark |
|
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
|
|
Wed Jun 09, 2010 5:17 pm |
|
 |
SysOp
Site Admin
Joined: 26 Nov 2006 Posts: 7951
|
|
|
|
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;
|
|
Wed Jun 09, 2010 5:26 pm |
|
 |
Janus S. Andersen
Joined: 09 Jun 2010 Posts: 5 Country: Denmark |
|
|
|
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 *

|
|
Wed Jun 09, 2010 5:37 pm |
|
 |
SysOp
Site Admin
Joined: 26 Nov 2006 Posts: 7951
|
|
|
|
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/

|
|
Wed Jun 09, 2010 7:10 pm |
|
 |
Janus S. Andersen
Joined: 09 Jun 2010 Posts: 5 Country: Denmark |
|
|
|
The link is not working. I am missing the DSN that is true.
Pls. help me to make this.
|
|
Wed Jun 09, 2010 7:19 pm |
|
 |
SysOp
Site Admin
Joined: 26 Nov 2006 Posts: 7951
|
|
|
|
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.
|
|
Wed Jun 09, 2010 11:08 pm |
|
 |
Janus S. Andersen
Joined: 09 Jun 2010 Posts: 5 Country: Denmark |
|
|
|
Thanks this link is working fine.
I will try to install the software and give a feedback.
|
|
Thu Jun 10, 2010 3:46 am |
|
 |
Janus S. Andersen
Joined: 09 Jun 2010 Posts: 5 Country: Denmark |
|
|
Thu Jun 10, 2010 7:56 pm |
|
 |
|