Sounds like a login dialog is trying to be displayed. Obviously, you can't have a dialog in a dll! Use SQLSETPROP() and set DispLogin to 3. That will prevent the dialog. Then, AERROR will tell you what the real problem is.
SNIP
>Thanks,
>I tried it and get the error
>"Connectivity error: [Microsoft][ODBC Driver Manager] Only SQL_DRIVER_NOPROMPT is allowed when connection pooling is enabled"
>
>What does this mean?
>Nick,
>
>>>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?
>>
>>SNIP
"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
