Why when I use all of the sample code to create a DSN does it always return a 0? (nRet = SQLConfigDataSource(vbAPINull, ODBC_ADD_DSN, sDriver, sAttributes)) What does 0 mean.
Also, My real goal is to set an Access Database that is currently "linked" to a SQL Server database via a dsn easy to distrabute and manage. The connection string can not be exposed so that is why I chose a DSN. I would most likely compile a dll and have the DSN creation and connection string in there upon the first open of the Access database or distrabuted updates of the dll.
Thanks...
Also, My real goal is to set an Access Database that is currently "linked" to a SQL Server database via a dsn easy to distrabute and manage. The connection string can not be exposed so that is why I chose a DSN. I would most likely compile a dll and have the DSN creation and connection string in there upon the first open of the Access database or distrabuted updates of the dll.
Thanks...
