LinuxQuestions.org
Visit Jeremy's Blog.
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Software
User Name
Password
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


Reply
  Search this Thread
Old 03-29-2009, 10:44 PM   #1
joseph
Member
 
Registered: Jun 2003
Location: Batam
Distribution: Ubuntu 10 And Linux Mint
Posts: 414

Rep: Reputation: 30
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
 
Old 03-30-2009, 12:02 AM   #2
Simon Bridge
LQ Guru
 
Registered: Oct 2003
Location: Waiheke NZ
Distribution: Ubuntu
Posts: 9,211

Rep: Reputation: 198Reputation: 198
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
 
Old 03-30-2009, 01:28 AM   #3
i92guboj
Gentoo support team
 
Registered: May 2008
Location: Lucena, Córdoba (Spain)
Distribution: Gentoo
Posts: 4,083

Rep: Reputation: 405Reputation: 405Reputation: 405Reputation: 405Reputation: 405
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.
 
Old 03-30-2009, 03:27 AM   #4
joseph
Member
 
Registered: Jun 2003
Location: Batam
Distribution: Ubuntu 10 And Linux Mint
Posts: 414

Original Poster
Rep: Reputation: 30
Quote:
Originally Posted by i92guboj View Post
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.
 
Old 03-30-2009, 04:37 AM   #5
i92guboj
Gentoo support team
 
Registered: May 2008
Location: Lucena, Córdoba (Spain)
Distribution: Gentoo
Posts: 4,083

Rep: Reputation: 405Reputation: 405Reputation: 405Reputation: 405Reputation: 405
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.
 
Old 03-30-2009, 08:48 PM   #6
Simon Bridge
LQ Guru
 
Registered: Oct 2003
Location: Waiheke NZ
Distribution: Ubuntu
Posts: 9,211

Rep: Reputation: 198Reputation: 198
Quote:
Originally Posted by i92guboj View Post
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
 
Old 03-30-2009, 08:50 PM   #7
joseph
Member
 
Registered: Jun 2003
Location: Batam
Distribution: Ubuntu 10 And Linux Mint
Posts: 414

Original Poster
Rep: Reputation: 30
Quote:
Originally Posted by i92guboj View Post
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.
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?
 
  


Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off



Similar Threads
Thread Thread Starter Forum Replies Last Post
Stupid Question: Microsoft Visual Studio 6.0 (A.K.A. Visual Basic 6) Will it run? S0RD3N Linux - Software 8 05-07-2008 08:42 PM
Is there a program for programing in Linux similar to Visual Basic ?? Xeratul Linux - Software 3 07-12-2006 06:35 AM
running Visual Basic/Visual Fox Pro in Linux? depam Linux - Software 9 02-11-2006 03:42 PM
Visual Basic like program for Linux shortname Linux - Software 1 02-07-2005 08:12 PM
Is there Visual Basic 4 Linux? torresma Linux - Software 1 11-16-2004 04:42 PM

LinuxQuestions.org > Forums > Linux Forums > Linux - Software

All times are GMT -5. The time now is 08:47 PM.

Main Menu
Advertisement
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
Open Source Consulting | Domain Registration