Re: Foxpro with MYSQL

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



On April 11, 2006 11:11 am, Linda de Boer wrote:
> G'day
>
> If I have VFP9 working, a Mysql DSN which I can contact via
> isql and using unixODBC for this. Do I need to do anything
> else to wine ie; install MySQL drivers (Windows version) to
> get connectivity? I just finished checking out Paul McNett's
> pages, however the MYSQL drivers he used for VFP8 are "no
> longer supported" when I do "wine setup.exe". I have a saved
> copy of my .wine that I reload from, so I figured I'd give it
> a try.
>
> The error I get is :
>
> Connection failed:
> SQLState: '01000'
> SQL Server Error: 2
> [Microsoft][ODBC SQL Server Driver][Shared
> Memory]ConnectionOpen (Connect()).
> Connection failed:
> SQLState:'08001'
> SQL Server Error: 17
> [Microsoft][ODBC SQL Server Driver][Shared Memory] SQL Server
> does not exist or access denied.
>
>
> So  if isql lets me conenct and show tables etc. and
> "sqlconnect()" in foxpro brings up the dialogue. What is
> between those two to stop it?
>
> WINEDEBUG=+odbc32 is set, but I haven't seen anything helpful
> yet, unless I'm looking in the wrong place. Is there a more
> up-to-date set of instructions I overlooked? So
> close.......;-(
>
> --
> ldb
>
> _______________________________________________
> wine-users mailing list
> wine-users@xxxxxxxxxx
> http://www.winehq.org/mailman/listinfo/wine-users

Hm.  Are you sure that Wine is trying to use the unixODBC or is 
it trying to use Native?  The "[Microsoft]" suggests to me that 
it is trying to use native drivers.

You have set WINEDEBUG=+odbc32 but you haven't seen anything 
useful yet.  Have you seen anything at all with the odbc32 label 
in the trace? If not then that is probably the problem.

Use whatever method you prefer to set the DllOverride to builtin 
for the odbc32.dll and see if that makes a difference.

-- 
Bill Medland
mailto:billmedland@xxxxxxxxxxxxxxxx
http://webhome.idirect.com/~kbmed

_______________________________________________
wine-users mailing list
wine-users@xxxxxxxxxx
http://www.winehq.org/mailman/listinfo/wine-users

[Index of Archives]     [Gimp for Windows]     [Red Hat]     [Samba]     [Yosemite Camping]     [Graphics Cards]     [Wine Home]

  Powered by Linux