473,473 Members | 1,959 Online
Bytes | Software Development & Data Engineering Community
Create Post

Home Posts Topics Members FAQ

MySQL and MyOleDB

I have installed MySql and am trying to use it in VB.Net 2003 using the
MyOleDb driver. However, from all I can find, MyOleDb only works on VB.Net
2005. Does anyone know if this is correct or is it supposed to work in
VB.Net 2003 as well?
--
Dennis in Houston
Dec 24 '06 #1
5 5569
Dennis,

I would use the MySql dot net connector. There is a vs 2003 and
vs 2005 version.

http://dev.mysql.com/downloads/connector/net/1.0.html

http://dev.mysql.com/downloads/connector/net/1.0.html

http://dev.mysql.com/downloads/connector/net/5.0.html

There is also a VS 2005 plug in available.

http://dev.mysql.com/downloads/visua...lugin/1.0.html

Ken
----------------------

"Dennis" <De****@discussions.microsoft.comwrote in message
news:A0**********************************@microsof t.com...
>I have installed MySql and am trying to use it in VB.Net 2003 using the
MyOleDb driver. However, from all I can find, MyOleDb only works on
VB.Net
2005. Does anyone know if this is correct or is it supposed to work in
VB.Net 2003 as well?
--
Dennis in Houston
Dec 24 '06 #2
I would but my specific requirements are to develop an application that by
changing the connection string but using the same Data Access Layer, runs
with either MySql or Access or SQL Express and OleDB seemed to be the way to
do it. Is this even possible.
--
Dennis in Houston
"Ken Tucker [MVP]" wrote:
Dennis,

I would use the MySql dot net connector. There is a vs 2003 and
vs 2005 version.

http://dev.mysql.com/downloads/connector/net/1.0.html

http://dev.mysql.com/downloads/connector/net/1.0.html

http://dev.mysql.com/downloads/connector/net/5.0.html

There is also a VS 2005 plug in available.

http://dev.mysql.com/downloads/visua...lugin/1.0.html

Ken
----------------------

"Dennis" <De****@discussions.microsoft.comwrote in message
news:A0**********************************@microsof t.com...
I have installed MySql and am trying to use it in VB.Net 2003 using the
MyOleDb driver. However, from all I can find, MyOleDb only works on
VB.Net
2005. Does anyone know if this is correct or is it supposed to work in
VB.Net 2003 as well?
--
Dennis in Houston
Dec 24 '06 #3
I would set it up to have an option the user chooses in some way shape or
form the backend they are using, and then have a case statement that handles
their choice. Implement the best drivers within your project for each kind
of database that could be possibly used so that all choices are covered.
"Dennis" <De****@discussions.microsoft.comwrote in message
news:41**********************************@microsof t.com...
>I would but my specific requirements are to develop an application that by
changing the connection string but using the same Data Access Layer, runs
with either MySql or Access or SQL Express and OleDB seemed to be the way
to
do it. Is this even possible.
--
Dennis in Houston
"Ken Tucker [MVP]" wrote:
>Dennis,

I would use the MySql dot net connector. There is a vs 2003
and
vs 2005 version.

http://dev.mysql.com/downloads/connector/net/1.0.html

http://dev.mysql.com/downloads/connector/net/1.0.html

http://dev.mysql.com/downloads/connector/net/5.0.html

There is also a VS 2005 plug in available.

http://dev.mysql.com/downloads/visua...lugin/1.0.html

Ken
----------------------

"Dennis" <De****@discussions.microsoft.comwrote in message
news:A0**********************************@microso ft.com...
>I have installed MySql and am trying to use it in VB.Net 2003 using the
MyOleDb driver. However, from all I can find, MyOleDb only works on
VB.Net
2005. Does anyone know if this is correct or is it supposed to work in
VB.Net 2003 as well?
--
Dennis in Houston

Dec 24 '06 #4
Hi,

http://msdn.microsoft.com/library/de.../html/daab.asp

Ken
------------------------
"Dennis" <De****@discussions.microsoft.comwrote in message
news:41**********************************@microsof t.com...
>I would but my specific requirements are to develop an application that by
changing the connection string but using the same Data Access Layer, runs
with either MySql or Access or SQL Express and OleDB seemed to be the way
to
do it. Is this even possible.
--
Dennis in Houston
"Ken Tucker [MVP]" wrote:
>Dennis,

I would use the MySql dot net connector. There is a vs 2003
and
vs 2005 version.

http://dev.mysql.com/downloads/connector/net/1.0.html

http://dev.mysql.com/downloads/connector/net/1.0.html

http://dev.mysql.com/downloads/connector/net/5.0.html

There is also a VS 2005 plug in available.

http://dev.mysql.com/downloads/visua...lugin/1.0.html

Ken
----------------------

"Dennis" <De****@discussions.microsoft.comwrote in message
news:A0**********************************@microso ft.com...
>I have installed MySql and am trying to use it in VB.Net 2003 using the
MyOleDb driver. However, from all I can find, MyOleDb only works on
VB.Net
2005. Does anyone know if this is correct or is it supposed to work in
VB.Net 2003 as well?
--
Dennis in Houston
Dec 26 '06 #5
sng
myoledb_Colibri3.exe

I have try this Oledb it work with framework 1.1 or vs 2003 and dreamweaver the connection object does not show properly but it works.

but i am unable locate the web site that was downloaded

http://sourceforge.net/project/shown...ease_id=425929

myoledbWIX-3.9.6.msi this one works with mysql 5.0 and asp.net 2.0
---
Posted via DotNetSlackers.com
Mar 21 '07 #6

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

0
by: Larry Lowry | last post by:
Well I'm new to MySql (coming from MS SQL Server) but I like what I see. I'm running 4.1.0. Problem is it seems that MySql is developing along real well but the MyOLEDB driver is stuck and going...
4
by: mikey | last post by:
Hi all, I'm having great problems trying to install the latest MySQl RPM package onto my Red Hat Linux OS. There is already MySQL v 3.0 pre-installed with the RH Linux distribution disk but I...
0
by: Eliecer | last post by:
I have a VB6 program that connects with a MySQL 4.0.17 through MyOLEDB Provider v3.0. At the begining of the program, when I try to connect with the MySQL server and this one is not running,...
2
by: Iaiken | last post by:
I am using vb.net and the myoledb provider. I've run into a problem where what I need to do is open a database connection to a mysql server, easy. The problem arrises in that I want to, if...
13
by: John | last post by:
First I'll answer "why". Because, while SQL Server is available, it is also "expensive". MySQL is CHEAP and a lot more robust than Access. Is there a way to add, update, retrieve, and delete...
5
by: Tim Bücker | last post by:
Hello. I am trying to get a connection to MySQL using OleDb but it seems that I am making something wrong. I´ve found this source in the net but it doesn´t work for me: ...
2
by: zMisc | last post by:
I am using VB.NET 1.1 and cannot connect to a MySQL (v5) database. I've done the following: 1) Create a DSN for MyODBC. 2) Connect using: Driver=MySQL ODBC 3.51 Driver; Server=localhost; Data...
1
by: Art | last post by:
After extensive searching I have come to an apparent dead end. I need to access a MySql database from C#. ODBC makes this very easy however not every customer is running MySql so I want to...
3
by: Toni | last post by:
I want to use asp.net & mysql. I am trying to download mysql db and tools from www.mysql.com but i can find everything what I need. Can somebody tell me where I can download DB, Tools, OleDB...
0
marktang
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,...
0
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...
0
Oralloy
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,...
1
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...
0
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
0
agi2029
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,...
1
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new...
0
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
0
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.