C++连接oracle数据库连接字符串

//远程连接，需要安装oracle客户端sprintf(szConnect4, ("Provider = OraOLEDB.Oracle.1; Password = %s; Persist Security Info = True; User ID = %s; Data Source = \"(DESCRIPTION =(ADDRESS_LIST =(ADDRESS = (PROTOCOL = TCP)(HOST = %s)(PORT = 1521)) )(CONNECT_DATA = (SID = %s)))\""),"密码","用户名","ip","数据库");//实验得知：64位操作系统，11g数据库可以连接，原因是我本地编译环境是64位，11g，同时ado库引用系统的目录即可sprintf(szConnect2, "Provider = OraOLEDB.Oracle; User ID = %s; Password = %s; Data Source = %s; Persist Security Info = False","***","***","***");//实验得知：32位9i数据库和64位11g数据库都可以连接成果，前提条件是ado库单独引用//#import "msado15.dll" rename_namespace("ADOCG") rename("EOF", "EndOfFile")sprintf(szConnect1, "Provider=OraOLEDB.Oracle.1;Password=%s;Persist Security Info=True;User ID=%s;Data Source=%s","***","***","***");//需要配置数据源sprintf(szConnect3, "Provider = MSDASQL.1; Persist Security Info = False; User ID = %s; PassWord = %s; Data Source = %s","***","***","***");//配置数据源m_pDatabase->SetConnectionTimeout(1);if (m_pDatabase->Open(szConnect1) ||m_pDatabase->Open(szConnect2) ||m_pDatabase->Open(szConnect3) ||m_pDatabase->Open(szConnect4)){return true;}

查看连接字符串可以使用这个方法：https://zhangzc.blog.csdn.net/article/details/128548644