ASP.NET Connection String Provider Name

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

asa-9 connection-string

asked 22 Sep '16, 16:06

Jongee
217●17●17●22
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

flat view

Be the first one to answer this question!

toggle preview

community wiki:

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

learn more about Markdown

Question tags:

asa-9 ×107
connection-string ×9

question asked: 22 Sep '16, 16:06

question was seen: 2,372 times

last updated: 23 Sep '16, 08:54

SAP SQL Anywhere

ASP.NET Connection String Provider Name

Follow this question

Related questions