做了一个MFC客户端,远程访问别的电脑上的SQL server 数据库,在向SQL Server 2008 FILESTREAM数据库中添加数据的时候,出现了下面情况,
添加代码如下:
sql.Format(_T("INSERT INTO modelDB_TAB(MODELName,GUID,MODELFILETYPE,MODELSIZE,UPLOADDATE,TEXT,MODELData) SELECT '%s' AS MODELName,NEWID() AS GUID,'%s' AS MODELFILETYPE,'%s' AS MODELSIZE,GETDATE() AS UPLOADDATE,'%s' AS TEXT,*FROM OPENROWSET(BULK N'%s',SINGLE_BLOB) AS MODELData"),m_filename,str,m_filesize,m_filetext,m_filepath);
,在数据库所在的电脑上试过,能够添加,请教高手。