Wrox Programmer Forums
Go Back   Wrox Programmer Forums > ASP.NET and ASP > ASP.NET 2.0 > ASP.NET 2.0 Basics
|
ASP.NET 2.0 Basics If you are new to ASP or ASP.NET programming with version 2.0, this is the forum to begin asking questions. Please also see the Visual Web Developer 2005 forum.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the ASP.NET 2.0 Basics section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old November 26th, 2005, 05:48 AM
Registered User
 
Join Date: Nov 2005
Posts: 7
Thanks: 0
Thanked 0 Times in 0 Posts
Default Web Express and Access on Remote Server?

Hi folks.. I've just downloaded Web Express from MS. I have a small client that wants to do some edits, updates, inserts, and deletes on an Access database via the web. The database only has 2 tables. So, I'll be developing this thing with forms that do the above, but my problem is that I can't seem to get the Web Express Connection Wizard, or Server Explorer to set up the correct path for my DB? Is it possible to use Access via a remote web host which is of course using Dot Net Framework version 2.0, etc..

Also, I read that I can use SQL server express and when I copy my web app to the client, as long as they have the same SQL server Express name, the app will work, even if the database isn't in the same path, but as long as it's in the App_Data folder? Is this true? Has anyone tried? Any help with getting connected to Access would be great, but if it can't be done, then I'll use SQL server express, but I'll again need to know how to move the database along with the web site to the remote client? I'll develop on my remote host, and then move / copy / ftp to the client is my hope with the DB that is..
Thanks in advance!
Tim (AKA HoosierDaddy)


 
Old November 26th, 2005, 05:58 AM
Imar's Avatar
Wrox Author
 
Join Date: Jun 2003
Posts: 17,089
Thanks: 80
Thanked 1,576 Times in 1,552 Posts
Default

Hi there,

Probably the easiest way to get an Access database to show up in the Database Explorer window is top create a new Access database on your local machine. Then select that database in a Windows Explorer and then drag it into Visual Web Developer on the special App_Code folder.

Then when you switch to the Database Explorer, your database will show up.

You can indeed automatically attach a database in the App_Data folder to SQL Server Express edition. Instead of a file path or database name in your connection string, use

AttachDbFileName=|DataDirectory|YourDatabase.mdf

in your connection string. The |DataDirectory| points to the current App_Data folder.

If you search Google for AttachDbFileName and DataDirectory, you'll find a lot more information.

HtH,

Imar
---------------------------------------
Imar Spaanjaars
Everyone is unique, except for me.





Similar Threads
Thread Thread Starter Forum Replies Last Post
Remote connection error with SQL Server Express DudeBori82 SQL Server 2005 4 April 12th, 2009 01:51 AM
Remote Access to SQL Server Express Bob Bedell .NET Web Services 6 December 21st, 2007 10:50 AM
VB Express and SQL server on remote server questio HoosierDaddy61 Visual Basic 2005 Basics 0 February 22nd, 2006 11:27 AM
connecting web server and remote db server via asp moreyt Classic ASP Databases 0 May 31st, 2005 12:13 AM
Linking Remote Sql Server with Web server yeetesh Pro VB Databases 1 May 26th, 2005 04:13 AM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.