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