Currently we use DBconnect to extract data from SQL2000 and it all works well. But now we need to connect to SQL2008, I can see the view in BW but cannot edit the datasource. The SQL user has all the permission and the view is under that user.
Could someone please help.
Is SQL2008 supported using DBconnect? Do we have to update our library?
We are currently on BI 7.0