Re: ADODB and using Workstation ID (odbc)
| From: | Marko | Date: | Wed, 24 Oct 2001 11:44:56 +0000 |
| Subject: | Re: ADODB and using Workstation ID (odbc) | ||
| References: | 1 | Groups: | php.windows |
| Request: | Send a blank email to php-windows+get-9991@lists.php.net to get a copy of this message | ||
"SøRen Nielsen" <news@n-crypt.dk> wrote in message
news:20011024072453.30621.qmail@pb1.pair.com...
> Can it be done with odbc ?
> I have tried and tried but nothing seems to work.
> Does anyone know if the Workstation ID can be set if i connect with odbc ?
>
> Best regards,
> Soeren Nielsen
>
I tried to do it at home (PWS and PHP4) and it worked. I used Windows' ODBC
administration tool to create an Access driven database. In php code i used
the following commands:
$db=odbc_connect("<DSN>","<username>","<password>");
followed by
$ersult=odbc_exec($db,"select * from........");
and it worked.
But, when i tried in school on win2k server, i got the following error on
odbc_connect():
Warning: SQL error: , SQL state 00000 in SQLConnect in
c:\inetpub\wwwroot\Ban\php\odbc.php on line 2
Can anyone help?