473,739 Members | 2,531 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

crystal reports unreleased connections

Hi Group,

I've got an interesting problem, I don't know if this is the right group but
I think so because everything I've read about it so far says it's a .net
problem. Here's the problem, we're using crystal reports 9 and vb.net and
we're using the crystalrepotVie wer to show our reports. But every time we
open a report the connection to or sql server remains, so if I open 5 forms
with the report viewer I've got 5 sleeping connections in my sql server. If
I close all 5 forms I still got 5 open connections, and they will not go
away until I close the entire application. The problem with this is that
some user only use the app to print reports so after about an hour or so
they've got 80 sleeping connections. I've tried putting
crystalreportvi ewer1.dispose in the form closing event but this has no
effect. The crviewer also hasn't got a connection.clos e method or something
like that
Any help would be very much appreciated

Grtz Peter
Nov 21 '05 #1
17 8450
Hi Peter,

This is interesting - how do you know you have these sleeping connections?

Bernie Yaeger

"Peter Proost" <pp*****@nospam .hotmail.com> wrote in message
news:%2******** ********@TK2MSF TNGP14.phx.gbl. ..
Hi Group,

I've got an interesting problem, I don't know if this is the right group
but
I think so because everything I've read about it so far says it's a .net
problem. Here's the problem, we're using crystal reports 9 and vb.net and
we're using the crystalrepotVie wer to show our reports. But every time we
open a report the connection to or sql server remains, so if I open 5
forms
with the report viewer I've got 5 sleeping connections in my sql server.
If
I close all 5 forms I still got 5 open connections, and they will not go
away until I close the entire application. The problem with this is that
some user only use the app to print reports so after about an hour or so
they've got 80 sleeping connections. I've tried putting
crystalreportvi ewer1.dispose in the form closing event but this has no
effect. The crviewer also hasn't got a connection.clos e method or
something
like that
Any help would be very much appreciated

Grtz Peter

Nov 21 '05 #2
Hi Bernie,

sorry I haven't replied earlier to your post but it didn't show up in my
news reader and it still doesn't but I saw it on google. I know I've got the
sleeping connections because they show up in the sql server enterprise
manager

greetz Peter

"Peter Proost" <pp*****@nospam .hotmail.com> wrote in message
news:#i******** ******@TK2MSFTN GP14.phx.gbl...
Hi Group,

I've got an interesting problem, I don't know if this is the right group but I think so because everything I've read about it so far says it's a .net
problem. Here's the problem, we're using crystal reports 9 and vb.net and
we're using the crystalrepotVie wer to show our reports. But every time we
open a report the connection to or sql server remains, so if I open 5 forms with the report viewer I've got 5 sleeping connections in my sql server. If I close all 5 forms I still got 5 open connections, and they will not go
away until I close the entire application. The problem with this is that
some user only use the app to print reports so after about an hour or so
they've got 80 sleeping connections. I've tried putting
crystalreportvi ewer1.dispose in the form closing event but this has no
effect. The crviewer also hasn't got a connection.clos e method or something like that
Any help would be very much appreciated

Grtz Peter

Nov 21 '05 #3
Hi Peter,

Your ISP is blocking you from perceived spam; happens to me all the time.
Just check back here periodically.

You're correct; I am working on the problem now to see if I can find a fix;
I will get back to you asap.

Bernie

"Peter Proost" <pp*****@nospam .hotmail.com> wrote in message
news:ud******** ******@TK2MSFTN GP15.phx.gbl...
Hi Bernie,

sorry I haven't replied earlier to your post but it didn't show up in my
news reader and it still doesn't but I saw it on google. I know I've got
the
sleeping connections because they show up in the sql server enterprise
manager

greetz Peter

"Peter Proost" <pp*****@nospam .hotmail.com> wrote in message
news:#i******** ******@TK2MSFTN GP14.phx.gbl...
Hi Group,

I've got an interesting problem, I don't know if this is the right group

but
I think so because everything I've read about it so far says it's a .net
problem. Here's the problem, we're using crystal reports 9 and vb.net and
we're using the crystalrepotVie wer to show our reports. But every time we
open a report the connection to or sql server remains, so if I open 5

forms
with the report viewer I've got 5 sleeping connections in my sql server.

If
I close all 5 forms I still got 5 open connections, and they will not go
away until I close the entire application. The problem with this is that
some user only use the app to print reports so after about an hour or so
they've got 80 sleeping connections. I've tried putting
crystalreportvi ewer1.dispose in the form closing event but this has no
effect. The crviewer also hasn't got a connection.clos e method or

something
like that
Any help would be very much appreciated

Grtz Peter


Nov 21 '05 #4
Hi Peter,

It looks like there is a good reason for what you've encountered, and I was
aware of it but didn't really observe its behavior before.

The issue is 'connection pooling'. In .net, open connections are pooled and
reused, up to a maximum (I believe 100). They really don't hurt anything
and provide for speedy reuse of a connection. If you want to shut it down,
you can set pooling = false, but I'm told this is not a good idea. Here's a
link that you may find helpful:

http://msdn.microsoft.com/library/de...taProvider.asp

HTH,

Bernie Yaeger

"Peter Proost" <pp*****@nospam .hotmail.com> wrote in message
news:%2******** ********@TK2MSF TNGP14.phx.gbl. ..
Hi Group,

I've got an interesting problem, I don't know if this is the right group
but
I think so because everything I've read about it so far says it's a .net
problem. Here's the problem, we're using crystal reports 9 and vb.net and
we're using the crystalrepotVie wer to show our reports. But every time we
open a report the connection to or sql server remains, so if I open 5
forms
with the report viewer I've got 5 sleeping connections in my sql server.
If
I close all 5 forms I still got 5 open connections, and they will not go
away until I close the entire application. The problem with this is that
some user only use the app to print reports so after about an hour or so
they've got 80 sleeping connections. I've tried putting
crystalreportvi ewer1.dispose in the form closing event but this has no
effect. The crviewer also hasn't got a connection.clos e method or
something
like that
Any help would be very much appreciated

Grtz Peter

Nov 21 '05 #5
Hi Bernie,

First of all, thnx for your time&help. I know about connection pooling, but
the problem is that some of our users open and close reports all the time
and then when they're up to 20-30 sleeping connections in sql server they
start getting connection timeouts, and they have to reboot the program. But
I was wondering if there isn't a possibility to let crystal reports only use
for example maximum 5 connections or something, because I don't realy want
to shut down connection pooling, because of it's advantages.
thnx again

Peter Proost

"Bernie Yaeger" <be*****@cherwe llinc.com> wrote in message
news:O1******** ******@TK2MSFTN GP15.phx.gbl...
Hi Peter,

It looks like there is a good reason for what you've encountered, and I was aware of it but didn't really observe its behavior before.

The issue is 'connection pooling'. In .net, open connections are pooled and reused, up to a maximum (I believe 100). They really don't hurt anything
and provide for speedy reuse of a connection. If you want to shut it down, you can set pooling = false, but I'm told this is not a good idea. Here's a link that you may find helpful:

http://msdn.microsoft.com/library/de...us/cpguide/htm
l/cpconConnection PoolingForSQLSe rverNETDataProv ider.asp
HTH,

Bernie Yaeger

"Peter Proost" <pp*****@nospam .hotmail.com> wrote in message
news:%2******** ********@TK2MSF TNGP14.phx.gbl. ..
Hi Group,

I've got an interesting problem, I don't know if this is the right group
but
I think so because everything I've read about it so far says it's a .net
problem. Here's the problem, we're using crystal reports 9 and vb.net and we're using the crystalrepotVie wer to show our reports. But every time we open a report the connection to or sql server remains, so if I open 5
forms
with the report viewer I've got 5 sleeping connections in my sql server.
If
I close all 5 forms I still got 5 open connections, and they will not go
away until I close the entire application. The problem with this is that
some user only use the app to print reports so after about an hour or so
they've got 80 sleeping connections. I've tried putting
crystalreportvi ewer1.dispose in the form closing event but this has no
effect. The crviewer also hasn't got a connection.clos e method or
something
like that
Any help would be very much appreciated

Grtz Peter


Nov 21 '05 #6
Hi Bernie,

I wanted to test to set the pooling to false for the reports but I think I
can't set this property for the crystalreportsv iewer connection, because it
seems to me that it manages it's own connections, I only have to pass the
servername, databasename, userid and password to the
CrystalDecision s.Shared.Connec tioninfo
There is CrystalDecision s.Shared.DbConn ectionAttribute s, maybe I can set it
here but I'm not sure how to use it.

Greetz

Peter
"Peter Proost" <pp*****@nospam .hotmail.com> wrote in message
news:eD******** ******@tk2msftn gp13.phx.gbl...
Hi Bernie,

