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

Cannot Open SQL Server

  
   Database Forums (Home) -> Connect RSS
Next:  ADO connection question  
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: 447



(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:
Ports to open in Windows Firewall for SQL Server 2005 - I'm running the Develpers version of SQL Server 2005 on my developer machine. I want to test an application from another machine but can neither log on nor use the SQL Server Management Studio from the remote machine unless I turn off the Windows..

provider: Named Pipes Provider, error: 40 - Could not open.. - Hello. I have a sql server install / database on the web server. Work great, all my asp.net 2.0 code on that server can access the database with no problem. I can access the database on the web server from my development machine through sql..

Could not open connection - I'm using SQL 2000 & MSDE 2000 I'm having a problem connecting to a local database running on MSDE but only when the computer isn't connected to the network. I've tried using both TCP and named pipes, both work while connected. This was not an iss...

Way to find if open connections - Hi, During an asp.net page execution, is there a way to find number of open connecions or current query being executed? etc etc. Thanks,

SQLConnection open call prevents display of virtual folder.. - Hi I have a MFC application which uses CFileDialog. When I use the following managed code to connect to SQL, as soon as I have the Open, the "My computer" and other virtual folders do not display any folders. But when I have Open commented ...
   Database Forums (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 ]