Ask the Expert

How can I make data available to a Windows form app on another computer over a WAN?

How can I make data in an Access database on a server available to a VB.NET Windows form application on another computer over a WAN? The server is an NT machine with IIS installed.
Using an Access database as a sort of database server is asking for trouble, in my opinion. You should move to MSDE (which is also free to distribute with several product licenses, such as VS, Office, etc.), which will scale much better, will give you real stored procedures, security and an inmediate path of upgrade to the full SQL Server. MSDE uses the same engine as SQL 2000, with limits on concurrent connections and database size. However, most of these limits are practically unreachable for an access database (performance-wise at least). You can install the trial version of SQL Server 2000 and perform the upgrade to your database, and then use MSDE in the production environment.

Reaching the DB is the easy part. If the application will run inside a VPN across the WAN, you can connect just as you do locally, with the machine name. If you're going through the Internet, you have to enable TCP/IP client protocol on the server and just connect to it from the other end with the appropriate connection string. This is not quite secure, however.

Another cool way of exposing the information in a MSDE/SQL 2000 database is through SQLXML. It allows client applications to issue queries and get results in XML format through standard HTTP calls.

This was first published in May 2003

There are Comments. Add yours.

 
TIP: Want to include a code block in your comment? Use <pre> or <code> tags around the desired text. Ex: <code>insert code</code>

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
Sort by: OldestNewest

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to: