on reporting services 2005(to dsiplay zeroes if data is not there in database)plss helppp

I am working on reporting services 2005 and i need to display zeroes in the report preview for the data which is not there in database,So pls help me if u can

Use the IsNull() or COALESCE functions in your sql. Check the Books Online (BOL) for instructions on how to use them.

OlyMars help?

Hi guys,
It seems that my last question was a little involved :)

Has any one got experience of working with OlyMars on Windows XP?

If so did you have problems with the OlyMars Tutorial in particular running the batch scripts?

I'm stuck on the section of Generation of Ready to Use Objects

Any help is appreciated :)

FBI think your best bet on this is one of the resources on this page:OlyMars: SQL Server Centric .NET Code Generator.

In particular there is a newsgroup that should help you: news://msnews.microsoft.com/microsoft.public.fr.dotnet.olymars. I see questions posted there in both French and English.

Terri|||..Good Stuff! Thanks Terri, I'll check it out now :)

OLEDB Providers

Hi,

I have a DTS package which is using OLEBD provider for Oracle, it was working fine. I tried to open this package and I got this error message "There was a problem retrieving the list of OLE DB Providers"

I tried to intall MDAC8.2, it didn't help, should I reinstall SQL Server?

Thanks!Where was the package working fine from, and where you were trying to open it from when you received an error?|||It was working from SQL Server 2000, I am trying it from same machine, same sql server and its not working.|||So you tried to install MDAC 8.2 on the SQL Server box? MDAC level on the server is controlled by service packs and should not be changed by any other way, like direct installation. MDAC is what SQL uses to talk to itself. If this is what you did, - at a minimum you need to have a reliable backup of your master, msdb, and user databases, because you may have to reapply SP3 (not sure that would do it), reinstall SQL (possibly will fix it), or reload the box.|||I tried to reinstall sql 2000 and service pack 3a but problem still exists. Is there any other option besides reloading the box?

Thanks!

OLEDB error exceeds maximum length of 128

I created a stored proc which is working perfectly even in SQL query analyser even if my query exceeds 128, but when i run it through asp I'm getting the error code 80040E14 which is mentioned in this subject, how can i work around on this?you can start here: http://support.microsoft.com/kb/306518

OLEDB command in SSIS

I AM working on DW building and i m using SSIS.I haev problem with data transformation OLEDB command.I have written a query to clean data in OLEDB command box ,but it takes whole lot of time because at a time it slects 6000 rows from the source and put in to destination but i have 300000 rows to process.How can i increase the size.The OLE DB command executes for every row in the data flow. Are you sure you're stating the correct component?

You should use an OLE DB Source component hooked to an OLE DB Destination component to move your data.|||I want to delete some data while transfering from one to another i.e i want to do cleaning.|||If you want this to be fast, try writing the keys for the rows to delete to a temporary table, then use an Execute SQL task to issue a batch DELETE statement. Since the OLEDB Command transform executes once for each row that passes through it, it will be slower than doing a batch.

OLE DB or ADO? plz give me a suggestion!

i am learn database access with native vc++, so ADO.NET is not electable for me.

i wonder whether i should study OLE DB first or ADO.

i've been working with ADO under VB for some time, it's very simple to use. but i dont think it's the best choice for vc++, i think it's OLE DB. but OLE DB is really difficult, too many interfaces, and properties!!!
could u give a suggestion? should i learn ADO with vc++ first and then OLE DB, or sould i learn OLE DB directly?

I would not suggest using ADO, use OLE DB if you're trying to stay native (since ADO has been superceded by ADO.NET). You could also use the C libraries that many database vendors supply.

Is there a reason you're using native C++ database calls, and not something like ADO.NET? Just curious,

Josh Lindenmuth|||thank for your suggestion! i use native C++ because i like it, and i am a student, i am learning native VC++. ADO.NET is great, it does a lot for you. but i want to learn more about the system.

the biggest problem i am facing now is about the data conversion and binding, i can find much material about this subject on MSDN. and the Property Set too, almost every call need a set of properties, but no body tell why i need them. and it seems that many calls can work with NULL property set!!!

is there any nice book for teaching OLE DB?|||

I still say if you're going to use OLEDb, use it through ADO.NET (there's an OLEDB data provider). You'll develop code faster, and it will probably perform better as well. Otherwise, I don't see much use ... if you're going to use native C++ I'd still suggest using ODBC or one of the database specific C libraries that many vendors provide.

Here are two older books on the subject of ODBC and OLEDB:
http://www.amazon.com/gp/product/0764533088/102-6516636-3196933?v=glance&n=283155&v=glance

http://www.amazon.com/gp/product/1572316128/102-6516636-3196933?v=glance&n=283155&s=books&v=glance

Hope this helps,
Josh Lindenmuth

|||thanks!!
one more question!
if i want to code a lightweight COM component, should i use ATL+ODBC or ATL+OLE DB ?|||

You should also look at ODBC. It is a simpler API with fewer calls and hence is easier to learn than OLE DB. OLE DB would be a good choice if you plan to become a COM expert, otherwise ODBC may be your best bet. For most tasks you will write less code with ODBC than you would with OLE DB.

