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

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.

  • Error Message, Database Error, Importing Exporting Backing up Data
  • 12 Users Found This Useful
Was this answer helpful?

Related Articles

After Import, Sales are Linked to the Wrong Item

Symptom After an import from eBay, some sales are created showing the wrong picture and are...

Creating a SQL Server Database with Blackthorne Basic

Background:To import a Blackthorne database into SixBit, it must be a SQL Server database.  This...

Import from CSV is not Importing Any Items

Symptom:After importing from CSV, the items do not appear anywhere in SixBit. Cause:   The...

Importing an Access Database from Blackthorne

Overview: Blackthorne users can use either an Access database or a SQL Server database. SixBit...

Importing From Multiple eCommerce Sites Handling

A big portion of setting up SixBit to work with multiple eCommerce sites involves defining or...