Connection String to Postgre

[martingaleh]

I'm using Access 2010 64 bit
I need help in the connection string to my database. First I did this

Dim connector As ADODB.Connection
    Dim rst As ADODB.Recordset
    
    Set connector = New ADODB.Connection
    connector.Open CurrentDb.TableDefs("MyInternetTable").Connect

But what's good for the table isn't good for VBA and I got datasource name not found even though the linked table found it

Then I tried this:

"ODBC;DRIVER={PostgreSQL35W} etc"

Because of this:

Which of course didn't work even though that thing is on every tab of the data source. Then I tried this:



and did this:

connector.Open "ODBC;DSN={PostGre};

But, I just don't get these connection strings. I dont' know what features are enabled by making these connection strings so difficult to work. I'd appreciate any help available. Thanks

[ssanfu]

There is a site about connection strings:
The Connection Strings Reference
http://www.connectionstrings.com/

Specific to postgresql: http://www.connectionstrings.com/postgresql/


Have fun reading...

[martingaleh]

Oh yeah, and http://www.connectionstrings.com/postgresql/
Doesn't work. Still have the same error. This is what I used out of that site:
connector.Open "Driver={PostgreSQL UNICODE};Server= etc.

[martingaleh]

I tried to make a passthrough Query to steal its connection string. The Pass through query works and I'm able to send a command to my server. Then I stole the connection string like so:

And put it into my code:

Dim connector As ADODB.Connection
    Dim rst As ADODB.Recordset
    
    Set connector = New ADODB.Connection
    connector.Open "ODBC;DSN=PostgreSQL35W;DATABASE=ama

But lo and behold, still doesnt' work because the datasource name not found even though the linked table found it. I don't know what the right solution is, but if the measures I've taken still dont' work, this access program is not a very good one to bet your career on.