We help IT Professionals succeed at work.
Get Started

MSDE vs SQL Server Express 2005

GeekRUS
GeekRUS asked
on
427 Views
Last Modified: 2012-05-05
I upgraded from MSDE to SQL server Express 2005.  My asp code that has inner and outer joins in the SQL statements doesn't seem to work the same.  I can write the SQL statement to I.E. and paste it in SQL Management studio and it give results.  The same query running in ASP vbScript under IIS doesn't returns no records.  If I simplfied the query to just one table, it will return records.

Any ideas on what the difference might be?
Comment
Watch Question
Commented:
This problem has been solved!
Unlock 2 Answers and 11 Comments.
See Answers
Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

  • Troubleshooting
  • Research
  • Professional Opinions
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE