Celebrate National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

DataReport can't print on different PC

Posted on 2002-03-04
13
Medium Priority
?
153 Views
Last Modified: 2011-09-20
Hello all,

Could someone help me on my problem...  I have been at it for 2 days now...

On my Win 2000 machine, my program is running well.  I can print all my reports.  The problem is when i run the program in another PC, only some reports can be printed.
Im using a data environment as a source for my reports.

Anyone have ideas?

Thanks
0
Comment
Question by:3Mann
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 6
  • 3
  • 2
  • +2
13 Comments
 
LVL 53

Expert Comment

by:Ryan Chong
ID: 6838633
Hi,

What's the message you get when you cannot print the reports?
0
 
LVL 1

Author Comment

by:3Mann
ID: 6838660
various...

I use an "on error resume next" but i log the error on function end.

These are the various errors i get:
Win NT: error 3705
Win 9x: error 380

3705 also occurs on my machine(2000) but it can still print having the "on error resume next"

Some explanation on my error:
3705: I modify the connectionstring on an open connection
380: Same line, modifying the connectionstring
0
 
LVL 22

Expert Comment

by:Mohammed Nasman
ID: 6838705
Hello

  are you sure that the lastest MDAC installed on nt and win 9x?, the MDAC came with newer versions of windows, like win 2000/XP and ME
0
Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
LVL 1

Author Comment

by:3Mann
ID: 6838741
well, i'm using MDAC 2.6 (w/o SP) on my Win2000 machine.  I've also installed the same version on Win NT and 9x.
0
 
LVL 53

Expert Comment

by:Ryan Chong
ID: 6838761
> I modify the connectionstring on an open connection
Make sure you close your Connection (myConn.Close) before you reopen/modify it. and Why you want to modify an open connection?

Do you have some codes in Data Environment or Data Report?

regards
0
 
LVL 70

Expert Comment

by:Éric Moreau
ID: 6838791
0
 
LVL 1

Author Comment

by:3Mann
ID: 6838815
ryancys,
I do that 'cause if I don't do it, a login screen will pop up on the different pc.. the one where it asks for a user name and password to connect to the datasource... actually, i tried using this code:
  if myconn.state<>0 then myconn.close
before calling myconn.open sConnectionString, but i found it still has the same error so i just returned to my old code w/c was modifying the connectionstring directly...
bad idea?

I have no codes in both DE and DR...

emoreau,
i'll check the link... thanks...
0
 
LVL 1

Author Comment

by:3Mann
ID: 6838833
emoreau,
The link explains about err 3705 when setting .ActiveConnection property.  Im not using that property, so i guess thats not the cause.  My problem is actually more on the printing.

I have tried doing below:
  if conn.state<>0 then conn.close
  conn.open sConnectionString
  'set command
  'call datareport

Using the above code, 3705 is gone on my PC and on the others as well.  No other error on my Win2000 but error 380: Invalid property value is logged on the other machines.  This i believe does the no-printing.  380 is raised when opening the connection.
0
 
LVL 1

Author Comment

by:3Mann
ID: 6841020
Hi guys, just an update...
i just found out the reason for my problem...
The printouts take its data from a parameterized command in a data environment...
Well, the param i used is a date.  Just so happens that date format vary on different machines.

And all the while I was putting the blame on the datareport.  Thanks for the help guys.
0
 
LVL 70

Expert Comment

by:Éric Moreau
ID: 6843199
ask the community support to refund your points and move this question to PAQ
0
 
LVL 1

Author Comment

by:3Mann
ID: 6844018
thanks, but how do i do that?
0
 
LVL 70

Expert Comment

by:Éric Moreau
ID: 6845732
ask a 0 point question at
http://www.experts-exchange.com/jsp/qList.jsp?ta=commspt and refer this question

0
 

Accepted Solution

by:
ComTech earned 0 total points
ID: 6847429
As per CS request, this question will be placed in PAQ and points have been refunded.

Best regards,
ComTech
CS Admin @ EE
0

Featured Post

On Demand Webinar - Networking for the Cloud Era

This webinar discusses:
-Common barriers companies experience when moving to the cloud
-How SD-WAN changes the way we look at networks
-Best practices customers should employ moving forward with cloud migration
-What happens behind the scenes of SteelConnect’s one-click button

Question has a verified solution.

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

Introduction While answering a recent question (http://www.experts-exchange.com/Q_27402310.html) in the VB classic zone, I wrote some VB code in the (Office) VBA environment, rather than fire up my older PC.  I didn't post completely correct code o…
Have you ever wanted to restrict the users input in a textbox to numbers, and while doing that make sure that they can't 'cheat' by pasting in non-numeric text? Of course you can do that with code you write yourself but it's tedious and error-prone …
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 Outlook using automation, Microsoft Access can control other applications. An example is the ability to programmatically talk to Microsoft Outlook. Using automation, an Access applic…
Suggested Courses

730 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