 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
SQL Server Forum / DB Engine / SQL Server / March 2008Visual Studio 2008
Unable to log into remote Sql Server through a local machine using Visual Studio 2008. I received the following error message: "A connection was sucessfully established with the server, but then an error occurred during the login process. (provider:TCP Provider, error:0 - The specified network name is no longer available.)" Can you connect to the remote SQL Server using other programs (e.g. Management Studio)? > Unable to log into remote Sql Server through a local machine using Visual > Studio 2008. I received the following error message: [quoted text clipped - 3 lines] > occurred during the login process. (provider:TCP Provider, error:0 - The > specified network name is no longer available.)" No, I did not use any other product other than Visual Studio 2008. But, I did receive a suggestion to download a client: http://dev.mysql.com/downloads/connector/net/5.2.html Additionally, the remote machine hosts MySQL You confuse us. In your fist post, you say you want to connect to SQL Server. You now show some article regarding connecting to MySQL.  SignatureTibor Karaszi, SQL Server MVP http://www.karaszi.com/sqlserver/default.asp http://sqlblog.com/blogs/tibor_karaszi > No, I did not use any other product other than Visual Studio 2008. > > But, I did receive a suggestion to download a client: > > http://dev.mysql.com/downloads/connector/net/5.2.html > You confuse us. In your fist post, you say you want to connect to SQL > Server. You now show some article regarding connecting to MySQL. That confused me too. I think the remote server has both SQL Server and MySQL, since the error message in the original post certainly looks like it came from SQL Server. But I think the article is the wrong tree to be barking up. If hal wants to connect to SQL Server, then hal should be trying with Management Studio or something along those lines, not some MySQL client. My apologies for the confusion on our side, the remote server hosts MySQL. We are accessing the remote Linux server through cPanel and WHM (Linux® / BSD). The server is running: FEDORA 7 i686 on virtuozzo - WHM X v3.1.0 Then you are in the wrong place. You should look for usenet newsgroups dedicated to mySQL. A > My apologies for the confusion on our side, the remote server hosts MySQL. > We [quoted text clipped - 4 lines] > > FEDORA 7 i686 on virtuozzo - WHM X v3.1.0 I strongly disagree. Because, the local machine is running Visual Studio 2008 on a Windows 2003 server. The remote Linux machine is nothing more than a client. >I strongly disagree. Because, the local machine is running Visual Studio >2008 > on a Windows 2003 server. The remote Linux machine is nothing more than a > client. What does any of this have to do with Microsoft SQL Server? OK. Why not visit the following screen shots, listed below: http://dslcomputer.com/Docs/sql.pdf http://dslcomputer.com/Docs/SQLClient.pdf Is there a conversion client between Sql Client (Visual Studio 2008) and MySQL? It seems there is some confusion between what Visual Studio, SQL Server and MySQL is. Visual Studio is a development tool. SQL Server (whcih is what this newsgroup is all about) and MySQL are database management systems. What you want to do is connect from Visual Studio to your Database Management System (MySQL). But the PDF you refer to show that you attemt to connect to a SQL Server. In short, your question is about how to use a dev tool (VS) to connect to MySQL. I suggest you try in a Visual Studio forum. SignatureTibor Karaszi, SQL Server MVP http://www.karaszi.com/sqlserver/default.asp http://sqlblog.com/blogs/tibor_karaszi > OK. Why not visit the following screen shots, listed below: > [quoted text clipped - 4 lines] > Is there a conversion client between Sql Client (Visual Studio 2008) and > MySQL? Sorry man, you are so wrong. > OK. Why not visit the following screen shots, listed below: > > http://dslcomputer.com/Docs/sql.pdf You cannot use SqlClient (namespace) to connect to MySql. It is a different database server from MS Sql Server. > http://dslcomputer.com/Docs/SQLClient.pdf This have nothing to do with SQL Server or MySql. You need to go to MySql website to find more information on how to use it with .NET applications. Not here. This NG is abount MS SQL Server, not MySQL, nor Visual Studio200x. > Is there a conversion client between Sql Client (Visual Studio 2008) and > MySQL? No way you are wrong, because the remote MySql sever is not on a development platform - Visual Studio is on a developers platform. Where are the dev apps? From: "Russell Rademacher" <241999+eSF1wyM9Qz@tickets.cpanel.net> (Add as Preferred Sender) ? Date: Thu, Mar 20, 2008 2:09 pm To: admin@dslcomputer.com Hello, No. It assumes that yours is windows platform with mysql db server on it. It is not Windows platform, it is a linux platform, and it does not need any drivers for it. You have to clarify that position with them, which you will get more proper responses for this. The problem is on your client side, which it need a driver to connect to the server, not on the server itself. -- Russell Rademacher cPanel Technical Analyst 2 ------------------------------------------- cPanel Conference 2008 - Be There! June 11-13 2008 Houston, TX http://conference.cpanel.net/ I searched my MSDN subscription and found nothing. Could you send the path link. > No way you are wrong, because the remote MySql sever is not on a > development > platform - Visual Studio is on a developers platform. Where are the dev > apps? Dude, this newsgroup is about SQL Server. You need to go visit either a newsgroup about MySQL, or a newsgroup about Visual Studio, or maybe both. It doesn't seem like you even understand the difference between a development tool, a workstation, and an RDBMS, but maybe someone out there can help you out. |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2009 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.