I have Visual Studio 2008 and SQL Server 2008 Developer Edition installed on a Windows XP machine. I get this error when trying to work on a Test Web Application: 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 instan...
I'm about to begin my first project with java Let me tell how I used to handle these things... So far now, I've been workin on asp with a com+ componente made with VB6. The component is registered via the com+ administration console with a domain user, something lile my_company_domain\my_app_account The components reads the configura...
I switched my DAL from using LINQ over to Entity Framework. Because my application connects to different databases depending on the current user, I need to dynamically create the DataContext at run time and pass in the appropriate connection string. However, when I tried to programatically create an Entity Framework connection using my...
I've written some VBA code in an Excel workbook to retrieve data from an Access database in the same directory on a desktop. It works fine on my machine and several other machines running Windows XP, but when we tested this on a Vista machine, we encountered the "Could not find installable ISAM" error. I've done a bunch of searching on...
I am using Oracle 9 JDBC Thin Driver - the connection string I have used for standard JDBC was: jdbcConn.connect("jdbc:oracle:thin:myDevDb/myDevDb@fooServer:1521:MYSIDNAME"); ...just trying to get my head around using this kind of connection in Spring 2.5. How do you wire up Spring to an Oracle connection - think it has something t...
I have an existing ASP.NET app which is configured to connect to a MS SQL Server database and I am trying to modify it to use a postgres database instead. I would like to avoid modifying the C# code, if possible. I expected that the following changes would be sufficient: Add a reference to a suitable postgres driver, in this case Nau...
Sorry if this is the most seen question on the web, but this is my turn. I am trying to publish my asp.net mvc app on IIS 7 under MS Sql Server 2008. I am on a Windows Server 2008 virtual machine. I get the following classical error: A network-related or instance-specific error occurred while establishing a connection to SQL Serv...
I am writing an client application in C# which will be supposed to change ConnectionString settings in a web.config file from another application I wrote. How can I achieve this goal? Is there a way to load the web.config file in my application and read/change its data object orientated? Or do I need to parse it as if beeing a complete ...
Hi There, I have a very funny problem on my application, I get an error as follow: System.ArgumentException: An OLE DB Provider was not specified in the ConnectionString. An example would be, 'Provider=SQLOLEDB;'. However, when I tried to speicify the provider on my connection as Provider=SQLOLEDB.1 or Provider=SQLOLEDB, then I get ano...
I ran across a new problem in the last week. Due to the nature of my project and available budget a small intranet web application I've been working on is both the testing and live server, as well as serves up the pages and is the sql server. This will last at least until the project is out of the major development cycle. Now that the pr...
Hi Guys.I am trying to connect to a Sql Server in my apllication using the following code : SqlConnection myConnection = new SqlConnection(); myConnection.ConnectionString = "Data Source = (local);Initial Catalag = Inventory; Persist Security Info = false; Integrated Secu...
I'm trying to migrate a few asp.net applications from iis 6 to iis 7 and I've run into a few snags along the one. I can't find any documentation for the issue I'm seeing and wanted to see if someone else has encountered the same problem. I'm using SQL Server 2005 db mirroring on my databases. In the connection strings of my applicatio...
I am having some trouble with one of my ASP.NET 2.0 application's connection string. There are instances that I would get a ConnectionString Property Has not Been Initialized problem which occurs randomly and intermittently and without any reason. My Connection string is actually coming from a webservice, because different kinds of use...
The Setup: I have a DLL that uses a ConnectionString to connect to a SQL database. When I add the DLL to my website i have to add the connectionstring into my web.config in order for my DLL to function properly (this is by design). Once I add it into the web.config then everything works fine (as expected). The Problem: The problem b...
We are using an Informix database, and are connecting to it from .NET sucessfully using ODBC. The connection string we are using is; DRIVER={IBM INFORMIX ODBC RIVER}; UID=username; PWD=password; DATABASE=our_database; HOST=devsrv01; SERVER=devsrv01_tcp; SERVICE=ids9tcp2; PROTOCOL=onsoctcp; CLIENT_LOCALE=en_US.CP1252; DB_LOCALE=en_US.819...
What is the best way to manage connection strings in a web application, from a security standpoint? I've done it several different ways. I've stored them as plain text web.config setting keys. I've also created a "Constants" class that has public read-only string properties for each connection string. Does anybody have any recommenda...
I have read-access to a MySQL database and am trying to connect to it via the MySql ODBC 5.1 driver. I'm getting an authorization failure (401) from the server. The administrator set up my access as follows: mysql> grant select, create temporary tables on theDatabase.* to 'adrian' identified by 'password'; I am successful in connecting...
Is it possible to modify the connectionstrings defined in the app.config/web.config at runtime? I want to use different configfiles depending on the machine the app/site is run on (only for debugging purposes, of course. We'll use the regular config files when deployed). I can write AppSettings, but not ConnectionStrings (AFAIK). Or can...
Hi, I have a windows application connecting to Database to read some data. Since the database is setup for resilience, my application needs to connect to one of the two databases. Can someone specify the what the syntax would be to specify the failover partner in a connection string using sql server authentication. Any help is greatly a...
Hi all, I am facing problem with database connection. As I know if we create new user, using Create UserWizard control and after running it if we refresh the refresh button from solution explorer,aspnetdb.mdf will generated automatically under app directory.But in my case its not happening.I mean aspnetdb.mdf is not generating. Once I su...