i have a code which has the connection string as driver. dim s as string = "Driver={SQL Server}; Server=xxx\SQLEXPRESS; Database=dbRegister; Trusted_Connection=yes" i need to change that to - "data source=1.2.3.4;user id=xx;password=xxxxx;initial catalog=xxxxx;Connect Timeout=30" when i just change the text it gives this error - "[Mic...
Borderline ServerFault question, but figured I'd try here first since I've had luck with Oracle questions in the past. I'm trying to connect to an oracle database from PHP, and I'm getting the following error. ORA-12505: TNS:listener does not currently know of SID given in connect descriptor This is the error that PHP reports, and th...
Hi, i'm developing a .net winforms desktop application intended to be run at several bank's branches as a backup application whenever the main one (a web application) is unavailable due to connection issues with the bank's central node. The branchs themselves don't count with any enterprise services besides a SQL-Server database. For tha...
At my shop we are used to store connections strings in the .config file. But when we had to update it in several applications in the same machine someone gave the idea of storing it on the windows registry. Is this a good idea? What are the implications (security)? ...
Hello, I created an c# application (not asp webpage) which connects to a sql 2005 server. In my sourcecode the password and userid for this sql-server is coded plain text in ConnectionString. SqlConnection con = new SqlConnection(); con.ConnectionString = "Data Source=server1;"+ "Initial Catalog=mydatabase;"+ ...
Does anyone have a good example or helper class that would allow me to read the connection string in a web application from a T4 template residing in ANOTHER assembly referenced by the web application. I am generating some code from the database that it references and i would appresiate some help on how to get the connection string for t...
Please some help on how to debug this! On my development machine I can succesfully host a local WCF service that uses a SQLIte database for its storage. I simply xcopied the wcf service dll's, the database file and the System.Data.SqLite.dll to the win 2008 server. The server hosts the the WCF service in IIS7.This worked without a hitch...
I have problem while connecting to mysql database using "ADO.NET Driver for MySQL (Connector/NET)" I got this exception The given key was not present in the dictionary. Edit: MySqlConnection con = new MySqlConnection("Server=localhost;Database=pgs_db;Uid=root;Pwd=;"); MySqlCommand com = new MySqlCommand(); com.CommandType = CommandT...
I store my connection-string in XML file. Then i use it in powershell script. Is there a way to secure it/to encrypt it somehow? ...
I set up a database mirroring and then used this connectionstring to connect to it: Data Source={0};Failover Partner={1};Initial Catalog=AdventureWorks; Integrated Security=True; After adding some data into database, I shutdown the principal server, so the mirror server becomes the principal server. I open the connection again...
I'm having trouble figuring out databases in VB.NET. (VS 2008) What control(s) do I need to use and how do I use them? I am ,looking for tutorials and sample code too. I'm working on a trivia game where the admin can remove and add questions to a database. EDIT: The program must be able to do all of the DB interactions itself throu...
Is there a way to display the connection properties dialog for connection string browsing(for database) in run time? As I want the user to be able to connect to various database using the GUI. The same one as we get in visual studio connection properties dialog. Thanks in Advance ...
I am working on a C# 4.0, WPF 4.0, SQL 2008 project and I do work at home and in the office. I just setup SubVersion using Visual SVN per the recommendations found in other questions. The problem I am having is the connection string for the database is different for each location. At home I have the database on my dev system, in the off...
I have an issue where users on my web site have recently begun to receive the error message: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) I know that the connection strings in the code are correct, as users are able to query the database view pages that retrieve info from and submit user-generated...
hi i have build my project in C#, i add DataSet.xsd, and connect him to Oracle DataBase in my computer - work Excellent !!!! when i installed on the customer computer (that connect to his Oracle DataBase) - it crushed. i need to change the connection string on the DataSet.xsd file - but how to do it ? is there any xml file ? or co...
is it possible to get MSSQL connection info?not onli SUSER_ID(), SUSER_NAME(), ORIGINAL_LOGIN(), BUT other like: IP Connection string ect.. ...
so the story is like this. I have a project, called PA.DLL, which have an entity model inside of it (edmx) file. In another project which i'm referencing to the PA.DLL, i copied the connection string that was created (automatically) when creating the edmx file into the main app app.config. however, when i load and run the following l...
I am not used to work with SQL Server(usually I just use express). I run it on windows server 2008, iis7. I have attached the database to my sql server. I made a web site in iis7 but I get this error message. Cannot open database "Phaeton.mdf" requested by the login. The login failed. Login failed for user 'NT AUTHORITY\NETWORK S...
Hi. I been strugling with this for 2 days now without comming any closer to solution. I have read 20-30 threads alteast and stil can not resolve this. Please help me out. I have disable anonymous authentication, enable asp.net impersonation. I have added <identity impersonate = "true" /> I have added the a user to the security logins...
Hi there, I'm building an app in C#. I'm using a connection string like: DSN=SomeDataSource; Trusted Connection = yes; Uid=SomeId; pwd=somePwd; Connection Timeout=x But no matter what value I set as x (Connection Timeout = x), by putting a breakpoint, I can see that my DbConnection object's ConnectionTimeout property always has the d...