To work with two data bases in asp

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
    - Web report development Hi, We have a web application(asp based) without any report features. I have to build web reports. Right now, these reports are build on an Access 97 desktop application. The idea is to have our clients to print the reports via web application. I am wondering, what is the best way to develop web reports that would be exact same as Access 97 reports. Thanks in advance. Regards. Tag: To work with two data bases in asp Tag: 314730
  - 2
    - Global.asa Session_OnEnd I have an ASP application that is a electronic purchase orders system. My problem is that only 3 people can authorise a purchase order. When a purchase order is selected I update the table to show that the field is locked. If they complete the form then the database is updated and the lock is removed, all though at this stage the record moves into another part of the system and the lock becomes redundant. If however they dont complete the form the record is left in a permanent locked state, it could be that they decided to look at the record then navigated away or closed the browser. So i thought maybe i could stick some code that updates the database into the session_OnEnd in the global.asa, so after 20 minutes when the session has ended the lock will free. I don't however have any experience with this and don't even know if this will work. The code won't be a problem its just whether this process will actually work. I am thinking that I code put the order_id into a session variable then when the session variable ends i run a sub in the .asa file that gets the session variable and updates the table. Am I thinking correctly here or have i misunderstood the event and its purpose, or is there a better way of achieving the task. TIA Tag: To work with two data bases in asp Tag: 314709
  - 3
    - Writing to valid ANSI text file (UTF8 issue?) Hi, I've a problem with code that should produce a Windows(ANSI) encoded text file but doesn't. Server is IIS 5 on Win 2k, with ASP ver? My ASP uses data from an upstream HTML form on a UTF-8 encoded page. The latter is output by a server-side system and I can't alter that source format. Here's some of the ASP code (may wrap): ' Following vars are longer strings but of this type - just more Request object vlaues added strLabels = "Filename" & vbTab "EXTENDED_DESCRIPTION" strValues = Request.Form("Filename") & vbTab & Request.Form("EXTENDED_DESCRIPTION") On Error Resume Next ' set up the FSO Set fso = CreateObject("Scripting.FileSystemObject") ' Create the lock file ('ture' arg allows file overwrite if already exists) Set objMyFile = fso.CreateTextFile(strDataFile, True) If Err.Number = 0 Then ' Successfuly created file, let's write to it objMyFile.WriteLine(strLabels) objMyFile.WriteLine(strValues) ' close - we're done objMyFile.Close This code worked with the previous version of the server-side system but since it was upgraded now the next part after the ASP form-to-file process breaks as expects a Windows(ANSI) TXT file. When I do a text import of my current ASP created files it reports "MS_DOS(PC-8)". I assume the move to UTF-* encoded pages upstream is the issue. I assume the ASP is getting UTF-8 values from the Response object. How can I parse these to ANSI encoding to get a valid Windows(ANSI) Text file? Many thanks. Mark Tag: To work with two data bases in asp Tag: 314705
  - 4
    - Alternative to <select> for large number of values? My users have to select an value from a fixed selection of values. The obvious choice of control for such a requirement is to use a <select> (i.e. a combo box). My problem is that sometimes, these combo boxes will have a *large* number of values. There could be any number of values in them from 5 to 5 million (unlikely it would be this large but possible). Obviously 5 million is far too much to populate a <select> control with. Does anyone have any suggestion as to how a user could select a value from a *potentially* very large selection of values (i.e a suitable alternative to the <select> control)? Tag: To work with two data bases in asp Tag: 314703
  - 5
    - Use of HTTP_REFERER in Global.asa Hello, I have the below requirement. When ever my website is opened by any link: say clicked from the google search result or a link from other website: Then I should able to know the referrer URL. How Do I get that? I know about Request.ServerVariables("HTTP_REFERER"). So I used this in "global.asa" file in "Session_OnStart" event like this: Sub Session_OnStart Session("ReferralURL") = Request.ServerVariables("HTTP_REFERER") End Sub Sub Session_OnEnd Session("ReferralURL") = "" End Sub So that I can use the session variable any where in my website, because the HTTP_REFERER will give the URL of the last webpage. But this seems to not working. Please help. Thanks Prabhat Tag: To work with two data bases in asp Tag: 314702
  - 6
    - dear microsoft.public.inetserver.asp.general readers -----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 It's getting a bit tiresome seeing one misguided American after another with their cutsie little yellow or red-white-blue ribbons on their outsized SUVs. Yeah, I guess it's the thing to do; maybe part of that whole soccer-mom culture. Unfortunately, the only thing they demonstrate is that the person behind the wheel is a clueless, gullible, misguided, nitwit. If foreign invaders landed on our soil, as we have done in Iraq, I would be the first one to take up arms and repel them. (I suppose that would make me an 'insurgent' by OUR logic.) This, and other aggressive governments have always done their utmost to make it APPEAR as if committing yourself to kill in feuds on distant shores that have nothing to do with the welfare of the citizenry is somehow patriotic. It is not. Enlisting in the armed forces, in the absence of a real and impending foreign threat, is no different that hiring yourself as a paid assassin . . the only difference is, you're not getting paid enough. But let's take a realistic look at exactly WHO joins up in an all-volunteer army. The first group are those who join (during peacetime) for the benefits: to get an education, or because it seems a reasonable career path. Consider carefully! Realize that you are gambling with your humanity. Once you sign that form, you sign away your right to say: "No, that is an atrocity." You put your abilities, including the ability to kill, at the disposal of proven liars, psychopaths . . . enemies of humanity. Do you think that every German soldier in World War II who helped load Jews into cattle cars was a cold-blooded killer? Most were poor kids, just like you, who got caught up in the patriotic frenzy. Once you're in, you're IN. You lose the ability to stop killing until they tell you so. This not only makes you less than human, it makes you less than an animal, for even the animals retain their freedom of self determination. The second group are the simple minded, who fall for patriotic entreaties about defending democracy, Mom, apple pie; in other words, all the traditional government propaganda. Do you think Soviet lads subjugated their neighbors throughout the world because they thought the Soviet Union was an EVIL empire? No, they were fighting for MOM, and whatever passes for apple pie in Russia. Step back and examine the lies your government is handing you, and ask yourself if they have the ring of truth. Do you want to be one of the murderers in uniform who opened up on their fellow citizens at Kent State? When you put on that uniform, you give up all autonomy, and become nothing more than a weapon, to be used for whatever evil purposes the scoundrels in government demand (and, if you look carefully, you will discover that the only interests THEY serve are those of the big businesses that own them.) Finally, you have the hard-core psychopaths. These are the people who WANT to kill. Murder, torture, rape; THESE are the American values upon which THIS group is focused. The cause doesn't matter, they're after the thrill that only warfare can provide. Just remember: killing for George W. Bush, or for George H.W. Bush, or for Lyndon B. Johnson, or for Richard M. Nixon is not the same as defending yourself, your family, your friends, or your country. Don't be a dupe. Don't Enlist! Remember -- supporting the troops means supporting Bush aggression, profiteering, and war crimes. Here's an idea: why not take those ribbons, dip them in blood, and mail them to the White House? - -- Tom St.Denis 111 Banning Rd Kanata, Ontario K2L 1C3 Canada Home: (613)836-3160 Cell: (613)796-8220 tomstdenis@gmail.com KeyID: 0x40B640D5 Fingerprint: 53F9 307F F83E D52A 9E63 C2A5 B43F D952 40B6 40D5 http://pgp.mit.edu:11371/pks/lookup?op=get&search=0x40B640D5 -----BEGIN PGP SIGNATURE----- Version: PGP 8.0.3 iQA/AwUBQxLVO7Q/2VJAtkDVEQJnnQCg1mRyNVgZ6Po6Xf7csn62Ph9rkC8AoMxZ Zo8jLvfr6bDGWZb/PhEpz3c8 =2NAY -----END PGP SIGNATURE----- Tag: To work with two data bases in asp Tag: 314701
  - 7
    - Paged recordsets What is the best way to produce these? Is there a SQL statement that selects, say, records 30-40 from the results? Tag: To work with two data bases in asp Tag: 314700
  - 8
    - Need help with "No input file specified" error I'm new here so if I posted this incorrectly please go easy. I recently moved my website from a Unix hosting service to a Windows 2003 IIS hosting service. The site was converted from php/mysql to asp/mssql. The search engines still have a lot of links cached that point to ......php. When a user clicks the link they get a blank page that reads "No input file specified.". This page does not appear to be a standard error page. My question. Is there a way to redirect all ....php page requests to my home page? Thanks, Terry http://www.4everhers.com Tag: To work with two data bases in asp Tag: 314696
  - 9
    - images and buttons HTML question Very basic HTML question 1. I have image I want to display that to a button how can I do that. I want to fire the on click event too 2. if 1 is not possible then how can I set image to have oncclick event, currently I get object nbot found error code is like this <button ID ="Sel" name="Sel" OnClick="moveOptions(this.form.AvailableInd, this.form.SelectedInd);" ><img src = "/images/movedown.gif" alt="Remove" title="Remove"></button> <button ID ="Del" name="Del" OnClick="moveOptions(this.form.SelectedInd, this.form.AvailableInd);" ><img src= "/images/moveup.gif" alt="Add" title="Add"></button> above code shows me the button which I dont want and just want to display image when I tried following code, moveoptions doesnt work <img src = "/images/movedown.gif" alt="Remove" title="Remove" OnClick="moveOptions(this.form.AvailableInd, this.form.SelectedInd);"> <img src= "/images/moveup.gif" alt="Add" title="Add" OnClick="moveOptions(this.form.SelectedInd, this.form.AvailableInd);" > any clues Tag: To work with two data bases in asp Tag: 314694
  - 10
    - un/hiding textbox when dropdown changes Hi, I would like to know if this is possible. I'm using ASP with JSCRIPT. I have a dropdown box that when the use selects a particular value, I would like the textbox to become visible. also if they dont choose it, I would like the textbox to be hidden. I have this web input form with many other fields. This dropdown box is in the middle of these fields. I dont see any property to set. I see the disable property but I want it hidden. thanks, Will Tag: To work with two data bases in asp Tag: 314692
  - 11
    - Capturing identity of the user Hi... I have made a asp page that accepts some data from user and stores it in MS Access database. Now...I want to identify the user who filled the form and store this information in database. About the enviornment....the server has Windows 2000 server installed. Clients have Windows XP. Server also has Exchange 2003 installed and every client has Outlook Express installed. Every user has to login to his account inorder to use a machine. A given user can login on any machine. How can i find the identity of the user who submitted the form? Is it possible to find out the current logged in user given the IP address of the machine? If yes, how and will there be any chances of error due to delay in replication? Since ASP can use 'com' components on server, i think there should be some way to achive this. What do you think? For any clarifications post a reply or mail me at mailanoop@gmail.com Thanks in advance.... - Anoop Tag: To work with two data bases in asp Tag: 314690
  - 12
    - problem accessing cookie values I have a pdf form that is submitting to an asp 3.0 page. I am setting a cookie value at login time that I need to access in this processing page. For some reason, the cookie is not being detected on that particular page but is being detected on other pages on the same server when I test for it. This problem only occurs on the processing page when I post to it from the form. If I navigate to it directly, the cookie is detected. This is happening no matter what version of adobe reader or acrobat is used. Tag: To work with two data bases in asp Tag: 314685
  - 13
    - ASP to EXCEL Hi, Im creating an Excel file using ASP Versions : Office 97 The formattting is not working properly in Excel 97, but the same works fine in Office XP & 2000 Is there any additional code has to be added in my code to get a formatted output in Excel 97 version? Please help. Thanks. MyCode --------- set Cn=server.createobject("ADODB.connection") Cn.open sqlconstring tfName = "salesexcel.xls" set Rs=server.createobject("ADODB.recordset") sql = "select * from sales WHERE month(saledate)=8 and day(saledate)=28 year(saledate)=2005" Rs.open sql,Cn,1,3 Response.ContentType = "application/vnd.ms-excel" Response.AddHeader "Content-Disposition", "attachment; filename=" & tfName if not rs.eof then Response.write "<table>" Response.write "<tr><td colspan='2'>ID</td><td colspan='2'>Executive</td><td colspan='2'>Sales Done</td></tr>" while not rs.eof Response.write "<tr>" Response.write "<td colspan='2'>" & rs(0) & </td>" Response.write "<td colspan='2'>" & rs(1) & </td>" Response.write "<td colspan='2'>" & rs(2) & </td></tr>" rs.movenext wend enf if Response.write "</table>" set Cn = Nothing ------------------------------------------------------------- Tag: To work with two data bases in asp Tag: 314684
  - 14
    - Multimedia - MP3 Does any know how to hide the audio media from the page or embedded file the way flash does? Explain. I have 5 MP3 or WMA files in hosting service and I want the user to select them for playing in the embedded windows media player in a asp page I know how to hide the control of the media player but by looking at the source of the page you can tell what file is playing and location of it cutting and paste link on the browser then anyone can still it and that what I want to avoid. I was trying to do it with flash but I am not good at it so gave up and trying to do it in just plain .ASP Can this be possible.? TIA. Tag: To work with two data bases in asp Tag: 314665
  - 15
    - Select DB Columns Dynamically! A Form has a select list which lists all the column names of a SQL Server database table. Users will select one or more than one column from this select list & after submitting the Form, the records of only those columns that he had selected in the previous page will be displayed to him. This is the Form code: ---------------------------------------- strSQL="SELECT COLUMN_NAME FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME='tblSheet' ORDER BY ORDINAL_POSITION" ............. ............. objRS.Open strSQL,objConn <form........> <select name="colname" multiple size=5> Do Until(objRS.EOF) %> <option><%= objRS("COLUMN_NAME") %></option> <% objRS.MoveNext Loop %> </select> ---------------------------------------- & this is the ASP page that retrieves the records: ---------------------------------------- <% Dim strColNames,arrColName,strEachColName strColNames=Request.Form("colname") arrColName=Split(strColNames,", ") ............. ............. ............. Dim strSQL strSQL="SELECT " & strColNames & " FROM tblSheet" ............. ............. ............. objRS.Open strSQL,objConn %> <table border=2> <tr> <% For Each strEachColName In arrColName %> <th><%= strEachColName %></th> <% Next %> </tr> <% Do Until(objRS.EOF) %> <tr> ---------------------------------------- Now how do I loop through the recordset to display the recordset to the user? Had the column names not been generated dynamically, objRS("ColumnName") would have sufficed but how do I do the same here? Thanks, Arpan Tag: To work with two data bases in asp Tag: 314659
  - 16
    - Need Help With QueryString & Password! An ASP application retrieves records from a SQL Server database. In the first page of the application, the user has to enter a password & the columns retrieved from the DB table depends upon the password. For e.g. if the password entered is say, pwd1, then that user should be displayed the records of Column1 & Column2 only. If the password entered is say, pwd2, then that user should be displayed the records of Column1 & Column3 only. If the password entered is say, pwd3, then that user should be displayed the records of Column1 & Column4 only. Now after the records are displayed, the user should also be given the option of sorting the records. I am implementing this by making the column header a hyperlink which has the column name & the sort order as the querystrings, something like this (the records are being displayed in a tabular format): ---------------------------------------- <% Dim strColName,strSortOrder,strPwd strColName=Request.QueryString("colname") strSortOrder=Request.QueryString("sortorder") strPwd=Request.Form("pwd") 'assume that the user is displayed the records of Column1 & 'Column2. When the user comes to this page for the first time 'after entering his password in the previous page, both 'strColName & strSortOrder are empty strings. Dim strSQL If(strColName="col1" Or strColName="") Then If(strSortOrder="" Or strSortOrder="asc") Then If(strPwd="pwd1") Then 'columns retrieved depends on the 'password strSQL="SELECT Col1,Col2 FROM tblSheet ORDER BY Col1 ASC" ElseIf(strPwd="pwd2") Then strSQL="SELECT Col1,Col3 FROM tblSheet ORDER BY Col1 ASC" ElseIf(strPwd="pwd3") Then strSQL="SELECT Col1,Col4 FROM tblSheet ORDER BY Col1 ASC" End If ElseIf(strSortOrder="desc") Then 'the same code in the If condition will come here, the 'only difference being using DESC in the ORDER BY clause. End If End If 'Column1 is common for both pwd1 & pwd2, thus using Or in the 'next If statement If(strPwd="pwd1" Or strPwd="pwd2") Then If(strColName="col1" Or strColName="") Then If(strSortOrder="" Or strSortOrder="asc") Then %> <a href="Records.asp?colname=col1&sortorder=asc">Column 1</a> <% Else %> <a href="Records.asp?colname=col1&sortorder=desc">Column 1</a> <% End If End If %> ---------------------------------------- As seen in the above code, I am passing the column name & the sort order through the column header (which is a link) as querystrings. This correctly sorts the columns & serves my purpose. But the problem is since the columns displayed depends on the password entered by the user, when it comes to sorting the records, even the password has to be passed somehow along with the column name & the sort order. Of course, the password can be passed as a querystring along with the column name & the sort order but that's definitely not a wise idea. So how do I pass the password when the user clicks one of the column headers to sort the records? One way of carrying the password forward is by encrypting the password & then sending it through the querystring along with the column name & the sort order but I would like to avoid such a solution. This solution will be my last option. Please keep in mind that the columns displayed to a user depends upon the password; so the password has to be sent somehow along with the column name & the sort order (column name & the sort order are being passed through the querystring). For e.g. if the password entered is pwd1, then the user sees the records of only Column1 & Column2. Next he clicks the column header 'Column 1' (which is a hyperlink with the column name & the sort order as the querystrings) to sort the records based on Column 1. When the link is clicked, pwd1 also has to be carried forward so that this user is displayed the records of Column1 & Column2 only & not the records of the other columns. Thanks, Arpan Tag: To work with two data bases in asp Tag: 314654
  - 17
    - checking for window existance Is there any way to check the existance of a window by the name ? I'm using this code: window.open("http://www.google.com",'targetWin1') If I open a window using previous code without getting immediatly return value of open method, can I get it in a second moment ? For example using the value of param sName of open method ? regards Tag: To work with two data bases in asp Tag: 314644
  - 18
    - Deleting blank lines from text file I have a text file being create with the FileSystemObject. It's being built based on results from a SQL query. All this is working fine, but so that I have a carriage return VBCRLF at the end of each row, I have an empty row at the end of my text file. How do I delete this last line? Here is the end of my script: csvText=csvText & vbcrlf rs.movenext loop How should I do this? Thanks!! *** Sent via Developersdex http://www.developersdex.com *** Tag: To work with two data bases in asp Tag: 314640
  - 19
    - £ to $ conversion Hi I want to be able to show prices in £ to UK customers and $ for every one else. Is there a way to do this. Thanks D Tag: To work with two data bases in asp Tag: 314636
  - 20
    - ASP Classic and .Net Components Hello, I have just moved an ASP Classic website to a new hosting company that has a number of .NET components available. The website works fine after the move with one exception. We were creating PDFs using ASPPDF for ASP but now it looks like only ABCPDF.NET is available. My knowledge of ASP.NET is very limited at this time and I am planning on converting the site to ASP.NET soon but I really need to get the PDF working as soon as I can. Is any of the following possible... 1) "wrap" the ASPPDF com control so I can use it at the new hosting company as a workaround for now? This would be the easiest for me as I would not need to change the asp classic code (maybe a little). Maybe place the asppdf com control in the .bin directory? The control does need registered in it's current form. 2) access the ABCPDF.NET component from a classic asp page? 3) write the pdf code in ASP.NET and then call that code from an ASP Classic page? If I write this as a web service can I call the web service from an ASP Classic page? I would need to pass a parameter, maybe two parameters to the pdf code 4) I am open to any suggestion other then migrate the website to asp.net at the moment as I need to get this up and working in the next few days if possible. If you have any thoughts on this subject please let me know. (code samples would be wonderful!!) Cheers, Rhek Tag: To work with two data bases in asp Tag: 314634
  - 21
    - Performance problem when moving to new server Hi All, We need to move an old asp database application that I wrote to a new server. But when we do we start getting serious performance problems as more and more users connect. By old I mean old, its using a MS Acccess 97 database as the back end which is on the server also. There are no code changes just a streight move from the old server to the new server. I testing it seemed ok, its only when a few users start connecting that the performance get really bad. It seems the initial connection time is one of the obvious problem areas. The original server is running on Windows 2000 Service Pack 4 with IIS 5 The new server is running on Windows 2003 Service Pack 1 with IIS 6. Whats different between the two versions that mightr be causing this problem. Can anyone help? TIA Brian Tag: To work with two data bases in asp Tag: 314632
  - 22
    - display problem Hi, I have a strange problem when i try to display my data on a web page. Everything's fine until i try to display a Date Value. If i try to display this, no problem : obj("data1") obj("data2") obj("data3") obj("data4") But if i try to display this, only "data1" and "data2" will by displayed : obj("data1") obj("data2") obj("DateData") obj("data1") (if i put DateData at the beginning, i will have a blank page) (if i put DateData after Data1, only Data1 will be displayed) did someone have any idea of my problem ? Thank you Tag: To work with two data bases in asp Tag: 314631
  - 23
    - Charset in XMLHTTP or an alternative solution? Hi, I'm trying to get some data from an external website using XMLHTTP, but my problem is that the data is with special danish characters in (ÆØÅ), which are being replaced with "?" due to UTF-8. I've tried to specify the charset using response.charset, but that doesn't seem to have any effect. Any suggestions, or alternative solutions to XMLHTTP? Thanks. -- Med venlig hilsen Sune Christesen http://www.ActiveWebs.dk/ Tag: To work with two data bases in asp Tag: 314630
  - 24
    - Correct HTTP response status code on "Access Denied" page. Hi, I have a password-protected area on my site. I'm not using any server authentication methods: Instead I prompt the user for a username and password using an HTML form and check these against a database of registered users. I was thinking that this page should be returning a HTTP status code of "401 Unauthorized" instead of its current "200 OK". My reasoning being that this would let search engines know what's going on when they request a protected page and get redirected to the "Access Denied" page. I experimented with adding response.status = "401 Unauthorized" to the "denied" page, but now it displays a (Windows/IE) username & password prompt instead. The HTTP sniffer shows that the www-authenticate field is set to "Basic". My question: How can I indicate to the search engines that the page it is requesting requires authentication, yet have it not display the login/password dialog box? Thanks in advance, --Diarmaid McGleenan Tag: To work with two data bases in asp Tag: 314628
  - 25
    - Looking for mutliple file downloader Is there such a component that makes downloading multiple files easy? Thanks Jon Tag: To work with two data bases in asp Tag: 314620
