From ConnectionStrings “If you want to read the column headers into the result set (using HDR=NO even though there is a header) and the column data is numeric, use IMEX=1 to avoid crash. To always use IMEX=1 is a safer way to retrieve data for mixed data columns. ..” Please note that the IMEX value … Read more
As detailed in the jTDS Frequenlty Asked Questions, the URL format for jTDS is: jdbc:jtds:<server_type>://<server>[:<port>][/<database>][;<property>=<value>[;…]] So, to connect to a database called “Blog” hosted by a MS SQL Server running on MYPC, you may end up with something like this: jdbc:jtds:sqlserver://MYPC:1433/Blog;instance=SQLEXPRESS;user=sa;password=s3cr3t Or, if you prefer to use getConnection(url, “sa”, “s3cr3t”): jdbc:jtds:sqlserver://MYPC:1433/Blog;instance=SQLEXPRESS EDIT: Regarding your Connection … Read more
. and (local) and YourMachineName are all equivalent, referring to your own machine. (LocalDB)\instance is SQL Server 2012 Express only. The other parts are depending on how you install – if you install with an instance name – then you need to spell that instance name out (SQL Server Express by default uses the SQLEXPRESS … Read more
This is what I would do safely store connection string credentials Download and install Visual Studio Express 2012 for Windows (FREE) Open it as Administrator and create a New Project. Select Visual C# then Class Library and rename it to HiddenConnectionString In the Solution Explorer, rename Class1.cs to MyServer.cs Right click your MyConnection project in … Read more
Requires .NET framework 4 updated to at least 4.0.2. If you have 4.0.2, then you should have HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft.NETFramework\v4.0.30319\SKUs.NETFramework,Version=v4.0.2 If you have installed latest VS 2012 chances are that you already have 4.0.2. Just verify first. Next you need to have an instance of LocalDb. By default you have an instance whose name is a single … Read more
The posted answer is fine but didn’t directly answer the same question I had about reading in a connection string. Through much searching I found a slightly simpler way of doing this. In Startup.cs public void ConfigureServices(IServiceCollection services) { … // Add the whole configuration object here. services.AddSingleton<IConfiguration>(Configuration); } In your controller add a field … Read more
Place single quotes around the Extended Properties: OleDbConnection oconn = new OleDbConnection( @”Provider=Microsoft.Jet.OLEDB.4.0;Data Source=” + path + “;Extended Properties=”Excel 8.0;HDR=YES;IMEX=1;”;”); Try it, it really works.
If your migration does not work correctly try to set Database.Initialize(true) in DbContext ctor. public CustomContext(DbConnection connection) : base(connection, true) { Database.Initialize(true); } I have similar problem with migrations. And in my solution I have to always set database initializer in ctor, like below public CustomContext(DbConnection connection) : base(connection, true) { Database.SetInitializer(new CustomInitializer()); Database.Initialize(true); } … Read more
I’ve written about this in a post on my blog. The trick is to use reflection to poke values in as a way to get access to the non-public fields (and methods). eg. var settings = ConfigurationManager.ConnectionStrings[ 0 ]; var fi = typeof( ConfigurationElement ).GetField( “_bReadOnly”, BindingFlags.Instance | BindingFlags.NonPublic ); fi.SetValue(settings, false); settings.ConnectionString = “Data … Read more
You need to add a reference to System.Configuration and then use: System.Configuration.ConfigurationManager. ConnectionStrings[“connectionStringName”].ConnectionString;