Solved

using adodb connection while calling crystal report

Posted on 2002-04-15
7
280 Views
Last Modified: 2008-03-17
Hi All,
    I am having a connection, opened in  my VB project.When i am calling the crystal report,It's loading
very slowly. In The crystal .rpt file,I am calling a stored procedure with maximum of 10 parameters.

     Is it slow,because of the crystal report  connection?.
     If is it so,How can i use the same dsnless
connection in my project?

Thanks in advance
Sri Prabha
0
Comment
Question by:Sriprabha
  • 4
  • 3
7 Comments
 

Accepted Solution

by:
VBMeera earned 60 total points
ID: 6944067
did u check that this happen with .rpt file only?
or else ur m/C is slow?
coz crystal report is not supposed to slow?
try below
1. if ur SP is having 10 or more parameter check .rpt using one parameter?
2. Try to execute u r SP in Query Analyser


0
 

Author Comment

by:Sriprabha
ID: 6944385
Hi vbmeera,
       Crystal report Parameter field accepts only 255 chars.But I am sending the Query which is Dynamically generated according to the Multiselect listbox in my VB form.It will surely exceed 1500 chars.I can't reduce the no of parameters.
       one more thing.While executing the stored procedure through the query analyzer it's pretty fast only.
       The above one is my requirement.But I am having the
doubt that whether there is a method to use the connection in VB which is already created.Is there any methodfor this.

Thanks for u'r response

Regards
Sriprabha.

0
 

Expert Comment

by:VBMeera
ID: 6944404
hey do one thing,
send me u r SP code which u used thr VB.
i will thing u r creating parameter ,appending it
am i right?
it might conflicting u r datatypes?
send those 4-5 lines where actual call for SP
0
Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

 

Author Comment

by:Sriprabha
ID: 6944426
Thanks for u'r immediate response.

     While Running through the query analyzer it's fast enough only.While calling the stored procedure in the crystal report,during the first time it's slow.I am very much sure that there is no problem in my SP.

     You just tell me that,whether there is a way to use the connection created in vb.

Regards,
Sriprabha

0
 

Expert Comment

by:VBMeera
ID: 6944464
hey ,
i am not telling u that there is pro in ur SP what i am trying to tell u that while calling thr vb u r passing parameter to ur SP and then u r getting O/P as .rpt file.
so do pass parameter u need to creat it and then append that parameter ,isn't it?
design .rpt file is one task and call that rpt file thr vb is different.(this what i
create object connection,command and Recordset object  
and call SP using Command
if u need code tell me
okay.
0
 

Author Comment

by:Sriprabha
ID: 6944484
I know that vbmeera.

    I have created the .rpt file.While creating it,i have opted SQL-ODBC dsn connection.
    I am calling the SP with the command object only.

     Because mine is a multiuser project the connection will open for the every first call of the .rpt file  .This may slow down the SQL sever.
      My argument is that,Already one connection is there.Why can't we use that one?.It will increase the speed of the application.

Thanks for u'r response

Regards
Prabha
0
 

Author Comment

by:Sriprabha
ID: 6944485
I know that vbmeera.

    I have created the .rpt file.While creating it,i have opted SQL-ODBC dsn connection.
    I am calling the SP with the command object only.

     Because mine is a multiuser project the connection will open for the every first call of the .rpt file  .This may slow down the SQL sever.
      My argument is that,Already one connection is there.Why can't we use that one?.It will increase the speed of the application.

Thanks for u'r response

Regards
Prabha
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
vba find the last empty column 10 88
Reading the Contents of a Directory In Access VBA 5 58
how to know if my Checkbox is True in VB6.0? 9 40
Child Form in front 4 38
Article by: Martin
Here are a few simple, working, games that you can use as-is or as the basis for your own games. Tic-Tac-Toe This is one of the simplest of all games.   The game allows for a choice of who goes first and keeps track of the number of wins for…
I was working on a PowerPoint add-in the other day and a client asked me "can you implement a feature which processes a chart when it's pasted into a slide from another deck?". It got me wondering how to hook into built-in ribbon events in Office.
As developers, we are not limited to the functions provided by the VBA language. In addition, we can call the functions that are part of the Windows operating system. These functions are part of the Windows API (Application Programming Interface). U…
Get people started with the process of using Access VBA to control Excel using automation, Microsoft Access can control other applications. An example is the ability to programmatically talk to Excel. Using automation, an Access application can laun…

920 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

16 Experts available now in Live!

Get 1:1 Help Now