ASP.NET Connection String Provider Name

[Former Member]

I am trying to connect my ASP.NET (C#) Webpage to my ASA database and I need to enter a prodiverName in my web.config file and I am not sure what to enter.

This is what I have so far,

<add name="PSCRM" connectionString="Driver=Adaptive Server Anywhere 9.0;ENG=prospect;UID=usr;PWD=password;DBN=prospect;LINKS=TCPIP(HOST=HOST=servername:49157);" providerName="" />=

[chris_keating]

What connectivity technology are you planning to use to establish the connection? It appears that you have ODBC because you have DRIVER. The providerName should be the .NET data driver. If you intend to use ODBC, it should be System.Data.Odbc but it you intend to use the SQL Anywhere .NET driver, it should be the assembly name for the driver i.e., iAnywhere.Data.SQLAnywhere or Sap.Data.SQLAnywhere (plus the framework version that the application is to use). The value will be what is stored in the Global Assembly Cache.