python - SQL server bulkinsert errors -

-

when run query bulkinsert file on shared drive sql server 2008 username , password (not windows authentication), these errors. dba, system admins , network guys denying these errors related teams , lost... can please me identify issue is? when run bulkinsert database username , password, authentication sql server use open file?

run on ms management studio

bulk insert databasename.dbo.tablename '\\shared_server\parent\child\file_name.txt'  with(fire_triggers, datafiletype='char', fieldterminator='\t',rowterminator='\n', firstrow=2);

and get

cannot bulk load because file  "\\shared_server\parent\child\file_name.txt" not opened. operating system error code 5(access denied.).

run on python 

import pyodbc  database = 'databasename' username = 'username' password = 'password' server = 'server_name' failover = 'failover_server_name' cnxn_string = 'driver={sql server native client 10.0};server=%s;failover_partner=%s;database=%s;uid=%s;pwd=%s;charset=utf8' % (server, failover, database, username, password) cnxn = pyodbc.connect(cnxn_string) cursor = cnxn.cursor()  query = r""" bulk insert estimates.dbo.fundamentalsis  '\\shared_server\parent\child\file_name.txt'  with(fire_triggers, datafiletype='char', fieldterminator='\t',rowterminator='\n', firstrow=2); """ cursor.execute(query) cursor.commit()"

and get

programmingerror: ('42000', '[42000] [microsoft][sql server native client 10.0][sql server]cannot bulk load because file "\\shared_server\parent\child\file_name.txt" not opened. operating system error code 1326(logon failure: unknown user name or bad password.). (4861) (sqlexecdirectw)')

could ms sql server 2008 possibly on different security group (or have different settings) shared drives, file located?

because bulk insert operation run on ms management studio server side, might not have access file, 'access denied' leads me believe db server cannot shared file drive, , possibly not have permission access it. likewise, if using python execute bulk insert statement, db server still needs have access ever file located.

i had similar issue in past, because db server not shared file, located elsewhere. workaround use local computer read in file , run insert queries using python. sounds local environment has access both , can used central communication hub. might have similar to


Comments

Post a Comment

Popular posts from this blog

python - TypeError: start must be a integer -

-
i trying draw 5 turtles, getting typeerror on line 25. here code: import turtle wn = turtle.screen() redrose = turtle.turtle() color = input("what background color be?") fillcolor_f = input("what color of rose be?") redrose.hideturtle() redrose.speed(30) redrose.penup() redrose.left(180) redrose.forward(175) redrose.right(90) redrose.forward(30) redrose.right(90) redrose.pendown() def drawrose(red): redrose.color("pink") redrose.fillcolor(fillcolor_f) redrose.fill(true) in range(red): redrose.forward(i) redrose.right(49) in range(5): drawrose(redrose) redrose.penup() redrose.forward(350) redrose.right(144) redrose.pendown() redrose.fill(false) drawrose(50) wn.bgcolor(color) i trying draw 5 roses, produces errors. doing in interactivepython.org. you recursively calling drawrose wrong parameter. on line 23 ( for in range(red): ) expect red integer...
Read more

c# - DevExpress RepositoryItemComboBox BackColor property ignored -

-
i have following code almost works properly; private void cbstatus_drawitem(object sender, listboxdrawitemeventargs e) { string item = e.item string; if (item != null) { switch (item) { case "1": e.appearance.forecolor = color.green; e.appearance.backcolor = color.green; break; case "2": e.appearance.forecolor = color.orange; e.appearance.backcolor = color.orange; break; case "3": e.appearance.forecolor = color.red; e.appearance.backcolor = color.red; break; } } } when dropdown shown, items forecolor correct, backcolor remains whatever backcolor of theme is; i.e. if i've got set dark theme, backcolor dark, cells in gridview, rather being green/orange/red. i've tried setting e.appearance.options.usebackcolor trying set e....
Read more

django - Creating multiple model instances in DRF3 -

-
1) create multiple model instances 1 api call, asked here: how create multiple model instances django rest framework? tried solution named in link, no success. i trying upload multiple files in 1 api call. result: files uploaded (only once overwrote perform_create) 1 instance created (if send 2 files, latter created instance). my code: class fileuploadserializer(serializers.modelserializer): def __init__(self, *args, **kwargs): many = kwargs.pop('many', true) super(fileuploadserializer, self).__init__(many=many, *args, **kwargs) class meta: model = fileupload read_only_fields = ('created', 'datafile', 'owner') class fileuploadviewset(viewsets.modelviewset): queryset = fileupload.objects.all() serializer_class = fileuploadserializer parser_classes = (multipartparser, formparser, ) def perform_create(self, serializer): file_list = self.request.data.getlist('file') ...
Read more