Connection strings for Sybase

ODBC
  • 复制到剪贴板Standard Sybase System 12 (or 12.5) Enterprise Open Client
    Driver={SYBASE ASE ODBC Driver};Srvr=Aron1;Uid=username;Pwd=password;
  • 复制到剪贴板Standard Sybase System 11
    Driver={SYBASE SYSTEM 11};Srvr=Aron1;Uid=username;Pwd=password;
  • 复制到剪贴板Intersolv 3.10
    Driver={INTERSOLV 3.10 32-BIT Sybase};Srvr=Aron1;Uid=username; Pwd=password;
  • 复制到剪贴板Sybase SQL Anywhere (former Watcom SQL ODBC driver)
    ODBC; Driver=Sybase SQL Anywhere 5.0; DefaultDir=c:\dbfolder\;Dbf=c:\mydatabase.db; Uid=username;Pwd=password;Dsn=""
OLEDB
  • 复制到剪贴板Adaptive Server Anywhere (ASA)
    Provider=ASAProv;Data source=myASA
  • 复制到剪贴板Adaptive Server Enterprise (ASE) with Data Source .IDS file
    Provider=Sybase ASE OLE DB Provider; Data source=myASE
    说明:必须先用Data Administrator创建Data Source .IDS file
  • 复制到剪贴板Adaptive Server Enterprise (ASE)
    Provider=Sybase.ASEOLEDBProvider;Srvr=myASEserver,5000;Catalog=myDBname;
    User Id=username;Password=password

©2009 vhalpha#163.com 鲁ICP备09080449号