Search results for query: *

let me start explain from this post what i need goal is how to read data and write to shared path remotly from another server on domain so iw ill start test from local read data on same server (D:\ExportExcel\testData.xlsx) ressult success access and read shared path from same server...

case number 3 this is actually what i tried

thanks for support really i get good support from this forum but i try more but ican't get support for remotly reading excel file because it give me access permission denied so i don't know how to solve this issue last thing i try from same server not from sql using python and it read data...

can any one helping me solving this issue please

I work with SQL Server 2019 on server I face issue when I try to read an Excel file from shared path using python 3.10. SQL Server exists on server 7.7 and files exist on another server on Active Directory domain 7.9. When I execute reading to Excel file on local server, it is working from...

I work on sql server 2019 i have table have 20 milion rows . i need to export data Exist on table to only one file by using sql server 2019 . so what best tool and faster tool can help me to extract 20 milions rows from sql server to csv file (only one file ) and on same time is good for...

I work on sql server 2019 . i can't write query below with stuff for xml . so how to change STRING_AGG to stuff xml ? query below take too much time so i need to try with stuff for xml to reduce time cost . query i try it select a.RecomendationId, cast(STRING_AGG(cast(f1.FeatureValue...

I work on sql server 2019 i face issue i can't reduce high cost of sort it reach to 86 percent so How to reduce it please additionally it take too much time to execute it . it take 6:06 minutes execution plan as below : Link statment that make issue select...

I work on sql server 2019 i can't make pivot for feature values based on feature name . i need to apply pivot dynamically because may be tomorrow add new features so it will depend on features on table . for original part id i have 4 features as...

how to use this to solve error Object.ReferenceEquals(null, myObjVar)

I work on csharp i get error object reference not set to an instance of an object code give me error Error object reference not set to an instance of an object: var Data = result.items.Select(e => new { PartID = e.create._id, IsUpdated = e.create.error != null && e.create.error.reason !=null...

i try now to use mape network drive it give me error 5 access is denied using code below import os result = os.system("net use S: \\\\192.168.7.9\\Import\\8") print("result =", result) d = os.path.isdir("S:") print("d =", d) so i try to using domain/account name my question i need to ask is...

I work on sql server 2019 i face issue i can't get part number that have partstring from table chemical based on chemicalid so i get chemicalid from table chemicalParts when part number match part string star refere to variable number of charachters meaning may be 1or 2 or 3 ,etc until 9 or...

can you help me answer this question if i use on python script as below it will working or no need to do that i use code below to reach remote server import paramiko hostname = "your-hostname" username = "your-username" password = "your-password" cmd = 'your-command' try: ssh =...

are need to add user name and password to nert use command or no need if required how to add

i can open maped drive and have all permissions with full control

it shared and give me access is denied

last try i create mapped drive i get error STDERR message(s) from external script: System error 5 has occurred. Access is denied. STDOUT message(s) from external script: result = 2 d = False

after map it give me result STDERR message(s) from external script: System error 67 has occurred. The network name cannot be found. STDOUT message(s) from external script: result = 2 d = False

so how to map network drive please