ODBC drivers require a connection string, ie:

DRIVER= Sybase System11}; UID=meathead; PWD=mymeat; SERVERNAME=datamac;DATABASE=mydb;IS=set ansinull off;SM=1;HOSTNAME=webserver

Or, a Data Server Name that is already set up on the web server to access your remote data. The FoxPro equivalent would look like:

h = sqlconnect(DSN)
x = "SQL statement"
sqlexec(h,x)

I don't know the equivalent VB syntax.

HTH