请教数据库连接问题:出现错误sql server不存在或访问被拒绝.
datamoudle中的代码
String sUserID,sPassWord,sDATABASENAME,sSERVERNAME;
TIniFile *ini;
ini = new TIniFile( ChangeFileExt( "a", ".INI" ) );
sUserID = ini->ReadString( "DatabaseStrings", "USERID", "sa" );
sPassWord = ini->ReadString( "DatabaseStrings", "Password", "007" );
sDATABASENAME = ini->ReadString( "DatabaseStrings", "DATABASENAME", "mis" );
sSERVERNAME = ini->ReadString( "DatabaseStrings", "SERVERNAME","(local)" );
delete ini;
String sTemp ;
sTemp = sTemp + "Provider=SQLOLEDB.1;" ;
sTemp = sTemp + "Password="+sPassWord+";" ;
sTemp = sTemp + "User ID=" +sUserID + ";";
sTemp = sTemp + "Initial Catalog=" + sDATABASENAME + ";";
sTemp = sTemp + "Data Source=" + sSERVERNAME ;
ADOConnection1->ConnectionString = sTemp;
ADOConnection1->Connected=true;
ADOConnection1->Open();
我的ini文件:
[DatabaseStrings]
userid=sa
Password=007
DATABASENAME=mis
SERVERNAME=(local)