Viewing 15 posts - 2,896 through 2,910 (of 5,394 total)
Koen Verbeeck (7/29/2011)
I have found the issue.
It's a combination of two things:
First of all, the driver needs to be executed out of process. So...
July 29, 2011 at 4:15 am
I feel your pain...
(NetMon + ProcMon + EventViewer + Policy Editor + Any log files you can find) is the only tools you have.
Good luck!
July 28, 2011 at 7:18 am
I have found that SSIS ignores the settings in the UDL file and requires entering ALL the connection parameters in the connection properties.
SQL Server has always been more forgiving and...
July 28, 2011 at 6:49 am
Looks like a TCP/IP connection error.
Can you trace the process with NetMon? You can add a filter for source or destination = your AS/400 machine.
If you don't see packets...
July 28, 2011 at 6:43 am
OK, thanks. So I guess you will have to stick to OLEDB (which is a good thing IMHO).
With "Windows Security" I mean the permissions to assign to the windows user...
July 28, 2011 at 1:43 am
Koen Verbeeck (7/28/2011)
However, I can rule out A through D, as I can create a successful connection and extract data from it in SSIS.
So it is...
July 28, 2011 at 1:27 am
Based on personal experience: don't use ODBC (too slow and unreliable) and go for OLEDB.
It could be something wrong in:
A) The iSeries package (have you checked that with your QSECOFR?)
B)...
July 28, 2011 at 12:53 am
More details on my blog: http://wp.me/p1gueM-4c
July 27, 2011 at 3:22 pm
Ninja's_RGR'us (7/27/2011)
Jim Murphy (7/27/2011)
Useless post just to make 500.I hate when people do this.
Do you realize I could do that every 2-3 weeks :blink:?
Unfair. This is pure bragging.
Oh, and this...
July 27, 2011 at 1:58 pm
My dear friends, I finally have the definitive answer to the question that originated this thread.
NO!
They're not getting worse! This is what they kept getting until today. Now they can...
July 27, 2011 at 8:42 am
I suspect that you're a bit confused. Let's see all your points one at a time:
I can browse to the MDF/LDF file
Fine. However, there's no need for this.
but cannot open...
July 27, 2011 at 8:30 am
Model is the template for a new database, so, if you don't like it in full recovery, change it to simple recovery.
No harm: it's your choice.
July 27, 2011 at 8:18 am
You can do it with a trigger or with a CHECK constraint WITH NOCHECK.
Be aware that:
1) CHECK constraints can't read data from another table directly, but have to use a...
July 27, 2011 at 4:06 am
GilaMonster (7/26/2011)
Grant Fritchey (7/26/2011)
Gianluca Sartori (7/26/2011)
Grant Fritchey (7/26/2011)
July 26, 2011 at 6:09 am
Grant Fritchey (7/26/2011)
July 26, 2011 at 5:59 am
Viewing 15 posts - 2,896 through 2,910 (of 5,394 total)