Connect to remote database with arcpy

Question

I'm trying to access a database located on a remote server.

I used ArcMap "Create Database Connection" tool on my computer to create a SDE file and I want to use a script to add some data to a table located on this remote database.

On the server SQLEXPRESS

there is a database called WeatherData (the SDE file is used to access this database)

and in this database there is a table called Weather1.

I'm currently using this script :

import os
import arcpy
from arcpy import env

directory = os.path.dirname(os.path.realpath(__file__))
arcpy.env.workspace = os.path.join(directory, "SqlServerConnect_UserAuthentication.sde")

table = "Weather1"
tableLocation = os.path.join(arcpy.env.workspace, table)

print arcpy.env.workspace
print tableLocation
print arcpy.ListTables()

arcpy.env.workspace and tableLocation are printed correctly, but arcpy.ListTables() print an empty list

C:\Users\...\ArcGISApp\SqlServerConnect_UserAuthentication.sde
C:\Users\...\ArcGISApp\SqlServerConnect_UserAuthentication.sde\Weather1
[]

which I guess means the script didn't find anything in the workspace. (or couldn't connect to it)

Afterwards, I just want to add some data to the table using another arcpy function

data = os.path.join(directory, "test.csv")
arcpy.Append_management (data, tableLocation, "NO_TEST")

Of course I get an error : (translated from french)

Traceback (most recent call last):
File "C:\Users\...\ArcGISApp\test.py", line 28, in <module>
arcpy.Append_management (data, tableLocation, "NO_TEST")
File "C:\Program Files (x86)\ArcGIS\Desktop10.2\arcpy\arcpy\management.py", line 3785, in Append
raise e
arcgisscripting.ExecuteError: Execution Error. Incorrect parameters
ERROR 000732: Dataset C:\Users\...\ArcGISApp\SqlServerConnect_UserAuthentication.sde
does not exist or is not supported
Execution Error(Append).

So how I am I supposed to use the SDE file to access the database (and the table) correctly ?

Answer 1

Ok so the error 732 was caused by the fact I inputted :

table = "Weather1"

when I should have used instead

table = "WeatherData.DBO.Weather1" (or at least "DBO.Weather1")

It then led to an error 229 which was caused by the fact that the user I used in the SDE file was able to access the database but couldn't see what was inside

When I changed the SDE file to one with another user with adequate rights it worked.