Tag Info

Hot answers tagged

3

You may need to use SQL Server Configuration Manager to enable TCP/IP connections. The default is disabled, as below. You must enable TCP/IP to allow remote connections to the SQL Server machine.


3

Don't reference it as [dbo].[vendor].[location].Lat in the SELECT list. use simply vendor.location.Lat or location.Lat or define a table alias and use that. CREATE TABLE dbo.Vendor([location] geography) GO /*Works fine*/ CREATE VIEW V1 AS SELECT v.location.Lat AS latitude FROM dbo.vendor v GO /*Fails*/ CREATE VIEW V2 AS SELECT ...


2

Management Studio is the tool you should probably be using to manage a SQL Server database. You can download SQLManagementStudio_x64_ENU.exe from here: http://www.microsoft.com/en-us/download/details.aspx?id=43351 For the C# side, you could use Visual Studio: http://www.visualstudio.com/downloads/download-visual-studio-vs#d-express-windows-desktop


2

Native, no. Heck, I barely classify the out of the box FTP component as a real component. It meets some technical specification for FTP only for the most rudimentary operations. I've usually gone the route of calling ftp.exe from the Execute Process Task with a parameter file or just used the .NET libraries for doing so. I had never thought about ...


2

I recommend not using Entity Framework with anything else other than SQLSERVER. And then LINQ to SQL may be better. lightspeed was recommended to me as a better product. I personally have not used it.


1

you can follow the tutorial in this link in-order to use PostgreSQL under C# and .net framework http://www.codeproject.com/Articles/30989/Using-PostgreSQL-in-your-C-NET-application-An-intr for managing the database side you can use aquafold (in my opinion one of the best database management for PostgreSQL check the following link http://www.aquafold.com/), ...


1

That C# script reads the file and executes each line from it. That works fine beacause the file contains only one line statements. If your T-SQL structure from your file is the same, then that C# code will work for you. You can check that by opening the file with Notepadd++. Cheers,


1

At the time of this writing, there is not public repository for Connector/NET, if you have performance/scaling improvements you are welcome to contribute them (together with a bug report) at bugs.mysql.com.


1

The syntax you're looking for is here CREATE {DATABASE | SCHEMA} ... [PAGE_SIZE [=] size] ... [DEFAULT CHARACTER SET charset [COLLATION collation]] ... [DIFFERENCE FILE 'filepath'] size ::= 4096 | 8192 | 16384 Also check out this page and this link from it specifically about case insensitive searches and collations on columns. ...


1

I did the same thing as Scott Chamberlain with the Itenso RTF DLL, but in my case there was a LOT more work that had to be done before this could be marked as SAFE in my SQL 2008R2 database. First, like Scott, I had to remove the reference to System.Drawing. I found the easiest way to do that was to remove the reference, recompile and then rewrite the bits ...


1

When I run sp_lock, I realized that two locks in my table: PAG and KEY. Searching more about KEY LOCK, I created an index for the column on the where clause, and this solve my problem. EDIT: When I removed the where clause (without index) , it worked fine too.


1

When you use Encoding.Default the result is dependent on local settings: An encoding for the operating system's current ANSI code page. The specification is pretty direct about the dangers of using the default encoding and very specifically calls out the recommendation not to use it: Different computers can use different encodings as the default, ...


1

As shown in Max Vernon's screenshot in his answer, you must allow TCP/IP connectivity for remote connections. Also, if you are not allowing traffic to the default instance (TCP 1433) that would also prevent connectivity. If you are trying to connect to a non-default (named) instance, you must have the port for that instance open as well. If your connection ...


1

In my view, you're on the right track and validating it in C# before sending it to the database is the better way, so you're able to show the changes before a submit. A regular expression should indeed be able to solve your validating issue, but depending on how you allow the number to be entered plays a part in how complex it should be. Say do you allow ...


1

Are you sure you have the right password? If you have forgotten your password, try resetting to trust first, and then running the following sql statement to set the password: alter user postgres with password 'the_password'; Then you should be able to connect using md5 auth and the_password as the password



Only top voted, non community-wiki answers of a minimum length are eligible