>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.
>
>AlanNot sure why it works in one mode and not the other but it could be you created a User DSN and the COM version does not run under your username but the system account.
Why not get rid of the DSN altogether and go DSNLess with SQLSTRINGCONNECT() instead?
See:
http://fox.wikis.com/wc.dll?Wiki~VFPCommandSQLStringConnect