sql server not running or database not found

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

Express Edition and Compact Edition (2005)

sql server not running or database not found

Author

Topic

justjoan
Starting Member

5 Posts

Posted - 2008-05-28 : 17:37:52

I have just installed sql server 2005 express, and ssmse..

have created the db, and can work in the management studio writing queries,etc.. all is fine..

when i try to open my proprietary exe i get the error of

"SQL SERVER NOT RUNNING OR DATABASE CANNOT BE FOUND" Now, I know the DB is there, and I know SQL is runnig.. what could it be?

any ideas and thanks in advance..

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2008-05-28 : 17:39:43

Could you post your connection string?

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Database maintenance routines:
http://weblogs.sqlteam.com/tarad/archive/2004/07/02/1705.aspx

justjoan
Starting Member

5 Posts

Posted - 2008-05-28 : 21:11:14

Thank you for responding, but unfortunately I am not following.. connection string?
I do not know much about SQL..

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2008-05-29 : 12:51:14

Well your application has a connection string somewhere which specifies how to connect to SQL Server. Please post that. It is not something that is done inside SQL Server but rather it's in your application, most likely in a config file.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Database maintenance routines:
http://weblogs.sqlteam.com/tarad/archive/2004/07/02/1705.aspx

justjoan
Starting Member

5 Posts

Posted - 2008-06-12 : 16:21:07

Hello,

Thank you so much for answering. I've been buried at work and am now just re-visiting this..

We are using ADODB in VB6. The line we use for the connection is:
cn.Open Database, UserID, Password

Where cn is:
Dim cn As adodb.Connection

It is not a true connection string since we are using ODBC. The Database above is just the ODBC connection name.

Does this help?

thanks again!!!

Joan

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2008-06-14 : 01:00:25

Did you test connection in odbc then?

justjoan
Starting Member

5 Posts

Posted - 2008-06-23 : 12:55:48

Yes, it connects fine in ODBC.. :-(

any other ideas? I'm thinking I'm on a 64 bit PC and the db app is only programmed for 32.. and that is my WAG.

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2008-06-23 : 22:26:12

You may need double check connection string for odbc.

justjoan
Starting Member

5 Posts

Posted - 2008-06-24 : 06:37:17

I"m pretty sure this is correct because I use it on 2 other PCs..

Or (and this is probably a stupid question), would it need to be different on different OS? 32 vs 64?

Thanks!

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2008-06-27 : 23:11:54

Lot of odbc drivers don't work in 64-bit os as I know.

DotNetSunil
Starting Member

1 Post

Posted - 2011-03-10 : 22:46:17

Hi,

I'm facing below issue when application(VB.Net/SQL 2000) runs.

"SQL SERVER NOT RUNNING OR DATABASE CANNOT BE FOUND"

can anybody help me on this issue ?

thanks for your help

-Sunil

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources