Programmatically test if DB server is alive?

TheMSsForum.com: The Microsoft Software Forum

The MSS Forum ‹ ASP Server
- Archive
  - Biz
  - MCSE
  - CRM
  - Drivers
  - Framework
  - ADO
  - ASP
  - Compact
  - Forms
  - Dotnet
  - C#
  - VB
  - FontpageGen
  - Excel
  - WorkSheet
  - Exchange
  - Setup
  - Fox
  - Fontpage
  - ASP
  - IIS
  - Entourage
  - Money
  - Messanger
  - PocketPC
  - Powerpoint
  - Project
  - Publisher
  - Excel
  - VB
  - Security
  - Portal
  - Services
  - SQLServerDev
  - SVCS
  - SQLServer
  - VB
  - VC
  - MFC
  - ExcelGen

- Previous
  - 1
    - querystring exceeds size limit using window.open Thanks in advance for any help. I am attempting to pass a large number of ID's using window.open in javascript. The number of the ID's exceeds the querystring length. Therefore, I would like to somehow use the POST method to submit. (or another method without rewriting the ASP page!) Please review the code below before submitting since this can be easily done but I am not sure how using <body onload... >. %> <body onload="myFunc('<%=request("wid")%>')"></body> <% <script language=javascript> function myFunc(w2) { var args = "&wono=" + w2; window.open("test_alert.asp?"+args, null,'width=600,height=550,scrollbars=yes,resizable=yes,status=yes,top=10,left=50'); } </script> Tag: Programmatically test if DB server is alive? Tag: 321959
  - 2
    - String Building When assembling an HTML string from a database before sending it to the client (ie keeping the connection as short as possible), adding to an existing string (strOut=strOut & strNextLine) takes time and can defeat the object. Is putting each line into an array, and re-dimming the array by +1 each time quicker? Is there a better way? Thanks Giles Tag: Programmatically test if DB server is alive? Tag: 321953
  - 3
    - How to get the Windows current logged user name using ASP Hi all How to get the Windows current logged user name using Classic ASP. If no direct way are there any work arounds. Thanks mvr Tag: Programmatically test if DB server is alive? Tag: 321947
  - 4
    - Possible with ASP? I want to create a 20 minute loop to generate an include file based on the html output of another file on a remote server. Is this possible using ASP? If so, how do you generate an application to check something every 20 minutes?! Tag: Programmatically test if DB server is alive? Tag: 321930
  - 5
    - asp geht nicht aber aspx und html :-( Hallo, hab ein großes Problem. Habe den IIS 5.1 windows XP Professional aktuellstes Servicepack. Updates auf dem neuesten Stand. Ich kann keine normalen .asp Seiten aufrufen aber aspx .NET Seiten und Html schon. Das funzt auch ohne Probleme. IIS hab ich deinstalliert und wieder installiert das ganze Programm eben. Ich nehme an mir fehlt da ne Einstellung oder so. Wo stelle ich das ganze ein ? Muss ich asp noch irgendwie aktivieren oder woran kann das alles liegen Bin für jede Hilfe dankbar. Nicholas Tag: Programmatically test if DB server is alive? Tag: 321928
  - 6
    - Calling several webrequests at the same time Hello, Is it possible to call 4 webrequests from an aspx file at the same time and then wait for the results of all 4 to come in. (4 webrequests to 4 different servers) I know that I can create 4 threads to do this, but when this application is called by 100 people, will it mean that 400 threads will be running? Is there a sollution or way around this? Tag: Programmatically test if DB server is alive? Tag: 321923
  - 7
    - Loosing session variables I have a website with several input forms over a number of pages. The information that the user gives is following through the pages as session variables. It has been working good for two years. Now I am redoing the whole site and have all the different pages put into an Iframe on the first page. The form pages are the same as before, but now I seem to loose some of the session variables. But the strange thing is that if I first go through the the process with the old website and then switch to the new in the same browser, it all works. Do you guys have any suggestions where to look for the fault? / Rolf Tag: Programmatically test if DB server is alive? Tag: 321920
  - 8
    - getobject permission denied We just moved a legacy asp application to a Win2003 server. The following line of code: set objUser = GetObject("WinNT://" & strDomain & "/" & strUserName & ",user") Raises the following error: Microsoft VBScript runtime error '800a0046' Permission denied: 'GetObject' Any suggestions? Thanks. Tag: Programmatically test if DB server is alive? Tag: 321919
  - 9
    - Can't get User's NT log-in Howdy, I'm having a real tough time getting a User's NT login after they submit a form. I have Anon. Login disabled. I'm using Digest Authentication (although I've tried everything). Every time I run the page, I get a blank string instead of the requested information. The information is in a hidden field, with the value set to: <%=Request.ServerVariables("LOGON_USER")%> The icing on the cake is that when I run this on my PWS, I can pull the information and it shows up in the SQL DB I'm sending it too. But, when put on our live box, it doesn't show up. The setting on each box are exactly the same. Any ideas? It seems as though I've tried everything. Tag: Programmatically test if DB server is alive? Tag: 321917
  - 10
    - Like Airlines website - Redirect to results page after getting res Hi everyone, I have a ASP page that triggers a db-side stored procedure. At the end of the procedure, it spits out a log file, that this ASP page reads and displays for the users. But the problem is that the database-stored Proc could take anything between 10 secs - to - 10 mins. I dont want the page to time out [But I dont want to increase the time out in the IIS webserver]. Is there a way, like the airlines websites do, where I can just show an animated gif while the procedure runs and redirect the page to results at the end of the procedure run. ex: like orbitz or hotwire.... or anything like that, but not as complicated as them. Hope I made my question clear, any ideas are truely appreciated, _Mac Tag: Programmatically test if DB server is alive? Tag: 321916
  - 11
    - Application & Session Cache Performance Problem Hi, Our website has recently been experiencing some problems under load. We have pinpointed a particular function which slows dramatically when we have these problems. Normally it should execute in under a second but it rises to about one minute under duress. The code is fairly straight forward with no calls to databases or any other servers. The only dubious thing I can see is that it retrieves several arrays from the Application cache and a few variables from Session Cache. From reading around I get the impression that storing arrays in Application cache can cause thread queuing problems that are only noticeable under heavy loads. However, some of the documents I have read apply to different versions of IIS, etc., so I am not sure if the info I have read applies to our configuration. We are using classic ASP running on IIS6 running on Win2K Server SP4. Please can someone confirm whether we may be expeiencing thread queuing on the Application cache or offer any other explanations. Thanks, roadrunner Tag: Programmatically test if DB server is alive? Tag: 321907
  - 12
    - Connect to mapped drive hi everyone, I have mapped a drive in our IIS, but I don't know how to connect to it from ASP. I would like to place files (like images files) to the mapped drive T:\XXX\YYY and display files from there. I've tried using Server.MapPath, but when I put T:\XXX\YYY as parameter, it will say it requires virtual path but not physical path. Then I tried using: Set MyFileObject=Server.CreateObject("Scripting.FileSystemObject") Set MyFolder=MyFileObject.GetFolder("T:\XXX\YYY") but it will say Path not found. Please advise. Thanks! Tag: Programmatically test if DB server is alive? Tag: 321902
  - 13
    - Help! ASP pages don't open with IIS (local files) IE6 and WinXP Hello everyone, I can't open ASP documents with Windows XP Pro SP2 IE6.0 + IIS 5.0. When I click an ASP file, it's macromedia mx 2004 that opens it. If I choose Open With... Internet Explorer, nothing opens. And if I can have an ASP page open in IE, if there is a link to another ASP page, when I click it, it doesn't open that ASP link, instead IE asks if I want to download the file. The http://localhost/ is working fine. I have ZoneAlarm Security Suite installed and tweaked it to high security settings. Dont know where this is blocking Asp files to be opened by IE. Any help will be appreciated. Thank you very much. Tag: Programmatically test if DB server is alive? Tag: 321900
  - 14
    - Security.Permissions.SecurityPermission G'day, I have 2 Win2K servers, 1 is my database server, 1 runs IIS On the IIS machine I have an ASP.NET 2 application that makes a call to a proprietry 3rd party COM Object/DLL that makes a call to a database on server number 2. When the DLL call is run, I get "Security.Permissions.SecurityPermission" error and thats all it says. Does anybody have any idea how I get around this? Im a newbie to ASP and have full trust set in the web.config file. Thanks in advance! Tag: Programmatically test if DB server is alive? Tag: 321898
  - 15
    - Running a server side script and getting failed to initialize I am attempting to have an asp page call a batch file. I had it working, I was high on life and then I decided to log off the server. Once I did, the code would no longer work. When I logged back onto the server, I saw: 'The application failed to initialize properly (0xc0000142). Click on OK to terminate the application.' Now before I get the usual questions, here is what I have/did: These servers are 'secure' so I'm not so concerned about security. I have the anonymous access account in IIS (server 2003, so IIS6) using a local admin account. I have granted full permission to every user account (IUSR, IWAM, ASPNET, Network Service etc. etc.) to all the files in the website's dir. I have granted full rights to cmd.exe, wscript.exe. Now, after stopping/starting IIS about 7000 times and offering up many a prayer to the IIS/ASP gods (who obviously hate me), my ASP code starts to work again. HOWEVER, as soon as I log off, Poof! The script stops working and I need to go through the whole dance routine (which isn't consistent) until the script starts working again. I dumbed down my code to something stupid like: <% set wshell = server.CreateObject("WScript.Shell") wshell.run "notepad", 1, TRUE set wshell = nothing %> just so I can see notepad pop up on the server (IIS is set to 'interact with desktop' and I'm Remote Desktop'd to the server) - which it does. Once I log off and log back on (as an admin) I get the 'application failed to initialize' error again. After clearing the blood off the monitor (smashed my head against the glass one too many times) I searched the groups and google high and low, but I haven't come across this issue before. I mean, it does work - as long as I leave the server logged on. I can understand that and live with it. However: Why in all that is holy and pure does it fail after I logged back in? I am a few lines of code from going Postal at my workplace and then committing hari-kari. Please. Save my coworkers, save me and most importantly - Save my script! Tag: Programmatically test if DB server is alive? Tag: 321894
  - 16
    - AspExec - Run batch file from ASP page hi everyone, I searched in faq's but couldn't find and solution... so here I post the popular question.. Env: Win2003 server / IIS6.0 Simple ASP page that runs a batch file. When I run the asp page, I see some command line window pop-up on my screen for a second [may be the "cmd" is triggered without any parameters]. But the batch file is not executed. I gave 'IUSR_*' account 'full control'. -----------------------CODE---------------------------- Set objExecutor = Server.CreateObject("ASPExec.Execute") objExecutor.Application = "cmd.exe" objExecutor.Parameters = "/c c:\test.bat" objExecutor.ShowWindow = True strResult = objExecutor.ExecuteWinApp response.write "<p>" & strResult & "</p>" -----------------------CODE---------------------------- On running the ASP page I see output as "Ok", with no errors. But the batch file is not executed. Interestingly, when I tried "WScript.Shell", same exact thing happennd [command pop-up for a second, with no executing of batch file.] I have this exact setup running on a Win2000/IIS 5 running for over a year..... Any suggestions are appreciated... thanks, Tag: Programmatically test if DB server is alive? Tag: 321892
  - 17
    - Help - 3 action buttons on each record Hi, I have the following need: I list a table from an access database but cannot interact with each record. At the html page I display all records, one field (field1) from and 3 buttons for each record so to: Button 1) Accept: Sets 1 on field 2 on that record Button 2) Reject: Sets 0 on field 2 on that record Button 3) Delete: Deletes that record That'd be: -------------Record 1--------------- Message: Hello 1!!! ACCEPT - REJECT - DELETE -------------Record 2--------------- Message: Hello 2!!! ACCEPT - REJECT - DELETE -------------Record 3--------------- Message: Hello 3!!! ACCEPT - REJECT - DELETE -------------Record 4--------------- Message: Hello 4!!! ACCEPT - REJECT - DELETE For example I press delete button and it'll have to delete that record: -------------Record 1--------------- Message: Hello 1!!! ACCEPT - REJECT - DELETE -------------Record 3--------------- Message: Hello 3!!! ACCEPT - REJECT - DELETE -------------Record 4--------------- Message: Hello 4!!! ACCEPT - REJECT - DELETE Actually, I'm just displaying these records but I don't know how to do different actions for each button for each field. This is the code: <form name="form" method="post" action="add_to_guestbook.asp"> <table width="610" border="0" align="center" cellpadding="0" cellspacing="0"> <% while not RS.eof %> <tr> <td> <%Response.Write RS("MessageText")%> </td> </tr> <tr> <td> <%Response.Write RS("MessageFrom")%> - <%Response.Write RS("MessageDate")%> </td> Hope you can help me, Marcelo. <tr> <input type="button" name="btnAccept" value="Accept"> <input type="button" name="btnReject" value="Reject"> <input type="button" name="btnDelete" value="Delete"></td> </tr> <%RS.movenext%> <%wend set conn=Nothing set RS=Nothing %> </table></td> </tr> </form> Tag: Programmatically test if DB server is alive? Tag: 321891
  - 18
    - how to configure IIS for sending mail from ASP.NET application Hi, I am learning ASP.NET , I want to send mail from my application so I need to configure IIS. I have written code for it but my mail is in Queue or Droped. I think I have not configured IIS properly. Can anyone tell me in detail how to configure it. Thanks -- shayad ------------------------------------------------------------------------ Posted via http://www.webservertalk.com ------------------------------------------------------------------------ View this thread: http://www.webservertalk.com/message1509913.html Tag: Programmatically test if DB server is alive? Tag: 321888
  - 19
    - Not looping Hey gang. I have a script that gets stats from a mssql db, and then inserts those stats into a temp table. where i can work with them as i wish. the problem is it isn't looping through all the records, and i am not sure why. i know the script isn't perfect, as it is open to sql injection and stuff like that, but once the site is complete, i will be putting in checks and things like that to stop it. any ideas why it isn't looping?? <% set stats1 = conn.execute("select team_name from teams where idivision = 'ACA'") do while not stats1.eof varT = stats1.fields.item("team_name").value set check1 = conn.execute("select count(teama) as cnt1 from matches where teama = '" & varT & "'") bam1 = check1.fields.item("cnt1").value if bam1 = 0 then varW1 = 0 elseif bam1 = 1 then set stats1 = conn.execute("select teama_points from matches where teama = '" & varT & "'") varW1 = stats1.fields.item("teama_points").value elseif bam1 > 1 then set stats1 = conn.execute("select sum(teama_points) as pts1 from matches where teama = '" & varT & "'") varW1 = stats1.fields.item("pts1").value end if set check2 = conn.execute("select count(teamb) as cnt11 from matches where teamb = '" & varT & "'") bam2 = check2.fields.item("cnt11").value if bam2 = 0 then varL12 = 0 elseif bam2 = 1 then set stats21 = conn.execute("select teamb_points from matches where teamb = '" & varT & "'") varL12 = stats21.fields.item("teamb_points").value elseif bam2 > 1 then set stats21 = conn.execute("select sum(teamb_points) as pts2 from matches where teamb = '" & varT & "'") varL12 = stats21.fields.item("pts2").value end if set stats2 = conn.execute("select count(iwinner) as wins from matches where iwinner = '" & varT & "'") varW2 = stats2.fields.item("wins").value set stats3 = conn.execute("select count(iloser) as losses from matches where iloser = '" & varT & "'") varL1 = stats3.fields.item("losses").value total_points = varW1 + varL12 var_total = bam1 + bam2 if bam1 = 0 then win_pct = 0 else win_pct = formatnumber(((bam1 / var_total)*100),0) end if strSQL = "insert into temp (team, points, wins, losses, win_pct) values ('" & varT & "', " & total_points & ", " & varW2 & ", " & varL1 & ", " & win_pct & ")" conn.execute (strSQL) stats1.movenext loop %> Tag: Programmatically test if DB server is alive? Tag: 321881
  - 20
    - avoid guestbook flooding hello, I'm trying to find how to avoid automatic submission of my guestbook form because many users submit their advertisement on it. I can't find the correct word for the little image where the user must enter what's written on it and avoir bots to recognize what's in. Please help, I'm tired to delete 300 spams a day. Bob Tag: Programmatically test if DB server is alive? Tag: 321880
  - 21
    - Best providers for asp server Hi, Can anyone recommend a company to provide us with a asp enabled ftp server please Cheers C Tag: Programmatically test if DB server is alive? Tag: 321875
  - 22
    - Moving on to SQL Express Hi! Just had to convert a asp website I have from Acces to MS SQL Express. Is this an OK way to connect to the database? It works great, but I just wanted to know if this is the best way to do it.... The code runs on the same surver as the sql express server. AdoConnection = "Provider=SQLOLEDB.1; Data Source=xxx.xx.xxx.xxx;Initial Catalog=DatabaseName;Persist Security Info=True;User ID=sa;Password=Pass" ConnectString = AdoConnection Set conn = Server.CreateObject("ADODB.Connection") conn.open ConnectString sqlBruker = "SELECT Fornavn FROM Bruker" Set rsBruker = Server.CreateObject("ADODB.Recordset") rsBruker.Open sqlBruker, conn, 3, 3 Response.Write(rsBruker("Fornavn")) rsBruker.close set rsBruker=nothing Best regards, Christopher Brandsdal Tag: Programmatically test if DB server is alive? Tag: 321874
  - 23
    - !! DOWNLOAD THE MOST POPULAR 2006's CRACKED SOFTWARE(CAD/CAE/CAM/EDA/PCB/GIS/CNC/FEA) Our team provide different types of services such as: - proffessional cracking of any kind of software (CAD,CAM,CAE,EDA,GIS,PCB,FEA,FEM,CNC,CFD,PDS,3D,Optics etc.) designed for any kind of operating systems(Windows 95/98/ME/2000/XP, Linux, FreeBSD, OS/2, MAC OS etc.) - producing keygens, licenses for different proctection systems (FlexLM, SentinelLM, ElanLM, CrypKey, etc.) - producing emulators for any kind of dongles (SentinelPro, SentinelSuperPro, Hasp4, Hardlock, WIBU, Guardant, etc.) - quality reverse engineering (decompilation of programs, algorithms reconstruction, etc.) - any other reverse engineering services... Also we have an excellent relationship with all our customers and we always happy to help them solve their problems. Our skills and experince will help you make a valuable conribution to your business. All soft we offer have been completely cracked and tested carefully by expert in corresponding field. All programs are full copies of originals (not demo, evaluation, trial or educational version) including English or multilanguage tutorial and crack or license file that makes program work as registered software from the house. Here is just a part of our software list.For getting the additional information, view our software list and ordering programs just visit our WEBSITE: http://www.softstore.org >> Contact e-mail: WarezStore2005@yahoo.com or WarezStore2006@yahoo.com Here is an example of the most popular offered latest software: 12D MODEL V6.0 3Ci GeometryWorks 3D For SolidWorks v3.2 ACCEL RYS MATERIALS STUDIO V3.2 Actel Designer v6.3 ADAPTSOFT ADAPT PT V7.0 ADAPTSOFT ADAPT BUILDER V1.5.4 ADOBE CREATIVE SUITE PREMIUM EDITION V2.0 ADOBE INCOPY CS2 V4.0 AEGIS CIRCUITCAM SUITE V5.0 AGILENT ADVANCED DESIGN SYSTEM 2005A Agilent IC-CAP 2004 Aglent RFDE2004A Aldec Active HDL v7.1 Aldec Riviera v2004.12.1684 ALGOR Designcheck v18.0 Alias Maya MasterClasses 2005 Alias SketchBook Pro v2 Build.166043 Alias Spoolgen v5.0 Align And Space2004 v1.1 for AutoCAD ALTAIR HYPERWORKS V7.0 SP1 ALTERA QUARTUSII V5.0 ANALYTICAL GRAPHICS STK PRO V6.1 Anasoft Helena v1.0.1 Anova Ambiente v4.8.6 Ansoft AnsoftLinks V3.0 ANSYS MULTIPHYSICS V10.0 ANSYS TURBOGRID V10.0 ANSYS WORKBENCH V10.0 Applied Flow Technology Impulse v3.0.2005.01.10 Aptech GAUSS v7.0.11.493 ARCGIS DESKTOP V9 SP3 ARTWORK CONVERSION NETEX-G V1.24B ASPENTECH ASPEN PIMS V2004 ATIR STRAP V11.5 Aucotec Elcad Aucoplan v7.3 AUTODESK ARCHITECTURAL DESKTOP V2006 Autodesk Autocad 2006 AUTODESK AUTOCAD ELECTRICAL V2006 AUTODESK AUTOCAD LT V2005 AUTODESK AUTOCAD MECHANICAL V2006 AUTODESK BUILDING SYSTEMS V2006 AUTODESK CIVIL 3D V2006 AUTODESK CIVIL DESIGN COMPANION V2006 AUTODESK DWF COMPOSER V2.0 AUTODESK INVENTOR SERIES V10 AUTODESK LAND DESKTOP V2006 AUTODESK MAP 3D V2006 AUTODESK MECHANICAL DESKTOP V2006 AUTODESK MECHANICAL V2006 Autodesk Productstream v4 AUTODESK RASTER DESIGN V2006 AUTODESK REVIT BUILDING V8.1 AUTODESK SURVEY V2006 AUTODESK TOXIK V1.1 AUTODESK VAULT V4 Autodesk VIZ v2006 Autodsys IntelliCAD v5.1.5.05 Pro Plus AutoTRAX EDA v3.12 AutoXlsTable v2.53 for AutoCAD 2006 AVID ALIENBRAIN STUDIO V7.1.1 AVID XPRESS PRO HD V5.1.5 BENTLEY Architecture v8.05.02.13 Bentley MicroStation J v07.01.05.03 BENTLEY Stuctural v8.05.03.53 BOBCAD-CAM V20.5 BOBWIRE V19.3 BRAIN VOYAGER QX V1.2.6 CABINET VISION SOLID v4.0 CAD EASY EASYSITE AUTOCAD V2 Cadance confrml50 base CADCAM-E CAT5WORKS V2.0 CADCAM-E PSPRO V3.1 Cadence LDV v5.1 CADENCE ORCAD UNISON SUITE PRO V10.5 Cadence spb 15.2 update Cadmai v2.1 CADRASTER LTX V6.10 FOR AUTOCAD CADSOFT TRADEME CADENCE V1.0 CAEFEM v9.0 CAM Expert v2.0.4.8 CAM350 v8.7.1 CATIA TRANSLATOR FOR FLUENT FLOWIZARD V2.0.4 Catia V5R15 P3 SP4 Chief Architect Picture Painter v1.0 Cigraph factory 2005 for ArchiCAD v9.0 CIMATRON ELITE V7.0 Cimco DNCMax v4.40.07 CIMCO SOFTWARE SUITE V5.02.19 Cimmetry AutoVue SolidModel Pro v19.0 CIMMETRY AUTOVUE SOLIDMODEL PROFESSIONAL V18.0 C8 CIVILTECH ALLPILE V6.5E CIVILTECH SHORINGSUITEPLUS V7.8D COADE CADWORX XSTEEL V2006 COADE CADWORX EQUIPMENT V2006 COADE CADWORX PID V2006 COADE CADWORX PLANT PROFESSIONAL V2006 COCREATE DESIGNER MODELING V13 COMSOL Multiphysics V3.2 Corel DESIGNER Technical Suite 12 COSMOSWORKS 2006 CSC TEDDS V8.0 CSI CSICOL V8.3.1 CSI ETABS NL V8.5 CSI SAFE V8.0.8 CSI SAP 2000 V9.10 CST MICROWAVE STUDIO V5.1 CURIOUS WORLD MAPS V6.0 DASSAULT SYSTEMES CATIA V5R15 SP3 DASSAULT SYSTEMES.CATIA.P3.V5R15 ISO 2CD Datacad v11.08 DDSPARTNER V6.34 DELCAM ARTCAM PRO V8.0 FIX DELCAM COPYCAD V6.0 DELCAM POWERSHAPE V5.7.30 DELCAM ART CAMINSIGNIA V3.1 DELCAM OWERSHAPE.v5.8.20 DESIGN DATA SDS2 V6.336 DIMSOLN COMBINED 3D V3.8.0 DIMSOLN MAT3D V3.8.4 Discreet 3ds Max v7 DISCREET 3DSMAX 2005 DISCREET COMBUSTION 2005 Dolphin SMASH v5.5.1 DOLPHIN SOCGDS V5.6 DRAFIX PRO LANDSCAPE V11 DSC GOSTEEL V5 SP6 BUILD 40 DYNASIM DYMOLA V5.3D EagleWare GENESYS 2004.7 EDS I-DEAS NX V11 M4 EDS UNIGRAPHICS NX V4.012 EFI Colorproof SP2 for v5.0.1 EGS FEATURECAM 2005 V11.4.0.19 SOLID PLUGIN Electronics Workbench Ultiboard v8.3.19 Elite Software Audit v7.01.16 ELITE VIDEO DIGITAL LIGHTNING MAGIC VOLUME I EMPIRUM PRO V2005 EMS-I GMS V5.1 DATECODE 04062005 EON CAD V3.5.10 Eovia Amapi Designer v7.1 EPCON SiNET v7.0 Eplan LogoCad Triga v4.20 ESRI ArcGIS Desktop V9.1 ETA Dynaform v5.2 EUKLID v2004 3 Multilingual Eurosystems EuroCut Basic 6.1.0.5 Excellink 2006 v16.2.0.50617 for AutoCAD Extensis Mask Pro v3.0.2 FASTCAD V7.22 FastShip v6.7 FELIXCAD V5 SP6 FEM DESIGN V5.21 FIDES ARW v2005.076 FIDES BearingCapacity v2005 250 FIDES WALLS FEA v2005 272 FIDES WinTUBE v2005 307 FLUENT AIRPAK V2.1.12 FLUENT FIDAP V8.7.4 FLUENT FLOWLAB V1.2.10 FLUENT MIXSIM V2.0.2 FLUENT V6.2.16 FLUENT FLO WIZARD V2.0.4 FME SUITE 2004 ICE.3 FORMZ RADIOZITY V5.0 FOTOWARE FOTOSTATION PRO v5.1.58 FXRAY V5.0 FOR FELIX CAD GAEA POLLUTE V7.061 GAEA WINLOG V4.34 GAGEtrak v6.05 GBRVU v2.66c GC-PowerStation v5.3.2 GENERAL CADD V3.1 21A Genstat v8.2 SP1 GEOSOLVE SLOPE V12.01 GEOSOLVE WALLAP V5.03 GerbTool v14.2 GGU Axpile v3.02 GGU Borelog v4.14 GGU Drawdown v3.00 GGU Gabion v2.10 GIBBSCAM 2005 V7.7 Global Mapper v6.06 GRAITEC ADVANCE STEEL SUITE V5.2 Graphicode Gc-powerstation V4.4.2 Hampson Russell CE v7.R2 HGEN 2006 For AutoCAD v16.2.2103.0001 HHK GEOgraf CAD v3.0e.1317 HKS Abaqus V6.5-1 HUMMINGBIRD EXCEED POWERSUITE V11 2006 ILLUMINATE LABS TURTLE V1.1.5.3 FOR MAYA 6 AND 6.5 I-Logix Rhapsody V6.0 Image Pro Plus 5.0.1 IMAGEWARE UNILET PRO 6.0.6 IMSI FLOORPLAN 3D DESIGN SUITE V9.0 IMSI TurboCAD Deluxe v11.0.12.2 INNOVMETRIC POLYWORKS V9.0.2 Intel Visual Fortran Compiler Pro v9.0.021 INUS TECHNOLOGY RAPIDFORM 2004 PLUS PACK 2 INVENSYS SIMSCI PIPEPHASE V9.0 IronCAD Inovate v8.0 ISE TCAD V10 ITASCA UDEC V4.00.153 JAWS v6.10.1002 Keil C51 V710 Full KISSSOFT HIRNWARE 10 2004 Lattice IspLevel V4.1 Layerman v4.1g For AutoCad And LT 2004 2005 LDRA TESTBED V7.2 Lectra Catalog v2.1 C1 LECTRA CATALOG V2.1c5 LECTRA DIAMINO FASHION v5R2 LECTRA GRAPHICS PEC FURNITURE V2R5 LECTRA KALEDO STYLE V1 R1 C11 LECTRA VECTOR PILOT V2 R2 C1 LEICA GEO OFFICE COMBINED V1.0 LISCAD V7.0 Magma da Magma v4.1 all with 13&18 MAK DATA LOGGER V3.9A MapInfo MapXtreme Java Edition v4.71.22 MASTERCAM V10.0 MathCAD 13.0 Enterprise Edition Mathworks Matlab v7.1 R14 SP3 Mentor Catapult C Syntesis 2004b.8 Mentor Graphics ePD 2004 Spac2 MicroGDS v9.0 Minitab v14 SUB100 MOLDFLOW WORKS V1.1 R1 MSC ADAMS 2005 R2 MSC Dytran 2005 MSC Fatigue 2005 For Patran 2005 MSC Marc 2005. R2 FINAL MSC NASTRAN V2005 R2 MSC Patran 2005 R2 FINAL MSC SuperForm 2005 Nemetschek Allplan v2005 NEMETSCHEK VECTORWORKS V11.5 NEWTEK LIGHTWAVE V8.3 B801 NextLimit RealFlow v3.1.17 NI-VISA V3.4.1 NOESIS OPTIMUS V5.0 SP1 OASYS Suite v9.1a PATHLOSS V4.0 PATHTRACE EDGECAM V9.75 PCI GEOMATICA V9.1 POLAR SI8000 V5.0 ProgeCAD v2006 SP1 ProgeMEC 2006 For ProgeCAD Prokon CalcPad v2.1.09 PTC INTRALINK V3.4 M011 PTC Pro ENGINEER WILDFIRE 2.0 Datecode 2004490 PTC PRO ENGINEER WILDFIRE v2.0 M120 QNX Neutrino 6.2.1 Quicklogic Quickworks v9.64 RAINDROP GEOMAGIC STUDIO V7.0 RAM STRUCTURAL SYSTEM V8.13 RENESAS NC30WA V5.30 RES2DINV v3.54.35 RISA TECHNOLOGIES RISA 3D V5.5 RISA TECHNOLOGIES RISA FLOOR V2.0 SCANVEC AMIABLEEN ROUTE V3.2 SCIA ESA PT V5.0.379 Siemens SIMATIC WinCC Flexible 2005 SIMSCI PRO II V7.1 SINDA FLUINT V4.7 SOCET SET V5.2 SOFiSTiK SOFiCAD v16.4 SOFTTECH STRUDS V2005 SOKKIA MAPSUITE PLUS V3.0.0 BUILD 304 SOLID EDGE V17 SOLIDWORKS 2006 SP2 SonicDVD it Pro v6.0 SPRUTCAM V4.0 SPSS v14.0 Star CD v3.24 SURFWARE SURFCAM V2005 SP1 SYNOPSYS STAR Hspice 2005 SYNPLICITY SYNPLIFY PRO V8.1 Synplify DSP v2.4 TanneLLEdit Pro V 11.0 TekSoft CAMWorks 2006 for SolidWorks 2006 Telelogic TAU Generation2 V2.4 SP1 THINK3 THINKDESIGN V2005.1 Transmagic Plus v2005 SP4 TRUMPF TOPS 600 V3.0 UG NX v3.0.1.2 UGS FEMAP V9.0.1 UGS IMAGEWARE NX V12.1 UGS NX V3.0.2.3 UGS SOLIDEDGE V17.0 VAG ElsaWin Data v3.20 VariCAD 2005 v1.04 VectorFX VOL 150.000 VectorLogos VENTURE FENIX V4.1 Visual Mill v5.08 VRML Export 2006 For AutoCAD v3.4.0.50317 VTC AUTOCAD 2005 FOR ARCHITECTS VX CADCAM V11.21 Watercom DRAINS v2005.01 Wolfram MatheMatica V5.2 WORLEY LABSG2 V1.7 FOR LW XILINX EDK V7.1 Xilinx ISE v7.1i XSTEEL V 11.0 TEKLA ZAXWERKS 3D FLAG AE V1.0.0 Zemax-EE 2005 This is not our complete software list. If you want to get access to our Software archive you should visit our website: http://www.softstore.org >> Contact e-mail: WarezStore2005@yahoo.com or WarezStore2006@yahoo.com -- WarezStore ------------------------------------------------------------------------ Posted via http://www.webservertalk.com ------------------------------------------------------------------------ View this thread: http://www.webservertalk.com/message1509142.html Tag: Programmatically test if DB server is alive? Tag: 321872
  - 24
    - How does a Personal Information Exchange Key function I have made an attempt to publish to a public domain using VS 2005. I have an option for Trust or No Trust in the Publish section of the properties. I chose trust and create a key (Personal Information Exchange). There are too many variables for me to understand why I can publish to a site and go through an installation and then reach the end where the actual exe file should run only to have it display an XML page with information about my certificate. Anyone have an idea about what may be happening here? -- Regards, Jamie Tag: Programmatically test if DB server is alive? Tag: 321870
  - 25
    - Hwo to write %> into a file in asp hi, Hwo to write %> into a file in asp, I got error when I run the script below. please help. many thanks. <% strContent = strContent & "<%" strContent = strContent & "dim i" strContent = strContent & "%>" dim fs, f Set fs = Server.CreateObject("Scripting.FileSystemObject") Set f = fs.openTextFile(strPath, 2, true) f.write strContent f.close set f = nothing set fs = nothing %> Tag: Programmatically test if DB server is alive? Tag: 321869
- Next
  - 1
    - Analyzing debugdiag output I am trying to use debugdiag to diagnose a problem that we're having. I have gotten user dumps of both the inetinfo process and the aspnet_wp process (Windows 2000). However, I am having trouble deciphering the information that is returned. Can anyone point me toward a good resource for making sense out of these reports? Thanks in advance, Linda Tag: Programmatically test if DB server is alive? Tag: 321868
  - 2
    - Administrator rights to control printer I have written some vbscript in ASP. The ASP code can access all Printer data correctly but when it tries to control the printer, such as pausing, resuming print, it does nothing. The written codes have been tested correct, in the sense they run correctly command mode, using VB Scripting Host. Therefore it think it is a access permission issue. I suspect it is because the account running ASP scripts has not got the rights to control system resources such as printer? Is there a way to work around this? This web application is for intranet application. Much apprecited. Tag: Programmatically test if DB server is alive? Tag: 321867
  - 3
    - obscure division by zero conundrum i know, this shouldnt be a conundrum right? one just shouldnt divide by zero. but this is suddenly happening *all over* my site. after chasing the error here and there, i simplified things down to: response.write cstr(4/2) response.end and i STILL get the error: Microsoft VBScript runtime error '800a000b' Division by zero [followed by the line on which the error occurs] so i know it's not my code. how can you get a division by zero error when you're dividing with CONSTANTS??? did i change some obscure setting or something? now mind you, i tried "response.write cstr(4+2)" and the system managed to output "6". what the heck is this? please help! Tag: Programmatically test if DB server is alive? Tag: 321862
  - 4
    - IIS shutting down automatically on its own IIS in our server is shutting down automatically on its own. I don't know what is the problem? Please suggest? Tag: Programmatically test if DB server is alive? Tag: 321858
  - 5
    - new to ASP - must create PDF Hi! Is there a (simple) way to create a PDF file from ASP? BR Sonnich Tag: Programmatically test if DB server is alive? Tag: 321853
  - 6
    - ASPNET account not created I am starting to use the ASP.NET Commerce Starter Kit to initiate a website, and have had an installation error - 'computerName/ASPNET account not found.'. I am using XP Pro with IIS installed and according to documentation, this should create the account, but it is not listed - It is needed as even changing the folder permissions for the root folder to 'Everyone' will not enable to connection from SQL Server to remote folders. I have tried installing and uninstalling IIS to no avail. There are some scripts to create the account but these are marked as suitable for .NET 1.1 only. I have .NET 2.0. Just wondering if anyone else has encountered this and if there is a fix. Thanks in advance for any help you can offer. -- Blackfish.NET Tag: Programmatically test if DB server is alive? Tag: 321848
  - 7
    - Write file from asp page. I need to write a log file on server side. I'm using the code below. By some reason it just hanging on and not doing anything. Just the progress bar is moving very very slow and maximum gets to the middle. Tryed it on two different server, same result. I have feeling I used to run this before with Server.MapPath and without, and it worked. But not now. Can somebody tell what's wrong with it? Thanks, Michael Here is the code: <% sub WriteToFile(FileName, Contents, Append) on error resume next Dim oFs, oTextFile, iMode if Append = true then iMode = 8 else iMode = 2 end if set oFs = server.createobject("Scripting.FileSystemObject") set oTextFile = oFs.OpenTextFile(FileName, iMode, True) oTextFile.Write Contents oTextFile.Close set oTextFile = nothing set oFS = nothing end sub WriteToFile "zzz.txt", "XXXXXXXXXXXXXXXXX", true response.write "Recorded" %> Tag: Programmatically test if DB server is alive? Tag: 321845
  - 8
    - Sort and list by month This one is related to my previous question. My (Access) database contains events. I'd like to sort and list by month and year, like the example under here. Any tips on how to do this would be appreciated. 2005 November Event Event Event 2005 December Event Event Event 2006 January Event Event Event 2006 February Event Event Event Tag: Programmatically test if DB server is alive? Tag: 321838
  - 9
    - Showing date as May 10 2006 not 05/10/2006 How do I get dates stored in Access to show on asp page as May 10 2006, or even better May 10th 2006? Is there a special format I should store the date as? Have tried various formats, long/short, but keep getting it to show up as 05/10/2006. Any asp code I can slap in there to fix this before it drives me nuts? I have no control over the web server. Torbjorn Tag: Programmatically test if DB server is alive? Tag: 321836
  - 10
    - formatcurrency() places $ after number??? Does anyone know how to correct or why formatcurrency() places the dollar sign after the number? thanks LJB Tag: Programmatically test if DB server is alive? Tag: 321832
  - 11
    - Request.Form 'and' cdo.message USING IIS 5.1, and Windows XP pro, the following form works on my system, and I can use as many form elements as I wish, as long as all form elements have the same name: "words", in this example. Help -- why can`t I give each form element a different name? Any suggestions will be gratefully appreciated. Also,See example at very bottom of something that once worked on a remote server, but doesn't on IIS 5.1, windows xp pro <%@LANGUAGE="VBSCRIPT"%> <% Dim MyMail Set MyMail = Server.CreateObject("CDO.Message") MyMail.TextBody = Request.Form("words") MyMail.From = "postmaster@localhost" MyMail.To = "postmaster@localhost" MyMail.Subject = "CDOSYS for Windows 2000/XP" MyMail.Send() Set MyMail = Nothing %> <HTML> <FORM NAME="TextBody" METHOD="post" ACTION="gusto44444444.asp"> <P><BR> <input type="text" NAME= "words" ID="words" COLS="28" ROWS="1"> Name <br> <input type="text" NAME= "words" ID="words" COLS="28" ROWS="1"> <SPAN CLASS="book_antigua">E-Mail</SPAN><BR CLEAR="all"> <input type="text" name= "words" id="words" cols="28" rows="1"> Phone</P> <BR> <TEXTAREA NAME = "words" ID="words" COLS="18" ROWS="2" wrap="VIRTUAL"></TEXTAREA> <SPAN CLASS="book_antigua">Write Here </SPAN><BR CLEAR="all"> <P> <INPUT TYPE="submit" NAME="Submit" VALUE="Submit, e-mail required" ALIGN="DEFAULT"> <input type="reset" name="Reset" value="Reset"> </P> <P> </P> <P> </P> </FORM> <% dim words words=Request.Form("words") If words<>"" Then Response.Write("Thanks " & words & "!<br />") Response.Write("We'll respond soon") End If %> EXAMPLE AT BOTTOM -- WORKED IN PAST BUT NOT NOW Dim myMail Set myMail = Server.CreateObject("CDONTS.NewMail") Request.Form("email1") Request.Form("name") Request.Form("phone") Request.Form("words") Tag: Programmatically test if DB server is alive? Tag: 321822
  - 12
    - HTML Tab pages I ahve an asp page which has many controls. I have identified that I can arrange then into different tab pages. are there any samples of the tab pages in ASP which can be cross browser. Simple HTML/JavaScript way will be fine. We want to avoid the third party tab controls. Thanks Tag: Programmatically test if DB server is alive? Tag: 321821
  - 13
    - wscript.shell error People; i'm from argentina so , sorry, but my english isn´t good... Now, the question is; I'm trying to run a *.bat program on an ASP page, with the wsh script, but i can´t do it... because i obtain an error code (5 access denied) I let you the code that i´m using, so you can help me Dim wshell, proc set wshell = server.createobject("wscript.shell") prg="%comspec% /c net stop dns" set proc = wshell.exec(prg) Do While proc.Status < 1 Loop Response.Write prg & "<br>" Response.Write proc.StdOut.ReadAll & "<br>" Response.Write proc.stderr.readAll & "<br>" set wshell = nothing .... I tried besides, the "run" methon instead of "exec", but the result is the same... so ... help!!! I have gave permissons (total control) to IWAM and IUSR users on the page folder, and on cmd.exe program and net.exe program; but there isn´t case, it doesn´t work... Thanks for your suggestions; and sorry about my english... If you don´t understand my , let me knot that, and i try to explain better... Ferg Tag: Programmatically test if DB server is alive? Tag: 321818
  - 14
    - Session variables are not getting initialized in global.asa file I have initialized some session variables in Global.asa for our web application. But these session variables are returning null values; it is was working fine before; Recently we have rebuild our servers. Please let me know if anyone of you have some idea? Tag: Programmatically test if DB server is alive? Tag: 321815
  - 15
    - Explorer waiting indefinitely for IIS response Strange and curious problem I'm experiencing. I implemeted a web site asp solution IIS 5.0. The site performe long calculations. What's happening is the following: if I connect through a ADSL connection I don't have problems, the browser (IE 6.0) wait also for 20/30 minutes and then receive correctly the response from the IIS server. If I connect through a dial-up connection, if the calculations duration is more that 10/15 minutes, than the browser wait undefinitely, without any signal, and doesn't receive the response from the server, although the calculations ended correcly. The browser didn't freeze or crash, simply wait forever! I've tried everything: I checked the "current connections" counter of performance monitor on the server host running IIS. But it seems that the connection isn't lost. I checked with a sniffer TCP/IP packets, and I noticed nothing strange, apart that the response was not being sent/received. Anyone experiencing a similar problem? Any suggestion, or idea to solve the problem? Thank's a lot for your help. Andrea Tirabosco Tag: Programmatically test if DB server is alive? Tag: 321810
  - 16
    - data sending i used a check box in a loop: <input type="checkbox" name="Inv" id="Inv" value="<%= rstMain("TR_ID") %>"> n transfered the value to the next page...wats the best way to transfer the data to a 3rd page Tag: Programmatically test if DB server is alive? Tag: 321809
  - 17
    - Includes I have an asp page. Now I know this is sortof OT, but I am not sure of the forum to get an answer. I have an include on this asp page  now, it gives me this error: File attribute '\forum\includes\consts-inc.asp' cannot start with forward slash or back slash. i can't use .. either, because it gives me this error:The Include file '..\forum\includes\consts-inc.asp' cannot contain '..' to indicate the parent directory. I tried with the slashes going / and \ if i use this:  i get this: The include file 'forum/includes/consts-inc.asp' was not found. for some information. i the file that gives the error is in the includes folder, which is in the root web. the forum folder is also in the root web. so i am in folder unthe root, and trying to include a file from another folder under the root. how can i do this?? thanks in advance Jeff Tag: Programmatically test if DB server is alive? Tag: 321806
  - 18
    - Problems with Access I get this error: ------------------------------------------------------- ADODB.Connection error '800a0e7a' Provider cannot be found. It may not be properly installed. /inc/DBconnect.asp, line 6 ------------------------------------------------------- I have just set up a new server, Win 2003 Std x64 bit It seems like the driver for connecting to the database does not work on x64 bit!?! Is there any workarounds on this, or do I have to get myself a new Win edition? Best regards, Christopher Brandsdal Tag: Programmatically test if DB server is alive? Tag: 321795
  - 19
    - CDOSYS help needed hi i'm new to ASP and have to deal with some email scripting at the very start.I've collected some script pieces from a variaty of tutorial pages but haven't been able to send any mails yet. I'm pasting the latest version of the code: <% Dim sMsg Dim sTo Dim sFrom Dim sSubject Dim sTextBody sTo = "test@blabla.com" sFrom = "crush@bonbon.com" sSubject = "Insert here your subject text" sTextBody = "Insert here your plain body text" Dim objMail, oMailConfig 'Create the mail object Set objMail = Server.CreateObject("CDO.Message") Set oMailConfig = Server.CreateObject ("CDO.Configuration") oMailConfig.Fields("http://schemas.microsoft.com/cdo/configuration/smtpserver") = "localhost" oMailConfig.Fields("http://schemas.microsoft.com/cdo/configuration/smtpserverport") = 25 oMailConfig.Fields("http://schemas.microsoft.com/cdo/configuration/sendusing") = 2 oMailConfig.Fields("http://schemas.microsoft.com/cdo/configuration/smtpconnectiontimeout") = 60 oMailConfig.Fields.Update Set objMail.Configuration = oMailConfig 'Set key properties objMail.From = sFrom objMail.To = sTo objMail.Subject= sSubject objMail.TextBody = sTextBody 'Send the email objMail.Send 'Clean-up mail object Set objMail = Nothing %> As I said before i'm very new to ASP so i might be even missing a very basic stuff. I've tried the code without the configuration part as well but nothing has changed. Actually it seems that the problem is about objMail.Send part. When I comment it the script runs fine but when I activate it the page is not accessible (that's another problem that i've come up with ASP. There's no error messages but a page error. Should I catch an exception to see what's wrong or do I need to check some other stuff?) I wasn't sure about the VB syntax style so I also tried objMail.Send() My script is running on IIS 6 server so I don't think there's a support problem with CDOSYS Any help and/or advise is appreciated muchly Thanks :) Tag: Programmatically test if DB server is alive? Tag: 321791
  - 20
    - Storing Session State HI All Looking for some advice on session in ASP. We are running windows 2000 with dot.net framework 1.1 on IIS 5.1 This is an NLB architecture with the session being stored in an SQL DB. We have been coding and deploying using ASP.NET with no problems however the 'powers that be' have recently bought an online booking application which has been coded using classic asp. We have set the session location in the machin config of the framework stating mode="SQLServer". Will this ASP use this or continue to store the code InProc? Thanks Michael D Tag: Programmatically test if DB server is alive? Tag: 321783
  - 21
    - Simultaneous fill out and display of a form I would like to make a form that multiple people can access and update at same time with their web browser. The form would have fields that each would fill in and I would like for all to see what the others fill in. Is there an automatic way or would they have to refresh? Any books, etc. to help would be great. Thank you. Tag: Programmatically test if DB server is alive? Tag: 321782
  - 22
    - Partial downloads Has anyone got any experience with getting partial downloads working with ASPX pages? I am unable to .AddHeader("Accept-Range", "bytes") - ASP.NET eats the header, and refuses to transmit it. I am trying to enable partial/resumable downloads for PDF/DOC content that I am streaming up from a SQL image column. Any thoughts? -- Regards, Fil. Tag: Programmatically test if DB server is alive? Tag: 321778
  - 23
    - Checkbox Issues Hello, I have the following problem with the checkbox. The issue seems to be that when I click on the following checkbox: <input type= checkbox id="checkbox1" name="<%response.Write "recount" & CoCount%>" value="<%=idx%>" > with the following values below: <input type=hidden name="recount" value=<%=idx%>> <input type=hidden name="contactname" value="<%=oDodgeCos3("f_person") %>" id=hidden1> <input type=hidden name="drnum" value="<%=request("dr_num")%>" id=hidden2> <input type=hidden name="companyname" value="<%=oDodgeCos3("f_comp_name")%>" id = hidden3> <input type=hidden name="address" value="<%=oDodgeCos3("f_addr1")%>" id=hidden4> <input type=hidden name="city" value="<%=oDodgeCos3("f_city")%>" id=hidden5> <input type=hidden name="state" value="<%=oDodgeCos3("f_state")%>" id=hidden6> <input type=hidden name="zip" value="<%=oDodgeCos3("f_zip")%>" id=hidden7> <input type=hidden name="phone" value="<%=oDodgeCos3("f_phone")%>" id=hidden8> <input type=hidden name="fax" value="<%=oDodgeCos3("f_fax_nbr")%>" id=hidden9> The problem is that when I click on the box, it seems that the all values is being passed over to the next page. How would I have the values passed over based upon the checkbox that the user select? Thanks! Kevin Davis Tag: Programmatically test if DB server is alive? Tag: 321776
  - 24
    - MS Access + ASP + ADO + OpenSchema + error - Unspecified Error I am using MSAccess 2003 as my DB, ASP page my front end. My access file is in the temp folder which ahs IUSR_Machine permissions. My asp page works fine, connects to DB and retrieves what I want. Now, when I open my db file in Microsoft Access in Exclusive mode my ASP page doest establish a connection which is correct as exclusive open locks the files and prevents further connections. Upto here no problem. Now when I close that opened Microsoft Access instance, my web page resumes working. If I refresh it, it works. The third time I refresh the page I get "Unspecified Error". Again if I refresh it works and again if I refresh I get "Unspecified error" when I debugged it fails at connection open. Here is my code snippet.. if strConnString <> "" then objConn.Mode = 3 objConn.ConnectionTimeout = 30 objConn.CursorLocation = 3 'adUseClient objConn.open strConnString set oTmpRs.ActiveConnection = objConn Set oTmpRs = objConn.OpenSchema(4, Array(Empty, Empty, tmpStrTable,Empty)) Set oTmpRs.ActiveConnection = Nothing set rsColumns = oTmpRs.Clone set oTmpRs = nothing objConn.Close end if set objConn = nothing Can anybody tell me what's wrong here..what could be the root cause of this problem.. I tried almost all solutions I know and found in search engines..but not yet solved this issue.. thanks Tag: Programmatically test if DB server is alive? Tag: 321775
  - 25
    - Date Prob In Sa the date format is dd/mm/yy. in sql server the format the format is mm/dd/yy. What code can be used to chnge the format to the SA date format eithout chnging sql servers regional settings? Tag: Programmatically test if DB server is alive? Tag: 321771

In ASP VBScript, is there a way to programmatically test if a SQL Server
database server is alive?

I want to use a connection string to a mirrored DB server in case the
primary DB server fails. This failover is easy in ASP.NET, which supports DB
mirroring and a the specification of a secondary server in its data
provider. I want to hack together the same thing for my classic ASP apps.
Any suggestions?

-KF

Top

RE: Programmatically test if DB server is alive? by lukezhan

lukezhan
Tue May 16 21:35:02 CDT 2006

Hello,

To detect a Database is availeble, you may just open a connection to it and
catch possible error. For example:

Con.Open "Provider=SQLOLEDB; Data
Source=localhost;database=northwind;integrated security=SSPI"

If Err.Number <> 0 Then
..
Else
..

If there is any error after opening a connection, we can think this server
is not availeble currently and redirect to backup server.

Regards,

Luke Zhang
Microsoft Online Community Support

==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================

(This posting is provided "AS IS", with no warranties, and confers no
rights.)

Top

Re: Programmatically test if DB server is alive? by kenfine

kenfine
Wed May 17 11:45:43 CDT 2006

Super, very helpful, thanks, Luke.

-KF

"Luke Zhang [MSFT]" <lukezhan@online.microsoft.com> wrote in message
news:FGChFqVeGHA.4672@TK2MSFTNGXA01.phx.gbl...
> Hello,
>
> To detect a Database is availeble, you may just open a connection to it
> and
> catch possible error. For example:
>
> Con.Open "Provider=SQLOLEDB; Data
> Source=localhost;database=northwind;integrated security=SSPI"
>
> If Err.Number <> 0 Then
> ..
> Else
> ..
>
> If there is any error after opening a connection, we can think this server
> is not availeble currently and redirect to backup server.
>
> Regards,
>
> Luke Zhang
> Microsoft Online Community Support
>
> ==================================================
> When responding to posts, please "Reply to Group" via your newsreader so
> that others may learn and benefit from your issue.
> ==================================================
>
> (This posting is provided "AS IS", with no warranties, and confers no
> rights.)
>

Top