Did you verify the resulting path?

You state your data is "/images/drawing1.wmf"

And you append "http:/machinename/"

The net result of which is

http:/machinename//images/drawing1.wmf

You may simply have the string wrong. Test the net result...

In case anyone has the same need here is what I did.

In the report I opened the Reports properties dialog and selected the Code tab. Then I inserted the following...

Spoke too soon. I think I found a way that meets my needs. However could be I missed an easier solution so still post if you think you have a...

Sorry I have found nothing else. You should from all accounts be able to connect however that said how much free space is on your drives? And when you connect...

Go back to your previous post here

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=5&messageid=267157#bm267755

Sounds like you got htis to work maybe once then changed the table definition.

First I have to really understand what has Document have to do with Client and to Porject, and what does Client have to do with Project and Document, and what...

This is how I do it

select dateadd(qq,datediff(qq,0,GETDATE()),0)

select dateadd(ms,-3,dateadd(qq,datediff(qq,0,GETDATE()) + 1,0))

See if this helps

http://www.mcse.ms/archive81-2004-10-1185845.html

Best bet in SQL 2000 or 7

I am confused by this. Where did you find and have you gotten it to successfully work. Then even if you do it will fail the moment you add or...

I do believe the only things you have to change to work are the following two lines

STRING(SUBSTR(SBT_SUBSCRIBER_NUMBER,5,2),'00') FM_PRIN,

and

STRING(SUBSTR(WRK_SUBSCRIBER_NUMBER,5,2),'00') TO_PRIN,

all the rest should work as is. The only issue I don't...

Have you tried connecting with Query Anaylzer and the try based on the following.

The error 1105 means that transaction log is full.

There are to ways to resolve the error 1105: