Accessing MySQL on Linux from Window

zMisc

Is it possible to have a visual basic application running under windows and
access MySQL database on a Linux box?

Any extra drivers required for this?

Any help greatly appreciated.

Tks
John

Jan 27 '06 #1

Subscribe Post Reply

1601

Bill Karwin

"zMisc" <yo********@hotmail.com> wrote in message
news:L9********************@news-server.bigpond.net.au...

Is it possible to have a visual basic application running under windows
and access MySQL database on a Linux box?

Any extra drivers required for this?

Yes, you can use an ODBC datasource to access from VB a client/server
database on another host, such as MySQL on Linux.

You need the MySQL Connector/ODBC. There are lots of docs available here:
http://dev.mysql.com/doc/refman/5.0/...connector.html

You need to install the MySQL ODBC driver on your Windows PC, and then your
VB application can use that via ADO or whatever. The SQL requests are sent
by the ODBC driver to the MySQL server, and result sets are returned to the
VB application.

Regards,
Bill K.

Jan 27 '06 #2

Similar topics

Failed install of DBD::mysql

by: Randell D. | last post by:

Folks, I have installed MySQL v4 (client, server and development rpm's). I've tried and failed to use the recommended mysqladmin to set a root password after the installation (I have another post...

Perl

Mysql won't install (crashes) on Red Hat Enterprise Linux 3 Beta 1 (Taroon)

by: Eric Raymond | last post by:

When installing the rpms (or the tar file) onto Red Hat Enteprise Linux AS Beta 1 (Taroon), we get the follwing error: Installing all prepared tables /usr/bin/mysql_install_db: line 1: 7690...

MySQL Database

MySQL Installation Challenges

by: Chris Moy | last post by:

SEND-PR: -*- send-pr -*- SEND-PR: Lines starting with `SEND-PR' will be removed automatically, as SEND-PR: will all comments (text enclosed in `<' and `>'). SEND-PR: From: moyc To:...

MySQL Database

Error 1130 when accessing MySQL from another IP??

by: Spare Brain | last post by:

Hi, I am trying to run the MySQL DB on a Linux machine that is part of a home LAN (IP=192.168.0.3), while trying to access it from another WinXP machine (IP=192.168.0.5). I keep getting the...

MySQL Database

How to connect to Linux MySql via syncLog?

by: Nick | last post by:

hi, all, I have a window mysql verison, which works really well with SyncLog. Now I have a vm linux, and install MySql4.0 server on it. I can use command line, mysql-administrator to access it...

MySQL Database

User Admin in mysql-administrator slow on Linux

by: timothy.williams | last post by:

Hi. We have a MySQL 5.0.16 server installed on a RedHat 8.0 machine. mysql-administrator v1.0.22 is installed on RH Linux FC3 from the mysql-administrator-1.0.22a-1.rh9.i386.rpm. Everything...

MySQL Database

can't install / uninstall MySQL

by: pc | last post by:

hi everyone, we have a server on which someone blew away the MySQL 4 progs directory before installing MySQL 5. When installing MySQL 5 the installation failed with an error stating that it was...

MySQL Database

I want to make transfer data between MySQL Server to MySQL Local .

by: Pratchaya | last post by:

Hi, All I want to make transfer data between MySQL Server to MySQL Local . My Environment. Server < --- > My PC Client Server = ::::: MySQL DB Server ( for Linux )

PHP

Connecting to MySQL over a network? How?

by: coolsti | last post by:

What I actually really want to do is to access my MySQL database running on Linux from C# programs running on Windows on the same network. As a first step, I am simply trying to connect to my...

MySQL Database

Easy Steps to Fix "Canon Printer Won't Connect to WiFi Network"

by: taylorcarr | last post by:

A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...

General

How to turn on java script in a villaon keypad mobile phone

by: Charles Arthur | last post by:

How do i turn on java script on a villaon, callus and itel keypad mobile phone

Java

Basic Javascript concepts

by: aa123db | last post by:

Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...

Javascript

Merging data from multiple Excel files

by: ryjfgjl | last post by:

In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...

Data Management

Looking to do Android software development, any suggestions? Is flutter better?

by: nemocccc | last post by:

hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?

General

Is that possible of reading the .csv file in column wise and the column have different lengths ?

by: Sonnysonu | last post by:

This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...

C / C++

What is ONU?

by: marktang | last post by:

ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...

General

Changing the language in Windows 10

by: Hystou | last post by:

Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...

Windows Server

Maximizing Business Potential: The Nexus of Website Design and Digital Marketing

by: jinu1996 | last post by:

In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...

Online Marketing