Results 1 to 3 of 3
  1. #1
    Join Date
    Mar 2005
    Posts
    1

    Unanswered: Connect to Sybase in a DTS Package

    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.

  2. #2
    Join Date
    Jan 2004
    Location
    Shanghai,China
    Posts
    76
    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

  3. #3
    Join Date
    Jan 2004
    Location
    Shanghai,China
    Posts
    76
    Picture-1,2,3
    Attached Thumbnails Attached Thumbnails 1.gif   2.gif   3.gif  

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •