ODBC behavior

• Lance Tamashiro

  Grasshopper

  Points: 12

  More actions

  March 19, 2007 at 11:22 am

  #175656

  Hi everyone, I was wondering if anyone has seen this problem before. We recently upgraded from SQL2000 32bit to SQL200564bit. I am seeing a lot of performance issues, the application is connecting vi ODBC. The application uses SQL Authentication.

  If I trace the queries I see a ton of RPC:Completed Events that are running EXEC sp_columns, sp_Tables and sp_Stored_procedures. They run ridiculously slow.

  I have been playing around and notice that if I connect via Windows Authentication or as a SQL User that has DBO on the database these queries run considerably faster.

  Anyone have any ideas??

  Thanks!

  Lance

• MarkusB

  SSC-Dedicated

  Points: 37370

  More actions

  March 20, 2007 at 3:12 am

  #695862

  Lance,

  you might need another driver to connect to the 64-bit server. I heard last week from MS that ODBC is not supported for 64-bit version.

  Markus

  [font="Verdana"]Markus Bohse[/font]