Home > database >  PB and SQL connection to ask
PB and SQL connection to ask

Time:10-05

My database (YYGL) table (Finger) in a field (Finger_info), there are more than 1000 characters in PB connection scripts I use SQL dedicated driver to connect the following script (first) :
The SQLCA. DBMS="MSS Microsoft SQL Server 6. X"
The SQLCA. Database="YYGL"
The SQLCA. SERVERNAME="Server"
The SQLCA. LogId="sa"
The SQLCA. LOGPASS=""
The SQLCA. The AutoCommit=False
The SQLCA. DBParm=""
CONNECT USING the SQLCA;
From the table (Finger) field (Finger_info) only 255 characters, the content of the is not all,
While using ODBC driver can all the content of the field (Finger_info), are all established in the ODBC (connection) in PB connection script writing ODBC driver (the second method) as follows:
The SQLCA. DBMS="ODBC"
The SQLCA. The AutoCommit=False
The SQLCA. DBParm="ConnectString='DSN=YYGL; UID=sa; The PWD='
"The CONNECT.

How to use a used a special driver (first) remove the table (Finger) field (Finger_info) the entire contents of the

CodePudding user response:

Try your Finger_info field types into the text

CodePudding user response:

Lz want?

CodePudding user response:

After the need to focus on, now but first, let me help you
  • Related