Vba odbc connection string system dsn
Pavana herb amazon
Create a System DSN in the Control Panel - Administrator Settings - ODBC Data Sources to connect to your DB. Make sure it is a System DSN and not a User DSN. Fill in the proper connection string. Specify a backup connection if required. Test with the Test Connection button. Create the tables using the Create Tables button. Press the OK button.
Mar 22, 2005 · You can create an ODBC connection to a SQL server using LotusScript with the click of a button. I put this button in my About Database document. Code: Option Explicit Private Const REG_SZ = 1 'Constant for a string variable type.