<?xml version="1.0" encoding="utf-8" ?><rss version="2.0"><channel><title><![CDATA[newtea的专栏]]></title><description><![CDATA[编程爱好者]]></description><link>https://blog.youkuaiyun.com/newtea</link><language>zh-cn</language><generator>https://blog.youkuaiyun.com/</generator><copyright><![CDATA[Copyright &copy; newtea]]></copyright><item><title><![CDATA[Oracle链接服务器IID_IDBCreateCommand]]></title><link>https://blog.youkuaiyun.com/newtea/article/details/129638246</link><guid>https://blog.youkuaiyun.com/newtea/article/details/129638246</guid><author>newtea</author><pubDate>Sat, 18 Mar 2023 16:11:13 +0800</pubDate><description><![CDATA[无法从链接服务器“xxx_DB”的 OLE DB 访问接口“OraOLEDB.Oracle”获取所需的接口(“IID_IDBCreateCommand”)。链接服务器 "xxx_DB" 的 OLE DB 访问接口 "OraOLEDB.Oracle" 报错。重启sql server服务，否则设置无效。消息 7399，级别 16，状态 1，第 31 行。消息 7301，级别 16，状态 2，第 31 行。设置接口属性，允许进程内。]]></description><category></category></item><item><title><![CDATA[SQL2019 附加数据库只读]]></title><link>https://blog.youkuaiyun.com/newtea/article/details/129538432</link><guid>https://blog.youkuaiyun.com/newtea/article/details/129538432</guid><author>newtea</author><pubDate>Tue, 14 Mar 2023 19:47:40 +0800</pubDate><description><![CDATA[2、找到*.mdf ,*.ldf 文件,添加这个账号的完全控制权限。3、数据库属性-->选项--->数据库只读 改为 false.1、查看服务属性，查看账号。]]></description><category></category></item><item><title><![CDATA[SQL SERVER 2012 x64 与 ORACLE 11g 建立 SERVER LINK]]></title><link>https://blog.youkuaiyun.com/newtea/article/details/9285437</link><guid>https://blog.youkuaiyun.com/newtea/article/details/9285437</guid><author>newtea</author><pubDate>Tue, 14 Mar 2023 19:43:33 +0800</pubDate><description><![CDATA[客户ERP服务器ORACEL : ORACEL DATABASE 9I 64bit
客户BMS系统服务器：
a.安装客户端ORACLE: ORACLE CLIENT 11G 64BIT
b.安装SQLSERVER : SQL SERVER 2012 64 BIT
  c.WINDOWS操作系统：SERVER 2008 64 BIT 
说明：在SQL S]]></description><category></category></item><item><title><![CDATA[word单元格自动换行，适应文字]]></title><link>https://blog.youkuaiyun.com/newtea/article/details/126032023</link><guid>https://blog.youkuaiyun.com/newtea/article/details/126032023</guid><author>newtea</author><pubDate>Thu, 28 Jul 2022 12:01:53 +0800</pubDate><description><![CDATA[文字下方会出现蓝色下划线]]></description><category></category></item><item><title><![CDATA[出口退税率文库2020B]]></title><link>https://blog.youkuaiyun.com/newtea/article/details/108551355</link><guid>https://blog.youkuaiyun.com/newtea/article/details/108551355</guid><author>newtea</author><pubDate>Sat, 12 Sep 2020 16:26:26 +0800</pubDate><description><![CDATA[https://jiangsu.chinatax.gov.cn/art/2020/3/19/art_15956_291752.html

出口退税率文库2020B
]]></description><category></category></item><item><title><![CDATA[MDI窗口点击节点报错问题]]></title><link>https://blog.youkuaiyun.com/newtea/article/details/47836743</link><guid>https://blog.youkuaiyun.com/newtea/article/details/47836743</guid><author>newtea</author><pubDate>Fri, 21 Aug 2015 16:43:48 +0800</pubDate><description><![CDATA[MDI窗口点击节点报错问题
本地VS内运行没有问题，但是发布以后，无法打开功能页面。
解决方式：
所有的引用的属性设置为：复制到本地。]]></description><category></category></item><item><title><![CDATA[引用Log4net.dll的模块，无法打开]]></title><link>https://blog.youkuaiyun.com/newtea/article/details/22872711</link><guid>https://blog.youkuaiyun.com/newtea/article/details/22872711</guid><author>newtea</author><pubDate>Thu, 03 Apr 2014 15:15:23 +0800</pubDate><description><![CDATA[错误提示：“加载文件格式不正确”
分析：log4net.dll 损坏，更换dll即可。]]></description><category></category></item><item><title><![CDATA[C# string格式的日期时间字符串转为DateTime类型]]></title><link>https://blog.youkuaiyun.com/newtea/article/details/17245475</link><guid>https://blog.youkuaiyun.com/newtea/article/details/17245475</guid><author>newtea</author><pubDate>Tue, 10 Dec 2013 15:53:15 +0800</pubDate><description><![CDATA[(1）Convert.ToDateTime(string)

string格式有要求，必须是yyyy-MM-dd hh:mm:ss

 

（2）：Convert.ToDateTime(string, IFormatProvider)

DateTime dt;

DateTimeFormatInfo dtFormat = new System.GlobalizationDat]]></description><category></category></item><item><title><![CDATA[Windows查看端口和结束进程]]></title><link>https://blog.youkuaiyun.com/newtea/article/details/17067425</link><guid>https://blog.youkuaiyun.com/newtea/article/details/17067425</guid><author>newtea</author><pubDate>Mon, 02 Dec 2013 09:41:12 +0800</pubDate><description><![CDATA[转载自：http://www.iteye.com/topic/1117270




开始--运行--cmd 进入命令提示符 输入netstat -ano 即可看到所有连接的PID 之后在任务管理器中找到这个PID所对应的程序如果任务管理器中没有PID这一项,可以在任务管理器中选"查看"-"选择列" 

        经常，我们在启动应用的时候发现系统需要的端口被别的程序占用，如何]]></description><category></category></item><item><title><![CDATA[Master-Detail 查询  表体字符串合并]]></title><link>https://blog.youkuaiyun.com/newtea/article/details/13768653</link><guid>https://blog.youkuaiyun.com/newtea/article/details/13768653</guid><author>newtea</author><pubDate>Thu, 31 Oct 2013 11:18:10 +0800</pubDate><description><![CDATA[Master-Detail 查询  表体字符串合并]]></description><category></category></item><item><title><![CDATA[asp.net 获取系统的根目录]]></title><link>https://blog.youkuaiyun.com/newtea/article/details/9830641</link><guid>https://blog.youkuaiyun.com/newtea/article/details/9830641</guid><author>newtea</author><pubDate>Thu, 08 Aug 2013 09:25:42 +0800</pubDate><description><![CDATA[测试有效的 ： 系统的根目录

HttpContext.Current.Server.MapPath(HttpContext.Current.Request.ApplicationPath).ToLower();           





以下为参考：

ASP.NET根路径的获取和将Web站点下的绝对路径转换为虚拟路径的两种方案

ASP.NET 根路径的获取
 ]]></description><category></category></item><item><title><![CDATA[VS2010: Microsoft.TeamFoundation.PowerTools.CheckinPolicies.ChangesetComments 未注冊]]></title><link>https://blog.youkuaiyun.com/newtea/article/details/9829839</link><guid>https://blog.youkuaiyun.com/newtea/article/details/9829839</guid><author>newtea</author><pubDate>Thu, 08 Aug 2013 08:53:14 +0800</pubDate><description><![CDATA[VS2010


缺少Team Foundation Server Power Tools
下载地址：
http://visualstudiogallery.msdn.microsoft.com/c255a1e4-04ba-4f68-8f4e-cd473d6b971f]]></description><category></category></item><item><title><![CDATA[通过设计器修改表结构，“不允许保存更改”]]></title><link>https://blog.youkuaiyun.com/newtea/article/details/9629839</link><guid>https://blog.youkuaiyun.com/newtea/article/details/9629839</guid><author>newtea</author><pubDate>Tue, 30 Jul 2013 16:44:48 +0800</pubDate><description><![CDATA[解决问题：
工具/选项]]></description><category></category></item><item><title><![CDATA[水晶报表指定小数位数，去除多余的0]]></title><link>https://blog.youkuaiyun.com/newtea/article/details/9466289</link><guid>https://blog.youkuaiyun.com/newtea/article/details/9466289</guid><author>newtea</author><pubDate>Thu, 25 Jul 2013 12:07:45 +0800</pubDate><description><![CDATA[DECLARE 
@dDECIMAL(18,8)
SET @d= 5.44
 
