Link to home
Start Free TrialLog in
Avatar of pramodkumar
pramodkumarFlag for India

asked on

VB, Oracle and Crystal Reports.......URGENT !!!!!

hi experts,

i'm using crystal reports ver 4.5 for reports with VB as front end and oracle as back end.  I connect with a microsoft userconnection object to oracle and perform all the sql operations. While generating the reports using the crystal Reports ocx, the method LogOnServer works fine. I use LogOffServer method in the next line, once i display the needed report as below,

CRpt.LogOffServer (connID, False)

But the vb compiler displays a message as "Expected:=" . But i'm sure that LogOffServer is not a Function but a sub and no return value can be obtained.
My versions are Crystal Report 4.5, Vb 6, oracle 8.
Please help me.......and this is urgent.

thanx in advance

Avatar of aikimark
aikimark
Flag of United States of America image

try:

CRpt.LogOffServer connID, False

or

Call CRpt.LogOffServer (connID, False)
Please attend to your open questions.
Avatar of pramodkumar

ASKER

hi aikimark,
thanx for responding

>>try:

>>CRpt.LogOffServer connID, False

already tried that...doesn't work


Getting problem with LogOnSever now. Can please tell me the ".dll" file i have to use with this?
"pdsodbc.dll" gets me the error "unable to logon to server"

i'm using oracle as backend
waiting for answer...
thank you


I recommend reinstalling Crystal Reports.  All the DLLs you need will be installed.

Did I answer your original question?
even tried that for no use...
is that a bug in 4.5 version???????
What problem are you getting with Logonserver?
ok aikmark, i've installed Crystal Reports 7 and no probs with logonserver, i can log on to oracle db but i get an error with,

Crpt.Action=1

while called this report, i get a flash view of the report but get an error.The error says something like "report is read only"

can u please help me with this one please?
Does it mean that the report file (.rpt) is read only?

Can you see the report?

Do you get the error messsage when you are doinging something to the report preview?
Does it mean that the report file (.rpt) is read only?
>>>OOOOps i'm very sorry aikimark, it is reverse, i mean the error says "field is write only"

Can you see the report?
>>> i can only see the report for a second and this error appears

Do you get the error messsage when you are doinging something to the report preview?
>>>>> no, i don't get any error in preview mode
Your problem is stumping me.  Please list the VB code that sets/accesses the CRW properties, both before and after the .Action=1 statement.
oops, sorry if i'm troubling you...
this is how i've tried so far

conID% = crpt.LogOnServer("pdsodbc.dll","mydsn","","username","pass")
crpt.Action = 1
call crpt.LogOffServer(connID,False)

i write above code mnu_Report_Click() sub, i mean i need to get the report when the menu item is clicked.

But remember, i'm already connected to the DB using an user connection and it is active.

i get error at LogOffServer, when the application is run at most of the time as it cannot Log Off from the server after showing the report, as there is an active connection(user connection).




I've written as LogOffServer(connID%,True) - here there is an error while writing to you
try:

crpt.LogOffServer("pdsodbc.dll", "mydsn")
crpt.LogOffServer takes 2 parameters -
LogOffServer(connectionID reutrned by the LogOnServer, Bool value for logging off all active connections (True) or only the connection indiacated by the connectionID (False))
is that right????????

will the code given by you will work?????? anyway i'll try that for u.....
and need not worry about your marks......i'll may also give more than 150 !!!
thanx for staying with my question for such a long time....
ASKER CERTIFIED SOLUTION
Avatar of aikimark
aikimark
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
though i could not solve my problem, i got valuable info regarding my question. Thanx for staying for a long time with my question, i'm awarding you 100 points for your help...if needed my mail is kpramodrai@hotmail.com
thax a lot !!!
bye

pramod