How can I create a valid connection string by using shared memory protocol to connect a named instance of sql server while the sql server browser is disabled? ...
Hello, So far, after creating DB with all the schema, all I have done so for was accessing them (tables) by reference through ConnectionStrings. Now, twice, I've read that it's better to create a DB user and access the DB trhough that user by including him in the c*onnectionString*. I'd like to know why so? Thank for helping ...
I have a connection string that all of the applications on my site need to know about. I know that I can put it in machine.config or root-level web.config but let's say that those options are not available to me and the only thing I can do is to modify applicationHost.cofig. I have tried this and the connection string does appear in the...
I have Oracle (10g Express Edition) installed on one pc. Visual Studio 2008 SP1 is installed on another pc. I want to run an ASP.NET web app that uses the remote database. The two PCs are connected by a LAN (wired) connection. How can I connect to the database? What will the connection string be? The operating system on both PCs is Win...
Hi, I'm using mysql database for my site, i want to use mysql pooling. How do I implement mysql pooling on c# environment ? i"m using the connection string like this example : User ID=root;Password=myPassword;Host=localhost;Port=3306;Database=myDataBase; Direct=true;Protocol=TCP;Compress=false;Pooling=true;Min Pool Size=0;Max Pool Si...
I know that I can set the connection timeout for MS SQL Server when using ADO or OLE DB, by adding Connect Timeout=somevalue to the connection string. This doesn't seem to work for ODBC connections though. Specifically, we made the decision to use the standard SQL Server ODBC driver that ships with Windows XP (SQLSRV32.DLL version 2000....
I need to connect to Excel table through TADOConnection, and I don't know what to write into ConnectionsString property. For Excel Version 8 I use Jet, for 12 I use ACE, what about 11? And how should connectionstring look? ...
Hi I've got 3 connection strings in my app: <add name="DBConnectionString" connectionString=""/> <add name="ADConnectionString" connectionString="" /> <add name="TestDBConnectionString" connectionString="" /> now in the code i do: public static string DefaultConnection { get { // this is used so ...
If we want in our WPF application to let a user make a SQL Server db connection settings through dialog window, what approach we should use in implementing this. Should we programmatically make changes to the app.config file? Or, some another approach exists? Or, maybe, in WPF there is some prebuilt tools for doing this? ...
I have a SQL Server 2008 on a server which goes out on the internet through a domain name computer.example.com, I want to develop a .net app on my PC and to connect to that database through SSMS - to create tables and so on... And I still want a connection string which can be accessed from anywhere - I'm thinking at a http ...
I'd like to set default database schema in Oracle Connection URL jdbc:oracle:thin:@<server>:<port1521>:<sid> My sample SQL statement: select monkey_name from animals.monkey I need to query database without schema prefix anymals. i.e. when I run this statement select monkey_name from monkey it will uses animals schema by default....
I am trying to change the database name in the connectionstring located in the App.Config of our servicehost at runtime and restart it afterwards connecting to another database. This works fine, but only if the application is shut down for multiple seconds. Shutting down the application for several seconds seems to clear the cache of th...
Hi there friends I'm doing a project for partial fulfillment of my under graduation. In the program the front end is VB >net 08 and back end is MS Access. The problem is ConfigurationErrorsException was unhandled error. My project is based on gas agency. In this project I take 3 input from user for adding customer details , gas booking a...
Currently we are running multiple Sitecore projects. Whenever the projects go live we create new repositories in our subversion system. The downside in this case is, that when we go live we edit the connectionstring obviously, so that the connectionstrings correspond to the live servers instead of our local servers we run on. When a pers...
What is a good approach to managing a debug and release connection string in a .NET / SQLServer application? I have two SQL Servers, a production and a build/debug and I need a method of switching between the two when my ASP.NET application is deployed. Currently I simply store them in the web.config and comment one or the other out, h...
hi I've saved my project connection string in app.config file and use it without any problem. But some one told me that she has put it in Properties.Resources of her project. Now, my question is is there any preference between these two ways? or what else do you offer? Thank you ...
hi I need for help on encrypting connection string in app.config and save it there and decrypting it and use . Thank you ...
I have a database in SQLExpress 2008 that I am accessing via an EF4 connection. It also contains the ASP.Net role provider tables for the website. In the web.config there are two separate connection strings pointing to the same database. When it comes to debugging the database I get the following error: Unable to open the physical f...
hi how can I open an MS Access 2007 database with a password in c# ? I have tried this: Conn = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\BioDB.mdb ;Password=1966;"); but it doesn't work. ...
Is there any way of specifying a URI (rather than a physical path) as the "Data Source" parameter in an OleDB connection string, or the "Dbq" parameter in an ODBC connection string, such that the default ADO.Net providers will work with it? I've tried file://, and it's a no go, so I just wanted to confirm whether or not this is possible...