r3trans-d giving error

[Former Member]

Dear All ,

Executing R3trans -d from os level i m getting following error.

4 ETW000 r3trans version 6.14 (release 700 - 18.09.06 - 09:35:00).

4 ETW000 unicode enabled version

4 ETW000 ===============================================

4 ETW000

4 ETW000 date&time : 02.10.2009 - 17:25:51

4 ETW000 control file: <no ctrlfile>

4 ETW000 R3trans was called as follows: r3trans -d

4 ETW000 trace at level 2 opened for a given file pointer

4 ETW000 [dev trc ,00000] Fri Oct 02 17:25:53 2009 36895 0.036895

4 ETW000 [dev trc ,00000] db_con_init called 81 0.036976

4 ETW000 [dev trc ,00000] create_con (con_name=R/3) 52 0.037028

4 ETW000 [dbcon.c ,00000] *** ERROR => Invalid profile parameter dbms/type (or environment variable dbms_type) = <undef>, cannot load DB library

4 ETW000 153 0.037181

2EETW169 no connect possible: "connect failed with DBLI_RC_LOAD_LIB_FAILED."

plz suggest me !!!

Regards

Ashok

[Former Member]

unable to connect database

[markus_doehr2]

Ashok,

please read the replies.

R3trans -d will not work under user administrator.

You have to logon using <sid>adm, do not use administrator.

Markus

[markus_doehr2]

As which user are you executing R3trans -d?

Markus

[anindya_bose]

Ashoke

Check your enviromnet variable .. Please paste the enviromnet variable here

Check if you have DBMS_TYPE =ORA set in environment variable.

My Commputer-> Properties->Advanced tab-->Env Variables..

By the way, what is your Operating system?

Edited by: Anindya Bose on Oct 15, 2009 5:44 PM

[Former Member]

Dear Bose,

I m using SQL database i m not getting any variable name dbms_type in environment variable.when i do right click on my computer ->property and-> checking environment variable from there.

Regards

[markus_doehr2]

Ashok,

if you do that then you just check the environment for the CURRENT user. If that user is administrator it's normal that R3trans -d is not working.

You have to use <sid>adm.

Markus

[Former Member]

Dear Markus,

i login as administrator.

Regards

Ashok

[anindya_bose]

Use SIDADM user id.. Enviroment variables are set for a particular user

[Former Member]

Dear All,

Can i set environment variable dbms/type = mss for my sql server coz still i m unable to connect database.

Regards

Ashok

[former_member524429]

Dear Ashok,

Along with Markus's suggestions, you can refer this [SAP Note 556232 - Environment settings for R/3/Oracle on Windows|https://websmp130.sap-ag.de/sap(bD1lbiZjPTAwMQ==)/bc/bsp/spn/sapnotes/index2.htm?numm=556232].

Regards,

Bhavik G. Shroff