CString strServer = "192.168.0.16";
CString strDbName = "student";
CString strUser = "Administrator";
CString strPass = "";/////////////////////CString strConnect = _T("Provider=SQLOLEDB.1; Data Source=") + dbsrc +
_T("; Initial Catalog=") + dbname +
_T("; User ID=") + user +
_T("; PWD=") + pass;try
{
m_pConnection->Open(_bstr_t(LPCTSTR(m_strConnect)), "", "", lOptions);
}
catch (_com_error e)
{
TRACE(_T("Warning: 连接数据库发生异常. 错误信息: %s; 文件: %s; 行: %d\n"), e.ErrorMessage(), __FILE__, __LINE__);
TRACE(_T("%s\r\n"), GetLastErrorText());
return FALSE;
}
catch (...)
{
TRACE(_T("Warning: 连接数据库时发生未知错误:"));
}
CString strDbName = "student";
CString strUser = "Administrator";
CString strPass = "";/////////////////////CString strConnect = _T("Provider=SQLOLEDB.1; Data Source=") + dbsrc +
_T("; Initial Catalog=") + dbname +
_T("; User ID=") + user +
_T("; PWD=") + pass;try
{
m_pConnection->Open(_bstr_t(LPCTSTR(m_strConnect)), "", "", lOptions);
}
catch (_com_error e)
{
TRACE(_T("Warning: 连接数据库发生异常. 错误信息: %s; 文件: %s; 行: %d\n"), e.ErrorMessage(), __FILE__, __LINE__);
TRACE(_T("%s\r\n"), GetLastErrorText());
return FALSE;
}
catch (...)
{
TRACE(_T("Warning: 连接数据库时发生未知错误:"));
}
解决方案 »
- 网页用的OCX会依赖几个DLL,而OCX会从当前目录去找DLL,请教DLL应该安装在什么地方?
- 全局变量问题
- GetMeesage总是会收到一个WM_QUIT消息,请教
- Nero SDK问题
- 傻傻的问题继续问,关于CSplitterWnd.
- VC++.net2003下怎样加入Splash Screen?
- 请问怎样在服务器程序退出前结束监听线程?
- 在线急候--C++异常忽略
- 我是新来的,有用过InstallShield的朋友吗?
- 如何获取系统当前时间,并将它转换为32或64位格式
- 在Dialog中根据Edit box 和Slider得变化随时改变显示的参数值怎么搞?
- dll显式调用时,利用DLL3LIB生成的LIB不可用,如何把它改为隐式调用呢?
dbname->strDbName
......
strConnection = _T("Provider=sqloledb;User ID=sa;Password=;Data Source=192.168.0.7;Initial Catalog=datebasename");g_pConnection->Open((LPCTSTR)strConnection,"","",adConnectUnspecified);数据库属性里最好设置为混合模式登陆。
strConnect = _T("Provider=sqloledb;Data Source=(local);Initial Catalog=myDatabaseName;"
"User ID=myUsername;Password=myPassword;");To connect to SQL Server running on a remote computer ( via an IP address): strConnect = _T("Provider=sqloledb;Network Library=DBMSSOCN;Data Source=130.120.110.001,1433;"
"Initial Catalog=MyDatabaseName;User ID=MyUsername;Password=MyPassword;");
如果不用ip,直接用server的名称就可以了
server的名称是不是指启动服务管理器时出现的那个组合框中出现的那几个名称?
对于SQL Server所在的机器是否要设置ODBC?
安装SQL Server是应该注意什么?
建立好数据库后,是否应该设置ODBC?
我的电脑是否还应该设置什么?
CString strServer = "192.168.0.16,1433";
CString strDbName = "student";
CString strUser = "";
CString strPass = "";/////////////////////CString strConnect = _T("Provider=SQLOLEDB.1; Network Library=DBMSSOCN; Data Source=") + dbsrc +
_T("; Initial Catalog=") + dbname +
_T("; Trusted_Connection=yes") +
_T("; User ID=") + user +
_T("; PWD=") + pass;在本地上没有问题,但是远程还是有问题,提示为用户‘friend’登录失败!
不知这是为什么,如何解决?请大家帮我在看看?
CString strConnect = _T("Provider=SQLOLEDB.1; Network Library=DBMSSOCN; Data Source=") + dbsrc +
_T("; Initial Catalog=") + dbname +
_T("; Integrated Security=SSPI") +
_T("; Persist Security Info=False") +
_T("; Trusted_Connection=yes") +
_T("; User ID=") + user +
_T("; PWD=") + pass;提示为无法打开登录‘BHCY’中请求的数据库。登录失败!
strConnect = _T("Provider=sqloledb;Network Library=DBMSSOCN;Data Source=192.168.0.16,1433;"
"Initial Catalog=student;User ID=sa;Password=Your pwd;");
connectionString的模板,按照那个东东就能连上了。现在的提示估计是数据库中没有建立登录数据库的用户。
我的数据库里的用户一栏里没有没有sa用户啊?
改为如下:
CString strConnect = _T("Provider=SQLOLEDB.1; Persist Security Info=False; Data Source=") + dbsrc +
_T("; Initial Catalog=") + dbname +
_T("; User ID=") + user +
_T("; password=") + pass;真是让人欲哭无泪啊!把PWD改为password, 再加上Persist Security Info=False一项就解决了。我看这个字窜有好几种写法,不值他们有什么区别:
比如
“driver={sql server};server=local;uid=sa;password=123;database=cqyw”
这个写法就至少在表面上比较好!我也试通了!谁有关于这些选项比较详细解释的资料???