VB/Oracle Development

Hi Friends !

I have joined another company which uses Oracle
at back end. I  use SQL Server and only used oracle for test purposes and in
one of the big conversion projects.

Can you advise what kind of challenges we can face in
Oracle at back end and vb at front end. I tried Oracle
data provider for .Net and found it very great tool.
But what about Oracle ODBC/OLE DB driver and its
performance in real enterprise environment.

Thanks in advance

Please adise

Having come from an Oracle shop in the late 90's I'd have to say that, if
anything, Oracle is capable of performing well in high volume environments.
It does take a bit of tuning to tweaking to  out every last drop of
performance.

From a developers perspective, it is important that you learn and use PL/SQL
.
You can also do on the fly SQL as long as you parameterize all your statemen
ts.
Not doing so will blow away your statement cache in no time.  I would also n
ot
recommend ODBC if it can be avoided, use the native drivers.

Having a DBA who knows Oracle inside and out is imperative.  Indexes and hin
ts
were important to maintaining an application set that scales with volume.
Theres quite a bit of houekeeping to do, but it pays off in the long haul.

hth,

D.


IMRAN SAMUEL SAROIA wrote:
> Hi Friends !
>
> I have joined another company which uses Oracle
> at back end. I  use SQL Server and only used oracle for test purposes and 
in
> one of the big conversion projects.
>
> Can you advise what kind of challenges we can face in
> Oracle at back end and vb at front end. I tried Oracle
> data provider for .Net and found it very great tool.
> But what about Oracle ODBC/OLE DB driver and its
> performance in real enterprise environment.
>
> Thanks in advance
>
> Please adise
>
>
>
>

"IMRAN SAMUEL SAROIA" <imransaroia2000@hotmail.com> wrote in message
news:ereTHgsHGHA.1288@TK2MSFTNGP09.phx.gbl...
> Hi Friends !
>
> I have joined another company which uses Oracle
> at back end. I  use SQL Server and only used oracle for test purposes and
in
> one of the big conversion projects.
>
> Can you advise what kind of challenges we can face in
> Oracle at back end and vb at front end. I tried Oracle
> data provider for .Net and found it very great tool.
> But what about Oracle ODBC/OLE DB driver and its
> performance in real enterprise environment.
>
> Thanks in advance
>
> Please adise
>

Are you using VB Classic or VB.Net?

If using VB Classic...
Get "Visual Basic Oracle 8: Programmer's Reference" by Dov Trietsch (Wrox).
A little dated, but you should be able to pick it up pretty cheap.

There are various nuances such as Sequences, Triggers. Parameters that are
manged a bit differently in Oracle compared to SQLServer. This little book
will save a couple of ws of agravation. It may be of some use for
ADO.Net.

For any version...
Do not use ODBC. ODBC has too many layers of indirection. OO4O is more
direct but is a poorer fit for a distributed environment (COM+,MTS...).
Stick with OLE DB/ADO. Use the latest Oracle provider, unless you can afford
DataDirect (www.datadirect.com) drivers and Providers. If you can. Get them.

Most important, for development buy Toad! There is nothing that will make
working with Oracle in a Windows environment easier.
(http://www.toadsoft.com/)
The full versions are very pricey - but then well worth it.

hth
-ralph

On Sat, 21 Jan 2006 12:19:47 -0800, "IMRAN SAMUEL SAROIA" <imransaroia2000@h
otmail.com> wrote:

¤ Hi Friends !
¤
¤ I have joined another company which uses Oracle
¤ at back end. I  use SQL Server and only used oracle for test purposes and 
in
¤ one of the big conversion projects.
¤
¤ Can you advise what kind of challenges we can face in
¤ Oracle at back end and vb at front end. I tried Oracle
¤ data provider for .Net and found it very great tool.
¤ But what about Oracle ODBC/OLE DB driver and its
¤ performance in real enterprise environment.

If this is a .NET app I wouldn't use OLEDB or ODBC unless there is a feature
 in the native .NET
provider that is not functioning or unavailable. If you do use OLEDB or ODBC
 then use Oracle's
drivers. Microsoft's drivers are obsolete and do not support newer Oracle fu
nctionality.

With respect to .NET, you can use Oracle's .NET library only if you're using
 the 9i client or
higher.

If you're working with BLOB and CLOB data types you will need to use a diffe
rent approach than SQL
Server. In addition, Oracle does not have an Identity column. In lieu of tha
t is provided what is
referred to as a "Sequence".


Paul
~~~~
Microsoft MVP (Visual Basic)

> Server. In addition, Oracle does not have an Identity column. In lieu of that is provided
 what is
> referred to as a "Sequence".

Sequences ... FYI.

http://www.psoug.org/reference/sequences.html

http://www.techonthenet.com/oracle/sequences.php