ODBC connection error 08001 (Hi Jim Creak)

[Jim Creak]

Hi Peter & all,

Nope I never did find a solution to the ODBC connecting to a remote Omnis Classic datafile using php ... ended up using Omnis to populate a local MySQL datafile and let php talk with that ... meant I didn't have live data on-line, but it was a solution to a problem that I couldn't find any other solution for.

I tried moving the datafile to a number of different servers and got the same error every time, it was my impression that it had something to do with the way php was using the Omnis ODBC client. But it worked as it should when on the local drive, and it also worked as it should if I used Excel to access the ODBC client to the remote source.

i'm pleased you found something that worked for you.

Thanks
Jim

JACSoft Programming Ltd.



On 30/12/2014, at 11:56 AM, Peter Suter wrote:

> G'day,
> I've spent days trying to resolve a problem accessing an Omnis datafile via ODBC on Windows 8 and have finally found something that works; posting it here will help me find the fix quicker when there is a next time.
> The error messages have "suggested" the DSN itself being the problem, but with the .Net side saying "always use a System DSN" and the Omnis side "always use a User DSN" those error messages and suggestions have been "time consuming".
> 
> 
> Finally, trying a database component in a new version of Visual Studio I got the 08001 error, and found Jim's message (all over the web) and on the list as "Trying to connect to Datafile using ODBC and PHP,error when datafile on network computer"
> 
> 
> That error message was:
> 
> 
> 
> ---------------------------
> Microsoft Visual Studio
> ---------------------------
> ERROR [08001] Unable to read disk (bad disk)
> ---------------------------
> OK   
> ---------------------------
> 
> 
> The suggested solution was to run check disk on the drive (didn't find anything).
> After moving the datafile to another drive .. no error.
> 
> 
> Hi Jim, did you resolve your problem? If you found a different fix can you please let me know what it was.
> 
> 
> Best Regards
> Peter Suter
> pete.suter at aol.com
> 
> 
> _____________________________________________________________
> Manage your list subscriptions at http://lists.omnis-dev.com