cannot open sql server - Calling Crystal reports in VB

[Guest_imported]

Hello everyone,

I am using a Oracle stored procedure in crystal report. the same is called from a vb program. It is giving the following errors:
1)run-time error 20534 --- error detected by database dll. -- this error is occuring when using "connect"

2)run-time error 20599 -- cannot open sql server -- this error is occuring when using "logonserver using pdsora7.dll"

3) run-time error 20536 -- unable to logon to server -- this error is occuring when using "logonserver using pdsodbc.dll"

the source code of vb program is shown below.
-------------
With cr1
.Connect = "dsn=vnb;uid=vnb;pwd=zyx"
'.LogOnServer "pdsora7.dll", "vpt", "", "vnb", "zyx"
'.LogOnServer "pdsodbc.dll", "vpt", "", "vnb", "zyx"
.StoredProcParam(0) = "1"
.ReportFileName = "c:\reptest\test_report.rpt"
.Action = 1
End With

--------------


Please suggest what to do?

Sudha malathi

 

[srimoti]

Hi,

Thats the problem might be with the DLLs. Make sure that you have version of DLLs which supports stored procedures. Search for the correct version in KB of crystal decisions and you will find it. I dont exactly remember the KB article number. Let me know if you still not able to work it out.