Viewing 15 posts - 196 through 210 (of 264 total)
the ssis error said that the odbc link did not support the required odbc level of behaviour or some such words to that effect.
The source of the error was...
Ben
^ Thats me!
----------------------------------------
01010111011010000110000101110100 01100001 0110001101101111011011010111000001101100011001010111010001100101 01110100011010010110110101100101 011101110110000101110011011101000110010101110010
----------------------------------------
May 19, 2011 at 7:49 am
this process has been in place for - oh, i dont know - 5 years now.
we pull over 8GB every night.
thats since it was trimmed down - used to be...
Ben
^ Thats me!
----------------------------------------
01010111011010000110000101110100 01100001 0110001101101111011011010111000001101100011001010111010001100101 01110100011010010110110101100101 011101110110000101110011011101000110010101110010
----------------------------------------
May 19, 2011 at 7:40 am
Yea there are options to consider.
Unfortunately unloading data to flat files is a no go flat files are all pipe delimited, not text qualified and users type pipes in free...
Ben
^ Thats me!
----------------------------------------
01010111011010000110000101110100 01100001 0110001101101111011011010111000001101100011001010111010001100101 01110100011010010110110101100101 011101110110000101110011011101000110010101110010
----------------------------------------
May 19, 2011 at 7:12 am
alas I had feared this to be the case...
Unfortunately there IS NO newer driver! the version of informix is so old that IBM do not release a driver for it...
Ben
^ Thats me!
----------------------------------------
01010111011010000110000101110100 01100001 0110001101101111011011010111000001101100011001010111010001100101 01110100011010010110110101100101 011101110110000101110011011101000110010101110010
----------------------------------------
May 19, 2011 at 2:02 am
for info the same error comes up when trying to access as a linked server.
php odbc uses this DSN on this box without issue.
Ben
^ Thats me!
----------------------------------------
01010111011010000110000101110100 01100001 0110001101101111011011010111000001101100011001010111010001100101 01110100011010010110110101100101 011101110110000101110011011101000110010101110010
----------------------------------------
May 18, 2011 at 6:49 am
lol it's a program that will be run regularly as part of a big process. the fast execution time going forward is definitely worth 3 hours initial development costs. ;)...
Ben
^ Thats me!
----------------------------------------
01010111011010000110000101110100 01100001 0110001101101111011011010111000001101100011001010111010001100101 01110100011010010110110101100101 011101110110000101110011011101000110010101110010
----------------------------------------
May 11, 2011 at 6:17 am
heh heh about 4 hours I think it took me.
The idea behind it was the less steps that had to take place, the less could fall over when processing in...
Ben
^ Thats me!
----------------------------------------
01010111011010000110000101110100 01100001 0110001101101111011011010111000001101100011001010111010001100101 01110100011010010110110101100101 011101110110000101110011011101000110010101110010
----------------------------------------
May 11, 2011 at 1:58 am
That's the wierd thing, the IIS box has SQL2005 on it anyway - and has the sqlncli driver selected for this connection.
maybe it's to do with the 'max' setting.
who knows?!
I...
Ben
^ Thats me!
----------------------------------------
01010111011010000110000101110100 01100001 0110001101101111011011010111000001101100011001010111010001100101 01110100011010010110110101100101 011101110110000101110011011101000110010101110010
----------------------------------------
May 10, 2011 at 3:26 am
yep thats fixed it.
asp does not seem to like varchar(max) - I can only assume a colleague changed the table for some reason whilst I was on holiday!
appologies for the...
Ben
^ Thats me!
----------------------------------------
01010111011010000110000101110100 01100001 0110001101101111011011010111000001101100011001010111010001100101 01110100011010010110110101100101 011101110110000101110011011101000110010101110010
----------------------------------------
May 10, 2011 at 3:12 am
ah.
I've just seen one table has the wrong data types.
I'll play with that and see if it makes a difference...
Ben
^ Thats me!
----------------------------------------
01010111011010000110000101110100 01100001 0110001101101111011011010111000001101100011001010111010001100101 01110100011010010110110101100101 011101110110000101110011011101000110010101110010
----------------------------------------
May 10, 2011 at 3:09 am
Hi
Microsoft SQL Server 2005 - 9.00.4035.00 (Intel X86) Nov 24 2008 13:01:59 Copyright (c) 1988-2005 Microsoft Corporation Standard Edition on Windows NT 5.2 (Build...
Ben
^ Thats me!
----------------------------------------
01010111011010000110000101110100 01100001 0110001101101111011011010111000001101100011001010111010001100101 01110100011010010110110101100101 011101110110000101110011011101000110010101110010
----------------------------------------
May 10, 2011 at 3:08 am
simply force of habit.
There is a fair amount of missing or incomplete data in my database. Most of my jobs on this server use temporary tables and there are...
Ben
^ Thats me!
----------------------------------------
01010111011010000110000101110100 01100001 0110001101101111011011010111000001101100011001010111010001100101 01110100011010010110110101100101 011101110110000101110011011101000110010101110010
----------------------------------------
May 10, 2011 at 1:32 am
hmmm good point
That would have to be done like:
SELECT '"' + REPLACE(someMemoField, '"','') + '"' ...
Manually remove any quotes from the field then add them back in manually?
I dont...
Ben
^ Thats me!
----------------------------------------
01010111011010000110000101110100 01100001 0110001101101111011011010111000001101100011001010111010001100101 01110100011010010110110101100101 011101110110000101110011011101000110010101110010
----------------------------------------
May 9, 2011 at 3:23 am
Thanks guys,
Everything on this server is supposed to run sequentially, however, I ran this at the same time as another batch of stored procs were running - it would be...
Ben
^ Thats me!
----------------------------------------
01010111011010000110000101110100 01100001 0110001101101111011011010111000001101100011001010111010001100101 01110100011010010110110101100101 011101110110000101110011011101000110010101110010
----------------------------------------
May 9, 2011 at 2:20 am
Maybe when you export from access to CSV, you could concatenate a close quote..
SELECT someMemoField + '"', nextField FROM MyAccessTable
Ben
^ Thats me!
----------------------------------------
01010111011010000110000101110100 01100001 0110001101101111011011010111000001101100011001010111010001100101 01110100011010010110110101100101 011101110110000101110011011101000110010101110010
----------------------------------------
May 6, 2011 at 9:13 am
Viewing 15 posts - 196 through 210 (of 264 total)