Viewing 4 posts - 16 through 19 (of 19 total)
If you need to store very large texts into a database you can use a binary or varbinary
column and cast your text from varchar to binary to insert or update...
January 10, 2002 at 6:46 am
The easiest way still to perform a dump to a file, transfer the file and perform a manual restore with QA (to specify other file locations, ...)
This always work.
January 10, 2002 at 5:50 am
Use Dynamic properties, OLE_DB , Datasource
select 'QUERY' and type this select
select '\\Server\Directory\Subdirectory\FILENAME'+(convert (char(6),(SELECT GETDATE()),12))+'.txt'
January 10, 2002 at 5:46 am
Thanks for all.
The problem was that the driver for Oracle was named MSDAORA.1 on windowsXP while it was MSDAORA on windows2000 ...
October 30, 2001 at 9:16 am