//Profile xueyuna
The SQLCA. DBMS="ODBC"
The SQLCA. The AutoCommit=False
The SQLCA. DBParm="Connectstring='DSN=xueyuna; UID=123; The PWD=456 '"
Connect using the sqlca;
If the SQLCA. SQLCode<0 Then
Messagebox (" error ", "database connection error")
The Else
Open (w_register)
End the If
Excuse me for connection to the database initialization code should be how to write??????? I am a novice, please advice, thank you!!!!!
CodePudding user response:
What is the databaseCodePudding user response:
Is bringing Sybase SQL Anywhere 8.0CodePudding user response:
The following content is reproducedHow to install SQL Anywhere and PB application?
, shall not be reproduced without permission as original studio
one Installation steps
Generally issued a PB application in addition to the application component itself, it should include the following documents and relevant operation:
1. Original concept Runtime dynamic link Library (the Runtime Library),
2. Database interface: on the one hand, including PB provide special interface or ODBC database interface program, on the other hand, including different database vendors provide ODBC database driver,
3. The ODBC data source configuration,
two Original concept Runtime dynamic link Library (the Runtime Library),
Different versions of the PB required runtime dynamic link library file is not the same, but the library has a similar place, these DLL must be included in the application or system directory:
PB6.5 required documents:
Necessary PBVM60. DLL original concept virtual machine
Optional PBDWE60. DLL DataWindow data window engine
Optional PBRTC60. DLL hypertext controls
Optional PBTRA60. DLL database access track
Optional PBODB60. DLL PB ODBC interface
Optional PBIN760. DLL INFORMIX interface
Optional PBMSS60. DLL Microsoft SQL Server interface
Optional PBSYC60. DLL Sybase SQL Server interface
Optional PBO7360. DLL/PBO7260. DLL Oracle Version interface
PB7.0 required documents:
Necessary PBVM70. DLL original concept virtual machine
Necessary LIBJCC. DLL original concept library management
Optional PBDWE70. DLL DataWindow data window engine
Optional PBRTC70. DLL hypertext controls
Optional PBTRA70. DLL database access track
Optional PBODB70. DLL PB ODBC interface
Optional PBIN770. DLL INFORMIX interface
Optional PBMSS70. DLL Microsoft SQL Server interface
Optional PBSYC70. DLL Sybase SQL Server interface
Optional PBO7370. DLL/PBO8470. DLL Oracle Version interface
PB8.0 required documents:
Necessary PBVM80. DLL original concept virtual machine
Necessary LIBJCC. DLL original concept library management
Optional PBDWE80. DLL DataWindow data window engine
Optional PBRTC80. DLL hypertext controls
Optional PBTRA80. DLL database access track
Optional PBODB80. DLL PB ODBC interface
Optional PBIN780. DLL INFORMIX interface
Optional PBMSS80. DLL Microsoft SQL Server interface
Optional PBSYC80. DLL Sybase SQL Server interface
Optional PBO7380. DLL/PBO8480. DLL/PBO9080. DLL Oracle Version interface
Above file can be found in C: \ Program Files \ Sybase \ Shared \ original concept,
3. SQL Anywhere ODBC database driver,
SQL Anywhere 5.0:
DBTL50T. DLL database tool
DBL50T. DLL database interface
WODBC. HLP help document
WOD50T. DLL ODBC driver
WL50ENT. DLL English string
WTR50T. DLL ODBC translation
DBENG50. EXE database engine
SQL Anywhere 6.0:
DBL60T. DLL, WODBC HLP, WOD60T. DLL, WL60ENT. DLL, WTR60T. DLL, DBENG60. EXE
SQL Anywhere 7.0:
DBODBC7. DLL, DBLIB7. DLL, DBWTSP7. DLL, DBLGEN7. DLL, DBODTR7. DLL, DBENG7. EXE
Four. The ODBC data source configuration,
Above contains files, still need to use the application of ODBC database configuration of the ODBC data source, after installation ends so that the application can directly access the user data source,
To use SQL Anywhere below 5.0 database created by the user database as an example to illustrate how to use the manual configuration manager for the ODBC data source and how to automatically modify the system in the installer registry, other database SQL Anywhere can refer to 5.0,
1. Use the data source manager configuration user data source,
1.1. Install SQL Anywhere database driver, make the data source manager "ODBC driver" page add a line of SQL Anywhere drive,
1.2. In the "User DSN" one page select "add", then select SQL Anywhere Data Source, Data Source configuration information table, the Data Source Name (Data Source Name), Database Name (the Database File), the User ID (User ID), the information such as User Password (Password) tian qi, choose "OK" to confirm, at this point in the "User Data Source" window will increase the User's Database ODBC driver, select "confirm" exit after Data manager,
For the above two steps after restart the system, users can use SQL Anywhere after running the application database,
2. Modify the registry configuration system user data source,
(note: C: \ YourApp applications for the user directory, C: \ YourApp \ Sqlany50 contains SQL Anywhere for the application database driver file directory, YourDB. DB database, for the user)
Under the HKEY_LOCAL_MACHINE \ software \ ODBC \ ODBC Drivers, increasing string keys:
Sybase SQL Anywhere 5.0="Installed"
In HKEY_LOCAL_MACHINE \ software \ ODBC \ Sybase SQL Anywhere 5.0, add the string keys:
Driver="C: \ YourApp \ Sqlany50 \ WOD50T DLL"
The Setup="C: \ YourApp \ Sqlany50 \ WOD50T DLL"
In the HKEY_CURRENT_USER \ Software \ ODBC \ ODBC.ini \ ODBC Data Source, increase the string keys:
TestDB="Sybase SQL Anywhere 5.0"
In the HKEY_CURRENT_USER \ Software \ ODBC \ ODBC.ini, increase primary key: TestDB, and the key values are as follows:
Autostop="yes"
Databasefile="C: \ YourApp \ YourDB DB
Databasename="TestDB"
Driver="C: \ YourApp \ Sqlany50 \ WOD50T DLL"
The PWD="SQL"
Start="C: \ YourApp \ Sqlany50 \ dbeng50 exe - d - c1024 - Q"
UID="dba"
These steps to join in the user's installation program, gives users the application without having to install SQL Anywhere database driver, also can direct access to the user data sources, so as to realize the independence of user applications,
CodePudding user response:
Try you can baidu, yourself, don't understand asked again, this effect may be a bit betterhttp://liu129jun.blog.163.com/blog/static/27333386200952901018795/
CodePudding user response:
The