PRB: ODS Does Not Support Bulk Load (97574)
The information in this article applies to:
- Microsoft SQL Server 4.2x
This article was previously published under Q97574 SYMPTOMS
Applications built using the Open Data Services API cannot identify and
pass to SQL Server requests to bulk load data. This means that BCP.EXE and
the DB-Library bulk copy special library routines cannot be used to load
data into a SQL Server through an intermediate ODS layer. However, BCP and
the bulk copy libraries can be used to extract data from SQL Server.
CAUSE
DB-Library clients communicate to SQL Server and ODS applications through a
protocol known as Tabular Data Stream (TDS). TDS makes use of a number of
message types, which roughly correspond to ODS events. For example, the
dbsqlexec() function generates a message that is recognized by Open Data
Services as a srv_language event. The bulk copy special library routines
make use of another message type which is currently mapped by Open Data
Services to a srv_language event.
WORKAROUND
Because the ODS API currently provides no functions to extract the data
from the "bulk insert" message, the data cannot be correctly extracted and
subsequently forwarded to SQL Server.
| Modification Type: | Minor | Last Reviewed: | 2/14/2005 |
|---|
| Keywords: | kbprb kbProgramming KB97574 |
|---|
|