Hector,
Didn't work. I'm running this on a different machine (W2000 Server, IIS 5.0). Naturally, it all works fine on mine.
Dan
>I know this sounds silly, but try with this instead:
>
>
>set oConnection = Server.CreateObject( "adodb.connection" )
>oConnection.Provider = "vfpoledb.1"
>oConnection.ConnectionString = "data source=c:\fullpath\mydata.dbc"
>oConnection.Open
>
>
>>>You need to specify the full path to the database. When you go through ASP, you are
not on the same folder as the database. Most likely you are on the Windows\System32 folder or something like that.
>>>
>>
>>Thanks for responding.
>>
>>I tried that first because I had the DBC in a different directory. Still did not work. Even tried Server.MapPath("testdata.dbc").
>>
>>Dan
>>
>>>
>>>>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>
>>>>
>>>>< % ERROR:
>>>>
>>>>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