- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - OpenVMS
- >
- Re: VMS and MSSQL
Categories
Company
Local Language
Forums
Discussions
Forums
- Data Protection and Retention
- Entry Storage Systems
- Legacy
- Midrange and Enterprise Storage
- Storage Networking
- HPE Nimble Storage
Discussions
Discussions
Discussions
Forums
Forums
Discussions
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
- BladeSystem Infrastructure and Application Solutions
- Appliance Servers
- Alpha Servers
- BackOffice Products
- Internet Products
- HPE 9000 and HPE e3000 Servers
- Networking
- Netservers
- Secure OS Software for Linux
- Server Management (Insight Manager 7)
- Windows Server 2003
- Operating System - Tru64 Unix
- ProLiant Deployment and Provisioning
- Linux-Based Community / Regional
- Microsoft System Center Integration
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Community
Resources
Forums
Blogs
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО04-07-2009 05:30 AM
тАО04-07-2009 05:30 AM
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО04-07-2009 05:50 AM
тАО04-07-2009 05:50 AM
Re: VMS and MSSQL
Some details and options:
http://labs.hoffmanlabs.com/node/668
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО04-07-2009 12:32 PM
тАО04-07-2009 12:32 PM
Solution- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО12-23-2009 11:18 AM
тАО12-23-2009 11:18 AM
Re: VMS and MSSQL
Craig's post (and his notes in the FreeTDS bits) only reference Alpha (and VAX as a possibility) but there was no mention of I64. Was that a warning sign?
Nope! I fetched the kit on a PC, un-gzipped it with WinZip, copied the unzipped tar file to VMS, used vmstar (with the /ODS2 switch as they say!) to unpack the sources, ran the configure, and built it on my I64 v8.3 system.
$ vmstar /ods2 freetds-stable.tar
$ @[.vms]configure
$ mms /macro=("MSDBLIB"=1,"TDSVER"="TDS80")
I did bump into a compile quirk, but it was documented in the source, and the required change was very simple; as well, Craig reviewed the latest sources (not yet "stable") and notes this has been fixed.
The samples are quite complete, and some are even easy to read. (Look at the BSQLDB.C file, for example...)
Now instead of doing all sorts of hokey message transfer and relaying to get the data from our VMS box into an MS-SQL database, we just... log in, connect up, and do the insert directly. A think of beauty.
Kudos to Craig and Hoff, and everybody else who documents their struggles and successes.
Much obliged!
\john
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО12-28-2009 12:16 PM
тАО12-28-2009 12:16 PM
Re: VMS and MSSQL
>Craig's post (and his notes in the FreeTDS bits) only reference Alpha
>(and VAX as a possibility) but there
>was no mention of I64. Was that a warning sign?
It's just a side effect of the fact that when I wrote those notes five years ago, Itanium was (for me) still just a rumor on the horizon. As of a month ago, I'm using FreeTDS on Itanium in production. Thanks for the success report. Looks like I need to update those notes.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО12-28-2009 12:56 PM
тАО12-28-2009 12:56 PM