Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Problem with SQLEXPRESS/MDB connection

4 views
Skip to first unread message

Santosh Pradhan

unread,
Nov 4, 2009, 7:59:45 AM11/4/09
to
My database is in mdb file. My development environment, on my laptop, is
Visual Studio 2008. Database is in the App_Data direcotry. Everything works
fine.

My server is NT 2003 R2. I have installed Web Developer 2008 Express and SQL
Server Express edition on the server. When I copy my code and run the app
via Web Developer it works fine. But When I try to access the web app as a
web site from a brower my database connection fails to open.

When I try to open the mdb file through SQL Server Management Studio - it
appears under the databases but I am unable to open or do anything with it.
When I double click the mdb file name from the folder, it starts the SQL
Server Management Studio but give message - that mdb file format are not
supported.

I have played with following settings in web.config:
Integrated Security=True/False
User Instance=True/False

Nothing works.

How do you get my web app through IIS recognize the database?

Thanks for you help,

Santosh

Erland Sommarskog

unread,
Nov 7, 2009, 12:46:22 PM11/7/09
to
Santosh Pradhan (san...@sanrose.com) writes:
> My database is in mdb file. My development environment, on my laptop, is
> Visual Studio 2008. Database is in the App_Data direcotry. Everything
> works fine.

MDB? That extension is normally used for Access databases, I think.
The primary data file for an SQL Server database usually has the extension
.mdf.

> My server is NT 2003 R2. I have installed Web Developer 2008 Express and
> SQL Server Express edition on the server. When I copy my code and run
> the app via Web Developer it works fine. But When I try to access the
> web app as a web site from a brower my database connection fails to
> open.

What is the error message? What does your code look like?

> When I try to open the mdb file through SQL Server Management Studio -
> it appears under the databases but I am unable to open or do anything
> with it. When I double click the mdb file name from the folder, it
> starts the SQL Server Management Studio but give message - that mdb file
> format are not supported.

No matter if it is an Access database or SQL Server database you have,
you cannot open it as a file in Mgmt Studio. Keep in mind that SQL Server
is a server-based application, and SSMS is a client just like any other
client.


--
Erland Sommarskog, SQL Server MVP, esq...@sommarskog.se

Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx
SQL 2000: http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

0 new messages