I have created an ASP.NET 2.0 site and just published it to my webserver.
None of the database stuff works, including membership, etc.... because my
hosting company (webhost4life) claims that they do not support SQLExpress,
just SQLServer 2005.
1. How difficult is it to migrate over to SQLServer 2005 OR MS Access as my
database?
2. Will the new .NET membership classes, profile classes, etc... still work
if I switch to a SQLServer 2005 OR Access db?
3. For new websites, how would I create the "base" database, including all
default tables AND stored procs, etc...? (For Access too.)
Thanks.
1  1046 
VBProgrammer,
SQLExpress is basically SQL Server 2005. All you should need to do is ensure
that the connection string is correct. All the membership/ roles etc. tables
and sprocs of course would have to be installed and that is between you and
your hosting provider. The ASPNET_REGSQL utility is what is used to create
"the works" on the database. It also works with SQL Server 2000.
Peter
--
Co-founder, Eggheadcafe.com developer portal: http://www.eggheadcafe.com
UnBlog: http://petesbloggerama.blogspot.com
"VB Programmer" wrote: I have created an ASP.NET 2.0 site and just published it to my webserver.
None of the database stuff works, including membership, etc.... because my
hosting company (webhost4life) claims that they do not support SQLExpress,
just SQLServer 2005.
1. How difficult is it to migrate over to SQLServer 2005 OR MS Access as my
database?
2. Will the new .NET membership classes, profile classes, etc... still work
if I switch to a SQLServer 2005 OR Access db?
3. For new websites, how would I create the "base" database, including all
default tables AND stored procs, etc...? (For Access too.)
Thanks.
This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics | |
by: andrewcw |
last post by:
I am trying to use the NorthWind database or anything with SQLEXPRESS on VS
2005 RC. I can see SQLExpress started with the tool SQL Server Configuration
Manager. But when i select DataBase | New Connection | Data Source |
Microsoft SQL Server - I see other SQL servers but not SQLExpress. What
should I be doing... Thanks
--
Andrew
|
by: Nate Hekman |
last post by:
I'm trying to set up a Membership/Role Provider for an ASP.NET 2.0 beta 2
site using SqlMembershipProvider, and am having problems configuring SQL
Server.
I'm comfortable with ASP.NET but very new at databases, so please help me
out on the database side!
When I run aspnet_regsql I get this error:
Setup failed.
|
by: Raja |
last post by:
Hi everybody
I am not using App_Data\aspnetdb.mdf but my own database TESTDB in
SQLEXPRESS.
In web.config I am using:
<connectionStrings>
<add name="TESTDB" connectionString="Data Source=.\SQLEXPRESS;Initial
Catalog=TESTDB;Integrated Security=True"
providerName="System.Data.SqlClient" />
|
by: |
last post by:
I am try this example on vb express 2005:
http://msdn2.microsoft.com/en-US/library/system.windows.forms.datagridviewcomboboxcolumn.aspx
but it keeps giving me an error about the data source to northwind database. I installed the SQL2000SampleDb.msi file, then ran this command at the prompt:
SQLCMD -E -S computerName\SqlExpress -i instnwnd.sql
with my computer name. Can anyone help a noob out here. Many thanks
*** Posted via a free...
|
by: Marcus |
last post by:
I have a function that simply returns TRUE if it can connect to a
particular Sql Server 2005 express, or FALSE if it cannot. I am getting
some strange error codes returned when the computer that sql server
resides on is not reachable. The error is different depending on the
connection string that I use. If I use the following connection string:
"server=192.1.1.1; Initial Catalog=master; uid=The_User;
password=The_Password; Connect...
| | |
by: Brad Isaacs |
last post by:
I am working with ASP.NET 2.0 and using an SQL Server 2000 database.
I am using Visual Studio 2005 and developing on my Local machine. I am
working with Login controls ASP.Configuration, I wanted to move my work
and needed to place it on the server.
Using VS 2005 , went to BUILD
-Publish Web Site
Checked the box for :: Alow this precompiled site to be updatable.
|
by: Torben Laursen |
last post by:
Hi
I am trying to find find the sqlserver express that is running on my
computer using:
DataTable dtSQLServers = SmoApplication.EnumAvailableSqlServers(false);
It returns one row that holds the name "Office1" but the sqlserver is:
"Office1\SQLExpress"
If I try to connect to "Office1" I get a very long errormessage while if I
|
by: Michel Vanderbeke |
last post by:
Hello,
I have a program, running in several places, using SQLEXPRESS as database.
The different places are stand-alone, and not connected to a network.
Regulary, I have to apply changes on certain tables of the database.
In a previous program, written in VB6 with an Access database, I used JRO
through VB6-code to delete the table in the different databases and to copy
the new one.
|
by: Aykut Canturk |
last post by:
Can I use SqlExpress2005 AttachDatabase feature with classic ADO connections
in my .asp pages ? But I need ConnectionString. Although I searched the web
for couple of weeks I still coulnd't find any solution.
anybody succeeded to use classic ado with attach feature without attaching
database filed from enterprise manager ? I want tou use SQL2005 and I don't
want directly attch files to sql.
Best regards...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
| | |
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
|
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
| | |
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| |
