Norman, David (SAAS) wrote: > I know I'm probably going over old ground again, but > what's the present state of play for UniVerse on HP-UX > connecting to SQL Server on w2000/2003 to update tables ? > Do I need middleware ? If so, what is recommended ? > UV10.0.16 HP-UX 11
For U2 Linux users to do this, I'd suggest taking a look at using Mono connectivity for SQL Server (and other databases). It's free and Open Source. See: http://forge.novell.com/modules/xfmod/project/?sqlsharpgtk (Same code works in Windows by the way.) And maybe http://www.mono-project.com/SQLClient For HP-UX the options are a little more limited. David, I'm not sure if you require a direct UV/HP-UX connection into your SQL Server or if you'd consider an indirect approach with a middle-tier component in Windows that pulls data from one database and pushes to the other. If you buy a *nix ODBC client into SQL Server, you will have a single-purpose component, and your next project will require buying or building other tools. If you use a versatile tool for development, your chosen technology can be re-used for any number of projects. There are tools that can be used for writing components like this, including UniObjects, UO.NET, PDP.NET, and mv.NET. [ad] My company, Nebula R&D has entered into a Distribution agreement to provide mv.NET and related support and services to VARs and end-users. Specific to your purposes, ADO.NET is _the_ main form of connectivity with SQL Server today, and unlike the other connectivity products, mv.NET includes full ADO.NET support to easily move data to/from U2 and relational databases. It's an ideal tool to build the solution you're looking for, and this one tool is versatile enough to be used for many other projects that people discuss in this forum. An enterprising VAR might want to develop a connector from U2 to SQL Server (and/or other databases) using mv.NET. We'll help our VARs to develop and market their products. Based on the requests we see in this forum, there is certainly a market for this one, and if someone else doesn't develop this connector soon then I might take a stab at it. U2 professionals of Nebula Team1 are available to help with development projects, and we are now offering training for all levels of .NET and mv.NET development. For more info, see this page and related links: http://removethisNebula-RnD.com/products/mvdotnet/mvdotnet.htm We're re-organizing those pages and will add more content soon, please feel free to ask for more details, documentation, and free evaluation licenses. [/ad] I hope that helps! Tony Gravagno Nebula R&D TG@ removethisNebula-RnD.com ------- u2-users mailing list [email protected] To unsubscribe please visit http://listserver.u2ug.org/
