crystal reports XI on 64 bit windows 7

[kims212]

I have just 'upgraded' to a 64 bit windows desktop and downloaded and installed a version of Crystal Reports that I was told would work on my machine.

It does in fact work but reports that used to run on my xp machine are taking A LOT longer to run. The reports that I'm referring to connect to a server in another city and are ones that contain quite a few sub-reports.

Frequently, when runing the reports - I am assuming that it is on the execution of each sub-report - I get an error message that states:

logon failed.
Details: ADO Error Code: 0x80004005
Source: Microsoft OLE DB Provider for SQL Server
Description: [DBNETLIB][ConnectionOpen (Connect()]SQL Server does not exist or access denied.
SQL State: 08001
Native Error: 17

I click OK and then it asks me for the server and password. Sometimes it displays the correct server but sometimes it reverts to a server that doesn't exist. On the drop down list, the server isn't listed and has to be typed in each time.

This all used to work fine on my xp machine and the reports with several sub-reports took only a few minutes - less time than when they are running in production - but that's another story.

At someone's suggestion, I ran the odbcad32.exe and added the system DSN for the server and the test connection works just fine.

If anyone can offer me any suggestions for something to try or a direction to take, I would be most grateful.

Thanks for reading (I know I can be a bit wordy - it's congenital.)

 

[lbass]

From what I have read, there are apparently two odbcad32.exe files in Windows 7 64-bit. Make sure the one you use is from:

C:\Windows\SysWOW64\odbcad32.exe

Not sure this will address the issue.

-LB

 

[kims212]

Thanks LB - you're so prompt.

Alas, that is the one that I ran - it's the only one that I have.

ks212

P.S. Please tell me that 64 bit machines have a built-in April 1st trigger, that this is just a big joke and it will all be fine tomorrow. I'm having trouble in sql server management studio and excel download from the same database from which I'm trying to run the crystal report.

 

[lbass]

You've probably already searched the web, but in case it helps:

http://tutorials.aspfaq.com/8000xxxxx-errors/80004005-errors.html

http://support.microsoft.com/kb/328306/en-us

-LB

 

[kims212]

Thanks again LB.

It turns out that I had entered the address missing a dot between numbers in the IP address - you'd think that that would be the first thing that I checked - and the correct address works fine.

The processing speed is still a huge problem and it seems to affect running queries on the sql server management studio. I think that it has something to do with my connections settings but a lot of this is rather beyond me and often, when an article refers to something I don't actually know what it means.

If you have any ideas about a setting that would cause my access to the database to run slowly, I'd be very happy to know.

Thanks
kims212

 

[lbass]

This is beyond me, too, really. Ordinarily I would say try different drivers (native, if possible), but I'm not sure what your options are with a system dsn and I haven't worked with SQL Server either. Maybe someone else will jump in.

-LB

 

[kims212]

Thanks LB.

It would be great if someone else would weigh in but I also have a call out to a techie who knows WAY more about these things than I, which is almost nothing.

kim