3Mann
asked on
DataReport can't print on different PC
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
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
ASKER
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
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
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
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
ASKER
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.
> 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
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
Is it your case: http://support.microsoft.com/default.aspx?scid=kb;en-us;Q275927
ASKER
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...
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...
ASKER
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.
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.
ASKER
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.
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.
ask the community support to refund your points and move this question to PAQ
ASKER
thanks, but how do i do that?
ask a 0 point question at
https://www.experts-exchange.com/jsp/qList.jsp?ta=commspt and refer this question
https://www.experts-exchange.com/jsp/qList.jsp?ta=commspt and refer this question
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
What's the message you get when you cannot print the reports?