VS 2008 - How To Add A Local Database
Aug 6, 2010
Initially i had vs 2005 and vs 2008 installed in my machine and both of them were working great.Yesterday i installed vs 2010 in my machine and then i saw that it was also working great.Today when i tried to add a local database in a project that i was working for in vs2008,then i get this error:
then i tried to add a local database in vs 2005 and again i get the same error
This error is not letting me to add the local database
but in the past i had all three vs installed in my machine at the same time and they did not cause any problem like the one i am facing right now.
View 15 Replies
Similar Messages:
Mar 2, 2010
I'm trying to figure out if it's possible to transfer records from SQL central database (who has a public IP address) into SQL local database (who doesn't have a public IP)?
or if it's not possible can I use a centralized website instead to pass some data into the local website? (but i'm not sure if it will have some security concerns)..
View 3 Replies
Sep 1, 2010
I have production server on our intranet and we have website on remote server with its own database. Now we want to sync some tables from our local database to remote database at some interval of time. I have own idea that if data sync is fail than we should get email about that from remote database.
For above scenario I was looking some ideas from you guys and different method to do it. I know about replication of database how to do that. Can we do it by asp.net, SSIS package which will be easy.
View 3 Replies
Feb 4, 2010
I've build an simple control called Menu:
namespace MyControls
{
public class MenuItem
{
public MenuItem()
{
Visible = true;
}
[Localizable(true)]
public string Text { get; set; }
[Localizable(false)]
public string Link { get; set; }
[DefaultValue(true)]
public bool Visible { get; set; }
[Code].....
View 1 Replies
Jan 13, 2011
I am fairly new to ASP.net - comming from a PHP / MYSQL background sometimes certain things in ASP.net confuse the hell out of me. In PHP - when writing an application you always connect to an external database server (MYSQL , PostGreSQL ) using a username and password and aswell a datbase server address(mostly localhost). Now with ASP.net i noticed that you can connect to an existing database within SQL server or you can create a local database in the App_Data folder.
The local database seems much easier to work with however my concern is what would you store in a local database? surely you cannot use it as a main database to store all your data(compared to a MYSQL database)? Secondarily with SQL server - when i login into SQL server management express , it uses "Windows Authetication" , i tried to select "Sql Server authentication" and enter my own username and password to login but that did'nt work. How do i deploy a database from SQL server to the web? - in MYSQL for example we would have a SQL dump file , which can be simply imported/exported from server to server.
View 4 Replies
May 18, 2010
Is it possible to connect to a SQL Server Express 2008 database in ASP.NET with a server name of (local) like "server=(local);integrated security=SSPI;database=DBNAME"? I'm working with another developer on a project and it's getting annoying having to have 2 different version of web.config because he is using SQL Server 2008 and (local) works, but I can't seem to get it to work with SQL Server 2008 Express locally. The database is located on the same computer as the .NET code in case that matters.
View 2 Replies
Nov 8, 2010
I can't figure this out. I have a simple ASP.NET application that I am hosting on my computer which all local computers can hit. The next thing I want to do is setup the website for public access. No matter what I can't seem to get it to work.
- I have allowed incoming connections to port 80 through the firewall.
- I have setup my router to port forward all HTTP requests (80) to my locally assigned IP (192.168.1.XXX).
- I have setup my server to use anonymous authentication, which is set to "Application pool identity".
- I have even shut off my firewall to try and see if it would work.
Can't figure this out. Read a bunch of information, and in my head this should work, but it seems like I am missing something simple. I realize this thread's subject matter applies to IIS7 more-so than ASP.NET, however since I am relatively new to ASP I figured maybe I missed an ASP setting or something.
View 7 Replies
Jul 9, 2013
I'm busy working on an ASP.NET Web Application (3.5) and can't seem to connect to a MySQL DB. I first created the entire application using a WinForms template and everything works 100%, but as soon as I move the exact same code to the Web Application, I can't connect anymore. Here's the code:
Code:
public class DBC {
OdbcConnection connection;
public bool CreateConnection() {
try {
string connFormat = "Driver={MySQL ODBC 5.1 Driver};Server=[SERVER];Database=[DBNAME];User=[UID];Password=[PWD];";
connFormat = connFormat.Replace("[SERVER]", Properties.Settings.Default.DBServer);
[Code] .....
As soon as I try to create the new OdbcConnection instance, I get the error:
Code: ERROR [IM002] [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
As noted this works in a WinForms app, and even more strange is that I don't even specify a DSN name...
All I could find from reading through forums all over the internet is suggestions of downgrading the MySQL ODBC driver version, which I'd really rather not...
View 5 Replies
Jan 19, 2010
I been trying to attach a database in sql 2008 express created in VS 2008 Professional. I have been getting error message and codes which there is no support for once you click the link in the message whats up with that? to my most recent memory it had something to do with permissions... but I was logged in as adminstrator so that confuses me.
View 2 Replies
Feb 17, 2010
Using the Web Platform installer, in installed both the Visual Web Developer Express 2008 and SQL Server Management Studio Express 2008. Next, I connected to my local SQL Server Express 2008 and created a simple database and table using Visual Web Developer Express 2008 where the database file resided in the app data folder of my website. I can connect and explore the table from both Visual
Web Developer 2008 as well as the full blown version of Visual Studio 2008.
View 3 Replies
Aug 10, 2010
I want to make spider charts like this one: [URL] I want to know can I prepare it using reporting service 2008? I am using sql server 2008 as the database and working with Visual studio 2008.
View 4 Replies
Apr 29, 2010
When i tried to attach 2008 database in sql server 2008 it is throwing the error-
"The database 'actitle' cannot be opened because it is version 655. This server supports version 611 and earlier. A downgrade path is not supported.Could not open new database 'actitle'. CREATE DATABASE is aborted. (Microsoft SQL Server, Error: 948)"
When i execute 'select @@version' it gives 'Microsoft SQL Server 2005 - 9.00.1399.06 (Intel X86) Oct 14 2005 00:33:37 Copyright (c) 1988-2005 Microsoft Corporation Workgroup Edition on Windows NT 5.1 (Build 2600: Service Pack 3) 'How the version still be 2005 when im in 2008 ..How can i attach my 2008 database back up.
View 2 Replies
Sep 16, 2010
how can I do it?
View 1 Replies
Aug 5, 2010
I am migrating an existing set of applications from Win XP to Win 7. We have a 3rd party application which is launched by and runs in the user's session which accesses a local SQL Anywhere 9 database via ODBC (launched on demand using dbeng9). On the same machine we have an ASP.NET website which also accesses the local SQL Anywhere database via ODBC. These two applications play nicely together in Win XP because both processes are running in Session 0.
In Win 7 the ASP.NET site encounters an ODBC error stating that the specified database file is already in use. This is because the 3rd party app starts first and spins up an instance of dbeng9 (via ODBC) in the user's session (usually Session 1). Then, the ASP.NET spins up and attempts to connect to the same database. The ODBC driver sees that an instance of dbeng9 is not running in the current session (Session 0) and attempts to spin up an instance at which time it is unable to access the database file because it is already in use by the logged on user in Session 1.
Does anyone have any suggestions for solving session isolation issues with local SQL Anywhere databases?
I thought about running dbeng9 as a service rather than allowing ODBC to spin up an instance on demand. However, because SQL Anywhere is bundled with the 3rd party product the PCs do not have dbsrv and I'm not sure how this would impact the licensing.
The ASP.NET site is only accessed from the local PC. Would running the ASP.NET site in a 3rd party web server cause it to execute in the user's session? (Note: because this runs on 1,000 machines a free or very low cost option is a must.)
Is the ASP.NET Development Server that is bundled with Visual Studio redistributable in this manner?
Can IIS 7 or IIS 7 Express be configured to run in "local only" mode in which it executes in the
user's session?
View 1 Replies
Jan 11, 2011
I have a website used by clients for reporting purposes and would like to give clients the option of my website reading their local database directly (instead of them providing data in a file format).In most instances their database would be SQL Express setup on their localhost.
How can I connect to a clients local SQL server via my website, using asp.net / javascript etc? If the client provides their connection string properties, localhost would just refer to my server's localhost...
Consider the following :Most people connect to the internet via an ISP. THeir database will run on their localhost and will not have a public address as such.Ideally, the client must supply some connectionstring (database name, login etc.) and my server must connect.VPN's wont work for this - I must connect to them (in a programmatic way) and pull data, not the other way around.
View 3 Replies
Jan 31, 2010
I had developed a program a few years back that stored data in an XML file. Over the years, I had accumulated about 500 or so records in the XML file. I wanted to replicate this program online using SQL as the holder of my data.
So I started developing the program using VB 2005 and ASP using the local SQL server on my computer. The first thing I wrote in my program was a piece that took the data from the XML and copied it into the SQL automatically...which was nice, made it easy. Then I continued to work on the program.
Eventually I copied everything to my online area and started running it, everything seems to be working fine so far but I'm stuck.
Is there a way to take the 500 or so records I have locally in a SQL Database and upload it to the SQL Database with the exact same structure that is online so I don't have to re-enter all these things?
View 7 Replies
May 27, 2010
Is there a way to display pdf from local directory or database in a object tag.
My problem is I am trying to display pdf print dialog after pdf is loaded.
This is possible if I load pdf using object tag, but currently my pdf is getting loaded dynamically using response.binarywrite.
View 1 Replies
Nov 2, 2010
I'll be having a website to upload images and am creating the database now , I'll have one original image and about 6 to 7 thumbnails , I just want it to be in the best possible way so I thought I'll save the original image in database and I'll be saving it's thumbnails on hard drive as they're going to be accessed alot so I dont want the httphandlers to be bringing like 20 images from the database while they can be brought easily from the harddrive.
View 7 Replies
Mar 20, 2010
I am wriyng an ASP website for my use on my local PC.
I have setup IIS and eveything works OK apart from accessing my SQL database. As I'm new to this I did not realise that you need to change the connnection string to reflect the place where the DB will be.
Having tried various options like http://localhost/ & db name, without succes I'm looking for some help.
View 8 Replies
Sep 13, 2010
Is it possible for an ASP.NET web application installed on a web server to connect to an Access database stored on a local PC (which is NOT the web server)? I would like the web application to allow the user to specify the path/complete file specification to the database. Or, based on login information specified by the user, the web application might determine the path to the database via an administrative database stored on the web server. The user/customer would be responsible for the storage of the Access database. If the answer to my first question is "YES", how do I programmatically specify/format the path to the Access database on the local PC so the web application can locate the database?
The path has to be something more than "C:foldernamesubfoldernamedatabase.mdb". When I use a path like this, the web application produces an error indicating that the database does not exist or cannot be found. So, I'm fairly sure that the web application is not starting with Drive C: on the local PC to find the database. For all I know, the web application may be interpreting Drive C: as Drive C: on the web server. I'm wondering if I need to specify a computer name before "C:" in the database path.
View 1 Replies
Jan 13, 2010
I had a database on a development server of which I am not the owner. The connection string was:
Dim MM_cnnTraining_STRING
MM_cnnTraining_STRING = "Provider=SQLOLEDB.1;Password=xxx;Persist Security Info=True;User ID=xxx;Initial Catalog=Training;Data Source=xxx"
I copied this database to my local machine, In services MSSQL is set to logon with my computer username and password, I have no idea if this affects anything.Also the local database which I can view in MSSQL Server Management Studio, I can connect by Windows Authentication only. The database copied there seems to have maintained the same permissions.Im completely confused. I finally was able to copy to my local machine but now can not connect. I am using dreamweaver, but using the connection string above.
View 7 Replies
Aug 27, 2010
I just installed SQL Server 2008 Management studio Express on my Vista machine.i tried connecting to local machine using :
.sqlexpress, (local)sqlexpress, or .SQLExpress, MyPCNAMESQLExpress
nothing is working, getting this error:
-----------------------------
Cannot connect to PC-NAMESQLEXPRESS. A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)
----------------------------
View 4 Replies
Jan 27, 2010
How can we debbug a multi-thread program to see local variables of each thread using visual studio 2008.
View 1 Replies
Apr 17, 2010
im trying to transfer my database from local machine to server, im using the publish to provider wizard in visual web developer to generate a scrip, im then using the generated script on the serever database.
[Code]....
View 1 Replies
Sep 1, 2010
Here i want to export my data from local sql server 2000 DB to online sql server 2008 DB.
View 6 Replies
