Question:
I have been using Visual Basic to manipulate databases for some time now and I consider myself skilled at it. The next challenge presented is to establish a connection to a database on the internet. I would imagine that I would have to log in through an FTP server, but I am unsure. Can you explain how I would do this. Thank You.
Answer:
Most databases, such as Oracle and SQL Server, won’t operate through an FTP server. They work with TCP/IP on a different port from your Web browser. Databases like Access are file-based and can’t operate across the Internet the way you’re talking about. Many sites have Access databases, however, those databases are on the same machine as the Web pages.