• Advantage .NET Data Provider

    • Standard remote connection

      Data Source=\\myserver\myvolume\mypat\mydd.add;User ID=myUsername;
      Password
      =myPassword;ServerType=REMOTE;

      The value 2 can also be used instead of REMOTE

      Sybase Advantage
    • Local connection

      Data Source=\\myserver\myvolume\mypat\mydd.add;User ID=myUsername;
      Password
      =myPassword;ServerType=LOCAL;

      The value 1 can also be used instead of REMOTE

      Sybase Advantage
    • AIS connection

      Data Source=\\myserver\myvolume\mypat\mydd.add;User ID=myUsername;
      Password
      =myPassword;ServerType=AIS;

      The value 4 can also be used instead of REMOTE

      Note that ServerType values can be summed, for instance a value of 3 would mean the combination of LOCAL | REMOTE. The value can also be set to the full string, for instance, LOCAL|REMOTE instead of a numeric 3.

      Sybase Advantage
    • Separating the path and catalog parameters

      Data Source=\\myserver\myvolume\mypat;Initial Catalog=mydd.add;
      User ID
      =myUsername;Password=myPassword;ServerType=REMOTE;
      Sybase Advantage
    • Specifying port

      Data Source=\\myserver:9999\myvolume\mypat\mydd.add;User ID=myUsername;
      Password
      =myPassword;ServerType=REMOTE;
      Sybase Advantage
    • Read only connection

      Data Source=\\myserver\myvolume\mypat\mydd.add;User ID=myUsername;
      Password
      =myPassword;ServerType=REMOTE;ReadOnly=TRUE;
      Sybase Advantage
    • Trim spaces from string data

      Fields of type String will have trailing white spaced trimmed on retrieval.

      Data Source=\\myserver\myvolume\mypat\mydd.add;User ID=myUsername;
      Password
      =myPassword;ServerType=REMOTE;TrimTrailingSpaces=TRUE;

      If FALSE is specified, then trailing white space is maintained on the values when they are retrieved. This means that a fixed length String field with a width of 10, for example, will always return 10 characters when the value is retrieved; it is padded with as many spaces as necessary.

      Sybase Advantage
    • Network protocol

      Data Source=\\myserver\myvolume\mypat\mydd.add;User ID=myUsername;
      Password
      =myPassword;ServerType=REMOTE;CommType=UDP_IP;

      Valid CommType values are; TCP_IP, UDP_IP and IPX

      Sybase Advantage
    • Compression

      Data Source=\\myserver\myvolume\mypat\mydd.add;User ID=myUsername;
      Password
      =myPassword;ServerType=REMOTE;Compression=ALWAYS;

      If ServerType is set to LOCAL, the Compression property is ignored.

      Valid values are ALWAYS, INTERNET, NEVER

      Bear in mind that if compression is turned off on the server no compression will take place no matter this client setting.

      Sybase Advantage
    • User count per connection disregarding client computer

      Default behaviour for counting number of users on the server is per computer connecting. This connection string overrides that behaviour making each connection count as a user even if made from the same computer.

      Data Source=\\myserver\myvolume\mypat\mydd.add;User ID=myUsername;
      Password
      =myPassword;ServerType=REMOTE;IncrementUserCount=True;

      Default value for IncrementUserCount is False

      Sybase Advantage
    • Share DBF tables to other applications

      This is used to share DBF tables in a writable mode with other (non-Advantage) database applications.

      Data Source=\\myserver\myvolume\mypat\mydd.add;User ID=myUsername;
      Password
      =myPassword;ServerType=REMOTE;LockMode=COMPATIBLE;

      Applicable to CDX and NTX TableTypes

      Default value (that will lock tables) is PROPRIETARY

      Sybase Advantage
    • Show deleted records

      Data Source=\\myserver\myvolume\mypat\mydd.add;User ID=myUsername;
      Password
      =myPassword;ServerType=REMOTE;ShowDeleted=True;

      Applicable to CDX and NTX TableTypes

      Sybase Advantage
    • Dont increment user count for stored procedure

      Data Source=\\myserver\myvolume\mypat\mydd.add;User ID=myUsername;
      Password
      =myPassword;ServerType=REMOTE;StoredProcedureConnection=True;

      Default value is false, meaning that the stored procedure will increment the server user count, preventing connections when user count reaches its maximum.

      Sybase Advantage
    • Disable connection pooling

      Data Source=\\myserver\myvolume\mypat\mydd.add;User ID=myUsername;
      Password
      =myPassword;ServerType=REMOTE;Pooling=False;

      Default values for pooling is true, with the options Min Pool Size=0, Max Pool Size=100, Connection Lifetime=0 (in seconds, 0 meaning it will never recycle)

      Sybase Advantage

    Problems connecting?   Get answer in the Sybase Advantage Q & A forum →

  • Advantage OLE DB Provider

    • 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.

      Sybase Advantage
    • Local Server

      Provider=Advantage OLE DB Provider;User ID=adssys;
      Data Source
      =MyDataDictionaryPath;Advantage Server Type=ADS_LOCAL_SERVER;
      Sybase Advantage
    • 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.

      Sybase Advantage
    • 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".

      Sybase Advantage
    • 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.

      Sybase Advantage
    • 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.

      Sybase Advantage
  • .NET Framework Data Provider for OLE DB

    • Use an OLE DB provider from .NET

      Provider=any oledb provider's name;OledbKey1=someValue;OledbKey2=someValue;

      See the respective OLEDB provider's connection strings options. The .net OleDbConnection will just pass on the connection string to the specified OLEDB provider. Read more here.

  • Advantage ODBC Driver

  • .NET Framework Data Provider for ODBC

    • Use an ODBC driver from .NET

      Driver={any odbc driver's name};OdbcKey1=someValue;OdbcKey2=someValue;

      See the respective ODBC driver's connection strings options. The .net OdbcConnection will just pass on the connection string to the specified ODBC driver. Read more here.

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.