Linux - Software This 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.
Are you new to LinuxQuestions.org? Visit the following links:
Site Howto |
Site FAQ |
Sitemap |
Register Now
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.
|
 |
03-29-2009, 10:44 PM
|
#1
|
Member
Registered: Jun 2003
Location: Batam
Distribution: Ubuntu 10 And Linux Mint
Posts: 414
Rep:
|
Visual Basic Program On Linux
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
|
|
|
03-30-2009, 01:28 AM
|
#3
|
Gentoo support team
Registered: May 2008
Location: Lucena, Córdoba (Spain)
Distribution: Gentoo
Posts: 4,083
|
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.
Last edited by i92guboj; 03-30-2009 at 01:35 AM.
|
|
|
03-30-2009, 03:27 AM
|
#4
|
Member
Registered: Jun 2003
Location: Batam
Distribution: Ubuntu 10 And Linux Mint
Posts: 414
Original Poster
Rep:
|
Quote:
Originally Posted by i92guboj
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.
|
|
|
03-30-2009, 08:48 PM
|
#6
|
LQ Guru
Registered: Oct 2003
Location: Waiheke NZ
Distribution: Ubuntu
Posts: 9,211
Rep: 
|
Quote:
Originally Posted by i92guboj
Simon Bridge, Mono would be a c# (and not VB) compiler.
|
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
|
|
|
03-30-2009, 08:50 PM
|
#7
|
Member
Registered: Jun 2003
Location: Batam
Distribution: Ubuntu 10 And Linux Mint
Posts: 414
Original Poster
Rep:
|
Quote:
Originally Posted by i92guboj
|
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?
|
|
|
All times are GMT -5. The time now is 06:37 PM.
|
LinuxQuestions.org is looking for people interested in writing
Editorials, Articles, Reviews, and more. If you'd like to contribute
content, let us know.
|
Latest Threads
LQ News
|
|