I am working with sql server database and visual basic 6 and need to access the database remotely in my visual basic 6 application. Could I set the database so that I can reference it remotely using IP.
I want to then be able to create an ODBC dsn pointing to the db using its IP address so I can use the dsn in my VB6 application to connect to the db. I have seen this working in another application but dont know how. Please help with details.