pcsoft.us.windevCopyright 2026, PC SOFT28 Feb 2020 06:15:17 Z14 Jan 2008 00:41:09 ZAfter much troubleshooting and continued failure linking to a MS SQL 2000 table via OLEDB, I have uncovered the issue--I just don't know what to do about it. The tables that I am interested in fall under a different schema than the default 'dbo' schema. This is preventing me from accessing the data. I won't be able to change the schema due to other business constraints. Does WinDev provide a way via OLEDB to add a table in a database under a different schema?30WEBDEVen_UShttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/11853-accessing-sql-table-different-schema-than-dbo/read.awpmoderateur@pcsoft.fr (El moderador)webmaster@pcsoft.fr (El webmaster)guy.meredithpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/11853-accessing-sql-table-different-schema-than-dbo-67661/read.awp28 Feb 2020 06:15:17 ZI tried various connections (except for the PC Soft Native Access Sql Server) to try and import into my Analysis the tables from…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/11853-accessing-sql-table-different-schema-than-dbo-67661/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/11853-accessing-sql-table-different-schema-than-dbo-67661/read.awpAccessing MS SQL table in different schema than dbosyed.alampcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/11853-accessing-sql-table-different-schema-than-dbo-47474/read.awp9 Aug 2014 21:53:42 ZFor SQL Server you can create a SYNONYM for the table within the SQL Server and then Windev will import the struct/data. for so…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/11853-accessing-sql-table-different-schema-than-dbo-47474/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/11853-accessing-sql-table-different-schema-than-dbo-47474/read.awpAccessing MS SQL table in different schema than dboolivierpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/11853-accessing-sql-table-different-schema-than-dbo-11911/read.awp17 Jan 2008 17:05:50 ZHello, I don't use it but as fer as I know 'dbo' is related to the owner of an objet under MS SQL. You can use tables with o…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/11853-accessing-sql-table-different-schema-than-dbo-11911/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/11853-accessing-sql-table-different-schema-than-dbo-11911/read.awpAccessing MS SQL table in different schema than dboguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/11853-accessing-sql-table-different-schema-than-dbo-11855/read.awp14 Jan 2008 11:51:54 ZI don't know much about MS SQL, but using Oracle, I can access any schema the user I logged in with has access rights to. I have…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/11853-accessing-sql-table-different-schema-than-dbo-11855/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/11853-accessing-sql-table-different-schema-than-dbo-11855/read.awpAccessing MS SQL table in different schema than dbo