方案1：修改IE的设置：

方案2：标记控件为脚本安全的

在工程中增加头文件 cathelp.h

#ifndef _CATHELP_H_
#define _CATHELP_H_
#include <comcat.h>
HRESULT CreateComponentCategory(CATID catid, WCHAR* catDescription);
HRESULT RegisterCLSIDInCategory(REFCLSID clsid, CATID catid);
HRESULT UnRegisterCLSIDInCategory(REFCLSID clsid, CATID catid);
#endif

增加cathelp.cpp

#include "cathelp.h"
HRESULT CreateComponentCategory(CATID catid, WCHAR* catDescription)
{
	
    ICatRegister* pcr = NULL ;
    HRESULT hr = S_OK ;
	
    hr = CoCreateInstance(CLSID_StdComponentCategoriesMgr, 
		NULL, CLSCTX_INPROC_SERVER, IID_ICatRegister, (void**)&pcr);
	if (FAILED(hr))
		return hr;
	
    // Make sure the HKCR\Component Categories\{..catid...}
    // key is registered
    CATEGORYINFO catinfo;
    catinfo.catid = catid;
    catinfo.lcid = 0x0409 ; // english
	
	// Make sure the provided description is not too long.
	// Only copy the first 127 characters if it is
	int len = wcslen(catDescription);
	if (len>127)
		len = 127;
    wcsncpy(catinfo.szDescription, catDescription, len);
	// Make sure the description is null terminated
	catinfo.szDescription[len] = '\0';
	
	if(pcr)
	{
		hr = pcr->RegisterCategories(1, &catinfo);
		pcr->Release();
	}
	
	return hr;
}
HRESULT RegisterCLSIDInCategory(REFCLSID clsid, CATID catid)
{
	// Register your component categories information.
    ICatRegister* pcr = NULL ;
    HRESULT hr = S_OK ;
    hr = CoCreateInstance(CLSID_StdComponentCategoriesMgr, 
		NULL, CLSCTX_INPROC_SERVER, IID_ICatRegister, (void**)&pcr);
    if (SUCCEEDED(hr))
    {
		// Register this category as being "implemented" by
		// the class.
		CATID rgcatid[1] ;
		rgcatid[0] = catid;
		hr = pcr->RegisterClassImplCategories(clsid, 1, rgcatid);
    }
	
    if (pcr != NULL)
        pcr->Release();
	
	return hr;
}
HRESULT UnRegisterCLSIDInCategory(REFCLSID clsid, CATID catid)
{
    ICatRegister* pcr = NULL ;
    HRESULT hr = S_OK ;
    hr = CoCreateInstance(CLSID_StdComponentCategoriesMgr, 
		NULL, CLSCTX_INPROC_SERVER, IID_ICatRegister, (void**)&pcr);
    if (SUCCEEDED(hr))
    {
		// Unregister this category as being "implemented" by
		// the class.
		CATID rgcatid[1] ;
		rgcatid[0] = catid;
		hr = pcr->UnRegisterClassImplCategories(clsid, 1, rgcatid);
    }
	
    if (pcr != NULL)
        pcr->Release();
	
	return hr;
}

修改 ocx的 DllRegisterServer 方法

#include "cathelp.h"
#include <objsafe.h>//for CATID_SafeForInitializing
#include "SafeocxtestCtl.h"
STDAPI DllRegisterServer(void)
{
	AFX_MANAGE_STATE(_afxModuleAddrThis);
	if (!AfxOleRegisterTypeLib(AfxGetInstanceHandle(), _tlid))
		return ResultFromScode(SELFREG_E_TYPELIB);
	if (!COleObjectFactoryEx::UpdateRegistryAll(TRUE))
		return ResultFromScode(SELFREG_E_CLASS);
	// 注册脚本安全
	if( FAILED( CreateComponentCategory(CATID_SafeForScripting, L"Controls that are safely scriptable") ) )
		return ResultFromScode(SELFREG_E_CLASS);
	
	if( FAILED( CreateComponentCategory(CATID_SafeForInitializing, L"Controls safely initializable from persistent data") ) )
		return ResultFromScode(SELFREG_E_CLASS);
	if (FAILED( RegisterCLSIDInCategory(
		CSafeocxtestCtrl::guid, CATID_SafeForScripting) ))
		return ResultFromScode(SELFREG_E_CLASS);
	
	if (FAILED( RegisterCLSIDInCategory(
		CSafeocxtestCtrl::guid, CATID_SafeForInitializing) ))
                return ResultFromScode(SELFREG_E_CLASS);
    
	return NOERROR;
}
/////////////////////////////////////////////////////////////////////////////
// DllUnregisterServer - Removes entries from the system registry
STDAPI DllUnregisterServer(void)
{
	AFX_MANAGE_STATE(_afxModuleAddrThis);
	if (!AfxOleUnregisterTypeLib(_tlid, _wVerMajor, _wVerMinor))
		return ResultFromScode(SELFREG_E_TYPELIB);
	if (!COleObjectFactoryEx::UpdateRegistryAll(FALSE))
		return ResultFromScode(SELFREG_E_CLASS);
	// 控件安全反初始化
    UnRegisterCLSIDInCategory(	CSafeocxtestCtrl::guid, CATID_SafeForScripting);
    UnRegisterCLSIDInCategory(	CSafeocxtestCtrl::guid, CATID_SafeForInitializing);
    
   
	return NOERROR;
}

