General information
Category:
Internet applications
Yes, it al worked ok at them command window.
Oscar
>BTW, did you try to open it from VFP command window?
>
>>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
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only