I have created a MTDLL COM object which I am calling from an ASP page using the code
Set oTest=Server.CreateObject("comtest.MyClass")
oQuote = oTest.MyMethod(params list)

When I call the method from within the VFP development environment everything works fine, and I get the expected results, but when I load the ASP page in a browser, I get an error due to a failed SQLCONNECT command...
lnHandle = SQLCONNECT('ODBC Database name','Username','Password') (returns -1 to denote failed connection).

AERROR() returns the following values
[1]1526
[2]Connectivity error: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
[3][Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
[4]IM002
[5]0
[6]1
[7].NULL.

I cannot work-out why SQL finds the datasource when called from VFP, but cannot do so when called from the ASP page. Has anyone any ideas how I can solve this problem so that the COM object can run correctly from both environments?

Any help would be appreciated.

Alan