Hi All,
I have developed a tool using Javascript , VBscript and HTA. To connect to the oracle database am calling cmd prompt from vbscript and i login to oracle database using sql plus in cmd prompt.
This works fine, but it will work on individual system. That is what HTA is meant to be.
Now the requirement is to host it and make it a web application. Well, because everything is written in HTML , so i don’t have to make many changes.
Only thing thats bothering me now is, how to connect to the Oracle Database. Is there a direct way to connect instead of calling cmd(which won’t work in web application).
I have googled and got many solutions. But am not sure which one to pick.
Overall, what i need is to connect to Oracle Database and execute a sql file.
You might want to look into re-writing it in PHP (in place of the VBscript), (using PDO for accessing the database). I’ve never heard of HTA before, what’s it short for?
You can’t connect to a oracle database using client-side code.You will need to build an API server-side that connects to the db and sends back a response to the client-side code. There is probably an oracle driver out there for nearly every server-side language.
I can’t because it is something I would need to research myself. I think you can connect to oracle in php using PDO but as for other languages I don’t know how off hand.
If I’m understanding, you are wanting to take code written to work with Windows OS native functions and convert it into a web application.
I’ve written a few “desktop” apps before, but as such they had “special access privilege” to my OS.
For example, I could do read - write work with my computer’s files.
A web app will not have access to a users file system.
And you will need to find “equivalents” in what ever language(s) your server has