Archived Months
June 2003
July 2003
August 2003
September 2003
October 2003
November 2003
December 2003
January 2004
February 2004
March 2004
April 2004
May 2004
June 2004
July 2004
August 2004
September 2004
October 2004
November 2004
December 2004
January 2005
February 2005
March 2005
April 2005
May 2005
June 2005
July 2005
August 2005
September 2005
October 2005
November 2005
December 2005
January 2006
February 2006
March 2006
April 2006
May 2006
June 2006
July 2006
August 2006
September 2006
October 2006
November 2006
December 2006
January 2007
February 2007
March 2007
April 2007
May 2007
June 2007
July 2007
August 2007
September 2007
October 2007
November 2007
all groups > sql server connect > june 2003

What is "RUN-TIME ERROR 20599" ??
Posted by Yudhi at 6/30/2003 2:41:21 AM
I have a printing program using Crystal Report and get the data from a SQL server using ODBC. So far this program can print without any problem. Suddently, when user try to print an error message show "Run-Time Error '20599' Cannot open SQL server". No program was modified. I checked all ODB...more >>


Newbie - SQL authentication question
Posted by Pat Kelecy at 6/27/2003 3:16:22 PM
I was running an installation (wizard) for an application that, as part of the installation process, creates a database in SQL. To to this it required that I provide a username and password. Since SQL2K is configured for "mixed mode" authentication, I thought I could provide any valid AD admin...more >>

sqldmo error
Posted by Steven at 6/27/2003 1:37:34 AM
I have received an message as below: -2147165949: [Microsoft][ODBC SQL Server Driver][SQL Server]You must upgrade your SQL Enterprise Manager and SQL-DMO(SQLOLE) to SQL Server 2000 (SQLDMO) to connect to this server. Our DB is running on SQL Server 2000 SP3 and client is Window 2000 Pr...more >>

SQL driver is hanging in IIS Old web page, Rebuit server.
Posted by BJ Freeman at 6/26/2003 5:11:38 PM
through the use of ISSTATE I have a thread that was started by the wpage doing a Con.Execute. to a stored proceedure. I am connecting to SQL 70 server. This page has worked flawless until I had to rebuild the NT 4.0 server and IIS 4.0 SP6a. I now have mdac 2.7 refresh sp1, SQL server Driver...more >>

Query Analyzer How to connect without window <connect to Sql server> but with a
Posted by estelle at 6/26/2003 4:10:27 PM
Query Analyzer How to connect without window <connect to Sql server> but with a command. The Command CONNECT TO databasename USER username.password .... Thanks -- Direct access to this group with http://web2news.com http://web2news.com/?microsoft.public.sqlserver.connect...more >>

Unable to connect to local Server
Posted by subrat_pani at 6/26/2003 2:28:09 PM
Hi, I'm using MS SQL Server 2000 developer version. I'm trying to connect to my local server from command prompt as follows C:\>osql /U sa /P or C:\>osql -E but both throw the following error: [Shared Memory]SQL Server does not exist or access denied. [Shared Memory]ConnectionOpen...more >>

Unable to connect to a mapped drive in SQL job
Posted by VChougule at 6/26/2003 1:53:11 PM
I have a job in SQL Server 2000. The job selects data from the SQL server(using a query) and writes it to a .dbf file on a network drive. When I start the job / schedule it, the job history shows that it has run successfully but it does not create or update the .dbf file. However if I wri...more >>

Can't Connect to Data
Posted by Ademar at 6/25/2003 1:20:34 PM
MSSQL2000 SP3 Desktop edition I installed it to a Dell Latitude Laptop and configured the Client Connectivity for Named Pipes. My application connects fine the SQL data when attached to the network, but when I'm traveling (not attached to the network), my application cannot connect to the SQL...more >>



Very slowly connecting to SQL Server from EM
Posted by precious at 6/25/2003 10:00:39 AM
Client : Windows 2000 Pro SP3, SQL server 2000 Client tools Server: Windows 2000 SP3, SQL Server 2000 SP3 All other clients are able to connect perfectly. Only one machine (having same config as others) takes very long time to connect to any database under Windows authentication or sa. TIA ...more >>

Monito SQL server load
Posted by Usman at 6/24/2003 11:41:23 AM
how to monitor.. how many users.. or connections are connected with SQL server... % usage.. how old is a connection.. and what tables or objects are being used in that connection and how to terminate one or many connections... thanks Usman ...more >>


DevelopmentNow Blog