I thought it required the element to be there but not necessarily a value for the element -- ( ie: userid=;password=; )
>I don't think the FoxPro OLDDB driver requires that but I'll give it a try.
>
>Dan
>>How about a username and password?
>>
>>
>>
>>>I'm having trouble using the VFP oledb driver in an ASP page. When I try to open the connection IIS hangs and I have to restart it. Here is the source I am using.
>>>
>>><html>
>>><head>
>>><title>Just A Test</title>
>>></head>
>>><body>
>>>Just a test <P>
>>>
>>>< %
>>>
>>>set conn = server.createobject("adodb.connection")
>>>
>>>conn.Open("Provider=vfpoledb.1;Data Source=testdata.dbc;")
>>>
>>>Response.Write("Hello")
>>>
>>>conn.Close()
>>>
>>> % >
>>>
>>>
>>></body>
>>></html>
>>>
>>>I know the driver works fine. I have a test app in FoxPro that works.
>>>The database is located in the same directory as the page.
>>>
>>>Any ideas?
>>>
>>>Thanks,
>>>Dan