Matt,
Here is how we are using this:
Code:
ODBCSQL('Loan Data','PROD\PD_PROD','Users')
So, to break this down:
'Loan Data' - Name of the DSN that shows in the ODBC Connectors
'PROD\PD_PROD' - Name of Server \ Instance
'Users' - Database Name
This creates a system-wide DSN Called "Loan Data".
If you want to create this a user DSN, then do:
Code:
ODBCSQL('Loan Data','PROD\PD_PROD','Users',1)
And this creates the DSN for the logged in user.
Kent
