ANSI & Jet 1

[miller1975]

Does VB recognize ANSI SQL. The reason I am asking is I got a code in ASNI (from DB2) and want to run it to get data into Access (which run on Jet). I am having trouble after trying to converting query to Jet. So if Vb can run ASNI SQL then its good.

Please advice.

 

[dilettante]

This isn't a VB issue at all, but instead a Jet/Jet interface issue.

http://office.microsoft.com/en-us/assistance/HP010322501033.aspx

For the closest ANSI compliance be sure to use ADO with the Jet OLEDB Provider, not ADO with the older ODBC driver (which ADO implicitly invokes via the ODBC Provider) and not DAO. This is mentioned at the link above.

Jet uses a superset of a subset of ANSI SQL... in other words complaince is far from one-to-one on features and syntax.

 

[miller1975]

Hello dilettante,
So for this code how will I interpret in VB as a Select statement.

http://www.tek-tips.com/viewthread.cfm?qid=1046833&page=1

Please help.

 

[Golom]

Considering that you already got an answer to that in thread701-1046833, why are you still asking?

 

[miller1975]

Hello Golom, The converted code did not work. So I wanted to know if I can run the ansi version in vb..
Like I said in my reply the query is not getting recognized.
I am getting "Micorsoft Access can't represent the join expression B.Branch_CO_NBR = C.BRANCH_CO_NBR in Design View" when I try to paste the code in the query SQL mode.