Hi, I have just upgraded from EG 8.1 to EG 8.2 when my connection to SQL database started to fuss. First, it does not load all tables, especially not the new once. Secondly, I lost the write/read and now I have just read access. Here is the code I use to set up the connection. libname mydata odbc noprompt="driver=ODBC Driver 17 for SQL Server; server=xxxxxxxxxx; Trusted_Connection=Yes; DATABASE=mydata;" read_lock_type=NOLOCK bcp=yes schema=dbo; So, a lot of tables seems to be missing and I cant write to the database any longer. Nota bene: With MS SQL Server Management studio I can see all tables and I can write to the database so it's nothing wrong there. I have googled a lot but can't find an answer to this problem. Please help me out. Best Regards Stefan Backlin
... View more