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="" />=

asked 22 Sep '16, 16:06

Jongee's gravatar image

accept rate: 0%


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.

(23 Sep '16, 08:54) Chris Keating
Be the first one to answer this question!
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here



Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Question tags:


question asked: 22 Sep '16, 16:06

question was seen: 604 times

last updated: 23 Sep '16, 08:54