OraFAQ Forum: Windows » Excel 64 bit problem using

Home » Infrastructure » Windows » Excel 64 bit problem using (19.3)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Excel 64 bit problem using [message #685954]

Tue, 10 May 2022 08:53

alcapps
Messages: 7
Registered: May 2022

Junior Member

Set OraSession = CreateObject("OracleInProcServer.XOraSession")
does not work, class not registered. When I try to load the old 32-bit type library that didn't work either.\
Looking for a 64 bit work around.

Report message to a moderator

Re: Excel 64 bit problem using [message #685955 is a reply to message #685954]

Tue, 10 May 2022 11:29

Michel Cadot
Messages: 68172
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Is your Oracle client a 32 or 64-bit one?

Report message to a moderator

Re: Excel 64 bit problem using [message #685956 is a reply to message #685955]

Tue, 10 May 2022 11:40

Michel Cadot
Messages: 68172
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Oops! OO4O no more exists in 19c, you have to convert your code using ADODB/OLEDB:

Set OraCon = New ADODB.Connection
OraCon.ConnectionString = "Provider=OraOLEDB.Oracle;Data Source="...;User ID=...;Password=...;"
OraCon.Open
...

Report message to a moderator

Re: Excel 64 bit problem using [message #685957 is a reply to message #685956]

Tue, 10 May 2022 13:44

alcapps
Messages: 7
Registered: May 2022

Junior Member

also on the orasessiOn object they use set db = oraSessiOn.OpenDatabse(instance,userid,password)

Report message to a moderator

Re: Excel 64 bit problem using [message #685958 is a reply to message #685957]

Tue, 10 May 2022 13:45

alcapps
Messages: 7
Registered: May 2022

Junior Member

Thanks for the quick reply. I did try that connection but the OraSession has many other uses in the vba code seems like a full rewrite to get this converted to olddb.

Report message to a moderator

Re: Excel 64 bit problem using [message #685959 is a reply to message #685958]

Tue, 10 May 2022 13:55

Michel Cadot
Messages: 68172
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Correct! The procedures are not the same ones, this is a full rewrite.

The other option is to access your 19c database only from a 11.2.0.4 client using OO4O but you won't have any support from Oracle neither for 0040 nor for the 11gR2->19c interoperability (unless you have a Market-Driven Support contract for this later, see MOS note 207303.1).
Note this option will no more work with later versions (21c+).

Report message to a moderator

Re: Excel 64 bit problem using [message #685961 is a reply to message #685959]

Tue, 10 May 2022 14:32

alcapps
Messages: 7
Registered: May 2022

Junior Member

what about db.Parameters.add "vendorxxx","" , 1

db was defined as set db = OraSessiOn.OpenDatabase(instance, userid, password, &0) Not sure how they were used.

Report message to a moderator

Re: Excel 64 bit problem using [message #685962 is a reply to message #685961]

Tue, 10 May 2022 14:33

alcapps
Messages: 7
Registered: May 2022

Junior Member

what is the equivalent of this oracle session variable to ADODB?

Report message to a moderator

Re: Excel 64 bit problem using [message #685963 is a reply to message #685962]

Tue, 10 May 2022 14:33

alcapps
Messages: 7
Registered: May 2022

Junior Member

Thanks for the help. I have the database being read now. Its in the weeds of the add parameters and such now.

Report message to a moderator

Re: Excel 64 bit problem using [message #685964 is a reply to message #685963]

Tue, 10 May 2022 14:39

alcapps
Messages: 7
Registered: May 2022

Junior Member

I am coming across db.paarameters("itemx").value = "org_id" then
set = oradynaset = db.dbCreateDyaset(sql, O&)
Not sure what needs to happen for the recordset in adodb

Report message to a moderator

Previous Topic:

Error in writing to directory

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu May 26 21:35:12 CDT 2022