Hi ,
I’m looking for driver that let you to connect to Microsoft SQL Server.
Please help me.
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
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-----
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.
-----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-----
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
I found this
MSSQL support in PHPI wil try it.