A, drive

  1. drive
item The database drive note
0 SQL Server 2000 SQL Server
1 SQL Server 2005 SQL Native Client
2 SQL Server 2008 10.0 SQL Native Client
3 Oracle Server Microsoft ODBC for Oracle || OraOLEDB.Oracle Local | | remote
4 Oracle Server EX OraOLEDB.Oracle
5 SQL Server 2008R2 2012 2014 11.0 SQL Native Client
  1. Connection string
item Connection string
0 “Driver={SQL Server}; Server = 192.168.2.207; Database=DNCTest; UID=sa; PWD=123”
1 “Driver={SQL Native Client}; Server = 192.168.2.207; Database=DNCTest; UID=sa; PWD=123”
2 “Driver={SQL Server Native Client 10.0}; Server = 192.168.2.207; Database=DNCTest; UID=sa; PWD=123”
3 Driver={Microsoft ODBC for Oracle}; Server=DNCTest; UID=system; PWD=123″ Remote: “Provider= oraoledb. Oracle; Data Source = (DESCRIPTION = (ADDRESS = (TCP) PROTOCOL = (HOST = 192.168.2.207) (1521) PORT =) (CONNECT_DATA = (SERVICE_NAME = DNCTest))); User Id=system; Password=123; PLSQLRSet = 1”
4 “Provider=OraOLEDB.Oracle; Data Source=dnc; User ID=system; Password=123;”
5 Driver={SQL Server Native Client 11.0}; Server = 192.168.2.207; Database=DNCTest; UID=sa; PWD=123″
  1. Local Driver Viewing

Control panel → small ICONS → Administrative tools → ODBC data source (differentiate x86 X64) → driver

4. Reference

1) support strategy – SQL Server Native Client | Microsoft Docs

2) used for the Oracle ODBC driver – the Open Database Connectivity (ODBC) | Microsoft Docs

Second, the SQL Server

  1. ADO environment does not have

Solution: Replace ADO data access components

Reference: Referencing the ADO Libraries In a Visual c + + Application – ActiveX Data Objects (ADO) | Microsoft Docs

Three, Oracle,

  1. The installation

Ensure that the Oracle Client is installed first, and use the administrator mode during the installation.

After that, install MS.

  1. Logic in MS

Data type: Oracle Server;

Database name: Oracle service name;

1) == Ensure that the tablespace name is created by MS, otherwise MS cannot use the start button ==;

For example, if the Oracle service is disconnected and the tablespace name already exists, the tablespace name is manually created.

Solution: The Oracle server manually deletes the tablespace and then creates the tablespace automatically when the MS installs the database. Or use a tablespace name that does not exist on Oracle and is automatically created by MS during database installation.

Database password: system login password.

1) Logic: Oracle connection string write dead user name: system;

2) When MS reinstalls the database, it creates a user (tablespace) with the database user name and system login password configured on the interface. The login password of the user (tablespace) is the same as that of system.

  1. The problem

1) The start button in MS cannot be used

Refer to instructions in 2;

2) The following prompt appears when MS installs or uses the start button:

Solution: Install the Oracle Client and then the MS server. If the Oracle Client has been installed, reinstall the MS server.

  1. Table space address query

Statement lookup:

SELECT * FROM Dba_Data_Files ddf WHERE ddf.tablespace_name = 'TablespaceName';
Copy the code

Reference: Oracle query the location of the tablespaces – chbyiming – cnblogs.com

select name from v$datafile					//recommendedCopy the code

Select * FROM DBA_DATA_FILES				//recommendedCopy the code

Reference :(8 messages) find the location of oracle datafiles and tablespaces

  1. Pay attention to the problem

If the Oracle server and client are installed on the same COMPUTER, ensure that the path of the environment variable server is earlier than that of the Oracle server. The client path must follow ==!

  1. This section describes how to configure Oracle clients

1) Oracle Net Manager visual configuration listening (== use ==)

Reference: Oracle 11G NET Manager configuration Step _Anying_define column -CSDN blog

2) Oracle connects to a remote database in four ways

Mysql > connect to a remote database from an Oracle database