Unix Technical Forum

BCP_INIT Question

This is a discussion on BCP_INIT Question within the MS SQL ODBC forums, part of the Microsoft SQL Server category; --> Hi. I am trying to load data from program variables using ODBC interface. ret := bcp_init(fhdbc, Table,'',ErrorLog,1); I call ...


Go Back   Unix Technical Forum > Database Server Software > Microsoft SQL Server > MS SQL ODBC

Register FAQ Members List Calendar Search Today's Posts Mark Forums Read
  #1 (permalink)  
Old 02-27-2008, 07:11 PM
news.microsoft.com
 
Posts: n/a
Default BCP_INIT Question

Hi.

I am trying to load data from program variables using ODBC interface.

ret := bcp_init(fhdbc, Table,'',ErrorLog,1);

I call bcp_init with error log file as a parameter.

How everthere are no error messages at all. It actually creates error log
but it is empty.

and bcp_sendrow returns success.

When I use db lib everything is fine except I cant load data into identity
filed.

Is there any way to get info for a log file like PK violation or
constraint/not null violation.

Also another problem

Let say I have a table with 2 fileds.

If I don't bind last column it does not load any data at all

It is related only for ODBC.

For dblib it works fine.

Any Ideas?

Vladimir


Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On
Forum Jump


All times are GMT. The time now is 09:13 AM.


Powered by vBulletin® Version 3.6.5
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
SEO by vBSEO 3.2.0
www.UnixAdminTalk.com