用ms的oracle驱动,不支持blob类型,使用oracle提供驱动,对汉字的处理上有问题。难到一定要两个驱动各建一个连接,分开处理数据才行吗。
解决方案 »
- ▲▲在主窗体菜单上打开了一个Form1,在Form1关闭后让Form2显示,可Form2显示后点主窗体,Form2跑到了主窗体后面,怎么办???▲▲
- 求职(深圳)
- 某个对象如何自己消灭自己?
- 怎样实现这个功能?
- DELPHI控件的事件是否都是用线程来管理的,都是在哪里触发的,我怎么没找到
- 菜鸟求助!!delphi7下ShellExecute问题?
- 请问,
- 数据库技术:如何能知道当前应用中是否存在一个特定的Database ?
- 我旁边来了一个大3的女生,实在是倍给我压力..
- 各位大虾,谁的Delphi6.0的密码能告诉我,我重重有分
- Delphi2009 ADO玩死人啊,让不让人活啊???
- 如何在dbgrideh中控制数字显示格式?
select * from openquery(svr_iqcjl,'select * from mdr')
/****** Object: LinkedServer [svr_iqcjl] Script Date: 02/05/2009 20:58:35 ******/
EXEC master.dbo.sp_addlinkedserver @server = N'svr_iqcjl', @provider=N'SQLOLEDB', @datasrc=N'172.20.100.12'
/* For security reasons the linked server remote logins password is changed with ######## */
EXEC master.dbo.sp_addlinkedsrvlogin @rmtsrvname=N'svr_iqcjl',@useself=N'False',@locallogin=NULL,@rmtuser=N'IQC',@rmtpassword='########'GOEXEC master.dbo.sp_serveroption @server=N'svr_iqcjl', @optname=N'collation compatible', @optvalue=N'false'
GOEXEC master.dbo.sp_serveroption @server=N'svr_iqcjl', @optname=N'data access', @optvalue=N'true'
GOEXEC master.dbo.sp_serveroption @server=N'svr_iqcjl', @optname=N'dist', @optvalue=N'false'
GOEXEC master.dbo.sp_serveroption @server=N'svr_iqcjl', @optname=N'pub', @optvalue=N'false'
GOEXEC master.dbo.sp_serveroption @server=N'svr_iqcjl', @optname=N'rpc', @optvalue=N'false'
GOEXEC master.dbo.sp_serveroption @server=N'svr_iqcjl', @optname=N'rpc out', @optvalue=N'false'
GOEXEC master.dbo.sp_serveroption @server=N'svr_iqcjl', @optname=N'sub', @optvalue=N'false'
GOEXEC master.dbo.sp_serveroption @server=N'svr_iqcjl', @optname=N'connect timeout', @optvalue=N'0'
GOEXEC master.dbo.sp_serveroption @server=N'svr_iqcjl', @optname=N'collation name', @optvalue=null
GOEXEC master.dbo.sp_serveroption @server=N'svr_iqcjl', @optname=N'lazy schema validation', @optvalue=N'false'
GOEXEC master.dbo.sp_serveroption @server=N'svr_iqcjl', @optname=N'query timeout', @optvalue=N'0'
GOEXEC master.dbo.sp_serveroption @server=N'svr_iqcjl', @optname=N'use remote collation', @optvalue=N'true'
GO