× Discuss on T24 Installation, Setting up the environment, TC Server, jBOSS, Package & Deployment, etc…

error while setting up environment T24 R10 + MSSQL

  • divesh
  • Topic Author
  • Offline
  • Senior Member
  • Senior Member
More
11 years 10 months ago #11409 by divesh
Dear All,
I have configure 1 environment R10 with MSSQL Server 2008 which is working fine. In the same server I created another test environment and when I try to go to jshell I get this error

E:\T24APP\bnk\bnk.run>remote.cmd
START GLOBUS Y/N=
drvOpen: *** ERROR *** Unable to initialise DriverData Structure, check ./XMLdri
ver.log for more information.


XMLdriver.log has is displayed below
R10.97389 - 2652 - (jmainfunction.b,0) - Thu May 10 10:04:53 - - - ErrorRecord: HResult: 0x80004005
Description: Cannot open database "MWVIPJB1" requested by the login. The login failed.
SQLErrorInfo: 42000
Source: Microsoft SQL Server Native Client 10.0
File: dbProcess.cpp, Line: 129

R10.97389 - 2652 - (jmainfunction.b,0) - Thu May 10 10:04:53 - - - accConnectDatabase: *** ERROR *** dbConnect failed
R10.97389 - 2652 - (jmainfunction.b,0) - Thu May 10 10:04:53 - - - comEstabConnection: *** ERROR *** accConnectDatabase failed
R10.97389 - 2652 - (jmainfunction.b,0) - Thu May 10 10:04:53 - - - comInitDriverData: *** ERROR *** comEstabConnection failed!
R10.97389 - 2652 - (jmainfunction.b,0) - Thu May 10 10:04:53 - - - drvOpen: *** ERROR *** Failed to initialise DriverData structure



Kindly help , its urgent

Thanks in Advance

Divesh

Please Log in or Create an account to join the conversation.

More
10 years 9 months ago #14126 by assefa.dagnachew
Replied by assefa.dagnachew on topic error while setting up environment T24 R10 + MSSQL
Dear Divesh,
I want to setting up the environment of t24 R10 with oracle 11g for windows or MS SQL 2008/12 database on window server 2008 R2.But I have not the driver for the above database for window.please help me how to configure the environment variable(remote.cmd) and the xmldriver file. If you can please send to me the driver file for window.

With Best Regards

assefa.dagnachew

Please Log in or Create an account to join the conversation.

  • divesh
  • Topic Author
  • Offline
  • Senior Member
  • Senior Member
More
10 years 9 months ago #14130 by divesh
Hi Assefa,


Before configuring, first in remote.cmd, comment below line

rem set JEDIFILENAME_MD=%HOME%\VOC

open a new session and login in jshell, from jshell command type -> config-XMLMSSQL

u will see below screen

** XMLMSSQL_FRMWRK Version R10.97389 *******************************************
Main menu **
*****************************************************************************
1. Database settings.
2. User settings.
3. Run installation script against database.
4. Test connection.
5. Save only.
6. Save and exit.

9. Exit without saving.

Select option:


Use 1 and 2 to setup your database and username for SQL Server/Oracle

Make Sure TAFC is installed.

Once you setup database and username , then select 4 to check your connection, If its successful then select 3 to run the script

The path of the script for SQL Server will be -> C:\TAFC\R10\XMLMSSQL\sql

and for Oracle -> C:\TAFC\R10\XMLORACLE\sql

depends where you have install your TAFC, once done check your connection save and exit from the jshell session

uncomment in remote.cmd
set JEDIFILENAME_MD=%HOME%\VOC

and try to login into yout t24 system

Hope this helps

Please Log in or Create an account to join the conversation.

More
10 years 9 months ago #14131 by assefa.dagnachew
Replied by assefa.dagnachew on topic error while setting up environment T24 R10 + MSSQL
Hi Divesh,

I would like to say thank you first for your help.I try to do what you recommend but config-xmloracle/mssql is not there. Please help me to get the file for window.


Thank you.


Assefa

Please Log in or Create an account to join the conversation.

  • divesh
  • Topic Author
  • Offline
  • Senior Member
  • Senior Member
More
10 years 9 months ago #14149 by divesh
First from command prompt, enter the below command and check whether your system connect to database



sqlcmd -S VFTESTSRV -U sa -P vfc4IT -d TEST

VFTESTSRV is your server name

sa - username of SQL Server
vfc4IT - password
TEST - database

when you enter the command it will prompt as below

1>select db_name()
2>go

TEST


(1 rows affected)
1>

now exit from this command prompt

open a new session and login in jshell and type
jsh>config-XMLDRIVER
and check if u get the output
[3] Unable to execute program 'config-XMLDRIVER'

in remote.cmd

%DRIVER_HOME% should point to C:\TAFC\R10\XMLMSSQL

and then logout from jshell open a new session

jsh>jshow -c config-XMLMSSQL

if you don't see the error Unable to execute.... as above

then try
jsh>config-XMLMSSQL

Please Log in or Create an account to join the conversation.

More
10 years 4 months ago #15030 by Ridwan
Dear All,
I have configure 1 environment for Linux Redhat and DB2 which is working fine. In the same server I created another test environment and when I try to go to jshell I get this error

messege :

drvOpen: *** ERRORR *** Unable to initialise DriverData Structure, check ./XMLdriver.log for more information

Kindly help , its urgent

Tks

Ridwan

Please Log in or Create an account to join the conversation.

More
1 year 11 months ago #23675 by kowalskiyaar
Replied by kowalskiyaar on topic error while setting up environment T24 R10 + Linux
Hi Ridwan,

i am also facing the same issue with DB2 along with R21 TAFC on RedHat. Can you provide your solution.

" drvOpen: Unable to initialise DriverData Structure, driver disabled "

Please Log in or Create an account to join the conversation.

  • VK
  • VK's Avatar
  • Away
  • Platinum Member
  • Platinum Member
  • Globus|G09-G13 TAFC|R05-R23 TAFJ|R19,R23-test
More
1 year 11 months ago #23681 by VK
Hi
looks that some environment variables are missing or that config-XMLDB2 wasn't properly executed.
 

Cheers
VK

Please Log in or Create an account to join the conversation.

Time to create page: 0.116 seconds