Which connection string should I use if I use SqlConnection?

[VA_er]

Sybase Adaptive connection strings - ConnectionStrings.com


It is Adaptive Server Enterprise, so I guess I can only go with Sybase ASE OLE DB Provider or Adaptive Server Enterprise ODBC driver, if I am going to use SqlConnection con = new SqlConnection ("Connection String"), then which one should I use? Or it does not matter?

Thanks.

Edit: How should I know if my workplace computer/database comes with OLE DB providers? For ODBC, I can find the database under Control Panel > ODBC Data Source Administrator

2nd Edit: If I try OLE DB connection string, then it returns "Keyword not supported: Provider"; if I try ODBC connection string, it returns "Keyword not support: Driver".






Continue reading...