First of all, thnx for your time&help. I know about connection pooling, but the problem is that some of our users open and close reports all the time
and then when they're up to 20-30 sleeping connections in sql server they
start getting connection timeouts, and they have to reboot the program. But I was wondering if there isn't a possibility to let crystal reports only use for example maximum 5 connections or something, because I don't realy want
to shut down connection pooling, because of it's advantages.
thnx again

Peter Proost

"Bernie Yaeger" <be*****@cherwe llinc.com> wrote in message
news:O1******** ******@TK2MSFTN GP15.phx.gbl...
Hi Peter,

It looks like there is a good reason for what you've encountered, and I was
aware of it but didn't really observe its behavior before.

The issue is 'connection pooling'. In .net, open connections are pooled

and
reused, up to a maximum (I believe 100). They really don't hurt anything
and provide for speedy reuse of a connection. If you want to shut it

down,
you can set pooling = false, but I'm told this is not a good idea.

Here's a
link that you may find helpful:

http://msdn.microsoft.com/library/de...us/cpguide/htm l/cpconConnection PoolingForSQLSe rverNETDataProv ider.asp

HTH,

Bernie Yaeger

"Peter Proost" <pp*****@nospam .hotmail.com> wrote in message
news:%2******** ********@TK2MSF TNGP14.phx.gbl. ..
Hi Group,

I've got an interesting problem, I don't know if this is the right group but
I think so because everything I've read about it so far says it's a ..net problem. Here's the problem, we're using crystal reports 9 and vb.net

and we're using the crystalrepotVie wer to show our reports. But every time we open a report the connection to or sql server remains, so if I open 5
forms
with the report viewer I've got 5 sleeping connections in my sql server. If
I close all 5 forms I still got 5 open connections, and they will not go away until I close the entire application. The problem with this is that some user only use the app to print reports so after about an hour or so they've got 80 sleeping connections. I've tried putting
crystalreportvi ewer1.dispose in the form closing event but this has no
effect. The crviewer also hasn't got a connection.clos e method or
something
like that
Any help would be very much appreciated

Grtz Peter



Nov 21 '05 #7
Hi Peter,

Below is a section on connection pooling that might be of value to you. It
indicates ways in which you can customize connection pooling using the
connection object. Try to set some of the parameters and let me know what
happens.

I'm a little concerned, though, about what you said - I'm wondering why your
users are encountering timeout problems and if this is really the result of
sleeping connections - let me know what you discover in this regard.

Bernie
--------------------------
Controlling Connection Pooling with Connection String Keywords
The ConnectionStrin g property of the SqlConnection object supports
connection string key/value pairs that can be used to adjust the behavior of
the connection pooling logic.

The following table describes the ConnectionStrin g values you can use to
adjust connection pooling behavior.

Name Default Description
Connection Lifetime 0 When a connection is returned to the pool, its
creation time is compared with the current time, and the connection is
destroyed if that time span (in seconds) exceeds the value specified by
Connection Lifetime. This is useful in clustered configurations to force
load balancing between a running server and a server just brought online.
A value of zero (0) will cause pooled connections to have the maximum
time-out.

Connection Reset 'true' Determines whether the database connection is
reset when being removed from the pool. For Microsoft SQL Server version
7.0, setting to false avoids making an additional server round trip when
obtaining a connection, but you must be aware that the connection state,
such as database context, is not being reset.
Enlist 'true' When true, the pooler automatically enlists the
connection in the current transaction context of the creation thread if a
transaction context exists.
Max Pool Size 100 The maximum number of connections allowed in the
pool.
Min Pool Size 0 The minimum number of connections maintained in the
pool.
Pooling 'true' When true, the connection is drawn from the appropriate
pool, or if necessary, created and added to the appropriate pool.
"Peter Proost" <pp*****@nospam .hotmail.com> wrote in message
news:%2******** ********@tk2msf tngp13.phx.gbl. ..
Hi Bernie,

I wanted to test to set the pooling to false for the reports but I think I
can't set this property for the crystalreportsv iewer connection, because
it
seems to me that it manages it's own connections, I only have to pass the
servername, databasename, userid and password to the
CrystalDecision s.Shared.Connec tioninfo
There is CrystalDecision s.Shared.DbConn ectionAttribute s, maybe I can set
it
here but I'm not sure how to use it.

Greetz

Peter
"Peter Proost" <pp*****@nospam .hotmail.com> wrote in message
news:eD******** ******@tk2msftn gp13.phx.gbl...
Hi Bernie,

First of all, thnx for your time&help. I know about connection pooling,

but
the problem is that some of our users open and close reports all the time
and then when they're up to 20-30 sleeping connections in sql server they
start getting connection timeouts, and they have to reboot the program.

