transfering data from MSO Access to Progress

C

Carlos78

New Member
Hi,

I have some data on MSO Access that i would like to transfer on a periodical basis (daily) to a Progress DB. What whould be your recommendation to do this on a easy-fast way?

I'm currently trying to do it using an OPC Client for ODBC, but for some reason it is not working.

Thanks!

Carlos :confused:
 
You don't Way anything about your Progress/OpenEdge Version. Plus, you don't give any information whether you get an error message.

Without more detailled information it's hardly possible to say anything reasonable.


Regards, RealHeavyDude.
 
Sorry, version is Progress OpenEdge 10.1B.

I'm not getting an error message directly, but the following is an extract of the log file for the OPC Cliento for ODBC:
[03/15 12:58:27.77](9 ID=128) ****LICENSE **** LICENSE DETECTED
[03/15 12:58:55.30](2 ID=056) COPCManager::_OPCMgrScan() Pinging OPC server [Matrikon.OPC.Simulation.1]
[03/15 12:59:25.38](2 ID=056) COPCManager::_OPCMgrScan() Pinging OPC server [Matrikon.OPC.Simulation.1]
[03/15 12:59:25.79](2 ID=208) CGDAODBCServer::ExecuteQuery() Query Failed: INSERT INTO [Counter_reading] ([Counter_key], [Reading]) VALUES ('Random.Int1', '126 ') with Error String: ERROR: SQL Error State:HY000, Native Error Code: 4294757240, ODBC Error: [DataDirect][ODBC Progress OpenEdge Wire Protocol driver][OPENEDGE]Syntax error in SQL statement at or about "[Counter_reading] ([Counter_key], [Readi" (10713)
[03/15 12:59:25.79](2 ID=208) CTransaction::DoTransaction() Item Query Failed!
[03/15 12:59:55.40](2 ID=056) COPCManager::_OPCMgrScan() Pinging OPC server [Matrikon.OPC.Simulation.1]
[03/15 13:00:25.41](2 ID=056) COPCManager::_OPCMgrScan() Pinging OPC server [Matrikon.OPC.Simulation.1]
[03/15 13:00:25.82](2 ID=208) CGDAODBCServer::ExecuteQuery() Query Failed: INSERT INTO [Counter_reading] ([Counter_key], [Reading]) VALUES ('Random.Int1', '57 ') with Error String: ERROR: SQL Error State:HY000, Native Error Code: 4294757240, ODBC Error: [DataDirect][ODBC Progress OpenEdge Wire Protocol driver][OPENEDGE]Syntax error in SQL statement at or about "[Counter_reading] ([Counter_key], [Readi" (10713)
[03/15 13:00:25.82](2 ID=208) CTransaction::DoTransaction() Item Query Failed!

Hope this provides a better view of the problem.
 
Don't know anything about OPC server, therefore I can't tell you what is going on, but the error message tells that the SQL syntax, as far as the OpenEdge database is concerned, is illegal.

HTH, RealHeavyDude.
 
You must log in or register to reply here.
Back
Top