Help!!! SQLLink, Work in Simulator but Not In Real

[lauren198]

Work(Simulator):

--------------------

11:47:51 Open OGM: Check Verification Number
11:47:51 Run plugin: "C:\Program Files\NCH Swift Sound\IVM\plugin\SQLLink.exe" "mysqlcon" "select * from test where Phone_Sessions= 123456" "root" ""
11:47:52 Plugin returned: [b]Rowcount=1&Result=Okay&Id=102&Phone_Sessions=123456&Phone_Number=5555555555&copyright=NCH Swift Sound
[/b]
11:47:52 Run plugin: "C:\Program Files\NCH Swift Sound\IVM\plugin\SQLLink.exe" "mysqlcon" "update test set Phone_Number=5555555555 where Id=102" "root" ""
11:47:52 Text-to-Speech Synthesis: Checking Verification Number, Please wait a few minute!
11:47:52 Plugin returned: [b]Rowcount=0&Result=Okay&copyright=NCH Swift Sound[/b]

11:47:52 Run plugin: "C:\Program Files\NCH Swift Sound\IVM\plugin\SQLLink.exe" "mysqlcon" "select * from [b]test[/b] where Phone_Number=5555555555 and Id=102" "root" ""
11:47:53 Plugin returned: [b]Rowcount=1&Result=Okay&Id=102&Phone_Sessions=123456&Phone_Number=5555555555&copyright=NCH Swift Sound
[/b]
11:47:57 Command - Go

 

Get Error(Real Connection):

--------------------------------

11:57:59 Open OGM: Check Verification Number
11:57:59 Run plugin: "C:\Program Files\NCH Swift Sound\IVM\plugin\SQLLink.exe" "mysqlcon" "select * from test where Phone_Sessions='123456'" "root" "123"
11:58:00 Plugin returned: [b]Result=Error&copyright=NCH Swift Sound[/b]

11:58:00 Run plugin: "C:\Program Files\NCH Swift Sound\IVM\plugin\SQLLink.exe" "mysqlcon" "update test set Phone_Number='102' where Id=''" "root" "123"
11:58:00 Text-to-Speech Synthesis: Checking Verification Number, Please wait a few minute!
11:58:00 Plugin returned: [b]Result=Error&copyright=NCH Swift Sound[/b]

11:58:00 Run plugin: "C:\Program Files\NCH Swift Sound\IVM\plugin\SQLLink.exe" "mysqlcon" "select * from test where Phone_Number='102' and Id=''" "root" "123"
11:58:00 Plugin returned: [b]Result=Error&copyright=NCH Swift Sound[/b]

11:58:04 Command - Go

 

What must i do?? Please help me to solve this problem..

 

thanks before.

 

best regards,

 

 

lauren.

[lauren198]

hello..

 

any body can help me??

please...

 

lauren.

[lauren198]

If You have some problems with SQLLink.exe

please Try this MySQL Plugin..

(I make it, I solve it)

 

http://rapidshare.com/files/192476644/pSQL.rar.html

Extract the Files and copy the "*.dll" files to "c:\windows"

 

Syntax:

pSQL.exe [host] [DB_Name] "SQL_Query_Syntax" [user_Name] [user_Pass]

 

e.i.:

pSQL.exe www.domain.com domain_db "select * from domain_tabel" domain_user domain_pass

 

 

Best Regard

 

 

lauren

[polenta]

The "user DSN" will only work for the Simulator.

You have to create a "system DSN" to allow other extensions or outside calls to interact with DB.