Forum Discussion
Kathryn_O_Malle
14 years agoContributor
Hi there,
Okay here goes...
1) On my XP Professional SP2 2002 SP2 via Control Pannel -> Administrative Tools -> ODBC Data Source Administrator I've defined a User DSN entry for our Access Database using the Microsoft Access Driver (*.mdb, *.accdb)
2) Within my SoapUI testcases I use Groovy Script steps when getting data from the external Access database
3) At the start of each Groovy script I have
4) I then define a connection to the external database via
5) I then create a results set via
NB: I use an Access Database view instead of directly accessing the underlying database table(s)
That's pretty much it...
I will also now try creating a little dummy project doing the above and attach it to the posting. Afraid I can't attach the actual work project due to various issues.
Kind regards
Adam
Okay here goes...
1) On my XP Professional SP2 2002 SP2 via Control Pannel -> Administrative Tools -> ODBC Data Source Administrator I've defined a User DSN entry for our Access Database using the Microsoft Access Driver (*.mdb, *.accdb)
2) Within my SoapUI testcases I use Groovy Script steps when getting data from the external Access database
3) At the start of each Groovy script I have
import groovy.sql.Sql
4) I then define a connection to the external database via
def sql = Sql.newInstance(context.expand('jdbc:odbc:<ODBC_Datasource_Name>),
context.expand(' '),
context.expand(' '),
"sun.jdbc.odbc.JdbcOdbcDriver")
5) I then create a results set via
def res = sql.firstRow("SELECT * FROM [<Access Database view name]....")
NB: I use an Access Database view instead of directly accessing the underlying database table(s)
That's pretty much it...
I will also now try creating a little dummy project doing the above and attach it to the posting. Afraid I can't attach the actual work project due to various issues.
Kind regards
Adam