I wish to create a dynamic ODBC connection to an SQL server in the following way:

1. My application is run on any local PC, at any of my client's offices, from various locations throughout the UK.
2. My SQL server is hosted on the internet with it's own unique IP address.
3. I wish to connect to the SQL server, from any local PC, WITHOUT having to specifically set-up an ODBC connection on each client PC.

Is there a way that I can supply the server IP address (and obviously the username and password) and create a connection on the 'fly'? Traditionally I'd need to create a connection, within the database container, and I'd need to create a new ODBC connection from within administrative tools; I have to be able to create the connection without doing either.

Is this possible, and if so, how? Thanks in advance.

Regards

Derek