473,792 Members | 2,877 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Database connectivity using Mysql

Hello,

I am new to .net Platform.
I want to build a sample application using VB.net and backend mysql.
now my problem is how to connect to the mysql database.
which is the better provider( oledb or odbc).
can you give any sample program.
I am using VS 2005.

Thanks in advance

Regards
Shun
Aug 23 '06 #1
2 2161
Hi Shun

Take a look on the mysql.com website as they have released a mySQL
connector specifically for .Net 2 (which I've briefly used with no
problems) - if you search on their site for Connector.Net you should
find it quite easily.

Cheers
Martin

Shun wrote:
Hello,

I am new to .net Platform.
I want to build a sample application using VB.net and backend mysql.
now my problem is how to connect to the mysql database.
which is the better provider( oledb or odbc).
can you give any sample program.
I am using VS 2005.

Thanks in advance

Regards
Shun
Aug 23 '06 #2

"Shun" <sh**********@g mail.comwrote in message
news:u2******** ******@TK2MSFTN GP05.phx.gbl...
Hello,

I am new to .net Platform.
I want to build a sample application using VB.net and backend mysql.
now my problem is how to connect to the mysql database.
which is the better provider( oledb or odbc).
can you give any sample program.
I am using VS 2005.
Hi,

I am using MySQL in VS2005 (not with VB.net but with Chrome, but that does
not make any difference) and it works fine...
You can download an ADO.net connector here :
http://dev.mysql.com/downloads/connector/net/5.0.html
Here is a tutorial about using MySQL in VB.net :
http://www.vbmysql.com/articles/vbdo...torial-part-3/

Best Regards,

Jeroen Vandezande
Aug 23 '06 #3

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

Similar topics

13
3410
by: SectorUnknown | last post by:
I've written a database (Access mdb) front-end using Python/wxpython/and ADO. However, the scope of the project has changed and I need to access the same data on an MSSQL server. Also, the front-end needs to be cross- platform (Windows and Linux). Does anyone have any suggestions on what database connectivity I should use? I've looked at mxODBC and wxODBC briefly, but am not sure what is the best way to go. BTW, although I would love...
1
2444
by: harish | last post by:
I am using java applications to connect to my MS SQL Server database. I am using ODBC for database connectivity. If i am running my java applications in a remote PC and try to connect to database server, unless i login to the serer, i am unable to connect to database. If a login to database server with it's username and password, then the database is getting connected. It is not correct to login to database server for database...
3
2106
by: junaid | last post by:
Hi to all, Can it is possible to connect to the databse like postgre or mysql through a C programm? I know the basics of C and I have developed a small program which uses a file for the repositary of the data.But I want to use a database for this, insted of file. If possible please give some Code snippets for the connectivity as well as how to run the queries.
3
3492
by: Niks | last post by:
Hi, I need to connect to SQL server Database using a System DSN. Can anyone tell me how to connect to SQL Server using DSN in ASP.NET (VB.Net). Using a Try Catch block. Does anyone know how to create a "filename.DSN" file. I know how to create a system DSN, but my N/W admin has asked me to create a DSN file to send him. which would be a file name with ".DSN" extension, so that he can place it on the server.
5
1311
by: Steven Caliendo | last post by:
Hi, I have a MySQL database on a remote server that I need to connect to. I can't seem to figure out what the connectionstring should be? I've searched through the help files, but all I can find is information for SQL server. Thanks, Steve
47
2474
by: Ivan Weiss | last post by:
Hi all, I am just getting started on a new app and am a rusty VB6 guy who is looking to create something on the side to serve as a corporate workbench for my company. ADO.net is new to me so I have some books and need to do some learning but I am seeing a few different ways to get started. Would you recommend going with the controls built into Visual Studio,
8
6337
by: cvijaykrishna | last post by:
hi can i connect database using (client side )javascript. pls send me a sample code. so that it would be very much helpfull.
0
1246
by: dalaimanoj | last post by:
I have a form with buttons 'View', 'Save', 'Delete', 'Edit' and some textboxes to input data.. On clicking each buttons the database is connected and the respective action is done. For example clicking on Save button inserts records, clicking on Delete button delete the specified record and clicking on View button the record from database table is fetched etc. So my question is 1. Should I write the database connectivity code and the...
1
1796
by: bharathlvn05 | last post by:
hi ,my name is bharath my question is... How to connect An Ajax application to database(sybase or sql) using servlts or jsp..but not using php and asp..
0
9670
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, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...
0
9518
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 effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
0
10430
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, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
0
10211
jinu1996
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 tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
1
7538
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 presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
6776
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
0
5436
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
0
5560
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
4111
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system

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.