How do PB and SQL server database connection, please

CodePudding user response:

A connecting step
.1) Server SQL Server and start the installation, create the database,
2) the client install SQL Server client,
3) start the PB, configuration data source description (through direct connection, it is not recommended to use the ODBC),
4) connection,
2. Written DB_profile

Set in the ini file
(Database)
The DBMS=MSS Microsoft SQL Server 6. X
The Database=databasename
UserId=
LogID=
DatabasePassword=
LogPass=
ServerName=
The AutoCommit=False
In the program with profilestring read


Additional information: ms SQL server configuration file Settings
Ms SQL server configuration file Settings:
DBMS="MSS"//just in *.ini file using this code will tell pb use ms SQL server
Database, the Database used
LogId: SQL server log in to your account
LogPass=password
Servername: allows the database server connection of computer name
The autocommit mode: control the pb is work within the scope of the transaction or work outside the scope of transaction processing
Special connection parameters dbparm: DBMS
The following parameters:
Language: in display an error message and the date format specified when the language is used, the server must be set on the straight.
Lock: the transaction isolation layer
Log: text and image data should update record to the transaction log.
Systemprocs: system stored procedures and user-defined stored procedure is displayed in a variety of pb sketchpad.
Pbcatalogownerb storage table in default.
Async: allow synchronous operation on the server. 0: synchronous and asynchronous
1:Dbgettime: when the async=1, the use of set this parameter to the user in the retrieval of pb waiting for response from pb in the number of seconds.
Cursorlock: release and cursorscroll parameters used together can set the cursor locking options. The lock, opt, optval, readonly
Cursorscroll: set the cursor scroll options.
Staticbind: control whether pb before retrieve data retrieve the result set in the DBMS.
Dbtextlimit: control returns the maximum length of the text field without the text as a large binary data objects to deal with.
Appname: set up the connection used by the application name.
Host: set up the connection work stops.
Packetsize: set up the server to the pb when transmitting data set package size.
If want to use secure: set winnt integration logic security safety and security the default 0 using standard SQL server connection, one integrated security.

CodePudding user response:

The upstairs has made it very clear

CodePudding user response:

Very detailed, thank you!

CodePudding user response:

The above Settings are correct, but does not join, whether you need to add some other functions, such as, like VB to call a WINDOWS API function, otherwise, always complain,

CodePudding user response:

Not to say that the
Use profilestring to read in the program

CodePudding user response:

Pay attention to in...

CodePudding user response:

good

CodePudding user response:

I also want to know, thank you LZ.