Hello, > -----Original Message----- > From: Jos� R�mulo El�as Contreras [mailto:[EMAIL PROTECTED] > Sent: Saturday, September 04, 2004 12:36 AM > To: [EMAIL PROTECTED] > Subject: What SQL join syntax does SAPDB use? > ... > Hi: > > I have a problem using Crystal Reports with sapdb. > Crystal reports > generates the sql query depending of what driver are you using to > connect to database. I am using the odbc driver that is in the sapdb > page (odbc74-setup.exe). It install two drivers: SQLOD32.DLL and > SQLOD32W.DLL, what is the difference between this two driver files?
SQLOD32W.DLL is the wide character version of the ODBC Driver. It should used UNICODE applications. The MS odbc driver manager also supports UNICODE but if an odbc driver didn't supports it. All character arguments of the odbc functions are converted from and to ASCII/UNICODE code sets. If the native driver supports UNICODE as sqlodbc32w the conversion of the MS odbc driver manager isn't necessary. > > In crystal reports I can connect to the database using > SQLOD32.DLL > or SQLOD32W.DLL driver, but crystal generates the SQL join > syntax wrong > when I attempt to link tables in the report or when I preview > a report > that has linked tables. Which join syntax is generated from crystal report? ... > > What join syntax does sapdb use with its odbc driver? The SAPDB ODBC driver is conform to ODBC Syntax specified by the Microsoft documentation. See http://msdn.microsoft.com/library/default.asp?url=/library/en-us/odbc/htm/odbcouter_joins.asp The SAPDB ODBC Driver supports SQL_OJ_RIGHT, SQL_OJ_NESTED, SQL_OJ_ALL_COMPARISON_OPS as returned by SQLGetInfo. Regards, Burkhard -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
