SQL Demo test

Share icon

Tue, 10/04/2016 - 02:57 am

Hi,
I'm trying to run the SQL Demo. I'm using Igor Pro 6.37 on Win 7.
But when I try to test the connection in ODBC Driver, I'm getting this error (Attached Image).

What I'm doing wrong ?
I'm pretty sure the database server you want to use is something different than wavemetrics.com. What is the ip address of the database server?

October 4, 2016 at 05:16 am - Permalink

I guess, but I took those parameters from the tutorial :

1. Open Control Panel -> Administrative Tools -> Data Sources (ODBC) to run the ODBC Data Source Administrator program.
2. Click the User DSN tab (or click System DNS if you want all users on your machine to be able to use this DSN).
3. Click the Add button.
5. Choose the MySQL ODBC Driver and click Finish. A new dialog, Connector/ODBC, is displayed.
6. In the Connector/ODBC dialog, in the Login tab, enter the following values exactly as shown here:

Data Source Name: IgorDemo1
Description: WaveMetrics Demo Database
Server: wavemetrics.com
User: DemoUser
Password: Demo
Database: Demo1


7. Click the Test button. You should get an alert saying that the connection was made. Click OK to dismiss the alert. If the test fails, carefully check all of the settings. Also make sure that port 3306 is open on your computer.
8. Click OK in the Connector/ODBC dialog to complete the DSN.
9. Click OK to quit the ODBC Data Source Administrator program.

October 4, 2016 at 05:52 am - Permalink

For security reasons, the SQL server at wavemetrics.com is no longer available.

I will attach a new version of the "SQL Help" file that uses a publicly available server for the demo. Replace your "SQL Help" file with the attached file.
SQL Help.ihf

October 4, 2016 at 09:33 am - Permalink

@fay.tor: Sorry for the wrong call. I did not expect a public test server from WM to be available.

October 4, 2016 at 10:19 am - Permalink