VB6: Oracle 8/SQL Server 2000 compatibility problems using ADO 2.5 and SQL Syntax 
Author Message
 VB6: Oracle 8/SQL Server 2000 compatibility problems using ADO 2.5 and SQL Syntax

VB6: Oracle 8/SQL Server 2000 compatibility problems using ADO 2.5 and SQL
Syntax

We are trying to find a common standard for Oracle 8i and SQL Server 2000
for SQL commands in ADO 2.5 objects and VB6 code. They use different a
syntax for outer joins (one uses a (+) and the other a *:

Oracle 8 apparently also requires that the table name is sent between quotes
(although documentation says otherwise), whereas SQL 2000 forbids it.

Ex.
Oracle: select "t1".id from t1,t2 where t1.field1 (+)= f2.field2
SQL Server: select ti.id from t1,t2 where t1.field1 *= f2.field2

Can anyone help?

Thanks in advance!
Jorge Ferreira



Mon, 29 Sep 2003 19:56:26 GMT  
 
 [ 1 post ] 

 Relevant Pages 

1. VB6: Oracle 8/SQL Server 2000 compatibility problems using ADO 2.5 and SQL

2. VB6: Oracle 8/SQL Server 2000 compatibility problems using ADO 2.5 and SQL Syntax

3. VB6 application using SQL Server 2000 migrating db to SQL Server 2

4. ADO Problem: VB6 hangs on sending a query to an SQL-Server 2000

5. Using ADO 2.5 Streams on SQL Server 7.0

6. problems with sql statement using access 2000, ado, vb6

7. SQL Connectivity - CR9 Developer Edition, VB6, SQL Server 2000

8. VB6/SQL Server 2000 ADO Best Practices question

9. ADO DLL VB6 - SQL Server 2000

10. know anything about Stored Proc and using SQL Server 2000, CR8.5 and VB6.0

11. ADO 2.5 Sql Server Ole Db Provider and Memory Loss

12. Help - SQL 7.0 , ADO 2.5 , Store Procedure , VB6 and MSDataGrid

 

 
Powered by phpBB® Forum Software