seeking Help : Connection to Database
User ian_boyus (firstname.lastname@example.org) posted:
I am a beginner with just few days of exposure to winrunner.
I am trying to connect to MS access by using Database
chosen specify SQL statement>in the connection string> I created New
data source with driver for MS Access. In the ODBC Microsoft MS
access setup,I selected NWIND.MDB. In the system database, I have
selected None and (also tried with other option,Database).I selected
the sql statement SELECT Categories.Category Name
Now it is giving error "Failed to capture data from database".
Could you please guide me where I am making mistakes.
Hope you all had a nice weekend.
Re: seeking Help : Connection to Database
create a DSN under system dsn tab in ODBC driver. Use DB COnnect and execute query functions to get the data. Let me know if you have any questions further.