OBDC Error (Join Operators)

[dperk]

Hello, I'm very new to Crystal Reports. I was put into the fire you can say to correct an issue. Our reports were created by an individual who is no longer an employee. Our IT department then had to reconfigure my computer which took off the crystal reports. I have re-installed Crystal Reports 8.0 and loaded the copy of the report we used. The report worked the very first time, giving a clean report. The next day all of a sudden it gives this error:

OBDC error(Microsoft)(ODBC SQL Server Driver)(SQL Server) Cannot specify outer join operators in a query containing join tables. View MP260s.dbo.WOCOSTH contains ourter join operators.

Our database is MP260S I am only working with two tables from our SQL 7 database.
WO which is Work Orders
WOCOSTH which is work order costs. Parts,Vendor,Labor,Total Cost

If I set up a report with just WO It will work giving me the account #, date, and invoice #. But as soon as I add just one section in WOCOSTH example: Total Cost it gives me that error.

I have made sure the links are good with the 2 tables:
It gave me 3 links: SiteID,WO,CloseDate


Any Help with this issue would be a greatful!! I've been reading the Crystals Users Guide to no advail. I will also try to search the messageboard for any clues.

Thanks In advance!

Dave

 

[dperk]

Ok, I found the problem!!!!!!! What HEADACHE it was figuring this out!!

This seems to be caused by P2SODBC.DLL file not being in the Crystal Report Directory.

Do a Search, for it, Probably in the windows/systems folder Copy it and paste it in the Crystal Report Directory! And BAM! no more outer Join Operator errors!!!

I think Im going to take tomorrow off!!! Yea!!