New in the Community? Get started here

Schneider Electric Exchange Community

Discuss and solve problems in energy management and automation. Join conversations and share insights on products and solutions. Co-innovate and collaborate with a global network of peers.

Register Now
Geo SCADA Expert Forum
Showing results for 
Search instead for 
Did you mean: 
Lt. Commander

[import] ASP.NET Connection String to ClearSCADA ODBC

>>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:



in TestODBC.aspx:



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!



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

The providerName should be System.Data.ODBC.


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"`