Skip to Main Content
Forums

DevOps, CI/CD and Automation

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Windows 7 - ODBC for Office 2010 64 bit - MS ODBC Driver for Oracle

jefferamJan 8 2010 — edited Jul 13 2011
I am trying to link a table from an oracle rac 10.2.0.4 64 bit install.
I have windows 7 with the oracle 64 bit client.
in odbc i can create a datasource using the oracle driver
and when i try to link a table i get an error :
Reserved error (-7732); there is no message for this error.

I would like to use the Microsoft ODBC for Oracle Driver but it doesnt exist on my computer.
the old one on windows xp used file MSORCL32.DLL is there a MSORCL64.DLL now?
Anyone have any help?
Jeff

Comments

ReportsToolsComponent is not a Server, it contains backing files for Reports Builder, font files.
Repeat your steps with below command.
createReportsServerInstance(instanceName='frm_rep_servr_hostname',machine='AdminServerMachine')
Thanks, Suresh

Tony007

./wlst.sh

Initializing WebLogic Scripting Tool (WLST) ...

Welcome to WebLogic Server Administration Scripting Shell

Type help() for help on available commands

wls:/offline> connect("weblogic","ofrwls12","hostname:7001")
Connecting to t3://hostname:7001 with userid weblogic ...
Successfully connected to Admin Server "AdminServer" that belongs to domain "Fr_domain".

Warning: An insecure protocol was used to connect to the server.
To ensure on-the-wire security, the SSL port or Admin port should be used instead.

wls:/Fr_domain/serverConfig/> createReportsServerInstance(instanceName='frm_rep_servr_hostname02',machine='AdminServerMachine')
Location changed to edit custom tree. This is a writable tree with No root.
For more help, use help('editCustom')

Starting an edit session ...
Started edit session, be sure to save and activate your changes once you are done.
Saving all your changes ...
Saved all your changes successfully.
Activating all your changes, this may take a while ...
The edit lock associated with this edit session is released once the activation is completed.
Activation completed
Reports Server instance "frm_rep_servr_hostname02" was successfully created.

/rwdiag.sh -FindAll

Reading the rwnetwork.conf from :/usr1/Oracle/Middleware/Oracle_Home/user_projects/domains/Fr_domain/config/fmwconfig/components/ReportsToolsComponent/frm_rep_servr_hostname01/rwnetwork.conf
Broadcast mechanism used to locate servers
------------------------------------------
Channel address = 228.5.6.7
Channel port = 14021

/usr1/Oracle/Middleware/Oracle_Home/user_projects/domains/Fr_domain/bin/startComponent.sh frm_rep_servr_hostname02
Rerun /rwdiag.sh -FindAll

Tony007

i did that still empty

rwdiag.sh can never return empty. The script should exit with REP-50503 or REP-50504
The script reads rwnetwork from frm_rep_servr_hostname01, so COMPONENT_NAME is correctly configured.
Double check if rwdiag.sh is running from /usr1/Oracle/Middleware/Oracle_Home/user_projects/domains/Fr_domain/reports/bin
Do you see the linux process for frm_rep_servr_hostname02?
What do you get when you run below.
http://<hostname>:<wls_reports_port>/reports/rwservlet/showjobs?server=frm_rep_servr_hostname02

Tony007

am geting

http://<hostname>:<wls_reports_port>/reports/rwservlet/showjobs?server=frm_rep_servr_hostname02

Did this answer the question? Yes No
REP-51002: Bind to Reports Server frm_rep_servr_hostname02 failed.

1 - 6
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Aug 10 2011
Added on Jan 8 2010
#11g, #client, #connection, #excel, #odbc, #oracle, #query, #windows, #windows-and-net, #xe
39 comments
112,369 views