.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Register
 
Win Surprise Gifts!!!
Congratulations!!!


Top 5 Contributors of the Month
Easy Web
Imran Ghani
Post New Web Links

ODBC connection issue to SQL 2000 SP4. [TCP/IP Sockets]Specified SQL server not found.

Posted By:      Posted Date: April 14, 2011    Points: 0   Category :
 

Server: Stand alone Windows 2003 R2 Enterprise x64 Edition Service Pack 2

The server has 4 quad-core processors with 32Gb RAM

SQL: 2 instances of SQL Server 2000 Enterprise Edition SP4 with cumulative update version: 8.00.2040

I am trying to connect to the named instance of SQL Server with an ODBC connection. I am a local admin on the server and a sysadmin on both the default instance and the named instance. I get the error message

Connection failed:
SQLState: '01000'
SQL Server Error: 11004
[Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]ConnectionOpen (Connect()).
Connection failed:
SQLState: '08001'
SQL Server Error: 6
[Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]Specified SQL server not found.

My users are trying to connect via SQL login and are also receiving the same error message.

The default instance is listening on port 1433. The named instance is listening on port 1464. There is no Windows firewall installed on the server.

The annoying thing is that if I click on the button called "Client Configuration" when using the "ODBC Data Source Administrator" dialogue wizard, and I un-tick the radio box called "Dynamically determine port", and hardcode the port 1464 into the dialogue box, everything works as it should do.

Unfortunately this


View Complete Post


More Related Resource Links

ODBC connection issue to SQL 2000 SP4. [TCP/IP Sockets]Specified SQL server not found

  

Server: Stand alone Windows 2003 R2 Enterprise x64 Edition Service Pack 2

The server has 4 quad-core processors with 32Gb RAM

SQL: 2 instances of SQL Server 2000 Enterprise Edition SP4 with cumulative update version: 8.00.2040

I am trying to connect to the named instance of SQL Server with an ODBC connection. I am a local admin on the server and a sysadmin on both the default instance and the named instance. I get the error message

Connection failed:
SQLState: '01000'
SQL Server Error: 11004
[Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]ConnectionOpen (Connect()).
Connection failed:
SQLState: '08001'
SQL Server Error: 6
[Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]Specified SQL server not found.

My users are trying to connect via SQL login and are also receiving the same error message.

The default instance is listening on port 1433. The named instance is listening on port 1464. There is no Windows firewall installed on the server.

The annoying thing is that if I click on the button called "Client Configuration" when using the "ODBC Data Source Administrator" dialogue wizard, and I un-tick the radio box called "Dynamically determine port", and hardcode the port 1464 into the dialogue box, everything works as it should do.

Unfortunately this

VS 2010: no Entity Framework or LINQ support for SQL Server 2000 SQLOLEDB connection?

  
Hello, I'm working with Visual Studio 2010 and for Data Connections am connecting to a SQL Server 2000 production database. When I try to drag a table to a .dbml file, the Object Relational Designer says, "The selected object(s) use an unsupported data provider."If I try to create an .edmx file via Generate from database, then the alert is, "This server version is not supported. You must have Microsoft SQL Server 2005 or later."So VS 2010 has no support for the Data Entity Framework or LINQ when connecting to a SQL Server 2000 database? If that is the case, what is the best data access strategy for this scenario?  

odbc connection to sql server c#

  
How can I use ODBC to connect to sql server 2005 in c# windows forms ??  Please post a code snippet as example ....  

ODBC connection to SQL Server 2005 Standard (on windows xp) with Windows authentication does NOT wor

  
I reviewed lots of postings, still could not find an answer. If I choose Windows authentication: - with TCP/IP and "Dynamically determine port" checked, I get the following error "The user is not associated with a trusted SQL Server connection; - with Named Pipes, Server Name & Pipe Name as "VSAXAONG", I get two errors, one after the other on the same pop-up:       Connection failed  SQL State 01000  SQL Server Error 1385 [Microsoft] [ODBC SQL Server Driver] [Named Pipes] ConnectionOpen (Connect()).       Connection failed  SQL State 08001 SQL Server Error 17 [Microsoft] [ODBC SQL Server Driver] [Named Pipes] SQL Server does not exist or access denied. If I choose SQL Server authentication and fill in the password - the ODBC connection works fine. I have to say that I created two different logins on the server, one for Windows authentication, and one for SQL Server authentication - both for the same Windows user name. I would appreciate any help I can get on this.  Thank you all in advance.

SQL Server Express 2005 connection timeout issue.

  
Client: Sql Sever Management Studio Express 2005 (SSMSE) on Vista Server: Sql Server 2005 Express on Windows Server 2008 Standard When I first try to log into SSMSE from the client machine, the login operation times out. When I retry, the login succeeds almost immediately. If I close the app and re-open it, the same thing happens. This appears to be infinitely repeatable. I am able to reproduce this behavior using SQLCMD.exe. Here's the error: "Timeout expired. The timeout elapsed prior to completion of the operation or the server is not responding. (Microsoft SQL Server)" The technical details reference Error Number -2 What may be unique or tricky about this client's network is that it's a mixture of IPv4 and IPv6. I believe the server is configured for both, but honestly the networking side of things is outside of my expertise. Has anyone else experienced a problem like this? I'm looking for some troubleshooting tips and of course a flat-out answer :-). Thank you in advance for your time and expertise - I hope I've broken the problem down to its simplest form. Will.

Issue with Connection of Sybase in SSIS and Linked Server in SQL Server

  
Iam having problem connecting with Sybase from SSIS or Link Server of SQL Server 2008.

 I have installed Sybase 12.5.1 OLE DB Driver and have also registered by running command:

 C:\sybase\DataAccess\OLEDB\dll>regsvr32 sybdrvoledb.dll

 We are also able to create System DSN from ODBC Administrator in Windows 7. I am also able to import data in the MS Access. Here is the System DSN I created, successfully.

 I would really appreciate you can help us out.


Catch 22 Database Connection Validation Issue w/ BIDS and Production Server

  

I have a rather simple SSIS package that exports data through an ODBC connection from an IBM iSeries database and copies that data to a SQL Server 2005 database.  When I was designing the application, I was able to connect to the iSeries database and store the user ID and password with my BIDS project and copy the data with out any problems.  Great!

When I finished designing and testing the project, I loaded it to the production server.  The final test was to schedule the process so that it would run each night.  I didn't realize it at the time but the password that I had stored with the project in BIDS was removed from the package and various MS documentation stated that I should create a configuration file and load the password from there.  So, I made the necessary changes to the project, adding a configuration file.  The config file is in the Miscellaneous folder within the BIDS project, however, it isn't automatically copied to the bin directory when I build the project.  I have to manually save it to the server, and then after importing the project I have to manually link to the necessary config fields.

This fixed the problem with the server, however, now I can not get BIDS to save my password with the connection string from within the designer.  This is a huge problem.  I am exporting from 21 different da

Remote Connection Of SQL Server 2000

  

Hi All,

Am creating a C# Windows Application. Am using SQL Server 2000 as my database. I have created a setup for my application. I have to install the application in some computers connected through WORKGROUP. Now am installing my application in a client machine which doesn't have any SQL Server or Visual Studio. After installing i need to configure the App.Config to set the ConnectionString. How can i do this? 

 

This is my connection string after installing. How can i modify this to access remote sql server?

 

<add key="ConnectionString" value="Password=sa;Persist Security Info=True;User ID=sa;Initial Catalog=Fahd;Data Source=(local)"/>


SQL Server 2005 Express ODBC connection error with Windows Vista Business

  
Hi
I have a SQL Server 2005 Express Edition installed on a Windows Server 2003 domain machine. When I do a connection with a client running Windows XP through the SQL 2008 ODBC driver I have no problem.  The problem is when I try to establish a connection using a client running Windows Vista Business Edition which is a member of the domain. Please help me to solve this issue.

Thanks in advance
Danilo Bucheli Sánchez

Sql Server connection issue : I can connect from a web app, but not from a windows app.

  

I have two applications, a win form and a web app. I am using  sql server on a local network. I can open a connection to the sql server from the web app, but the win form app always fails when i try to open a connection. I get a TCP provider error of all sorts. I am using the same connection string for both apps.

Any Idea,

Thanks

 

Additional Info:

Visual Studio 2010, Sql Server 2005,

 


microsoft management console issue in SQL Server 2000

  

Hi Team,

I have an issue starting the management console (enterprise manager), Installed SQL Server 2000 and when i try to open the enterprise manager got a pop-up Microsoft management console the selected file cannot be found.

more info installed using my username but am not the admin of the machine is this causing the issue, though i didn't face any issue in the installation and i haven't restarted the server after installation.

Any help would be greatly appreciated!!

Regards,

Eshwar.


C#, sockets, Windows and port 21 : A simple Client-server using TCP; connection dies after transfer

  

Hello,

I have a thread on Stackoverflow here:

http://stackoverflow.com/questions/4118800/c-networking-server-hangs-after-receiving-more-than-65535-bytes

In short: 

In a very VERY simple Client-Server solution the TCP connection dies after sending 65535 bytes. This only happens when I am connected on port 21. If I change the server port to for example port 22 the connection does not die.

I am posting the simple code here for reference.

CLIENT:

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Net;
using System.Threading;
using System.Net.Sockets;

namespace tWorks.Samcom.PassSocketPoller
{
  public class PollerTest2
  {
    private IPAddress _sutiSocketIpAddr;
    private int _sutiSocketPort;

    private Thread pollerThread = null

Trying to import excel data into dbo schema using odbc connection with sql server

  

I have written this vb.net code to import an excel spread sheet but need for it to imported into the dbo shema. When I look in the database the table name is me.tablename instead of dbo.tablename.


    Public Sub Main()
        Dim sheetname As String
        excelpath = "S:\Account Management\jkormann\DynamicScoring\GE_Money_MN.xls"
        ServerName = "server"
        DBName = "sf"
        'SchemaName = "dbo"
        InsertedTableName = Dts.Variables("strTableName").Value.ToString
        sheetname = Dts.Variables("strSheet").Value.ToString
        'ImporttoServer(CStr(ExcelPath), CStr(ServerName), CStr(DBName), CStr(SchemaName), CStr(InsertedTableName))
        ImporttoServer(CStr(ExcelPath), CStr(ServerName), CStr(DBName), CStr(InsertedTableName), CStr(sheetname))

        '
        Dts.TaskResult = Dts.Results.Success
    En

Need SQL Server ODBC Driver 2000.81.9042

  
We have this application that requires a specific version of the SQL Server ODBC driver 2000.81.9042.  Where can I get this?

sp4 Sql server 2000 version issue

  

I have two sql servers one with version 2000.8.00.2050 and another with 2000.8.00.2055.

I want to upgrade 2050 to 2055. How can I do that.? I thought it is matter of sp4. so I installed a file [SQL2000-KB884525-SP4-x86-ENU.EXE] from

http://www.microsoft.com/downloads/en/details.aspx?familyid=8e2dfc8d-c20e-4446-99a9-b7f0213f8bc5&displaylang=en.

But this makes no difference to version.

Do I need to apply some hotfixes?

Thanks!


SQL 2000 server has an issue after an unidentifed event and began running at a snails pace.

  

One of our SQL 2000 servers has an issue after an unidentifed event and began running at a snails pace.

     I know SQL 2000 is no longer supported.

We are running IIS on the same server and no connection can be made to the SQL server on the same machine.

     Microsoft OLE DB Provider for ODBC Drivers error '80004005'

     Specifed driver could not be loaded due to system error 5 (SQL Server).

A std query from outside the server works fine until a  Join is added then it runs forever.

A backup and restord did nothing as well as reindexing, shrinking and optimizing. 

After restoring the database on another SQL 2000 server we compared the speeds.

Bad server 4:22 minutes good server less then 1 second.

Any sugguestions??????  r.morrison@gerresheimer.com


scripts file not found on server - 404

  

Fiddler is showing a 404 error when my published web application runs. the jquery.js file in
/scripts is highlighted in red by fiddler as not found. ( IIS log also shows the 404 error ).
I run the web app from visual studio, on local host - no problems. The publish is successful.
All the files are in the scripts folder of the web app on the server.

In the site.master I have:
<script src="../../Scripts/jquery-1.4.1.min.js" type="text/javascript"></script>

Visual studio does not complain about this. ( which indicates the file is found. )

Oddly, when I fully qualify the path, VS says file not found, but after I publish and run, fiddler
shows the jquery file being found and sent to the browser.
<script src="/MvcApplication1/Scripts/jquery-1.4.1.min.js" type="text/javascript"></script>

when the <script> path is "../../Scripts/jquery-1.4.1.min.js", the fiddler error is
404: /Scripts/jquery-1.4.1.min.js .

when the <script> path is "/MvcApplication1/Scripts/jquery-1.4.1.min.js", fiddler shows the file
being sent to the browser from that /MvcApplication1/Scripts path.

Both the Scripts fol

Categories: 
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend