Re: Driver for connecting SQL server
| From: | Frank M. Kromann | Date: | Mon, 01 Oct 2001 18:43:32 +0000 |
| Subject: | Re: Driver for connecting SQL server | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-12885@lists.php.net to get a copy of this message | ||
Hi
Try to remobe 'DNS=' from the connect
$conn=odbc_connect("dnsname","userid","password");
should do the trick.
- Frank
> Hi:
>
> I'm trying to establish a connection with SQL 7.0.
>
> My system runs W2000, Apache, PHP4. I created a DNS odbc file (with MS
> Access) and checked that the connection can be established.
>
> Then, my php script is as follow:
> $conn=odbc_connect("DNS=dnsname","userid","password");
>
> When I execute the script, I get the following error message:
>
> Warning: SQL error: [Microsoft][ODBC Driver Manager] Data source name not
> found and no default driver specified, SQL state IM002 in SQLConnect in
> c:\apache\intranet\default.php on line 6.
>
> How can I specify the missing driver? Should I install something?
>
>
> Thanks for your help.
>
> JL
>