December 13, 2012 at 8:46 am
Hi,
I am trying to connect to my remote SQL Server 2008 database for SAP Business Objects using odbc connection. I setup the connection and it was connected successfully, but when I try to view the table in my database it is giving me this error " [Microsoft][ODBC SQL Server Driver][SQL Server]The cursor was not declared". Can anyone please help me?
Thanks
Hung Hoang
December 13, 2012 at 10:13 am
We need more details... What software were you using to actually make the connection? There are numerous ways to do such a thing, including SSIS, MS Access, MS Excel, any of a number of application programs, and any of a number of non-MS relational database products. Be aware that each such program is likely to have it's own unique rules about how to set the security context for the connection, so while using the local admin tools to create an ODBC might work fine, setting up another application to actually use the connection can have challenges at times - and most of those are security related. Care to elaborate?
Steve (aka sgmunson) 🙂 🙂 🙂
Rent Servers for Income (picks and shovels strategy)
December 15, 2012 at 8:42 pm
I agree with sgmunson that most of these posts do not have enough information to make a judgement call.
However, this is what I am thinking.
1 - You said that when setting up the ODBC connection, it returned successfull for the test. This means you have access to the server and can see the database.
It does not mean you have access to the table you are trying to select.
Please make sure the login you are using has access to the database and has at least db_datareader rights.
2 - This support ticket from microsoft show a simmular case. http://support.microsoft.com/kb/963954
However, the error message about the cursor is at the end of the batch. Try to get more information about the error by doing a ODBC logging trace, look at the SQL logs, or trace the connection to the database with SQL profiler.
Good luck.
Sincerely
John
John Miner
Crafty DBA
www.craftydba.com
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply