General information
Category:
Internet applications
>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,
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only