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

Jongee
217171722
accept rate: 0%

2

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

By RSS:

Answers

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:

×108
×10

question asked: 22 Sep '16, 16:06

question was seen: 2,533 times

last updated: 23 Sep '16, 08:54