|||yes, i want to be a COM expert! but the OLE DB interfaces are really difficult for starters, however, ATL make it much easier to use! i think i can use those wrapped OLE DB interfaces first!

OLE DB Command Error SSIS

Hi,

when we are using OLEDB Command we are getting the following error?

when we use sql server as the source its working fine .but its throwing error when we try to connect the orcale database .

Error at Data FLOW TASk[OLE DB Command[3863]]: An OLE DB error has occured :0x80040E51.

An OLE DB record is available. Source : "Microsoft OLE DB Provider for Oracle" Hresult: 0x80040E51

Description: "Provider cannot derive parameter information and SetParameterInfo has not been called.".

ERrror at Data Flow Task [OLE DB Command [3863]]: Unable to retrieve destination column description from the Parameter of the SQL Command

Thanks & Regards

Jegan.T

This is an OLE DB Error. My first suggestion would be to try Oracle's own driver instead of the Microsoft one.

-Jamie

|||

Hi Jamie,

Do we need to install orcale driver separtely or its comes with SSIS ?

Thanks

Jegan.T

|||

Seperately. It comes with Oracle.

|||

Hi Jamie

Thanks for the suggestion . i'll give a try and get back to you..

Jegan.T

Older versions of SQL Server

I'm going to be working on a project that needs both SQL Server 6.5 and SQL
Server 7.0. Does anybody know how I can get hold of copies of these?
Mark,
I would suspect you'd need to purchase both - online would be probably be
the cheapest i.e, EBay or (Google it). Would check with seller to ensure
validity of the product.
HTH
Jerry
"Mark Burton" <MarkBurton@.discussions.microsoft.com> wrote in message
news:CCC8E556-4814-4E15-9425-D77ACEC69CA7@.microsoft.com...
> I'm going to be working on a project that needs both SQL Server 6.5 and
> SQL
> Server 7.0. Does anybody know how I can get hold of copies of these?
|||The original instructions for this are at
http://www.microsoft.com/sql/howtobuy/70/pricing.asp however they don't
appear to still be valid. You'll probably have to call Microsoft for help.
Hal Berenson, President
PredictableIT, LLC
"Mark Burton" <MarkBurton@.discussions.microsoft.com> wrote in message
news:CCC8E556-4814-4E15-9425-D77ACEC69CA7@.microsoft.com...
> I'm going to be working on a project that needs both SQL Server 6.5 and
> SQL
> Server 7.0. Does anybody know how I can get hold of copies of these?

Older versions of SQL Server

I'm going to be working on a project that needs both SQL Server 6.5 and SQL
Server 7.0. Does anybody know how I can get hold of copies of these?Mark,
I would suspect you'd need to purchase both - online would be probably be
the cheapest i.e, EBay or (Google it). Would check with seller to ensure
validity of the product.
HTH
Jerry
"Mark Burton" <MarkBurton@.discussions.microsoft.com> wrote in message
news:CCC8E556-4814-4E15-9425-D77ACEC69CA7@.microsoft.com...
> I'm going to be working on a project that needs both SQL Server 6.5 and
> SQL
> Server 7.0. Does anybody know how I can get hold of copies of these?|||The original instructions for this are at
http://www.microsoft.com/sql/howtobuy/70/pricing.asp however they don't
appear to still be valid. You'll probably have to call Microsoft for help.
--
Hal Berenson, President
PredictableIT, LLC
"Mark Burton" <MarkBurton@.discussions.microsoft.com> wrote in message
news:CCC8E556-4814-4E15-9425-D77ACEC69CA7@.microsoft.com...
> I'm going to be working on a project that needs both SQL Server 6.5 and
> SQL
> Server 7.0. Does anybody know how I can get hold of copies of these?

Older versions of SQL Server

I'm going to be working on a project that needs both SQL Server 6.5 and SQL
Server 7.0. Does anybody know how I can get hold of copies of these?Mark,
I would suspect you'd need to purchase both - online would be probably be
the cheapest i.e, EBay or (Google it). Would check with seller to ensure
validity of the product.
HTH
Jerry
"Mark Burton" <MarkBurton@.discussions.microsoft.com> wrote in message
news:CCC8E556-4814-4E15-9425-D77ACEC69CA7@.microsoft.com...
> I'm going to be working on a project that needs both SQL Server 6.5 and
> SQL
> Server 7.0. Does anybody know how I can get hold of copies of these?|||The original instructions for this are at
http://www.microsoft.com/sql/howtobuy/70/pricing.asp however they don't
appear to still be valid. You'll probably have to call Microsoft for help.
Hal Berenson, President
PredictableIT, LLC
"Mark Burton" <MarkBurton@.discussions.microsoft.com> wrote in message
news:CCC8E556-4814-4E15-9425-D77ACEC69CA7@.microsoft.com...
> I'm going to be working on a project that needs both SQL Server 6.5 and
> SQL
> Server 7.0. Does anybody know how I can get hold of copies of these?