SoftTree Technologies SoftTree Technologies
Technical Support Forums
RegisterSearchFAQMemberlistUsergroupsLog in
[SA 9.0.0152 Pro BETA] PostgreSQL Native settings

 
Reply to topic    SoftTree Technologies Forum Index » SQL Assistant View previous topic
View next topic
[SA 9.0.0152 Pro BETA] PostgreSQL Native settings
Author Message
elfounek



Joined: 29 Sep 2016
Posts: 4
Country: Czech Republic

Post [SA 9.0.0152 Pro BETA] PostgreSQL Native settings Reply with quote
When I choose PostgreSQL Native for DB connection, there is no information how to set Data provider (no valid information in popup).

Only when you click on Test you get error message. From that, I searched in that directory and I founded that right value is libpg.dll.
Thu Sep 29, 2016 6:30 am View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 6505

Post Reply with quote
Hi, just to be clear, there is no "data provider" property when you choose PG Native connection. And the libpq.dll is automatically filled in for the LIBPQ DLL field as the file location for the library Normally it should be entered without path because it's pre-installed with SQL Assistant. It knows where to find it. If should enter path to a different library only if there is a compatibility issue between the library version installed and the server version.


Data provider property is part of ADO.NET connectivity, and that is not a native connection.
Thu Sep 29, 2016 8:02 am View user's profile Send private message
elfounek



Joined: 29 Sep 2016
Posts: 4
Country: Czech Republic

Post Reply with quote
Sorry my fault, I mean "DSN / Driver" of course. And problem is that is not automatically filed.


Thu Sep 29, 2016 8:30 am View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 6505

Post Reply with quote
Thank for the screenshot. I was under impression that you are referring to the Connect to Database dialog.

You are correct, in the Options you need to enter it manually for every field. and field names have generic names because the same ones are used for all connectivity interfaces and driver types. It's quite different in the Connect to Database dialog. In the Connect to Database dialog most of that is filled in automatically and field names show different labels and prompts / hints for different connection method.

Hint: If in the Connect to Database dialog you tick Save connection data check-box, the connection setting will be saved to the Options. It's much easier and more transparent that way.
Thu Sep 29, 2016 9:32 am View user's profile Send private message
Display posts from previous:    
Reply to topic    SoftTree Technologies Forum Index » SQL Assistant All times are GMT - 4 Hours
Page 1 of 1

 
Jump to: 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


 

 

Powered by phpBB © 2001, 2005 phpBB Group
Design by Freestyle XL / Flowers Online.