HomeActive Query BuilderPostGre database / Cannot connect

PostGre database / Cannot connect


Hi Forum,

I tried to connect to a PostGre databaseand totally failed.
I am using the string HOST=localhost;PORT=5432;DATABASE=postgres;USER ID=postgres;PASSWORD=montag2000

on the PostGre SQL 8.4.

I am owning Version 1.12.4.219

Thanks,

Andreas
Andreas | email
August 5 2010, 08:31 AM
Hi Forum,

I tried to connect to a Firebird db and has issues.

When I execute the SQL buid for the sample DB (EMPLOYEE.FDB) with your tool

Select *
From "SALES" Inner Join
"CUSTOMER" On "CUSTOMER"."CUST_NO" = "SALES"."CUST_NO"

I dont get a result/ no records


I am owning Version 1.12.4.219

Thanks,

Andreas
Andreas | email
3 mins since original post
The same happens with MySQL

I see the tavles but I dont get fields i the QueryBuilder

Its MySQL 5.1

BTW Its Firebird 2.1
Andreas | email
14 mins since original post
Dear Andreas,

Please explain your problem with PostgreSQL database in detail. Please note that Active Query Builder does not create PostgreSQL connection, but utilizes already created connection.

For the Firebird database, please note that Active Query Builder does not execute SQL queries, so if you see that the generated SQL text is correct, than the rest is up to your database and connection.

For the MySQL Server, please let us know, on what platform your server is installed (Unix or Windows). This is important because table naming conventions are different for different platforms. Also please let us know, how you connect to your MySQL Server (using ODBC or native .net MySQL Connector).
Sergey Smagin | email
28 mins since original post
Also please make sure that you use specific syntax providers for different servers. You should not use the Universal syntax provider as it does not take into account specifics of various database server.
Sergey Smagin | email
32 mins since original post
This topic is closed