Label Gallery Home - Technical SupportFAQ - SUPPORT FAQ - Database


SUPPORT FAQ - Database

 
Go back to SUPPORT FAQ Main
GENERAL LABEL DESIGN INSTALLATION DATABASE PRINTING
 


1. I cannot use Access 2000 database in Label Gallery.
2. How to use Oracle (MS SQL Server, DB2, Informix...) databases?
3. Locking Paradox databases in multi-user network environment.
4. Using local language characters with dBase databases.
5. Values from Excel worksheet do not appear in Label Gallery; the database-variables are empty.
6. I cannot use data from Microsoft SQL Server 2000.
7. When I use Excel database in GalleryForm the "Database login" dialog box is shown at form start-up but data from Excel does not show.
8. GalleryData freezes at start-up and it cannot be started any more. Re-install does not help either.
9. I cannot use data from FoxPro database tables.
10. I cannot use data from dBase database tables in GalleryForm.
11. How can I convert text file to a real database?
12. Label Gallery keeps displaying the "User Name and Password" login box when connected to an Excel DB file. This problem happens only in Win98 First Edition and is working fine in other platforms such as Windows 2K and Windows XP. How to solve this problem?
13. Gallery Data prompts error message, “Network Initialization Failed” upon creating new database layout.

 
1) I cannot use Access 2000 database in Label Gallery.
Applies to: Label Gallery prior to 1.6

You try to use a database created with Microsoft Access 2000 and receive an error message: Error opening database! General SQL error. The problem occurs because prior versions of MS Access use DAO interface, while Access 2000 uses ADO.

SOLUTION
The problem only occurs when selecting database directly by pointing to the MDB file. To use Access 2000 database in Label Gallery, first define an ODBC data source that points to your database: In Control Panel select ODBC data sources and click on the Add button. Select Microsoft Access Driver (*.mdb) and then define and name the data source to suit your needs. Afterwards you edit (or create new) database function in Label Gallery. On Detailed tab in Database Access dialog box click on the Define button. A Database dialog box appears. Under Driver Type select Microsoft Access Driver (*.MDB). In the Definition box select the data source that you have defined previously.
Back to top
 
2) How to use Oracle (MS SQL Server, DB2, Informix...) databases?
Oracle databases can be used in two different ways in Label Gallery. The first one is a connection via ODBC drivers for your Oracle server, the second one is a direct connection using BDE (Borland Database Engine). The later one is faster and more reliable, but it requires the SQL Links component of BDE to be installed. SQL Links component is not installed by default, but is available as add-on on Label Gallery CD-ROM. You will find the full version of BDE in folder \Updates\BDE.

SOLUTION
Please install the full version of BDE and then follow these steps
1. Start SETUP.EXE from \Updates\BDE\Setup\Disk1 folder on Label Gallery CD-ROM and follow on-screen instructions. This will install the full version of BDE including SQL Links (drivers for enterprise databases). Then run BDE511EN.EXE from \Updates\BDE folder to update the installed BDE to version 5.11.
2. Go to Start.Programs.Label Gallery and start BDE Administrator.
3. Select Databases tab and select Merge configuration from Object menu.
4. Enter *.CNF in File name field and click Open.
5. Select SQL_ORA8.CNF from the list and click Open.
6. Select New from Object menu, select ORACLE for Database Driver Name, click OK.
7. Enter the name of your new alias.
8. In definition of Oracle alias (right side of program window) fill the following fields:
SERVER NAME (enter the name of your Oracle server/database), NET PROTOCOL (probably TNS), LANGDRIVER (set the appropriate language driver),
USER NAME (enter the username you usually use to connect to server)

Also verify the settings DLL32 and VENDOR INIT. They should match your version of Oracle server. Every version of Oracle should be used with its own version of .DLL file.
9. Close the BDE Administrator and save the changes.
10. Now let's verify that alias can connect to the server. Re-open BDE Administrator and select the Oracle alias, you have created in previous steps, right-click it and select Open. Enter the password. If everything is OK, the alias settings should appear in bold font.
11. Close the BDE Administrator and use created alias in Label Gallery. Use command Database access from Data menu, then select New.

