- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - OpenVMS
- >
- Re: Accessing SQLServer from VMS
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
тАО07-12-2004 04:01 AM
тАО07-12-2004 04:01 AM
Accessing SQLServer from VMS
We also have Oracle on VMS and I believe we can get a gateway from Oracle. But I didn't know if there were any other options available.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО07-12-2004 04:15 AM
тАО07-12-2004 04:15 AM
Re: Accessing SQLServer from VMS
Or could use jdbc from java?
Purely Personal Opinion
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО07-12-2004 04:58 AM
тАО07-12-2004 04:58 AM
Re: Accessing SQLServer from VMS
I have a preference for FreeTDS since I'm the one who ported it to VMS :-). See:
http://www.freetds.org
There is also a pure Java JDBC client:
http://jtds.sourceforge.net/
Providing more information about the specifics of "access a SQL Server database" would probably net you more concrete help about the relative advantages of the different solutions. I.e., are you just exporting data and don't need transactional control? Or do you need full programmatic access? If so, what language(s) are you using? Do you need to access Oracle, SQL Server, and RMS from within the same program? Do you need access from DCL?
Do you have the budget and authority to install a special driver on each of the target systems you want to access (something all the commercial solutions will require)?
The list could go on, but you get the idea.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО07-12-2004 05:35 AM
тАО07-12-2004 05:35 AM
Re: Accessing SQLServer from VMS
I looked at Easysoft but like you said it has a server side piece.
>I have a preference for FreeTDS since I'm >the one who ported it to VMS :-). See:
>http://www.freetds.org
I'll take a look at it.
>Providing more information about the >specifics of "access a SQL Server database" >would probably net you more concrete help >about the relative advantages of the >different solutions. I.e., are you just >exporting data and don't need transactional >control? Or do you need full programmatic >access? If so, what language(s) are you >using? Do you need to access Oracle, SQL >Server, and RMS from within the same >program? Do you need access from DCL?
The application is written in Fortran.
It would only need to access SQLserver.
The application is an interface to 3rd party product(Proficy). All it would be doing is
calling a stored procedure. Everything would be read only.
>Do you have the budget and authority to >install a special driver on each of the >target systems you want to access
>(something all the commercial solutions >will require)?
I could get the authority(and budget) but I'd prefer to keep this as a client side application only.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО07-12-2004 06:46 AM
тАО07-12-2004 06:46 AM
Re: Accessing SQLServer from VMS
In any case you'll likely be calling C routines from FORTRAN, so you'll need to sort out how you want to do that. You can null terminate your strings and pass by reference, or you can write a layer in C that accepts values by descriptor, copies them to C strings, and passes them to the database library. In your case the "layer" might be a single routine that handles all database interaction and returns a result. Or the layer could provide a jacket around each database call. Attunity provides something like the latter, I believe.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО07-12-2004 01:41 PM
тАО07-12-2004 01:41 PM
Re: Accessing SQLServer from VMS
depending on what you already have, you might be able to access SQL server using a Sybase client. For reference see
http://msdn.microsoft.com/archive/default.asp?url=/archive/en-us/dnarsqlsg/html/msdn_sqlintgr.asp
If I had to do it, I'd go the freetds route, but if you already have Sybase by chance it can be worth a look.
Greetings, Martin
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО07-13-2004 08:31 AM
тАО07-13-2004 08:31 AM
Re: Accessing SQLServer from VMS
With a number of pretty severe restrictions, yes, you can use the old, now-defunct Sybase clients to access MS SQL Server. If you have SQL Server before 7.0, you'll probably be fine. If you have SQL Server 7.0, you need, IIRC, SP2 since 7.0 as originally shipped accidentally broke compatibility with older versions of the TDS protocol. If you're using MS SQL 2000 or later, you're out of luck because these versions *intentionally* broke compatibility with older versions of the TDS protocol.
Under the limited circumstances in which the combination works, I believe you are limited to text and varchar fields with a maximum length of 255 characters.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО07-13-2004 08:35 AM
тАО07-13-2004 08:35 AM
Re: Accessing SQLServer from VMS
I downloaded FreeTDS and ran the configure.com But when I run MMS I got
the following error:
%MMS-F-GWKNOPRN, There are no known sources for the current target [.INCLUDE]TDS
_SYSDEP_PUBLIC.H_IN
Also the documentation refers to using SQSH
to test with but I didn't see a VMS version.
Is there something else I can test with?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО07-13-2004 10:21 AM
тАО07-13-2004 10:21 AM
Re: Accessing SQLServer from VMS
When you've got a successful build, edit pwd.in and freetds.conf in the top-level directory and run MMS CHECK to test. You'll also have a tsql.exe and freebcp.exe for interactive SQL and bulk copy operations, respectively. See [.doc]tsql.txt and [.doc]freebcp.txt for the documentation of these utilities.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО07-13-2004 10:53 AM
тАО07-13-2004 10:53 AM
Re: Accessing SQLServer from VMS
I did it a little different and maybe that
was the problem. I untared it on my PC
then zipped it up. Then I FTP'ed it to
VMS and created a directory.
MMS only gave that one error but didn't create and exe's.