Actually the data source isWhat driver did you select when testing this connection via Visual Studio?
Perhaps you should try using anOdbcConnection
instead of aSqlConnection
. The connection string for an ODBC connection should look like what you are using for VBA and R.
What driver did you select when testing this connection via Visual Studio?
Perhaps you should try using anOdbcConnection
instead of aSqlConnection
. The connection string for an ODBC connection should look like what you are using for VBA and R.