Data Export - SQL Database Professional

[suprsnipes]

I am having difficulty trying to use the SQL Database Professional Plugin.

I have installed the plugin and read the documentation but I am still having trouble getting a connection.

In the connection parameters window when testing the connection I receive the following error message;

Database accessing error[Unable to connect to a database [Error loading library 'libmysql.dll'].].

I have mySQL installed and have a local database already created yet I still get this message.

Appreciate your help.

[Arthur Grasin]

Please, download the following file and place it to Windows\system32 folder.

http://www.aggsoft.com/download/libmysql.zip

Also you can download this file from the MySQL site with ODBC drivers.

[suprsnipes]

That's great.

"Tested Successfully".

Appreciate the help, again...

 

[suprsnipes]

I can get a connection to mySQL. But I receive this error message.

"Data have been processed but with errors".

I've set up the database in mySQL with a data table that corresponds to the data parser settings. I've never done this before so I'm not quite sure where I have gone wrong.

Appreciate the help.

[Arthur Grasin]

Please, attach the backup of your settings. You can create it from the "File" menu. I'll verify it.

[suprsnipes]

Hi Arthur,

I have attached a copy of the program settings (backupofsettings.txt). I realized that I had not configured the SQL queue correctly and have made some progress. I am now able to make a connection to mySQL database.

The data is exporting into mySQL except for one problem, a column, the 'type' column should show a value of either 'A', 'B', or 'S'. After attempting to re-configure the settings a number of times I am having the same problem. I keep getting a value of '4' instead, all the remaining columns are working fine. (I have attached a .jpg copy of the mySQL data sample).

I'm not sure if mentioning the following will help but the DDE server doesn't seem to have a problem with this (see DDE .jpg attached). I have using the same information to export the data into mySQL. There are no other queries running at this stage.

[Arthur Grasin]

All seems OK, but can't make the full test without your data example. One exception, your table contains columns with names DATE, TIME, TYPE that are reserved in the SQL language. This may cause this problem. Could you change these names?

[suprsnipes]

Do you mean to change the table names in mySQL, I don't quite understand?

Would I need to change any of these settings on the data logger software?

I have tried various different ways to fix this problem with no success...it's seems very odd that the only field effected is the type field. It always returns a value 4 no matter what I do???

It doesn't seem to have anything to do with the order or variables of the parser items, SQL queries. I have also tried to change the database table names but the data wouldn't export into mySQL at all.

I would be happy to provide the raw data prior to parsing so that you can see if this problem can be resolved.

Regards,
suprsnipes

[Arthur Grasin]

You need to change column names and make corresponding changes in the SQL statement withing our software.

[suprsnipes]

So let me get this straight...

Do I leave the data parsing settings as is?

I'm just a little confused...can you give me an example?

Thank you in advance.

[Arthur Grasin]

Yes, you don't need to change parser settings. You need change your table structure in the database. Now, you've defined columns with names DATE, TIME, TYPE, SIZE. If you'll change your table structure, then, of course, you should change your SQL statement in the SQL Database Prof. plug-in. For example, if you'll rename your columns to DATE1, TIME1, TYPE1, SIZE1, then your SQL statement should be:

INSERT INTO night
(SYMBOL, DATE1, TIME1, TYPE1, PRICE, SIZE1)
VALUES
(:P1, :P2, :P3, :P4, :P5, :P6)

[suprsnipes]

Hi Arthur, thanks for your help. I still had some problems after changing the table names in mySQL and also the SQL query table in the data logger program...not sure why this is?

Any how I added a new parser with a different name and changed the SQL parser to match and it is now working as expected.

Thanks again for your help. This software is working very well. As you know I have tried almost every export plugin available and considering that from a technical perspective my programming knowledge is very limited so if I could get it to work I'm sure any user could also.

By the way I've said this before but your responses to my questions on this forum have been exceptional. I appreciate all your help.

I know how this must sound by my feedback is genuine I DO NOT have any affiliation with this software or employee's.