asked on

Crystal Reports Question

I'm using the activeX Crystal reports component to access a sql server (6.5).

This code was already in the project:

MDIForm1.CrystalReport1.LogOffServer 1, True
MDIForm1.CrystalReport1.LogonInfo(0) = "DSN=" & MDIForm1.Server & _
' ";uid=;pwd=;database=" & MDIForm1.Database

MDIForm1.CrystalReport1.WindowState = crptMaximized
MDIForm1.CrystalReport1.Action = 1

where mdiform1.server = "serverName"
and mdiform1.database = "databasename"

We are now changing to sql server 7 and this no longer works.
Where can I find info on how this connection string should read?
I tried setting it up like the database connection:

.ConnectionString = "DRIVER={SQL Server};DATABASE=" & mconstDatabase & _
";SERVER=" & mconstServer

Any suggestions?

eab111098

it may not be the code but rather the crystal report itself. i have no experience with CR and SQl x.x, however, i do have experience with CR and access and i know that when the db changes in anyway, that cr will not print it and you get some component error that is of little use and points you in no particular direction. to fix this, go to the CR report and reverify your database. you can find it under the database menu item in the designer window.

if this doesn't do the trick, i know that seagate has a bulletin board set up on their web site for q&a. sorry don't know the address off hand. just go to the seagate web site. there's a link to from there.

hope this helps.
ed.

rutledgj

ASKER

I've already verified database, its ok. Couldn't find anything on seagates knowledge base either

ASKER CERTIFIED SOLUTION

svenkatapuram

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial