December 20, 2005 at 5:44 am
I am testing my application with Yukon. It uses ADO to connect to SQL Server. Everything works fine except for the bulk inserts.
The bulk Insert query is 'BULK INSERT Nodes_TempUnknownSW FROM '\\NAC-XP\bvNIBCPData\UnknownSW.txt' WITH (FIELDTERMINATOR = '|', TABLOCK)'
Interesting part is that it does not work through the SQL Query Analyzer as well. But it does work from the Management Studio (Yukon's UI). I also figured out that the SQL Server Enterprise Manager cannot connect to Yukon version of SQL Server as well.
Anybody has any idea as to what has changed in Yukon or how I can make it work. What exactly does Yukon do through the Management studio that is different from what the query analyzer or the ADO does.
Any help on this would be appreciated.
Thanks in Advance.
Dinesh
December 20, 2005 at 6:17 am
Dinesh - I probably will not know the answer to this question, but I'm sure that it will help others who do to work out what the problem is if you post the error message that you are receiving.
The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply