Hello everybody,
I'm not all that familiar with backing up and restoring databases on SQL 2005 and I have a question. First, let me give you a little insight into how we're setup and what we want to do.
We have two servers--live & test. Currently, we perform a full back of the live server each night and restore it to the test server. This all runs automatically. It's been requested that it would be nice to have the...
cryogeneric
Last Activity: Dec 14 '09, 07:02 PM
Joined: Jan 11 '08
Location:
-
Question about differential restores (SQL Server 2005)
-
SQL Server 2005 - Open SQL file with Query Analyzer behavior
Hello!
My company recently upgraded to SQL Server 2005 and I'm still getting used to the new interface. One thing I've noticed:
When I'm connected to a specific database and I want to run a script, I click New Query, Open File then select the script. SQL Server 2005 brings up the "Connect to Database Engine" dialog again and the resets the database to master.
This is a bit annoying, especially... -
Hi iam_clint,
That's exactly how I solved it--more or less. I used a third party Active X component to merge the PDF's into one file then open the merged file and allowed the users to print it.
Thanks! -
Printing Multiple PDF's at the same time using ASP
Hello everyone,
I've developed an ASP classic program that allows users to view PDF reports. Currently, users can click on a PDF and print it, however, I need to find a way to allow them to select multiple PDF's and print them at the same time. I can can handle the multiple selection part, but I need ideas how ASP can interact with Adobe Reader and print multiple files at once.
Can anyone please help?
... -
There has to be something consistent about the descriptions or hierarchy structures to do what you need to do.
There isn't a way for SQL to know what "root" description you're attempting to group by. Without something unique to group these structures with, you're going to be limited in what results you can return.
Is there something unique within each structure? Or is there something consistent with the descriptions...Leave a comment:
-
Well, if you're specifically trying to bring back the row count for records containing the description "CDR VER AP-CS-UPS SANLUCA" ?
That would be fairly simple, just:
Since the descriptions are different on every row, you won't be able to bring back a single row if you are attempting to include the...Code:select count(*) from table where DESCRIPTION like "CDR VER AP-CS-UPS SANLUCA%"
Leave a comment:
-
What do you mean by Oracle HTTP?
What operating system are you running this on?
If it's Windows Server 2003, you need to make sure that ASP is "Allowed" to run. Do this by clicking "Web Service Extensions" in the IIS Manager, then select Active Server Pages and click the "Allow" button.Leave a comment:
-
FYI, if the 60 and 61 aren't variables, there's no need to place them outside of your SQL string.
You could simply say:
Or, even more simple: (especially if you have a lot of values to include)Code:Where CategoryID <> 60 and CategoryID <> 61
...Code:Where CategoryID not in (60,61)
Leave a comment:
-
Thanks.
That's good to know about the FileExists method. I suspect this solution could be used to get around that problem as well. Of course, IIS needs to be setup on the remote server.
In fact, now that I think about... I wonder if you could "include" a script on the remote server which has subs that call FileExists or LoadFromFile... hmmm
I might have to test that someday. :)Leave a comment:
-
Solved!
While for whatever reason I'm unable to run LoadFromFile and read from a folder on a different computer, I was able to solve the problem by placing the script that calls the LoadFromFile method on the Network computer and calling THE SCRIPT using the IP address.
I guess LoadFromFile is unable to read from a folder that is not physically on the computer that the script is called from. Seems weird, but trust me,...Leave a comment:
-
Hi danp129, Thanks so much for the response.
The web server will vpn to a computer behind the firewall that contains the files. So by "servername ", I'm assuming IP address will be fine.
In other words: \\100.100.100.1 \pdf\somefile.p df
Theoretically, I don't see any reason why this shouldn't work. The path shouldn't matter if the server can read from the folder (which it can). But it doesn't work....Leave a comment:
-
LoadFromFile using a mapped network drive
Hello everyone
I'm creating an ASP classic application that let's users download and save PDF files without having to bring them up in the browser. I have successfully used the LoadFromFile method to perform this feat but not in the manner in which I ultimately want things to be.
Currently the PDF's sit on the server itself, but I would like for these to be on a different computer. When I try to set up this scenario,... -
The print() function, PDF's, ASP, and other exciting things, etc...
Hi,
I'm writing an ASP application that can display PDF files in a frame.
The user can save or download the PDF, but I need to know when they do this so I can add an activity record to my database.
My first thought was to disable the PDF tool bar and allow saving and printing from buttons that I CREATE. This would allow me to trap the action. I was able to do this for saving using the LoadFromFile method... -
Thank you for the response! I think my test wouldn't work regardless (since I need to response.write the ouput... I'm thinking unix), but I set all of the permissions for the batch file and it still didn't work. I found this snippit from another site and now it seems that the batch file runs.
...Code:Permissions is the most likely cause. If you open a command prompt on your 2003 machine and enter "cacls %comspec%"
Leave a comment:
-
Can't run a batch file from ASP
Hello everyone, :)
I can't seem to get around some annoying permission issues when I attempt to run a quick test where I call a batch file from my ASP script.
I'm running this on my XP Pro machine with IIS 5.1
Here is my test script (batchtest.asp) :
...Code:<html> <body> <h1> <% Dim wshell Set wshell = Server.CreateObject("WScript.Shell")
No activity results to display
Leave a comment: