Data Source Provider Error: The event log file is full

I'm trying to process one of my cubes and am getting this error, see subject
line. Mt configuration is this: Development Web server Dul09 holds the cube
s. The data lives on a SQL server DryHou10. I have had my sysadmin check the
event logs on both serv
ers, neither of which is full. This setup has been working just fine for the
last few years. Other cubes on Dul09, using different SQL servers for data,
process just fine.
All servers are running SQL 2000TJSully wrote:
> *I'm trying to process one of my cubes and am getting this error, see
> subject line. Mt configuration is this: Development Web server Dul09
> holds the cubes. The data lives on a SQL server DryHou10. I have had
> my sysadmin check the event logs on both serv
> ers, neither of which is full. This setup has been working just fine
> for the last few years. Other cubes on Dul09, using different SQL
> servers for data, process just fine.
> All servers are running SQL 2000 *
annieckl
---
Posted via http://www.mcse.ms
---
View this thread: http://www.mcse.ms/message441896.html|||Are you sure that they are not full...I got the same error once and emptied
all my logs (you can put them into files if
you want to keep them) - it worked again after that.
--Michael
"annieckl" <annieckl.1dtcei@.mail.mcse.ms> skrev i en meddelelse
news:annieckl.1dtcei@.mail.mcse.ms...
> TJSully wrote:
>
> --
> annieckl
> ---
> Posted via http://www.mcse.ms
> ---
> View this thread: http://www.mcse.ms/message441896.html
>

Data source name not found and no default driver specified

On the database server, when I try to connect my SQL Server registration, I
get the error on the subject line. WHen I check my SQL Server Services using
SQL Server Services Manager, I do not see my server name in the drop down box
- I have to type it in. SQL Server Agent and server services are started. My
jobs failed because of the error. I have never had to set up a DSN on the
server to get a connection to the database. PLease help to resolve
Hmmm...Is this a clean installation, an upgrade, etc...
Might be related (and I emphasize might) to MDAC. Check out:
http://support.microsoft.com/?kbid=301202
and
http://www.microsoft.com/downloads/d...displaylang=en
HTH
Jerry
"spoons" <spoons@.discussions.microsoft.com> wrote in message
news:CD4E905C-F6B5-4B1F-A1F8-8D205580DB35@.microsoft.com...
> On the database server, when I try to connect my SQL Server registration,
> I
> get the error on the subject line. WHen I check my SQL Server Services
> using
> SQL Server Services Manager, I do not see my server name in the drop down
> box
> - I have to type it in. SQL Server Agent and server services are started.
> My
> jobs failed because of the error. I have never had to set up a DSN on the
> server to get a connection to the database. PLease help to resolve
>

Data source name not found and no default driver specified

On the database server, when I try to connect my SQL Server registration, I
get the error on the subject line. WHen I check my SQL Server Services using
SQL Server Services Manager, I do not see my server name in the drop down box
- I have to type it in. SQL Server Agent and server services are started. My
jobs failed because of the error. I have never had to set up a DSN on the
server to get a connection to the database. PLease help to resolveHmmm...Is this a clean installation, an upgrade, etc...
Might be related (and I emphasize might) to MDAC. Check out:
http://support.microsoft.com/?kbid=301202
and
http://www.microsoft.com/downloads/details.aspx?FamilyID=6c050fe3-c795-4b7d-b037-185d0506396c&displaylang=en
HTH
Jerry
"spoons" <spoons@.discussions.microsoft.com> wrote in message
news:CD4E905C-F6B5-4B1F-A1F8-8D205580DB35@.microsoft.com...
> On the database server, when I try to connect my SQL Server registration,
> I
> get the error on the subject line. WHen I check my SQL Server Services
> using
> SQL Server Services Manager, I do not see my server name in the drop down
> box
> - I have to type it in. SQL Server Agent and server services are started.
> My
> jobs failed because of the error. I have never had to set up a DSN on the
> server to get a connection to the database. PLease help to resolve
>sql

Data source name not found and no default driver specified

On the database server, when I try to connect my SQL Server registration, I
get the error on the subject line. WHen I check my SQL Server Services using
SQL Server Services Manager, I do not see my server name in the drop down bo
x
- I have to type it in. SQL Server Agent and server services are started. My
jobs failed because of the error. I have never had to set up a DSN on the
server to get a connection to the database. PLease help to resolveHmmm...Is this a clean installation, an upgrade, etc...
Might be related (and I emphasize might) to MDAC. Check out:
http://support.microsoft.com/?kbid=301202
and
http://www.microsoft.com/downloads/...&displaylang=en
HTH
Jerry
"spoons" <spoons@.discussions.microsoft.com> wrote in message
news:CD4E905C-F6B5-4B1F-A1F8-8D205580DB35@.microsoft.com...
> On the database server, when I try to connect my SQL Server registration,
> I
> get the error on the subject line. WHen I check my SQL Server Services
> using
> SQL Server Services Manager, I do not see my server name in the drop down
> box
> - I have to type it in. SQL Server Agent and server services are started.
> My
> jobs failed because of the error. I have never had to set up a DSN on the
> server to get a connection to the database. PLease help to resolve
>

Data Series Color and Fill Effects?

Hi,

I was wondering if one could manage the color of the data series in line and bar charts much like what you could do in Excel?

Even changing the default order of the colors would be nice, just so different charts actually look...well, different.

Thanks!

Well,

I figured out how to do it, when I actually have multiple data fields there. It is a simply matter of navigating to:

Properties -> Data Tab -> Edit Values...

However, when I have different series that are determined dynamically by dropping dimension fields into the series field, can you still dictate the colors and fills?

Thanks!

|||

OK, I found this online:

http://msdn2.microsoft.com/en-us/library/aa964128(SQL.90).aspx

But I can't seem to find the magical custom code window.

Where is the custom code window?

