Welcome to dbFreaks.com!
FAQFAQ    SearchSearch      ProfileProfile    Private MessagesPrivate Messages   Log inLog in

Cannot Open SQL Server

  
   Database Help (Home) -> Connect RSS
Next:  Connection Abended after changing user password  
Author Message
Raymond1

External


Since: Dec 16, 2003
Posts: 1



(Msg. 1) Posted: Wed Dec 17, 2003 2:16 am
Post subject: Cannot Open SQL Server
Archived from groups: microsoft>public>sqlserver>connect (more info?)
Good day!

My program which was developed using Visual Basic 6 as
the programming language, MS SQL 2000 as the database and
Seagate Crystal Report as reporting tool.

The program runs well in all the PC except for one. When
the program suppose to display a report, it says "Cannot
Open SQL Server".

Why does this happen?
Is it because some of the .dll files are missing or
corrupted?

Please help!

Thank you and have a nice day.

 >> Stay informed about: Cannot Open SQL Server 
Back to top
Login to vote
Kevin McDonnell MS

External


Since: Dec 12, 2003
Posts: 219



(Msg. 2) Posted: Wed Dec 17, 2003 8:16 pm
Post subject: RE: Cannot Open SQL Server [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
That's a pretty generic error message. Try creating a new ODBC DSN to the
same server on that machine.
Press the Test button. Note the OS error number and search the kb for that
error or repost with the exact error message.

Example:
OS Error 53. == Network Name Not Found (trying to connect over Named
Pipes.
OS Error 10060 : == ConnectionTimeout (trying to connect over TCP)


Thanks,

Kevin McDonnell
Microsoft Corporation

This posting is provided AS IS with no warranties, and confers no rights.

 >> Stay informed about: Cannot Open SQL Server 
Back to top
Login to vote
JN

External


Since: Mar 06, 2009
Posts: 1



(Msg. 3) Posted: Fri Mar 06, 2009 6:25 am
Post subject: RE: Cannot Open SQL Server [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
Hi,

I get this error while I try to connect to sql server from cystal report 7. ODBC connection test was successful. So any more suggestions?

From http://www.developmentnow.com/g/100_2003_12_0_0_389396/Cannot-Open-SQL...rver.ht

Posted via DevelopmentNow.com Groups
http://www.developmentnow.com/g/
 >> Stay informed about: Cannot Open SQL Server 
Back to top
Login to vote
Robert Mijango

External


Since: Apr 13, 2009
Posts: 1



(Msg. 4) Posted: Mon Apr 13, 2009 3:25 pm
Post subject: Cannot Open SQL Server [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
I get the same error message with Crystal 8.5.
I have un/re-installed SQLServer and Crystal. I have are dropped/created a new ODBC DSN.
I am using SQL Server 2000.81.9030.04 SQLSRV32.DLL 08/06/2002

Any other suggestions?

From http://www.developmentnow.com/g/100_2003_12_0_0_389396/Cannot-Open-SQL...rver.ht

Posted via DevelopmentNow.com Groups
http://www.developmentnow.com/g/
 >> Stay informed about: Cannot Open SQL Server 
Back to top
Login to vote
Display posts from previous:   
Related Topics:
IIS 6 and Windows Authentication to SQL Server 2000 - I am running a Windows Server 2003 machine as my web server. I would like to use Windows authentication for connections to my SQL Server 2000 instance on a Windows 2000 server. I've read where mirroring the ASPNET account and password on the web server...

Cannot connect to local sql server 2000 from VB.NET on pc .. - Hi I just installed SQL Server 2000 to run locally on a WinXP Pro SP2 PC. When I run the following VB.NET code: Protected Const SQL_CONNECTION_STRING As String = _ "Server=localhost;" & _ "DataBase=Northwind;" &...

Oracle linked Server - Hello, I have a SQL 2003 SP3a on Windows 2003 and am connecting to an Oracle 9i database. I've set up the linked server and necessary permissions and it has been working successfully for months. However occasionally after rebooting the machine I..

automating server registration - I'm forever running around updating\ change client libraries and aliases on developer machines. Has anyone any idea how I could go about automating this eg User logs in to the network and automatically their server aliases are updated\ corrected with...

connection string does not work for a different server - Hi all, I currently have an ASP .Net project running locally, and accessing a local SQL server 2000 database. The project runs fine since it is able to open the connection to the database, and perform operations on it locally using a connection dtata..
   Database Help (Home) -> Connect All times are: Pacific Time (US & Canada)
Page 1 of 1

 
 You can post new topics in this forum
You can reply to topics in this forum
You can edit your posts in this forum
You can delete your posts in this forum
You can vote in polls in this forum



[ Contact us | Terms of Service/Privacy Policy ]