Ad:

VB.NET Discussion Thread
Unsolved
Views: 901

Dec 8th, 2008

Error connecting to MySql

Expand Post »

hello everyone, i need to make a program that will show/load the images stored in mysql database, i've already created the database and my problem is i can't load it in my vb code....

here's my code below

Dim conn As MySqlConnection
'connect to database
conn = New MySqlConnection()
conn.ConnectionString = "server = localhost; id = root; password = mypass; database=face manager"

Try
conn.Open()
Catch myerror As MySqlException
MsgBox("Error connecting to database")
End Try

'sql query
Dim myAdapter As New MySqlDataAdapter

Dim sqlquery = "SELECT * FROM eyes"
Dim myCommand As New MySqlCommand()
myCommand.Connection = conn
myCommand.CommandText = sqlquery

'start query
myAdapter.SelectCommand = myCommand
Dim myData As MySqlDataReader
myData = myCommand.ExecuteReader()

thanks, i need any response

Similar Threads

[MySQL][ODBC 3.51 Driver]Can't connect to MySQL server 10060 in Visual Basic 4 / 5 / 6
error in connecting MySql and PHPBB help me..... in MySQL
Problems connecting to MySQL in IT Professionals' Lounge
Problems using a php generator in PHP
hit another brick wall, mysql :S in PHP

cutieann12

Reputation Points: 10

Solved Threads: 0

Newbie Poster

Offline

7 posts
since Nov 2008

Permalink

Dec 8th, 2008

Re: Error connecting to MySql

For some reason I didn't get DataReader to work. But with DataAdapter and DataSet I got images from DB. I used SQL Server but that shouldn't make any difference.

VB.NET Syntax (Toggle Plain Text)
'start query
' Declare a DataSet object
Dim Images As New DataSet()
 
myAdapter.Fill(Images, "Eyes")
' With DataAdapter you can close connection, with DataReader you have to keep connection open and close it at the end
conn.Close()
 
' Buffer to hold image data
Dim ByteArr() As Byte
Dim ImageIndex As Integer
Dim i As Integer
 
ImageIndex = 0 ' Column index of images, set the right value in here
 
' Loop all rows
For i = 0 To Images.Tables(0).Rows.Count - 1
  ' Read a BLOB to buffer
  ByteArr = CType(Images.Tables(0).Rows.Item(i).Item(ImageIndex), Byte())
  ' Create a memory stream of the buffer
  Dim ImageStream As New MemoryStream(ByteArr)
  ' Get the image from the memory stream
  PictureBox1.Image = Image.FromStream(ImageStream)
  ' "Refresh" display
  Application.DoEvents()
  ' Wait 3 seconds
  System.Threading.Thread.Sleep(3000)
Next i
'start query
' Declare a DataSet object
Dim Images As New DataSet()

myAdapter.Fill(Images, "Eyes")
' With DataAdapter you can close connection, with DataReader you have to keep connection open and close it at the end
conn.Close()

' Buffer to hold image data
Dim ByteArr() As Byte
Dim ImageIndex As Integer
Dim i As Integer

ImageIndex = 0 ' Column index of images, set the right value in here

' Loop all rows
For i = 0 To Images.Tables(0).Rows.Count - 1
  ' Read a BLOB to buffer
  ByteArr = CType(Images.Tables(0).Rows.Item(i).Item(ImageIndex), Byte())
  ' Create a memory stream of the buffer
  Dim ImageStream As New MemoryStream(ByteArr)
  ' Get the image from the memory stream
  PictureBox1.Image = Image.FromStream(ImageStream)
  ' "Refresh" display
  Application.DoEvents()
  ' Wait 3 seconds
  System.Threading.Thread.Sleep(3000)
Next i

You also have to import System.IO namespace to use memory stream.

Teme64

Reputation Points: 218

Solved Threads: 201

Veteran Poster

Offline

1,024 posts
since Aug 2008

Permalink

Dec 11th, 2008

Re: Error connecting to MySql

Hi!

Just verify these-

Do you have the MySQL Connector installed?

Are you sure your connection string is correct?

tuse

Reputation Points: 32

Solved Threads: 14

Junior Poster

Offline

173 posts
since Jul 2007

Permalink

Dec 11th, 2008

Re: Error connecting to MySql

Click to Expand / Collapse Quote originally posted by tuse ...

Hi!

Just verify these-

Do you have the MySQL Connector installed?

Are you sure your connection string is correct?

Yes, i have installed MySql Connector Net version 1.0.10.1 and the connection string was correct..

cutieann12

Reputation Points: 10

Solved Threads: 0

Newbie Poster

Offline

7 posts
since Nov 2008

Permalink

Dec 11th, 2008

Re: Error connecting to MySql

try this connection string-

VB.NET Syntax (Toggle Plain Text)

Server=myServerAddress;Database=myDataBase;Uid=myUsername;Pwd=myPassword;

tuse

Reputation Points: 32

Solved Threads: 14

Junior Poster

Offline

173 posts
since Jul 2007

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.

Previous Thread in VB.NET Forum Timeline: Teach Me a Comeback to Visual Basic.net Programming

Next Thread in VB.NET Forum Timeline: Is it worth getting Visual Basic Professional Edition?

DaniWeb Message

Cancel Changes

User Name
Password