But
I was wondering if there isn't a possibility to let crystal reports only

use
for example maximum 5 connections or something, because I don't realy
want
to shut down connection pooling, because of it's advantages.
thnx again

Peter Proost

"Bernie Yaeger" <be*****@cherwe llinc.com> wrote in message
news:O1******** ******@TK2MSFTN GP15.phx.gbl...
> Hi Peter,
>
> It looks like there is a good reason for what you've encountered, and I

was
> aware of it but didn't really observe its behavior before.
>
> The issue is 'connection pooling'. In .net, open connections are
> pooled

and
> reused, up to a maximum (I believe 100). They really don't hurt anything > and provide for speedy reuse of a connection. If you want to shut it

down,
> you can set pooling = false, but I'm told this is not a good idea. Here's
a
> link that you may find helpful:
>
>

http://msdn.microsoft.com/library/de...us/cpguide/htm
l/cpconConnection PoolingForSQLSe rverNETDataProv ider.asp
>
> HTH,
>
> Bernie Yaeger
>
> "Peter Proost" <pp*****@nospam .hotmail.com> wrote in message
> news:%2******** ********@TK2MSF TNGP14.phx.gbl. ..
> > Hi Group,
> >
> > I've got an interesting problem, I don't know if this is the right

group > > but
> > I think so because everything I've read about it so far says it's a .net > > problem. Here's the problem, we're using crystal reports 9 and vb.net

and
> > we're using the crystalrepotVie wer to show our reports. But every
> > time

we
> > open a report the connection to or sql server remains, so if I open 5
> > forms
> > with the report viewer I've got 5 sleeping connections in my sql server. > > If
> > I close all 5 forms I still got 5 open connections, and they will not go > > away until I close the entire application. The problem with this is that > > some user only use the app to print reports so after about an hour or so > > they've got 80 sleeping connections. I've tried putting
> > crystalreportvi ewer1.dispose in the form closing event but this has
> > no
> > effect. The crviewer also hasn't got a connection.clos e method or
> > something
> > like that
> > Any help would be very much appreciated
> >
> > Grtz Peter
> >
> >
>
>



Nov 21 '05 #8
Hi Peter,

Below is a section on connection pooling that might be of value to you. It
indicates ways in which you can customize connection pooling using the
connection object. Try to set some of the parameters and let me know what
happens.

I'm a little concerned, though, about what you said - I'm wondering why your
users are encountering timeout problems and if this is really the result of
sleeping connections - let me know what you discover in this regard.

Bernie
--------------------------
Controlling Connection Pooling with Connection String Keywords
The ConnectionStrin g property of the SqlConnection object supports
connection string key/value pairs that can be used to adjust the behavior of
the connection pooling logic.

The following table describes the ConnectionStrin g values you can use to
adjust connection pooling behavior.

Name Default Description
Connection Lifetime 0 When a connection is returned to the pool, its
creation time is compared with the current time, and the connection is
destroyed if that time span (in seconds) exceeds the value specified by
Connection Lifetime. This is useful in clustered configurations to force
load balancing between a running server and a server just brought online.
A value of zero (0) will cause pooled connections to have the maximum
time-out.

Connection Reset 'true' Determines whether the database connection is
reset when being removed from the pool. For Microsoft SQL Server version
7.0, setting to false avoids making an additional server round trip when
obtaining a connection, but you must be aware that the connection state,
such as database context, is not being reset.
Enlist 'true' When true, the pooler automatically enlists the
connection in the current transaction context of the creation thread if a
transaction context exists.
Max Pool Size 100 The maximum number of connections allowed in the
pool.
Min Pool Size 0 The minimum number of connections maintained in the
pool.
Pooling 'true' When true, the connection is drawn from the appropriate
pool, or if necessary, created and added to the appropriate pool.
"Peter Proost" <pp*****@nospam .hotmail.com> wrote in message
news:%2******** ********@tk2msf tngp13.phx.gbl. ..
Hi Bernie,

I wanted to test to set the pooling to false for the reports but I think I
can't set this property for the crystalreportsv iewer connection, because
it
seems to me that it manages it's own connections, I only have to pass the
servername, databasename, userid and password to the
CrystalDecision s.Shared.Connec tioninfo
There is CrystalDecision s.Shared.DbConn ectionAttribute s, maybe I can set
it
here but I'm not sure how to use it.

Greetz

Peter
"Peter Proost" <pp*****@nospam .hotmail.com> wrote in message
news:eD******** ******@tk2msftn gp13.phx.gbl...
Hi Bernie,

