Oracle Version

[Anonymous]

Is there anyway to tell what version of Oracle is being used on a particular computer?

[Anonymous]

Tsig...

Not exactly sure which answer your looking for but:

You could run the Oracle Installer to see what is installed on the client.

if you have any of your SQLNet.log files available you can see what version is associated with TNSAPI.

Or you can also hit oracle itself for other version information:

Via PL/SQL or other :

select * from v$version

Hope this helps,

Bob Coward
CADS, Inc

800-366-0946
bcoward@mindspring.com

[Anonymous]

I currently have a line in my code as follows:

Driver={Oracle in OraHome92}

and it works fine with my version of Oracle. A user with version 8.? (don't remember exactly which version he had) tried to run it and of course it blew up at the line. Would be nice if I could check what version the user was running and use the right driver accordingly.

[Anonymous]

Tsig...

Your user that is on version 8.x will have different tools at their disposal. With version 8 Oracle went to what they call Network Computing Architecture (NCA) which is Oracle's multi-tier architecture as they move forward.

Have your user try this and see if it helps.

Set a reference to Oracle InProc Server 2.x Type Library

In the module declaration section place..(the drawback to this, as you might notice, is that OO4O goes faster being early bound.)

Public OraSession As Object
Public OraDatabase As Object
Public OraDyn as Object

Sub OracleLogin(ServiceName as string, Uid as string, Pwd as string)

Set OraSession = CreateObject("OracleInProcServer.XOraSession")

Set OraDatabase = OraSession.OpenDatabase(ServiceName, Uid & "/" & Pwd, 0&)

Set OraDyn = OraDatabase.CreateDynaset("Select * From YourTableNamed?", 0&)

msgbox "Number of record(s) : " & OraDyn.RecordCount

End sub

Hope this helps,

Bob Coward
CADS, Inc