hi, you can use following codes ( may be u need to modify a bit)
Set gobjConnectionAs400 = CreateObject("ADODB.Connection")
gobjConnectionAs400.CommandTimeout= 600
gobjConnectionAs400.ConnectionString = "Driver=iSeries Access ODBC
Driver;System="& Environment("DBURL") & ";Uid=" & Environment("DBUSER") &
";Pwd="& Environment("DBPASSWORD") &"; ":gobjConnectionAs400.Open
Thanks,
Ashish gupta
Gurgaon,Haryana
On Thu, Jul 24, 2014 at 8:28 AM, palyam rakesh <[email protected]>
wrote:
> Hi all,
>
> *Scenario:* My machine is configured with Data Studio client, where my
> required DB2 data base is configured. Through Data Studio, connection is
> successful. Here are configuration parameters I am having - Connection,
> Host, Username, Password, Port, Connection URL.
> When connection is established to data base, in the trace view I got to
> know "Run method as - JDBC".
>
> *DB2 details* - DB2 for z/OS (V10)
>
> *Requirement* - I have to make connectivity to DB2 through UFT / QTP.
>
> *Queries -*
> 1. Can we make DB2 connectivity with UFT with out installing any drivers /
> DSN configuration ? If so, based on the configuration parameters I am
> having, what will be the connection string ?
> 2. If DB2 connectivity with UFT can be done only with installation of
> drivers, then which drivers to be installed - JDBC / ODBC ? (From data
> studio, connection is through JDBC)
> - Could anyone pls share the process to install & configure drivers &
> connection string that can be used in script.
>
> *Thanks in advance !*
>
> --
> --
> You received this message because you are subscribed to the Google
> "QTP - HP Quick Test Professional - Automated Software Testing"
> group.
> To post to this group, send email to [email protected]
> To unsubscribe from this group, send email to
> [email protected]
> For more options, visit this group at
> http://groups.google.com/group/MercuryQTP?hl=en
>
> ---
> You received this message because you are subscribed to the Google Groups
> "QTP - HP Quick Test Professional - Automated Software Testing" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to [email protected].
> For more options, visit https://groups.google.com/d/optout.
>
--
--
You received this message because you are subscribed to the Google
"QTP - HP Quick Test Professional - Automated Software Testing"
group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to
[email protected]
For more options, visit this group at
http://groups.google.com/group/MercuryQTP?hl=en
---
You received this message because you are subscribed to the Google Groups "QTP
- HP Quick Test Professional - Automated Software Testing" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
For more options, visit https://groups.google.com/d/optout.
