Results 1 to 6 of 6

Thread: Connecting to Microsoft SQL Server

  1. #1

    Default Connecting to Microsoft SQL Server

    Hi ,

    I'm looking for driver that let you to connect to Microsoft SQL Server.
    Please help me.

  2. #2
    ab NNTP User

    Default Re: Connecting to Microsoft SQL Server

    -----BEGIN PGP SIGNED MESSAGE-----
    Hash: SHA1

    http://jtds.sourceforge.net/

    Good luck.
    -----BEGIN PGP SIGNATURE-----
    Version: GnuPG v2.0.19 (GNU/Linux)
    Comment: Using GnuPG with Mozilla - http://www.enigmail.net/

    iQIcBAEBAgAGBQJQiblaAAoJEF+XTK08PnB5raUQAJM6eK5HJbzXWtRyFdpGN6dA
    CCBU7WwynTAuTAhCRkYP4lsNT0lw+BGAAPsGlOzqPArtZwYKUgcuzzPZpQvlnrzE
    73QE2szoSRZS+xEAJMPVTYyL/Y33BQaqGpAnl1Pxjzou5vWZ+3qB7TT1OQ/wZMFW
    9QSuQek7CbTENEcHA9fKZp6DEkxAWZ0LV0NxiMi7sHStNCLyr+h96lu4Y1q0qAtf
    1+0cirhj7LjOOczLfvLPjjrkv+CcLCzV8DTNnuVv2ywLbS34tkA6mEAAf0JmncSJ
    2dMc2mYy9g8iWJ89GMsQgpjnG63JH2aHKmnUsSZsrkaHePYe1MOnCGrVO9/j14nc
    6XROsmYlIs2wCBn6jslzn9ECbQv4u53uaOQpwv//uce3lfn9Hvbnt14DtWkjBJ/q
    q/4cBdOHu/uGt18HDYSZa4NsFWuM1+S8AeWxRZyQ6GjK7fJ+BkIHuSc6FcWX3fZ5
    M1IYlgpQM2gfk5pMMTnEKHVeQVMGv8kpqkA565qQ5/ymd4Hvsp7CQ+63eyh5zVYS
    PXANy7mVAnTduIcA+DLHPADSJPZG4qjf8eAJFgutTgpp5JsUGxK9ry098htyvPGr
    7n86SouYRyZt1bI/M/kCljDi+9XtcD+9H0K40uLBuWRbmdBB0iOueGkUQJ0AQ78l
    jEaw+6+okrCXA6Gn420f
    =gbK4
    -----END PGP SIGNATURE-----

  3. #3

    Default Re: Connecting to Microsoft SQL Server

    Thank you.
    jTDS is a java (JDBC).
    We are using PHP. I tyed FreeTDS.org but no success.
    I found this ODBC, JDBC and XML Driver Downloads for Windows, Unix, Linux and Mac OS X but it's a commercial.

    Regards,

    Alex.


    Quote Originally Posted by ab View Post
    -----BEGIN PGP SIGNED MESSAGE-----
    Hash: SHA1

    jTDS JDBC Driver

    Good luck.
    -----BEGIN PGP SIGNATURE-----
    Version: GnuPG v2.0.19 (GNU/Linux)
    Comment: Using GnuPG with Mozilla - Enigmail: A simple interface for OpenPGP email security

    iQIcBAEBAgAGBQJQiblaAAoJEF+XTK08PnB5raUQAJM6eK5HJbzXWtRyFdpGN6dA
    CCBU7WwynTAuTAhCRkYP4lsNT0lw+BGAAPsGlOzqPArtZwYKUgcuzzPZpQvlnrzE
    73QE2szoSRZS+xEAJMPVTYyL/Y33BQaqGpAnl1Pxjzou5vWZ+3qB7TT1OQ/wZMFW
    9QSuQek7CbTENEcHA9fKZp6DEkxAWZ0LV0NxiMi7sHStNCLyr+h96lu4Y1q0qAtf
    1+0cirhj7LjOOczLfvLPjjrkv+CcLCzV8DTNnuVv2ywLbS34tkA6mEAAf0JmncSJ
    2dMc2mYy9g8iWJ89GMsQgpjnG63JH2aHKmnUsSZsrkaHePYe1MOnCGrVO9/j14nc
    6XROsmYlIs2wCBn6jslzn9ECbQv4u53uaOQpwv//uce3lfn9Hvbnt14DtWkjBJ/q
    q/4cBdOHu/uGt18HDYSZa4NsFWuM1+S8AeWxRZyQ6GjK7fJ+BkIHuSc6FcWX3fZ5
    M1IYlgpQM2gfk5pMMTnEKHVeQVMGv8kpqkA565qQ5/ymd4Hvsp7CQ+63eyh5zVYS
    PXANy7mVAnTduIcA+DLHPADSJPZG4qjf8eAJFgutTgpp5JsUGxK9ry098htyvPGr
    7n86SouYRyZt1bI/M/kCljDi+9XtcD+9H0K40uLBuWRbmdBB0iOueGkUQJ0AQ78l
    jEaw+6+okrCXA6Gn420f
    =gbK4
    -----END PGP SIGNATURE-----

  4. #4
    ab NNTP User

    Default Re: Connecting to Microsoft SQL Server

    -----BEGIN PGP SIGNED MESSAGE-----
    Hash: SHA1

    > jTDS is a java (JDBC).


    Indeed, and it works well to give you a driver to mssql.

    > We are using PHP.


    That's a good detail to include.

    I tyed 'FreeTDS.org' (http://www.freetds.org/) but
    > no success.


    Apparently, but how specifically? No success as in you had a PHP error?
    No success as in you could not do certain queries? You did not get
    authenticated?

    It would help if you shared what did work in your system... for example,
    if you're a PHP guru, include that so we don't try to help you with
    syntax issue. If you're a database master (despite using mssql) let us
    know, so we can assume you've checked that side's logs and can confirm
    that you're not even getting a connection attempt from your PHP script.
    It other tools (DB Visualizer is my personal favorite) work to connect
    from this openSUSE box to your mssql database, let us know that too so
    we rule out networking/credential issues. Post logs from Apache, or
    directly from PHP if you can get them. Include your code used for the
    connection for comparison.

    Good luck.
    -----BEGIN PGP SIGNATURE-----
    Version: GnuPG v2.0.19 (GNU/Linux)
    Comment: Using GnuPG with Mozilla - http://www.enigmail.net/

    iQIcBAEBAgAGBQJQiqXgAAoJEF+XTK08PnB5FdwP/jFRckSaUjxcUP/BCAKOL/LH
    MaC3+Q2JZshR3QbjBxTjG0S+MAVvG8GKDE7ebWyvfH4ulmxrdihNvyL1o+c/haO3
    V6xQAa8mdGQH2rpuHl+YUn6f1SU6MoxA0+GVM7A5kQ8s/HEL9gGtCXFGbhYue25/
    u0tFdoJVSMcidllAUEHGb1RjmELqYRgcW7N77/tpO82YFhxuuSFrQrrID2gn3I03
    TY/8Dqmk0RevJFB8Mv+ebgi2J218dGY89nrtuz6ATJxK1LbZ/iXRfoEc1TB18v95
    nsPCZme1h4dFuSIMuH5lfCaxdsU4J71Is8eM2kGQE1FyGyrqrEpb2XRv5lOEdxfe
    nWls1MXPHwKsOSqd3gbez7BA9Z6Xv3KIr3s3Rm5qB+FI875ZyKBXGvLSem0zkuBi
    A5rvWDnS8cJH1npnJ8cw+WgBR+l5UCYxiFf6MfkWIcWe53bExZ8oFSSbaC7ArmEb
    porDrnyXeXmRY9rpXCkd3Sw9dvrnXYYoiF/w9Q5+YvYrmB2C29tllqvdOUoZRczA
    7caM5425VQudcCOqTDbcvA+8dHazsOc1EmXz08mTUH5J5TUGBA7kW0javdzFoL5I
    Zg3HAASIGO8aIJjQbDbDY+EXsvXjGIpRd7nZGVjoqNLSwTd8S2mAcu2V5KZo8iVw
    5KTdqUgLBqpGYz0PMv/8
    =HENL
    -----END PGP SIGNATURE-----

  5. #5
    Join Date
    Jun 2008
    Location
    San Diego, Ca, USA
    Posts
    10,956
    Blog Entries
    2

    Default Re: Connecting to Microsoft SQL Server

    I've found that php.net is usually the place to find generic PHP "How To"
    Do read the pages at php.net, for instance this page describes some structural issues to be aware of that likely has nothing to do with whether a driver works
    PHP: Mssql - Manual

    Also, looks like there is a MS SQL driver already offered in the OSS called "php5-mssql"
    I haven't used it but since it's from Arch Linux I assume there should be decent documentation and likely is the "latest, stable" driver.


    TSU

  6. #6

    Default Re: Connecting to Microsoft SQL Server

    I found this
    MSSQL support in PHP

    I wil try it.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •