1. How to use pb dynamic link database,
SQL server2000
2. The problem of design database
In mobile phones, for example, has a price, brand, model, etc., is to create a table, or creating multiple tables,

CodePudding user response:

Reading, don't waste space of BBS,

CodePudding user response:

1. Your reading! This is the most basic!
2. As long as your data structure that can express the business logic, how much do you want to build how many table table was built!
3. To the source.

CodePudding user response:

What is a dynamic link database, is a login system links database? Then you can write directly link the database in the login screen script,
In SQL server, for example:
The SQLCA. DBMS='OLE DB'
SQLCA. LogPass=link database password
SQLCA. LogId=link database user name
='SQLOLEDB' SQLCA. DBParm="PROVIDER and DATASOURCE='" + is_servername +"', PROVIDERSTRING='database="+ is_dbname +"', DBTextLimit='9999' "
The SQLCA. The AutoCommit=False
Connect using the sqlca;
Among them: is_servername database server, can be IP address, or service name
Is_dbname database name,
Connect using the sqlca; Began to link is the use of the above parameters database, if the return value is zero, then the database connection,
These statements, but also can be used in other parts of the application interface, for example, you want to link to other database (of course have to define a transaction object, the sqlca is the system default),
Design table that depends on your application for the purpose, management of pass in and out of the commodities, if as that, of course, have to build more than one table, for example, to build a basic information table, put certain goods are common in this table, while the characteristics of things in another table, then the number of goods to build another table to store, with the goods identification to correlate between them...

CodePudding user response:

SQLCA. DBMS="MSS Microsoft SQL Server" - the database type
SQLCA. ServerName=". "//the server name
The SQLCA. Database="factory"//Database name
The SQLCA. LogId="sa"//login account
The SQLCA. LogPass=& lt; * * & gt;//account password
The SQLCA. The AutoCommit=False

CONNECT USING the SQLCA;
If the SQLCA. SQLCode=1 then
MessageBox (" prompt ", "connect to database failure! Please check whether the parameter is correct, ")
End the if

As for the table, can learn to see yourself demand budweiser 9000 or kingdee K3

CodePudding user response:

Should know what questions to answer, what problem does not need to answer,,,,,,,

CodePudding user response:

The best way, when reading a book like this small problem don't sent above

CodePudding user response:

By the top

CodePudding user response:

Spot bamboo is a soft touch!

CodePudding user response:

Top new elder brother!

CodePudding user response:

According to their own needs to build one

CodePudding user response:

Pass by, this kind of problem will not be answer

CodePudding user response:

A lot of online

CodePudding user response:

Sqlca. DBMS="MSS Microsoft SQL Server" - the database type
The sqlca. Database="dbName"//Database name
The sqlca. Logid="Logid"//login account
The sqlca. Logpass=& lt; * * & gt;//account password
Sqlca. ServerName=". "//the server name
The sqlca. UserID="dbUserId"//database user name
The sqlca. DBPass="DBPass"//database password
The SQLCA. The AutoCommit=true

CONNECT USING the SQLCA;
If the SQLCA. SQLCode=1 then
MessageBox (" prompt ", "connect to database failure! Please check whether the parameter is correct, ")
End the if

CodePudding user response:

reference 13 floor hovy_yang reply:

sqlca. DBMS="MSS Microsoft SQL Server - database type"
The sqlca. Database="dbName"//Database name
The sqlca. Logid="Logid"//login account
The sqlca. Logpass=& lt; * * & gt;//account password
Sqlca. ServerName=". "//the server name
The sqlca. UserID="dbUserId...

The sqlca. UserID="dbUserId"//database user name
The sqlca. DBPass="DBPass"//database password
This has not been used for two, and use of, with loppass and logpass have what distinction, parsing the upstairs, please

CodePudding user response:

The so-called dynamic, dynamic access to the server name

CodePudding user response:

O (︶ ︿ ︶) o alas food rarely read a book to than I am

CodePudding user response:

reference 16 floor zhayun001 response:

o (︶ ︿ ︶) o alas people rarely read a book than I have food to

+ 1

CodePudding user response:

reference 16 floor zhayun001 response:

o (︶ ︿ ︶) o alas people rarely read a book than I have food to

Elder brother, you than I have to,

CodePudding user response:

This is less that sometimes a book written by not less, netizens please sympathy