|
|
|||
| 330-676-0022 Call Us | |||
The population of 64-bit PCs has steadily increased since their mainstream introduction in 2003, and ENOVIA SmarTeam has supported the use of 64-bit machines since V5R18 SP1. However, saying that a client-server application supports 64-bit machines can mean a number of different things. Let’s take a closer look at how 64-bit Oracle is supported in an ENOVIA SmarTeam environment. Continue Reading
ENOVIA SmarTeam’s client-server architecture relies on several key connections for successful client operation. When one of these connections is blocked or otherwise unavailable, the client will be unable to login to SmarTeam. Fortunately, most client connection problems can be quickly identified. Read on to learn more about a few common issues and tips on resolving them. Continue Reading
If you’ve ever tried to pack up and move a SQL Server database from one computer to another, you’ve probably noticed that the permissions and users won’t line up between the two machines. Even if you create accounts with the same usernames on the target machine, the users from one SQL Server are not recognized by the other. As a result, you receive error messages like, ‘Login failed for user USERNAME’. Continue Reading
Part numbers, quotation numbers, item numbers, revisions, serial numbers…they’re all sequential values that need to be unique, and need to be tracked. In most cases (Design Automation, Product Data Management, CRM, etc.) this means the creation of a database table to hand out and track these identifying numbers and their related data. To ensure that the numbers are unique, most tables will be setup with a unique ID field that will automatically be populated by a database server. But what happens when your ID counter (automatic sequencer) needs to be reset? Continue Reading
Have you ever wanted to globally replace one value with another inside of a database? Have you ever wanted to globally alter string data, replacing one word with another in a database? If so, the SQL Replace statement could be just what you’re looking for! It allows you to search for one string within another and either remove the string or replace it with a different string. The Replace() statement is available for use on most major database management systems in use today, including Microsoft SQL Server and Oracle. Continue Reading
Microsoft Access is a wonderful thing. It looks, smells, and tastes like a comfortable Excel spreadsheet. But once you get past the wonderful interface, you find out that as databases go, Access really isn’t up to the power demanded by most applications. So when we go to create a supporting database for a design automation or we build a tracking database for our data management system, we want the ease-of-use of Access, but the power of something like Microsoft SQL Server. Continue Reading
Microsoft’s latest set of server operating systems has been out for a while now, and many are starting to adopt them as “mainstream”. Therefore, it is a good idea to take a look at server requirements if you are going to be purchasing SolidWorks Enterprise PDM (EPDM) or if you are going to be upgrading to the latest version of the software. Continue Reading
Article Feeds Blog Feeds 
Follow us on Twitter 
Fan Us
