http://www.sqlmag.com/authors/author/author/5645867/rsscomment/5645867en-USFri, 25 May 2012 08:18:11 GMTFri, 25 May 2012 08:18:11 GMThttp://www.sqlmag.com/article/stored-procedures/learning-about-ole-automation-stored-procedures7910#commentsAnchorSat, 07 Aug 2010 06:48:31 GMT
yea, this article is weak. I realize it is 2010 but believe it or not some companies still have sql2000 installs that don’t work. I paid 5.95 to find out nothing. Thanks]]>TaylorSat, 07 Aug 2010 06:48:31 GMThttp://www.sqlmag.com/article/stored-procedures/learning-about-ole-automation-stored-procedures7910#commentsAnchorhttp://www.sqlmag.com/article/visual-basic-vb/jump-start-your-database-project#commentsAnchorMon, 16 Nov 2009 06:34:13 GMT
It is amazing the number of applications still using VB6. The article is a good introduction to something that are very present in today’s IT environment ten years later! Take Care!]]>MarcosMon, 16 Nov 2009 06:34:13 GMThttp://www.sqlmag.com/article/visual-basic-vb/jump-start-your-database-project#commentsAnchorhttp://www.sqlmag.com/article/quering/querying-reporting-generate-reports-with-word#commentsAnchorThu, 10 Sep 2009 18:09:45 GMT
Very good article... thanks for the nnowledge]]>CurtisThu, 10 Sep 2009 18:09:45 GMThttp://www.sqlmag.com/article/quering/querying-reporting-generate-reports-with-word#commentsAnchorhttp://www.sqlmag.com/article/vbscript/iis-scripting-solutions#commentsAnchorSat, 15 Nov 2008 01:11:37 GMT
i am able to get physical path of virtual directories from iis but if i create websites not virtual directories then not able to get the physical path of websites from iis (i m using c#) please help]]>AmitSat, 15 Nov 2008 01:11:37 GMThttp://www.sqlmag.com/article/vbscript/iis-scripting-solutions#commentsAnchorhttp://www.sqlmag.com/article/certificates/using-win2k-certificate-services-to-configure-a-standalone-ca-part-1#commentsAnchorFri, 10 Oct 2008 14:09:54 GMT
JFKLDLJKFDJLKFDJLDLK]]>jonathanFri, 10 Oct 2008 14:09:54 GMThttp://www.sqlmag.com/article/certificates/using-win2k-certificate-services-to-configure-a-standalone-ca-part-1#commentsAnchorhttp://www.sqlmag.com/article/sql-server/using-sql-server-s-guid-feature#commentsAnchorWed, 07 Nov 2007 11:22:39 GMT
Todd, it’s a 128-bit number. AFAIK it is only evaluated as a string when parsing the SQL.]]>JonWed, 07 Nov 2007 11:22:39 GMThttp://www.sqlmag.com/article/sql-server/using-sql-server-s-guid-feature#commentsAnchorhttp://www.sqlmag.com/article/performance/hardware-s-golden-rule8645#commentsAnchorTue, 25 Sep 2007 11:34:56 GMT
This is a seven year old article. Many many changes since then.]]>ROSSTue, 25 Sep 2007 11:34:56 GMThttp://www.sqlmag.com/article/performance/hardware-s-golden-rule8645#commentsAnchorhttp://www.sqlmag.com/article/activex/querying-reporting-reporting-with-visual-basic-6-0#commentsAnchorTue, 31 Jul 2007 09:18:16 GMT
The described example is very basic and lacks to describe any grouping options which are more likely to occur for many reports. When working with Hierarchical data from an ADO recordset grouping does not work with the Data Report Designer. The Report Designer seems to be made exclusively for the Data Environment which in itself is cluncky and lacks the flexibility of dynamically generating recordsets.]]>RalphTue, 31 Jul 2007 09:18:16 GMThttp://www.sqlmag.com/article/activex/querying-reporting-reporting-with-visual-basic-6-0#commentsAnchorhttp://www.sqlmag.com/article/systems-administrator/iis-problem-resolution#commentsAnchorFri, 04 May 2007 14:37:22 GMT
ok]]>KENFri, 04 May 2007 14:37:22 GMThttp://www.sqlmag.com/article/systems-administrator/iis-problem-resolution#commentsAnchorhttp://www.sqlmag.com/article/systems-administrator/solving-iis-application-problems#commentsAnchorWed, 10 May 2006 09:19:14 GMT
it stops with Monitor to view the inetinfo.exe process CPU utilization. . . . and there doesn’t seem to be a link to read the rest.]]>SergioWed, 10 May 2006 09:19:14 GMThttp://www.sqlmag.com/article/systems-administrator/solving-iis-application-problems#commentsAnchorhttp://www.sqlmag.com/article/systems-administrator/solving-iis-application-problems#commentsAnchorWed, 10 May 2006 09:18:05 GMT
I am a subscriber and I cannot read the whole of the article.]]>SergioWed, 10 May 2006 09:18:05 GMThttp://www.sqlmag.com/article/systems-administrator/solving-iis-application-problems#commentsAnchorhttp://www.sqlmag.com/article/systems-administrator/iis-problem-resolution#commentsAnchorSat, 01 Apr 2006 09:17:16 GMT
Not able to read the complete artcel - no good]]>DonSat, 01 Apr 2006 09:17:16 GMThttp://www.sqlmag.com/article/systems-administrator/iis-problem-resolution#commentsAnchorhttp://www.sqlmag.com/article/activex/querying-reporting-reporting-with-visual-basic-6-0#commentsAnchorSat, 12 Nov 2005 22:39:15 GMT
Thank you very much for this article. It is really helpful. I have one question, though, is there a way where i can change the Report title dynamically? Thanks.]]>DukeSat, 12 Nov 2005 22:39:15 GMThttp://www.sqlmag.com/article/activex/querying-reporting-reporting-with-visual-basic-6-0#commentsAnchorhttp://www.sqlmag.com/article/server-extensions/debugging-with-visual-interdev#commentsAnchorThu, 29 Sep 2005 14:52:27 GMT
I tried so many help but nothing worked this worked thank a million.]]>bhavesh_parikh2004@yahoo.com Thu, 29 Sep 2005 14:52:27 GMThttp://www.sqlmag.com/article/server-extensions/debugging-with-visual-interdev#commentsAnchorhttp://www.sqlmag.com/article/activex/querying-reporting-reporting-with-visual-basic-6-0#commentsAnchorWed, 24 Aug 2005 03:18:47 GMT
dear sir can u just tell me how to dynamically set the datareport based upon the user mentioned data at runtime. uma]]>Anonymous User Wed, 24 Aug 2005 03:18:47 GMThttp://www.sqlmag.com/article/activex/querying-reporting-reporting-with-visual-basic-6-0#commentsAnchorhttp://www.sqlmag.com/article/tsql3/debugging-stored-procedures#commentsAnchorFri, 12 Aug 2005 04:22:48 GMT
Very Informative]]>Anonymous User Fri, 12 Aug 2005 04:22:48 GMThttp://www.sqlmag.com/article/tsql3/debugging-stored-procedures#commentsAnchorhttp://www.sqlmag.com/article/activex/querying-reporting-reporting-with-visual-basic-6-0#commentsAnchorTue, 09 Aug 2005 11:21:54 GMT
how to create online railway reservation form using VB6 with open source code.plz answer me at ur earliset]]>Anonymous User Tue, 09 Aug 2005 11:21:54 GMThttp://www.sqlmag.com/article/activex/querying-reporting-reporting-with-visual-basic-6-0#commentsAnchorhttp://www.sqlmag.com/article/server-extensions/debugging-with-visual-interdev#commentsAnchorWed, 03 Aug 2005 03:38:23 GMT
Is there a solution for Windows XP?]]>Anonymous User Wed, 03 Aug 2005 03:38:23 GMThttp://www.sqlmag.com/article/server-extensions/debugging-with-visual-interdev#commentsAnchorhttp://www.sqlmag.com/article/log-files/iis-exception-monitor#commentsAnchorMon, 01 Aug 2005 06:47:47 GMT
Hi :)]]>Anonymous User Mon, 01 Aug 2005 06:47:47 GMThttp://www.sqlmag.com/article/log-files/iis-exception-monitor#commentsAnchorhttp://www.sqlmag.com/article/activex/using-ado-s-xml-features7897#commentsAnchorTue, 05 Jul 2005 22:52:05 GMT
This reads like "hey - you can totally do this - and someday I’ll show you how!". I’ve read more informative scripts for infomercials.]]>Anonymous User Tue, 05 Jul 2005 22:52:05 GMThttp://www.sqlmag.com/article/activex/using-ado-s-xml-features7897#commentsAnchorhttp://www.sqlmag.com/article/activex/querying-reporting-reporting-with-visual-basic-6-0#commentsAnchorMon, 06 Jun 2005 02:12:36 GMT
pls let me know how to generate a report according to date requirements, I mean at run time querying the report for a perticuler date.Suppose if I want to generate a report for a perticuler date and that date will be entered by me at run time? Pls help me in this regard. regards S REDDY]]>Anonymous User Mon, 06 Jun 2005 02:12:36 GMThttp://www.sqlmag.com/article/activex/querying-reporting-reporting-with-visual-basic-6-0#commentsAnchorhttp://www.sqlmag.com/article/activex/querying-reporting-reporting-with-visual-basic-6-0#commentsAnchorSun, 05 Jun 2005 23:37:03 GMT
The tutorial is very good! However, it to make it an excellent complete tutorial it needs to have part where you explain how to pass parameter values from a form to the comand in the data envorinment in order to make the report dynamically!]]>Anonymous User Sun, 05 Jun 2005 23:37:03 GMThttp://www.sqlmag.com/article/activex/querying-reporting-reporting-with-visual-basic-6-0#commentsAnchorhttp://www.sqlmag.com/article/sql-server/discover-the-visual-database-tools#commentsAnchorFri, 20 May 2005 02:06:38 GMT
I can modify tables.. May be that it is a problem with the rights?]]>Anonymous User Fri, 20 May 2005 02:06:38 GMThttp://www.sqlmag.com/article/sql-server/discover-the-visual-database-tools#commentsAnchorhttp://www.sqlmag.com/article/windows-management-instrumentation-wmi/wmi-101-event-logging#commentsAnchorFri, 13 May 2005 00:53:33 GMT
there are some comments with problems... and no correction or feedback]]>Anonymous User Fri, 13 May 2005 00:53:33 GMThttp://www.sqlmag.com/article/windows-management-instrumentation-wmi/wmi-101-event-logging#commentsAnchorhttp://www.sqlmag.com/article/com-and-com/getting-started-with-com-#commentsAnchorTue, 26 Apr 2005 22:37:38 GMT
very usefull article]]>Anonymous User Tue, 26 Apr 2005 22:37:38 GMThttp://www.sqlmag.com/article/com-and-com/getting-started-with-com-#commentsAnchorhttp://www.sqlmag.com/article/activex/querying-reporting-reporting-with-visual-basic-6-0#commentsAnchorSat, 23 Apr 2005 01:01:30 GMT
dear sir, this dhurai, having a problem to put serial number for the records displayed in datareport.and another major problem i face is, i want to disply images of employee in datareport for each record. one of my field in access database having path for images...so pls..help me to solve this problems...i am curioulsy waiting for ur mail...dhurai_mas@yahoo.com..thank you kind regards, dhurai ]]>Anonymous User Sat, 23 Apr 2005 01:01:30 GMThttp://www.sqlmag.com/article/activex/querying-reporting-reporting-with-visual-basic-6-0#commentsAnchorhttp://www.sqlmag.com/article/server-extensions/debugging-with-visual-interdev#commentsAnchorSat, 16 Apr 2005 09:29:13 GMT
you the man, saved me loads of time, thanks.]]>Anonymous User Sat, 16 Apr 2005 09:29:13 GMThttp://www.sqlmag.com/article/server-extensions/debugging-with-visual-interdev#commentsAnchorhttp://www.sqlmag.com/article/activex/querying-and-reporting-printing-reports-from-the-web#commentsAnchorFri, 08 Apr 2005 10:30:05 GMT
Your approach has many merits but ignores simpler solutions. Outputting the data to an xml document would allow it to be viewed in xml supporting browsers with the header on a per page basis as required or in newer versions of office (2002, XP etc.) provided an xsl was provided. The main problem I find with using browsers to generate and print reports is the layout. To make it visible to the viewer on the screen means making fonts of types and sizes that make it illegible on the printed report. An alternative to this is to use the newer versions of CSS (CSS-2) which allow for one style for screen representation and another for printed representation.]]>Anonymous User Fri, 08 Apr 2005 10:30:05 GMThttp://www.sqlmag.com/article/activex/querying-and-reporting-printing-reports-from-the-web#commentsAnchorhttp://www.sqlmag.com/article/server-extensions/debugging-with-visual-interdev#commentsAnchorTue, 29 Mar 2005 19:49:54 GMT
I followed the steps that Ken outlined to debug ASP on Win2K environment. I tried installing server extensions but it nerver worked!!!. Also tried reinstalling visual InterDev and Server Extensions over and over again. It never seeems to work. Do I need to install some service pack for Win2K to get it working? Can anyone help me to fix this debugging problem with Visual InterDev? Thanks Thusitha]]>Anonymous User Tue, 29 Mar 2005 19:49:54 GMThttp://www.sqlmag.com/article/server-extensions/debugging-with-visual-interdev#commentsAnchorhttp://www.sqlmag.com/article/activex/querying-reporting-reporting-with-visual-basic-6-0#commentsAnchorMon, 28 Mar 2005 23:02:38 GMT
i am Ratheesh I want to know is there any method to dynamically change the Title of the Report in data reports. I am really thankful for u if send response to ratheeshpkr@gmail.com]]>Anonymous User Mon, 28 Mar 2005 23:02:38 GMThttp://www.sqlmag.com/article/activex/querying-reporting-reporting-with-visual-basic-6-0#commentsAnchorhttp://www.sqlmag.com/article/activex/querying-reporting-reporting-with-visual-basic-6-0#commentsAnchorSat, 26 Mar 2005 05:01:46 GMT
I want to get selected records from the table on the basis condidtion which will get the value from the form text box . how do I put that value in SQL statement in Data report ???? PLease Hurry]]>Anonymous User Sat, 26 Mar 2005 05:01:46 GMThttp://www.sqlmag.com/article/activex/querying-reporting-reporting-with-visual-basic-6-0#commentsAnchorhttp://www.sqlmag.com/article/activex/querying-reporting-reporting-with-visual-basic-6-0#commentsAnchorSat, 12 Mar 2005 01:32:11 GMT
That’s a helpful article for beginners.I want to know that does any other sections exists besides the defalt sections i.e. Report Header,Page Footer,Page Header,Detail,report footer or can we create any other sections.]]>Anonymous User Sat, 12 Mar 2005 01:32:11 GMThttp://www.sqlmag.com/article/activex/querying-reporting-reporting-with-visual-basic-6-0#commentsAnchorhttp://www.sqlmag.com/article/activex/querying-reporting-reporting-with-visual-basic-6-0#commentsAnchorFri, 11 Mar 2005 16:15:09 GMT
stop glodssing ove rthe fact that it and ADO are brain-dead abortions from that little commie in Redmond, Washington.]]>Anonymous User Fri, 11 Mar 2005 16:15:09 GMThttp://www.sqlmag.com/article/activex/querying-reporting-reporting-with-visual-basic-6-0#commentsAnchorhttp://www.sqlmag.com/article/tsql3/debugging-stored-procedures#commentsAnchorWed, 09 Mar 2005 02:56:26 GMT
Good one...but I couldnt download the code!!]]>Anonymous User Wed, 09 Mar 2005 02:56:26 GMThttp://www.sqlmag.com/article/tsql3/debugging-stored-procedures#commentsAnchorhttp://www.sqlmag.com/article/quering/querying-reporting-using-cizer-to-customize-reports#commentsAnchorWed, 02 Mar 2005 09:22:32 GMT
You can write your own report generator for ASP.NET using RDL reader/writer (download the demo’s source code). http://www.rdlcomponents.com http://www.rdlcomponents.com/ASPExamples/Default.aspx?sm=b1_a ]]>Anonymous User Wed, 02 Mar 2005 09:22:32 GMThttp://www.sqlmag.com/article/quering/querying-reporting-using-cizer-to-customize-reports#commentsAnchorhttp://www.sqlmag.com/article/reporting2/integrating-cizer-and-asp-applications#commentsAnchorWed, 02 Mar 2005 09:21:47 GMT
http://www.rdlcomponents.com]]>Anonymous User Wed, 02 Mar 2005 09:21:47 GMThttp://www.sqlmag.com/article/reporting2/integrating-cizer-and-asp-applications#commentsAnchorhttp://www.sqlmag.com/article/reporting2/integrating-cizer-and-asp-applications#commentsAnchorWed, 02 Mar 2005 09:20:25 GMT
You can generate you own Web Based Report Generator using RDL reader/write from RDL Software, here is the online demo (source code available) http://www.rdlcomponents.com/ASPExamples/Default.aspx?sm=b1_a ]]>Anonymous User Wed, 02 Mar 2005 09:20:25 GMThttp://www.sqlmag.com/article/reporting2/integrating-cizer-and-asp-applications#commentsAnchorhttp://www.sqlmag.com/article/activex/querying-reporting-reporting-with-visual-basic-6-0#commentsAnchorMon, 28 Feb 2005 06:10:09 GMT
Very useful and I really appreciate the mini lecture. However, can you please explain how to group my report into group using code. Below is a sample of my report code. ssql = "select b.BankName, a.clearing_section, a.cheque_no, a.paying_bank_acct_no, a.amount, a.clearing_date, c.Presenting_Bank from clearing_capture a, BankMaster b, Reliance_Bank c Where Left(a.paying_bank_routing_no, 3) = Left(b.BankRoutingNumber, 3) and mid(a.paying_bank_routing_no,4,2) = mid(b.BankRoutingNumber,4,2) and a.clearing_section = ’" & Combo1.Text & "’ and a.clearing_date between #" & startdate & "# and #" & enddate & "# order by b.BankName, a.clearing_section,a.clearing_date" Set adoRecord = New Recordset connect adoRecord.Open ssql, conn, adOpenStatic, adLockOptimistic Set localdetail.DataSource = adoRecord localdetail.Show my email address are oyero@reliancebanklimited.com or oyerogbenga@yahoo.co.uk I will appreciate your quick response. Thank you. ]]>Anonymous User Mon, 28 Feb 2005 06:10:09 GMThttp://www.sqlmag.com/article/activex/querying-reporting-reporting-with-visual-basic-6-0#commentsAnchorhttp://www.sqlmag.com/article/internet/using-site-server-express-utilities#commentsAnchorSat, 19 Feb 2005 02:57:34 GMT
not]]>Anonymous User Sat, 19 Feb 2005 02:57:34 GMThttp://www.sqlmag.com/article/internet/using-site-server-express-utilities#commentsAnchorhttp://www.sqlmag.com/article/sql-server/using-sql-server-s-guid-feature#commentsAnchorMon, 07 Feb 2005 09:01:24 GMT
Should be 16 bytes long, this GUID type...]]>Anonymous User Mon, 07 Feb 2005 09:01:24 GMThttp://www.sqlmag.com/article/sql-server/using-sql-server-s-guid-feature#commentsAnchorhttp://www.sqlmag.com/article/activex/standardizing-data-access-with-ado-and-asp-scripts#commentsAnchorWed, 02 Feb 2005 02:47:48 GMT
how to use precision ]]>Rajini kanthWed, 02 Feb 2005 02:47:48 GMThttp://www.sqlmag.com/article/activex/standardizing-data-access-with-ado-and-asp-scripts#commentsAnchorhttp://www.sqlmag.com/article/task-scheduling/debugging-asp-applications-with-iis-and-visual-interdev#commentsAnchorThu, 27 Jan 2005 04:54:14 GMT
I have set script debugging option in IIS but I can’t able to debug, any one help me]]>Anonymous User Thu, 27 Jan 2005 04:54:14 GMThttp://www.sqlmag.com/article/task-scheduling/debugging-asp-applications-with-iis-and-visual-interdev#commentsAnchorhttp://www.sqlmag.com/article/visual-basic-vb/jump-start-your-database-project#commentsAnchorWed, 26 Jan 2005 22:06:31 GMT
Great!!! Thanks a lot. Saad]]>Anonymous User Wed, 26 Jan 2005 22:06:31 GMThttp://www.sqlmag.com/article/visual-basic-vb/jump-start-your-database-project#commentsAnchorhttp://www.sqlmag.com/article/activex/querying-reporting-reporting-with-visual-basic-6-0#commentsAnchorTue, 25 Jan 2005 03:35:28 GMT
Hello there, This is very usefull article for freshers like me and i have one problem in my VB6.0 environment. That is i didnt find the option "ADD DATA REPORT" in project menu. Please help me out thanks in advance. please reply ot my mail id gopi799@gmail.com Thanks once agian Gopi]]>GopiTue, 25 Jan 2005 03:35:28 GMThttp://www.sqlmag.com/article/activex/querying-reporting-reporting-with-visual-basic-6-0#commentsAnchorhttp://www.sqlmag.com/article/activex/vb-toolkit-tweaking-ado-for-performance#commentsAnchorSun, 23 Jan 2005 11:26:58 GMT
i asked about the 4 Cursor types and the description of the cursors...but no description is present.]]>Anonymous User Sun, 23 Jan 2005 11:26:58 GMThttp://www.sqlmag.com/article/activex/vb-toolkit-tweaking-ado-for-performance#commentsAnchorhttp://www.sqlmag.com/article/activex/querying-reporting-reporting-with-visual-basic-6-0#commentsAnchorSat, 22 Jan 2005 11:29:45 GMT
I guess people can think that the following link for MSDN is very usefull: http://msdn.microsoft.com/library/en-us/vbcon98/html/vbconUsingMicrosoftDataReportDesigner.asp]]>Anonymous User Sat, 22 Jan 2005 11:29:45 GMThttp://www.sqlmag.com/article/activex/querying-reporting-reporting-with-visual-basic-6-0#commentsAnchorhttp://www.sqlmag.com/article/server-extensions/debugging-with-visual-interdev#commentsAnchorFri, 21 Jan 2005 05:42:56 GMT
much thanks,same problem i handled,thanks again]]>Anonymous User Fri, 21 Jan 2005 05:42:56 GMThttp://www.sqlmag.com/article/server-extensions/debugging-with-visual-interdev#commentsAnchorhttp://www.sqlmag.com/article/activex/querying-reporting-reporting-with-visual-basic-6-0#commentsAnchorWed, 19 Jan 2005 03:15:29 GMT
I want to put records Serial number in details section and search option in data report of VB 6.0 and I have to use a single report to more than one modules How to use please help...?]]>Anonymous User Wed, 19 Jan 2005 03:15:29 GMThttp://www.sqlmag.com/article/activex/querying-reporting-reporting-with-visual-basic-6-0#commentsAnchorhttp://www.sqlmag.com/article/activex/querying-reporting-reporting-with-visual-basic-6-0#commentsAnchorMon, 17 Jan 2005 03:08:50 GMT
how to solve when error is report section does not match data source ]]>Anonymous User Mon, 17 Jan 2005 03:08:50 GMThttp://www.sqlmag.com/article/activex/querying-reporting-reporting-with-visual-basic-6-0#commentsAnchorhttp://www.sqlmag.com/article/windows-management-instrumentation-wmi/wmi-101-event-logging#commentsAnchorThu, 13 Jan 2005 13:50:20 GMT
When processing the Security Log, you must include a different impersonate level. Set objWMIService = GetObject("winmgmts:{impersonationLevel=impersonate,(Backup, Security)}!\\" & strComputer & "\root\cimv2") -MikeBlane]]>Anonymous User Thu, 13 Jan 2005 13:50:20 GMThttp://www.sqlmag.com/article/windows-management-instrumentation-wmi/wmi-101-event-logging#commentsAnchorhttp://www.sqlmag.com/article/activex/querying-and-reporting-printing-reports-from-the-web#commentsAnchorTue, 11 Jan 2005 04:52:59 GMT
sds]]>Anonymous User Tue, 11 Jan 2005 04:52:59 GMThttp://www.sqlmag.com/article/activex/querying-and-reporting-printing-reports-from-the-web#commentsAnchorhttp://www.sqlmag.com/article/distributed-comdcom/introduction-to-iis-4-0-with-mts-and-dcom#commentsAnchorThu, 30 Dec 2004 02:58:50 GMT
534]]>Anonymous User Thu, 30 Dec 2004 02:58:50 GMThttp://www.sqlmag.com/article/distributed-comdcom/introduction-to-iis-4-0-with-mts-and-dcom#commentsAnchorhttp://www.sqlmag.com/article/task-scheduling/debugging-asp-applications-with-iis-and-visual-interdev#commentsAnchorWed, 22 Dec 2004 06:14:20 GMT
Does anyone know if the developer needs to be logged in with administrator access into the development PC also. Can user work on a PC without admin access?]]>Anonymous User Wed, 22 Dec 2004 06:14:20 GMThttp://www.sqlmag.com/article/task-scheduling/debugging-asp-applications-with-iis-and-visual-interdev#commentsAnchorhttp://www.sqlmag.com/article/task-scheduling/debugging-asp-applications-with-iis-and-visual-interdev#commentsAnchorSat, 18 Dec 2004 08:29:54 GMT
Activating server- and client-side debugging creates overhead on the IIS server because these options apply to all pages associated with the application you want to debug. This overhead can slow a busy Web site’s response time. For this reason, I recommend that you completely debug your application on a test or development server]]>Anonymous User Sat, 18 Dec 2004 08:29:54 GMThttp://www.sqlmag.com/article/task-scheduling/debugging-asp-applications-with-iis-and-visual-interdev#commentsAnchorhttp://www.sqlmag.com/article/task-scheduling/debugging-asp-applications-with-iis-and-visual-interdev#commentsAnchorSat, 18 Dec 2004 08:28:11 GMT
Activating server- and client-side debugging creates overhead on the IIS server because these options apply to all pages associated with the application you want to debug. This overhead can slow a busy Web site’s response time. For this reason, I recommend that you completely debug your application on a test or development server]]>Anonymous User Sat, 18 Dec 2004 08:28:11 GMThttp://www.sqlmag.com/article/task-scheduling/debugging-asp-applications-with-iis-and-visual-interdev#commentsAnchorhttp://www.sqlmag.com/article/server-extensions/debugging-with-visual-interdev#commentsAnchorWed, 15 Dec 2004 02:50:01 GMT
Excelent article. Thank you ;)]]>Anonymous User Wed, 15 Dec 2004 02:50:01 GMThttp://www.sqlmag.com/article/server-extensions/debugging-with-visual-interdev#commentsAnchorhttp://www.sqlmag.com/article/vbscript/iis-scripting-solutions#commentsAnchorTue, 14 Dec 2004 23:31:25 GMT
is there anyway to retirve hosted sites/virtual direcotires name in C# application Adnan(asiddiqi@bankalfalah.com]]>Anonymous User Tue, 14 Dec 2004 23:31:25 GMThttp://www.sqlmag.com/article/vbscript/iis-scripting-solutions#commentsAnchorhttp://www.sqlmag.com/article/vbscript/iis-scripting-solutions#commentsAnchorTue, 14 Dec 2004 23:31:25 GMT
is there anyway to retirve hosted sites/virtual direcotires name in C# application]]>Anonymous User Tue, 14 Dec 2004 23:31:25 GMThttp://www.sqlmag.com/article/vbscript/iis-scripting-solutions#commentsAnchorhttp://www.sqlmag.com/article/internet/includes-boost-productivity-code-performance#commentsAnchorTue, 14 Dec 2004 09:20:01 GMT
sucks]]>Anonymous User Tue, 14 Dec 2004 09:20:01 GMThttp://www.sqlmag.com/article/internet/includes-boost-productivity-code-performance#commentsAnchorhttp://www.sqlmag.com/article/web-administration/using-windows-security-with-iis-and-sql-server-2000#commentsAnchorTue, 07 Dec 2004 14:28:29 GMT
Valuble information for windows programmers and administrators]]>Anonymous User Tue, 07 Dec 2004 14:28:29 GMThttp://www.sqlmag.com/article/web-administration/using-windows-security-with-iis-and-sql-server-2000#commentsAnchorhttp://www.sqlmag.com/article/activex/querying-reporting-reporting-with-visual-basic-6-0#commentsAnchorWed, 01 Dec 2004 00:14:44 GMT
how to solve when error is report section does not match data source]]>Anonymous User Wed, 01 Dec 2004 00:14:44 GMThttp://www.sqlmag.com/article/activex/querying-reporting-reporting-with-visual-basic-6-0#commentsAnchorhttp://www.sqlmag.com/article/activex/querying-reporting-reporting-with-visual-basic-6-0#commentsAnchorTue, 30 Nov 2004 23:43:59 GMT
data report does match data report.may i know what wrong i comitted]]>Anonymous User Tue, 30 Nov 2004 23:43:59 GMThttp://www.sqlmag.com/article/activex/querying-reporting-reporting-with-visual-basic-6-0#commentsAnchorhttp://www.sqlmag.com/article/activex/querying-reporting-reporting-with-visual-basic-6-0#commentsAnchorTue, 30 Nov 2004 23:43:59 GMT
data report does match data report.may i know what wrong i comitted]]>Anonymous User Tue, 30 Nov 2004 23:43:59 GMThttp://www.sqlmag.com/article/activex/querying-reporting-reporting-with-visual-basic-6-0#commentsAnchorhttp://www.sqlmag.com/article/activex/querying-reporting-reporting-with-visual-basic-6-0#commentsAnchorWed, 24 Nov 2004 12:32:59 GMT
How can i make a report in visual basic 6]]>Anonymous User Wed, 24 Nov 2004 12:32:59 GMThttp://www.sqlmag.com/article/activex/querying-reporting-reporting-with-visual-basic-6-0#commentsAnchorhttp://www.sqlmag.com/article/activex/querying-reporting-reporting-with-visual-basic-6-0#commentsAnchorWed, 10 Nov 2004 17:10:14 GMT
Sorry for my english Some tool in Visual Basic exists to format the report in run time]]>Anonymous User Wed, 10 Nov 2004 17:10:14 GMThttp://www.sqlmag.com/article/activex/querying-reporting-reporting-with-visual-basic-6-0#commentsAnchorhttp://www.sqlmag.com/article/activex/querying-reporting-using-visual-basic-to-drive-excel-97#commentsAnchorWed, 10 Nov 2004 06:04:01 GMT
how to write vb program to send data excel and noepad with desired alignment? give me more examples ]]>Anonymous User Wed, 10 Nov 2004 06:04:01 GMThttp://www.sqlmag.com/article/activex/querying-reporting-using-visual-basic-to-drive-excel-97#commentsAnchorhttp://www.sqlmag.com/article/monitoring-and-analysis/using-the-http-monitor-to-monitor-web-sites-and-applications#commentsAnchorMon, 08 Nov 2004 16:51:32 GMT
I dont use SQL. In the event log I get this error "Unable to Extablish handle to connection, error 122"]]>jazzman,jazz4man Mon, 08 Nov 2004 16:51:32 GMThttp://www.sqlmag.com/article/monitoring-and-analysis/using-the-http-monitor-to-monitor-web-sites-and-applications#commentsAnchorhttp://www.sqlmag.com/article/stored-procedures/learning-about-ole-automation-stored-procedures7910#commentsAnchorWed, 03 Nov 2004 15:18:27 GMT
worthless article]]>Anonymous User Wed, 03 Nov 2004 15:18:27 GMThttp://www.sqlmag.com/article/stored-procedures/learning-about-ole-automation-stored-procedures7910#commentsAnchorhttp://www.sqlmag.com/article/activex/shaped-recordsets#commentsAnchorWed, 03 Nov 2004 10:11:50 GMT
excellent]]>Anonymous User Wed, 03 Nov 2004 10:11:50 GMThttp://www.sqlmag.com/article/activex/shaped-recordsets#commentsAnchorhttp://www.sqlmag.com/article/activex/shaped-recordsets#commentsAnchorWed, 03 Nov 2004 08:37:28 GMT
perfect]]>Anonymous User Wed, 03 Nov 2004 08:37:28 GMThttp://www.sqlmag.com/article/activex/shaped-recordsets#commentsAnchorhttp://www.sqlmag.com/article/activex/sql-server-secrets-stored-procedures-and-ado#commentsAnchorMon, 01 Nov 2004 16:53:16 GMT
The regsvr32 command didn’t work for me either. what did work was this: Under Add-Ins, click on Browse, point to the DLL found in the zip file, it’ll add a reference called "Stored Procedure ADO Code Wizard". Hope this helps]]>Anonymous User Mon, 01 Nov 2004 16:53:16 GMThttp://www.sqlmag.com/article/activex/sql-server-secrets-stored-procedures-and-ado#commentsAnchorhttp://www.sqlmag.com/article/activex/building-interactive-web-applications#commentsAnchorMon, 01 Nov 2004 05:52:45 GMT
Ultra basic explanation...]]>Anonymous User Mon, 01 Nov 2004 05:52:45 GMThttp://www.sqlmag.com/article/activex/building-interactive-web-applications#commentsAnchorhttp://www.sqlmag.com/article/activex/querying-reporting-reporting-with-visual-basic-6-0#commentsAnchorMon, 18 Oct 2004 01:39:58 GMT
any idea on how to do nested queries in the DataReport sqlBuilder ?]]>Anonymous User Mon, 18 Oct 2004 01:39:58 GMThttp://www.sqlmag.com/article/activex/querying-reporting-reporting-with-visual-basic-6-0#commentsAnchorhttp://www.sqlmag.com/article/server-extensions/debugging-with-visual-interdev#commentsAnchorWed, 25 Aug 2004 08:21:37 GMT
Thanks. Great Article. For some reason I get a login box. even with the admin account it won’t let me debug. Any ideas?]]>amit0001Wed, 25 Aug 2004 08:21:37 GMThttp://www.sqlmag.com/article/server-extensions/debugging-with-visual-interdev#commentsAnchorhttp://www.sqlmag.com/article/windows-management-instrumentation-wmi/wmi-101-event-logging#commentsAnchorThu, 22 Jul 2004 13:50:28 GMT
are you able to run this on remote machines? IE this run on machine 1 and pulls the event logs from machine 2 and 3?]]>flightgod160Thu, 22 Jul 2004 13:50:28 GMThttp://www.sqlmag.com/article/windows-management-instrumentation-wmi/wmi-101-event-logging#commentsAnchorhttp://www.sqlmag.com/article/activex/sql-server-secrets-stored-procedures-and-ado#commentsAnchorMon, 12 Jul 2004 10:30:11 GMT
I had the same issue as the above comment. No add-in is available.]]>JASONMon, 12 Jul 2004 10:30:11 GMThttp://www.sqlmag.com/article/activex/sql-server-secrets-stored-procedures-and-ado#commentsAnchorhttp://www.sqlmag.com/article/com-and-com/getting-started-with-com-#commentsAnchorFri, 25 Jun 2004 03:58:19 GMT
Your ’Printer Friendly’ link takes you to the same place as your ’Email This Article’ link!]]>Corrina Yeo Fri, 25 Jun 2004 03:58:19 GMThttp://www.sqlmag.com/article/com-and-com/getting-started-with-com-#commentsAnchorhttp://www.sqlmag.com/article/visual-basic-vb/jump-start-your-database-project#commentsAnchorWed, 16 Jun 2004 22:54:43 GMT
interesting and helpful]]>dileepWed, 16 Jun 2004 22:54:43 GMThttp://www.sqlmag.com/article/visual-basic-vb/jump-start-your-database-project#commentsAnchorhttp://www.sqlmag.com/article/quering/dynamic-sql-redux7577#commentsAnchorWed, 09 Jun 2004 07:09:07 GMT
This article reveals good secret about exec() i.e dynamic sql execution. But we need to over come it. I think we have to do some workaround to resolve this issue.]]>NagarajWed, 09 Jun 2004 07:09:07 GMThttp://www.sqlmag.com/article/quering/dynamic-sql-redux7577#commentsAnchorhttp://www.sqlmag.com/article/activex/mastering-ado#commentsAnchorFri, 04 Jun 2004 04:04:54 GMT
dear sir, i want to some code for the vb, that is how to connect access driver, pls]]>hasmeer Fri, 04 Jun 2004 04:04:54 GMThttp://www.sqlmag.com/article/activex/mastering-ado#commentsAnchorhttp://www.sqlmag.com/article/visual-basic-vb/jump-start-your-database-project#commentsAnchorTue, 01 Jun 2004 14:43:14 GMT
this artticle is very very good.i have a problem in DE,using data enviroment i search the specific record and then generate this record reports ,can u help me]]>abubakarTue, 01 Jun 2004 14:43:14 GMThttp://www.sqlmag.com/article/visual-basic-vb/jump-start-your-database-project#commentsAnchorhttp://www.sqlmag.com/article/activex/querying-reporting-reporting-with-visual-basic-6-0#commentsAnchorThu, 27 May 2004 02:15:40 GMT
Where to find it ? I cannot find it in VB6]]>alexThu, 27 May 2004 02:15:40 GMThttp://www.sqlmag.com/article/activex/querying-reporting-reporting-with-visual-basic-6-0#commentsAnchorhttp://www.sqlmag.com/article/activex/querying-reporting-reporting-with-visual-basic-6-0#commentsAnchorThu, 27 May 2004 02:15:40 GMT
Very nice]]>alexThu, 27 May 2004 02:15:40 GMThttp://www.sqlmag.com/article/activex/querying-reporting-reporting-with-visual-basic-6-0#commentsAnchorhttp://www.sqlmag.com/article/quering/querying-reporting-generate-reports-with-word#commentsAnchorWed, 26 May 2004 07:56:13 GMT
The article is good even though it would help even more if a complete aplication souce could be included on it. For those who don´t know VB well it´s kinda complicate to use the given code and build a usefull aplication... regards...]]>rodrigoWed, 26 May 2004 07:56:13 GMThttp://www.sqlmag.com/article/quering/querying-reporting-generate-reports-with-word#commentsAnchorhttp://www.sqlmag.com/article/task-scheduling/debugging-asp-applications-with-iis-and-visual-interdev#commentsAnchorFri, 21 May 2004 05:37:50 GMT
The description is good but I am facing one problem.i am getting an error message you can not debug at design or run time as the app does not have any frames]]>UpenderFri, 21 May 2004 05:37:50 GMThttp://www.sqlmag.com/article/task-scheduling/debugging-asp-applications-with-iis-and-visual-interdev#commentsAnchorhttp://www.sqlmag.com/article/windows-management-instrumentation-wmi/wmi-101-event-logging#commentsAnchorWed, 19 May 2004 01:07:28 GMT
Would you do me a favor? I want to get only "specific time" of event log by using WMI. for example, 05/01/2004-05/15/2004. I couldn’t solve in my favor. Would you mind helping me if you know about this solution. Sincerely,]]>kimiokWed, 19 May 2004 01:07:28 GMThttp://www.sqlmag.com/article/windows-management-instrumentation-wmi/wmi-101-event-logging#commentsAnchorhttp://www.sqlmag.com/article/activex/querying-reporting-reporting-with-visual-basic-6-0#commentsAnchorTue, 11 May 2004 11:27:20 GMT
Sir, I am working on an office automation project with VB 6.0 as frontend and SQL Server 7.0 as backend. My problem is after I package the project using Package and Deployment wizard and deploy it in another system all my data report pages show errors and do not load. Can you please tell me what the problem might be. I need to finish the project soon, so please help. Regards, Arun]]>arunTue, 11 May 2004 11:27:20 GMThttp://www.sqlmag.com/article/activex/querying-reporting-reporting-with-visual-basic-6-0#commentsAnchorhttp://www.sqlmag.com/article/configuration/setting-up-and-configuring-iis#commentsAnchorWed, 05 May 2004 00:55:54 GMT
In order to debug my application, what all the settings i need to take care about?]]>rajeshWed, 05 May 2004 00:55:54 GMThttp://www.sqlmag.com/article/configuration/setting-up-and-configuring-iis#commentsAnchorhttp://www.sqlmag.com/article/monitoring-and-analysis/using-the-http-monitor-to-monitor-web-sites-and-applications#commentsAnchorTue, 04 May 2004 19:50:32 GMT
What do you change the "Percent word" to? for SQL 2000]]>Mark Anderson Tue, 04 May 2004 19:50:32 GMThttp://www.sqlmag.com/article/monitoring-and-analysis/using-the-http-monitor-to-monitor-web-sites-and-applications#commentsAnchorhttp://www.sqlmag.com/article/activex/querying-reporting-reporting-with-visual-basic-6-0#commentsAnchorMon, 03 May 2004 05:36:46 GMT
this is really good but if i want to get details from diffrent tables of a particular author(entered by user) by user entry through a form.how it can be done plz mail me sir]]>satish kumar Mon, 03 May 2004 05:36:46 GMThttp://www.sqlmag.com/article/activex/querying-reporting-reporting-with-visual-basic-6-0#commentsAnchorhttp://www.sqlmag.com/article/permissions/many-levels-of-web-security#commentsAnchorThu, 29 Apr 2004 11:16:01 GMT
Good Article but COMPlusSecurity.dll is not in the downloaded .zip file.]]>tomThu, 29 Apr 2004 11:16:01 GMThttp://www.sqlmag.com/article/permissions/many-levels-of-web-security#commentsAnchorhttp://www.sqlmag.com/article/activex/querying-reporting-reporting-with-visual-basic-6-0#commentsAnchorTue, 27 Apr 2004 07:50:01 GMT
Article is good and helped me a lot but i want to use "where" clause in datareport at run time mean to say i want to get the record of a student whose roll is 3 on datareport Hope u will help me Thanks]]>manishTue, 27 Apr 2004 07:50:01 GMThttp://www.sqlmag.com/article/activex/querying-reporting-reporting-with-visual-basic-6-0#commentsAnchorhttp://www.sqlmag.com/article/activex/querying-and-reporting-printing-reports-from-the-web#commentsAnchorMon, 26 Apr 2004 03:14:34 GMT
realy ,u provide great facility to programmer. by y’r help trainnee programmer getting lots of help to make programe tnx]]>NareshMon, 26 Apr 2004 03:14:34 GMThttp://www.sqlmag.com/article/activex/querying-and-reporting-printing-reports-from-the-web#commentsAnchorhttp://www.sqlmag.com/article/activex/querying-reporting-reporting-with-visual-basic-6-0#commentsAnchorMon, 26 Apr 2004 02:45:07 GMT
Railway reservation project report using visual Basic 6.0 and oracle 8i]]>Dulal Chandra Mondal Mon, 26 Apr 2004 02:45:07 GMThttp://www.sqlmag.com/article/activex/querying-reporting-reporting-with-visual-basic-6-0#commentsAnchorhttp://www.sqlmag.com/article/active-directory-service-interfaces-adsi/iis-resource-kit-utilities#commentsAnchorSat, 24 Apr 2004 15:35:04 GMT
downloads]]>kreg Sat, 24 Apr 2004 15:35:04 GMThttp://www.sqlmag.com/article/active-directory-service-interfaces-adsi/iis-resource-kit-utilities#commentsAnchorhttp://www.sqlmag.com/article/ecommerce/using-email-in-your-web-site-dimac-w3-jmail#commentsAnchorSat, 24 Apr 2004 06:04:23 GMT
I have used jmail I am able to set the x-header but i am unable to read the header . I am able to read the pop3 mail box . I will very kind of u if u can help regarding reading of bounce mail.]]>timarSat, 24 Apr 2004 06:04:23 GMThttp://www.sqlmag.com/article/ecommerce/using-email-in-your-web-site-dimac-w3-jmail#commentsAnchorhttp://www.sqlmag.com/article/activex/querying-reporting-reporting-with-visual-basic-6-0#commentsAnchorWed, 21 Apr 2004 14:32:35 GMT
This is a good Book.]]>Amaresh Dikshita Wed, 21 Apr 2004 14:32:35 GMThttp://www.sqlmag.com/article/activex/querying-reporting-reporting-with-visual-basic-6-0#commentsAnchorhttp://www.sqlmag.com/article/activex/querying-reporting-reporting-with-visual-basic-6-0#commentsAnchorWed, 21 Apr 2004 02:00:33 GMT
Great for beginers like me]]>Rajinder Singh Wed, 21 Apr 2004 02:00:33 GMThttp://www.sqlmag.com/article/activex/querying-reporting-reporting-with-visual-basic-6-0#commentsAnchorhttp://www.sqlmag.com/article/activex/querying-reporting-reporting-with-visual-basic-6-0#commentsAnchorTue, 20 Apr 2004 20:00:33 GMT
i want to learn more about reports]]>sijo Tue, 20 Apr 2004 20:00:33 GMThttp://www.sqlmag.com/article/activex/querying-reporting-reporting-with-visual-basic-6-0#commentsAnchorhttp://www.sqlmag.com/article/web-administration/using-windows-security-with-iis-and-sql-server-2000#commentsAnchorWed, 14 Apr 2004 19:34:11 GMT
About SQL server 2000 and ASP Script,why I can’t write and update database within SQL server 2000. Before I installed SQL server 2000,I could modify and visite the database!]]>Sailor.Wise Wed, 14 Apr 2004 19:34:11 GMThttp://www.sqlmag.com/article/web-administration/using-windows-security-with-iis-and-sql-server-2000#commentsAnchor