Yes, you can do that. See Re: Is it possible to connect a sql database with IP and por Message #829320

>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