Solved

INNER JOIN in mySql Ver: 3.23.49a and ODBC ver: 2.50.39

Posted on 2002-03-18
4
854 Views
Last Modified: 2012-06-27
I have problems running an INNER JOIN agains mySql.
Tables involved are:
testtable,
  fields: TesID (int), ImaID (int)
  index : PRIMARY (TesID and ImaID)
images:
  fields: ImaID (int), ImaName (varchar)
  index : PRIMARY (ImaID)


Here is my Select statement and recordset open line:

strSql = "SELECT testtable.TesID, testtable.ImaID, images.ImaName, images.ImaID FROM testtable INNER JOIN images ON testtable.ImaID = Images.ImaID WHERE testtable.TesID = 2"

Set rs = Server.CreateObject("ADODB.Recordset")
rs.Open strSql, Conn, 1

Here is the error message:
Microsoft OLE DB Provider for ODBC Drivers error '80040e21'
ODBC driver does not support the requested properties

The error triggers on line 38 which is the rs.Open line.
Have tested the rs.Open with another select and that works fine...

I thought mySql supported INNER JOIN.

So does anyone knows whats wrong in my Select statement?

Erot

0
Comment
Question by:erot
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
4 Comments
 
LVL 6

Expert Comment

by:kotan
ID: 6876251
try this

"SELECT testtable.TesID, testtable.ImaID, images.ImaName, images.ImaID FROM testtable LEFT JOIN images ON images.ImaID = testtable.ImaID WHERE testtable.TesID = 2"
0
 

Author Comment

by:erot
ID: 6876304
Have found what caused the problem...
INNER JOIN works fine..

but replacing Images.ImaID with images.ImaID did the trick

Erot
0
 
LVL 5

Accepted Solution

by:
kelfink earned 200 total points
ID: 6877851
Mysql on UNIX is case sensitive by nature of the fact that the tables are stored and referenced as files on the OS.  On Unix, files are case sensitive.  It's one annoyying aspect of developing with mySQL on NT then transferring to UNIX later.
0
 

Author Comment

by:erot
ID: 6879273
Thanks. I got to the point where I found out that i and not I did the trick, now I know the reason for it as well.

Thanks
0

Featured Post

Back Up Your Microsoft Windows Server®

Back up all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Introduction In this article, I will by showing a nice little trick for MySQL similar to that of my previous EE Article for SQLite (http://www.sqlite.org/), A SQLite Tidbit: Quick Numbers Table Generation (http://www.experts-exchange.com/A_3570.htm…
Load balancing is the method of dividing the total amount of work performed by one computer between two or more computers. Its aim is to get more work done in the same amount of time, ensuring that all the users get served faster.
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…

763 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question