First of all, thnx for your time&help. I know about connection pooling,

but
the problem is that some of our users open and close reports all the time
and then when they're up to 20-30 sleeping connections in sql server they
start getting connection timeouts, and they have to reboot the program.

But
I was wondering if there isn't a possibility to let crystal reports only

use
for example maximum 5 connections or something, because I don't realy
want
to shut down connection pooling, because of it's advantages.
thnx again

Peter Proost

"Bernie Yaeger" <be*****@cherwe llinc.com> wrote in message
news:O1******** ******@TK2MSFTN GP15.phx.gbl...
> Hi Peter,
>
> It looks like there is a good reason for what you've encountered, and I

was
> aware of it but didn't really observe its behavior before.
>
> The issue is 'connection pooling'. In .net, open connections are
> pooled

and
> reused, up to a maximum (I believe 100). They really don't hurt anything > and provide for speedy reuse of a connection. If you want to shut it

down,
> you can set pooling = false, but I'm told this is not a good idea. Here's
a
> link that you may find helpful:
>
>

http://msdn.microsoft.com/library/de...us/cpguide/htm
l/cpconConnection PoolingForSQLSe rverNETDataProv ider.asp
>
> HTH,
>
> Bernie Yaeger
>
> "Peter Proost" <pp*****@nospam .hotmail.com> wrote in message
> news:%2******** ********@TK2MSF TNGP14.phx.gbl. ..
> > Hi Group,
> >
> > I've got an interesting problem, I don't know if this is the right

group > > but
> > I think so because everything I've read about it so far says it's a .net > > problem. Here's the problem, we're using crystal reports 9 and vb.net

and
> > we're using the crystalrepotVie wer to show our reports. But every
> > time

we
> > open a report the connection to or sql server remains, so if I open 5
> > forms
> > with the report viewer I've got 5 sleeping connections in my sql server. > > If
> > I close all 5 forms I still got 5 open connections, and they will not go > > away until I close the entire application. The problem with this is that > > some user only use the app to print reports so after about an hour or so > > they've got 80 sleeping connections. I've tried putting
> > crystalreportvi ewer1.dispose in the form closing event but this has
> > no
> > effect. The crviewer also hasn't got a connection.clos e method or
> > something
> > like that
> > Any help would be very much appreciated
> >
> > Grtz Peter
> >
> >
>
>



Nov 21 '05 #9
Hi Peter,

I now see that getting to the viewer's connection object might not be
possible, so my advice doesn't serve any purpose; I will continue to look
into this to see if it's possible.

Bernie

"Peter Proost" <pp*****@nospam .hotmail.com> wrote in message
news:%2******** ********@tk2msf tngp13.phx.gbl. ..
Hi Bernie,

I wanted to test to set the pooling to false for the reports but I think I
can't set this property for the crystalreportsv iewer connection, because
it
seems to me that it manages it's own connections, I only have to pass the
servername, databasename, userid and password to the
CrystalDecision s.Shared.Connec tioninfo
There is CrystalDecision s.Shared.DbConn ectionAttribute s, maybe I can set
it
here but I'm not sure how to use it.

Greetz

Peter
"Peter Proost" <pp*****@nospam .hotmail.com> wrote in message
news:eD******** ******@tk2msftn gp13.phx.gbl...
Hi Bernie,

First of all, thnx for your time&help. I know about connection pooling,

but
the problem is that some of our users open and close reports all the time
and then when they're up to 20-30 sleeping connections in sql server they
start getting connection timeouts, and they have to reboot the program.

But
I was wondering if there isn't a possibility to let crystal reports only

use
for example maximum 5 connections or something, because I don't realy
want
to shut down connection pooling, because of it's advantages.
thnx again

Peter Proost

"Bernie Yaeger" <be*****@cherwe llinc.com> wrote in message
news:O1******** ******@TK2MSFTN GP15.phx.gbl...
> Hi Peter,
>
> It looks like there is a good reason for what you've encountered, and I

was
> aware of it but didn't really observe its behavior before.
>
> The issue is 'connection pooling'. In .net, open connections are
> pooled

and
> reused, up to a maximum (I believe 100). They really don't hurt anything > and provide for speedy reuse of a connection. If you want to shut it

down,
> you can set pooling = false, but I'm told this is not a good idea. Here's
a
> link that you may find helpful:
>
>

