VB6: Oracle 8/SQL Server 2000 compatibility problems using ADO 2.5 and SQL 
Author Message
 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
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



Fri, 03 Oct 2003 17:42:40 GMT  
 VB6: Oracle 8/SQL Server 2000 compatibility problems using ADO 2.5 and SQL


Fri, 19 Jun 1992 00:00:00 GMT  
 VB6: Oracle 8/SQL Server 2000 compatibility problems using ADO 2.5 and SQL

Quote:

> 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



Sat, 04 Oct 2003 18:28:54 GMT  
 
 [ 3 post ] 

 Relevant Pages 

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

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