Remote MySQL Connection using VB 2005 Express

RivaCom

Is this possible? I know you can do local connections but I have yet
to see a remote connection though VB 2005 express. Can anyone help me
out?

Apr 18 '07 #1

Subscribe Post Reply

2956

zacks

On Apr 18, 9:28 am, Riva...@gmail.com wrote:

Is this possible? I know you can do local connections but I have yet
to see a remote connection though VB 2005 express. Can anyone help me
out?

I have a VB.NET 2005 app that makes connections with MySQL. I use full
blown VS, not VS Express, but surely VS Express supports ODBC
connections? The only rub with MySQL is that you will need to get the
special MySQL ODBC driver. Get it from mysql.com.

Apr 18 '07 #2

zacks

On Apr 18, 9:28 am, Riva...@gmail.com wrote:

Is this possible? I know you can do local connections but I have yet
to see a remote connection though VB 2005 express. Can anyone help me
out?

Oh, and the only thing you need to remember about local as opposed to
remote MySQL connections is that MySQL uses TWO separate usernames for
the same user, one being local, the other being remote.

Apr 18 '07 #3

Similar topics

MySQL ConnectorJ and remote machines

by: Ike | last post by:

Let's say I have a MySQL 4.12 database, opened to the internet on 111.111.111.111 allowing all incoming and outgoing ports. I have a username and password setup, which CAN connect to this database,...

MySQL Database

SQL Server does not allow remote connections

by: 3Dfelix | last post by:

Hi, someone could help me with this problem when trying to insert a record in a SQL express database? I can view record but not edit or insert. When connecting to SQL Server 2005, this failure...

ASP.NET

VB Express SQL Express Remote Connection

by: cleo | last post by:

I am migrating from VB6/Access to Visual Basic and SQL Express. I have success writing test code on my local machine and am now setting up tests for deployment to a server. I have installed SQL...

Visual Basic .NET

Database on remote server

by: Tor Inge Rislaa | last post by:

Database on remote server On the remote server where my ASP.NET application is located there is no SQL Server or SQL Server Express. When I test my application locally it works fine because...

ASP.NET

Failing to connect to remote SQL Server 2000 from ASP.NET 2.0 application

by: tamayi | last post by:

I have a problem (like most others posting issues on this forum :) ) I have a remote server running Windows XP SP2, with both SQL Server 2005 Express with Advanced Features and SQL 2000...

ASP.NET

Re-Connect with Remote SQL Servr 2005 Database

by: BD | last post by:

I am developing C# win form app to work with remote database on SQL Server 2005. Problem scenario is as follows: 1. a form is open that has downloaded dataset to local cache 2. computer is...

C# / C Sharp

connecting vs 2005 to remote SQL server 2000

by: Me LK | last post by:

I did a search but could not find an aswer that worked so here it goes. I just did an upgrade from 2003 to vs 2005 express. I am using a remote sql server 2000. I specifically upgrade to make...

ASP.NET

Connect To Local SQL Server DB From Remote Server

by: RN1 | last post by:

Is it possible to connect to my local SQL Server 2005 database from a remote web server? If yes, what ConnectionString do I use? Thanks, Ron

ASP.NET

An error has occurred while establishing a connection to the server.When connecting to SQL Server 2005, this failure may be caused by the factthat under the default settings SQL Server does not allow remote connections.

by: mina | last post by:

My application which is written in vb.net 2005 uses sql server 2005 express as a database, this application is multi-user. So i am used 3 xp machine to install my application i can say...

.NET Framework

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

Navigating the Data Structures and Algorithms (DSA)

by: BarryA | last post by:

What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...

Algorithms / Advanced Math

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++

How to build RAID in BIOS?

by: Hystou | last post by:

There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...

Computer Hardware

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

Problem With Comparison Operator <=> in G++

by: Oralloy | last post by:

Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...

C / C++

The easy way to turn off automatic updates for Windows 10/11

by: Hystou | last post by:

Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...

Windows Server

AI Job Threat for Devs

by: agi2029 | last post by:

Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...

Career Advice