Using Variables Globally

P

Penstar

Dim Cnxn As ADODB.ConnectionDim strCnxn As String
Dim strSQL As String
Dim intEventID As Integer
Dim str2 As String

' Open connection
'Set Cnxn = CurrentProject.AccessConnection

Set Cnxn = New ADODB.Connection
strCnxn = "DRIVER = {MySQL ODBC 3.51
Driver};Server=localhost;DSN=ttime;Database=ttime;User=ttime;Password=mkghgfr;Option=3;"
Cnxn.Open strCnxn
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Lookup value from another table ado. 3
Connection string issues 9
ADODB Timeout 0
ADO Connection problem when not logged in as an Admin 3
ADO - Add Item to combo box 1
ADO Connection 12
Could my ADODB connection be causing a network problem? 2
Execute Stored procdure, no results show up 2

Top