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

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

Post by JF » Tue, 17 Apr 2001 18:42:40



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

 
 
 

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

Post by Kunle Odutol » Wed, 18 Apr 2001 19:28:54



> 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?

Yes. Use stored procedures and, the use ADO Command and Parameter objects to
excutes the stored procedures and pass parameters respectively.
That way your application is insulated from the such details of differences
in SQL syntax etc.

Kunle

 
 
 

1. 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

2. Binding at Runtime

3. Getting Started - Sample code not working

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

5. SSCE_M_FAILEDRETRIES ERROR 28549

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

7. Migration from Pervasive SQL 2000 to MS-SQL Server 2000 using ADO

8. Sql Server 7 and SQL Server 2000 compatibility

9. Using ADO 2.5 Streams on SQL Server 7.0

10. Performance issue - Access 2000 using VB6 and ADO 2.1 with SQL