18 January 2026:


This forum is now archived and is in read-only mode. Please continue discussions on our improved new Sahi Pro Community forum.



Sahi Pro is an enterprise grade test automation platform which can automate web, mobile, API, windows and java based applications and SAP.

Excel connection string not successful

badrimallireddybadrimallireddy Members
edited November -1 in Sahi - Open Source
HI Narayana,

I am having issue with making a connection with JDBC ODBC drivers to excel
below is the error i am seeing

exception: java.sql.SQLException: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified

Sahi version 3.5
fire fox 12
java version 7
MS Office 2007 (32 bit)
Install MS access driver for 32 bit
and JDB ODBC bridge
windows 7 64 bit

and finally i am new to sahi or java, can you please help me on this ASAP.

BElow is my connection string
var $db = _getDB("sun.jdbc.odbc.JdbcOdbcDriver", "jdbc:odbc:Driver={Microsoft Excel Driver (*.xls, *.xlsx, *.xlsm, *.xlsb)};DBQ=C:\\Users\\Bada0656\\sahi\\userdata\\TCM.xls;readOnly=false", "", );

var $attributes = $db.select("select UserId from [Logins$] WHERE Role='IT Racker'");
_debug($attributes);

Thanks in Adavance.

Comments

  • ashokashok Members
    Try this below line of code.

    $db = _getDB("sun.jdbc.odbc.JdbcOdbcDriver", "jdbc:odbc:Driver={Microsoft Excel Driver (*.xls)}; DBQ=C:\\Users\\Bada0656\\sahi\\userdata\\TCM.xls; readOnly=false", "", "");

    also make sure below points.
    - worksheet name is "Logins" in TCM.xls
    - a column in Logins "Role" with value 'IT Racker'.
  • microjobmicrojob Members
    The presentation layer should be designed to be attractive, intuitive, logical, and user-friendly. As personal computers (and Apple products, of course) now process information with lightning speed, users can quickly and automatically manage and process outsource small jobs data right at their desks by pressing a few buttons or by dragging and dropping information to a different part of the screen. If the screen is laid out well, they can do so with a minimum of frustration and correctly trigger the proper actions behind the scenes.
  • microjobmicrojob Members
    Performing any one of the actions sounds like a simple task you can do manually. When businesses must enter, update, and manipulate fiverr alternative information on hundreds, thousands, millions of accounts, doing it by hand becomes an overwhelming task that takes a huge block of time and manpower. Software automates the process.
  • badrimallireddybadrimallireddy Members
    Hi Ashok,

    I tried changing my driver but no luck.
    Can you please suggest me any other solution, am i configuring wrong things.
    i am completly new to java and sahi.
  • badrimallireddybadrimallireddy Members
    Can Somebody help me please, i am struck in between, i have been trying too many things
    but no success.
Sign In or Register to comment.