Board index » delphi » Delphi MS SQL Server & Oracle

Brian Wheatley

Delphi Developer
Sat, 30 Jul 2005 21:14:04 GMT

Delphi MS SQL Server & Oracle

Hello,

We recently purchased Delphi 7 Enterprise for a project that we are working
on for a customer. The customer would like us to read information directly
from their Oracle server. Currently, I do not have access to Oracle within
our company, but we do have MS SQL Server.

What are the steps involved with connecting to MS SQL Server and Oracle from
a D7 application?

Thanks,
Brian Wheatley

 
Dmeiste

Delphi Developer
Sat, 30 Jul 2005 22:58:06 GMT

Re:Delphi MS SQL Server & Oracle


Oracle:
Use DOA (Direct Oracle Access) from www.allroundautomations.com  Price is
pretty cheap also last I checked.  beats any other method I've used to
connect to oracle (ODBC, ADO, BDE).

SQL Server:
The provided ADO components work fine.

Quote
"Brian Wheatley" <bria...@brechbuhler.com> wrote in message

news:3e48f729$1@newsgroups.borland.com...
Quote
> Hello,

> We recently purchased Delphi 7 Enterprise for a project that we are
working
> on for a customer. The customer would like us to read information directly
> from their Oracle server. Currently, I do not have access to Oracle within
> our company, but we do have MS SQL Server.

> What are the steps involved with connecting to MS SQL Server and Oracle
from
> a D7 application?

> Thanks,
> Brian Wheatley

Brian Wheatle

Delphi Developer
Sat, 30 Jul 2005 23:35:28 GMT

Re:Delphi MS SQL Server & Oracle


I was hoping that there would be some way to do this through a standard
Delphi object type (dbGo, dbExpress, etc.), so that the program could be
changed from MS SQL (in house development) to Oracle at the end user's
location without rewriting the code.

Brian

Quote
"Dmeister" <da...@malikyar.com> wrote in message

news:3e490f78$1@newsgroups.borland.com...
Quote
> Oracle:
> Use DOA (Direct Oracle Access) from www.allroundautomations.com  Price is
> pretty cheap also last I checked.  beats any other method I've used to
> connect to oracle (ODBC, ADO, BDE).

> SQL Server:
> The provided ADO components work fine.

> "Brian Wheatley" <bria...@brechbuhler.com> wrote in message
> news:3e48f729$1@newsgroups.borland.com...
> > Hello,

> > We recently purchased Delphi 7 Enterprise for a project that we are
> working
> > on for a customer. The customer would like us to read information
directly
> > from their Oracle server. Currently, I do not have access to Oracle
within
> > our company, but we do have MS SQL Server.

> > What are the steps involved with connecting to MS SQL Server and Oracle
> from
> > a D7 application?

> > Thanks,
> > Brian Wheatley

Martin Brekho

Delphi Developer
Sun, 31 Jul 2005 00:05:02 GMT

Re:Delphi MS SQL Server & Oracle


Quote
> I was hoping that there would be some way to do this through a standard
> Delphi object type (dbGo, dbExpress, etc.), so that the program could be
> changed from MS SQL (in house development) to Oracle at the end user's
> location without rewriting the code.

> Brian

The only option that comes near your wishes would be the dbExpress
equivalents from ODAC for SQL server and Oracle (www.crlab.com). From what
I've heard/read however you either have to use very generic SQL or you'll be
beter of installing an Oracle server inhouse (or hire a consultant to do so)
otherwise you'll be rewriting a lot of code (Microsoft has a very long
article about migrating from Oracle to SQL server, so I assume it will be
the same the other way around).

hth,
Martin

Brian Wheatle

Delphi Developer
Sun, 31 Jul 2005 01:09:11 GMT

Re:Delphi MS SQL Server & Oracle


Thanks, that looks like the ticket.

As far as the SQL goes, that shouldn't be a problem. All I need to do is to
look up a couple of fields in one table by searching for an order number.
Everything else will be done in a native DB (FlashFiler 2).

Brian

Quote
"Martin Brekhof" <mar...@brekhof.nl> wrote in message

news:3e491e84@newsgroups.borland.com...
Quote
> > I was hoping that there would be some way to do this through a standard
> > Delphi object type (dbGo, dbExpress, etc.), so that the program could be
> > changed from MS SQL (in house development) to Oracle at the end user's
> > location without rewriting the code.

> > Brian
> The only option that comes near your wishes would be the dbExpress
> equivalents from ODAC for SQL server and Oracle (www.crlab.com). From what
> I've heard/read however you either have to use very generic SQL or you'll
be
> beter of installing an Oracle server inhouse (or hire a consultant to do
so)
> otherwise you'll be rewriting a lot of code (Microsoft has a very long
> article about migrating from Oracle to SQL server, so I assume it will be
> the same the other way around).

> hth,
> Martin

Martin Brekho

Delphi Developer
Sun, 31 Jul 2005 03:05:35 GMT

Re:Delphi MS SQL Server & Oracle


Quote
"Brian Wheatley" <bria...@brechbuhler.com> wrote in message

news:3e492e43$1@newsgroups.borland.com...
Quote

> Thanks, that looks like the ticket.

> As far as the SQL goes, that shouldn't be a problem. All I need to do is
to
> look up a couple of fields in one table by searching for an order number.
> Everything else will be done in a native DB (FlashFiler 2).

> Brian

ok, be sure to look in the dbexpress newsgroup, some people seem to have
found some differences between these dbExpress drivers and the official
dbExpress behaviour. Not using them myself I couldn't tell wether or not
this is a major problem.

regards,
Martin

Marc Scheune

Delphi Developer
Sun, 31 Jul 2005 15:06:26 GMT

Re:Delphi MS SQL Server & Oracle


On Tue, 11 Feb 2003 10:35:28 -0500, "Brian Wheatley"

Quote
<bria...@brechbuhler.com> wrote:
>I was hoping that there would be some way to do this through a standard
>Delphi object type (dbGo, dbExpress, etc.), so that the program could be
>changed from MS SQL (in house development) to Oracle at the end user's
>location without rewriting the code.

Start dreaming! As soon as you start using the SQL dialects of Oracle
and SQL Server, you're basically breaking the dream of being
DB-independant - forget it, won't work.

I would STRONGLY advise you to get an Oracle for inhouse development -
developing on SQL Server and then "just migrating" to SQL Server is
like writing in Java, and then just recompiling in Delphi :-)

The two systems are so totally different, you won't be very lucky and
successful trying to do development on one and deployment on the
other. Don't - it won't work.

Marc

Other Threads

1. Delphi 3.0 - IIS ISAPI + SQL Server (MS) + BDE = SQL Server not found errors

2. ms sql server & delphi

3. Delphi & MS-SQL Server - datefield problems

4. Delphi 4 & MS SQL Server 7

5. MS SQL Server NULLS & Delphi 2 StoredProc

6. TBatchMove w/Delphi 2 & MS SQL Server

7. Delphi & MS SQL Server 6.0

8. Delphi 3 & MS SQL Server 2000

9. Delphi-5/6 Enterprise & MS-SQL server

10. Delphi 4 & MS SQL Server 6.5