I ran across these white papers on the forums and thought I’d host them here too. They cover configuration of SQL Server and migrating a project from SQLite to SQL Server.
Now that we have our SQL Server instance setup, we need to configure it for remote connections. Microsoft disables remote connections out of the box for security purposes. They don’t want people connecting to servers that were not intended to be available remotely. In our previous post, I displayed a network map showing that my […]
Today I’m going to do a series of posts on migrating to SQL Express. Future posts will cover installation and migration details, but today I wanted to lay some of the ground work for why you would need to move to SQL Express and some of the general implementation details. Database, what database? Behind […]
As many may know, there isn’t a way to change the project name via the UI. However, there is still a way. To get to where the data is stored, we will need some tools to open the SQLite database. If you are using SQL Server, you’ll have an easier time because you have […]
A couple small housekeeping updates to the ECAD database. The SQLMap table had an incorrect mapping for the Process Lines table. Also, the DatabaseECAD.tbl file incorrectly used the LINE_LIST_ field in the Process Lines sections instead of LINELIST_. A new version has been posted, and you may download it by going to your orders page.
With the help of Rod Abbott, we’ve been able to fix up the ECAD Database for CADWorx to run on 64-bit. For those of you who are curious, this is a compatibility issue we had to address. Incidentally, the code posted will fix the out of the box database for CADWorx too. #If VBA7 Then […]
I’m willing to bet many of you have never heard of this command. Well, it’s a dialog added in 2009 (I think). It allows you to assign an order number to the valves. In case you’re wondering (or have to use this in a query/report somewhere) the Order Number column uses the CW_RES_03_ field in […]
For the last couple weeks, I’ve been out of town training and checking into creating an installer for all of our products. We’ve decided to go ahead and release the database in the store so that you guys can start playing with it. Feel free to Contact Us if you run into any issues or […]
This week on the forums, Kather asked a question that piqued my curiosity. The question was, “Is there a way to globally turn off attributes in a drawing file.” I remembered that a while back a solution had been presented to filter out existing items in the plant database by Steven Hollinger. So, I wanted […]
We are proud to announce that the ECAD Database for CADWorx will be available in our store soon. We showed it briefly at CADWorx University 2010, and since then have gotten more features included. Download the feature walk through: The goal in creating this database was to add functionality that users request on a regular […]