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
84248members
353348posts

Link to an ODBC Table created using the Microsoft Access Text Driver

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
MiBarr
Cadet
3
2516

Link to an ODBC Table created using the Microsoft Access Text Driver

I am trying to link an ODBC Table to Geo SCADA using the Server Configuration Tool, but I am having issues using the correct connection string for the Microsoft Access Text Driver. (This is to import a .csv into Geo SCADA).

 

I have tried multiple connection strings without any luck. This is the latest format I used:

Driver=Microsoft Access Text Driver (*.txt, *.csv);Dbq=c:\txtFilesFolder\; Extensions=asc,csv,tab,txt;

 

 

What is the correct format for the connection string for this particular ODBC driver?

Tags (2)

Accepted Solutions
sbeadle
Janeway Janeway
Janeway
0 Likes
0
2503

Re: Link to an ODBC Table created using the Microsoft Access Text Driver

For clarification (because the 'ODBC Driver' can mean 3 things!

a) The ability to connect an ODBC client application (like Excel, VB, ...) to read and write data

b) The ability to link external database tables within the Geo SCADA database so that client displays and (warning) Logic can read/write from those external tables

c) The ability to read data from an external table and bring it in as point values/times/quality. (As if it was a device). 

This latter facility is what you might consider. No 'danger' of locking the database. Search the Help for 'odbc driver guide Introduction to the ODBC Driver'

 

See Answer In Context

3 Replies 3
BevanWeiss
Spock
Spock
0 Likes
0
2506

Re: Link to an ODBC Table created using the Microsoft Access Text Driver

Is there a reason that you can't just use the ODBC Driver?

As has been raised several times in the past week on the forum here, you will be setting yourself up for terrible ClearSCADA / GeoSCADA Expert performance if you use a Linked ODBC Table in your Logic.

 

I think this link suggests you will need to jump through a bunch more hoops to use the Access Driver

https://docs.microsoft.com/en-us/office/troubleshoot/access/cannot-use-odbc-or-oledb

 

Perhaps the plain Microsoft ODBC Text Driver would work better?

https://docs.microsoft.com/en-us/sql/odbc/microsoft/text-file-driver-programming-considerations?view...


Lead Control Systems Engineer for Alliance Automation (VIC).
All opinions are my own and do not represent the opinions or policies of my employer, or of my cat..
sbeadle
Janeway Janeway
Janeway
0 Likes
0
2504

Re: Link to an ODBC Table created using the Microsoft Access Text Driver

For clarification (because the 'ODBC Driver' can mean 3 things!

a) The ability to connect an ODBC client application (like Excel, VB, ...) to read and write data

b) The ability to link external database tables within the Geo SCADA database so that client displays and (warning) Logic can read/write from those external tables

c) The ability to read data from an external table and bring it in as point values/times/quality. (As if it was a device). 

This latter facility is what you might consider. No 'danger' of locking the database. Search the Help for 'odbc driver guide Introduction to the ODBC Driver'

 

MiBarr
Cadet
0 Likes
0
2498

Re: Link to an ODBC Table created using the Microsoft Access Text Driver

Thank you!

 

I have set up a system DSN using the 32-bit Microsoft Text Driver (Instead of using the 64-bit Microsoft Access Text Driver), as suggested by Bevan, which has been detected by the ODBC Connection object within Geo SCADA.

 

Now I just need to use the ODBC Query and respective ODBC Data Points to extract the data from the DSN, following the steps highlighted in the Help topic that Stephen recommended.