RE: [PHP-DB] Solaris/ODBC.

> -----Original Message----- > From: Rune Kallhovd [mailto:rka@corena.no] > Sent: Wednesday, May 31, 2000 11:38 AM > To: John Margaritsanakis > Cc: PHP/DB List > Subject: Re: [PHP-DB] Solaris/ODBC. > > > Hi John, > > Have you tried to switch the order of your odbc_connect args? > > e.g. $connection = odbc_connect("userid","passwd","machine_name") > > This should probably work :-) > > Nope. I'm afraid not -- I checked various things already anyway, but it's nothing as simple as this. In either case, the definition for odbc_connect() in the PHP manual is for int odbc_connect (string dsn, string user, string password [, int cursor_type]) . If it comes down to having ODBC drivers for Solaris, does anyone know where I can find them? Or otherwise, if that is not the problem, if someone who's had problems with connecting from Solaris to a MS SQL Server on NT, please let me know. > John Margaritsanakis wrote: > > > > Does anyone know the solution to this? It seems to be a > common enough > > thing to do, but I've looked around and can't find an obvious > way to resolve > > it. > > Basically, recently we decided to have our front-end handled by PHP > > scripts on Unix, and the databases themselves on NT on our SQL > server. I've > > already been using PHP for a while on msql and MySQL, so I > figured it was > > going to be pretty much easy. > > Thing is, $connection = odbc_connect("DSN=<machine > > name>","<userid>","<passwd>") doesn't return > > name>anything; it doesn't even > > return 0. The script reaches that and just dies an unfortunate > death. Even > > or die (...) won't return anything helpful. > > After looking around on the FAQs and tutorials, I assume my > problem is > > the lack of ODBC drivers for Solaris; if it's not, and someone > can propose a > > solution, please let me know. Otherwise, I've been looking > around for some > > Solaris drivers but all I can find is Sybase's, and there seems > to be some > > problem with their ftp site in the section I need. > > Thanks for any replies. > > /------------------------------------------------------------- | John Margaritsanakis, Programmer/Analyst | Istos Web Publishing Solutions and Services Agency |------------------------------------------------------------- | Crime doesn't pay as well as politics. |------------------------------------------------------------- | "And when we meet again my hand shall hold a Silmaril | from the Iron Crown; for you have not looked the last | upon Beren son of Barahir." The Silmarillion. \-------------------------------------------------------------