Home > Database > Mysql Tutorial > sqlserver连接服务器读取Oracle数据,sqlserver读取oracle的ODBC

sqlserver连接服务器读取Oracle数据,sqlserver读取oracle的ODBC

WBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWB
Release: 2016-06-07 15:40:25
Original
2049 people have browsed it

1.建立ODBC与orcale 数据 库的链接 参考文章:http://wenku.baidu.com/link?url=qJqJzf7m-hdfIDHJaZvcJezkNv1bkA0kiAvkepXz08WgjjAu9_sTZ9_c1DewIholtnX8XAtqda1s1da1uVNJqg7punQk0lQSmpL_af8_0Gm 参考文章:http://blog.csdn.net/enjoyinwind/article/detai

1.建立ODBC与orcale数据库的链接

参考文章:http://wenku.baidu.com/link?url=qJqJzf7m-hdfIDHJaZvcJezkNv1bkA0kiAvkepXz08WgjjAu9_sTZ9_c1DewIholtnX8XAtqda1s1da1uVNJqg7punQk0lQSmpL_af8_0Gm

参考文章:http://blog.csdn.net/enjoyinwind/article/details/7755348

oracle链接字符串汇总:http://www.connectionstrings.com/oracle/

2.设置sqlserver数据库的链接服务器

sqlserver连接服务器读取Oracle数据,sqlserver读取oracle的ODBC


sqlserver连接服务器读取Oracle数据,sqlserver读取oracle的ODBC

3.查询验证

通过连接查询Oracle数据库中的数据

select * from openquery(TEST_ORA, 'SELECT * FROM BASEMETADATA_DEPARTMENT')

通过连接向Oracle中的表插入数据

INSERT OPENQUERY(TEST_ORA, 'select DepartmentId,DeptName,DeptCode from BaseMetaData_Department')
select DepartmentId,DeptName,DeptCode from BaseMetaData_Department

4.乱码解决

正在查找

Related labels:
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Latest Issues
Problem with tp6 connecting to sqlserver database
From 1970-01-01 08:00:00
0
0
0
Unable to connect to SQL Server in Laravel
From 1970-01-01 08:00:00
0
0
0
Methods of parsing MYD, MYI, and FRM files
From 1970-01-01 08:00:00
0
0
0
SQLSTATE: User login failed
From 1970-01-01 08:00:00
0
0
0
Popular Tutorials
More>
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template