请大侠帮我看下列代码为什么不能创建数据源:
CString TmpStr=_T("Dsn=Xgbill\0Server=127.0.0.1\0Database=Xgbill\0Network=DBMSSOCN && DBMSSOCN=TCP/IP Connection\0\0");
BOOL RV=SQLConfigDataSource(this->m_hWnd,ODBC_ADD_SYS_DSN,"SQL Server",(LPCTSTR)TmpStr);
程序运行不出错,死活不能创建数据源?
CString TmpStr=_T("Dsn=Xgbill\0Server=127.0.0.1\0Database=Xgbill\0Network=DBMSSOCN && DBMSSOCN=TCP/IP Connection\0\0");
BOOL RV=SQLConfigDataSource(this->m_hWnd,ODBC_ADD_SYS_DSN,"SQL Server",(LPCTSTR)TmpStr);
程序运行不出错,死活不能创建数据源?
BOOL RV=SQLConfigDataSource(this->m_hWnd,ODBC_ADD_SYS_DSN,"SQL Server",(LPCTSTR)TmpStr);
char tempch[60];
strcpy(tempch,"DSN=");
CString strKeyName=strcat(tempch,m_fName); // "DSN=m_fName"
if(SQLConfigDataSource(NULL,ODBC_ADD_DSN,m_driver,strKeyName))
{
…………
}
绝对可以,我试过的
if(FALSE==SQLConfigDataSource(NULL,ODBC_ADD_SYS_DSN,"SQL Server",(LPCSTR)TmpStr) )
MessageBox("fail!");请大侠们帮我建立与SqlServer的数据源连接!
"DSN=MyDSN\0DESCRIPTION=SQLConfigDSN Sample\0"
"SERVER=(local)\0ADDRESS=127.0.0.1\0NETWORK=dbmssocn\0"
"DATABASE=pubs\0";::SQLConfigDataSource(NULL,ODBC_ADD_DSN,"SQL Server",lpszAttributes);这种格式可以加,只是无法加用户名和密码;
下面是winnt认证的,可以通过 LPCSTR lpszAttributes =
"DSN=MyDSN\0DESCRIPTION=SQLConfigDSN Sample\0Trusted_Connection=false\0"
"SERVER=(local)\0ADDRESS=127.0.0.1\0NETWORK=dbmssocn\0"
"DATABASE=pubs\0";::SQLConfigDataSource(NULL,ODBC_ADD_DSN,"SQL Server",lpszAttributes);
CHAR *szAttributes =
"DSN=MyDSN\0DESCRIPTION=SQLConfigDSN Sample\0"
"SERVER=MySQL\0ADDRESS=MyServer\0NETWORK=dbmssocn\0"
"DATABASE=pubs\0";retcode = SQLConfigDataSource(NULL,
ODBC_ADD_DSN,
szDriver,
szAttributes);