sqlBulkCopy

[Beth]

Hi.
I have some VS 2005 VB.NET code that uses the writeToServer method of a
sqlBulkCopy object to write records in a dataTable to the SQL server.

The code works fine against our SQL Server 2000 database, but we get a
'login failed' error against 2005.

The DBA says the account on 2005 has dbOwner permissions and bulk
administrator permissions. I'm not setting any of the copyOptions of the
writeToServer method.

Any ideas for what to try to get this to work on our 2005 server?

Thanks,

-Beth

 

[William Vaughn]

Hummm, this is a DBA issue. I have not had that problem 'cause I cheated. My
account has SA rights. I would take this to the SQL Server newsgroup.
I'll also echo it in the SQL Server MVP list as well. Perhaps one of the
gurus over there have seen this.

--
__________________________________________________________________________
William R. Vaughn
President and Founder Beta V Corporation
Author, Mentor, Dad, Grandpa
Microsoft MVP
(425) 556-9205 (Pacific time)
Hitchhiker’s Guide to Visual Studio and SQL Server (7th Edition)
____________________________________________________________________________________________