Most definitely. All you'll have to ensure is that they have a SQL server driver loaded.

lcConnect = "DRIVER={SQL SERVER};SERVER=ipaddresshere\serverinstancehere;UID=" + SQLUser + ";pwd=" + SQLUserPassword + ";database=yourdatabase"

lnHandle = sqlstringconnect(lcConnect)

HTH
Richard

>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