Unable to complete connection (VBScript/HTA App/MySQL 5.6)

Question

While I am relatively new at this side of things I have an interesting dilemma.

If I place the following code in a stand alone VBS script file it runs with no errors:

 Dim conn
 Set conn = CreateObject("ADODB.Connection")
 conn.open "DSN=books"
    conn.Execute "DROP TABLE IF EXISTS token"
    conn.Execute "CREATE TABLE token(filename int not null primary key, author varchar(100), title varchar(250), other varchar(250), folder varchar(50))"
 conn.close
 set conn=nothing
 msgbox "done!"

However, if I place the same code inside a HTA application I receive the following error message:

[Microsoft][ODBC Driver Manager] Data Source Name Not Found and No Default Driver Specified

I have tried the following methods when adding the code to the HTA file:

1) I have connected to the working VBS file (that works when opened directly) but when included gives the above error
<SCRIPT Language="VBScript" src="test.vbs"></script>

2) I have just included the coding into HTA file (still receives error above)
<SCRIPT language="VBScript">
Code from above
</SCRIPT>

Any ideas?  I've searched for a reason for this but everything I have found indicates that I should either be receiving the error whether I open the VBS file directly or include it in the HTA app.

Answer 1

Hi,

This forum is for MSFT SQL Server not mysql. However please see the link below with a similar issue. You may consider posting there for mysql issues in the future.

http://www.pcreview.co.uk/forums/windows-pe-hta-sql-error-t2107815.html

Frank.

---

Frank Garcia