Hi,
I have a connection string
"Data Source=db1.myne t;DATABASE=test ;User ID=testuser;Pas sword=test;"
,
when i use the connection string to get a dataset of all the tables of
a database
it works without any problem, but when i try and call a stored
procedure i get an
exception trace like :
"...Additio nal information:
System.Web.Serv ices.Protocols. SoapException: Server was
unable to process request. ---> System.Argument Exception: Format of
the initialization
string does not conform to specification starting at index 0.
at System.Data.Com mon.DBConnectio nString.GetKeyV aluePair(Char[]
connectionStrin g, Int32 currentPosition , String& key, Char[] valuebuf,
Int32& vallength, Boolean& isempty)
at System.Data.Com mon.DBConnectio nString.ParseIn ternal(Char[]
connectionStrin g, UdlSupport checkForUdl, NameValuePair& keychain)
at System.Data.Com mon.DBConnectio nString..ctor(S tring
connectionStrin g, UdlSupport checkForUdl)
at System.Data.Sql Client.SqlConne ctionString..ct or(String
connectionStrin g)
at System.Data.Sql Client.SqlConne ctionString.Par seString(String
connectionStrin g)
at System.Data.Sql Client.SqlConne ction.set_Conne ctionString(Str ing
value)
at System.Data.Sql Client.SqlConne ction..ctor(Str ing
connectionStrin g)
at Microsoft.Appli cationBlocks.Da ta.SqlHelper.Ex ecuteDataset(St ring
connectionStrin g, CommandType commandType, String commandText,
SqlParameter[] commandParamete rs) in C:\Program Files\Microsoft
Application Blocks for .NET\Data Access ...."
I googled a bit and have traced this to a probable bug, described in
Microsoft Knowledge Base Article - 823679
(http://support.microsoft.com/default...;en-us;823679).
So my questions are :-
1. Is there something wrong with the connection string that i am
using,
2. According to the article i need the following files :-
Date Time Version Size File name
--------------------------------------------------------------
27-Jun-2003 15:01 1.1.4322.918 1,294,336 System.data.dll
30-Jun-2003 22:27 1.0.0.0 1,629,352
Ndp1.1-kb823679-x86.exe
03-Jul-2003 03:20 5.3.17.17 709,920
Windowsserver20 03-kb821415-x86-enu.exe
Where can i get these files from?
I am using :
* .NET Framework 1.1 version 1.1.4322
* Microsoft Devel. Envi. 2003 Version 7.1.3088
* OS : XP Professional Version 2002 Service Pack 1
Regards
Gaurav