October 7, 2002 at 1:06 pm
I tried to find a basic question discussion section but couldn't I hope this is ok to post here. I am learning about SQL and I had some basic questions. I would appreciate any help I can get. Ok now to the questions....
1. What are some types of clients that can be used to connect to SQL Server 2000?
2. What are the necessary requirments necessary for communication between the client and server?
3. What are the benefits and drawbacks of using ODBC to configure your client applications?
I really do appreciate any help you can give me. I was looking at some of the posting her and it is amazing how much some of you guys know about this topic. Hopefully I can be that good some day.
Many Thanks
Morgan
October 7, 2002 at 1:46 pm
Post as often as you like.
#1 - Anything that can open an ODBC or OLEDB connection, there is a JDBC driver too.
#2 - Assuming you have one of the items from #1, you need a network connection, typically TCP/IP or Named Pipes.
#3 - OLEDB drivers are newer (possibly better in some cases). ADO.Net moves even further from ODBC. ODBC will work fine if that is what you have. On a Win platform I'd install the latest MDAC and use v2.6 or higher with the OLEDB driver.
Andy
October 7, 2002 at 2:38 pm
ODBC, AFAIK, is no longer being worked on at MS, so the OLEDB drivers are getting the latest enhancements. For basic selects, might not matter. For more complicated things, like MDX, ODBC might not work.
I also agree with what Andy wrote above.
Steve Jones
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply