How Do You Backup A Database Using Sql Server 2005 Express???
I know there isn't a backup feature but I was wondering if there was a way to back up a database?
Thanks!!!
View Complete Forum Thread with Replies
Related Forum Messages:
2005 SQL EXPRESS DATABASE BACKUP
I am using Veritas backup exec 10.d with sql agent. I am able to see the sql express studio 2005 database files but there is difference in file size between original database file and the one shows in sql agent backup selection. The backup performs 100% successful but the original database file size is different e.g( original file:350MB, backup file: 28MB).. Any ideas...? Thanks in advance..
View Replies !
Edited Data Won't Propagate Back To The Database (VB 2005 Express && SQL Server 2005 Express)
Hi, I'm trying to learn some VB programming with the VB 2005 Express Absolute Beginner Series video tutorials (which I think is great) and have come across a problem that I can't solve. When I follow the instructions in Lesson 9 (Databinding Data to User Interface Controls) my application will display the data from the database correctly and I can edit it (and as long as the debugger is running the data remains changed). However, the changes won't propagate back to the database. I don't get any error messages but after I edit the data, save (with the save button on the BindingNavigator toolbar), and end debugging the data in my database remains unchanged. When I use a MessageBox to show how many rows where edited/updated in the Me.myTableTableAdapter.Update(Me.myDatabaseDataSet.myTable) I get the correct number back. I'm sure the problem is not due to coding errors since I've also tried running the accompanying Lesson 9 project file that can be downloaded from MSDN and the problem persists. I'm using Windows XP SP2, SQL Server 2005 Express Edition and VB 2005 Express Edition. I've tried installing SQL Server 2005 Express with a number of different settings, including default settings, but it doesn't make any difference. Would greatly appreciate any feedback on this as I'm keen to resolve this problem so I can get on with the next tutorial lesson. Thanks, Ieyasu
View Replies !
How To Restore Sql Server 2000 Db Backup Into Sql Server 2005 Express Edition
Hi Friends,I have installed SQL server 2005 Express Edition and SQL Server managementI have a SQL server 2000 db backup file. I try create a new database in my SQL server 2005 express Edition and try restore that backup file from device, it only searching for file with *.bak and *.tm extension! I tried generate backup file with .bak extension and tried restore into SQl server 2005 express edition but still it is not allowing to do so! I also tried copy my database's data file and log file and paste it under SQL server 2005 express edition Data folder and still not able to read the tables.Is that any ways to do restoring for this SQL server 2000 backup file into SQL server 2005 express edition! Anybody can help me on this please...:eek:
View Replies !
Sql Server 2005 Express Backup On Windows 2003 Server
I note that after installing sql server 2005 express onto a Windows 2003 server from a Windows XP pro computer I lose the ability to backup, specifically, the microsoft sql studio express lost or is missing the function (management -> Management plans) which allows for backups to be run at specified times. How can I proceed to backup my SQL server 2005 express database ? Thanks, David
View Replies !
How To Backup A Database In Sql Server Management Studi Express Automatically
I come cross some post about how to backup a database in Sql Server Management Studio Express automatically. The scripts look like as below USE [master] GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE PROCEDURE [dbo].[sp_BackupDatabase] @databaseName sysname AS BEGIN SET NOCOUNT ON; DECLARE @sqlCommand NVARCHAR(1000) DECLARE @dateTime NVARCHAR(20) SELECT @dateTime = REPLACE(CONVERT(VARCHAR, GETDATE(),111),'/','') + REPLACE(CONVERT(VARCHAR, GETDATE(),108),':','') SET @sqlCommand = 'BACKUP DATABASE ' + @databaseName + ' TO DISK = ''C:Backup' + @databaseName + '_Full_' + @dateTime + '.BAK''' EXECUTE sp_executesql @sqlCommand END It throws that the DDL statement is not allowed. What's wrong with it?
View Replies !
How Can I Backup The AdventureWorksLT Database To SQL Server Management Studio Express?
Hi all, I just found out the name of AdventureWorksLT is in my SQL Server Server Management Studio Express, but the content of AdventureWorksLT database in my SQL Server Management Studio Express is gone. I saved the backup file of the AdventureWorksLT database in my C:Program filesMicrosoft SQL ServerMSSQL.1MSSQLackup folder. How can I backup the AdventureWorksLT database to SQL Server Management Studio Express again? Please help and advise. Thanks in advance, Scott Chang
View Replies !
Northwind Database In SQL Server Management Studio Express Is Lost Or Used/processed By VB 2005 Express:How To Locate/return It
Hi all, In the last one and half years, I used the Northwind Database in SQL Server Management Studio Express (SSMSE) to learn the programming of SqlConnections, Data sources, Database Exploere, ADO.NET 2.0, etc. via VB 2005 Express. The Northwind Database in my SSMSE got lost very often, but I was not aware of it. How can I know where the Northwind Database is used or processed by my VB 2005 Express projects that were the examples of some tutorial books or my trial projects? How can I release the Northwind Database back to my SSMSE from the VB 2005 Express projects? Please help and advise. Thanks in advance, Scott Chang
View Replies !
SQL Server Express: Restore, Backup And Attach Do Not Work Anymore && Database Locations Fault
Hello there, I've some really big problems with SQL Server 2005 Express. I Recently, I had 2 instances on my machine, one was a SQL Server 2000 Developer and the other a 2005 Express Version. The 2000 version was not necessary anymore, so I unstalled it, since then, the Express version keeps having probems. Under the Server Properties -> Database settings -> Database Locations I've changed the path to D:sqldatamssql, but now, the programm always takes the "C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLData" to store and load the databases, no matter what I do. And there are more problems see here: Restoring does not work======================= I wanted to restore a database called "fw40_admin" from a backup file (.bak), but that didn't work at all, it always says this as an error: "System.Data.SqlClient.SqlError: The operating system returned the error '5(error not found)' while attempting 'RestoreContainer::ValidateTargetForCreation' on 'D:sqldatamssqlfw40_admin.mdf'. (Microsoft.SqlServer.Express.Smo)" But as soon as I type in the installation path "C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLData" inside the "Restore As" under "Options", it works. Why does the backup only work in "C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLData", BUT the database locations under the server properties is indicated with "D:sqldatamssql"???? Attaching does not work======================= Attaching an existing database does not work either. Most databases (mdf) are located on the path D:sqldatamssql, but as soon as I press Attach Databases -> Add The dialog window appears with the "D:sqldatamssql" path, but it is unable to find any *.mdfs altough THERE ARE .mdfs in this directory. But Express can find databases in the selected installation: "C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLData". Why can't Express see the directory on the D: partition??? What is wrong? Here? Can anybody help me?
View Replies !
How Can I Take BackUp Of Database In Sql Server 2005 ?
hello all i have Database of having 5 tables , 5 SP, etc now due to some reason i have to format my Harddisk. so which files i shuold take as Backup so next time i install Sqlserver 2005 so i will have to run(paste ) only those backuped files and i will have my database ready , pls show me path for taking back up. thank u
View Replies !
Backup Of MS SQL 2005 Database On Remote Server
Hello Friends: My problem relates to backing up my MS SQL 2005 database which is sitting on a shared server at a hosting company. OVERVIEW: - Hosting company is using MS SQL 2005 - I am using the SQL Server Management Studio that comes with SQL Server 2005 Standard (NOT Express), which is installed on MY PC. - So, I am connecting to the SQL server over the internet WHAT I WANT TO ACHIEVE: - I would like to backup the data sitting on the Hosting company's MS SQL Server. I only have one database on this SQL Server. There are of course 100s of other databases on the same server which belong to other customers of the hosting company. - I want to bring the backup to MY PC, from the SQL Server. - As far as I can tell the following options within SQL Server Management Studio may be of help to me. I do not know which one I should use or which one is best or what is the proper method. 1) Select Backup option from the Tasks menu (but it only shows me drives/devices on the Hosting SQL Server, not my PC, so I can’t backup to my PC) 2) Export Data (it does not work, showing errors ‘…not a trusted connection…’ I have no clue what a trusted connection is. 3) Copy Database (which is supposed to copy the remote database on the Hosting company SQL server, to my local SQL Server running on my PC). I go through the wizard, on the last screen it just hangs i.e. shows- not responding) MY QUESTION TO THE COMMUNITY: How do I backup the database sitting on the hosting company SQL server? I of course need to bring the backup to my PC.
View Replies !
Can't Connect To Sql Server 2005 Database Using Vb 2005 Express
I've used Sql Server 2000 and Visual Studio 2003 for a few years. I've started a new position and they have access to Sql Server 2005 Standard and Visual Basic 2005 Express which I'd like to use for a new project. So I installed Sql Server 2005 and then VB 2005 Express on my workstation. I didn't choose the Sql Server option for VB Express because I already had Sql Server 2005 Standard installed with a simple database created. I created a simple vb project that justs connects to the database but I get the following error. Request for the permission of type 'System.Data.SqlClient.SqlClientPermission, System.Data, Version=2.0000, Culture=neutral, PublicKeyToken=b77a5c561934e089' failed. I looked at permissions in the database and it looks ok. I'm the db owner and I'm using Windows Auth. My connection string is "Data Source=MySystem;initial catalog=AdventureWorks;integrated security=true;" I thought I'd look at the starter kit to get some ideas about what the problem is, but when I started the movie starter kit project, it was upset that I didn't have Sql Server 2005 EXPRESS installed. Yea, but I do have Sql Server 2005 Standard installed. Any help will be greatly appreciated. Thanks.
View Replies !
Unable To Restore Backup Database In Sql Server 2005
I am using sql server 2005 and unable to restore backup file(.bak) file when i ry to restore it to other database it shows following error restore failed for server (microsoft.sqlserver.smo) additional information: system.data.sqlclient.sqlerror : the media set has 2 media families but only 1 are provided.All members nust be provided.(microsoft.sqlserver.smo)
View Replies !
How To Restore A Sql Server 2005 Database Backup To Sql Server 2000
Hi All This is a very urgent requirement of my client having 200 stores and one Head office. the HO has just installed SQL-Server 2005, The HO sends small backups of the data related to stock transfer which needs to be restored at stores. It was working find when both the HO and stores were SQL-Server 2000. but the process has come to a dead halt as the HO has SQL-Server 2005. It is not possible to convert the stores immediately. please help me out. Thanks Raoshan
View Replies !
How To Apply SQL Server 2005 Express SP1 To The Version Of SQL Server 2005 Express Which Installs With Visual Studio 2005?
When I installed VS 2005, it installed the default version of SQL Server 2005 Express that ships with Visual Studio 2005 installer media. How can apply SQL Server 2005 Express SP1 to update this existing instance? Currently, if I run this query: SELECT @@version I get the following: Microsoft SQL Server 2005 - 9.00.1399.06 (Intel X86) Oct 14 2005 00:33:37 Copyright (c) 1988-2005 Microsoft Corporation Express Edition on Windows NT 5.1 (Build 2600: Service Pack 2) After applying SP1, I should get 9.00.2047.00. Should I just go to this link and download & install the SQL Server 2005 Express Edition SP1: http://msdn.microsoft.com/vstudio/express/sql/download/ Thank you, Bashman
View Replies !
Error 18210 Backup Up SQL Server 2005 Database To Network Drive
I have 2 different servers that run nightly backup jobs to a network drive using the UNC format. I am noticing the larger databases encountering the following errors on a regular basis Error: 18210, Severity: 16, State: 1. '\fnfssql3SQLBackupsMNSQL05<database>.BAK'. Operating system error 64(The specified network name is no longer available.). BACKUP failed to complete the command BACKUP DATABASE <database>. Check the backup application log for detailed messages. There are 5 databases on this server all backed up by the same job and 3 of them wortk fine and 2 of them fail so it is not a permissions problem. Have there been any problems with backing up to a network drive in 2005?
View Replies !
SQL Server 2005 Express Database On The Internet
Hey all!I am hoping that somebody will be able to help me getting my database working over the Internet.I am using VS 2005 and SQL Server 2005 Express Edition and have my database set up within a web site project in VS under the App_Data folder.Everything runs smoothly when running the application on localhost I am just facing a problem when I attempt the same thing after uploading my pages to my web server.I am receiving the following error:An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)I have tried enabling the disabled SQLEXPRESS protocols and disabled my firewall with no luck.I have also looked into using localhostsqlexpress as the server name but I dont see how this method would work as it appears to only run a database on the local machine which is the problem I have currently.Could anybody help me with this problem? I have only just started trying to use SQL Server Express as a means of database connectivity and I am not exactly sure how it all works.Thanks
View Replies !
How Do You Transfer A Database From SQL Express To SQL Server 2005?
Hello, On the web site for MS SQL Server 05 Express the description at the top of the page says, "Transfer any database created in SQL Express to other editions of SQL Server 2005." http://msdn.microsoft.com/vstudio/express/sql/powerful/ How do you transfer a database from SQL Express to SQL Server 2005? I am creating a data-driven web site using Visual Web Developer 05 Express, SQL Server 05 Express and MS SQL Server Management Studio Express. My host uses SQL Server 2005, ASP.net 2.0, and FrontPage extensions. Thanks for your help.
View Replies !
Need Help On Migrating A SQL 7 Database To SQL 2005 Server Express
Hi all, I'm not sure if this is the right place to seek help. I'm trying to migrate a small sql 7 database to a new server runing sql 2005 server express. is that possible? if anyone has any instructions or point me to the information that i need to get this done. i'm not a dba so any details instructions would be really appreciated. Thanks in advance. Brandon
View Replies !
Web Hosting - ASP.NET With SQL Server 2005 Express Database
What is needed for a hoster / hosting company to be able to host .Net applications with SQL Server 2005 Express database? My questions regarding this issue basically are: If a hoster has several sites hosted on a server, can each one of them have its own SQL Express database? Or, do they have to be migrated to full SQL Server? What is with the Upsize Tool for SQL Server Express (or something like that) - is it available? Generally, how do hosters do their hosting - do they have SQL Server SPLA signed? Or do they just have SQL Server 2005 Express and allow users just to copy their web sites and databases to server? I would really appreciate any answer. Kind regards, Luka
View Replies !
SQL Server 2005 Express Adv. SP2 Setup Fails To Install SQL Server Database Serices Only.
I run setup using GUI. It upgrades all components of the existing installation w/out any problems except the last component. That is, it proceeds with the installation of SQL Server Database Serices and at the end fails to shut down the SQL Server and aborts the installation reporting the following: "Service 'Computer_NameSQLEXPRESS' could not be stopped. Verify that you have sufficient privileges to stop system services. The error code is (16386)". I am running Windows XP SP2 with both .NET 2.0 and .NET 3.0 installed on it. I am logged in as a system administrator. The most puzzling to me things are: - the setup starts AND STOPS w/out any problems SQL Server Reporting Services and SQL Server VSS Writer (thus finding enough privileges for both). - the setup starts the SQL Server w/out any problems (thus it finds enough privileges to START A SYSTEM SERVICE) and then fails as described above 'lucking privileges". During installation before failing the setup displays following: "Run as Normal User. RANU instance Shutdwon in progress: MSSQL$SQLEXPRESS". The "normal user" puzzles me too, unless the SQL Server itself is meant here. Any suggestions would be appreciated. I can provide the installation log file as well. Thanks.
View Replies !
SQL Server 2005 Express - Import Data To Database On Webhost's Server
Hello,I finished designing my site in VWD Express and I need to import my database with its already-made tables and data to the empty database on my webhost's server.I tried using MS SQL Server Management Studio Express but I found that there is no import/export tool. I tried making a backup but I can only restore from backups on my webhost's server.I do NOT have the permission to attach a database, so I can't do that. Is there any way I can use a query or some sort of tool to import the data from the database I made in VWD to my empty one?Thanks a lot!
View Replies !
Problem With Creating New SQL Server Database In VWDExpress Using SQL Server 2005 Express
I have two problems on creating new SQL server database in Visual Web Developer 2005 Express using SQL server 2005 Express. The 1st problem: (It is resolved) After installed SQL Server 2005 express and Visual Web Developer 2005 Express. When I tried to create a SQL server database in VWD the following error occurred: "connection to SQL Server files (*.mdf) require SQL server express 2005 to function properly. please verify the installation of the component or download from the URL: go.microsoft.com/fwlink/?linkId=49251" I was stuck with this problem for few days. I did several times of install/reinstall of VWPExpress and SQL server Express, made very sure following proper de-installation sequence as specified in the release readme. But it did not resolve the problem. Latter I found out that if I login with another Windows XP user account, I don't get the problem. Changing the security authority of XP file systems and IIS didn't help. And to prove that I was doing the installation correctly, I tried a new installation of the VWDExpress with SQL server 2005 express in another machine, it worked and I could create new empty SQL database. After 2 days of frustrating changing of options, parameters, server names, messing with the registry etc.... Finally, I found a way to overcome this problem. The solution is: In Visual Web Developer 2005 Express, select: Tools -> Options -> Database Tools -> Data Connections, Change the setting: "SQL Server Instance Name (blank for default)" to "SQLEXPRESS". (where SQLEXPRESS is the default server instance name) That solved this 1st problem. I still don't know the exact reason for this problem. But I recalled I did installed the VWDExpress few weeks ago, I might have installed it without selecting SQL server 2005 express at that point. I guess the subsequent install/re-install did not clean up those junk in the registry. I still have the 2nd problem: The "Create new SQL database..." option is always grayed out when I right click on the Data connections in the "Database Explorer" tab. I have a bypass for this difficulty for time being: I have to do it by using the "Add connection....", put in the server name: "myserver/SQLEXPRESS" and a new database name. Any input form anyone ? Appreciated!
View Replies !
How To Connect To Remote SQL Server Database Using SQL Server 2005 Express
Hi,I've an account with a hosting service provider online for SQL Server database. I've downloaded SQL Server 2005 Express from ASP.Net. How can I use it to connect to my SQL Server Database which is sitting on remote server? The hosting provider gave me following things to connect to the remote database.Server NameDatabase NameUser NamePasswordRegards,A.K.R
View Replies !
Restoring Sql Server 7.0 Database Into Sql Server 2005 Express - Problem!
Hi! I'm a beginner w ith SQL Express and am having some problems. I am using 2005 SP1 and installed the SQL Server Management Studio Express as well. I have a backup from a SQL Server 7.0 database that I am trying to restore into my database using the management studio. When I try to restore from the file into my database, I get the error, System.Data.SqlClient.SqlError: The backup of the system database on the device D:GMBeta2Local.bak cannot be restored because it was created by a different version of the server (7.00.1063) than this server (9.00.3033). (Microsoft.SqlServer.Express.Smo) Is this true? Is there any way for me to get this data into my SQL Server 2005 express on my laptop?
View Replies !
Connection String To SQL Server 2005 Express Database
Hi, all. I am using VS.NET 2005 and SQL Server 2005 Express. I tried to use the following code to connect to a database named "AMSPROD" that I attached to SQL Server 2005 Express: dbConn = new OleDbConnection(Data Source=.SQLEXPRESS;AttachDbFilename="C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLDataAMSPROD_Data.MDF";Integrated Security=True;Connect Timeout=30;User Instance=True); dbConn.Open(); I got an error asking for provider with the above connection string, then I changed the conncection string to be like follows: Data Source=.SQLEXPRESS;AttachDbFilename="C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLDataAMSPROD_Data.MDF";Provider=SQLNCLI;Integrated Security=True;Connect Timeout=30;User Instance=True I got error: No error message available, result code: DB_E_ERRORSOCCURRED(0x80040E21) Then I changed the Provider to be like: Provider=SQLOLEDB, now I am getting the following error: Message: "Invalid authorization specification Invalid connection string attribute" Source: "Microsoft SQL Native Client" StackTrace: " at System.Data.OleDb.OleDbConnectionInternal..ctor(OleDbConnectionString constr, OleDbConnection connection) at System.Data.OleDb.OleDbConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningObject) at System.Data.ProviderBase.DbConnectionFactory.CreateNonPooledConnection(DbConnection owningConnection, DbConnectionPoolGroup poolGroup) at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection) at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) at System.Data.OleDb.OleDbConnection.Open() at ISESAMSData.DbConnections.MakeConnection() in C:\ISES\ISESCommon\ISESAMSData\DbConnections.cs:line 74" TargetSite: {Void .ctor(System.Data.OleDb.OleDbConnectionString, System.Data.OleDb.OleDbConnection)} Strange thing is, when I use the Connect To Database under Tool menu of VS.NET 2005, I could make the connection to this database. Then I copied this connection string to the code, the connection couln't be made. I feel very confused. I am wondering if I need to add ASP.NET user to SQLExpress. But I don't know how to do it? Can anyone please help me out! Many thanks!
View Replies !
Attach Database Failed For SQL Server 2005 Express
I have installed a sample from the web and put it in my localhost inetpub folder, then i open up my SQL Server 2005 Express to attach the database from the App_Data directory, it throws an error below: errors occur in both window and sql authentication login. Error: Attach database failed for Server '...SQLEXPRESS'. (Microsoft.SqlServer.Express.Smo) Additional Information An exception occcured while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.Express.ConnectionInfo) Directory lookup for the file "C:Documents and SettingsmirtariqMy DocumentsWorksStarterKitVSI smallbusiness_csApp_DataSmallCompanyDB_log.LDF" failed with the operating system error 3(The system cannot find the path specified.).(Microsoft SQL Server, Error:5133)
View Replies !
How To Upload My Express Database To Remote Sql 2005 Server
I have make a website with asp.net 2.0, but I only have a PC with Window 98 connect to Internet. so I can't upload my express database to remote sql 2005 server with SSManagement Studio How can I do? I heard that SSManagement Studio Express version can't upload database,right? I find the site http://www.vwdhosting.net/ can upload my express database and attach to sql 2005 server easily, but some big hosting provider such as http://www.discountasp.net require us upload express database using SSManagement Stud! Where can I find a hosting provider who can attach express database easily?
View Replies !
Transfer Database Created In SQL Express To SQL Server 2005
Using VWD 05 Express & SQL Server 05 Express, how do I transfer my database to my host that is using SQL Server 2005. On the SQL Server express web site http://msdn.microsoft.com/vstudio/express/sql/powerful/ one of the features listed for SQL Server 05 Express is: Transfer any database created in SQL Express to other editions of SQL Server 2005. Thanks
View Replies !
How To Allow Remote Connections To SQL Server 2005 Express Database
I've developed an asp.net 2.0 web app with vs 2005 and am using a SQL Server 2005 Express database. The app works fine locally, but after uploading to the remote web server the following error occures: An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified) How do I go about granting remote connections to SQL Server Express? Does the web server have to have SQL Server Express installed in order to run apps that utilize SQL Server 2005 Express databases? Do I grant access locally on my machine or do I have to be on the web server to grant remote connections? I've been using .net 1.1 with access databases for the past couple of years, so this is all new to me. Thanks.
View Replies !
How Upgrade MSDE Database To SQL Express 2005 On Different Server
I have a database on one server that is running MSDE and I would like to copy it to another server running SQL Server Express. The process I followed was to create a backup on the first server. Copy the backup file to the other sever Then restore using the backed database file on the new server Is this the right procedure? Everything I see about migrating in on the same server. I do not want to do it on the same server as we are migrating the application to the new server.
View Replies !
Java App Connecting To SQL Server 2005 Express Database
Hey All, I am having a problem connecting to a database I have with a java app I am creating for my senior project. I am using the latest MS JDBC for connecting to the SQL Server. Below is the code I am trying to run: try { ds.setIntegratedSecurity(true); ds.setServerName("localhost\SQLEXPRESS"); ds.setDatabaseName("*databasename*"); con =ds.getConnection(); } catch (Exception ex) { ex.printStackTrace(); } The ds and con variables are declared and initialized correctly. The error I am getting now is this: com.microsoft.sqlserver.jdbc.SQLServerException: Cannot open database "*databasename*" requested by the login. The login failed. Any suggestions on what I could be doing wrong?
View Replies !
Attach Database Problem - SQL Server Express 2005.
I m facing a strange phenomenon. Please refer to below points. environment: ------------------ windows XP sp2 SQL Server 2005 express [log on as 'network service'(by default)] programming language: VC++(MFC) There is a sample database in .mdf format which to be attached to SQL Server. Ist case: ------------ I add MASTERDSN (for master databse) to ODBC by calling API SQLConfigDataSource() and then attach the sample DB to SQL Server by calling stored procedure 'sp_attach_db' through VC++ code. On verification from SQL Server management studio express, the DB attached is in read only mode. II case: ---------- I add MASTERDSN using ODBC data source administrator manually. Now I add MASTERDSN (again with same name) by calling API SQLConfigDataSource() and then attach the DB to SQL Server by calling stored procedure 'sp_attach_db' through VC++ code. Now on verification, the DB attached is not in read-only mode. The problem is that why there is difference in behavior in both cases? I want to get the sample DB attached in read-write mode in Ist case. Hopefully waiting for ur response. Thanks & Regards
View Replies !
Can I : Set Up A Distributed Database System By Sql Server 2005 Express?
Hi, I am zeronet. I decide to set up our own web system application just like Ebay. Because of the low investment, I want to select a free DB for our data storage. For high performance, we want to set up a distributed db system. As a beginner of SQL server 2005 express, we want to know: if the SQL-server-2005-express has that ability to manage large amout data and to do with this work? I am eager to hear of your advice. Thanks. yours zeronet
View Replies !
|
TRACKER
