General information
Category:
Internet applications
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
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