| Groups | Blog | Home |
sql server clients : Novell and Apple clients
connect to SQL Server 2000. Here is my understanding: Novell clients 1) Can connect using NWlink IPX/SPX only Apple (Macintosh) clients 1) Can connect using AppleTalk 2) Can connect using TCP\IP 3) Can connect using multiprotocol over a) named pipes ? b) TCP\IP ? Thanks
Hi
I am not sure what the question is here! I have never used IPX/SPX, but if you have configured the server to accept these protocols, clients can connect using them. John [quoted text, click to view] "john" <john@nospam.com> wrote in message news:09a601c38ae5$8ea3f700$a401280a@phx.gbl... > My company wants Novell and Apple clients to be able to > connect to SQL Server 2000. > > Here is my understanding: > > Novell clients > 1) Can connect using NWlink IPX/SPX only > > Apple (Macintosh) clients > 1) Can connect using AppleTalk > 2) Can connect using TCP\IP > 3) Can connect using multiprotocol over > a) named pipes ? > b) TCP\IP ? > > Thanks >
I apologize for the confusion. Let me try the questions
again. Client SQL Server Net-Library Net-Library ---------------------------------------------------------- 1) Macintosh computer Server running - can connect to SQL Server running: a) AppleTalk ADSP AppleTalk ADSP b) TCP/IP TCP/IP c) Multiprotocol over named pipes Multiprotocol d) Multiprotocol over TCP/IP Multiprotocol e) Named Pipes ? Named Pipes 2) client computer on Novell Network - can connect to SQL Server running: a) NWLink IPX/SPX NWLink IPX/SPX b) ? others - TCP/IP Multiprotocol 3) Banyan Vines client - can connect to SQL Server running: a) Banyan Vines SSP Banyan Vines SSP b) ? others [quoted text, click to view] >-----Original Message-----
>Hi John, > >According to your description, I am not sure what your question is. Do you >mean you want to know how to connect to SQL Server using multiprotocol? > >If so, this article describes how to programmatically specify the client >network library in the connection string when you connect to a SQL Server >database. >313295 HOW TO: Use the Server Name Parameter in a Connection String to >Specify >http://support.microsoft.com/?id=313295 > >Please feel free let me know if this solves your problem or if you would >like further assistance. > >Regards, > >Michael Shao >Microsoft Online Partner Support >Get Secure! - www.microsoft.com/security >This posting is provided "as is" with no warranties and confers no rights. > >.
Hi John,
According to your description, I am not sure what your question is. Do you mean you want to know how to connect to SQL Server using multiprotocol? If so, this article describes how to programmatically specify the client network library in the connection string when you connect to a SQL Server database. 313295 HOW TO: Use the Server Name Parameter in a Connection String to Specify http://support.microsoft.com/?id=313295 Please feel free let me know if this solves your problem or if you would like further assistance. Regards, Michael Shao Microsoft Online Partner Support Get Secure! - www.microsoft.com/security This posting is provided "as is" with no warranties and confers no rights.
If you can tell me what client network-libraries can run
on a Macintosh client computer that needs to connect to SQL Server. Thanks [quoted text, click to view] >-----Original Message-----
>Hi John, > >Thanks for your update. Detailed information and completed questions help >us to deal with the issue more efficiently. How do you connect to SQL >Server, in application or using some tools? >According to your description, do you mean you want to connect to SQL >Server with Macintosh computer via Named Pipes? >I am afraid that it is impossible. We need to have windows account to use >Named Pipes. > >What are the other questions? Please describe them in detailed. > >Users are unable to connect to a SQL Server 2000 Named SPX Instance, if >there is also a SQL Server 2000 default Instance listening on IPX/SPX, or a >default Microsoft SQL Server 7.0 Server listening on IPX/SPX. >Alternatively, if there are two named instances, both listening on IPX/SPX, >they both attempt to listen on the same SPX port 33854. No errors are >reported in the SQL Server errorlog even though the Named Instance failed >to listen on port 33854. >For additional information, please refer to the following article: >270667 BUG: SQL Server 2000 SPX Named Instance Uses the Same Port as the >http://support.microsoft.com/?id=270667. > >I am standing by for your response. > >Regards, > >Michael Shao >Microsoft Online Partner Support >Get Secure! - www.microsoft.com/security >This posting is provided "as is" with no warranties and confers no rights. > >.
Hi John,
Thanks for your update. Detailed information and completed questions help us to deal with the issue more efficiently. How do you connect to SQL Server, in application or using some tools? According to your description, do you mean you want to connect to SQL Server with Macintosh computer via Named Pipes? I am afraid that it is impossible. We need to have windows account to use Named Pipes. What are the other questions? Please describe them in detailed. Users are unable to connect to a SQL Server 2000 Named SPX Instance, if there is also a SQL Server 2000 default Instance listening on IPX/SPX, or a default Microsoft SQL Server 7.0 Server listening on IPX/SPX. Alternatively, if there are two named instances, both listening on IPX/SPX, they both attempt to listen on the same SPX port 33854. No errors are reported in the SQL Server errorlog even though the Named Instance failed to listen on port 33854. For additional information, please refer to the following article: 270667 BUG: SQL Server 2000 SPX Named Instance Uses the Same Port as the http://support.microsoft.com/?id=270667. I am standing by for your response. Regards, Michael Shao Microsoft Online Partner Support Get Secure! - www.microsoft.com/security This posting is provided "as is" with no warranties and confers no rights.
Hi
Does this help? http://msdn.microsoft.com/library/default.asp?url=/library/en-us/instsql/in_runsetup_77g3.asp John [quoted text, click to view] "john" <john@nospam.com> wrote in message news:0a5301c38c99$90d292b0$a401280a@phx.gbl... > If you can tell me what client network-libraries can run > on a Macintosh client computer that needs to connect to > SQL Server. > > Thanks > > > > >-----Original Message----- > >Hi John, > > > >Thanks for your update. Detailed information and > completed questions help > >us to deal with the issue more efficiently. How do you > connect to SQL > >Server, in application or using some tools? > >According to your description, do you mean you want to > connect to SQL > >Server with Macintosh computer via Named Pipes? > >I am afraid that it is impossible. We need to have > windows account to use > >Named Pipes. > > > >What are the other questions? Please describe them in > detailed. > > > >Users are unable to connect to a SQL Server 2000 Named > SPX Instance, if > >there is also a SQL Server 2000 default Instance > listening on IPX/SPX, or a > >default Microsoft SQL Server 7.0 Server listening on > IPX/SPX. > >Alternatively, if there are two named instances, both > listening on IPX/SPX, > >they both attempt to listen on the same SPX port 33854. > No errors are > >reported in the SQL Server errorlog even though the > Named Instance failed > >to listen on port 33854. > >For additional information, please refer to the > following article: > >270667 BUG: SQL Server 2000 SPX Named Instance Uses the > Same Port as the > >http://support.microsoft.com/?id=270667. > > > >I am standing by for your response. > > > >Regards, > > > >Michael Shao > >Microsoft Online Partner Support > >Get Secure! - www.microsoft.com/security > >This posting is provided "as is" with no warranties and > confers no rights. > > > >. > >
Hi John,
Thanks for John Bell's help. The server AppleTalk (ADSP) Net-Library allows Apple Macintosh? clients to connect to SQL Server using native AppleTalk (as opposed to TCP/IP Sockets). Did you install the Mac Office on your Macintosh client computer? According to my experience, we can connect to SQL Server via Mac Office. For additional information regarding this issue, please refer to the following articles. 182496 XL98: How to Completely Remove Data Access http://support.microsoft.com/?id=182496 184793 OFF98: Minimum Extensions and Control Panels Required for ODBC http://support.microsoft.com/?id=184793 184684 XL98: Cannot use File DSN to Connect to SQL Server via AppleTalk http://support.microsoft.com/?id=184684 Also, how do you want to connect to SQL Server? Do you mean that you want to use some tools provided by Macintosh to connect to SQL Server or you want to code some program to connect to SQL Server? Regards, Michael Shao Microsoft Online Partner Support Get Secure! - www.microsoft.com/security This posting is provided "as is" with no warranties and confers no rights.
Thanks for the help. I was asked by my employer to find
out information about connecting Macintosh clients to SQL Server. The information in BOL seemed pretty thin. I guess I don't understand if the Client Connectivity Tools (Query Analyzer, isql, etc.) run on Macintosh clients. Also do the other Client Network Libraries (TCP/IP, multiprotocol) run on Macintosh clients or not. [quoted text, click to view] >-----Original Message-----
>Hi John, > >Thanks for John Bell's help. The server AppleTalk (ADSP) Net-Library allows >Apple Macintosh? clients to connect to SQL Server using native AppleTalk >(as opposed to TCP/IP Sockets). >Did you install the Mac Office on your Macintosh client computer? According >to my experience, we can connect to SQL Server via Mac Office. For >additional information regarding this issue, please refer to the following >articles. > >182496 XL98: How to Completely Remove Data Access >http://support.microsoft.com/?id=182496 > >184793 OFF98: Minimum Extensions and Control Panels Required for ODBC >http://support.microsoft.com/?id=184793 > >184684 XL98: Cannot use File DSN to Connect to SQL Server via AppleTalk >http://support.microsoft.com/?id=184684 > >Also, how do you want to connect to SQL Server? Do you mean that you want >to use some tools provided by Macintosh to connect to SQL Server or you >want to code some program to connect to SQL Server? > >Regards, > >Michael Shao >Microsoft Online Partner Support >Get Secure! - www.microsoft.com/security >This posting is provided "as is" with no warranties and confers no rights. > >.
Hi John,
Thanks for your feedback. As I understand, there is no version of Query Analyzer or isql for Macintosh. TCP/IP can run on Macintosh client. When we installed Mac Office on the Macintosh client, we can connect to SQL Server via TCP/IP. For additional information regarding this issue, please refer to the following article: http://support.microsoft.com/?id=182496 Thanks for using MSDN newsgroup. Regards, Michael Shao Microsoft Online Partner Support Get Secure! - www.microsoft.com/security This posting is provided "as is" with no warranties and confers no rights.
Don't see what you're looking for? Try a search.
|
March 2003
May 2003
June 2003
July 2003
August 2003
September 2003
October 2003
November 2003
December 2003
January 2004
February 2004
March 2004
April 2004
May 2004
June 2004
July 2004
August 2004
September 2004
October 2004
November 2004
December 2004
January 2005
February 2005
March 2005
April 2005
May 2005
June 2005
July 2005
August 2005
September 2005
October 2005
November 2005
December 2005
January 2006
February 2006
March 2006
April 2006
May 2006
June 2006
July 2006
August 2006
September 2006
October 2006
November 2006
December 2006
January 2007
February 2007
March 2007
April 2007
May 2007
June 2007
July 2007
August 2007
September 2007
October 2007
November 2007
| home · blog · groups | Questions? Comments? Contact the dn |