I have a web application which i make on my local host and publish it on different servers. in the web config of this application i have connectionstrings property like: <connectionStrings> <add name="MyConnectionString" connectionString="Data Source=XYZ-PC\SQLEXPRESS;Initial Catalog=SumooHServerDB;Integrated Security=True" providerNam...
An ASP.NET 3.5 application has two connection strings: Data Source=RedDB;Initial Catalog=Red;User Id=myuser;Password=pas;Max Pool Size=50;Min Pool Size=1 Data Source=BlueDB;Initial Catalog=Blue; User Id=myuser;Password=pas;Max Pool Size=375;Min Pool Size=2 Suppose the RedDB connection has a stored procedure that is hanging indefinite...
I had been working on a project in VS2005 that utilized a local connection to an Access DB. In the past week, I installed .NET framework 3.5 for use w/ a different project as well as VS6. I went back to my VS2005 application and suddenly there are big issues: In the designer for any class utilizing my OLEDB connection showed this: Un...
This sounds really easy to fix but I've been working on it for awhile. Database Error: Unable to connect to the database:Could not connect to MySQL I had to make a local copy of Joomla for backup and changes so I didn't mess up the live site. I grabbed all the files off the live site via FTP. Did a DB dump. Put the DB on my local m...
Today I noticed that in my ConfigurationManager.ConnectionStrings the very first instance is .\SQLEXPRESS. I remembered explicitly removing this entry from my web.config so I checked again, but didn't find a thing. Then I did a search over my entire solution, not a single match. Where the hell is this connection string coming from and ho...
Hi, i need to open a connection to a remote access db. in the local environment to the remote acess db is working great . when i run this application from production server (other server) it's fail with message " It is already opened exclusively by another user, or you need permission to view its data. " my code : conStr...
I need to give the user the ability to change application settings, in this case the location for the application database. I noticed that Application Settings are read only at run time, but this needs to be application-wide, not user-specific. How do I persist an application-wide connection string in windows.forms that is changeable a...
I'm trying to create a VB6 application linking to Microsoft Access 2007. I'm going to save account names and passwords in Access 2007. I'm using VB6 as the front end. Would somebody help me on the connection string and the codes to store and check the account names and passwords. ...
Is there a way to see what connection string was used to connect to SQL Server? Or rather what string was used in a failed login attempt. Many times I deal with complex systems in which I see failures caused by some service failing to log in to SQL. I am guessing the connection string might be wrong, but since I can't see what it was I ...
I have a console application which gets the connectionstring as a parameter. I would have to set a ConnectionString in app.config with name 'ConnectionString' and the given parameter as the sql connectionstring. Thx to answers. With help of the links I got to this: var config = ConfigurationManager.OpenExeConfiguration(Configurati...
I am trying to connect my DB to a project in c# and it is not working? any ideas?? static string connectionString = "Data Source=ESTER-PC;Initial Catalog=fridge; Integrated Security=True;Server Version=9.00.1399.06;"; //"Data Source=Fridge;Persist Security Info=True;"; ...
How do I connect to Mas90's file using their ODBC that they setup - SOTAMAS90? how do I do this in vb.net ? ...
my sql server instance name is MYPC\SQLEXPRESS and I'm trying to create a jTDS connection string to connect to the database 'Blog'. Can anyone please help me accomplish that ? I'm trying to do like this: DriverManager.getConnection("jdbc:jtds:sqlserver://127.0.0.1:1433/Blog", "user", "password"); and I get this: java.sql.SQLExcepti...
I have a MVC web site that worked well, until I moved it into test, where it fell over. After some investigation If found that because I had split the 'model' into its own seperate project, the model was using the connectionstring from its own app.config (not the web.config of the website). So I found an article somewhere (can't find t...
Hello, I've been running an ASP.NET MVC application on my IIS 7.5 localhost (on my Win7 Pro box) server with SQL Server 2005 Developer Edition. I went to put the application on my production server (IIS 7, SQL Server 2008) and am getting SQL Server connection errors. Here is the error I get when I try to browse site root: A network-...
microsoft visual studio opens my table using dataset designer but i cannot open my table using the same connectionstring. my database is DBase IV. and this is the connectionstring Driver={Microsoft dBASE Driver (*.dbf)};collatingsequence=ASCII;dbq=d:\Data\88;deleted=0;driverid=277;fil=dBase IV;maxbuffersize=2048;maxscanrows=8;p...
My application needs to do a certain query against a user-specified connectionstring. The query will need some parameters, so I was thinking of using the DbProviderFactory , in combination with myConnection.GetSchema("DataSourceInformation").Rows[0]["ParameterMarkerFormat"] to find out if I need to use :(Oracle), @(Sql) or ?(OleDb) to s...
I'm trying to set a DataAdapter connection string to point to %APPDATA% from within Visual Studio designer by editing the DataAdapter properties. I cannot seem to be able to use that moniker on the connection string property. It doesn't get translated to C:\Users\MyUserName\AppData\Roaming when I then run the application in debug mode. ...
In SQL 2005/2008 is there any way to set default lock_timeout values. Anything at the server, database, or connection string level would be great. ...
Hi guys, I am having a strange error with VC# Express and System.Data.SQLite's Design-Time Database Explorer. You can see the error itself at http://tinypic.com/r/rcsl5g/6. What happens is, I go to Tools -> Connect to Database, select SQLite Database File, and then a window comes up with one place to enter a Connection String(you can see...