Advantage OLE DB Provider connection strings

Connects to

Sybase Advantage

  • Remote Server

    Provider=Advantage OLE DB Provider;User ID=adssys;
    Data Source
    =MyDataDictionaryPath;Advantage Server Type=ADS_REMOTE_SERVER;

    The value "Advantage.OLEDB.1" is also applicable for the provider key, the result will be the same.

  • Local Server

    Provider=Advantage OLE DB Provider;User ID=adssys;
    Data Source
    =MyDataDictionaryPath;Advantage Server Type=ADS_LOCAL_SERVER;
  • Using FoxPro tables

    Provider=Advantage OLE DB Provider;User ID=adssys;
    Data Source
    =MyDataDictionaryPath;TableType=ADS_CDX;
    Advantage Server Type
    =ADS_LOCAL_SERVER;

    If not specifying the TableType value the default value of "ADS_ADT" will be used.

  • Show deleted records

    Provider=Advantage OLE DB Provider;User ID=adssys;
    Data Source
    =MyDataDictionaryPath;TableType=ADS_CDX;ShowDeleted=TRUE;
    Advantage Server Type
    =ADS_LOCAL_SERVER;

    Please note that the ShowDeleted option is only available with FoxPro tables, ie TableType="ADS_CDX".

  • Using OEM characters in tables

    Provider=Advantage OLE DB Provider;User ID=adssys;
    Data Source
    =MyDataDictionaryPath;Advantage Server Type=ADS_REMOTE_SERVER;
    CharType
    =ADS_OEM;

    If not specifying the CharType value the default value of "ADS_ANSI" will be used.

  • Ignoring rights

    Provider=Advantage OLE DB Provider;User ID=adssys;
    Data Source
    =MyDataDictionaryPath;Advantage Server Type=ADS_REMOTE_SERVER;
    SecurityMode
    =ADS_IGNORERIGHTS;

    If not specifying the SecurityMode value the default value of "ADS_CHECKRIGHTS" will be used.

Problems connecting?
Get answer in the Sybase Advantage Q & A forum
OLE DB ProviderProvider=Advantage OLE DB ProviderInfo 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.