Having Different Versions of Crystal Reports (8,9) in the same web application

See, We have a web application which is developed using Webclass Designer and currently runs on IIS 4.0 and IIS 5.0. It also contains a Reports Menu thorugh which the end user sees the data. These reports are mainly displayed using Crystal Reports 8.0.0.371. There are around 110 reports. The client wants specifically only couple of these reports to be migrated to version 9.0 leaving the rest. The reports are mainly opened, passed with SQL query etc in a single class file. So this is common for all the reports. Just that the object of this class file is created in every instance. The reference of CRAXDRT.dll of version 8 is added as a reference in this class file so that objects can be created.



Now my question is , is it possible to have two different versions of Crystal Reports in the same application. It means that ideally the support files are different. Also , it will be not possible for the report’s class file present in VB to refer both 8 and 9 at the same time. This is what I feel but as usual the client needs some support docs if this is true. Hence I need ur expert opinion on this.


Any help in this issue ...Please share ur expert opinionsHi,
I wish to do the same, did you manage to solve this problem, or does any1 else have any input?

Hardware requirement

Hi !
We have a sql server 2000, IIS and windows 2000 op-sys.
1133 Mhz cpu, 512 Mb RAM, raid5 scsi disk.
One prod database size 1164 Mb
Two test databases size 45 Mb
The server have 4 user in production and 1 programmer.
Is this server to small ?
If yes, what should we upgrade ?
Regards Jan RockstedtConsidering that your database and number of users is within the limitations
for MSDE (2GB data, 5 concurrent users), and MSDE is designed to run on a
desktop machine, I would say that your server might be overspec'd rather
than underspec'd.
Do you have any performance issues with it?
--
Jacco Schalkwijk
SQL Server MVP
"Jan" <_NO_SPAM_@.telia.com> wrote in message
news:O2LAncL8DHA.1548@.tk2msftngp13.phx.gbl...
> Hi !
> We have a sql server 2000, IIS and windows 2000 op-sys.
> 1133 Mhz cpu, 512 Mb RAM, raid5 scsi disk.
> One prod database size 1164 Mb
> Two test databases size 45 Mb
> The server have 4 user in production and 1 programmer.
> Is this server to small ?
> If yes, what should we upgrade ?
> Regards Jan Rockstedt
>|||I have problem with the RAM.
The server is allocating 560 Mb of 512 Mb, and using the swap file.
Is the any recomendation of memory alocating in SQL server 2000 ?
//Jan
Jacco Schalkwijk wrote:
> Considering that your database and number of users is within the
> limitations for MSDE (2GB data, 5 concurrent users), and MSDE is
> designed to run on a desktop machine, I would say that your server
> might be overspec'd rather than underspec'd.
> Do you have any performance issues with it?
>
> "Jan" <_NO_SPAM_@.telia.com> wrote in message
> news:O2LAncL8DHA.1548@.tk2msftngp13.phx.gbl...
>> Hi !
>> We have a sql server 2000, IIS and windows 2000 op-sys.
>> 1133 Mhz cpu, 512 Mb RAM, raid5 scsi disk.
>> One prod database size 1164 Mb
>> Two test databases size 45 Mb
>> The server have 4 user in production and 1 programmer.
>> Is this server to small ?
>> If yes, what should we upgrade ?
>> Regards Jan Rockstedt|||F.Y.I the sql server i configure:
Dynamically configure SQL server memory
Minimum 41 MB
Maximum 388 MB
Minimum query memory (KB) 1024
Jan wrote:
> I have problem with the RAM.
> The server is allocating 560 Mb of 512 Mb, and using the swap file.
> Is the any recomendation of memory alocating in SQL server 2000 ?
> //Jan
> Jacco Schalkwijk wrote:
>> Considering that your database and number of users is within the
>> limitations for MSDE (2GB data, 5 concurrent users), and MSDE is
>> designed to run on a desktop machine, I would say that your server
>> might be overspec'd rather than underspec'd.
>> Do you have any performance issues with it?
>>
>> "Jan" <_NO_SPAM_@.telia.com> wrote in message
>> news:O2LAncL8DHA.1548@.tk2msftngp13.phx.gbl...
>> Hi !
>> We have a sql server 2000, IIS and windows 2000 op-sys.
>> 1133 Mhz cpu, 512 Mb RAM, raid5 scsi disk.
>> One prod database size 1164 Mb
>> Two test databases size 45 Mb
>> The server have 4 user in production and 1 programmer.
>> Is this server to small ?
>> If yes, what should we upgrade ?
>> Regards Jan Rockstedt|||If you want to avoid having the server use the page file (I guess that's
mostly IIS that does that) you can limit SQL Server to 340 MB or less, or
you can buy some more memory. Memeory is quiet cheap these days.
--
Jacco Schalkwijk
SQL Server MVP
"Jan" <_NO_SPAM_@.telia.com> wrote in message
news:OUgXrrU8DHA.2316@.TK2MSFTNGP09.phx.gbl...
> F.Y.I the sql server i configure:
> Dynamically configure SQL server memory
> Minimum 41 MB
> Maximum 388 MB
> Minimum query memory (KB) 1024
> Jan wrote:
> > I have problem with the RAM.
> > The server is allocating 560 Mb of 512 Mb, and using the swap file.
> >
> > Is the any recomendation of memory alocating in SQL server 2000 ?
> >
> > //Jan
> >
> > Jacco Schalkwijk wrote:
> >> Considering that your database and number of users is within the
> >> limitations for MSDE (2GB data, 5 concurrent users), and MSDE is
> >> designed to run on a desktop machine, I would say that your server
> >> might be overspec'd rather than underspec'd.
> >>
> >> Do you have any performance issues with it?
> >>
> >>
> >> "Jan" <_NO_SPAM_@.telia.com> wrote in message
> >> news:O2LAncL8DHA.1548@.tk2msftngp13.phx.gbl...
> >> Hi !
> >>
> >> We have a sql server 2000, IIS and windows 2000 op-sys.
> >> 1133 Mhz cpu, 512 Mb RAM, raid5 scsi disk.
> >>
> >> One prod database size 1164 Mb
> >> Two test databases size 45 Mb
> >>
> >> The server have 4 user in production and 1 programmer.
> >>
> >> Is this server to small ?
> >> If yes, what should we upgrade ?
> >>
> >> Regards Jan Rockstedt
>
>

