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