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

Do you like this post? Please link back to this article by copying one of the codes below.

URL:

HTML link code:

BB (forum) link code: