Clients Area

"It appears that the database was not initially populated with data" error message Print

  • Error Message, Database Error, Importing Exporting Backing up Data
  • 13

Symptoms:

       - Error message pops up in SixBit stating the database is not populated.

       - Cannot select the database in the Open Database dialog box using SQL Authentication

       - You can log into SQL Server Management Studio with Windows Authentication but not using SQL Authentication.

       - A database exists on the SQL Server with only system tables in it.

Possible causes:

The Windows ODBC Driver is not installed for the version of SQL Server you are working with.  Chances are that one of the following has happened:

-       The 64-bit ODBC driver was installed, but not the 32-bit driver for whichever version of SQL Server you are working with.

-       The ODBC driver was not installed at all during the upgrade.

Troubleshooting:

64-bit and 32-bit systems:

-       Open Control Panel | Administrative Tasks | Data Sources.  Click on the driver's tab. 

-       Check to see which SQL Server Native Client is installed.  If your version's driver is missing, see the Solutions section of this document.

32-bit troubleshooting ends here, 64-bit continues on:

-       Close the already open control panel if you have not already done so. (important!  The next step will fail if you do not close the control panel)

-       Start | Run | %systemdrive%\Windows\System32\odbcad32.exe  (This opens the 32-bit ODBC control panel)

-       Check that the 32-bit SQL Server Native Client for your SQL version is installed.  If it is missing, see the Solutions section of this document.

Solution:

-       Download the ODBC driver for your version of SQL Server and install it.

Additional Information:

Common SQL Server version numbers include:

-       10.0 (SQL Server 2008)

-       10.5 (SQL Server 2008 R2)

-       11.0 (SQL Server 2012)

-       See http://support.microsoft.com/kb/321185 for a full list if needed.

The 32-bit version of the Odbcad32.exe file is located in the %systemdrive%\Windows\SysWoW64 folder.
The 64-bit version of the Odbcad32.exe file is located in the %systemdrive%\Windows\System32 folder.


Was this answer helpful?

« Back

© 2023 SixBit Software. All rights reserved.