I was wondering if this is possible and would operate reasonably quickly:
I want to create a standalone MS program (exe) that can be called from my own program (running on my users’ computers) via the command line (so I know I need the pro version with the compiler). The MS program would have VB script code (if needed) to create a connection to my MS SQL database running on my ISP’s server. This would download the queried data that then would be converted to a csv file that my program could then process further. The csv file could be several thousand rows large with perhaps 10 fields.
Also, the reverse process would be needed- i.e. my program creates the csv file which is read by the MS program, which in turn loads that data into the MS SQL database.
Thank you very much for your help.
Is This Type Remote MS SQL Access Possible?
Moderators: JRL, Dorian (MJT support)
- Marcus Tettmar
- Site Admin
- Posts: 7395
- Joined: Thu Sep 19, 2002 3:00 pm
- Location: Dorset, UK
- Contact:
Hi,
Yes, it is possible and would run quickly. Use ADO/ODBC see:
http://www.mjtnet.com/vbsdb.htm
Also search these forums for other ODBC examples.
Yes, it is possible and would run quickly. Use ADO/ODBC see:
http://www.mjtnet.com/vbsdb.htm
Also search these forums for other ODBC examples.
Marcus Tettmar
http://mjtnet.com/blog/ | http://twitter.com/marcustettmar
Did you know we are now offering affordable monthly subscriptions for Macro Scheduler Standard?
http://mjtnet.com/blog/ | http://twitter.com/marcustettmar
Did you know we are now offering affordable monthly subscriptions for Macro Scheduler Standard?
MSSQL is on ISP's Server
Thank you very much. But my MSSQL database is running on my ISPs computer, so I don't believe that would be practical. I need a way of ceating the connection string programmatically and privately. Does that make sense? Thanks again.
- Marcus Tettmar
- Site Admin
- Posts: 7395
- Joined: Thu Sep 19, 2002 3:00 pm
- Location: Dorset, UK
- Contact:
Hi,
Doesn't matter where the database is. A connection string or ODBC connection can be set up to access it. E.g. we can access our MySQL database on our web server via an ODBC connection or connection string.
You need to ensure that your ISP has given you access and that the firewall allows such connections of course.
Doesn't matter where the database is. A connection string or ODBC connection can be set up to access it. E.g. we can access our MySQL database on our web server via an ODBC connection or connection string.
You need to ensure that your ISP has given you access and that the firewall allows such connections of course.
Marcus Tettmar
http://mjtnet.com/blog/ | http://twitter.com/marcustettmar
Did you know we are now offering affordable monthly subscriptions for Macro Scheduler Standard?
http://mjtnet.com/blog/ | http://twitter.com/marcustettmar
Did you know we are now offering affordable monthly subscriptions for Macro Scheduler Standard?