![]() I was able to select "MySQL Database" provider, enter the server name, user name and password options, and the new connection was finally added to the "Data Connections" tree successfully.Īlso, I tried the same steps as above, but using "MySQL Installer 5.6.25" ( ) - which installed "mysql-connector-net-6.9.6" and "mysql-visualstudio-plugin-1.2.3" - and the error wasn't present either. 2) Search your machine for copies of TNSNAMES.ORA and copy the relevant one over to this location. This will typically be set to the etwork\admin.![]() Note: In the case of a remote connection, provide the IP address or resolvable hostname of the machine where the database is installed. 1) When attempting to create a new connection in Server Explorer, look in the Oracle Connection dialog for the current path to TNSNAMES.ORA. In there, I clicked on all the options, hit a lot of keys randomly and the window did not close. Connecting to Oracle Database using sqlplus command As a final touch I would recommend you get an Oracle SQL Developer for more convenient work with Oracle databases. The "Choose Data Source" popup window was shown. In the Add Connection dialog if the Data Source field is not already set to Oracle Database (ODP.NET, Managed Driver), click the Change button. Show "Server Explorer", and right click on "Data Connections" to select the "Add Connection. (If Server Explorer is not visible in Visual Studio, select View->Server Explorer from the Visual Studio menu. Download and install "mysql-connector-net-6.7.4.msi" and "mysql-visualstudio-plugin-1.0.2.msi"Ĥ.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |