Can I transfer data from lookout to microsoft sql server 2005/2008?

[RobertGuirguis]

Can anybody please tell me the exact procedure to tranfer data directly from lookout to microsoft sql server 2005/2008?

-which data sources should I install (ODBC drivers)?

-what do I exactly enter in data source string and SQL fields in SQLexec or datatable object in lookout? 

Thanks, 

Robert

[Mike@Forshock]

Robert, 

As we discussed over the phone, please upload the .lks file and we can help here so everyone can learn as well.

I appreciate the contact and will do what I can to help,

Mike 

[RobertGuirguis]

Here is the source file as requested:

the sqlexec object is called Sql1.

[Mike@Forshock]

Robert,

To test if the data is being posted into the MySQL database please create a new SQLExec object called "SQLSelect".

In the SQLExec, set these values:

Data Source = "DSN=pp-lookout;"

SQL = ""SELECT * FROM new_table7 LIMIT 10"

Drag the Data Members  SQLSelect.c1 to SQLSelect.c10 to a screen to see if the values are correct.

Thanks and good luck,

Mike

PS:  Folders are your friend 🙂 

[Mike@Forshock]

Forgot to add that you need to create a new Pushbutton to Execute the query.

Mike 

[RobertGuirguis]

I can only find c1-c65535 and when I do drag it, it shows 0. (corresponds to the first data member). How can I view the data in mysql workbench, because I refreshed the table in mysql workbench and it's still empty. Does the table get updated automatically?

[Mike@Forshock]

Robert,

I myself have not used MySQL workbench so am not sure how that product works.

When a successful INSERT query is sent, the database should have the data almost instantly (within 1-5 seconds).

Please verify if there are any SQL errors in the Lookout Alarm Window.

Mike 

[RobertGuirguis]

Could it be because the odbc driver is under user DSN instead of system DSN?

[RobertGuirguis]

And how does mysql recognize that this sql function from lookout is executed? Is there something else I have to do in order add this value to the column?

[Mike@Forshock]

Is there an alarm in the Alarm Window whenever you execute Pb1 (the button used to execute the INSERT)?

Message Edited by Mike@Forshock on 06-17-2010 04:00 PM