Welcome to the new Schneider Electric Community

It's your place to connect with experts and peers, get continuous support, and share knowledge.

  • Explore the new navigation for even easier access to your community.
  • Bookmark and use our new, easy-to-remember address (community.se.com).
  • Get ready for more content and an improved experience.

Contact SchneiderCommunity.Support@se.com if you have any questions.

Close
Invite a Co-worker
Send a co-worker an invite to the Exchange portal.Just enter their email address and we’ll connect them to register. After joining, they will belong to the same company.
Send Invite Cancel
84611members
353910posts

[Imported] ASP.NET Connection String to ClearSCADA ODBC

EcoStruxure Geo SCADA Expert Forum

Find out how SCADA systems and networks, like EcoStruxure Geo SCADA Expert, help industrial organizations maintaining efficiency, processing data for smarter decision making with IoT, RTU and PLC devices.

Solved
sbeadle
Janeway Janeway
Janeway
0 Likes
1
531

[Imported] 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:

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

 


Accepted Solutions
sbeadle
Janeway Janeway
Janeway
0 Likes
0
530

Re: [Imported] ASP.NET Connection String to ClearSCADA ODBC

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

See Answer In Context

1 Reply 1
sbeadle
Janeway Janeway
Janeway
0 Likes
0
531

Re: [Imported] ASP.NET Connection String to ClearSCADA ODBC

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