Problema cu replicarea inca nu am rezolvat-o :(
Ce am incercat acum ... sa utilizez un SGBD de PostgreSQL local pe acelasi server cu SQL 2005.
kitul vine atat cu ODBC provider cat si cu PgOleDB provider
Am vrut sa execut un sql simplu
select * from
opendatasource('PostgreSQL', 'Data Source=127.0.0.1:5432;User ID=sqlrepl;Password=sqlrepl').slave..tab1
dar am primit eroare ca acest provider PostgreSQL nu stie ThreadingMode = 'Both'
Dupa ce am modificat ThreadingMode = 'Both' in registrii pentru ca imi da urmatorea eroare.
Msg 7399, Level 16, State 1, Line 2
The OLE DB provider "PostgreSQL" for linked server "(null)" reported an error. The provider did not give any information about the error.
Msg 7304, Level 16, State 2, Line 2
Cannot connect using OLE DB provider "PostgreSQL" to linked server "(null)". Verify the connection parameters or login credentials associated with this linked server.
Daca stiti unde gresesc .... corectati-ma
Daniel.
MCP (C Sharp)
Software Engineer,
Cluj Napoca