henriklauritzen Posted August 15, 2006 Share Posted August 15, 2006 What is wrong with my setup?? DNS: Goto “Control Panel->Performance and Maintenance->Administrative Tools->Data Sources (ODBC)” I select "User DSN" and adds a new DNS that connects to my mysql database. If I test the connection - I get 'success connection is made' from the ODBC Data Sources administrator. The DNS is named IVRDNS I call the sqllink.exe with: line 1. IVRDNS line 2. insert into IVR (q1) values(1) Table is called IVR + there is a column called q1 present in the table (INTEGER) Log-file shows Run plugin: "C:\Documenter and settings\henrik\skrivebord\ivr lyd\sqllink.exe to plugin" IVRDNS "insert into IVR (q1) values(1)" But I keep getting an error in return. If I use a system DNS + .asp-page on localhost - the "insert into IVR (q1) values(1)" inserts a row in the IVR database without any problems. Any ideas what I am doing wrong?? Link to comment Share on other sites More sharing options...
tjareson Posted August 21, 2006 Share Posted August 21, 2006 Hi, I also tried to use this sqllink.exe but without any success. Meanwhile I've written a little VB-script which works fine with an MySQL database. It is also capable to execute selects, deletes, updates and to perform next and previous actions, just in case a select statement delivers more than one record. Just let me know, if you interested in it. Could provide it by email or something. regards Tjareson. Link to comment Share on other sites More sharing options...
Genius_Boy Posted September 6, 2006 Share Posted September 6, 2006 Hello Boy I so think that NCH SQLLink plugin is not useful for most users. I get SQLLink source from NCH but it was in c language and I am a VB programmer. In my language this work is very easy but NCH don't determine a way for exporting result of VB project to IVM so I write result as text stream into a text file and read it by getdatax.exe plugin. Best regards Link to comment Share on other sites More sharing options...
mobasoft Posted September 6, 2006 Share Posted September 6, 2006 Hi, I also tried to use this sqllink.exe but without any success. Meanwhile I've written a little VB-script which works fine with an MySQL database. It is also capable to execute selects, deletes, updates and to perform next and previous actions, just in case a select statement delivers more than one record. Just let me know, if you interested in it. Could provide it by email or something. regards Tjareson. I'd appreciate it if you could email me that script mbailey [at] mobasoft [dot] com thanks Link to comment Share on other sites More sharing options...
Claudio Posted October 10, 2006 Share Posted October 10, 2006 Just a suggestion... we experienced similar problems, but the problem was due to firewall blocks. When using external plug-ins always be sure the connection is not being blocked. Bye, Claudio Link to comment Share on other sites More sharing options...
amru Posted May 12, 2008 Share Posted May 12, 2008 Thank you if you give me VB Script. My email : winslab@gmail.com Regards, Amru Hi, I also tried to use this sqllink.exe but without any success. Meanwhile I've written a little VB-script which works fine with an MySQL database. It is also capable to execute selects, deletes, updates and to perform next and previous actions, just in case a select statement delivers more than one record. Just let me know, if you interested in it. Could provide it by email or something. regards Tjareson. Link to comment Share on other sites More sharing options...
Juki777 Posted May 12, 2008 Share Posted May 12, 2008 Hi Guys, I have been using SQLlink plugin for my IVR that is connected with MSSQL server 2005 and so far it works like a charm. I have to admit that it's quite difficult to get it running properly but after a while a got the hang of it. Try the following 1)First of all make sure that your firewall is not blocking any of the ports that SQLlink will be using and/or processes. Some software firewalls will even prevent sqllink to have access to local resources. I would recommend setting up sqllink with no firewall on and once u're done , re-enable it and configure it accordingly. 2) If you have your databaseon a different server, make the firewalls on that server is not blocking sqllink from accessing its ports 3) 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. NCH should really add that information on their plugin files/webpage. SQLlink is quite limited actually. It will not allow long SQL statements and will only return one data row. If this is limitation for you , you could try the other scripts created by other users . Good luck on your project !!! Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now