Hi,
I'm currently running our Intranet on a Solaris machine with PHP and MySQL. Everything works great.
Now I want to be able to connect to a MS SQL 7 (or 2000) database that is placed on another server in our network. I just need to be able to get some data from that machine on a non-regular basis.
Since I've concentrated on learning on using MySQl I'm a bit stumped here how to do this.
* I've figured out that I need to use some kind of ODBC-connection. Is OpenLink ODBC a good driver to compile and use in PHP?
* How exactly do I connect to this other MS SQL server? What is needed to be set up on this server. Is a System-DSN enough?
* I've read the php-manual but am still not sure what to do to connect to the remote server - where you put the name of the server, should I put the IP for the MS SQL server?
Yeah, I'm a bit clueless here and I've even read the article on this site (and some others site's articles) and I'm still a bit lost
.
Thanks for any help in advance!
/Bj鰎n Tidal
I'm currently running our Intranet on a Solaris machine with PHP and MySQL. Everything works great.
Now I want to be able to connect to a MS SQL 7 (or 2000) database that is placed on another server in our network. I just need to be able to get some data from that machine on a non-regular basis.
Since I've concentrated on learning on using MySQl I'm a bit stumped here how to do this.
* I've figured out that I need to use some kind of ODBC-connection. Is OpenLink ODBC a good driver to compile and use in PHP?
* How exactly do I connect to this other MS SQL server? What is needed to be set up on this server. Is a System-DSN enough?
* I've read the php-manual but am still not sure what to do to connect to the remote server - where you put the name of the server, should I put the IP for the MS SQL server?
Yeah, I'm a bit clueless here and I've even read the article on this site (and some others site's articles) and I'm still a bit lost
.Thanks for any help in advance!
/Bj鰎n Tidal