Tag Info

Hot answers tagged

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 ...


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

Remmber you need the following assemblies: Microsoft.SqlServer.ConnectionInfo Microsoft.SqlServer.Management.Sdk.Sfc Microsoft.SqlServer.Smo Microsoft.SqlServer.SmoExtended More info http://technet.microsoft.com/de-de/library/microsoft.sqlserver.management.smo.aspx using System; using System.IO; namespace ConsoleApplication2 { using ...


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 ...


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


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

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

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

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

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

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 ...



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