INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Member Login

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips now!

Talk With Other Members
Be Notified Of Responses
To Your Posts
Keyword Search
One-Click Access To Your
Favorite Forums
Automated Signatures
On Your Posts
Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

LINK TO THIS FORUM!

Tek-Tips LinkedIn^® Group

Join our
LinkedIn^® Group!

Hook up with past and present colleagues and classmates quickly.

Partner With Us!

"Best Of Breed" Forums Add Stickiness To Your Site

(Download This Button Today!)

Feedback

"...Just wanted to let you know that I registered today, and your site is fantastic. I found solutions to problems that I have been encountering for months!..."

More...

Geography

Where in the world do Tek-Tips members come from?

Click Here To Find Out!

Tek-Tips Shirts!

Get your
Tek-Tips Forums
SWAG here!

Home > Forums > Programmers > DBMS Packages > Centura Software / Gupta : SQLBase Forum

Problem: ODBC from MS Access (linked tables / join)

Read More Threads Like This One

tglynx (Programmer)

9 Sep 04 10:23

Hello!

Running SQLBase 8.5.0, I linked 2 Tables from the ISLAND database in a MS Access database using the supplied 'Gupta SQLBase' ODBC Driver. I linked PUBLIC_COMPANY and PUBLIC_COMPANY_STATISTICS.

If i Query only one of the two tables everything works fine.
But the following SQL-Statement fails with an error:

------------------------
SELECT
PUBLIC_COMPANY.COMPANY_NAME,
PUBLIC_COMPANY_STATISTICS.STYLE

FROM
PUBLIC_COMPANY

INNER JOIN
PUBLIC_COMPANY_STATISTICS
ON
PUBLIC_COMPANY.COMPANY_ID = PUBLIC_COMPANY_STATISTICS.COMPANY_ID
------------------------

The error Message:
[Gupta][ODBC Driver][SQLBase]01401 DLU ICN Invalid Column name COMPANY_ID (#1401)

------------------------

What went wrong? During the installation of SQLBase i answered the Question asking if I am going to use ANSI99 SQL JOIN Syntax with 'yes'. If i try the same Query using the VB6 Sample application it works fine. So JOIN Syntax is supported.

Any suggestions?

Thanks in advance ;)

Michael

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Back To Forum

Back To Centura Software / Gupta : SQLBase