- Next
  - 1
    - LOGON_USER becomes null Hi, I create a web site in a Windows 2003 server/IIS6, and I used asp pages to get ServerVariables. After I set FrontPage Extension 2002, some ServerVariables like LOGON_USER become null. Any body has an idea? Tag: To work with two data bases in asp Tag: 314612
  - 2
    - Importing comma delimited file I've been asked to develop a semi-automated type situation where we have a database table (sql server) and periodically, there will be a comma delimited file from which we need to import the data, replacing the old. I naurally know that we can use [truncate tablename] to kill the other data, but does anyone have any examples of importing a comma delimited file into SQL Server with ASP? Tag: To work with two data bases in asp Tag: 314610
  - 3
    - Session Problems with Desktop Shortcuts in IE I have an issue that I've been encountering in an ASP application I'm working on. Most of the application is written in ASP, but there is one page written in ASP.NET. The ASP.NET page needs to have access to the ASP Session data to run correctly. In order to achieve this I create my own HTTP request for a certain ASP page with the name of Session variable that I want is stored in the query string of the request. The requested ASP page sends back the Session value in the response (you can see more on this at http://searchvb.techtarget.com/vsnetTip/1,293823,sid8_gci951935_tax293033,00.html). This seems to work in general but we have noticed a few difficult to reproduce problems with this. When multiple instances of the web app are set up in different virtual directories and the user creates desktop shortcuts to access each installation, there appears to be problems with the Session data. When the user opens up more than one shortcut at once, it looks as though all the browsers are running under one IEXPLORE.EXE process. This would explain things if the ASPSESSIONID cookie, which holds the ID for the Session data to use for a particular user, is held in the shared process. However, on different servers the Session bug is not always reproducible. In other words if the user has a desktop shortcuts to "http://Server1/app1/login.asp" and another to "http://Server1/app2/login.asp", the Session accessing will have problems. However if you do the same thing on a different server, that is "http://Server2/app1/login.asp" and to "http://Server2/app2/login.asp", the bug will *not* occur. The servers are running different versions of Windows and IIS, so I'm sure that has something to do with it, but I just can't figure out what. Through some experimentation using FireFox and Live HTTP Headers, we found that sometimes FireFox will contain two ASPSESSIONID cookies, where the characters after "ASPSESSIONID", but before the '=' sign, are different. Since both FireFox browsers were running in the same process and yet somehow correctly handled the Session data, we assumed these extra characters helped the server distinguish which Session data the browser needed. However, these cookies have magically stopped appearing (though FireFox still seems to handle the Session correctly). And I've never gotten the multiple cookie thing to happen in IE. Has anyone heard of this issue? Since people use desktop shortcuts quite a bit, I would have expected this issue to have occurred a number of times in the past, but I'm having trouble finding any info on it. Dave Tag: To work with two data bases in asp Tag: 314609
  - 4
    - Indenting HTML code in a textarea the question is simple... is there any way to indent HTML code inside a simple textarea?... tnx! martin Tag: To work with two data bases in asp Tag: 314605
  - 5
    - trying to open excel from a page (changes in 2002+) hi.. i'm trying to have excel open up a webpage which basically contains a table. in excel 2000 if i specify content type text/csv this works by displaying an open/save dialog box and clicking open, launches excel and displays data as a table (desired result ) however in machines with excel 2002+ excel simply displays the html code. trying to specify application/excel opens an excel plug-in inside the browser which poses a problem becouse the excel has links to pdf file that obscure the plug-in. Tag: To work with two data bases in asp Tag: 314603
  - 6
    - 100% height of a div inside a TD This is a multi-part message in MIME format. ------=_NextPart_000_0080_01C5ABC5.EFAC9860 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable I've got the problem described in the table above. I've put a div red with some text inside a TD, but its height is less = than 100% of TD height as you can see. I've defined the following styles: div.test { background-color:red; height:100%; width: 100%; }=20 table.test { border: 1px solid #CCCCCC; background-color:yellow; }=20 td.test { border: 1px solid #CCCCCC; } does anyone know a solution ? Please help me. Regards to all 2 2b 1=20 4 5=20 7 8=20 ------=_NextPart_000_0080_01C5ABC5.EFAC9860 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"> <HTML><HEAD> <META http-equiv=3DContent-Type content=3D"text/html; = charset=3Diso-8859-1"> <META content=3D"MSHTML 6.00.2800.1515" name=3DGENERATOR> <STYLE></STYLE> </HEAD> <BODY><FONT face=3DArial><FONT size=3D2> <DIV> <STYLE> div.test { background-color:red; height:100%; width: 100%; } =09 span.test { background-color:blue; height:100%; width:100%; }=09 </STYLE>  I've got the problem described in the table above.</DIV> <DIV> </DIV> <DIV>I've put a div red with some text inside a TD, but its height is = less than=20 100% of TD height as you can see.</DIV> <DIV> </DIV> <DIV>I've defined the following styles:</DIV> <DIV> </DIV> <DIV>div.test { background-color:red; height:100%; width: 100%; } </DIV> <DIV>table.test { border: 1px solid #CCCCCC; background-color:yellow; } = </DIV> <DIV>td.test { border: 1px solid #CCCCCC; }</DIV> <DIV> </DIV> <DIV>does anyone know a solution ?</DIV> <DIV> </DIV> <DIV>Please help me.</DIV> <DIV> </DIV> <DIV>Regards to all</DIV> <DIV> </DIV> <DIV> <STYLE> div.test { background-color:red; height:100%; width: 100%; } =09 span.test { background-color:blue; height:100%; width:100%; } table.test { border: 1px solid #CCCCCC; background-color:yellow; } td.test { border: 1px solid #CCCCCC; } </STYLE>  =20 <STYLE> div.test { background-color:red; height:100%; width: 100%; } =09 span.test { background-color:blue; height:100%; width:100%; } table.test { border: 1px solid #CCCCCC; background-color:yellow; } td.test { border: 1px solid #CCCCCC; } </STYLE> <TABLE class=3Dtest id=3DTable1 cellSpacing=3D0 cellPadding=3D0 = width=3D300 border=3D0> <TBODY> <TR> <TD class=3Dtest>2<BR>2b</TD> <TD class=3Dtest> <DIV class=3Dtest>1</DIV></TD></TR> <TR> <TD class=3Dtest>4</TD> <TD class=3Dtest>5</TD></TR> <TR> <TD class=3Dtest>7</TD> <TD = class=3Dtest>8</TD></TR></TBODY></TABLE></DIV></FONT></FONT></BODY></HTML= > ------=_NextPart_000_0080_01C5ABC5.EFAC9860-- Tag: To work with two data bases in asp Tag: 314602
  - 7
    - asp component error Hi I am having a problem with a com object on WinXP Pro. It is properly registered, but gives me the following error: Server object error 'ASP 0177 : 800401f3' Server.CreateObject Failed /code/cgi-sec/upload.asp, line 3 Invalid class string I do not have windows firewall active and it does the same thing with firewall/virus/spyware software disabled. It runs fine on my Win2K Pro desktop. The MS Knowledgebase entries are no help. Thanks fo all help, Bill Tag: To work with two data bases in asp Tag: 314601
  - 8
    - Functions pass by ref or by value? I have a function called GetRS which takes in a SQL string and returns a recordset object. Does this mean that a copy of the recordset is returned or is it passed by reference? Obviously this could have a large impact on performance for large recordsets. Tag: To work with two data bases in asp Tag: 314596
  - 9
    - ASP does not work We have a new installation of Win XP Pro, SP2 with IIS 5.1. None of the ASP pages will function - they just display ALL the code on the page, including code between script tags. .asp is listed in Application Mappings for the Default Web Site properties. Seems like I'm missing something obvious...??? Tag: To work with two data bases in asp Tag: 314591
  - 10
    - Best ASP 3.0 Editor? This is a multi-part message in MIME format. ------=_NextPart_000_000A_01C5AA56.CF8386E0 Content-Type: text/plain; charset="Windows-1252" Content-Transfer-Encoding: quoted-printable I'm currently using Dreamweaver MX as my editor but continually have = problems with it. Any suggestion for a "lighter" weight editor for 3.0? Kev ------=_NextPart_000_000A_01C5AA56.CF8386E0 Content-Type: text/html; charset="Windows-1252" Content-Transfer-Encoding: quoted-printable <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"> <HTML><HEAD> <META http-equiv=3DContent-Type content=3D"text/html; = charset=3Dwindows-1252"> <META content=3D"MSHTML 6.00.2800.1515" name=3DGENERATOR> <STYLE></STYLE> </HEAD> <BODY bgColor=3D#ffffff> <DIV><FONT face=3DArial size=3D2>I'm currently using Dreamweaver MX as = my editor but=20 continually have problems with it.</FONT></DIV> <DIV><FONT face=3DArial size=3D2></FONT> </DIV> <DIV><FONT face=3DArial size=3D2>Any suggestion for a "lighter" weight = editor for=20 3.0?</FONT></DIV> <DIV><FONT face=3DArial size=3D2></FONT> </DIV> <DIV><FONT face=3DArial size=3D2>Kev</FONT></DIV></BODY></HTML> ------=_NextPart_000_000A_01C5AA56.CF8386E0-- Tag: To work with two data bases in asp Tag: 314588
  - 11
    - Displaying carriage returns in a memo field Can someone please help with a suggestion as to how I can keep the formatting (carriage returns) that the user enters into a memo field and then display that later. I figured I might be able to use: 'replace carriage returns with BRs comment=Replace(comment, chr(13), "<br>") but obviously net.! The <pre> tag doesn't sem to help either as the embedded return is lost by the time you get past Request.Form...... thanks .les. Tag: To work with two data bases in asp Tag: 314584
  - 12
    - Date Question Hi all, I need a script that tells the user what the date is for monday and what the date is for friday for the current week based on the current day. Any help? Tag: To work with two data bases in asp Tag: 314580
  - 13
    - User Account Security Hi I'm trying to design a web application where people can create user Ids and passwords while signing up and then use that information to login to an account. (I know, very basic). I just can't get my mind around how to make this system most secure. the user id and password is verified at the time of logging in and at that point, I would like to create something like a session key before openning the new page. I basically don't want to start the new page by passing regular parameters through the URL because that's very easy to manipulate and break. Can someone give me some information about creating a secure system like this and/or forward me some useful sources?? btw.. I'm using, IIS as my server, ASP.Net and VB.Net. Thanks Farsad Tag: To work with two data bases in asp Tag: 314579
  - 14
    - MSXML posting SOAP message with Client Certificate I get the following error, I've seen many news forum with similar issue but never a concrete solution. anyone have an idea what could be causing this not to work? msxml4.dll (0x80072F0C) A certificate is required to complete client authentication Here's the code: strPostToURL = "https://cert.here.com/SOAP/" strCert = "cert.here.com" strRequest = server.MapPath("/xml/Sample_XML.xml") set objXMLDocument = CreateObject("MSXML2.DOMDocument.4.0") objXMLDocument.async = false objXMLDocument.load(strRequest) set objSrvHTTP = CreateObject("MSXML2.ServerXMLHTTP.4.0") objSrvHTTP.setOption 3, strCert objSrvHTTP.open "POST", strPostToURL, false objSrvHTTP.setRequestHeader "content-Type","text/xml" objSrvHTTP.send objXMLDocument <-------------------- Error occurs here Response.Write objSrvHTTP.responseText Set objSrvHTTP = Nothing Set objXMLDocument = Nothing Response.End Resources I've looked up and followed that didn't help: http://support.microsoft.com/default.aspx?scid=KB;en-us;q290761 http://support.microsoft.com/default.aspx?scid=kb;EN-US;q294266 http://support.microsoft.com/default.aspx?scid=kb;EN-US;q301429 http://support.microsoft.com/kb/289481/ http://support.microsoft.com/kb/302080/EN-US/ Tag: To work with two data bases in asp Tag: 314578
  - 15
    - Posting Data From .aspx to WorldPay Hi, I am writing a script that requires two actions performed on the same page; 1) upload pictures and store them on the server & 2) Send all of the variables from the WebForm to the WorldPay servers via the POST method. I am aware of the Server.Transfer and Response.Redirect methods but neither of these will do what I want. Are there any soluitions out there in C# that I can used to do this easily (running out of time on this project!)? Thanks for your help. Tag: To work with two data bases in asp Tag: 314577
  - 16
    - Using ScanLine I'm trying to create an asp page for Scanline from Foundstone (http://www.foundstone.com/index.htm?subnav=resources/navigation.htm&subcontent=/resources/proddesc/scanline.htm) with the asp below. (for our network monitoring site) sl.exe starts on the web server processor goes to 50% but just hangs there. The asp page then eventually times out. (I have to kill the sl.exe process on the server) Any ideas where I'm going wrong.... [-------------code---------------] Dim wshShell Dim oResult Set wshShell = CreateObject("WScript.Shell") Set oResult = wshShell.Exec("sl -nsr "&startaddress&"-"&endaddress) Do Until oResult.StdOut.AtEndOfStream oline=oResult.StdOut.Readline&"<br>" response.write oline Loop Set oResult = Nothing Set wshShell=Nothing [-------------code---------------] Many Thanks Tag: To work with two data bases in asp Tag: 314574
  - 17
    - how do I upload files to server? Hi, I need to allow a user to upload images to my website. I can't use an asp.net solution, just asp 3.0. Please advise. many thanks, NEIL Tag: To work with two data bases in asp Tag: 314572
  - 18
    - Odd "Invalid class string" error In an asp page in localhost I have this: Set x = Server.CreateObject("Scripting.Dictionary") And I get this error: Invalid class string If I omit Server like this: Set x = Server.CreateObject("Scripting.Dictionary") I get this error: ActiveX component can't create object: 'Scripting.Dictionary' In the same asp page this works fine: Set conn = Server.CreateObject("ADODB.Connection") In a Visual Basic application this works fine, too: Set x = CreateObject("Scripting.Dictionary") I reinstalled VB without success. Why do I get "Invalid class string" in the first case? Tag: To work with two data bases in asp Tag: 314568
  - 19
    - Date/Calendar query Hi all, I have an events database (Access) that contains 2 fields, StartDate and EndDate. The fields are set as Date/Time long date. The server is UK date format (dd/mm/yyyy) I have a small calendar that changes the day of the month to a link if an event exists for that day. I start off on day 1 of the month and use a loop through the month until the last day. Each run through the month queries the DB to see if an events exists with this sql: sql="SELECT ListingsID FROM tblEventsListings WHERE StartDate <= #" & DispDate & "# AND EndDate >= #" & DispDate & "#;" The DispDate is generated as part of the loop and is producing the date correctly. My problem is that if an event has the same start/finish day (single day event) then it gets missed. Also, an event that runs over a couple of months seems to randomly be displayed. eg, the calendar will show an event exists for 4 days, then 5 days of no event then events exist for the rest of the month. (The whole month should reflect an event on every day.) Sorry if this is a bit long winded! I'm stumped! Is there a better way to do this loop? Simon Tag: To work with two data bases in asp Tag: 314552
  - 20
    - runat=server! The following code snippet ---------------------------------------- <script language="VBScript" runat=server> <% a=1 %> </script> <%= a %> ---------------------------------------- throws the "Expected statement" error pointing to line no. 2. Why? Thanks, Arpan Tag: To work with two data bases in asp Tag: 314550
  - 21
    - server application error I use to always be able to view my local ASP pages at http://localhost, but a few days ago, it started giving me the following notice: =================== Server Application Error The server has encountered an error while loading an application during the processing of your request. Please refer to the event log for more detail information. Please contact the server administrator for assistance ================================================== I assume that something is up with IIS, but I don't know where to look. It happens on each and every ASP page I try to view. I haven't changed anything, haven't put up any Microsoft patches or anything. I suspect spyware. I run the usual anti-spyware/adware programs quite often, and catch one or two items just about every time. That dang Winfixer came in a couple weeks ago, and it was pretty nasty, but I digress. Anyone seen this error before? Disclosure: I posted this to the IS group, and received no answer yet, so this could be considered a cross-post Tag: To work with two data bases in asp Tag: 314547
  - 22
    - Request.BinaryRead()! Under what circumstances can Request.BinaryRead() be useful & when should it be used? Assume that the value of Request.Form("anyvalue") is "a" (without the quotes). The output of <% Response.Write(Request.BinaryRead(10)) %> is "??a" (again, without the quotes). How does ASP compute this value? Thanks, Arpan Tag: To work with two data bases in asp Tag: 314546
  - 23
    - Global.asa good practice? In my Global.asa file I have the following 2 subs for opening and closing my db connection: Sub OpenConn() Dim conn Set conn = Server.CreateObject("ADODB.Connection") conn.Open Application("ConnString") End Sub Sub CloseConn() conn.Close Set conn = nothing End Sub Then in my asp pages I simply call the subs when I need to open and close the db connection. Eg.: Dim Test Test = "Select XXX from SomeTable" OpenConn() Set rs = conn.Execute(Test) Do While Not rs.eof Response.Write(rs("XXX")) rs.MoveNext() Loop CloseConn() Is this good practice to have the 2 db subs in the Global.asa? Tag: To work with two data bases in asp Tag: 314544
  - 24
    - String Gets Truncated: VBScript End of String Character? Help, I am using an encryption routine that occasionally will encrypt a string using some extended ASCII characters (ASCII code > 128) I am wondering if there is a reserved character in VB that signifies the end of a string of characters. Here is what happens: I am encrypting certain fields before adding them to a SQL string. On occassion, the SQL string will simply end in the middle of the encrypted value. Example code sSQL = "EXEC SaveDetails " & _ " @iDetailID = " & iDetailID & ", " & _ " @sEncryptedText = '" & _ replace(EncryptText(sText),"'","''") & "', " & _ " @iOtherValue = 6" Normally Response.Write would print something like this: using Response.Write(Server.HTMLEncode(sSQL)): EXEC SaveDetails @iDetailID = 3, @sEncryptedText = 'aw@##@QASV@#AV (!', @iOtherValue = 6 Occasionally on certain inputs for sEncryptedText it will print: EXEC SaveDetails @iDetailID = 3, @sEncryptedText = '@#DFVIDXZI Is my encryption algorithm possible generating a reserved character that signifies the end of a string? Does such a character exist in VBscript? Any help would be appreciated. FYI, I'd rather not post my encryption routine. Please let me know if you feel it would be necessary. Tag: To work with two data bases in asp Tag: 314540
  - 25
    - Under High IE Security buttons don't work Hi All, I've got a set of asp pages used to register students into the ResNet database. Testing things out under different browser security settings I ran into a problem. The following buttons.... <INPUT type=button id="EditInfo" name="EditInfo" value="Edit Information" class="ButtonBlue" style="WIDTH: 150px" onclick="location.href='EditResNetInformation.asp'"> <INPUT type=button id="GoToGetMAC" name="GoToGetMAC" value="Continue" class="ButtonBlue" style="WIDTH: 150px" onclick="location.href='GetMACNow.asp'"> ....on page ReadySetGetMAC.asp (in text following) do not do anything in the onclick when Internet Explorer has High Internet zone Security. No error is given.....it looks as if the page has only been refreshed. GetMACNow.asp (also in text following) is 1 of the 2 pages which can be called from the ReadySetGetMAC.asp page. Right now it is nothing fancy at all. If I place http://<MyIPAddress>/WebRegTest/GetMACNow.asp directly into the address I can go to GetMACNow.asp as I can go directly to the 2nd page when directly addressed. I seem to be able to go between other asp pages in this project with nothing similar happening. Also the pages seem to work correctly when using Firefox or Netscape, but I'm not certain I've got them set to their highest security setting. So......why don't those buttons work, in particular (I guess), under IE's High Security settings and how do I get them to work under these settings? Thanks. gdr *******asp pages****** ******************begin code ReadySetGetMAC.asp************************ <%@ Language=VBScript %> <% OPTION EXPLICIT %>   <% 'On Error Resume Next Response.Buffer=true Response.ExpiresAbsolute = #January 1, 1990 00:00:01# Response.ExpiresAbsolute = Now() - 1 Response.AddHeader "pragma", "no-cache" Response.AddHeader "cache-control", "private, no-cache, must-revalidate" '------------------------------------------------------------------------------ Dim NewValID Dim cnMain Dim rstGetConnectionInfo Dim strStudentIDNumber Dim strLastName Dim strFirstName Dim strEMailAddress Dim strCellPhoneNumber Dim strRoomCode Dim strResidenceHall Dim strRoomNumber Dim strPortNumber Dim strConnectionDate Dim strConnectionSemester Dim strConnectionYear Dim strMACAddress Dim strOSVersion NewValID = Session("StuID") Set cnMain = Server.CreateObject("ADODB.Connection") Application("ResNet_ConnectionString") = "Provider=SQLOLEDB;" & _ "Data Source=MySQL;" & _ "Initial Catalog=MyDB;" & _ "User ID=IUSR_FAKE;" & _ "Password=*******;" & _ "ConnectionTimeout=15;" & _ "CommandTimeout=30;" & _ "CursorLocation=3;" & _ "Packet Size=4096;" & _ "Use Encryption for Data=False;" cnMain.Open Application("ResNet_ConnectionString") Set rstGetConnectionInfo = Server.CreateObject("ADODB.Recordset") cnMain.spGetOnlineStudentConnectionInformation NewValID, rstGetConnectionInfo If rstGetConnectionInfo.EOF <> True Then strStudentIDNumber = rstGetConnectionInfo(0) strLastName = rstGetConnectionInfo(1) strFirstName = rstGetConnectionInfo(2) strRoomCode = rstGetConnectionInfo(3) strResidenceHall = rstGetConnectionInfo(4) strRoomNumber = rstGetConnectionInfo(5) strPortNumber = rstGetConnectionInfo(6) strConnectionDate = rstGetConnectionInfo(7) strConnectionSemester = rstGetConnectionInfo(8) strConnectionYear = rstGetConnectionInfo(9) strMACAddress = rstGetConnectionInfo(10) strOSVersion = rstGetConnectionInfo(11) strCellPhoneNumber = rstGetConnectionInfo(12) strEMailAddress = rstGetConnectionInfo(13) Else 'there is no record of this student.....send 'em to apology page Session("StuID") = "" Response.Redirect ("ResLifeValidationFailure.htm") End If %> <HTML> <HEAD> <META NAME="GENERATOR" Content="Microsoft Visual Studio 6.0"> <title>Last Edit Get MAC Address Next</title> <link href="resnet.css" rel="stylesheet" type="text/css"> </HEAD> <BODY> <p align="center"><img src="ResNet_InetActivation.jpg" width="598" height="151"></p> <h3>Here is your information we have entered.</h3> <h5> <%=strConnectionSemester%> <%=strConnectionYear%> ResNet Registration<br> Date of Activation Request: <%=strConnectionDate%><br> <%=strFirstName%> <%=strLastName%>;  <%=strStudentIDNumber%><br> <%=strResidenceHall%>  <%=strRoomNumber%><br> Port Number: <%=strPortNumber%><br> Cell Phone Number: <%=strCellPhoneNumber%><br> E-mail Address: <%=strEMailAddress%><br> OS Version: <%=strOSVersion%><br> MAC Address: <%=strMACAddress%> </h5> <p><h3>If this NOT correct, you may edit your information<br> by clicking the Edit button below,<br> or you may call the Support Desk @ 6776. </h3></p> <h5> Please click the Continue button below to finish ResNet Internet Activation. </h5> <P align="center"><INPUT type=button id="EditInfo" name="EditInfo" value="Edit Information" class="ButtonBlue" style="WIDTH: 150px" onclick="location.href='EditResNetInformation.asp'">     <INPUT type=button id="GoToGetMAC" name="GoToGetMAC" value="Continue" class="ButtonBlue" style="WIDTH: 150px" onclick="location.href='GetMACNow.asp'"> </P> <h5>If you do not have Internet access within 24 hours,<br> please contact your RCC or the Support Desk at 6776.</h5> </BODY> </HTML> ******************end code ReadySetGetMAC.asp************************ ******************begin code GetMACNow.asp************************ <%@ Language=VBScript %> <% OPTION EXPLICIT %>   <% 'On Error Resume Next Response.Buffer=true Response.ExpiresAbsolute = #January 1, 1990 00:00:01# Response.ExpiresAbsolute = Now() - 1 Response.AddHeader "pragma", "no-cache" Response.AddHeader "cache-control", "private, no-cache, must-revalidate" '------------------------------------------------------------------------------ Dim NewValID Dim cnMain NewValID = Session("StuID") 'connection not used yet 'Set cnMain = Server.CreateObject("ADODB.Connection") 'Application("ResNet_ConnectionString") = "Provider=SQLOLEDB;" & _ ' "Data Source=MySQL;" & _ ' "Initial Catalog=MyDB;" & _ ' "User ID=IUSR_FAKE;" & _ ' "Password=*******;" & _ ' "ConnectionTimeout=15;" & _ ' "CommandTimeout=30;" & _ ' "CursorLocation=3;" & _ ' "Packet Size=4096;" & _ ' "Use Encryption for Data=False;" 'cnMain.Open Application("ResNet_ConnectionString") 'connection not used yet %> <html> <head> <meta NAME="GENERATOR" Content="Microsoft Visual Studio 6.0"> <title>MAC Address and OS Version</title> <link href="resnet.css" rel="stylesheet" type="text/css"> </head> <body> <p align="center"><img src="ResNet_InetActivation.jpg" width="598" height="151"></p> <p> </p> <p align="center"><a href="GetMACHandler_test.asp">CLICK HERE</a></p> <p> </p> <h5>If you do not have Internet access within 24 hours,<br> please contact your RCC or the Support Desk at 6776. </h5> </body> </html> ******************end code GetMACNow.asp************************ -- Gary D. Rezek University Nerworking Systems and Services South Dakota State University Tag: To work with two data bases in asp Tag: 314538

Is possible to have a connection to SQL server and another one conaxion to a
data base Access to process data among them
Thanks.

Top

Re: To work with two data bases in asp by Aaron

Aaron
Thu Sep 01 12:57:03 CDT 2005

> to process data among them

You were most vague about the most important piece.

Yes, it is possible to have multiple connection strings in ASP. You can
connect to an Access and a SQL Server database, 8 different SQL Server
databases, or 2 MySQL, 4 Access and 3 FoxPro databases.

The more important part is how you want to "process data among them" because
that could have just as many meanings as there are possible database
combinations.

Typically, you would connect to one data source, and use linked tables
(Access -> SQL Server) or linked servers (SQL Server -> Access). It all
depends on exactly what you are doing. Is one database read-only from the
web app, or do they have to share data and update both sources, or ...?

Top