We would like to have SQL connect with an Access database over a WAN. Is the best way to use MSDE and allow SQL to connect directly to the Access database or to convert this database every so often to SQL? Thanks! Ernie Adsett ...more >>

We are developing with SQL 7 Developer Edition and planning to install MSDE with the VB application. We received the following question from the IT dept. of our client: "Does your version of SQLServer database work well across a frame relay wide area network?" Should there be any proble...more >>

Is there a character limit on the size of the string that can be passed through to SQL? It appears that when I try to send a string of approximately 15,000,000 bytes, the first 109,000 bytes or so are processed. The rest is ignored. However, no error occurs, and the value returned from...more >>

This occurs when I try to add an Item in the basket in my Online-Store I am using Visual.Studio.Net and data stored on SQL Server 2000 Why am I getting these errors and what can I do to correct them? Thanks! ---------------------------------------------------------------------------- -----...more >>

Can someone please help me with this problem. I Did a database backup from serverA and restore to serverB using w2k. I detached the database from serverB, and when try to attach to the restored database, I got an error" Error 9003:The LSN(120998:148:1) passed to log scan in database "xyz" i...more >>

SQL Server 2000 Enterprise Edition clustered on Win 2k Advanced Server Last week we installed the Oracle client 8.1.6 to allow DTS to extract data from our Oracle Financials system, which has been working fine. Since then users have reported poor performance. Performance monitor showed low (20-30%)...more >>

We're having problems establishing a Linked Server that points at Active Directory in SQL Server 2000. We've executed sp_addlinkedserver and have created a view of active directory users. However, when querying the view, no data is returned. Are we maybe not connecting correctly? We are not...more >>

We have recently installed SQL 2000 sp 3 on Windows Server 2003 and cannot connect using windows authentication. We have a NT Domain and successfully connect to our SQL 2000 DBs running on 2000 Server and have recreated all settings. We are running in Mixed Mode. We can connect with SQL accoun...more >>

