LoadRunner parametric connection Oracle, MySQL data source error and Solutions

LoadRunner Parametric connection Oracle, MySQL data source error and Solutions

(My system is Win7 64, two small partners because it is the default installation of LR, installed in

When the final parameterization occurs, the connection string cannot be loaded automatically:

Finally through the installation, the problem is addressed to this

1. Through the database connection parameterized a large amount of data, the computer has successfully installed the database driver locally, and the local can configure the data source is successful, the configuration of the data source in the LoadRunner is unable to find the corresponding database driver.

----A: Check the current version of the LoadRunner tool, whether it is 32-bit or 64-bit (currently not 64-bit), 32-bit is not able to install the 64-bit MySQL driver, even if the operating system is not high.

----B: After reloading other versions of MySQL driver, reboot LoadRunner is required to ensure the installation data reload successfully.

----C: After the data source is configured directly via LoadRunner, the computer restarts to load the configured data source, which is visible locally.

2. Operating system Win7 64-bit, through the database connection parameterized large amounts of data, the following three cases of reasons
---A: The computer has already configured the Oracle data source successfully, selecting the configured data source in LoadRunner without automatically bringing in the connection string

---B: Select the database name that has been connected, and test the data source configuration as follows

---C: Enter the data source for the TNS Server name format "ip:port/database name" and click "Test Connection" to prompt for the following error

Unable to connect
sqlstate=08004
[Oracle] [ODBC] [Ora] Ora-12154:tns: Unable to resolve the specified connection identifier
Possible causes:
1, the service name with special characters, so need to remove the service name of the special characters.
2. Carefully check that you set the correct parameter for the connection Oracel database: Test the connection successfully ≠ the database parameters are correct.
3, application services such as: LoadRunner, ODBC driver installed in a directory with spaces, such as D:\Program Files (x86).

(My problem is solved by this method)

Workaround: Check each parameter to complete the correct, reinstall LoadRunner in the non-empty directory.

ODBC even Oracle database error, sqlstate=im004                                                     

Under WINDOW7, use ODBC to connect to Oracle Database (11g), and then report the following error:

Unable to connect

sqlstate=im004

[Microsoft] [ODBC Driver Manager] Driver Sqlallochandle on Sql_handle_env failed

Workaround:

The original is oracle_home pointing wrong, I even have to be oracle11g database, but the environment variable in the specified oracle_home as a oracle10g path, so even when the ODBC report driver error. View environment variables If there are multiple values in the path

LoadRunner parametric connection Oracle, MySQL data source error and Solutions