Thanks a lot

Oscar


>I had the same issue a few days ago. It was working fine on my development machine but not on the server where I installed my app. When, I copied the dll from my computer to server, it worked just fine.
>
>So, I am sending you an email with the the version of DLL that worked for me. See if you can find someone to put it on your web server.
>
>Good Luck !!!!
>
>>The DSN is in a hosting service somewhere in the UK. The administrator was only able to create a DSN through an administration page wher you chose:
>>
>>The ODBC type: Visual FoxPro
>>The name: AnyName
>>The Path: Path to the database.DBC
>>
>>
>>
>>
>>>You can find it out from Control Panel->Settings->Administrator Tool->Data Sources->Drivers Tab.
>>>
>>>>Is that possible through ASP code?
>>>>
>>>>So I do not have to wait for an answer from the hosting support team.
>>>>
>>>>
>>>>
>>>>
>>>>
>>>>>Cna you check the VFPODBC.dll version and timestamp?
>>>>>
>>>>>>Hi Jayesh
>>>>>>
>>>>>>I'm using a VFP OLEDB provider (according to the host administrator) the table belongs to the database to whidh the DSN is connected. I guess this is Ok, since I'm not getting any error when connecting.
>>>>>>
>>>>>>Te database and the table shouldn't be used by anyone. Both have beeen just oploaded.
>>>>>>
>>>>>>Any other ideas?
>>>>>>
>>>>>>Regards and thanks for you reply
>>>>>>
>>>>>>Oscar Corte
>>>>>>
>>>>>>
>>>>>>>Is that same dbf opened exclusively anywhere else?
>>>>>>>
>>>>>>>Are you using VFP OLEDB Provider to connect or just ODBC datasource?
>>>>>>>The reason why I asked because I saw some threads on other newsgroups having problems connectiong to Free table using VFP OLE DB?
>>>>>>>
>>>>>>>
>>>>>>>>Hi everyone
>>>>>>>>
>>>>>>>>I'm connecting to a DSN without any error(s) through
>>>>>>>>
>>>>>>>>Set Conn = Server.CreateObject("ADODB.Connection")
>>>>>>>>Conn.Open("dsn=DataSource")
>>>>>>>>
>>>>>>>>However the command
>>>>>>>>
>>>>>>>>sql = "Select * from personal"
>>>>>>>>set rs = Conn.Execute(sql)
>>>>>>>>
>>>>>>>>This SQL statement works locally but not as shown above.
>>>>>>>>
>>>>>>>>The error looks like this:
>>>>>>>>
>>>>>>>>Microsoft OLE DB Provider for ODBC Drivers error '80004005'
>>>>>>>>[Microsoft][ODBC Visual FoxPro Driver]Cannot open file e:\domains\bcthis.co.uk\user\private\personal.dbf.
>>>>>>>>
>>>>>>>>
>>>>>>>>I’ll appreciate any hints to execute the SQL statement correctly.
>>>>>>>>
>>>>>>>>Oscar Corte