Lang leader label Barcode printing software How to connect to a SQL Server database

Using lang leading label barcode printing software to make a product barcode process, if the data is stored in an Excel table or text document, according to the previous tutorial, we can easily connect to use the data. But if the data is stored in a remote host or database, how do we get it? Here is a brief introduction of the next in the Lang leading label barcode printing software database connection basic procedures, in SQL Server 2000, for example, other databases such as mysql,oracle, such as connection steps are similar.
First, whether your database is installed on a native or remote server, make sure that SQL Server is available to connect. Note that for the version of SQL Server 2000, you need to install the SQL Server SP4 patch, otherwise it will not connect, how to do the online view, there are a lot of related tutorials, here is not the statement.
After the successful connection, we can be in Lang leading label barcode printing software to try to connect, here are two ways, first we can directly through the barcode printing software provided by the SQL Server (JDBC) to connect, the specific operation is to open the Lang barcode printing software, and then found in the top column " Database settings Click, in the pop-Up Database Settings window, click Add, select SQL Server data source (JDBC) as shown in:

After the above operation, a SQL Server data source Management (JDBC) window will pop up, here we only need to enter the appropriate server IP, port, the database name to connect to, the account number and password can click the test connection, if the above information is correct, you can connect successfully. As shown in the following:

Next is the second method, we directly through the ODBC connection, the specific procedure is, the same click on the database settings, in the Pop-up window select "Add", in the drop-down menu that appears we select the last ODBC Data Source (ODBC), The ODBC Data Source Management (ODBC) window will also pop up at this time, as shown in:

How do we need to connect this time, enter "Driver={sql Server}" in the connection string; Server=localhost;database=test; User Id=sa; password=* *; " The data here can be changed appropriately based on your SQL Server information, then click on "Test Connection". As shown in the following:

A corresponding table appears in the selection table to indicate that the connection was successful.

About Us leading barcode label printing software How to connect to a SQL Server database this is the end of the operation. Other databases such as MySQL, and so on, just need to select the appropriate database JDBC connection in the barcode printing software.

Lang leader label Barcode printing software How to connect to a SQL Server database