Hi,
First new table I am creating in 19.0 in Managed SQL.
I want to create a table with TABLENAME.INT instead of having the MSSQLDRV:TABLENAME format and I get the attached error which wrongly tells me that I did not add the .int at the of the root name and it does not let me go through.
So what I did was to create it with the prefix anyway and then in DBBuilder I chose to remove database indentification and the I chose to add database identification to add the .int
I did try this on two computers and also on the WebOrder workspace.
Also, it will be nice if we could create the table without Managed SQL... what I did was to edit the int file afterwards. The reason that I need the .int and I need the whole connection string instead of an ID is that it is needed by the db update program that I use to update the client databases. At least until I get around to update that program to work with Managed SQL connections.
Regards,
Oscar