[Imported] ASP.NET Connection String to ClearSCADA ODBC

[sbeadle]

>>Message imported from previous forum - Category:ClearSCADA Software<<
User: nminchin, originally posted: 2019-01-15 06:14:26 Id:348
Hi, I'm trying to configure a connection to ClearSCADA via ASP.NET to execute a query to display info on a local intranet webpage, but I can't get the connection string formed correctly. I'm not sure that I'm using the right provider name?

Currently I have:

in Web.Config:

```html

```

in TestODBC.aspx:
```ASP

body { background-color: IndianRed; }

South Australia - All Site Logs (View only)

```

The error I get is:
`[ArgumentException: Unable to find the requested .NET Framework Data Provider. It may not be installed.]`

I'm not really sure where to go to from here... any help is very welcome!

Nick

[sbeadle · Accepted solution]

>>Responses imported from previous forum

Reply From User: nminchin, posted: 2019-01-15 06:35:00
Worked it out.

The providerName should be System.Data.ODBC.

E.g.
``

Also there was an error in the aspx file:

` DataSourceID="SqlDataSource1" Font-Size="Smaller" ForeColor="#333333" DataKeyNames="EntryNumber" EnableModelValidation="True"`

should be:
` DataSourceID="SqlDataSource1" Font-Size="Smaller" ForeColor="#333333" DataKeyNames="FullName" EnableModelValidation="True"`

Also, I changed the connection string away from using a DSN as I don't like relying on DSNs to be created:
`connectionString="DRIVER=ClearSCADA Driver;SERVER=Net"`