pcsoft.us.windevCopyright 2026, PC SOFT21 Mar 2020 13:31:50 Z10 Mar 2014 12:59:00 ZHi, I`m making a small import utility for one of my clients, but struggle with their choosen Schema name in MS-SQL (I`m using windev v18) I`m currently trying to connect to a MS-SQL Database that`s not using the default [dbo] schema, but [DataBridge]. So a table will bee in the form [database].[schema].[tablename] = [DataBridge].[DataBridge].[Transactions] 1. When trying to connect via the "Import existing table" in the analyze there is no place to specify SCHEMA and I get an error? 2. If I rename the schema on the server side to [dbo], I can import the table, but will I now hack up for the "main" app using the [DataBridge].[DataBridge].[Transactions] table? 3. My App is just an Import a XML file into Database i "Live" mode, and at clients sites there`s no SQL Management studio available so what to do? Can I change the schema in my connection name on the fly (Via code) to [DataBridge]? Cheers Tor-Bjarne30WEBDEVen_UShttps://forum.pcsoft.fr/en-US/pcsoft.us.windev/44881-windev-sql-not-using-dbo-schema/read.awpmoderateur@pcsoft.fr (The moderator)webmaster@pcsoft.fr (The webmaster)Meredith GUYpcsoft.us.windevhttps://forum.pcsoft.fr/en-US/pcsoft.us.windev/44881-windev-sql-not-using-dbo-schema-67705/read.awp21 Mar 2020 13:31:50 ZThanks very much indeed, Tor-Bjarne, for the very useful code you posted above! I had exactly the same situation with 3 differen…https://forum.pcsoft.fr/en-US/pcsoft.us.windev/44881-windev-sql-not-using-dbo-schema-67705/read.awphttps://forum.pcsoft.fr/en-US/pcsoft.us.windev/44881-windev-sql-not-using-dbo-schema-67705/read.awpWinDev MS SQL not using dbo SCHEMAguestpcsoft.us.windevhttps://forum.pcsoft.fr/en-US/pcsoft.us.windev/44881-windev-sql-not-using-dbo-schema-44986/read.awp14 Mar 2014 13:06:00 ZHi, Thanks Paulo and Peter J for your input :) Paulo, the hChangeName did the trick. Here`s how for future recerence: …https://forum.pcsoft.fr/en-US/pcsoft.us.windev/44881-windev-sql-not-using-dbo-schema-44986/read.awphttps://forum.pcsoft.fr/en-US/pcsoft.us.windev/44881-windev-sql-not-using-dbo-schema-44986/read.awpWinDev MS SQL not using dbo SCHEMAguestpcsoft.us.windevhttps://forum.pcsoft.fr/en-US/pcsoft.us.windev/44881-windev-sql-not-using-dbo-schema-44909/read.awp11 Mar 2014 12:38:00 ZI'm afraid I think you're going to be in for a bit of a renaming session. I had this before when using non-DBO tables, for some …https://forum.pcsoft.fr/en-US/pcsoft.us.windev/44881-windev-sql-not-using-dbo-schema-44909/read.awphttps://forum.pcsoft.fr/en-US/pcsoft.us.windev/44881-windev-sql-not-using-dbo-schema-44909/read.awpWinDev MS SQL not using dbo SCHEMAguestpcsoft.us.windevhttps://forum.pcsoft.fr/en-US/pcsoft.us.windev/44881-windev-sql-not-using-dbo-schema-44890/read.awp10 Mar 2014 17:25:00 ZI don't know if you are using OLEDB or native access but probably this note in the hchangename function can help you. http://…https://forum.pcsoft.fr/en-US/pcsoft.us.windev/44881-windev-sql-not-using-dbo-schema-44890/read.awphttps://forum.pcsoft.fr/en-US/pcsoft.us.windev/44881-windev-sql-not-using-dbo-schema-44890/read.awpWinDev MS SQL not using dbo SCHEMA