October 6, 2007 at 5:30 am
I am in the process of moving from SQL 2000 to SQL 2005. During this transition, I need to connect from the front end of my application to a SQL 2000 database using SQL NATIVE CLIENT. When I try to do so, it will connect but then all of my objects are invalid (SQLSTATE = 42S02 Invalid object name). Is there something I can do to make my SQL 2000 databases work with SQL Native Client?
October 8, 2007 at 10:03 am
Did the default database setting cause a change of scope? Meaning - the "old" way had you connecting into a specific instance, and the new one might not, or puts you in another DB that the "original connection"?
Sounds to me that you might need to double-check if "fully qualifying" your query helps you at all.
----------------------------------------------------------------------------------
Your lack of planning does not constitute an emergency on my part...unless you're my manager...or a director and above...or a really loud-spoken end-user..All right - what was my emergency again?
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply