Hi, When I am trying to open Access 2003 report after SQL server is stopped I am getting following error: ------------------------------------------------------ Microsoft SQL Server Login ------------------------------------------------------ Connection failed: SQL Server Error: 53 SQL S...more >>

Is there a way to set the length of my command text? I have a very large script I am trying to pass through the adodb.connection object, and it keeps getting truncated....more >>

I have a linked server to an Oracle 8i database. When I attempt to query the Oracle tables I get the following error: Server: Msg 7317, Level 16, State 1, Line 1 OLE DB provider 'MSDAORA' returned an invalid schema definition. OLE DB error trace [Non-interface error: OLE/DB provider returne...more >>

I'm running MSSQL2k on a Win2k box used as a webserver. I imagine that using a "localhost" type of connection would be faster than referring to the server name and thus invoking the DNS lookup. The connection string I am using as an ASP include is: Dim Connect Set Connect = Server.Create...more >>

I have SQL Server 2000 running on a Win2000 server, and MSDE 2000 running an XP Pro machine (named ASUS). I also have two client machines from which I wish to connect to both of these. All 4 machines are in a workgroup, not in an domain. I CAN connect to the SQL Server and its databases from...more >>

Hi. I have a database established by MS SQL, and I want to make online queries to my database over the net by a GUI developed in Visual Studio .NET. Could someone explain the procedure I must follow to accomplish such an aim. I mean that database is in the desktop computer in my house and I wa...more >>

hi, I am working on sql server 2000 replication. One of our sql servers has multipul publications that push out to several subscribers, and some of the subscribers are the database on the same publisher server. and I've encountered the following failures with only one of its publicati...more >>

In the past, I needed to add the 'use pubs' prior to my select * from employee statement when accessing the pubs database on my sql server. Now, when I add it to my sql statements in my programs, I get only a few of the fields instead of all of them. The odbc connection does NOT specify th...more >>

When using windows authentication mode should should the connection work if the server and client are logged on to windows using "this computer", or must they log on to windows using a domain account - i can't seem to connect using windows authentication, only with a sql account...more >>

Somehow, on my XP box, when I installed SQL Server 2000, I have only a named instance running (and no default instance). So, I have these ASP.NET applications that have "web.config" files that are trying to connect to "localhost". My apps don't work until I change the connection string to "co...more >>

My Asp.net application can't connect to the SQL server from the app server, but an asp page and I can connect to the SQL server, the server also can't connect to a database in other machine. Tks, Pietro...more >>

Hi All, When I open SQL Query analyser and If I try to connect, I am getting this error. Unable to connect to server CSPL. Server Msg 160, Level 16, State 1. Specified driver could not be loaded due to system error 126 (SQL Server) Please help me out of this. Thanks and Regards Peri...more >>

Hello, I use MsAccess 2002 on a Windows XP platform, together with SQL Server 2000. I installed SQL Server on my XP machine prior to installing Service Pack 2 for XP. Everything worked fine: could use the Upsize Wizard, ADP etc. After installing Service Pack 2, I can no longer get a connec...more >>

Have an APP running IIS on one box and SQL on a Win 2K3. When running through a browser located on a completely different box (double hop) the credentials get lost (as designed by MS) and user is only known as Anonymous. Everything is fine and expected so far. SQL on Win 2K allowed such...more >>

Hello, I have a small workgroup of computers (4) all running windows xp sp2. One of them is running msde2000. I can connect to a named instance of sql server but can not connect to the default instance. I am using osql and using trusted connection. I am not sure what other information is n...more >>

i tired my best to get answer of my issue but no one helped me in ORacle OTN newsgroups , please if you know how can ORacle Forms 6i can connect with SQl Server 2000, kindly write. Thanks ...more >>

The environment is ASP.Net accessing the SQL server through IIS. While, I've been told that .Net does not create a cache the behavior I'm observing for intensive purposes looks as if there is a cache. I'm at a bit of a loss to explain this behavior. Also, if I wait five or ten minutes, and ...more >>

Hi, I have an access DB (2000) with links to tables in SQL server. If I go back to my original DB and add a field, it doesn't show in the Access list. I have to delete the link and then re-connect it. Is there a better way of dealing with this? Thanks, Neil ...more >>

Hi, Can anybody please help me how to set up a conncetion between IIS & SQL Server on seperate machine. 1. Domain is same 2. I've tried as per the article 176380, but we are facing some problem on IIS. So my Network manager said I need to try something else. Please let me know the step...more >>

Hello. I would appreciate any assistance in finding a solution to this problem. I am using an access program that connects to an access database. The program was written using Access 2000. However, the program does not properly connect to the database, depending on the computer on which it...more >>

If IIS cached a logon just for one particular page, but not for other pages performing the same logon, is that normal? I know it sounds bizarre but I have an ASP page that makes an ADO connection to MS SQL Server. Authentication on SQL is set to SQL and Microsoft. Authentication in IIS is ...more >>

We've been running a web app for months now, and then suddenly, that web = server could not connect to the remote SQL instance anymore. We are = using a standard TCP configuration with SQL default port. No alias is = used. We use the SQL instance name (as opposed to IP) to connect. We reboote...more >>

I have created a stored procedure wich queries a linked ORACLE database. When I try to save the procedure I get the following error Heterogeneous queries require the ANSI_NULLS and ANSI_WARNINGS options to be set for the connection. This ensures consistent query semantics. Enable these option...more >>

Is there a way to allow a client PC connect to my default SQL instance on an XP Pro SP3 machine without turning off the Windows Firewall? ...more >>

Hello, system administrator asked me to modify my VB application to authanticate itself for ISA when wants to connect to an outer sql server. the system administrator dont want to open fully the port 1433 (from inner LAN), and also dont want to set my application name at ISA. Is any way to sol...more >>

We have recently upgraded to SQL Server 2000 and Server 2003. We're running with TCP/IP and can access the db but the connection appears to then drop. The message is Connection Failed: SqlState 01000 [Microsoft][ODBC Sql Server Driver][TCP/IP Sockets] Open Connection(Connect()). Connec...more >>

We are planning to start warehousing some of the data that currently resides on an as400 (using DB2) on a MSSQL 2000 server. Has anyone monitoring this group gone through such a project? ...more >>

I have a list of CustomerID's that I need to oull address information from a linked Oracle database. I can query individual numbers from query analyzer. However I would like to have my list of CustomersID's be automatically processed through the openquery command. Here is what I currently ha...more >>

Hi all, I want my application's Installer to automatically install the SQL Connectivity on machine in which the Connectivity does not exist. For this i require a Stand-Alone installer (to be called from my Installer if connectivity is not found). Do you know if there exists a Stand-Alone Conn...more >>

Is this even possible? I'm coding a VB.NET WinForms app and an ASP.NET app that will access a MS SQL 2000 Server. I've been told that when I move into a "production" environment that I must go thru a VPN. I'm no VPN expert, but this doesn't make much sense to me especially since the remot...more >>

OpenDataSource gives "Unspecified Error" when connecting to local Excel spreadsheet file with account not in local administrators group, on Microsoft Windows 2003 / Microsoft SQL Server 2000 sp3a. I am having a permissions problem using the OpenDataSource command to open an Excel spreadsheet l...more >>

When I try to Install SQL Server 2000 using a local account that is a member of the LOCAL ADMINISTRATORS GROUP, this is what happens: --------------------------- Setup The logon account cannot be validated for the SQL Server service. Verify that the user name and password entered are...more >>

Hi there, I'm running an ASP program from my web server which connectes to the SQL Server 2000 in a different machine using the follwowing conncetion string. Dim dc0, rs, SQL Set dc0 = Server.CreateObject("ADODB.Connection") dc0.Open "Driver={SQL Server};" & _ "Server=IPAddress...more >>

Hi all, After merged two partitions into one (C:\ and D:\ into one C:\) by using Partition Magic, I can't start SQL Server 2000 which was previously installed in both C:\Program Files\Microsoft SQL Server\80 and D:\Program Files\Microsoft SQL Server\MSSQL The original files in D:\ (every th...more >>

I am trying to troubleshoot a SQL Server connection from my home machine to an instance of SQL server running on my client's network using Enterprise Manger and I am going through the steps in the MS KB article How to troubleshoot connectivity issues in SQL Server 2000, http://support.micros...more >>

Hi, Have a quick question. Having a problem connecting from the IIS server (windows 2000 sp3) which hosts the asp.net application to retrieve data from an SQL server (windows nt 4, sql 7). The error keeps coming up SQL server does not exist or access denied. I've checked the permission...more >>

Here's my setup. I have an SQL server machine with a local LAN ip. I have a router with an internet IP. I configured the router to pass external port 5000 through to the sql machine's ip on port 1433. When I try to connect to the sql server using the router's IP and port 5000 I get a timeo...more >>

I have the following error message when trying to connect from an SQL 2000 client to an SQL 200 server: Msg 11, Level 16, State 1 (General Network Error. Check your network documentation) The connection was working fine until the server was moved behind a new firewall. My client is using a...more >>

I just moved a database from one sql server to another. Both use Windows 2000, sp4, build 2195. Both use SQL Server 7, but the old server uses service pack 3 (7.00.961). the new server uses service pack 4 (7.00.1094). I connect to the database in the old server without a problem. I connec...more >>

I can be connected to services analysis 8.00.194 through HTTP?...more >>

Hello everybody! Can you help with this problem. I use SQLSERVER 2000, sp 3. When I keep connection alive during execution several ( a lot of ) queries I see that some connections do not free memory ( I check memusage in sysprocesses ) . And as a result the total server memory is increasing ...more >>

Hi, I have a webserver with sql server on it. All was working fine until a few days ago, when now sometimes it refuses asp a connection. In other words, I have an asp page which accesses the database, but sometimes it says the connection is not allowed. The only significant thing I have do...more >>

Greetings ! We need to find if MS SQL has an API for connecting C++ components to it. We don't know if "extended stored procedure (xp)" is the way to go. Why do we need that ? We must implement a synchronization software layer to make sure an ODBMS has the same values as tho...more >>

I have a server in my office which is configured as a linked server on another one. How can I configure the connections between them to be killed after a period of non-useness. As the connections are not killed after some time the limit of connections in my server is exceeded. The connections...more >>

If another sql server has my server registered is there any way for me to find out?...more >>

Users on the same PC who do not have admin rights cannot see or logon to the sql server/msde that exists on the PC. Any user with admin rights can see it, of course. I have waded thru lots of hits in my searches but none of them describe this behavior and whether I can surmount this or not. ...more >>

I've Googlet alot, but can't find my solution. 1. I cannot telnet on port 1433 2. SQL Server Network Utility shows 1433 on the TCP/IP. 3. netstat -an doesn't show anything using port 1433 4. HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\Client\SuperSocketNetLib\Tcp\DefaultPort has the va...more >>

Hi, I want to grant login for whole domain and then add certain domain users to certain user defined sql server database roles. I'm using SQL Server 2000. 1. I have created login for my domain user using Enterprise Manager (group name is MyDomain\Users). 2. I have added a role member usi...more >>

Hi..im trying to use BCP to transfer data from text file to a SQL table and give me an error. I have access to the db table with the 'sa' user and both input and format files are in the directory. This was working well, but suddenly stop working. This is the complete command and the error a...more >>

I have some data that I want to select with an ORDER BY statement and be = able to have it sorted in a hierrarchical order. There will be essentially 1) and ID, and 2) a ParentID. I would like to have the data returned sorted such that any row with a = ParentID =3D to an ID is under that ID ...more >>