Information générale
Catégorie:
COM/DCOM et OLE Automation
Titre:
SQLConnect() not working from COM object
Versions des environnements
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
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement