Is This Type Remote MS SQL Access Possible?

[BobL]

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.

[Marcus Tettmar]

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.

[BobL]

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]

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.

[BobL]

Thank you very much for your helpful and quick response.