Crystal XI pulling my hair out

[thefox149]

a Few issues and I can't find any infor

I have an Access 2000 database using the activex viewer

All works well when run on the local hard drive when moving to netwrok drive I get Log on failure or unable to provide free license in time

I know there is a fix for the license but it only applies to .net.

The database is unsecured

we use windows 2000 and I would guess there would be some sort of permission or limitation over the network. I cannot find any RDC documentation.

I am really having my fill with Crytal now what good is it if I can't enpower the end user

here is my code:

Me.CrystalReport1.Visible = True

Set crxReport = crxApplication.OpenReport(strPath & "\SummaryReport.rpt")

have played with this
'With crxReport.Database.Tables(1).ConnectionProperties
'.Item("Session UserID") = ""
'.Item("Session Password") = ""
'End With


'accessing the database and reading records
crxReport.ReadRecords
'Setting the ReportSource of the CrViewer control to the Report object
Me!CrystalReport1.ReportSource = crxReport
'view the report.
Me!CrystalReport1.ViewReport
'Setting the zoom = 80%
CrystalReport1.Zoom (75)
'default mouse pointer
'do events first before continuing in order to avoid application crashes
While Me!CrystalReport1.IsBusy
DoEvents
Wend

 

[vidru]

What type of connectivity are you using - ODBC, OLEDB, Native, etc?

Download the whitepaper on ConnectionProperties, and you should find your answer:

http://support.businessobjects.com/communityCS/TechnicalPapers/cr_rdc9_connectionproperties.pdf.asp

-dave

 

[synapsevampire]

Also try using the UNC naming instead of a mapped drive.

\\machine name\path...

as opposed to

G:\path...

 

[thefox149]

I am using native have played with ODBC same erros occuring the white paper has some interesting things that i will be checking out today

I have played with UNC and will need to read more about it

 

[thefox149]

anyone one had issues running the activex over a novell network

 

[chelseatech]

If it is using a windows service to view and run the report, it will not be able to see any mapped drives or anything on them.

This problem appeared with Seagate Info 7 and is still around. It is a windows service problem, and not a crystal problem. It only happens with file databases and not with client server databases.

The Access ODBC driver requires a mapped drive so you will need to migrate your access report to a database driver and use a UNC path to the MDB file.

Editor and Publisher of Crystal Clear

http://www.chelseatech.co.nz/pubs.htm

 

[thefox149]

Could you expand on this..??

"The Access ODBC driver requires a mapped drive so you will need to migrate your access report to a database driver and use a UNC path to the MDB file. "

A mapped drive being a network folder?
Migrate your access report??
...are you refering to the rpt file or the mdb ??

 

[chelseatech]

When you use the ODBC tool in the windows control panel to create a new DSN, you can select the database using the MS-Access driver.

The database selection screen lists all the drives on your machine. If you have a mapped drive, it will appear but you can't search the network. However, as I said earlier, mapped drives aren't visible to a service.

So if you want to report from a Access database on a remote machine, use a Database data source rather than ODBC. Then you can locate your MDB using a \\server\share path and your windows service can also see it properly.

Editor and Publisher of Crystal Clear

http://www.chelseatech.co.nz/pubs.htm

 

[thefox149]

How do I create this database data source?? If i understand correctly i DON'T do it from the administrative tools|Data Sources (ODBC).

This database is not a complicated one and only 1 or 2 users. locally this works fine however the moment you put it on the network it works once then gives me a log on failure..I would have thought that the active x some how is losing the connection information....

 

[chelseatech]

Create a new report using the "Database" source for your report. Locate the database using the "Network Places" to find the server and share where your MDB is located. Do NOT use a mapped drive to find it.

Open your original report and use "Set Location" to move each table to the same source as your new report. You do this by selecting a table in the bottom of the screen, find the matching table in the top portion and click the "Update" button.

Check the original report still works, and then do the same to any other reports using the same approach.

Editor and Publisher of Crystal Clear

http://www.chelseatech.co.nz/pubs.htm