Linked server between SQL and PostgreSQL || Part 2 || Ms SQL

An ODBC driver uses the Open Database Connectivity (ODBC) interface by Microsoft that allows applications to access data in database management systems using SQL.

OLE DB (Object Linking and Embedding Database, sometimes written as OLEDB or OLE-DB)allows accessing data from a variety of sources in a uniform manner.

To download ODBC drivers for PostgreSQL click here

[geethikawijeratne]

This was very helpful. Thank you so much.

[PURVAMARGAJ-jb]

in my sql server the option of server type other data source is disable how to unable that option

[chitrangsharma]

Is there any way using dbLink that we can create clone of the table present in one database into another database ?
I'm really confused please help me with this
I want to make something like- I need to create two databases if we create table in one database then it should also be created into another database.
IS THAT ANYHOW POSSIBLE ?
Please I need help

[SoumyaGhosh-vmfj]

Unable to connect from PostgreSql to Sql Server with foreign Data wrapper. Error : could not translate host name "DEV-SAUMYAG-LG\SQL_2019" to address: Unknown host could not establish connection.

[allentertainmentin]

how to drop table of postgresql from linked server share command in sql server

[AJEETKUMAR-mexf]

I want to access data from sql server to postgresql, pls help

[obivolgaz]

Couldn't connect to server: connection timed out, is the server running on host and accepting.
Tcp/IP connections on port 5432, I am getting this error while creating link server, please suggest me brother.

[Vlogs]

can we create other rdbms data source linked servers(like oracle) through sql command instead of GUI.

[timnolan]

When I do the same steps (setting RPC also) "Data source name not found and no default driver specified". When I open ODBC, I can test the connection successfully. What am I missing here?

[anilkraman]

can we transfer data from sql server to Postgres with this method