Tag Info

Hot answers tagged


If you're on SQL Server 2008 R2, I'd recommend taking a look at the Open Data Protocol (also known as OData). Microsoft has some FAQs on it as well, and there is a Java client library available. Also take a look at sqlREST, which exposes relational databases using web services and works with most databases that have a JDBC driver.


I have seen this before. According to the Sybase ASE Documentation: Adaptive Server Enterprise implements dynamic SQL using temporary stored procedures. A temporary stored procedure is created when a SQL statement is prepared, and destroyed when that prepared statement is deallocated...[a]s a consequence of this implementation, an application accessing ...


Background From wikipedia RESTful API REST was initially described in the context of HTTP, but is not limited to that protocol. RESTful architectures can be based on other Application Layer protocols if they already provide a rich and uniform vocabulary for applications based on the transfer of meaningful representational state. RESTful ...


I could be that the Linux TDS implementation is outdated compared with the SQL Server version Windows Azure uses. See: http://msdn.microsoft.com/en-us/library/dd340799.aspx. At least the FreeTDS docs at http://www.freetds.org/userguide/tdshistory.htm indicate they are not up to par with the latest versions. Try to connect using JDBC on your Linux machine for ...


I know this is an old question but for the sake of "drive by googlers" I shall attempt an answer. I'm assuming you know the backslash doesn't belong in your cmd line and that the servername showing in your output is something random you typed to hide the actual name. Check this page http://www.freetds.org/userguide/confirminstall.htm Its got info on ...


tds7_get_instance_port means freedts is using udp 1434 to query the port of the instance (source: net.c). But this should only be called if the instance is specified. Please doublecheck your freetds.conf


I suspect the one of the values is NULL, so the whole expression concatenation is NULL. You'd need this: CAST(ISNULL(PageGuid, '') as varchar(max)) + ',' + CAST(ISNULL(TenantGuid, '') as varchar(max)) + '/' + CAST(ISNULL(OriginalFileGuid, '') as varchar(max))

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