SQL not returning results after upgrade to 2005

• mbowden

  Newbie

  Points: 3

  More actions

  November 18, 2005 at 6:46 am

  #364175

  Hi

  After chasing around a problem I have closed it down to just the following -

  I have two simple tables in my database

  linkme

  linkme2

  both of which have one column called catno

  I have put one record in linkme and one in linkme2

  select * from linkme -- pulls back one record correctly via .asp page and management studio

  select linkme.catno from linkme left join linkme2 on linkme.catno = linkme2.catno -- pulls back one record in management studio and 0 records in .asp page connection !!!

  Connection string in .ASP page

  Provider=SQLOLEDB;Data Source=192.168.0.5;Initial Catalog=DVD;User Id=XXXXXX;Password=XXXXXX;

  I can point the same page to a SQL 2000 server with the same tables and this brings back 1 record as expected

  I have also tried using the native drivers

  Provider=SQLNCLI;server=192.168.0.5;uid=XXXXXX;pwd=XXXXX;database=DVD;DataTypeCompatibility=80;"

  and this is exactly the same ie no results from a valid left hand join

  I have put up an example .asp page that can be found on. This show the code running

  http://217.154.157.166/sql2005test.asp

  I have found if you swap to client side cursors the SQL works correctly but this is not an option in the live environment.

  Please help

  Mat

• Joseph Mulhall

  SSCarpal Tunnel

  Points: 4672

  More actions

  November 21, 2005 at 2:18 am

  #604872

  Are you trying this under the same user account used by the ASP?

  Do the tables and user all belong to the same schema?