Solved

SQL Server Client Side Configuration

Posted on 2011-09-15
3
302 Views
Last Modified: 2012-06-27
Hi All,
I have IBM websphere application server and need to configure a JDBC/database connection for a remote windows SQL server 2008?

What min I have to install at client side to connect to a SQL server database?
Is there anything like Oracle Instant Client (doesn't need a install)  for SQL server.

Thanks
0
Comment
Question by:crazywolf2010
  • 2
3 Comments
 
LVL 17

Accepted Solution

by:
dbaSQL earned 500 total points
Comment Utility
This is a very nice write up:
http://www.devdaily.com/java/edu/pj/pj010024
0
 

Author Comment

by:crazywolf2010
Comment Utility
Hi Mate,
That is a brilliant article.

Unfortunately the JBDC drivers will only try and get connection to the database. Sometimes i need something more to debug jdbc connection issues. I am not a developer, i work as a DBA.

I want to know bit more on installing client side tools & configuring remote SQL server connections. At same time , I don't want to install MS visual studio. I will be OK as far as I can use sqlcmd and get connection to remote database. At least I can prove to the developers it's not my problem. What do I need on the box?

thanks
0
 

Author Comment

by:crazywolf2010
Comment Utility
Hi,
What about SQL server workstation installation? Do you need that installed at every client machine which need access to remote SQL database?

Is it same like Oracle client installation which have all libraries,dlls,SQLnet files & sqlplus client side utility needed to carry a remote database connection?

Many Thanks
0

Featured Post

Highfive + Dolby Voice = No More Audio Complaints!

Poor audio quality is one of the top reasons people don’t use video conferencing. Get the crispest, clearest audio powered by Dolby Voice in every meeting. Highfive and Dolby Voice deliver the best video conferencing and audio experience for every meeting and every room.

Join & Write a Comment

Let's review the features of new SQL Server 2012 (Denali CTP3). It listed as below: PERCENT_RANK(): PERCENT_RANK() function will returns the percentage value of rank of the values among its group. PERCENT_RANK() function value always in be…
Slowly Changing Dimension Transformation component in data task flow is very useful for us to manage and control how data changes in SSIS.
Via a live example, show how to backup a database, simulate a failure backup the tail of the database transaction log and perform the restore.
Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables. Make a table: Update a specific column given a specific row using the UPDATE statement: Remove a set of values using the DELETE s…

771 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now