VBA MySQL .NET connector

[Dustman]

I've used the .net connector for MySQL before with VB .net.. but it doesn't seem to work with VBA. Anybody know if this is true? I'm trying to connect with Outlook 2003 VBA.

-Dustin
Rom 8:28

 

[SkipVought]

Hi,

Check out ADO Data objects to access the MYSQL.

Skip,

_[red][/red]

 

[Dustman]

I've done it before with ODBC.. isn't that the same thing? I love the ability of the .net connect because all i have to do is build my sql statement and go.. I really didn't want to have to create a DSN or anything.

-Dustin
Rom 8:28

 

[SkipVought]

http://www.carlprothman.net/Default.aspx?tabid=81

http://www.connectionstrings.com/

Something like this...

    Dim sConn As String, sSQL As String, sServer As String
    Dim rst As ADODB.Recordset, cnn As ADODB.Connection
    
    Set cnn = New ADODB.Connection
    
    sServer = "DWPROD"
    cnn.Open "Driver={Microsoft ODBC for Oracle};" & _
               "Server=" & sServer & ";" & _
               "Uid=;" & _
               "Pwd="
    
    Set rst = New ADODB.Recordset
    
    sSQL = "SELECT Sum(A.STKITQTY_233+A.STKOHQTY_233+A.QTYONDOK_233) AS Inv_Qty "
    sSQL = sSQL & "FROM FRH_MRP.PSK02233 A "
    sSQL = sSQL & "Where A.PARTNO_201='" & Trim(sPN) & "' "
    sSQL = sSQL & "  And STORETYP_233<>'W' "
    
    rst.Open sSQL, cnn, adOpenStatic, adLockReadOnly, adCmdText
.....

Skip,

_[red][/red]