danmat46
14 Nov 2007, 3:10 AM
Hello!
I am having an issue with using the ODBC connector to MySQL in that when you use VBScript
with this it takes 5 seconds to close WScript.exe after it has completed running the
code.
This only occurs when you .Open an ADODB connection
My current MySQL version =
My current MySQL ODBC version =
This only occurs with MySQL, MsAccess doesn't cause this issue.
This is causing a massive issue as 5 times this script needs to be called but the software
has to wait for WScript.exe to close before moving to the next one leaving a lag time of 5
seconds for each one!
How to repeat:
Create a file named VbScript.vbs and add this code:
Dim conn
Set conn = CreateObject("ADODB.Connection")
conn.open "DSN=DSNMy"
conn.close
set conn = Nothing
msgbox "done!"
Then save that and add an ODBC connection to MySQL database and table, providing login
details etc.
Then open up task manager and select tab "Processes", run the the script by double
clicking. Select OK to the message and look in task manager and count the seconds the
Wscript.exe stays there after the message box has been selected.
This is not correct behavouir, but you can run more than one instance of WScript.exe so is it an issue of speed with the ExtJS library?
When running these cgi-bin scripts and using firebug it states GET http://cgi-bin/....etc. and on the far right it states "yui-utilities.js (line 16)".
Where do I go from here to solve this?
Thank you and please help!
Mite be worth mentioning that I have followed the steps from this bug (http://forums.mysql.com/read.php?10,153077,153077#msg-153077) regarding "Error in my_thread_global_end(): 1 threads didn't exit"
I am having an issue with using the ODBC connector to MySQL in that when you use VBScript
with this it takes 5 seconds to close WScript.exe after it has completed running the
code.
This only occurs when you .Open an ADODB connection
My current MySQL version =
My current MySQL ODBC version =
This only occurs with MySQL, MsAccess doesn't cause this issue.
This is causing a massive issue as 5 times this script needs to be called but the software
has to wait for WScript.exe to close before moving to the next one leaving a lag time of 5
seconds for each one!
How to repeat:
Create a file named VbScript.vbs and add this code:
Dim conn
Set conn = CreateObject("ADODB.Connection")
conn.open "DSN=DSNMy"
conn.close
set conn = Nothing
msgbox "done!"
Then save that and add an ODBC connection to MySQL database and table, providing login
details etc.
Then open up task manager and select tab "Processes", run the the script by double
clicking. Select OK to the message and look in task manager and count the seconds the
Wscript.exe stays there after the message box has been selected.
This is not correct behavouir, but you can run more than one instance of WScript.exe so is it an issue of speed with the ExtJS library?
When running these cgi-bin scripts and using firebug it states GET http://cgi-bin/....etc. and on the far right it states "yui-utilities.js (line 16)".
Where do I go from here to solve this?
Thank you and please help!
Mite be worth mentioning that I have followed the steps from this bug (http://forums.mysql.com/read.php?10,153077,153077#msg-153077) regarding "Error in my_thread_global_end(): 1 threads didn't exit"