PRB: File DSN and DSN-Less Connections May Fail with Localized ODBC

WORKAROUND

• Change the driver description used in the file DSN or DSN-less connection so that it matches the one on the client computer.
  
  -or-
• Install the driver again on the client computer with the description used in the connect string. Note that using this option will result in more than one description for the same driver, which will allow any program using any one of the localized descriptions to connect through the driver on the client.

   #include <windows.h>
   #include <stdio.h>
   #include <odbcinst.h>

   void ShowErrors ()
   {
      WORD     iError = 1;
      DWORD pfErrorCode;
      char     lpszErrorMsg[301];
      WORD     cbErrorMsgMax = 300;
      RETCODE  rc;

      while (SQL_NO_DATA != (rc = SQLInstallerError(
               iError ++,
               & pfErrorCode,
               lpszErrorMsg,
               cbErrorMsgMax,
               NULL )))
         if (rc == SQL_SUCCESS || rc == SQL_SUCCESS_WITH_INFO)
            printf( "%s\n", lpszErrorMsg);

      printf ("\n");
   }


   void main ()
   {
      char *    szDriver = "SQL
   Server\0Driver=sqlsrv32.dll\0Setup=sqlsrv32.dll\0\0";
      char *    szPathIn = "c:\\winnt\\system32";
      char   szPathOut[301];
      WORD   cbPathOutMax = 300;
      WORD   cbPathOut;
      DWORD dwUsageCount;

      printf ("Calling SQLInstallDriverEx ...\n");
      if (!SQLInstallDriverEx(
            szDriver,
            szPathIn,
            szPathOut,
            cbPathOutMax,
            & cbPathOut,
            ODBC_INSTALL_COMPLETE,
            & dwUsageCount))
         ShowErrors ();

      printf ("Calling SQLConfigDriver ...\n");
      if (!SQLConfigDriver(
            NULL,
            ODBC_INSTALL_DRIVER,
            "Microsoft Access - test 4",
            "",
            szPathOut,
            cbPathOutMax,
            & cbPathOut))
         ShowErrors ();
   }