Linux PDM software

Our VAR is checking if we could run DBWorks in our Linux server. I'll let you know what they come up with.

Hi,

A customer is running his DBWorks on a Linux Server (Suse) with Oracle Database !

It work very well !

Regards

e-Systems

Nicolas Rubin

Application Engineer

SolidWorks VAR

"Count Zero" a écrit dans le message de news:

Hi,

A customer is running his DBWorks on a Linux Server (Suse) with Oracle Database !

It work very well !

Regards

e-Systems

Nicolas Rubin

Application Engineer

SolidWorks VAR

"Count Zero" a écrit dans le message de news:

Hi, A customer is running his DBWorks on a Linux Server (Suse) with Oracle Database ! It work very well ! Regards

e-Systems VAR SolidWorks Nicolas Rubin Application Engineer

"Count Zero" a écrit dans le message de news:

Phil,

I may be installing DBWorks on a clent's Liniux sever in the near future.

I am also waiting for DBWorks to support MySQL (So my client's don't have to use Access, MSDE, MS SQL, or Oracle).

I've provided a snippet of the email correspondance I got back in June regarding this issue.

"Apparently MySQL is not robust enough yet to handle the DBWorks data, they are missing two key features, before MechWorks would consider adding support for MySQL Database, the two items are Full support for subqueries and Support for Views.

The good news, MySQL is adding these features in version 5.1, the bad news, they do not publish any estimates of when the enhancements will be added and the current production release is 4.0, 4.1 is in Alpha testing and Version 5.0 is available for testing of new features for applications, the later two versions are not supported in a production environment"

I haven't had time to look into what MySQL version is available as of today.

This would negate the need to buy a MS SQL server license. In the meantime you could start to use MS access or MSDE (a free MS limited version of MS SQL).

Since you can upsize and downsize the database pretty easy you may want to start with MSDE as an interm fix prior to MechWorks supporting MySQL.

Could you please forward any further information you find about MySQL with respect to the missing functions.

Hope this helps.

Len K. Mar, PEng. E-data Solutions

Cheers Len, I am awaiting a reply from Smarteam also as we will be adding Catia v5 to our CAD stable soon due to OEM pressure and as you know Smarteam is tailored to handle both CAD systems.

In MySQL, the OLEDB provider driver is buggy, so your only option currently is the ODBC driver which will cause a performance issue.

Perhaps this will also change in future releases.

Best Regards,

-- Bob Hanson Centare Group, Ltd. - Custom Software and Systems Integration Specialists

So why not use PostgreSQL? It is widely used on linux as well and has many high-end features that MySQL currently lacks, such as support for views and subqueries.

Tron

Len K. Mar wrote:

Tron,

Thanks for the info. Just starting out on the Linux path and am at the bottom of the learning curve. (Any steeper and I'll be lying on my back ;)

Len