SQL Server 2000 is supposed to support up to 8K varchar data type, but if I use ODBC to connect to database, I can only retrieve 255 characters. How to retrieve more than 255 chars? ...more >>

my sql server database is in remote place. how to create a instance of remote server database from my local machine. i want to access all of my tables which are available at remote sql server database. ...more >>

I have started administrating a system that has 44 databases running on the same server. That is 44 user databases. This is running under NT4 SP 6a and SQL 7 SP3 I am sure that SQL was not meant to support this number of databases on the same server but unable to find any documentation to s...more >>

I'm attempting to set up a table on SQL Server 2000 for analysis, using source data from an AS/400 server and the IBM AS400 OLEDB Provider which is installed with the Client Access Express product. If I use the DTS Import/Export wizard, the data preview for the "Copy tables(s) and views(s) fro...more >>

This is my first SQL project. I'm attempting to run AutoDL's setupdb.bat from the Exchange 2K Resource Kit. It tells me that I've failed to make a connection. The script is running on the server where SQL 2K lives. What do I need to do to establish a connection? ...more >>

I installed sql server 6.5 on Windows 2000 server. I opened sql enterprise manager to register a new server locally. It said the server couldn't be connected. I cannot find any active server in enterprise manager. I am sure sql service manager shows this server's ms sql server, msdtc, and ...more >>

Hi, I have connected to the SQL server database using the Access Project but I am not able to add in rows to exisiting tables when I open up the tables for editing.No empty rows shows up at the end of the table to allow me to do so. It works fine for new table setup.I am able to add in data f...more >>

how do I combine 3 columns within the same table. for instance firstname, lastname, middlename all into one field ...more >>

I need to install another instance of SQL. The manual for the program I am installing tells me that if there is already another instance there, that I cannot use port 1433. What other port would, should I use?...more >>

Hi. I'm running the same ASP.NET code on the same IIS box in two different virtual directories, but against two different SQL servers. We upgraded the SQL servers to SQL SP3 and I now cannot connect to one of them. I'm not convinced it is a client issue as, as I mentioned previously, I'm running...more >>

Hi i want to connect to the mssql7.0 database with this asp script dim strConn strConn = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath("/../../mssql7/data/stage_data.mdf") dim adoCn dim strSQL set adoCn = Server.CreateObject("ADODB.Connection") adoCn.Open strConn di...more >>

how do i remove sql from my win2k server in prep for a fresh install of mssql? ...more >>

