I'm working on an app which is using OLE DB and SQL Server Native Client to access a SQL Server DB. To date, I've only been dealing with fairly simple SQL. For this, I've been obtaining an ICommandText and using SetCommandText. I now want to insert a large object into the database. I see that ICommandStream exists, but it seems like ...
I love the new DATE datatype in SQL Server 2008, but when I compare a DATE field to a DATETIME field on a linked server (SQL 2005, in this case), like this: DECLARE @MyDate DATE SET @MyDate = CONVERT(DATE, GETDATE()) SELECT * FROM MySQL2005LinkedServer.SomeDB.dbo.SomeTable WHERE SomeDatetimeField < @MyDate I get this error: OLE D...
short version: the sqlsrv driver (Native Client wrapper) "eats" constraint violation errors generated from triggers; the mssql driver (ntwdlib wrapper) reports them just fine. SQL Server 2005 PHP 5.3.1 SQL Server Driver for PHP 1.1 fixture: CREATE TABLE t ( t INT NOT NULL PRIMARY KEY ); CREATE VIEW v AS SELECT CURRENT_TIMESTAMP ...
I am experimenting with WineBottler and I would like to try to run my win32 native application written in Delphi on OSX. The application runs, but I stop at login screen since I cannot connect to SQL Server. Does anyonw know how to install and configure SQL Server native client on OSX so that it is usable with WineBottler? Note: I put...