sory for repost but nobody on sqlserver.server helped me to solve this :-((((((((( ------------------------------------------------------------- AFAIK QA uses ODBC and EM uses OLE DB right? anyway, I can connect using QA but not using EM. tried with IP addredd too with no avail what's wrong?...more >>

Hello, We are experiencing this severe problem with our software installed at a customer's office. We've tried to diagnose the problem, but we couldn't find the cause (and therefore couldn't find the solution either) that leads to this undesired behavior. I'll expose the scenario and the probl...more >>

We need to know if SQL Server requires any specific VPN ports to run? besides the standard 500 VPN port? thanks...more >>

We are running a fairly simple ASP application, that connect to a MS SQL server It selects from one table (15.000 records), and updates into another table. But when we execute the ASP script, it reports the following error, after completing between 70%-80%. This varies each time it run “Micros...more >>

The problem what iam facing,is while updating records from a network system to sql server,the time taken is very high. I would like to know how to make faster updation of record to my sql database. And what role does ODBC play here.and is there any log file or temporary files created at ...more >>

Microsoft OLE DB Provider for ODBC Drivers error '80004005' Specified driver could not be loaded due to system error 126 (SQL Server). alguien puede darme alguna posible solucion...more >>

Microsoft OLE DB Provider for ODBC Drivers error '80004005' Specified driver could not be loaded due to system error 126 (SQL Server). ...more >>

I have some Jobs in the sceduler with the same problem. The error is General network Error The Client and the SErveur are the same, Only database or table change. I can have the error at any time a day. I can have this error with Sceduler or directly into DTS. I use the protocole TCP-I...more >>

Hello, I have an asp.net web application on server #1, and I am trying to connect it to a SQL Server 2000 database on Server #2. Both servers are in the same domain on the LAN. How should I edit the appSettings element in web.config to make this possible? I have this: <add key="Conn...more >>

Need Help with sql mail. It is not seeing my profile. The pofile on my computer is working because I can get mail. Sql is not seeing that mail. ...more >>

Is SQL mail apart of the installation or is a service that can be turned on and off after install. ...more >>

Hi, maybe someone can help me with the following problem? Background: Our company switched from Access97 to AccessXP and I am not really familiar with XP yet. Goal: I want to start stored procedures on the SQL-Server from the AccessXP Frontend. I am able to link SQL-Server 2000 tables a...more >>

I can't access resources on the remote server sql2000, getting error 10060.(sql authentication) Connecting through netscreen remote OK, but ODBC test fails. Any idea why? --- Posted using Wimdows.net NntpNews Component - Posted from SQL Servers Largest Community Website: http://www.sqlJunkies.co...more >>

I just moved all of my SQLServer databases to a new machine running Windows Server 2003 with SQLServer 2000. All of my normal applications run fine but none of my Web applications can connect. I get Access denied. Our web server is not part of our domain. SQLServer server is part of our d...more >>

Hi, I am trying to read data off a MSDE (downloaded from MS website 2 weeks back)database and display it on a web- form, using .NET. As any ASP.NET application requires access permission for user "ASPNET" on the database, after 3 days of constant searching I hit upon the sp_addlogin, ...more >>

When I register to SQL server 2000 on another machine, I get message " SQL server doesn't exist or access is denied. Connection open". The pinging of the two machines is OK. And I checked the protocols of both machines were the same. Tell me how to rectify this problem. Thanks...more >>

SQL Server 2000 ODBC driver The second statement receive the error: "Connection is busy with result for another hstmt" There are ODBC driver for SQL Server that suport server side cursor such as to be possible 2 active statements for a connection ? ...more >>

Hi, I'm running MS SQL 2000 on Windows 2000 adv srv with 2 network adapters on it . How can I configure MS SQL to listen from one IP address and don't listen from another? Thanks, Leonid ...more >>

I have a SQLServer database that has connections that started days ago, with last status days ago as well. Is this normal? I would assume they aren't connected anymore. Is this a SQL bug? Shouldn't it have closed these after being idle for awhile? These are actually user processes, ...more >>

I have two workstations, one running Windows 2003 Server, one running Windows XP Pro. I have not created a domain, because I don't always have the server. both units are in the same workgroup. The server is running SQL Server 2000 Developer and I am trying to access it from the XP workstatio...more >>

Gurus, I've installed MSDE on an XP Professional server - to be used by the public as part of a forum I'm building. I can connect locally but fails when I connect locally using the option: Network Library=dbmssocn Please help me out here, I'm not a network/XP person and I'd like to get ...more >>

Hi, I am trying to create an application for IPAQ (windoes CE) that can access data from SQL 2000 server and send data back to that server. Can someone tell me how can I do this. Thanks, ...more >>

Hello, We have a Windows 2000 Server and SQL Server 2000. Lately in my event viewer - Application Log I see just thousands of entries that state 18456 : Login failed for user 'sa'. It happens just at random times and as far as I know doesn't affect the server or access to it in any way. Ha...more >>

Can SQL Server 2000 database on a named Instance connect using a ColdFusion 4.5 odbc sql server connection? I have tried so many times and so many ways and unfortunitly I did not create a successful connection. Does CF use the default SQL Server port 1433 for the connection? I went as f...more >>

Hello I have an ASP Website running on W2K SP4 with SQL Server 2K SP3 using MDAC 2.71.9040.2. The website has been running with no problems for about three months. We are now getting this error with alarming regularity. [DBNETLIB][ConnectionOpen (PreLoginHandshake()).] It is not possible ...more >>

I'm trying to finkd the source of sporadic disconnects and I searched through my event logs and nothing points to a loss of netowrk connection. I did see the following and am curious if this can cause a loss of netowrk connection. Event ID 1010 (error) Source: Perflib The Collect Procedure...more >>

From SQL 2000\Query Analyzer on my local\master database I run a query against a linked server. The linked server is comprised of a DSN on my local which points to a Pervasive database version 4 on another server. Here is the Query: select * from openquery(MyLinkedServer,'MyQuery') ...more >>

Hi all, I have SQL Server A and B and client C B is registered as Linked Server in A with option 'Be made using the login's current security context' All of them use Windows NT authentication. client C works only with SQL A When it tries to access SQL B it receives error message 18456 Lo...more >>