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 >>
Don't see what you're looking for? Search DevelopmentNow.com.
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 >> |
