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?
>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,
"It is an important and popular fact that things are not always what they seem. For instance, on the planet Earth, man had always assumed that he was more intelligent than dolphins because he had achieved so much -- the wheel, New York, wars and so on -- whilst all the dolphins had ever done was muck about in the water having a good time. But conversely, the dolphins had always believed that they were far more intelligent than man -- for precisely the same reasons." - Douglas Adams