Hello guys,

I have problem now in migrating my whole windows to linux.

I have a software which is written by my vendor using visual basic and database mysql.

I aware that to run those windows based program, i need wine, and most of the program is working under wine, now the problem arise when i tried to run that program(written by vendor) in wine, it prompt out an error "access to sql server denied" i have installed mysql odbc driver for windows using wine, installed the vb runtimes. the software is not doesn't have a package, in windows we just need to install the vb runtimes and everything works well.

so anyone know what is the problem that i am facing now? maybe some guideline which will able to lead me to bright path to find the root cause.

in my mind, i think this will be related to the odbc driver for mysql.

please point me some clue..

The server for the database is still windows 2000 and the client is using Ubuntu 8

Thanks

MySQL runs natively in linux so you do not need wine for this. I understand you can migrate the database files from windows.

So the question becomes - How do I migrate my MySQL database to linux?
http://www.experts-exchange.com/Data..._20775159.html
http://it-idiot.einsamsoldat.net/200...omment-page-1/

There are linux visual basic interpretors (mono), so you don't need wine for that either. However, you may find there is already a linux program which does the same or similar-enough job.
http://www.linuxdevices.com/news/NS9725385854.html

Simon Bridge, Mono would be a c# (and not VB) compiler. Maybe you meant Gambas, but it's not a 1:1 clone of VB, it's close yes, but it's not VB. And anyway, that won't help if he has not the source code to port it adequately and recompile it under linux. If he only has the binary program compiled for windows, then wine is the one and only option, unless he wants to resort to virtualization.

However, I agree that the database should be migrated to mysql. It's the way to go.

joseph, you have two separate problems here.

First, looking into how to set up a mysql server, and migrate the database, and second, get that app running with wine if that's even possible. If the problem with the later is that it can't find some dlls, you can have a chance to get it working by putting these into ~/.wine/drive_c/windows/system32/. If it still doesn't work, then launch winecfg and look for a tab where you can set overrides for the libs your program will need. This tells wine to use native dlls instead of the builtin alternative when possible.

Thanks for the reply guboj,

i am able to migrate the current mysql server (windows 2000) to the linux box and accessible when i am trying to test the connection using the PHP, so i think it is not mysql server's problem, but the odbc driver for the client computer which run through wine.

now the program even cannot start on wine, when double clicking the app, it said access to sql server denied, while the app should show the login form.

I guess the key point there is that you need to connect the underlying unixODBC functionality into wine, I found these:

http://www.winehq.org/pipermail/wine...ly/007349.html
http://www.codeweavers.com/support/d...er/config-odbc

Which are a starting point. Admittedly, I've never used odbc under wine. But I think that you need to run the odbc layer in linux, whichever one you choose, and not on wine.

Mono is primarily supposed to be a cross-platform implimentation of the .NET framework .... the project includes compilers for several languages including C# and Visual Basic (since mono 1.2.3 - Feb last year.).
http://www.linux.com/feature/60360
http://www.mono-project.com/Visual_Basic

Will also run Visual Studio binaries.
http://www.mono-project.com/FAQ:_General

The compiler won't generale CIL 1.0 assemblies (focussed on 2.0) but, as you say, the apps are likely to be binaries, so this won't be a problem. vis:

Visual Basic support in Mono isn't new. Past versions of Mono have bundled a VB runtime component that allows VB applications to run under gnuLinux.

Applications written on Windows," says De Icaza, "with the 1.0 or 2.0 [.Net] frameworks are supported by the runtime

just try unixODBC, but still cannot connect to the sql server ....

try to telnet to the mysql port, it succesfull.

still confusing what is the problem actually

anyone?