Thursday, February 07, 2013 4:33 PM
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:
Set conn = CreateObject("ADODB.Connection")
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))"
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)
Code from above
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.
Friday, February 08, 2013 3:50 PM
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.
- Marked As Answer by Iric WenModerator Monday, February 18, 2013 6:29 AM