I've seen similar postings with no solution, so I'll post again.... Windows 2003 server, default instance of SQL Enterprise edition. Client has utilities from SQL Server Standard edition. (MY Win 2000 server has Standard edition. I am merely helping out another division in getting th...more >>

I have an Access 2000 DB that has an ODBC connection to a SQL 6.5 Server. The server is runing in Mixed Mode (SQL Authentication and NT Authentication). I can open the ODBC connections if I use SQL authentication (my SQL username and password). I cannot use a trusted connection to open the Ac...more >>

I have several different databases, including a single Thorough-Bred database, an old My SQL and a new My SQL database. My question is this, can I merge all these into one single database or is there a way to front all five data bases with some type of gateway that somehow downloads every...more >>

howdy, running two servers running win2k server. the newer one just has sharepoint team services installed and runs with mssql server. everything runs just fine. tried to install sharepoint in the older one. apparently, it has a sql server that is not ms? sharepoint does not run. can i...more >>

I have just created a new SQL server instance on Windows 2003 server. I can open databases using interprise manager on the local machine but when I try to connect using the enterprise manager from another machine I get the error message: "A connection could not be established to [server]...more >>

Hi all, I am using a SQL server account to connect to a sql database from an asp page, but I want to use Windows Authentication only, not mixed mode. How do I go about setting that up? I have tried the oledb string that uses a trusted connection, but some of the people that will access th...more >>

Hi , I am facing a problem with the connection to a remote SQL Server 2000 (Developer Edition). The error thrown is "Sql server does not exist or access denied ConnectionOpen(Connect())" I used to get this error earlier also but then i formatted my machine and it started working. Today i i...more >>

Hi all. I am running a SQL server in Mixed mode at this point, but I'd like to change it to Windows authentication. The problem I am having is that there's an ASP application front end that users use to access the SQL database. I use a OLEDB string to connect to the database through an acc...more >>

ERROR: New transaction cannot enlist in the specified transaction coordinator I have 2 webservers, a development and live server. Several SQL 2000 Servers. All in the same domain. On the dev server the code runs fine so I'm pretty sure the SQL servers are setup properly. The live serv...more >>

My production web server runs fine for hours or even days, and then all of a sudden throws the error [Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not exist or access denied. .... when trying to connect to the database. As soon as I reboot the database and web server, all is...more >>

I need to move the Transaction Log to another disk aray, what's the best way to do this??? Thanks.....more >>

Hello, I have an application running on IIS and it always leaves connections unclosed for days. Using sp_who I can tell the spid of the connection, the last batch and the command, eg. (73 09/11 13:34:14 AWAITING COMMAND) Now, according to MS i can not kill a processes with cmd = AWAITING C...more >>

How to connect into a SQL 2000 server which has no records in master..syslogins table? TIA...more >>

Hi, I have a web server that I'm trying to use to connect to a SQL Server. If I try to create an ODBC DSN to the SQL machine, I get SQL Server Error: 1326. If I open network neighborhood on the web server and browse to the sql server machine, it prompts me for a username/password to...more >>

I just migrated the database and web pages from one machine to another machine. The speed of the original web pages are faster than the current one. I think there is no problem on the web pages, but maybe the setting problem in IIS or SQL Server I wonder if anything to do on IIS or SQL Server ...more >>

We're getting an OLE DB Provider for SQL Server error '80004005' Invalid Authorization Specification error from an ASP page that works perfectly on Windows 2000 Server or Professional. The only difference is that we use Windows Server 2003. We have applied the SP3a on SQL Server 2000. Th...more >>

I have installed SQL 2000 on an XP machine. The service runs fine for a while (a couple of days) and then locks me out giving me a login failure. I uninstalled SQL and reinstalled, worked for a while and then locked me out. I then tried this on a Win 2000 machine, same problem. What gi...more >>

I'm trying to attach a database and get the following error. Any ideas? EXEC sp_attach_db @dbname = 'ZytaxPilot', @filename1 = 'c:\data\ZytaxPilot_data.mdf', @filename2 = 'c:\data\ZytaxPilot_log.ldf' ERROR #:-2147217900 Description: [Microsoft][ODBC SQL Server Driver][SQL Server]The he...more >>

We are using sql7 + sp3 on sbs 2000 on Pentium 2 processor + 2 gb ram Between 20 to 30 stations are connecting to the sql and using it. It seems that the memory blows and bigger every time and in spite of the stains disconnecting still the memory is not smaller.. after a while the ...more >>

Error Message: Error opening connection: -2147467259 - [Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not exist or access denied. ...more >>

When I try to connect to a remote SQL Server 2000, it has connection error message saying " SQL Server does not exist or access denied." It doesn't matter if I use Query Analyzer, or DTS, it just doesn't work. That computer is not behind the firewall. I have no idea what's going on. please ...more >>

I have an instance of an SQL server called servername\instancename. How do I pass it to connect to a SQL server from an ASPX page. The successful string without instance for a server called "servername" is as follows Dim ConnectionString As String = "server=servername;database=Northwin...more >>

Let me start by saying this is my first SQL oriented project and I don't have a clue what I'm doing. How do I resolve a Login Failed error? I'm attempting to use AutoDL from the Exchange Resource kit. Upon running the "setupdb.bat" script, I see this error in the log file: Login failed fo...more >>

Hi All, I just set up a SQL 2000 personal server for one of my web development guys. I installed ActiveState active perl on the machine as well as IIS. He wants to be able to connect to the SQL server and modify tables using PERL scripts. I also set up a DSN for him and that DSN when I ...more >>

Over the weekend we applied the following NT 4.0 Server SP6a patches on our NT Servers one of them is running MS SQL 6.5 SP4: MS02-050: Q329115 MS03-001: Q810833 MS03-008: Q814078 MS03-011: Q816093 MS03-013: Q811493 MS03-023: Q823559 MS03-026: Q823980 MS03-030: Q819696 and the follo...more >>