SELECT @d
--5.44000000 DECIMAL
SELECT 
CONVERT(FLOAT,@d)
--5.44       FLOAT
SELECT 
CONVERT(VARCHAR(50),CONVERT(FLOAT,@d))
--5.44       VARCHAR]]></description><category></category></item><item><title><![CDATA[sqlServer 链接 oracel 建立DBlink（未完）]]></title><link>https://blog.youkuaiyun.com/newtea/article/details/9313049</link><guid>https://blog.youkuaiyun.com/newtea/article/details/9313049</guid><author>newtea</author><pubDate>Fri, 12 Jul 2013 16:45:09 +0800</pubDate><description><![CDATA[1 访问接口： Oracel Provider for OLE DB
2 产品名称：oracle 小写。]]></description><category></category></item><item><title><![CDATA[Sql Server  (错误：7302）]]></title><link>https://blog.youkuaiyun.com/newtea/article/details/9312881</link><guid>https://blog.youkuaiyun.com/newtea/article/details/9312881</guid><author>newtea</author><pubDate>Fri, 12 Jul 2013 16:36:10 +0800</pubDate><description><![CDATA[windows server 2008 x64
sql server 2008 r2
OraClient 11g 


错误提示：








解决办法：]]></description><category></category></item><item><title><![CDATA[SQL Server 不能通过外部IP访问，解决方法]]></title><link>https://blog.youkuaiyun.com/newtea/article/details/9249915</link><guid>https://blog.youkuaiyun.com/newtea/article/details/9249915</guid><author>newtea</author><pubDate>Fri, 05 Jul 2013 10:58:20 +0800</pubDate><description><![CDATA[版本：SQL server 2008 express with tools
打开配置管理器，开启 TCP，右键属性设置TCP端口：]]></description><category></category></item><item><title><![CDATA[How to setup linked servers for SQL Server and Oracle 64 bit client]]></title><link>https://blog.youkuaiyun.com/newtea/article/details/9187233</link><guid>https://blog.youkuaiyun.com/newtea/article/details/9187233</guid><author>newtea</author><pubDate>Thu, 27 Jun 2013 14:11:10 +0800</pubDate><description><![CDATA[感谢作者：Tim Ford. 图文并茂。
原帖地址：
http://www.mssqltips.com/sqlservertip/1433/how-to-setup-linked-servers-for-sql-server-and-oracle-64-bit-client/



Problem
We have two SQL 2005 64-bit clusters in our]]></description><category></category></item><item><title><![CDATA[HTTP 错误 500.21 - 处理程序“PageHandlerFactory-Integrated”在]]></title><link>https://blog.youkuaiyun.com/newtea/article/details/9022693</link><guid>https://blog.youkuaiyun.com/newtea/article/details/9022693</guid><author>newtea</author><pubDate>Tue, 04 Jun 2013 15:30:08 +0800</pubDate><description><![CDATA[HTTP 错误 500.21 - Internal Server Error

处理程序“PageHandlerFactory-Integrated”在其模块列表中有一个错误模块“ManagedPipelineHandler”




解决办法：
以管理员的身份运行vs命令行工具，然后运行一下aspnet_regiis.exe -i 命令，重启iis。]]></description><category></category></item><item><title><![CDATA[未能加载文件或程序集“file:///C:\Program Files (x86)\SAP BusinessObjects\Crystal Reports for .NET Framework 4.0]]></title><link>https://blog.youkuaiyun.com/newtea/article/details/8900678</link><guid>https://blog.youkuaiyun.com/newtea/article/details/8900678</guid><author>newtea</author><pubDate>Wed, 08 May 2013 15:55:50 +0800</pubDate><description><![CDATA[重命名启动文件*.exe后，应用系统打开正常，但是，一旦显示水晶报表页面，系统就报错死掉
，找了很久，唉还是点击调试进去，才找到原因啊。
未能加载文件或程序集“file:///C:\Program Files (x86)\SAP BusinessObjects\Crystal Reports for .NET Framework 4.0\Common\SAP BusinessObjects E]]></description><category></category></item></channel></rss>