Handling Bounced Emails

We use CDonts to send email from SQL 2k & IIS 6.0. All the email is "From:
server@.myserver.com", it has a "Reply To: ourcustomer@.thieremail.com" that
is the user we are sending on behalf of, so to speak.
I need to process undeliverable emails (bounced email is the term yes?).
Looking for suggestions, using ASP or SQL is preferred.
Thanks,
Dan Foxley
Hi
If you are not returning the emails to a profile that is set up so that SQL
Server can read the mailbox then you can not do it from SQL Server. If you
can access the emails using SQL Mail, then you may be able to read then with
xp_readmail and parse and process them accordingly, unfortunately you may
have to deal with a multitude of formats.
John
"Dan Foxley" <dfoxley@.nospampacificdatavision.com> wrote in message
news:uwL30Ls5EHA.1524@.TK2MSFTNGP09.phx.gbl...
> We use CDonts to send email from SQL 2k & IIS 6.0. All the email is
> "From: server@.myserver.com", it has a "Reply To:
> ourcustomer@.thieremail.com" that is the user we are sending on behalf of,
> so to speak.
> I need to process undeliverable emails (bounced email is the term yes?).
> Looking for suggestions, using ASP or SQL is preferred.
> Thanks,
> Dan Foxley
>
|||Are there options to using SQL Mail without an Exchange server? Looks like
SQLiMail in SQL 2005 will not use a MAPI client.
"John Bell" <jbellnewsposts@.hotmail.com> wrote in message
news:OrhAbMt5EHA.2600@.TK2MSFTNGP09.phx.gbl...
> Hi
> If you are not returning the emails to a profile that is set up so that
> SQL Server can read the mailbox then you can not do it from SQL Server. If
> you can access the emails using SQL Mail, then you may be able to read
> then with xp_readmail and parse and process them accordingly,
> unfortunately you may have to deal with a multitude of formats.
> John
> "Dan Foxley" <dfoxley@.nospampacificdatavision.com> wrote in message
> news:uwL30Ls5EHA.1524@.TK2MSFTNGP09.phx.gbl...
>
|||Hi
SQLMail can be configured to use a non-exchange email account, but I have
never done it. Looking at CDONTS you can access a SMTP login (logonSMTP)
http://msdn.microsoft.com/library/de...s_library_.asp
and from there access the inbox and messages within it.
John
"Dan Foxley" <dfoxley@.nospampacificdatavision.com> wrote in message
news:%23hUyOZu5EHA.4040@.TK2MSFTNGP14.phx.gbl...
> Are there options to using SQL Mail without an Exchange server? Looks
> like SQLiMail in SQL 2005 will not use a MAPI client.
>
> "John Bell" <jbellnewsposts@.hotmail.com> wrote in message
> news:OrhAbMt5EHA.2600@.TK2MSFTNGP09.phx.gbl...
>
|||This seems like the solution. I've heard of VERP Variable Envelope Return
Path, mainly used in the Unix world for prepending each email recipient with
a unique "From:", have you seem implementations using SQL?
Thanks,
Dan
"John Bell" <jbellnewsposts@.hotmail.com> wrote in message
news:%23s2NQ3x5EHA.3472@.TK2MSFTNGP09.phx.gbl...
> Hi
> SQLMail can be configured to use a non-exchange email account, but I have
> never done it. Looking at CDONTS you can access a SMTP login (logonSMTP)
> http://msdn.microsoft.com/library/de...s_library_.asp
> and from there access the inbox and messages within it.
> John
> "Dan Foxley" <dfoxley@.nospampacificdatavision.com> wrote in message
> news:%23hUyOZu5EHA.4040@.TK2MSFTNGP14.phx.gbl...
>
|||If I understand what you are doing.......
What you want to do is defined the "Return Path" or "Mail From" field for
the SMTP state that defines the sender address (not the author address) as
the return path for any notification (bounce) purposes.
So if you can, set the Return Path (MAIL FROM) in CDONTS, prepare a real
address that will bounce mail to a specific bin. I don't use CDON'T so I
can't tell you how to do that, but it is PART of the normal SMTP system.
This would be the MAIL FROM address in the SMTP state machine:
connection
HELO client domain name
MAIL FROM: return address
RCPT TO: recipient address
DATA
email body
QUIT
It is not the RFC 822 header fields "From: " or "Reply-To:" These are
completely meaningless when it comes to the transport system. Those are
"user fields." Reply-To: just tells the user where to send a reply to. It
is not used for bouncing mail.
Once you do this, then you can use some IIS Event hook to trigger inbound
mail handling for a specific address.
Hector Santos
WINSERVER "Wildcat! Interactive Net Server"
support: http://www.winserver.com
sales: http://www.santronics.com
"Dan Foxley" <dfoxley@.nospampacificdatavision.com> wrote in message
news:uwL30Ls5EHA.1524@.TK2MSFTNGP09.phx.gbl...
> We use CDonts to send email from SQL 2k & IIS 6.0. All the email is
"From:
> server@.myserver.com", it has a "Reply To: ourcustomer@.thieremail.com" that
> is the user we are sending on behalf of, so to speak.
> I need to process undeliverable emails (bounced email is the term yes?).
> Looking for suggestions, using ASP or SQL is preferred.
> Thanks,
> Dan Foxley
>
|||Hi
CDONTS and the processing of SMTP mail is not really anything to do with SQL
Server. Creating unique return addresses should not be that difficult, but
handled the returned emails is a funtion of your mail server. I think would
still have to parse the content of the email to try and determine why it was
returned.
John
"Dan Foxley" <dfoxley@.nospampacificdatavision.com> wrote in message
news:OQeJJk55EHA.3472@.TK2MSFTNGP09.phx.gbl...
> This seems like the solution. I've heard of VERP Variable Envelope Return
> Path, mainly used in the Unix world for prepending each email recipient
> with a unique "From:", have you seem implementations using SQL?
> Thanks,
> Dan
>
> "John Bell" <jbellnewsposts@.hotmail.com> wrote in message
> news:%23s2NQ3x5EHA.3472@.TK2MSFTNGP09.phx.gbl...
>

Handling Bounced Emails

We use CDonts to send email from SQL 2k & IIS 6.0. All the email is "From:
server@.myserver.com", it has a "Reply To: ourcustomer@.thieremail.com" that
is the user we are sending on behalf of, so to speak.
I need to process undeliverable emails (bounced email is the term yes?).
Looking for suggestions, using ASP or SQL is preferred.
Thanks,
Dan FoxleyHi
If you are not returning the emails to a profile that is set up so that SQL
Server can read the mailbox then you can not do it from SQL Server. If you
can access the emails using SQL Mail, then you may be able to read then with
xp_readmail and parse and process them accordingly, unfortunately you may
have to deal with a multitude of formats.
John
"Dan Foxley" <dfoxley@.nospampacificdatavision.com> wrote in message
news:uwL30Ls5EHA.1524@.TK2MSFTNGP09.phx.gbl...
> We use CDonts to send email from SQL 2k & IIS 6.0. All the email is
> "From: server@.myserver.com", it has a "Reply To:
> ourcustomer@.thieremail.com" that is the user we are sending on behalf of,
> so to speak.
> I need to process undeliverable emails (bounced email is the term yes?).
> Looking for suggestions, using ASP or SQL is preferred.
> Thanks,
> Dan Foxley
>|||Are there options to using SQL Mail without an Exchange server? Looks like
SQLiMail in SQL 2005 will not use a MAPI client.
"John Bell" <jbellnewsposts@.hotmail.com> wrote in message
news:OrhAbMt5EHA.2600@.TK2MSFTNGP09.phx.gbl...
> Hi
> If you are not returning the emails to a profile that is set up so that
> SQL Server can read the mailbox then you can not do it from SQL Server. If
> you can access the emails using SQL Mail, then you may be able to read
> then with xp_readmail and parse and process them accordingly,
> unfortunately you may have to deal with a multitude of formats.
> John
> "Dan Foxley" <dfoxley@.nospampacificdatavision.com> wrote in message
> news:uwL30Ls5EHA.1524@.TK2MSFTNGP09.phx.gbl...
>> We use CDonts to send email from SQL 2k & IIS 6.0. All the email is
>> "From: server@.myserver.com", it has a "Reply To:
>> ourcustomer@.thieremail.com" that is the user we are sending on behalf of,
>> so to speak.
>> I need to process undeliverable emails (bounced email is the term yes?).
>> Looking for suggestions, using ASP or SQL is preferred.
>> Thanks,
>> Dan Foxley
>|||Hi
SQLMail can be configured to use a non-exchange email account, but I have
never done it. Looking at CDONTS you can access a SMTP login (logonSMTP)
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/cdo/html/_denali_session_object_cdonts_library_.asp
and from there access the inbox and messages within it.
John
"Dan Foxley" <dfoxley@.nospampacificdatavision.com> wrote in message
news:%23hUyOZu5EHA.4040@.TK2MSFTNGP14.phx.gbl...
> Are there options to using SQL Mail without an Exchange server? Looks
> like SQLiMail in SQL 2005 will not use a MAPI client.
>
> "John Bell" <jbellnewsposts@.hotmail.com> wrote in message
> news:OrhAbMt5EHA.2600@.TK2MSFTNGP09.phx.gbl...
>> Hi
>> If you are not returning the emails to a profile that is set up so that
>> SQL Server can read the mailbox then you can not do it from SQL Server.
>> If you can access the emails using SQL Mail, then you may be able to read
>> then with xp_readmail and parse and process them accordingly,
>> unfortunately you may have to deal with a multitude of formats.
>> John
>> "Dan Foxley" <dfoxley@.nospampacificdatavision.com> wrote in message
>> news:uwL30Ls5EHA.1524@.TK2MSFTNGP09.phx.gbl...
>> We use CDonts to send email from SQL 2k & IIS 6.0. All the email is
>> "From: server@.myserver.com", it has a "Reply To:
>> ourcustomer@.thieremail.com" that is the user we are sending on behalf
>> of, so to speak.
>> I need to process undeliverable emails (bounced email is the term yes?).
>> Looking for suggestions, using ASP or SQL is preferred.
>> Thanks,
>> Dan Foxley
>>
>|||This seems like the solution. I've heard of VERP Variable Envelope Return
Path, mainly used in the Unix world for prepending each email recipient with
a unique "From:", have you seem implementations using SQL?
Thanks,
Dan
"John Bell" <jbellnewsposts@.hotmail.com> wrote in message
news:%23s2NQ3x5EHA.3472@.TK2MSFTNGP09.phx.gbl...
> Hi
> SQLMail can be configured to use a non-exchange email account, but I have
> never done it. Looking at CDONTS you can access a SMTP login (logonSMTP)
> http://msdn.microsoft.com/library/default.asp?url=/library/en-us/cdo/html/_denali_session_object_cdonts_library_.asp
> and from there access the inbox and messages within it.
> John
> "Dan Foxley" <dfoxley@.nospampacificdatavision.com> wrote in message
> news:%23hUyOZu5EHA.4040@.TK2MSFTNGP14.phx.gbl...
>> Are there options to using SQL Mail without an Exchange server? Looks
>> like SQLiMail in SQL 2005 will not use a MAPI client.
>>
>> "John Bell" <jbellnewsposts@.hotmail.com> wrote in message
>> news:OrhAbMt5EHA.2600@.TK2MSFTNGP09.phx.gbl...
>> Hi
>> If you are not returning the emails to a profile that is set up so that
>> SQL Server can read the mailbox then you can not do it from SQL Server.
>> If you can access the emails using SQL Mail, then you may be able to
>> read then with xp_readmail and parse and process them accordingly,
>> unfortunately you may have to deal with a multitude of formats.
>> John
>> "Dan Foxley" <dfoxley@.nospampacificdatavision.com> wrote in message
>> news:uwL30Ls5EHA.1524@.TK2MSFTNGP09.phx.gbl...
>> We use CDonts to send email from SQL 2k & IIS 6.0. All the email is
>> "From: server@.myserver.com", it has a "Reply To:
>> ourcustomer@.thieremail.com" that is the user we are sending on behalf
>> of, so to speak.
>> I need to process undeliverable emails (bounced email is the term
>> yes?). Looking for suggestions, using ASP or SQL is preferred.
>> Thanks,
>> Dan Foxley
>>
>>
>|||If I understand what you are doing.......
What you want to do is defined the "Return Path" or "Mail From" field for
the SMTP state that defines the sender address (not the author address) as
the return path for any notification (bounce) purposes.
So if you can, set the Return Path (MAIL FROM) in CDONTS, prepare a real
address that will bounce mail to a specific bin. I don't use CDON'T so I
can't tell you how to do that, but it is PART of the normal SMTP system.
This would be the MAIL FROM address in the SMTP state machine:
connection
HELO client domain name
MAIL FROM: return address
RCPT TO: recipient address
DATA
email body
QUIT
It is not the RFC 822 header fields "From: " or "Reply-To:" These are
completely meaningless when it comes to the transport system. Those are
"user fields." Reply-To: just tells the user where to send a reply to. It
is not used for bouncing mail.
Once you do this, then you can use some IIS Event hook to trigger inbound
mail handling for a specific address.
--
Hector Santos
WINSERVER "Wildcat! Interactive Net Server"
support: http://www.winserver.com
sales: http://www.santronics.com
"Dan Foxley" <dfoxley@.nospampacificdatavision.com> wrote in message
news:uwL30Ls5EHA.1524@.TK2MSFTNGP09.phx.gbl...
> We use CDonts to send email from SQL 2k & IIS 6.0. All the email is
"From:
> server@.myserver.com", it has a "Reply To: ourcustomer@.thieremail.com" that
> is the user we are sending on behalf of, so to speak.
> I need to process undeliverable emails (bounced email is the term yes?).
> Looking for suggestions, using ASP or SQL is preferred.
> Thanks,
> Dan Foxley
>|||Hi
CDONTS and the processing of SMTP mail is not really anything to do with SQL
Server. Creating unique return addresses should not be that difficult, but
handled the returned emails is a funtion of your mail server. I think would
still have to parse the content of the email to try and determine why it was
returned.
John
"Dan Foxley" <dfoxley@.nospampacificdatavision.com> wrote in message
news:OQeJJk55EHA.3472@.TK2MSFTNGP09.phx.gbl...
> This seems like the solution. I've heard of VERP Variable Envelope Return
> Path, mainly used in the Unix world for prepending each email recipient
> with a unique "From:", have you seem implementations using SQL?
> Thanks,
> Dan
>
> "John Bell" <jbellnewsposts@.hotmail.com> wrote in message
> news:%23s2NQ3x5EHA.3472@.TK2MSFTNGP09.phx.gbl...
>> Hi
>> SQLMail can be configured to use a non-exchange email account, but I have
>> never done it. Looking at CDONTS you can access a SMTP login (logonSMTP)
>> http://msdn.microsoft.com/library/default.asp?url=/library/en-us/cdo/html/_denali_session_object_cdonts_library_.asp
>> and from there access the inbox and messages within it.
>> John
>> "Dan Foxley" <dfoxley@.nospampacificdatavision.com> wrote in message
>> news:%23hUyOZu5EHA.4040@.TK2MSFTNGP14.phx.gbl...
>> Are there options to using SQL Mail without an Exchange server? Looks
>> like SQLiMail in SQL 2005 will not use a MAPI client.
>>
>> "John Bell" <jbellnewsposts@.hotmail.com> wrote in message
>> news:OrhAbMt5EHA.2600@.TK2MSFTNGP09.phx.gbl...
>> Hi
>> If you are not returning the emails to a profile that is set up so that
>> SQL Server can read the mailbox then you can not do it from SQL Server.
>> If you can access the emails using SQL Mail, then you may be able to
>> read then with xp_readmail and parse and process them accordingly,
>> unfortunately you may have to deal with a multitude of formats.
>> John
>> "Dan Foxley" <dfoxley@.nospampacificdatavision.com> wrote in message
>> news:uwL30Ls5EHA.1524@.TK2MSFTNGP09.phx.gbl...
>> We use CDonts to send email from SQL 2k & IIS 6.0. All the email is
>> "From: server@.myserver.com", it has a "Reply To:
>> ourcustomer@.thieremail.com" that is the user we are sending on behalf
>> of, so to speak.
>> I need to process undeliverable emails (bounced email is the term
>> yes?). Looking for suggestions, using ASP or SQL is preferred.
>> Thanks,
>> Dan Foxley
>>
>>
>>
>