Starting SQL XOP Demo
| Project: | SQL XOP |
| Version: | IGOR.6.00.x-1.0-beta-1 |
| Component: | Miscellaneous |
| Category: | support request |
| Priority: | normal |
| Assigned: | Unassigned |
| Status: | closed |
I am running Igor 6.10 prebeta on WindowsXP. I am stuck on trying to run the SQL XOP demos. I believe I followed the ReadMe.txt instructions about placing the xop, ihf, and ipf files, and deleting old ipf files from "WaveMetrics Procedures\File Input Output". I downloaded the mySql connector, set up the connection to the Igor demo with a successful "test" in the ODBC setup. But when I load either of the SQL XOP demos I get messages such as:
"Error creating the symbolic path: File_Input_Output"
and when I try to run "Fetch Data with Indicators" from the macro menu, I get:
"While executing SQLHighLevelOp, the following error occurred: SQLError."
What should I try?
Updates
Mark,
Just skip that path error message at the beginning.
The next issue is more than likely your driver version. I just downloaded MySQL ODBC 5.1 Driver so you need to change the connection string in GetWMDemoConnectionString() from version 3.51 to 5.1. After recompile all should work as expected.
If you have any question contact support@wavemetrics.com.
A.G.
WaveMetrics, Inc.
| Title: | Starting Demo | » Starting SQL XOP Demo |
Thanks. That worked after I also managed to straighten out the paths, since an old incompatible version of the SqlConstants.ipf was being loaded (I have both an "Igor Pro6 Folder" and an "Igor Pro6.10beta Folder").
The Wavemetrics demo worked, but more importantly, I was able to use a command like:
SQLHighLevelOp /CSTR={"DSN=myAccessDB",SQL_DRIVER_COMPLETE} /O /E=1 "Select * from myTable"
Which looks like it loaded 100% correctly, but I have not checked it in full detail.
I will note that when I reloaded the same table a second time, overwriting the initial read, I got a couple of messages like:
Wave 'dateDS' changed to 'dateDS0' because of a conflict.
After deleting all waves, the error message disappears.
The SQL XOP will be very tedious for advanced operations, but it is a tremendously powerful addition to Igor. Well worth the effort Wavemetrics put into the development.
| Status: | active | » fixed |
Removed the bad path from the demo experiment. Changed demo to be independent of MySQL driver version.
| Status: | fixed | » closed |