Relative path for ODBC DSN
In my SilkTest script I am reading an Excel file by creating an ODBC DSN.
While Creating the ODBC DSN it asks me for the file name and path. Is it possible to create the ODBC DSN using relative path?
I apprecite your help.
Re: Relative path for ODBC DSN
To access data from Excel, no need to create DSN.
Use like below or see my post related to this.
[ ] //connect to the database
[ ] //OK2===> hDB = DB_Connect ("DRIVER=Microsoft Excel Driver (*.xls);DBQ=c:\silktest\mysamples\exceltrial\excel trial.xls")
[ ] //OK1===> hDB = DB_Connect ("DRIVER=Microsoft Excel Driver (*.xls);FIRSTROWHASNAMES=1;READONLY=FALSE;DRIVERID =790;DBQ=C:\SilkTest\mysamples\ExcelTrial\ExcelTri al.xls")