Linux - SoftwareThis forum is for Software issues.
Having a problem installing a new program? Want to know which application is best for the job? Post your question in this forum.
Notices
Welcome to LinuxQuestions.org, a friendly and active Linux Community.
You are currently viewing LQ as a guest. By joining our community you will have the ability to post topics, receive our newsletter, use the advanced search, subscribe to threads and access many other special features. Registration is quick, simple and absolutely free. Join our community today!
Note that registered members see fewer ads, and ContentLink is completely disabled once you log in.
If you have any problems with the registration process or your account login, please contact us. If you need to reset your password, click here.
Having a problem logging in? Please visit this page to clear all LQ-related cookies.
Get a virtual cloud desktop with the Linux distro that you want in less than five minutes with Shells! With over 10 pre-installed distros to choose from, the worry-free installation life is here! Whether you are a digital nomad or just looking for flexibility, Shells can put your Linux machine on the device that you want to use.
Exclusive for LQ members, get up to 45% off per month. Click here for more info.
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
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.
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.
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.
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.
just try unixODBC, but still cannot connect to the sql server ....
LinuxQuestions.org is looking for people interested in writing
Editorials, Articles, Reviews, and more. If you'd like to contribute
content, let us know.