编译注册就OK了。

如果要查看ocx是否是脚本安全的。在注册表HKEY_CLASSES_ROOT\CLSID\OCX的clsid\Implemented Categories\ 下看一下有没有“{7DD95801-9882-11CF-9FA9-00AA006C42C4}” 和“{7DD95802-9882-11CF-9FA9-00AA006C42C4}”

下图就是脚本安全的：

参考：http://support.microsoft.com/kb/161873/en-us

  1: #安装 依赖的开发包
  2: yum groupinstall "Development Tools"
  3: 
  4: #安装 wxGTK，我这个使用的是2.8.*测试是可以的
  5: yum install wxGTK*
  6: 
  7: #下载codeblocks安装
  8: #http://www.codeblocks.org/downloads/binaries#linux 
  9: # codeblocks-12.11-1.el6.i686.tar.bz2 (CentOS/RedHat 6)
 10: 
 11: #然后是解压安装
 12: #安装完成后，建立一个helloCB的工程，运行是提示 xTerm -T 失败。。。
 13: #于是
 14: yum install xterm
 15: # 完成
 16: 

  1: #!/bin/sh

  2: 	rpm -ivh mysql-5.0.77-4.el5_5.4.i386.rpm  --nodeps

  3: 	rpm -ivh perl-DBI-1.52-2.el5.i386.rpm

  4: 	rpm -ivh perl-DBD-MySQL-3.0007-2.el5.i386.rpm 

  5: 	

  6: 	rpm -ivh mysql-server-5.0.77-4.el5_5.4.i386.rpm

  7: ##设置MySQL服务随系统启动自启动

  8: 	chkconfig mysqld on

  9: 	echo "设置MySQL服务随系统启动自启动成功"

 10: ##启动MySQL服务

 11: 	echo "启动MySQL服务成功"

 12: 	/etc/rc.d/init.d/mysqld start

 13: ##关闭Linux的防火墙功能

 14: 	echo "防火墙已关闭"

 15: 	chkconfig iptables off

 16: ##授权root 远程

 17: 	grant all privileges on *.* to root@'%' identified by '123456';

 18: 

  1: USE dbtest;
  2: DELIMITER ;;
  3: 
  4: CREATE TRIGGER tr_ondel_test1 AFTER DELETE ON testtable1
  5: FOR EACH ROW BEGIN
  6: DELETE FROM testtable2 where testtable2.FID= OLD.ID;
  7: END;;
  8: 
  9: DELIMITER ;

删除触发器：

  1: DROP   TRIGGER  dbtest.tr_ondel_test1;

查看触发器：

  1: SHOW TRIGGERS FROM dbtest;
  2: 
  3: SHOW TRIGGERS FROM dbtest LIKE ‘%ondel%’;

导出存储过程和触发器：

  1: mysqldump -u root -p123456 --default-character-set=gbk --triggers dbtest >./bk.sql

  1: mysql> use ivm;
  2: Database changed
  3: mysql> show variables like '%char%';
  4: +--------------------------+---------------------------------------------------------+
  5: | Variable_name            | Value                                                   |
  6: +--------------------------+---------------------------------------------------------+
  7: | character_set_client     | latin1                                                  |
  8: | character_set_connection | latin1                                                  |
  9: | character_set_database   | gbk                                                     |
 10: | character_set_filesystem | binary                                                  |
 11: | character_set_results    | latin1                                                  |
 12: | character_set_server     | latin1                                                  |
 13: | character_set_system     | utf8                                                    |
 14: | character_sets_dir       | D:\Program Files\MySQL\MySQL Server 5.0\share\charsets\ |
 15: +--------------------------+---------------------------------------------------------+
 16: 8 rows in set (0.00 sec)
 17: 
 18: mysql>

在 ivm数据库中创建存储过程及调用结果如下：

  1: delimiter ;;
  2: DROP PROCEDURE IF EXISTS r_test;
  3: CREATE PROCEDURE r_test(IN inStr VARCHAR(255) )
  4: BEGIN
  5: 	SELECT CHARSET(inStr);
  6: END;;
  7: delimiter ;
  8: 
  9: #下面的语句都执行失败,错误信息为：Data too long for column 'inStr' at row 1
 10: call r_test('中国');
 11: call r_test(_gbk'中国');
 12: SET @china = _gbk'中国';
 13: CALL r_test(@china);
 14: #执行成功 返回值是：latin1
 15: call r_test('china');
 16: 
 17: 
 18: # 创建存储过程中设置了 参数的字符集
 19: delimiter ;;
 20: DROP PROCEDURE IF EXISTS r_test2;
 21: CREATE PROCEDURE r_test2(IN inStr VARCHAR(255) character set gbk)
 22: BEGIN
 23: 	SELECT CHARSET(inStr);
 24: END;;
 25: delimiter ;
 26: 
 27: #执行成功 返回值是：gbk
 28: call r_test2('中国');
 29: #执行成功 即使执行前设置了字符集是utf8返回值仍然是：gbk
 30: call r_test2(_utf8'中国');
 31: #执行成功 返回值是：gbk
 32: call r_test2('china');

结论：创建存储过程时如果没有指定存储过程的参数的字符集，mysql总是认为当前的参数使用的是系统的字符集(windows 下 my.ini中的 default-character-set指定)。

否则，mysql总是认为存储过程的参数使用的就是定义时指定的字符集。

需要注意的是：上面的规则和当前的连接字符集没有任何的关系（使用mysql_options(m_pMySql, MYSQL_SET_CHARSET_NAME, "utf8")也不会改变）

  1: DROP TABLE IF EXISTS alarm;

  2: CREATE TABLE alarm     ( id int(11) NOT NULL  auto_increment, name    varchar(255) default NULL,PRIMARY KEY (id));

  3:  

  4: INSERT INTO alarm (name) values('aa');

  5: INSERT INTO alarm (name) values('bb');

  6:  

  7: DROP procedure if exists statalarm;

  8: delimiter // 

  9: create procedure statalarm()

 10: begin

 11: SET @id  = '1,2';

 12: 

 13: SET @sql = 'select * from alarm where id IN (?)';

 14: PREPARE stmt FROM @sql;

 15: /* 

 16:  注意 EXECUTE 的最终语句是：select * from alarm where id IN ('1,2');

 17:  而不是 select * from alarm where id IN (1,2);

 18:  这是因为如果用户变量的值是字符串，在EXECUTE时 会自动的在变量的值前后加上引号

 19:  */

 20: EXECUTE stmt USING @id;

 21: DEALLOCATE PREPARE stmt;

 22: /*

 23:  如果想要 组成select * from alarm where id IN (1,2);可以使用下面的语句

 24: */

 25: SET @sql = concat('select * from alarm where id IN (',@id,')');

 26: PREPARE stmt FROM @sql;

 27: EXECUTE stmt ;

 28: DEALLOCATE PREPARE stmt;

 29:  

 30: end;//

 31: delimiter ;

第一个解决方案就是把c.so放到/usr/lib或 /usr/local/lib下。

第二种解决方案是 在makefile文件中定义 环境变量 LD_LIBRARY_PATH 设置值为c.so的存放目录。

   1: #ifndef _FOO_H_

   2: #define _FOO_H_

   3: #include <stdio.h>

   4: #include<iostream>

   5: #include<string>

   6:  

   7: class foo

   8: {

   9: public:

  10:     template<typename T>

  11:         void Saytype(const T&)

  12:     {

  13:         std::cout <<"unrecognized  type !"<<std::endl;

  14:     }

  15:  

  16:     // 下面的全特化在 vc6下编译通过，但g++ 4.1.2 编译失败

  17: //     template<>

  18: //         void Saytype<int>(const int & )

  19: //     {

  20: //         std::cout<<" type is int";

  21: //     }

  22:     // g++上可以使用重载来代替全特化

  23:     void Saytype(const int &)

  24:     {

  25:         std::cout<<" type is int";

  26:     }

  27: };

  28:  

  29: #endif

main.cpp

   1: #include "../include/foo.h"

   2:  

   3: int main()

   4: {

   5:     

   6:     foo f;

   7:     f.Saytype((unsigned int)1);

   8:     f.Saytype((int)1);

   9:  

  10:     return 1;

  11: }