June 20, 2014 at 3:56 am
Hi All,
We have an application that uses ado.net recordsets that works fine with SQL 2008. It uses the recordset.movefirst() command, in conjunction with a snapshot cursor, which works fine when connecting to a SQL 2008 db. However, after moving and upgrading the db to sql 2012 the move first thorows a "fetch type out of range error"
I know this is maybe a driver or ado.net issue but I thought it was worth asking the question, in case any of you have seen it before.
Thanks in advance
E
SQL DBA
Every day is a school day, and don't trust anyone who tells you any different.
http://sqlblogness.blogspot.co.uk
June 23, 2014 at 8:45 am
Might be the ODBC driver. One way to find out is to set up Excel or Access and write some quick VBA with ADO to test the functionality from a client PC and see if it can work when set up from scratch. If it does work, then look at the differences and see if the drivers for ODBC are the same or not.
Steve (aka sgmunson) 🙂 🙂 🙂
Rent Servers for Income (picks and shovels strategy)
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply