parora
Well Known Member
Hi All,
2 questions regarding ODBC connections:
1a. When I use the OneWorld ODA to link to a OneWorld table using MS Access, I get an error when I try to sum across a currency field, "ODBC--call failed....Currency columns can only be in simple column references".
1b. Using the ODA Connection I also have problems trying to filter on Date fields, e.g. if I have <6/30/04 specified in my Access query, I get the error "SQL0180 - Syntax of date...not valid"
Is there a way around #1a) and #1b) above?
2. If I create my own ODBC connection and then link to a OneWorld Table, I don't get the proper format when I perform queries, so I may have to take a Quantity Field and divide by 1000 in my query. Is there any setting that I can change, when I'm creating my ODBC connection to get the proper format, similiar to what the OneWorld ODA does?
Thanks.
2 questions regarding ODBC connections:
1a. When I use the OneWorld ODA to link to a OneWorld table using MS Access, I get an error when I try to sum across a currency field, "ODBC--call failed....Currency columns can only be in simple column references".
1b. Using the ODA Connection I also have problems trying to filter on Date fields, e.g. if I have <6/30/04 specified in my Access query, I get the error "SQL0180 - Syntax of date...not valid"
Is there a way around #1a) and #1b) above?
2. If I create my own ODBC connection and then link to a OneWorld Table, I don't get the proper format when I perform queries, so I may have to take a Quantity Field and divide by 1000 in my query. Is there any setting that I can change, when I'm creating my ODBC connection to get the proper format, similiar to what the OneWorld ODA does?
Thanks.