Is there a way to connect PostGreSql without ODBC definitions

[Rajesh Karunakaran]

Hi,

Is there a way to connect to PostgresSql directly using a connection string?

Sql servers, we connect something similar to

lCnStr  = "Driver={SQL Server};Server=localhost\mssqlexp;Database=TestDb;Uid=sa;Pwd=sa11111;'
lStatus = SQLSTRINGCONNECT(lCnStr)

Is there a similar way for PostgresSql ?
This is a local connection, ie the application and PostgresSql database are in same pc.

Thanks
Rajesh

 

[Rajesh Karunakaran]

Hi,

I got it using

lCnStr = 'Driver={PostgreSQL ANSI};Server=localhost;Port=5432;Database=TestDb;Uid=uuuuuuu;Pwd=ppppp;'
? SQLSTRINGCONNECT(lCnStr)

I had installed the ODBC driver also.

Thanks
Rajesh

 

[Mike Lewis]

Rajesh,

For future reference, you (and others) might find this useful:

https://www.connectionstrings.com/

It gives connection strings for around 60 database servers.

Mike

__________________________________
Mike Lewis (Edinburgh, Scotland)

Visual FoxPro articles, tips and downloads

 

[Rajesh Karunakaran]

Thank you very much Mike.

In fact, I know about that. I took the connection string from there only. But, somehow it failed to function at my first trials but then I got it working.

Rajesh

 

[Gerrit Broekhuis]

Hi Rajesh,

With “localhost” it will only work on your own pc. Don’t forget to change this if you’re using a server with a central database.

Regards, Gerrit

 

[Rajesh Karunakaran]

Hi Gerrit,

Yes, I know.
But, thank you so much for your time and suggestion.

Rajesh