>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
>
Cannot connect cannot change property.
SQLSETPROP() demands a connection handle.

Is there another way?

Thanks,

>>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