The same procedure can be applied to other kinds of enterprise databases as well. Just make sure to select the .CNF file that describes your type of the database and then define the alias accordingly.
Back to top
 
3) Locking Paradox databases in multi-user network environment.
Locking of database files in network environment is important for their consistency. If two or more users are able to simultaneously write to the same database table, they may not be aware of updates to the table some other user has made. Only the changes from the last user who saved the label are preserved and all previous are ignored.

As a solution to these problems, Paradox introduces special locking mechanism that has its use in network environments. It is network control file, PDOXUSRS.NET. The net file contains the users currently using the BDE (Borland Database Engine) and which table they're accessing. This is how Label Gallery knows which tables are in use by other users and will not allow you to alter them simultaneously. It also serves as the reference point for all lock files created by Paradox. Each lock file references the network control file and contains information regarding the locks on the table and by which user. It is vital that each user maps to the same network control file.

HOW TO MAP TO THE NETWORK CONTROL FILE?
1. Go to Start.Programs. Label Gallery and start BDE Administrator.
2. Select Configuration tab.
3. Select Drivers, then Native and lastly Paradox.
4. Select NET DIR and browse the directory, where PDOXUSRS.NET resides for your network.
Please note: Every user in your network should set NET DIR to the same directory.

If a network file server stores databases, this set-up will be enough. But if databases are stored on some workstation computer, that shares them to other computers but accesses them as well, one further modification in BDE Administrator will have to be made.
1. Start BDE Administrator one more time.
2. Select Configuration tab.
3. Select System, then INIT.
4. Select LOCAL SHARE parameter and change it to TRUE.
Back to top
 
4) Using local language characters with dBase databases.
When printing labels with data from dBase databases, there could be instances that some of your local language characters are not be printed correctly. The cause for this behaviour is misconfiguration in language settings of the BDE (Borland Database Engine).

SOLUTION
1. Start the program BDE Administrator, it can be found on you Start menu (Start.Programs.SATO Label Gallery.Utilities.BDE Administrator).
2. Open Database tab and open setting for dBase Files. Select appropriate language driver for LANGDRIVER (e.g. "dBASE SLO cp852" for local slovenian characters).
3. Open Configuration tab and open dBase settings in Local.Native. Select appropriate language driver for LANGDRIVER (e.g. "dBASE SLO cp852" for local slovenian characters).
4. Close BDE Administrator and save changes.
Back to top
 
5) Values from Excel worksheet do not appear in Label Gallery. The database-variables are empty.
When you have connected an Excel worksheet to the label, sometimes the data from worksheet is not transferred to the variables on the label and they remain empty. This can happen when column in worksheet contains mixed data: some fields are alphanumerical and other numerical.

Microsoft ODBC driver tries to auto-detect the type of data entered in the cells, but sometimes this auto-detection routine fails and data type is wrongly recognized. 

WORKAROUND
Make sure that all values in the same column are of the same type. If that is not possible and you need to use mixed data, format this column as Text and not Generic (on the Format menu, click Cells, and select the Text option on the Numbers tab). The column formatting has to be performed prior the actual data entry. If the data is already entered, you will have to re-format the values using function TEXT (refer to MS Excel help for proper syntax of this function). In some instances, you might have to re-type the data after formatting the column to Text.

More information about this issue can be found in the Microsoft Knowledge Base, article No. Q141284
Back to top
 
6) I cannot use data from Microsoft SQL Server 2000.
Database functionality in Label Gallery software relies on the Borland Database Engine (BDE) that does actual connections to the database. Microsoft SQL Server 2000 introduced some new datatypes that were not available before, as Unicode character type NVARCHAR and NTEXT. BDE does not know how to handle these new datatypes and unpredictable programme behaviour can occur because of this. Since MS SQL Server 2000 emerged, Microsoft stopped supporting DBLib library (responsible for connection to MS SQL Servers) in favour of ADO data connection. Because of this DBLib cannot be used for connection to new datatypes.

