Click here to Skip to main content
15,884,836 members
Home / Discussions / Database
   

Database

 
GeneralRe: ExecuteScalar with COUNT causes Exception? Pin
jeff_martin12-Nov-03 7:25
jeff_martin12-Nov-03 7:25 
GeneralRe: ExecuteScalar with COUNT causes Exception? Pin
Pauwll12-Nov-03 16:27
Pauwll12-Nov-03 16:27 
GeneralRe: ExecuteScalar with COUNT causes Exception? Pin
jeff_martin13-Nov-03 3:41
jeff_martin13-Nov-03 3:41 
GeneralRe: ExecuteScalar with COUNT causes Exception? Pin
Pauwll13-Nov-03 5:07
Pauwll13-Nov-03 5:07 
GeneralPutting fixed array into DB field Pin
EddieSD647-Nov-03 11:31
sussEddieSD647-Nov-03 11:31 
GeneralStored Procs, parameters and IN Clause Pin
stephen woolhead7-Nov-03 5:00
stephen woolhead7-Nov-03 5:00 
GeneralRe: Stored Procs, parameters and IN Clause Pin
jeff_martin11-Nov-03 12:04
jeff_martin11-Nov-03 12:04 
GeneralSQL Server does not exist or access denied Pin
yyf7-Nov-03 2:50
yyf7-Nov-03 2:50 
I have a problem here. I tried to connect sqlserver as many time as I can in one function, because I want to know about the limitation of connection of sqlserver, btw, the sqlserver is not in my computer, the code is like :

		private void ExecuteCommand_ConnTest_process()<br />
		{<br />
			ArrayList conn = new ArrayList(3000);<br />
			int num = 0;<br />
<br />
			string conn_s = "...";<br />
			conn_s += "Connect Timeout=600;Max Pool Size=1000000;";<br />
<br />
			try<br />
			{<br />
				while ( true ) <br />
				{<br />
					conn.Add(new SqlConnection(conn_s));<br />
					((IDbConnection)conn[num]).Open();<br />
					num ++; <br />
					Thread.Sleep(10);<br />
				}<br />
			}<br />
			catch( InvalidOperationException ioexp )<br />
			{<br />
				StringBuilder buildError = new StringBuilder();<br />
				buildError.Append( "InvalidOperationException thrown when trying to connect "  );<br />
				buildError.Append( ", error given = " + ioexp.Message);<br />
                             MessageBox.Show(builderError.ToString());<br />
			}<br />
			catch ( Exception e ) <br />
			{<br />
				StringBuilder buildError = new StringBuilder();<br />
				buildError.Append( "Exception thrown when trying to connect "  );<br />
				buildError.Append( ", error given = " + e.Message );<br />
<br />
                             MessageBox.Show(builderError.ToString());<br />
			}<br />
			finally<br />
			{<br />
                             MessageBox.Show(builderError.ToString());<br />
			}<br />
		}


After certain number connections, such 6000, it throws an exception:
"SQL Server does not exist or access denied". Then I found I can not access Internet. I have to restart my computer. Why this happened? What's wrong with my code? Could anyone please tell me? Thanks in advance!
GeneralProblem with _Connection::Open ! Pin
nigs_krec7-Nov-03 1:53
nigs_krec7-Nov-03 1:53 
GeneralManaged .NET Embedded Database Pin
Andrew Shapira6-Nov-03 10:11
Andrew Shapira6-Nov-03 10:11 
GeneralRe: Managed .NET Embedded Database Pin
Mike Dimmick7-Nov-03 2:54
Mike Dimmick7-Nov-03 2:54 
GeneralRe: Managed .NET Embedded Database Pin
Andrew Shapira7-Nov-03 10:17
Andrew Shapira7-Nov-03 10:17 
GeneralRe: Managed .NET Embedded Database Pin
Arjan Einbu10-Nov-03 11:01
Arjan Einbu10-Nov-03 11:01 
GeneralRe: Managed .NET Embedded Database Pin
Andrew Shapira10-Nov-03 13:57
Andrew Shapira10-Nov-03 13:57 
GeneralMax Pool Size's Limitation Pin
yyf6-Nov-03 8:43
yyf6-Nov-03 8:43 
GeneralCreating a DBASE file Pin
DonBush6-Nov-03 4:04
DonBush6-Nov-03 4:04 
GeneralRe: Creating a DBASE file Pin
Jörgen Sigvardsson6-Nov-03 14:00
Jörgen Sigvardsson6-Nov-03 14:00 
GeneralRe: Creating a DBASE file Pin
DonBush7-Nov-03 2:33
DonBush7-Nov-03 2:33 
GeneralRe: Creating a DBASE file Pin
Jörgen Sigvardsson7-Nov-03 3:14
Jörgen Sigvardsson7-Nov-03 3:14 
GeneralRe: Creating a DBASE file Pin
DonBush7-Nov-03 4:10
DonBush7-Nov-03 4:10 
GeneralRe: Creating a DBASE file Pin
Arjan Einbu10-Nov-03 11:07
Arjan Einbu10-Nov-03 11:07 
GeneralRe: Creating a DBASE file Pin
DonBush11-Nov-03 2:47
DonBush11-Nov-03 2:47 
QuestionMust be a permissions thing, but what? Pin
Colin Angus Mackay6-Nov-03 4:04
Colin Angus Mackay6-Nov-03 4:04 
Answer(Actually it wasn't) Pin
Colin Angus Mackay6-Nov-03 5:33
Colin Angus Mackay6-Nov-03 5:33 
GeneralRe: (Actually it wasn't) Pin
Michael Dunn6-Nov-03 13:01
sitebuilderMichael Dunn6-Nov-03 13:01 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.