Visual DB Script uses JDBC, so to use and manage a Database with VDBScript you must configure DNS.
Go in "Option Panel" -> "Administrative Tools" -> "ODBC"
Now you must create a new DNS file (a system link to your real Database), choose the Driver (for example: Microsoft Access Driver *.mdb), choose the pathfile of your existing Database and set a "Name". This name is the "system path" of your Database that VDBScript will use in future connection.
Now go in VisualDBScript -> Settings
and set your DNS name as:
jdbc:odbc:nameofyourDNS
where nameofyourDNS is the name that you set in ODBC.
Now VisualDBScript is ready to view, manipulate, manage and use your Database integrated with SQL Queryes!
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
How to set a DATABASE connection?
Visual DB Script uses JDBC, so to use and manage a Database with VDBScript you must configure DNS.
Go in "Option Panel" -> "Administrative Tools" -> "ODBC"
Now you must create a new DNS file (a system link to your real Database), choose the Driver (for example: Microsoft Access Driver *.mdb), choose the pathfile of your existing Database and set a "Name". This name is the "system path" of your Database that VDBScript will use in future connection.
Now go in VisualDBScript -> Settings
and set your DNS name as:
jdbc:odbc:nameofyourDNS
where nameofyourDNS is the name that you set in ODBC.
Now VisualDBScript is ready to view, manipulate, manage and use your Database integrated with SQL Queryes!