How would I connect to a Sybase ASE 12.5 Server in a data transformation step in a DTS package (MS SQL Server 2000)? I am not sure of the driver to specify, etc.
Thanks.You must install sybase client package which included network communication files,odbc driver,oledb driver first.
Then you must create a database alias in dsedit same as client network configuration tools of SQL Server.Please remember the communication port of sybase is 4100.Test if it works well. see pic-1
Then,you need create an odbc connection in odbc manager.Please fill with the alias name which has been named in dsedit in server name input-box. see pic-2
And now,you can choose other connection using sybase odbc driver in DTS package designing. see pic-3|||Picture-1,2,3
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment