MySQL and BLOBs - Connection Object

(Page 3 of 6 )

Now that we have a connection string, we can connect to the database. First I will give a sample of how I connect.

Dim conn As ADODB.Connection
Set conn = New ADODB.Connection
conn.ConnectionString = GloConnectionString
conn.CursorLocation = adUseClient
conn.Open

In the first line we create an ADODB connection object in memory and in the second line we instantiate it. The alternative syntax to this is to type:

 Dim conn As New ADODB.Connection

While I previously recommended the 'as New' syntax, I have since learned that it slows down your code since it must check if the object is instantiated every time a reference is made to the object.

In the second line we set the Connection String of our Connection object to the global variable we specify in the login prompt. Conversely, you can always place the connection string here. In the third line we set the connection to use client-side cursors. I have found that this setting helps to prevent a lot of problems that can pop up while programming ADO with MySQL (for more details on cursorlocation, cursortype, and locktype, see http://www.vbmysql.com/articles/cursorsandlocks.html.) In the final line we open the connection object, which we will of course have to close when we are finished with conn.close.

Next: Sending Data Into the BLOB Column >>
 

More MySQL Articles
More By Mike Hillyer

Comments On: MySQL and BLOBs

· "mystream.Write rs!file"should be:mystream.Write rs.Fields(0).Value   >>> Post your comment now!