(I know this is a stupid question, but I really really can't find it)

Data not getting plotted in line graph

Hi,
I have a LINE chart with 2 data fields, and 1 category field.
I havent included any series field in the chart.
If the query returns more than 1 records then both the data field values are
getting plotted in the graph.
If the query returns only one record then only the first data point is
plotted. I dont know why the value for second data field is not plotted...
Is it a bug in reporting services?
Please any one reply me asap... I have to fix it for the client by today...
Thanks for help...
Regards,
RanjithTo add more information,
if i change the chart type to any other chart other then LINE graph, it is
getting plotted. Only for Line graph its not working...
Thanks,
Ranjith
"Ranjith Prakash" wrote:
> Hi,
> I have a LINE chart with 2 data fields, and 1 category field.
> I havent included any series field in the chart.
> If the query returns more than 1 records then both the data field values are
> getting plotted in the graph.
> If the query returns only one record then only the first data point is
> plotted. I dont know why the value for second data field is not plotted...
> Is it a bug in reporting services?
> Please any one reply me asap... I have to fix it for the client by today...
> Thanks for help...
> Regards,
> Ranjith
>
>|||Please read this recent thread:
http://msdn.microsoft.com/newsgroups/default.aspx?dg=microsoft.public.sqlserver.reportingsvcs&mid=a3bce317-0626-47f4-9ec2-aebe559a41b3&sloc=en-us
It sounds like you have a very similar situation. You can either request the
SP1-based hotfix or use SP2 Beta (http://support.microsoft.com/kb/842440) or
wait till the official release of SP2.
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"Ranjith Prakash" <Ranjith Prakash@.discussions.microsoft.com> wrote in
message news:158BA878-86E5-4D17-93F1-E19F79350E92@.microsoft.com...
> To add more information,
> if i change the chart type to any other chart other then LINE graph, it is
> getting plotted. Only for Line graph its not working...
> Thanks,
> Ranjith
> "Ranjith Prakash" wrote:
> > Hi,
> >
> > I have a LINE chart with 2 data fields, and 1 category field.
> > I havent included any series field in the chart.
> >
> > If the query returns more than 1 records then both the data field values
are
> > getting plotted in the graph.
> >
> > If the query returns only one record then only the first data point is
> > plotted. I dont know why the value for second data field is not
plotted...
> >
> > Is it a bug in reporting services?
> > Please any one reply me asap... I have to fix it for the client by
today...
> >
> > Thanks for help...
> >
> > Regards,
> > Ranjith
> >
> >
> >|||Hi Robert,
Thanks a lot for helping me. That did fix my bug.
Thanks again,
Ranjith
"Robert Bruckner [MSFT]" wrote:
> Please read this recent thread:
> http://msdn.microsoft.com/newsgroups/default.aspx?dg=microsoft.public.sqlserver.reportingsvcs&mid=a3bce317-0626-47f4-9ec2-aebe559a41b3&sloc=en-us
> It sounds like you have a very similar situation. You can either request the
> SP1-based hotfix or use SP2 Beta (http://support.microsoft.com/kb/842440) or
> wait till the official release of SP2.
> --
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "Ranjith Prakash" <Ranjith Prakash@.discussions.microsoft.com> wrote in
> message news:158BA878-86E5-4D17-93F1-E19F79350E92@.microsoft.com...
> > To add more information,
> >
> > if i change the chart type to any other chart other then LINE graph, it is
> > getting plotted. Only for Line graph its not working...
> >
> > Thanks,
> > Ranjith
> >
> > "Ranjith Prakash" wrote:
> >
> > > Hi,
> > >
> > > I have a LINE chart with 2 data fields, and 1 category field.
> > > I havent included any series field in the chart.
> > >
> > > If the query returns more than 1 records then both the data field values
> are
> > > getting plotted in the graph.
> > >
> > > If the query returns only one record then only the first data point is
> > > plotted. I dont know why the value for second data field is not
> plotted...
> > >
> > > Is it a bug in reporting services?
> > > Please any one reply me asap... I have to fix it for the client by
> today...
> > >
> > > Thanks for help...
> > >
> > > Regards,
> > > Ranjith
> > >
> > >
> > >
>
>

Data Load from cmd line prompt...how?

I need to load lookup tables into SQL2005 from a cmd line prompt. Whats the
best way to do this?
Thanks
-Theresa
Refer to the documentation on the BCP utility (bulk-copy program). This will
extract/load from/to tables or queries.
AndyP,
Sr. Database Administrator,
MCDBA 2003
"TheresaB" wrote:

> I need to load lookup tables into SQL2005 from a cmd line prompt. Whats the
> best way to do this?
> Thanks
> -Theresa

Data Load from cmd line prompt...how?

I need to load lookup tables into SQL2005 from a cmd line prompt. Whats the
best way to do this?
Thanks
-TheresaRefer to the documentation on the BCP utility (bulk-copy program). This will
extract/load from/to tables or queries.
AndyP,
Sr. Database Administrator,
MCDBA 2003
"TheresaB" wrote:

> I need to load lookup tables into SQL2005 from a cmd line prompt. Whats th
e
> best way to do this?
> Thanks
> -Theresa

Data Load from cmd line prompt...how?

I need to load lookup tables into SQL2005 from a cmd line prompt. Whats the
best way to do this?
Thanks :)
-TheresaRefer to the documentation on the BCP utility (bulk-copy program). This will
extract/load from/to tables or queries.
--
AndyP,
Sr. Database Administrator,
MCDBA 2003
"TheresaB" wrote:
> I need to load lookup tables into SQL2005 from a cmd line prompt. Whats the
> best way to do this?
> Thanks :)
> -Theresa

Data in table truncated

Hi all,
Is there a way to set the cell in a table to allow the data to print
on one line by spilling into the cell to the right of it?
I currently have a table with two group headers and detail lines.
However, the text that I need to put in the group header is much
longer then the data I put in the first column in the details. So I
don't want to stretch the first column out to fit my group header,
since that would cause a lot of white space in the detail rows. Also,
I can't use the Can Grow property, since the text in the group header
is just one word.
Is there a way to work around this?
Thanks in advance.On Feb 29, 3:40=A0pm, k-chan <kitty.s...@.gmail.com> wrote:
> Hi all,
> Is there a way to set the cell in a table to allow the data to print
> on one line by spilling into the cell to the right of it?
> I currently have a table with two group headers and detail lines.
> However, the text that I need to put in the group header is much
> longer then the data I put in the first column in the details. So I
> don't want to stretch the first column out to fit my group header,
> since that would cause a lot of white space in the detail rows. Also,
> I can't use the Can Grow property, since the text in the group header
> is just one word.
> Is there a way to work around this?
> Thanks in advance.
Try selecting all the cells in the group header row then right
clicking and choosing "Merge Cells." That should let your group
header text take the room it needs without affecting the size of the
detail row columns.
HTH
toolman|||On Mar 3, 8:41 am, toolman <t...@.infocision.com> wrote:
> On Feb 29, 3:40 pm, k-chan <kitty.s...@.gmail.com> wrote:
> > Hi all,
> > Is there a way to set the cell in a table to allow the data to print
> > on one line by spilling into the cell to the right of it?
> > I currently have a table with two group headers and detail lines.
> > However, the text that I need to put in the group header is much
> > longer then the data I put in the first column in the details. So I
> > don't want to stretch the first column out to fit my group header,
> > since that would cause a lot of white space in the detail rows. Also,
> > I can't use the Can Grow property, since the text in the group header
> > is just one word.
> > Is there a way to work around this?
> > Thanks in advance.
> Try selecting all the cells in the group header row then right
> clicking and choosing "Merge Cells." That should let your group
> header text take the room it needs without affecting the size of the
> detail row columns.
> HTH
> toolman
Thank you, that solved my problems! :D