error while setting up environment T24 R10 + MSSQL

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

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

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

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

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

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

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 "

Hi
looks that some environment variables are missing or that config-XMLDB2 wasn't properly executed.