473,503 Members | 1,772 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

VB.NET 2005, MYSQL Problem

16 New Member
Dear All,

I have been trying this for a few days now but still not able to find a proper solution to this problem.
I am trying to connect to MYSQL database through VB.NET 2005 bt i am facing a problem. The Code I am using is as follows :-

************************************************** *****
Dim mySQLConnString As String
Dim mySQLConn As SqlClient.SqlConnection
Dim dbReader As SqlClient.SqlDataReader
Dim dbCmd As SqlClient.SqlCommand = New SqlClient.SqlCommand( _
"SELECT name, rollno,address FROM data where rollno=547")
mySQLConnString = "Provider=MSDASQL;DRIVER={MySQL ODBC 3.51 Driver};Server=localhost;Database=vbtesting;User=t est;Password=test;"
mySQLConn = New SqlClient.SqlConnection(mySQLConnString)
mySQLConn.Open()
dbCmd.Connection = mySQLConn
dbReader = dbCmd.ExecuteReader(CommandBehavior.SingleResult)
Do While dbReader.Read()
TextBox1.Text = dbReader.GetString(0)
TextBox2.Text = dbReader.GetString(1)
TextBox3.Text = dbReader.GetString(2)
Loop
*******************************************

but the error i am getting is (KEYWORD NOT SUPPORTED "PROVIDER") and if I remove Provider then the same error popsup for DRIVER.

Please Help. thanx in advance.

Thanks & Regards
Nrip
May 1 '07 #1
0 826

Sign in to post your reply or Sign up for a free account.

Similar topics

0
6491
by: JL | last post by:
Platform: Linux Red Hat RHEL 3 (and red hat 9) Installed MySQL from source. As a matter of fact, installed all LAMPS from source, and the mysql socket file was arranged in a place other than...
0
3510
by: Lenz Grimmer | last post by:
-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Hi, MySQL 4.0.14, a new version of the popular Open Source/Free Software Database, has been released. It is now available in source and binary...
3
2165
by: Materialised | last post by:
Hello everyone, I am having a issue inserting values into a MYSQL table, and for the life of me, I can figure out why. I know the connection is successful, however I am getting errors. The...
2
2962
by: RivaCom | last post by:
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?
3
1393
by: qu4dman | last post by:
Hi all I would like to program an application with C# Express (for now, because I'll soon use VS.NET 2005 not in "express version") that would use Mysql 5 and Office 2007 in automation (Word,...
0
12869
Coldfire
by: Coldfire | last post by:
Since i cannot show the differences in a two-column like table. I am first putting MS SQL Server 2005 and then MySQL 5.x. MS SQL Server 2005 Brief Overview - SQL Server is a full-fledged...
0
1006
by: lokeya | last post by:
I want to transfer data from MySQL to SQLServer 2005 using Bulkcopy. I referred to this link where i can understand how this can be done if its SQL server DB using SqlConnection, but not across MySQL...
39
5823
by: alex | last post by:
I've converted a latin1 database I have to utf8. The process has been: # mysqldump -u root -p --default-character-set=latin1 -c --insert-ignore --skip-set-charset mydb mydb.sql # iconv -f...
6
1836
rizwan6feb
by: rizwan6feb | last post by:
I have to develop a database application in vb.net 2005 with the following rules 1. The application connects with an online mysql database (i.e database resides on a remote machine) 2. The...
0
7199
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
7076
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
7323
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...
0
7453
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...
1
5005
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
4670
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...
0
3162
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...
0
3151
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
0
1507
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 ...

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.