You may not be able to connect to SQL Server smoothly in the first time. On the one hand, there is no MSSQL Server private interface. On the other hand, the database management system (DBMS) is replaced with "OLE DB", and it is a bit not moving! The following will be described in the PB10 to connect the SQL 2000 database with OLE DB.
When installing the PB10, select the Custom / Full mode installation (the default installation method does not install the OLE DB interface), and Next- "If you are not installed. Net Do not select ADO.NET .... item in the list. All the way is completed.
Find the OLE Microsoft OLE DB item in the Database Drawing board, and right click to create a new configuration, in the pop-up configuration window:
Profile Name: Fill in the configuration file name //
Provider: Select the database management system type, select "SQLOLEDB" item
Data Source: The server name (and the previous version is not the same). You can select it in the drop-down list, or you can fill in the server name or IP address, such as: 127.0.0.1. If the above provider is not "SQLOLEDB", there may be no options in this drop-down list.
User ID: User Name. My username is the default SA
Password: Corresponds to the password of the User ID above, my password is empty, so don't fill.
Here you can connect to SQL Server smoothly. But which database is connected? The above parameters did not specify, I also found a half day: P. Don't worry, you can fill in "Database = Database Name" in Extended. (Do not quotation)
The final configuration file is:
// Profile hisSQLCA.DBMS = "OLE DB" SQLCA.LogId = "sa" // my username is saSQLCA.AutoCommit = FalseSQLCA.DBParm = "PROVIDER = 'SQLOLEDB', DATASOURCE = 'NETMANAGER', PROVIDERSTRING = 'database = zs' "// My database name is: zs; DataSource can also be an IP address: DataSource = '127.0.0.1'
At this time, the configuration of connecting SQL Server with OLE DB is completed!
