Results 1 to 1 of 1

Thread: Cannot create new sql table with .int suffix (bug) in 19.0

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. #1

    Default Cannot create new sql table with .int suffix (bug) in 19.0

    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
    Attached Thumbnails Attached Thumbnails Click image for larger version. 

Name:	Screenshot 2018-01-25 14.57.10.png 
Views:	84 
Size:	74.8 KB 
ID:	11664  

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •