RE: [PHP-DB] help connecting to ODBC
| From: | Andrew Hill | Date: | Fri, 19 Oct 2001 19:42:09 +0000 |
| Subject: | RE: [PHP-DB] help connecting to ODBC | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-13548@lists.php.net to get a copy of this message | ||
Anthony,
Then enable ODBC tracing in the ODBC Administrator and see where the calls
are failing.
Or try a different ODBC driver - you can download free ones from our site
for most databases.
Best regards,
Andrew Hill
Director of Technology Evangelism
OpenLink Software http://www.openlinksw.com
Universal Data Access & Data Integration Technology Providers
> -----Original Message-----
> From: Anthony [mailto:atampone@attechcomputer.com]
> Sent: Friday, October 19, 2001 1:21 PM
> To: php-db@lists.php.net
> Subject: Re: [PHP-DB] help connecting to ODBC
>
>
> yes, I can use the source from other programs. The source is a System
> DSN, based on a file DSN for the driver. The I_USR_<servername> user
> has the correct access rights to the files being accessed and to the
> file DSN driver.
>
>
> Andrew Hill wrote:
>
> > Anthony,
> >
> > Is the DSN usable from the ODBC Administrator control panel?
> > E.g. test it there first. Also, you mention File DSNs? PHP
> can only use
> > System DSNs on Windows, AFAIK.
> >
> > Best regards,
> > Andrew Hill
> > Director of Technology Evangelism
> > OpenLink Software http://www.openlinksw.com
> > Universal Data Access & Data Integration Technology Providers
> >
> >
> >>-----Original Message-----
> >>From: Anthony [mailto:atampone@attechcomputer.com]
> >>Sent: Friday, October 19, 2001 1:01 PM
> >>To: php-db@lists.php.net
> >>Subject: [PHP-DB] help connecting to ODBC
> >>
> >>
> >>I can't connect to an ODBC data source. I have done this before many
> >>times. I am now trying to connect to a new driver for new data. This
> >>is the first time I have tried to access a file DSN. I have the driver
> >>setup as a system DSN on win2k and IIS 5. PHP 4.06. when I attempt to
> >>connect to the data source I get "SQL error: , SQL state S1000 in
> >>SQLConnect". What does this mean? does anyone know where I can get a
> >>list of SQL errors and their meaning? Thanks to anyone that can lend
> >>their thoughts.
> >>
> >>- Anthony
> >>
> >>
> >>--
> >>PHP Database Mailing List (http://www.php.net/)
> >>To unsubscribe, e-mail: php-db-unsubscribe@lists.php.net
> >>For additional commands, e-mail: php-db-help@lists.php.net
> >>To contact the list administrators, e-mail: php-list-admin@lists.php.net
> >>
> >>
> >>
> >>
> >
> >
>
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, e-mail: php-db-unsubscribe@lists.php.net
> For additional commands, e-mail: php-db-help@lists.php.net
> To contact the list administrators, e-mail: php-list-admin@lists.php.net
>
>
>