>Some questions: You've created a VFP OLE server and registered it on a web server, and in your ASP page you use Server.CreateObject to instantiate it? Are you passing the connection string as a method parameter or is it hard-coded in the DLL? Do you get an error message in the browser and if so, what is it?
>
I created VFP OLE DLL and use CreateObject in ASP to instantiate it.
Then is run the function in the DLL like this
Set ox = CreateObject("VFPDLL.SubMain")
Response.Write ox.ConnectToSQL

If connection is good i simple return the message "Connected To SQL"
otherwise i return the message "Cannot connect to SQL"

When i run the ASP page
Response.Write Return "Cannot connect to SQL"

When i run the DLL from VFP
I get "Connected To SQL".

Any ideas?


>>Hi,
>>
>>I've created a DLL in VFP that connect and sends information to SQL.
>>Using a ASP web page.
>>
>>But when i try to run the web page it tell me it cannot connect to SQL. When i test it in VFP it give me no errors.
>>
>>i use something like this to connect in the dll
>>gnConnectHandle =
>>SQLSTRINGCONNECT ('DSN=WebUpdate;UID=Hello;PWD=Hello;DATABASE=WebUpdatesDB')
>>NOTE: ODBC System DSN is created
>>
>>If i run it in VFP it connects, but if i run it in ASP it cannot connect.
>>
>>Any help is greatly appreciated.
>>
>>Nick,