If you are experiencing strange programme crashes and access violation error messages, it is most probably due the use of the new datatypes.
WORKAROUND
Avoid the usage of new datatypes. Convert the field types in question to the data format from SQL Server 7 or earlier.

SOLUTION
Upgrade to version 1.5.0 or greater.
 
7) When I use Excel database in GalleryForm the "Database login" dialog box is shown at form start-up and data from Excel do not show.
The problem originates in the fact is that two different applications cannot access Excel spreadsheet at the same given time. MS Excel itself can handle multiple connection to the same .XLS and if you open the .XLS file in one instance of MS Excel, it will be opened in read/write mode. If then some other user opens the same file in his instance of MS Excel, he will be prompted that only read-only mode is available to access the file.
But if you connect to MS Excel spreadsheet from some other application, the first user will be allowed to connect to it and will lock the file. So the second user is not allows the connection to the spreadsheet and will see the "Database login" dialog box.

There are two workarounds you can try:

WORKAROUND 1
Disable Data view in Label Gallery Plus software and enable Normal view. This can be performed in View menu. Data view is used to preview the data values for the current record on the label. In order to do that Label Gallery Pro has to connect to MS Excel spreadsheet and thus locks the file. If Label Gallery Pro does not preview the data on the label, GalleryForm will be able to connect to the same Excel spreadsheet.

WORKAROUND 2
Do not make connection to the database on the label at all. Instead create prompted variables on the label. Connect to the database only in GalleryForm. Then make sure to map the database fields and label variables together in order for databsae values to be transferred to the variables. In this case GalleryForm is the only application connecting to the Excel spreadsheet and "Database login" dialog box will not be shown.

Another option is to use Access, MS SQL Server, Oracle and other databases where record locking will be handled automatically. As Excel is not a real database and therefore not suitable for network (multi-user) operation.
Back to top
 
8) GalleryData freezes at start-up and it cannot be started any more. Re-installation does not help either.
Applies to: Label Gallery prior to 1.6.4

When starting GalleryData, it displays splash screen only and then freezes. If you try to run it once more, it freezes again. Restarting Windows does not help, uninstallation and re-installation of the programme does not solve the problem either.
WORKAROUND
Go to Windows temporary directory. Usually it is located in c:\windows\temp or c:\temp. Find all files which name starts with ND and ends with extension .TMP (ND*.TMP). Delete them. They are GalleryData temporary files that have not been removed automatically and are restricting GalleryData to run normally.

SOLUTION
Upgrade to version 1.6.4 or greater.
Back to top
 
9) I cannot use data from FoxPro database tables.
Databases created in FoxPro (with file extension .DBF) are not natively supported in Label Gallery software. There is no database driver provided for connection to such data in Label Gallery installation. If you need to link to FoxPro databases there are two solutions available for you. Use one of the following solutions.

Solution 1 (recommended): To connect to FoxPro databases and obtain the data out of them the appropriate ODBC driver must be installed on the system. You must create the Data Source Name (DSN) in ODBC Data Source Administrator. This utility is located inside Administrative Tools in Control Panel. Then use this DNS as the ODBC source in Label Gallery software.

Solution 2: If you do not have the ODBC driver for FoxPro installed on the system, you can use a different approach. You can convert the FoxPro database to some other database format for which the driver is available. It can be done like this.  

1. Start Microsoft Excel application. Open the FoxPro database. Just use the Open command in the File menu. The data from FoxPro table will be displayed in the spreadsheet.
2. Select the command Save As from the File menu and save the database in the .dbf (dBase) file format.
3. Start Label Gallery software and use the database wizard to link to the converted database. The driver for dBase table access are installed with Label Gallery software.
Back to top
 
10) I cannot use data from dBase database tables in GalleryForm.
You have created the form in GalleryForm application and have linked it to the dBase database. You can see the dBase table in the design GalleryForm window. But as soon as you start your form, the run GalleryForm window does not show the data in the table object. When you open the properties of the table object, you can experience the error message 'Access violation'.

Based on the information and research that was conducted the problem seems to occur in the development environment used to program GalleryForm (Borland Delphi). GalleryForm uses different connection technologies like ADO (ActiveX Data Objects) and BDE (Borland Database Engine) to be able to connect to the widest array of database types. When different database connectivity technologies are used at the same time and Windows XP SP2 is installed on the system, the application cannot connect to the dBase tables. Several Delphi-developed applications created by other developers have the same problem, so not just GalleryForm is affected.

At this moment GalleryForm V2 does not support the dBase tables. The same feature is working in GalleryForm V1. We are working hard to have dBase functionality working again in GalleryForm application. Until then the following workarounds are suggested: 
 
WORKAROUND 1 (Recommended)
Convert your dBase database to some other database type, like Access or Paradox. You can use the application GalleryData to convert the database type.
WORKAROUND 2
Remove the Service Pack 2 from the computer.
Back to top
 
11) How can I convert text file to a real database?
Text files are often used as files with data for the labels. Text databse are usually generated from some software that does not have the label-printing features. Label Gallery can use the text file and print the data on the label, thus adding label-printing capability.

The text file is not a real database. This brings two major limitations:
1. The text file doesn't have stored the definition of the fields.
The applications can be aware of the field name (if it is stored in the first line in the text file), but not aware of the structure of the text file. The information about fields types (numeric, alphanumeric, etc.) and field lengths is not known and you have to set it manually.
2. You cannot define indexes in the text file.
Because of this fact the database connectivity options in Label Gallery software are limited. For example, you cannot change the printing order, or you cannot define a filter on some field.

Luckily, there is an easy way in Label Gallery software to convert the text file into the real database. The idea is the following: Use GalleryData to define the structure of the text file, then use GalleryData to save text file into a real database.   Follow these steps:

1. Start GalleryData.
2. Open the text file. The structure of the text file is not known so Text File Wizard opens.
3. Follow on-screen instructions and define the structure of your text file. You can store the name of the fields in the first line of the text file.
When you define the structure of the text file, the definition will be save in the file with extension .SCH in the same folder, where the text database is stored. When you open the text file some other time, the structure will be read from the definition .SCH file.
4. Create a new empty database in GalleryData. Make sure the database has the same structure of fields as the fields in your text file.
5. Close the new database in GalleryData. Leave the text file opened.
6. Select the command Fill from the Tools menu.
7. The text file is selected for the 'Source Table'. Select your empty database for the 'Destination Table' field.
8. Click on the Map Fields button.
9. Link the appropriate fields from the text file and from the database. If the fields have the same names, GalleryData will link automatically.
10. Click OK to return to the Fill Table dialog box.
11. Click OK to begin with the filling of the table.

Please note: the same procedure can be applied automatically. You can use GalleryData command-line switches and control the conversion process from some other information. For example, you can define a form in GalleryForm where a click on a button will convert text file into real database. Refer to the GalleryData help file.
Back to top
 
12) Label Gallery keeps displaying the "User Name and Password" login box when connected to an Excel DB file. This problem happens only in Win98 First Edition and is working fine in other platforms such as Windows 2K and Windows XP. How to solve this problem?
Solution: Install/Upgrade MDAC and JetEngine (Database components for Windows). The installation files are in the Label Gallery CD-ROM or can be obtained directly from Microsoft's website.

JET
http://www.microsoft.com/downloads/details.aspx?FamilyID=4335216C-8CDD-4168-A030-46F815D3F5CD&displaylang=en

Back to top
 
13) Gallery Data prompts error message, “Network Initialization Failed” upon creating new database layout.

SOLUTION
Go to the Control Panel and launch the BDE Administrator program. Go to Configuration\Drivers\Native\Paradox. In the NET DIR, change the pathway to the one that Label Gallery 3 is installed in.

Example: C:\Program Files\Sato\Gallery 2\Bin
Back to top


Label Gallery Home - Technical SupportFAQ - SUPPORT FAQ - Database