Function QODBCConnect

Places your connection string into a one-word function. You will see this function throughout this site.



Details


Why try to remember that QODBC connection string? Place it in a function and forget about it.



Code


Function QODBCConnect() As String
'make the QODBCConnect string equal to whatever your connection string is
QODBCConnect = "ODBC;DSN=QuickBooks Data;SERVER=QODBC"
End Function



How to Use


Instead of typing something like this:

        qDef.connect = "ODBC;DSN=QuickBooks Data;SERVER=QODBC"

Type This:

        qDef.connect = QODBCConnect

Popular Posts