Hi Can SQL 2000 tools be installed onto a Windows 95 machine? When I try to run the install, the only option available is the client connectivity. Thanks Jono...more >>

Hello, I am working with Access 97 front end and a SQL Server 2000 Backend. Sometimes when a users enters a new record into my main form as soon the record is saved "#Delete" shows up. When I look at the table the data is there but I am not sure what is causing this. Thanks for your help ...more >>

Are CALS assigned to specific client PC's or can any PC connect as long as I don't exceed the number of CALs at any one time? If a single PC creates 2 connections, does that use up 1 or 2 CALs? Thanks, Marc ...more >>

Hi Am using a SQL 2k server and have been regularly logging into other SQL 2K servers in the network using the SQL Query Analyser/Enterprise Manager. After suffering a BSD yesterday, unable to log in to any server from my Query Analyser/Enterprise Manager - get this error: "Client Unable t...more >>

hi, after running OK a sql2000 server above win2000, i try to install the window component "Terminal Server" and succeed to reach the server from my winxp station. but now i get on the sql2000 server an error C0000142 from sql agent/client service,that also cannot load. mssqlserver service...more >>

Are you able to have a sql 6.5 client and a sql 2000 client on the same pc? If so, are you able to use them at the same time? Meaning - Are you able to go into an application using a sql 6.5 database at the same time you go into an application using a sql 2000 database? Thank you....more >>

I have Windows 2000 clients with SP4 installed running an Access 97 application that connects to an SQL 2000 SP3 server running on Windows 2003 server. We recently upgraded from Windows NT 4.0 server running on a dual PIII- 450Mhz server w/ 2GB ram to the Windows 2003 server on a quad PIII...more >>

Hello All, I have used the sp_addlogin command into my Application and I have experiencing error msg and the procedure could not be continue to process. The msg is "Invalid Character Value for cast specifictation" Here are the function & SP script I was made from my application // Function...more >>

I have an Access frontend which pulls out data from SQL server database(using link..). one form (retrieving data in A table) in the frontend has a subform(retrieve data from B table) ; when i run this form and try to edit/delete the data records in the subform, i got message "The microso...more >>

I am trying to run the following query: insert into wr_doc_comment(wr_doc_id, wr_doc_comment_ds) select d.wr_doc_id, r.remarks from wr_doc_comment c, wr_document d, remarks r where r.control_id=d.wr_doc_file_nr and d.wr_doc_id=c.wr_doc_id but I am getting this error: Server: Msg 515, L...more >>

When we create a system DSN for ODBC, and we select SQL Server, in the drop-down list below the question, "Which SQL Server do you want to connect to?" sometimes the same server will be listed twice. Does anyone know what causes this? Is there a difference between the two selections? They...more >>

I have set up SQL Server client s/w on a PC and I am attempting to register a SQL Server database athat exists on a different machine. I can ping the machine and there's no problem. I keep getting a time out error when this happens. The same thing happens if I try to setup a DSN to the serv...more >>

I have a simple application written in Access 97 that uses linked tables from SQL2000. The server was recently upgraded from 7.0 so I know the problem existed before the upgrade. I have a form that uses a combo box to navigate the recordset. Occasionally, this combo will create a runnable ...more >>

Problem is, when I create View, and some fields are calculated and other = fields I will return through *,=20 I will get result, where head of resultset is in correct order, but = "body" (I mean data) is in mixed - bad order. For example i will try to explain it graphically: Table1: Col1 ...more >>

I'm receiving this message "DBPROCESS is dead or not enable" after this my communications are dead, I'm seeing that the configuration in the cliconfg is not keeped, any idea? thx in advance...more >>

I'm receiving the next message "DBPROCESS is dead or not enable", after this the connection is dead, any help? please. I'm seeing, that the configuration inthe cliconfg is not keeped?...more >>

Hi, I have to upgrade à SQL server from v7 to v2000. Does I need to upgrade my client also or does it work normally ? Thanks rjp...more >>

I loaded the SQL 2000 Enterprise client tools on my PC running XP PRO. The installation went smoothly but when I log into SQL Query Analyzer I get the error: Server: Msg 11, Level 16, State 1, Line 0 [Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]General network error. Check your network ...more >>