http://msdn.microsoft.com/library/de...us/cpguide/htm
l/cpconConnection PoolingForSQLSe rverNETDataProv ider.asp
>
> HTH,
>
> Bernie Yaeger
>
> "Peter Proost" <pp*****@nospam .hotmail.com> wrote in message
> news:%2******** ********@TK2MSF TNGP14.phx.gbl. ..
> > Hi Group,
> >
> > I've got an interesting problem, I don't know if this is the right

group > > but
> > I think so because everything I've read about it so far says it's a .net > > problem. Here's the problem, we're using crystal reports 9 and vb.net

and
> > we're using the crystalrepotVie wer to show our reports. But every
> > time

we
> > open a report the connection to or sql server remains, so if I open 5
> > forms
> > with the report viewer I've got 5 sleeping connections in my sql server. > > If
> > I close all 5 forms I still got 5 open connections, and they will not go > > away until I close the entire application. The problem with this is that > > some user only use the app to print reports so after about an hour or so > > they've got 80 sleeping connections. I've tried putting
> > crystalreportvi ewer1.dispose in the form closing event but this has
> > no
> > effect. The crviewer also hasn't got a connection.clos e method or
> > something
> > like that
> > Any help would be very much appreciated
> >
> > Grtz Peter
> >
> >
>
>



Nov 21 '05 #10

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

0
1247
by: Stedak | last post by:
We are new to crystal reports. When our WinForms application is distributed to our clients are the ODBC connections required to be entered throught the ODBC administrator or is there another way to do it? or how do we programatically add a database connection to Crystal reports?
0
1092
by: Stedak | last post by:
We are new to crystal reports. When our WinForms application is distributed to our clients are the ODBC connections required to be entered throught the ODBC administrator or is there another way to do it? or how do we programatically add a database connection to Crystal reports?
0
1820
by: Mikko Pulkkinen | last post by:
Hi, I'm trying to use Crystal Reports to generate reports from an Access database. I'm using VS2003 and C#. I need to select the database the report uses as data source at runtime. The database does not have any password protection. I've tried using ODBC connections, but all I get is logon errors. It seems that I should be able to pass a connection string in
3
2883
by: Shawn H. Mesiatowsky | last post by:
I have come across lots of information regarding this, but nothing seems to work. I have created a Crystal Report that access's a SQL server backend for the data, and I want to display the report via a webform and the CrystalViewer Web Component. First of all, I have been using Trusted Connections so far (for data access) and really do not want to have some static login information in my web app. but most of the documents so far have...
7
4426
by: John | last post by:
I am using Crystal Reports in my application I made using Visual Studio.NET. I installed my application on the client machine, with all the DLLs required(added the merge modules), the engine and the rest. When I start my application and, from it, try to open up a report I get an exception "Query engine error: C:\WINDOWS\Temp\temp_*******.rpt" with some wierd numbers instead of *******. Can anyone tell me what the problem is here and how to...
0
1297
by: Crash | last post by:
Windows XP C# .NET 2.0 Crystal Reports v10 I have an application that has 30+ Crystal Reports. Due to bad planning {not by me} the database connection settings are hard coded into each report. We tried to set database connection information at runtime just before executing the report but that didn't work. I do not have the budget
2
1449
by: Tony K | last post by:
Getting the former. Not the latter. As some of you may know (Terry...btw thanks for all your help), I have been battling a Crystal Reports problem. I have recently made the discovery that my "Current Connections" or ADO.NET options for the database expert in CR are not working with my project. IF I create a new connection to my Access DB(DAO) or use OLE DB(ADO) connection I will receive correct data (results) on my report for the...
8
3085
by: Brock | last post by:
I am trying to populate a Crystal Report from data in my DataGrid. The reason for this is that I want the user to be able to change values without updating the database, but still have their report reflect the values they anticipate committing to see hypothetical totals of columns from a set of records. These records are displaying properly on my DataGrid but I'm not sure how to get Crystal Reports 10 to use as its datasource the dataset...
1
1478
by: jimjim | last post by:
Hi, When I try t run an aspx page which has crystal reports code in one section of the .vb code behind page, it gives following error. "A Crystal Reports job failed because a free license could not be obtained in the time allocated. More licenses can be purchased direct from Crystal Decisions or through the Crystal Decisions Online Store. " ALSO REPORT PATH IS NOT GETTING RECOGNIZED. i HAVE HIGHLIGHTED IT BELOW. CONNECTIONS ARE FINE....
0
8969
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...
0
8794
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
0
9483
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
0
9341
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
0
9211
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
0
8216
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
0
4572
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
2
2748
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
3
2195
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.