Hi,

I'm using "Microsoft OLE DB provider for DB2" driver, shipped with HIS and suitable for SQL Server Enterprise Edition.

It works very well, I used the "Data Access Tool" to configure...

I transfer datas from AS400 to SQL Server 2005 via SSIS, it works well but there is a bug in V5R3 that disable the possibility to make SQL querys against AS400.

It...

Hi,

Where do you type your text ? In SQL Server Enterprise Manager ?

A varchar column can indeed contain up to 8.000 characters (nvarchar up to 4.000 because unicode needs 2...

I think the best would be to send me a screenshot because there are so many images on that page...

Could you send me the url of your general forum home and tell me which link does display a cross mark ?

"Show image download place holders" should be OFF.

It's the option "Show pictures" just below that must be ON.

And if you can see the GIF file that I linked, the problem...

So let's try to go ahead : can you see gif files like this one ?

http://www.google.fr/logos/olympics06_alpine.gif

Could you check in IE options that the option "display images" is enabled in...

The problem is I can see all the pictures so I can't help you if you don'y give me an URL for an image that you can't see like this...

Hmm my name is Thierry (not newbie...)

I think you made a mistake because your link redirects to the forum login page...

Could you post a link to a .jpg file that causes problem because I'm at work right now and I don't have sufficient time to find an image...

Thanks !

Hello,

Do you have a test URL ?

My first idea is that some JPG pictures are recorded in CMYB insted of RGB. Internet explorer does not like JPG in CMYB mode.

Regards

Ok, what I would do is the following :

- rather than proceed to multiple UPDATE statements, I would insert values in a temporary table for each row

- at the end...

Hello,

If you do multiple updates, it's very slow. Another way to do multiple updates is to use a temporary table and make a global update with an inner join.

Could you...