OK, I been playing around with Crystal Reports for months, and
successfully solved problems with sql server.

But now I'm using crystal reports with Access, and I can't get the
damn thing to work - it's really frustrating.

I'm using Crystal reports application and reports to set location,
database, etc. at runtime, but I keep getting "Server not yet opened"
message.  I've tried messing with DSNs, but i'm not sure i'm doing it
correctly.  Here's my code:

For i = 1 To crxReport.Database.Tables.Count
        crxReport.Database.Tables(i).SetLogOnInfo App.Path &
"\Emdcs.dsn", App.Path & "\db\Emdcs.mdb", "admin", ""
Next i
crxApplication.LogOnServer "pdsodbc.DLL", App.Path & "\Emdcs.dsn",
App.Path & "\db\Emdcs.mdb", "admin", ""

I tried changing dsn location to my server name, using
"Setsessioninfo", and even leaving some parameters blank to use
default values.  But nothing works.  The error always occurs when I
try to use LogOnServer event of application.  Setting the reports
logoninfo doesn't yield an error.

Any ideas??

Hi Andrew,

| OK, I been playing around with crystal reports for months,
| and successfully solved problems with sql server.
|
| But now I'm using crystal reports with Access, and I
| can't get the damn thing to work - it's really frustrating.

Have seen this article already?:

Troubleshooting the error "Server Not Yet Opened" when using the RDC
< http://support.crystaldecisions.com/library/kbase/articles/c2002649.asp >

if this one doesn't help, try searching for "Server Not Yet Opened" at:
< http://support.crystaldecisions.com/library/kbase.asp >

--
Abra?os,
Lobo.
http://www.FatorX.com.br