Beefy Boxes and Bandwidth Generously Provided by pair Networks
Just another Perl shrine
 
PerlMonks  

comment on

( [id://3333]=superdoc: print w/replies, xml ) Need Help??
Thats certainly an interesting predicement you're in ;-)

As far as ODBC goes -- in order to do ODBC from your *nix box over to Windows, I believe you will still need a "bridge" to get your there. There are tools that can help you with this, ranging from open source to commercial. You would use unixODBC or iodbc along with it. Check out: (I just searched for "odbc bridge" at freshmeat)

  • dbtcp (Open Source)
  • ODBC-ODBC Bridge (Commercial)

    Now, for FreeTDS. I haven't looked at that in some time.. but I heard a rumour some months ago that SQL Server 7.0 was the last version that it would work with, as MS is moving it away from functioning like Sybase. I'm sure digging through the FreeTDS website would clear that up, but it's something to consider. Even if it still works now.. as soon as MS changes it enough, it may never work again.

    Doing HTTP and XML is always fun, and you could always consider using Apache 2.0, which is supposed to work well on Windows. It's of course in beta now, but I've been hearing good reports about it.

    There are also two other interesting options you can look into. There is the ODBC Socket Server, which is a service which you run on your NT box. It's job is to expose ODBC resources via TCP/IP, making it very easy to access from non-windows platforms. I've never used it, but they claim that it's pretty fast.

    And lastly, you could always consider a middleware/application server product. That might be a bit much for what you're looking to do, but you never know. Anything from IBM's Websphere to the open source JBoss, there's a lot available.

    Good luck!
    -Eric

    In reply to Re: Connecting from *nix/Apache/mod_perl to SQL Server by andreychek
    in thread Connecting from *nix/Apache/mod_perl to SQL Server by jehuni

    Title:
    Use:  <p> text here (a paragraph) </p>
    and:  <code> code here </code>
    to format your post; it's "PerlMonks-approved HTML":



    • Are you posting in the right place? Check out Where do I post X? to know for sure.
    • Posts may use any of the Perl Monks Approved HTML tags. Currently these include the following:
      <code> <a> <b> <big> <blockquote> <br /> <dd> <dl> <dt> <em> <font> <h1> <h2> <h3> <h4> <h5> <h6> <hr /> <i> <li> <nbsp> <ol> <p> <small> <strike> <strong> <sub> <sup> <table> <td> <th> <tr> <tt> <u> <ul>
    • Snippets of code should be wrapped in <code> tags not <pre> tags. In fact, <pre> tags should generally be avoided. If they must be used, extreme care should be taken to ensure that their contents do not have long lines (<70 chars), in order to prevent horizontal scrolling (and possible janitor intervention).
    • Want more info? How to link or How to display code and escape characters are good places to start.
  • Log In?
    Username:
    Password:

    What's my password?
    Create A New User
    Domain Nodelet?
    Chatterbox?
    and the web crawler heard nothing...

    How do I use this?Last hourOther CB clients
    Other Users?
    Others goofing around in the Monastery: (3)
    As of 2024-03-29 15:45 GMT
    Sections?
    Information?
    Find Nodes?
    Leftovers?
      Voting Booth?

      No recent polls found