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
Eric Kleeman - EDS Consulting Services
MCP Visual FoxPro
MCSD C#.NET
Hua Hin Thailand
Los Angeles California