BOB: Business Objects Board
Not endorsed by or affiliated with SAP

Register | Login 

Follow BOB on Twitter! 
Follow BOB on Twitter! (Opens a new window)  

General Notice: BOB is going to retire...please see details here.
General Notice: No events within the next 45 days.

old reports not running post sql upgrade


 
Search this topic... | Search General Discussion... | Search Box
Register or Login to Post    Forum Index -> General Discussion  Previous TopicPrint TopicNext Topic
Author Message
yddraig
Forum Member
Forum Member



Joined: 13 May 2008

Posts: 3



PostPosted: Mon Jul 15, 2019 7:19 am 
Post subject: old reports not running post sql upgrade

Hi,
If i had any hair left, it would have been pulled out by now. My issue is......

Boxi 4.1 running reports from MS SQL. Since upgrading the SQL server from Server 2008 r2 and SQL 2008 r2 up to Server 2012 and SQL 2014 the universe connects and i can run new reports but all the old reports fail with:
Database error ODBC Driver Maager Data Source name not found and no default driver specified......
What have i missed? I have tried connecting with 2014 odbc driver and gone back to generic MS SQL ODBC Driver and I have ensured that the 64 Bit ODBC connection has a twin in 32 bit ODBC centre.....

I know the answer is going to be simple but i have gone over it so many ways i have caught my own tail.

The other option is to script out the 50+ reports and import them from the script... IF such a thing is available (Like we can script out a SQL Job in management studio...)

Thank you in advance

G
Back to top
joepeters
Forum Fanatic
Forum Fanatic



Joined: 29 Aug 2002

Posts: 6631
Location: Connecticut, USA


flag
PostPosted: Mon Jul 15, 2019 1:07 pm 
Post subject: Re: old reports not running post sql upgrade

WebI, Crystal?
Back to top
Display posts from previous:   
Register or Login to Post    Forum Index -> General Discussion  Previous TopicPrint TopicNext Topic
Page 1 of 1 All times are GMT - 5 Hours
 
Jump to:  

Index | About | FAQ | RAG | Privacy | Search |  Register |  Login 

Get community updates via Twitter:

Not endorsed by or affiliated with SAP
Powered by phpBB © phpBB Group
Generated in 0.0812 seconds using 17 queries. (SQL 0.0566 Parse 0.0008 Other 0.0238)
CCBot/2.0 (https://commoncrawl.org/faq/)
Hosted by ForumTopics.com | Terms of Service
phpBB Customizations by the phpBBDoctor.com
Shameless plug for MomentsOfLight.com Moments of Light Logo