Sybase ASE OLE DB Provider connection strings

Connects to

Sybase Adaptive

  • With Data Source .IDS file

    Provider=Sybase ASE OLE DB Provider;Data source=myASE;

    Note that you must create a Data Source .IDS file using the Sybase Data Administrator. These .IDS files resemble ODBC DSNs.

  • Adaptive Server Enterprise (ASE) alternative 1

    Provider=Sybase.ASEOLEDBProvider;Srvr=myASEserver,5000;Catalog=myDataBase;
    User Id
    =myUsername;Password=myPassword;

    Some reports on problem using the above one, try the following as an alternative.

  • Adaptive Server Enterprise (ASE) alternative 2

    Provider=Sybase.ASEOLEDBProvider;Server Name=myASEserver,5000;
    Initial Catalog
    =myDataBase;User Id=myUsername;Password=myPassword;

    Some other reports on problem using the above one, try the following as an alternative

  • Adaptive Server Enterprise (ASE) 12.5

    Provider=Sybase.ASEOLEDBProvider.2;Server Name=myASEserver;
    Server Port Address
    =5000;Initial Catalog=myDataBase;User ID=myUsername;
    Password
    =myPassword;

    This one works only from Open Client 12.5 where the server port number feature works, allowing fully qualified connection strings to be used without defining any .IDS Data Source files.

  • Adaptive Server Enterprise (ASE) 15.0

    Provider=ASEOLEDB;Data Source=myASEserver:5000;Catalog=myDataBase;
    User Id
    =myUsername;Password=myPassword;
  • Adaptive Server Enterprise (ASE) 15.0 alternative

    This one is included because of reported problems with using the "Catalog" key which was solved by using the 12.5 syntax key "Initial Catalog" instead.

    Provider=ASEOLEDB;Data Source=myASEserver:5000;Initial Catalog=myDataBase;
    User Id
    =myUsername;Password=myPassword;
Problems connecting?
Get answer in the Sybase Adaptive Q & A forum
OLE DB ProviderProvider=ASEOLEDBInfo and provider downloads

Articlesread all »

Providers

Connect

Articlesread all »

Didn't find your connection string?

Start over from the connection string reference index - or try a search!

In the Q&A forums you can ask your own question and let somebody help you.

The knowledge articles contains solutions and guides.