Search results for query: *

So, I've got a head scratcher and if anyone has any ideas, I'd muchly appreciate it. We have an internal web app that (amongst other things) serves some pdf reports. These are stored on the network on a different machine. I managed to have them working for months, and in the past week...

I'm not sure what I changed, but it started working... It had failed on two differet FTP servers, but now it works on both... :S I didn't restart or close anything, so I'm really not sure what changed... Maybe a typo somewhere, but I tried entereing the information several times, so it's not...

I'm having a problem getting SSIS to connect to an FTP site via the FTP Connection Manager and the FTP Task. I get a rather unhelpful error of "Connection can not be established. Server name, port number, or credentials may be invalid." I've confirmed my server name, port number and...

Awesome! Worked great! I knew there had to be an easyish way to do it. Thanks!

I have an Access 2007 application that does a search and returns a file location. I want to be able to click a link or push a button and open the location, which contains a series of PDFs. This command works great on my computer - Windows XP Shell "C:\WINDOWS\explorer.exe """ & FileFolderLoc...

I'm trying to integrate some data into a new system. The existing system is a Firebird database and I can't move away from it. So, I'm trying to create a linked server to this Firebird database. I created one on my local machine (XP pro, mssql 2008 express) and it works great! Moved to my...

Thanks, that's a huge help!

I'm trying to pass a formatted array to a Stored Procedure and am having problems with the SQL. I know I can use dynamic SQL, but was hoping to avoid using it. Sample of what I'm trying, it works as dynamic, but not this way: declare @Param nvarchar(200), @cmd nvarchar(2000) set...

Thanks! Importing the data/forms/stuff to a new file looked like it did it! I'm moving the data now. For the next noob... The function to import is now under External Data->import->Access.

Yes... That's when the security warning pops up. If I don't hold down the shift key, it goes straight to run mode, same as "trusting" the macro.

Sorry it took so long to get back, I'm working on a few projects at once! I got a different copy of the database that's been upgraded to 2007 and that doesn't have this exact problem. But of course, it has a different one. We want to migrate the data to MSSQL server and keep the access forms...

I've seen other posts on the internet with the same issue, but no solution. So it is a curious problem! Well, I watched processes and didn't see anything overly weird. I tried an assortment of destroying sessions, closing sessions and similar, thinking that maybe there was an existing session...

here's the php_info section. everything looked ok to me. session Session Support enabled Registered save handlers files user sqlite Registered serializer handlers php php_binary Directive Local Value Master Value session.auto_start Off Off session.bug_compat_42 On On...

I have a newly built webserver using Ubuntu Linux and php 5.2.10. Everything seems to work well, but the session_start is painfully slow. It works, but seems to take 2 minutes. I tested on IE and FF and on a couple computers with the same results. I've search the internet and come up with...

I am unable to find one. Is there any way to find out if I SHOULD have one? It wouldn't surprise me if it got 'misplaced'. If there isn't a 'nice' way to do it, is there a program someone can recomend to 'fix' it? I'm starting to think about getting a good Access form to VB project...

Yep. I've got a copy on my local machine. I even made sure no one was in it when I copied it. I'm a little paranoid about messing up their production stuff.

I've recently inherited an Access Database. It has become more popular than originally expected and they are running into several errors. So I'm looking to migrate the data into MSSQL server and keep the Access front end, but make a few minor adjustments as requested. However, I can't get it...

Damn it! I KNOW when I was testing yesterday, I was checking to ensure it didn't get inserted into the table and just wan't printing. Must have checked the table 20 different times! I really did and it really wasn't inserting. It's the only reason I posted... Now it's actually inserting...

Sorry it took so long... Couldn't get to my code until now. here's the stored procedure. It's pretty straight forward... ALTER PROCEDURE [dbo].[ScaleSchedule_Contractor_Prep] -- Add the parameters for the stored procedure here @currentdate as datetime AS BEGIN -- SET NOCOUNT ON added to...

I have a table with column entry for every hour (TableA) and I'm converting it to a table with a row for every hour (TableB). I'm creating a stored procedure to help, beacuse every day there will be a new entry in TableA to convert to the TableB. I've chosen to do it with 24 insert statements...