How long will an ADO connection object remains connected to SQL server if there is no communication at all from the client side??
Shamoon
Posts
-
ADO connection object -
...Microsoft Certified professional.In India Subia Hashmat, 11 and Supriya Singh, 12 are probably the youngest "person ever to attempt and clear the Microsoft Certified Professional examination." Story at http://www.rediff.com/computer/1999/aug/04mcp.htm Meanwhile in Pakistan a 12-year girl Sheeza Ahmed "is the youngest Microsoft Certified System Engineer". Details at http://www.pakistannation.com/pakworld/youngMCSE.htm
-
A SQL queryI got a table
mytable
in SQL server database. The table contains 20 records. If i execute queryselect * from mytable
, total 20 records are returned. If i want the first four records, i execute the queryselect top 4 * from mytable
, and it returns the first four records. Can anyone tell me about the queries in following cases: 1) Selecting last 4 records from table. 2) Selecting records 9 to 15 from the table. -
IRAQ nuke attackJoe Woodbury wrote: Moreover, the US, Britain and France have multilayered safeguards on the use of their nuclear weapons. Iraq, North Korea and other rogue states have no such thing. Such safe guards are of no use because they are controlled by leadership, and once moron leadership decided to turn them, the result is destruction... remember USA was the first to throw nuclear cake on Japan..
-
How does a war against Iraq affect you?Emcee Lam wrote: he US would like Pakistan to lay down its nuclear weapons Why only Pakistan and not India ????
-
How does a war against Iraq affect you?Thomas George wrote: In Pakistan, militancy is secret-service sponsored. They recently released leaders of a group Lashkar-e-Taiba, which is in the US terrorist groups list, citing no evidence. FYI, Lashkar-e-Taiba was sponsored by USA during its "virtual" war with USSR in Afghanistan during 80s.
-
How does a war against Iraq affect you?Thomas George wrote: Pakistan has been more dangerous because they have made another country nuclear-capable No my dear, who made Pakistan Nuclear capable?? Pakistan's Nuclear program was started by Dr. Abdul Qadir Khan who was graduated from Holland and was working there. At that time, i remember, many western news papers blamed Holland for transfering metallurgy plants to Pakistan. Most of the early days scientists of Pakistan nuclear program were US graduates. Last year ago a ship was caught near British ports in which neuclear material was captured which was heading towards Pakistan. The nuclear production style of Pakistan is based on Heavy Water (D20) and Gas centrifuges, something similar to that of style used in US So, if you think that a country that transfers nuclear technology to others is dangerous, then those countries are more dangerous that provided nuclear know how to Pakistan.
-
..about US foreign policyFelix Gartsman wrote: With Pakistan, US is too late. Disarming Pakistan today is nuclear war for sure. Why talking about disarming Pakistan and not India?? Is there no extremism in India. Has India not fought wars with China and Pakistan. Has India having no tension along the borders of Bangladesh ??? Is there no extremism inside India??
-
..about US foreign policyThomas George wrote: Think about Pakistan. CIA tells us that they provided nuclear material to N Korea. There is not even a statement from the Bush administration USA was the first country that provided technology to Pakistan during early 70s to build nuclear power plants. May be you are unaware of that.
-
Is Linux confusing M$ -
SQL Server Stored procedureI've created a stored procedure using SQL server query analyzer. The procedure takes single argument which is an output variable and return certain integer value. The procedure is something like this:
CREATE PROCEDURE DBO.MUMAdds
@addtype intoutput
ASSET @addtype=100
return 20GO
Now i want to execute this procedure using query analyzer, in order to get two values i.e the value this function return and the output value that is passed as a parameter to this procedure. Can anyone tell me that how can i execute this procedure i.e supplying paremeter variable and getting returned value in a variable ????
-
More Money or Less Money? C++ vs C# -
MFC Sockets - Urgent!!!Vladimir Georgiev wrote: if you know what the multithreading sequence must be using CSocket or CAsyncSocket Never use MFC socket classes in Multithreaded environment, otherwise you'll be between the devil and the deep sea. MFC not allows you to pass CSocket/CAsync objects directly from one thread to another. You have to use references for that purpose. Have a look here[^]
-
ADO relatedI am in search of ADO wrapper class in C++ without using MFC. I want to use it in console app. The class should support ADO operations like connection to Data Base source, query execution and execution of stored procedures. If you know about any such wrapper class/framework then please let me know... Thanks
-
EID Greetings to All Muslims -
Web server (which is best)I've seen many "horrible" discussions here at CP comparing Java Vs VC++ OR SQL-server Vs Oracle... OR many like that. My intention is not to start another war of flames here :) Here i want to ask you people that which web server is the best ?? Since i worked only on Microsoft technologies, i've only dealt with IIS. I am also little bit fimiliar with its internal working like: it uses I/O completion ports, based on winsock 2 model, uses AcceptEx() for accepting incoming connections, uses transmitfile() API .e.t.c As such i can say that it is based on excellent winsock programming model and so it is highly scalable. But the problem is that i don't know about any other web server because i had no chance in the past to deal with any thing other than IIS. I've heard about Apache, a lot but unfortunately never worked on it. So i want to ask which web-server existed today is the best. What other web servers offer advantage to IIS. What are the features of IIS that makes it superior to the others. What are the features of others that made IIS inferior in front of them ????
-
Winsock gethostbyaddr problemI know the ip address of a host and i want to know the name of that host. For this purpose i am using following code:
struct hostent *hp; unsigned int addr = inet_addr(m_strHost); hp = gethostbyaddr((char *)&addr,4,AF_INET); if (hp == NULL ) { printf("\n Failed: %d",WSAGetLastError()); } else { printf( "%s\n\n", hp->h_name ); }
It is working fine for my LAN that uses ip address of type 192.x.x.x. But the problem occurs when i give the ip address of host over internet. As such sometimes
gethostbyaddr
is successful and in most cases it fails. It fails with error 11004 (i.e A blocking Windows Socket 1.1 call was canceled through WSACancelBlockingCall) Strange that it is happening in office and not at home. Any idea ??? Or any other alternative way to determine host name when ip address is known ??? Strange that it is not failing in all cases. For example, the ipaddress of yahoo.com is: 64.58.79.230. If i give this ip address then, the program runs successful and the hostname returned as: w1.rc.vip.dcx.yahoo.com But if i give the ip address: 207.219.70.31 (which is that of codeproject.com), then i get error 11004, and gethostbyaddr returns NULL -
Iraq threatens to use chemical weapons (the ones it "doesn't" have)From Article: Iraq had used chemical weapons during the war with Iran and would use them again if necessary Who provided those weapons to Iraq during war with Iran ?? Hmm, interesting to see whether Iraq will be able to use such weapons against 'the countries responsible' for providing this technology to Iraq. :wtf:
-
Hidden window -
Windows 2000/XPHow can i get rid of start-up programs and their relative systray icons from Windows 2000/XP. Back during the days of Windows 98/ME, there was a utility called msconfig that i used to do so. Is there anything equivalent of msconfig in Win2k/XP ??