[Microsoft][ODBC Microsoft Access Driver]Syntax error 42000

building semantic layer
1

Exception: DBD, [Microsoft][ODBC Microsoft Access Driver] Syntax error in FROM clause.State: 42000

Dear friends,

I am having this issue since long time now and banging my head on the wall…

firstly while creating the universe when i do a join with a table called TIME with another table ResponseTime. The DETECT in join properties gives “unknown cardinality DSG0003” I am doing a join on its primary key called EID to EID in both tables.

The database is a .mdb imported from an excel sheet.

Secondly if I leave the join with that error and make reports with it using all columns from both the tables, it gives me this error query 1 Universe1 a database error occured. The database error text is Microsoft ODBC Microsoft access driver syntax error in FROM clause WIS 10901

I think the main issue is with the join though.

please help! and please let me know if you want further information.

Really appreciate it

mehul1511 (BOB member since 2011-07-01)

2

[Moderator Note: Moved from WebIntelligence XI to Semantic Layer / Universe Designer]

And welcome to B:bob:B!

Marek Chladny :slovakia: (BOB member since 2003-11-27)

3

Can you parse the join successfully?

Have you carried out a university integrity test?

4

thank you for your reply mark.

Yes I id the integrety check by it gives an error in PARSE OBJECTS “parse failed: Invalid definition(UNV0023)”

And so does the parse gives the same error as "Exception: DBD, [Microsoft][ODBC Microsoft Access Driver] Syntax error in FROM clause.State: 42000 "

I should have added it in the first post.

the parse error makes me wonder wether if its an issue with some kind of driver of ms access. Also to add I have tried to design the universe in Win 7 and also in Win 2003 server with ms access 2005 db and also with ms access 2007.

Thank you very much for looking into this matter…

mehul1511 (BOB member since 2011-07-01)

5

Hi,

What’s the definition (Select and Where parts) of objects that do not parse? Can you post the syntax that you used?

Marek Chladny :slovakia: (BOB member since 2003-11-27)

6

I think what you are looking for is this, but please let me know if you meant something else.
Time.EID=ResponseTime.EID
this is where I parse and getting error here Time is one table with EID as primary key and ResponseTime is another with EID.

Please let me know,

mehul1511 (BOB member since 2011-07-01)

7

What is it that does not parse?
If it’s a join, have you tried recreating it using the drag and drop functionality within Designer?

8

This is a join? Yet you’ve said it’s an object that does not parse. Have you tried actually setting the cardinality for this join and seeing if it parses?

debbie

Debbie :uk: (BOB member since 2005-03-01)