Every SQL Server connection string I ever see looks something like this: Data Source=MyLocalSqlServerInstance;Initial Catalog=My Nifty Database; Integrated Security=SSPI; Do I need the Initial Catalog setting? (Apparently not, since the app I'm working on appears to work without it.) Well, then, what's it for? ...
If one has a connectionstring in one's application, is there a way to encrypt the information it contains? The connection string is created using the SqlConnectionStringBuilder object. Or is it 'acceptable' that sensitive information is sent in plaintext to the server? ...
Hi, I've been convinced to use windows setup files(msi) for the installation of my new windows forms application after I asked a question here and got some excellent answers (thank you all): http://serverfault.com/questions/97039/net-application-deployment Now i have a different question: My application will need to access a SQL Serve...
Management strikes again. How should I satisfy the code scanner that is going to read my php source and red flag my MySQL connection string? Linux Server (soon to be Sun) php 4.2 (soon to be latest version) MySQL database Servers in a DMZ outside of the firewall Read only MySQL account Not a single byte of non public information in t...
Is there any official write-up what forms can Data Source field take in sql server connection string? I'm aware of following forms: SERVER SERVER\Instance tcp:SERVER,port nb:SERVER nb:SERVER\Instance are there more forms? EDIT: The essence of this exercise is not to construct a connection string. I am trying to parse existing connect...
I'm writing a CFC on a server running Coldfusion MX 7. The CFC needs to be able to query a database the location of which will be determined at runtime. The database is SQL Server 2005. The CFC takes the IP address of the server and the name of the database as arguments, and the built-in Windows Authentication should allow connections fr...
Hai guys, I use the following connection string <add name="connectionString" connectionString="server=localhost;user id=root; password=; database=lms; pooling=false;" providerName="MySql.Data.MySqlClient"/> It gives me the error There is no 'lms'@'%' registered. My database server is localhost and the user account doesn't have a pas...
Is it possible to set a property or variable on MYSQL connect string so that the tablenames are not case sensitive when queries are run on the session? MySQL client/server is running on Linux and storage engine is InnoDB but can be controlled by specifying sessionVariables=storage_engine=MyISAM in the connect string. jdbc:mysql://host:...
I thought that VS 2005 automatically generated the connection strings in the web.config, however I can't for the life of me remember how. ...
As all we know, Connection string is a very important info.... So taking this strategy while developing .net win-based application : "get a new connection object, use it, close and dispose it each time you need", How to handle connection string within the application? ...
OK, Ive got my site all up - just not working. ahah. I need (I think) the correct code for a connection string to my database etc. I'm using ColdFsuion and Mysql. My code for the connection string is as follows: <CFQUERY NAME="cfGossip" DATASOURCE="mysqlcf_bridgettip" USERNAME="<bridgettip>" PASSWORD="<*******>" > </CFQUERY>...
Using Visual Basic for Applications, how can I find out which version of the MySQL ODBC driver is installed in Windows on a user's machine? I have a Microsoft Access application that uses the MySQL ODBC driver to make a connection. The connection string looks like this: ODBC;DATABASE=mydatabase;DRIVER={MySQL ODBC 3.51 Driver}; OPT...
So, we are migrating an old web app from a 32-bit server to a newer 64-bit server. The app is basically a Classic ASP app. The pool is set to run in 64-bit and cannot be set to 32-bit due to other components. However, this breaks the old usage of Jet drivers and subsequent parsing of Excel files. After some research, I downloaded the 6...
Hi, I'm planning on moving a database from C: drive to E: drive because the database is growing and the C: drive does not have enough capacity to handle that. I wonder if I need to changes anything in the connection on the web.config page in order to access the database. The database still has the same name, is still on the same serv...
Am trying to run a C# application which fetches data from PostgreSQL database(8.4) and am using the PostgreSQL OLE DB Provider This is my connection string string connString = @"Provider=PostgreSQL OLE DB Provider;Data Source=localhost;location=;User ID=;password=;timeout=1000"; The error am getting is The 'PostgreSQL...
Can someone tell me what I am missing? I am using this connection string to connect to my database and still it won't connect: Dim str As String = "Provider = .NET Framework Data Provider for SQL Server; Data Source=C:\Users\konin\Documents\UHMS\bin\Debug\UHMS.mdf;Integrated Security=True;Connect Timeout=30;User Instance=True" This is...
Hi, I have a bunch of SSRS 2008 reports which I'd like to run on several different machines (development, test, production). Each machine has it's own database, so I need to use different connection strings depending on where the report is running. One workaround I found is to specify the server and catalog name in a hidden parameter ...
Hi, We have a windows account in the SQL Server 2008 called drwho for example and a password. In the connection string we disabled integrated security and added User Id and password values. User Id=THEDOMAIN\drwho;Password=...... However ASP.NET keeps thinking we are using SQL server authentication. Any suggestions? ...
Hi, I'm trying to connect to a named SQL instance on the server. There is already default instance of SQL Server 2005 and a newly named one - SQL Server 2008. I'm using the "Network library" property to use TCP connection but for some reason, he try's to connect the default instance and omit an error about login error. If I remove the n...
Is it possible to set connection collation within MySql connection string and how, since there's a default setting on the server that's used for new connections. Two things I can't do: Can't call SET COLLATION_CONNECTION after I open a connection, because I'm using Entity Framework that does all the calls for me not entirely true as y...