Every so often my database log files fill up and i have to truncate the file.
DBCC SHRINKDATABASE (database_name_here, TRUNCATEONLY)
GO
BACKUP LOG [database_name_here]
WITH NO_LOG
Any idea how I could run this? From an asp page...?
I am in the process of transferring several ASP 3.0 websites from NT 4.0 to Windows Server 2003. The latest issue I am having is in converting CDONTS code to CDO code. My email sends fine, but is showing up truncated (approx. 1000 characters). The email is being sent in HTML format with the body string being a long string of concatenated strings. In NT 4.0 this is not a problem, but it appears to be in Win 2003. Have any of you come up against this same issue and if so what did you do to rectify it?
View Replies View RelatedI've been examining IIS logs downloaded from my web host's server, and I noticed that entried that they should have been created by me going to my own site minutes before are not there. In fact, it seems the logs were way off timewise.
How does IIS write to logs? Does it keep a cache and then dumps it once in a while to the logs, or writes right away (the latter doesn't seem the case). I am concerned by this an other anomalies in which my hosting service seems involved.
I have five forms in my website, what I'm trying to accomplish is to track the users history. For an example if the user save their information on the first page and exit the system; Whenever that user logs back in I want them to be where they left off. I hope I'm clear on what I need help with. Does anyone know how to accomplish this task?
P.s I'm using Deamweaver to create my page.
I have a shopping cart that logs the datetime when a user logs in...
I want to run reports to see who all has been on in the last 90 minutes (or whatever my script specifies)
The problem is that I cant get the select statement down...
I would think it to be something like:
SELECT CompanyName, LastLoggedIn from LoginDB where LastLoggedIn > (LastLoggedIn -90m)
And obviosuly that doesnt work as the datetime field date is in the format:
1/21/2007 2:20:00 PM
I am thinking of creating a custom 404 page which does a server.transfer to a variety of different pages. My question is what shows up in the log, which the web statistics are based on?
1. The non existent page, which is requested?
2. The custom 404 page?
3. The page it gets transfered to?
how can I make a query in windows 2000 event viewer logs by asp?
View Replies View Relatedi need to parse smtp logs to check the delivery status. from previous experience with smtp logs, i was under the impression that the log file followed a very specific format:
EHLO
MAIL
RCPT
BDAT
QUIT
in this case, however, i've got a log indicating commands being issued like this:
EHLO
EHLO
MAIL
MAIL
RCPT
RCPT
BDAT
BDAT
QUIT
QUIT
i have a separate list from a database of people i attempted to send emails to and need to try to look at each line in the smtp logs until i find a matching email address, then continue to read until i find a line that includes the string "+Queued+mail+for+delivery" or any of the other strings indicating the delivery status. however, given the odd sequence in which the mail commands are being issued, i don't seem to have any way of knowing if the delivery status notification line i'm reading really reflects delivery status info about the email address in question or if it's referring to one of the other delivery requests issued with another one of the EHLO commands. i've tried looking to see if there's something unique about the delivery status line to see if it's in some way associated with the RCPT line, but don't see any patterns:
2005-10-05 11:12:30 10.1.208.103 OutboundConnectionCommand SMTPSVC1 ACME -
25 RCPT - TO:<person@acme2.com> 0 0 4 0 50 - - ......
I have my system set-up, where by when a user accesses the cms, a time stamp is added to the database. So we can keep check of when people accessed the system.
The added benefit of my addition, is that a session timeout is usable based on the inputted timestamp the user logged in. I added this functionaility because the system could be idle for some time and if so set the session to equal nothing or similar.
However what would be a nice feature of the cms is the display of the current user.
Below is code I have inputted to give some idea of what I am doing
Session("ADID") = objRS("adminID")
objConn.Execute("UPDATE tblAdmin SET adminLastLogged=now() WHERE adminID=" & Session("ADID"))
Session.Timeout = 30 ' 30 = Minutes
SO does anyone know how I can retireve the adminUsername based on the session used when loggin into the system.
I have an application i am creating that will require the ability for a remote site to access some of the abilities of the program.
For example: Program will have a product manager and the webmaster will need to be able to place the product information on his/her remote site.
another funtion: the remote site will need to pass variable data back and forth between the application hosting server and webmasters site.
I have thought about using cookies or XML but cookies are kinda limited in respect to what i need and XML requires an XML enabled browser like IE 5+.
Am I missing something? any ideas on how i can accomplish this
I was wondering if it's possible to get "the name" istead of ip from a user that runs a asp page?
cust10354-344.someisp.com istead of 231.13.434.23
I'm trying to get remote ip address and local ip address
of the user (i.e. machine name) but i couldnt find out it.
however i can see the public remote ip address.here is
the little code that i have written..
<%
For Each Item in Request.ServerVariables %>
<tr>
<td><%= Item %></td>
<td><%=Request.ServerVariables(Item)%></td>
</tr>
<%
Next
%>
If I have the line adoCon.Open "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" & Server.MapPath("produkten.mdb") to access an Access Database local to the site, is it possible to have something like adoCon.Open "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=http://www.somesite.com/somedb.mdb" To allow the site to connect to a db on another site/server which also belong to me?
View Replies View RelatedI use the RemoteScripting with the rsproxy.class within my asp pages.
I don't have problems except, when the Java console is not active in IE.
Is there a way to detect from asp, if the java console is active or not ?
or, how to do remote scripting without the rsproxy ?
i want upload a txt file to remote server
View Replies View Relatedi have just completed the charity web site www.leahpattison.org (please give
your support) and i have the news system that they can update hosted on
shared hosting on a sub domain of one of our core domains leah.neue.co.uk on
the main sites home page i have a scrolling news ticker in an iframe that
calls a page from the 'news server' and whenever you click on a news item it
pushes you onto the news server to deliver the pagesonly it keepstiming out.
anyone have any suggestions? the host say 'because we host many asp sites we
have a lot of traffic hitting msaccess databases, some of which do not
properly close their connections' basically tough luck. is there any way i
can make this site more efficient and make the news system work?
I work with dreamweaver 8. I use the tools provided within dw to create my asp features etc. I downloaded a news script to save time since its a very low budget site, but I need to customise how its displayed.
The news script connects using a Server.MapPath connection. I would like to be able to work locally using a dsn. dsn=nwnews; but I would like to be able to change that connection to work on the remote server for testing etc.
This is Dreamweavers Connection file: Code:
I have a Web application that uses Remote Scripting to provide dynamic data to a web page.I am testing the application in Internet Explorer 6 SP1 running on Windows XP Professional.
When I use the Microsoft JVM,the application works without any problems.However, as a result of future withdrawal of support of the Microsoft JVM as a result of the settlement with Sun, I need to ensure that the application works okay with the Sun Java plug-in for Internet Explorer.
This component is no longer available,and clicking on the OK button only reiterates this message. When I click on the Cancel button instead, the Remote Scripting functionality fails to work.Is it possible for Remote Scripting to be configured to work with an alternative JVM, such as the Sun Java Plug-In, or is it entirely dependent on the Microsoft version?
IM trying to put up a small database in my website and having my visitors to search it. A record of this database will have four fields: The first one will hold a number, the second one a Street name, the third a City, and the fourth a picture. The database will be searched either by the number or by the city.
View Replies View RelatedWe're wanting to upload files and save them to a different server on the network (Windows 2000) from the web server. The upload works fine but we cannot copy files, using the File System Object, to this other server folder.
what is required in terms of mapping and registering the folder so that the web server can link to it?
I just want to delete a file in a server by FSO. My code is:
Set objFSOD = Server.CreateObject("Scripting.FileSystemObject")
objFSOD.DeleteFile Server.MapPath(".") + "Greetings" + sFileName1,
True
Set objFSOD = Nothing
When I check the code locally, everything is fine. I have two remote servers. When I check the code in each servers, one is fine and other is thrown a error. But the error msg is in Korean language while I'm not korean, that is why I can't read the error
msg. What would be the error msg about? The sFileName1 was always correct every time I checked.
Currently we have a site that allows users to listen to mp3 files. It is creating bandwidth issues. So we want to move the mp3 files to an ISP that caps bandwidth usage. Ours is currently burstable.
Now I am able to do the following:
Set fs = CreateObject("Scripting.FileSystemObject")
If fs.fileExists(music_file) Then
'show music file
Else
'do not show a link for file
End If
set fs = nothing
Is it possible to do the same thing, but on a remote server?
How do I connect to a remote Access DB from my desktop? I have a MS Access DB online adn wish to hook up to it from my desktop absed DB?
View Replies View RelatedI have a access database on my server which my users can download it from my website. I have update.asp file which will update the database on the client. So say if there are 2 users each will download a copy of the database on to their machines.
When they run the update.asp file, the information will go to their respectively database(the one's on their machine). The architecture of the DB's remains the same but each client will have his only data. Is this possible? IF yes then, why do I get this error...
Microsoft JET Database Engineerror '80004005'Could not find file C:Test.mdb.
How to include remote file in an asp file? Anybody woh know about it.
View Replies View RelatedLocaly along with VS2005 when hitting ctrl+f5 the asp application server get's launched, and the whole site works fine, now on my windows 2003 server i installed IIS, it also has apache running and that works fine but the IIS part, i cant get it to work.... i have my inetpub filder on c which has a www folder but when i copy my project to there it tells me it's unable to process the page (aspx), can somebody help me out here please.....
I did the configuration and rule statements in the server manager which now displays ASP.net working and active, but it does NOT work at all....
I was susseesful in mapping remote machine with vbscript. Now I am building the same tool with ASP .I am using the same code but its not working. Below is the portion where I am mapping the drive: Code:
View Replies View RelatedI have a shell script that needs to be executed on a unix machine on our network and text output needs to be retrieved How can I make a asp.net page do it ?
is there a way to batch execute the command that I execute in the command prompt and just retrieve the outoput.
Here is what I am manually executing currently from the dos command prompt
Step 1. telnet <unixmachine>
Step 2. login <login name>
Step3. I Provide the password
Step4. once logged in to the machine I Provide the <shell script command>
The results of the script get displayed on my command window. I copy and paste the result
can the above be done through asp/asp.net page
I have asp page needs to access remote database, I got error"The Microsoft Jet database engine cannot open the file 'Unknown'. It is already opened exclusively by another user, or you need permission to view its data. "
Could anyone show me the steps to configure permission (I tried creating IUSER_DBMACHINE local account on the database box, give this account full permission on the database folder, doesn't work.
I have a form where I want to be able to validate a field against a DB
*before* the form has been submitted.
After doing a bit of homework, it seems there are two general approaches:
1) Remote Scripting [using RSExecute/RSGetASPObject]
2) Using XMLHTTP/XMLDOM objects
I have no experience with either, so I though I'd see what my peers are
using.
If ASP can read remote file like php does.I am trying to read this weather forecast page, and only output certain line from it.I only know how to read a local file using server.mapPath()
View Replies View Related1. I wonder, why do I need to add the following lines when sending forms through mail, using CDO component?
2. If I remove these lines and the form is still submitted as it should, and I get the mail as a result as it should, does it mean I do not need these lines?
3. In other words - How do I know if an SMTP service is installed on the local server, and not in another network (besides asking the admin)? Code:
Whenever i put in a remote location to server.map, it errors about an invalid character (the colon is what gets it. is there any way to do xml parsing remotely?
View Replies View Related