Skip to main content

Oracle SQL Developer & Named MSSQL Instance

Its a small tip to connect to a ‘Named MSSQL Instance’ using Oracle SQL Developer. Oracle SQL Developer allows you to connect to any database which has supported JDBC drivers. You can add these drivers either using “Help –> Check for Updates” and by selecting “Third Party SQL Developer Extensions” option. This will list available updates, from which you can select the needed drivers. Second option is adding these drivers from your local drive using “Tools –> Preferences” and by selecting the “Database –> Third Party JDBC Drivers” option from the tree given in the left column.
If you installed needed driver for MSSQL database you’ll get the tab “SQL Server” on the New Database Connection window. If you observe this window, you’ll see that there is no text field/option to provide “Database Instance Name”. This window is simple to create a Database Connection to Unnamed MSSQL Database Instance. The big question is how do we create a connection to a Named MSSQL Database Instance!
Its really simple – All you need to do is add this information to the “Port” text field.

In the above example, I’ve used ‘1433’ which is the default port number for MSSQL. And the Instance I am trying to connect to, is ‘MyInstance’. Well that is all you need!, Happy Querying!!!


striker said…
this will connect you to themaster database of your second instance. You forgot to specify the database, say AdventureWorks in Instance2

The code will be

Popular posts from this blog

Hosting Multiple Domains In Tomcat

Tomcat allows us to host multiple domains in one instance, using multiple 'Host' tags. In this article I will explain how to do it on Tomcat. This is very simple configuration using 'Host' tags in your server.xml. A novice can also understand this configuration very easily.
Before going into the details of the configuration first lets have a look at the 'Host' tag, 'Context' tag and 'Alias' tags first.
<Host name="domain1" appBase="[application base]" autoDeploy="[true/false]" unpackWARs="[true/false]"> <Alias>...</Alias> <Context path="" docBase="" reloadable="[true/false]"/> </Host> First lets have a look at 'Alias' tag. This tag is used to provide aliases for your actual domain. For example you have a domain called '', and you want to run the same application for '' also…

File Uploading Using Servlets, JSP and Commons File Upload API

I’ve seen many developers who are at the early stages of their career have problems with this topic and seen many posts in forums asking how to do it – File Uploading using Servlets, JSP!; this article will provide an example using Commons File Upload API. I tried to make the example as simple as possible, hope it helps those early birds. Example uses JSP to provide the pages with form where user can select the file to upload with other form fields, Commons File Upload API to process submitted form and read form fields separately, and Servlets as middle layer between JSP and Commons File Upload API, example also has ANT build script to generate the distributables. All the code can be downloaded, links to these resources are provided at the end of this post, lets get on with the example then.
The flow in this example is as depicted in the following picture.
As you can see, user selects the file to upload and provides normal form data as well, using "index.jsp" and submits th…

Simple AJAX [, JSP] Example

You will find many examples to learn how AJAX [Asynchronous Java Script And XML] works, but this one is different. Its one of the best way of using AJAX in web applications. The difference -  many of the examples you find uses Java Script to parse the AJAX response, this example avoids that parsing Java Script and uses JSP to generate the HTML and uses simple Java Script just to make the asynchronous call and show the response. It shows simple way of using JSP and AJAX with as much less Java Script as possible. This article wont go into details of what AJAX is and how to make AJAX calls, it explains one good way among many to use AJAX. Lets get on with it then!
The flow of this example is like this – A simple JSP page where user performs an action [button click in this example] to get list of employees, on this action we’ll make an Asynchronous call to a Servlet which will prepare the dummy employee data and sends that data to a JSP page. This JSP generates the HTML displaying the em…