Excel_JDBC30.jar

rajasekhar

Hi

For Data driven testing on Sahi Tool
we need to download Excel_JDBC30.jar file and set it in Sahi.bat

'SET EXT_CLASS_PATH=C:\sahi\sahi_20080305\sahi\extlib\Excel_JDBC30.jar;'

Could you please help me in which URL can I download it.

Thanks in Advance
Rajasekhar & Mahesh

narayan

For working with Excel, you can use the JDBC:ODBC bridge which is already available on Windows. Have a look at this post:
http://sahi.co.in/w/working-with-excel-sheets

rajasekhar

Hi

Could you please help me, where I went wrong

var $db = _getDB("sun.jdbc.odbc.JdbcOdbcDriver","jdbc:odbc:Driver={Microsoft Excel Driver(*.xls)};DBQ=D://sahi//data//pass.xls;","","");
$rs = $db.select("Select * from [Sheet1$]");

After running the script, I got the below message on Sahi Controller
--Stopped Playback: FAILURE--

When i checked it in View logs

Starting script
JSERROR SyntaxError: syntax error at Jul 23, 2009 6:25:26 PM
Stopping script

Thanks in Advance
Rajasekhar & Mahesh

dp

Please let me know how the following code goes

var $db = _getDB("sun.jdbc.odbc.JdbcOdbcDriver","jdbc:odbc:Driver={Microsoft Excel Driver (*.xls)};DBQ=D:\\sahi\\data\\pass.xls;readOnly=false","","");

$rs = db.select("select * from [Sheet1$]");

Cheers
Dilip