>Thanks Boris
>
>Can you point me to some example code for code for connecting to the SQL server from a machine logged onto the domain please?
>
>!st requirement is just to browse the data in a table
>
>2nd requirement is to append/amend/delete records in a table
>
>Many thanks
>
>Rob

**** If you use SQL Server Authentication
TEXT TO ConnectionString NOSHOW PRETEXT 15
     DRIVER={SQL Server Native Client 10.0};Database=YourDataBase;UID=username;PWD=password;
ENDTEXT

**** If you use Trusted connection
TEXT TO ConnectionString NOSHOW PRETEXT 15
     DRIVER={SQL Server Native Client 10.0};Database=YourDataBase;Trusted_Connection=yes;
ENDTEXT


lnHandler = SQLSTRINGCONNECT(ConnectionString)
IF lnHandler < 0
   AERROR(laError)
   MessageBox(laError[1,2])
ENDIF

You could force the ODBC to use some protocol with adding this to connection string:
Network=dbnmpntw -> Named pipes
Network=dbmssocn -> TCP/IP