I want to create a linked server to Informix through OLEDB.
I tried to use sp_addlinkedserver but with wanted parameters
name!!!
Bellow settings are my odbc connection that can help you to advise me ,how
to setup parameter to values
working odbc
Servername=bronz
Host Name=192.168.19.184
service=bronz
protocol=onsoctcp
database name=development
userid=user
password=pass
client locale=cs_CZ.852
database locale = cs.CZ.852
thanksTarvirdi wrote:
> I want to create a linked server to Informix through OLEDB.
> I tried to use sp_addlinkedserver but with wanted parameters
> name!!!
> Bellow settings are my odbc connection that can help you to advise me ,how
> to setup parameter to values
> working odbc
> Servername=bronz
> Host Name=192.168.19.184
> service=bronz
> protocol=onsoctcp
> database name=development
> userid=user
> password=pass
> client locale=cs_CZ.852
> database locale = cs.CZ.852
Haven't tried a linked server, but we did install Informix drivers on
SQL Server and then utilized a DTS package to regularly pull data from
an Informix source into SQL Server so we could operate on that data.
Maybe that would meet your needs?
gorf
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment