RE: [PHP-DB] Driver for connecting SQL server

2001-10-01 Thread Andrew Hill 

Also, ensure that this is a System DSN.

Best regards,
Andrew Hill
Director of Technology Evangelism
OpenLink Software  http://www.openlinksw.com
Universal Data Access & Data Integration Technology Providers 

> -Original Message-
> From: Frank M. Kromann [mailto:[EMAIL PROTECTED]]
> Sent: Monday, October 01, 2001 2:44 PM
> To: LeTortorec, Jean-Louis
> Cc: '[EMAIL PROTECTED]'
> Subject: Re: [PHP-DB] Driver for connecting SQL server
> 
> 
> 
> 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
> > 
> 
> 
> 
> 
> -- 
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
> To contact the list administrators, e-mail: [EMAIL PROTECTED]
> 
> 

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

Re: [PHP-DB] Driver for connecting SQL server

2001-10-01 Thread Frank M. Kromann 


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
> 




-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

[PHP-DB] Driver for connecting SQL server

2001-10-01 Thread LeTortorec, Jean-Louis 

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