php-windows Digest 12 Jun 2002 19:39:01 -0000 Issue 1188
Topics (messages 14190 through 14196):
Re: PHP with Apache modules
14190 by: Brian Huff
Connecting to MS Access
14191 by: Bill Hudspeth
14193 by: Scott Hurring
14194 by: Michael Davey
14195 by: Scott Carr
could not load php_mssql.dll problem
14192 by: R.S. Herhuth
javascript in php
14196 by: prachi shroff
Administrivia:
To subscribe to the digest, e-mail:
[EMAIL PROTECTED]
To unsubscribe from the digest, e-mail:
[EMAIL PROTECTED]
To post to the list, e-mail:
[EMAIL PROTECTED]
----------------------------------------------------------------------
--- Begin Message ---
you should probably send the exact error message so we can be sure...
but Im betting that its complaining about build numbers being different.
You probably have incompatible versions of php4apache.dll and
php4ts.dll on your machine... or else one of the other dlls that you
load up (referenced in your php.ini file) is too old.
You'll have to check all files in your system path to make sure you
replaced all old dlls with the new ones. The error message should point
you to the name of the culprit, at least...
--
Brian 'Bex' Huff
[EMAIL PROTECTED]
Phone: 952-903-2023
Fax: 952-829-5424
> I just updated PHP to the latest version. When I start up Apache
> theres an error in php4acpache.dll or something. Says something that
> is attached to the system is not working.
>
> Also with the old version of PHP(4+) I cant get ImageCreateFromJPEG()
> to work.
>
> Cheers
>
> -sean
--- End Message ---
--- Begin Message ---
I am having problems connecting to an Access database. I am using Windows
2000, IIS 4, Access 2000, and PHP 4.2.1. I have created a system DSN using
the Access (.mdb) driver, and have a username and password. What's going
on?? Thanks, Bill
The code I have used is as follows:
************************************************************************
<?php
//connect to database
$connectionstring = odbc_connect("meteoritecatalog", "username",
"password");
//line 14 is immediately above
//SQL Query
$query = "SELECT sample, type FROM sample";
//execute query
$queryexe = odbc_do($connectionstring, $query);
//line 20 above
//output results to standard output
odbc_result_all($queryexe, "BORDER=1");
//line 23 above
//disconnect from the database
odbc_close($connectionstring);
//line 26 above
?>
************************************************************************
The error message I get is:
Warning: SQL error: [Microsoft][ODBC Microsoft Access Driver]General error
Not enough information to connect to this DSN with SQLConnect. Use
SQLDriverConnect., SQL state S1000 in SQLConnect in
C:\inetpub\wwwroot\PHP\data_tap.php on line 14
Warning: odbc_do(): supplied argument is not a valid ODBC-Link resource in
C:\inetpub\wwwroot\PHP\data_tap.php on line 20
Warning: odbc_result_all(): supplied argument is not a valid ODBC result
resource in C:\inetpub\wwwroot\PHP\data_tap.php on line 23
Warning: odbc_close(): supplied argument is not a valid ODBC-Link resource
in C:\inetpub\wwwroot\PHP\data_tap.php on line 26
--- End Message ---
--- Begin Message ---
All of your errors stem from the first error. You do not have
a valid connection resource -- so when you try and run queries
and functions, they fail, saying that there's no valid ODBC
source.
I've not used Access in the past, so i can't say what specific
information it's looking for, but go over the documentation
again, and try to look for code examples.
** And always check your status vars **
--
Scott Hurring
Systems Programmer
EAC Corporation
scott (*) eac.com
--
"Bill Hudspeth" <[EMAIL PROTECTED]> wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> I am having problems connecting to an Access database. I am using Windows
> 2000, IIS 4, Access 2000, and PHP 4.2.1. I have created a system DSN using
> the Access (.mdb) driver, and have a username and password. What's going
> on?? Thanks, Bill
>
>
>
> The code I have used is as follows:
>
>
>
> ************************************************************************
>
>
>
> <?php
>
>
>
> //connect to database
>
> $connectionstring = odbc_connect("meteoritecatalog", "username",
> "password");
>
> //line 14 is immediately above
>
>
>
> //SQL Query
>
> $query = "SELECT sample, type FROM sample";
>
>
>
> //execute query
>
> $queryexe = odbc_do($connectionstring, $query);
>
> //line 20 above
>
>
>
> //output results to standard output
>
> odbc_result_all($queryexe, "BORDER=1");
>
> //line 23 above
>
>
>
> //disconnect from the database
>
> odbc_close($connectionstring);
>
> //line 26 above
>
>
>
> ?>
>
>
>
> ************************************************************************
>
> The error message I get is:
>
>
>
> Warning: SQL error: [Microsoft][ODBC Microsoft Access Driver]General error
> Not enough information to connect to this DSN with SQLConnect. Use
> SQLDriverConnect., SQL state S1000 in SQLConnect in
> C:\inetpub\wwwroot\PHP\data_tap.php on line 14
>
> Warning: odbc_do(): supplied argument is not a valid ODBC-Link resource in
> C:\inetpub\wwwroot\PHP\data_tap.php on line 20
>
> Warning: odbc_result_all(): supplied argument is not a valid ODBC result
> resource in C:\inetpub\wwwroot\PHP\data_tap.php on line 23
>
> Warning: odbc_close(): supplied argument is not a valid ODBC-Link resource
> in C:\inetpub\wwwroot\PHP\data_tap.php on line 26
>
>
>
>
>
>
>
--- End Message ---
--- Begin Message ---
I have had to use an Access database once with ODBC and found that it was
very picky about the username that you used to login - the only one I found
that actually worked was Admin - YMMV...
Mikey
> -----Original Message-----
> From: Scott Hurring [mailto:[EMAIL PROTECTED]]
> Sent: 12 June 2002 19:26
> To: [EMAIL PROTECTED]
> Subject: [PHP-WIN] Re: Connecting to MS Access
>
>
> All of your errors stem from the first error. You do not have
> a valid connection resource -- so when you try and run queries
> and functions, they fail, saying that there's no valid ODBC
> source.
>
> I've not used Access in the past, so i can't say what specific
> information it's looking for, but go over the documentation
> again, and try to look for code examples.
>
> ** And always check your status vars **
>
> --
> Scott Hurring
> Systems Programmer
> EAC Corporation
> scott (*) eac.com
> --
> "Bill Hudspeth" <[EMAIL PROTECTED]> wrote in message
> [EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> > I am having problems connecting to an Access database. I am
> using Windows
> > 2000, IIS 4, Access 2000, and PHP 4.2.1. I have created a
> system DSN using
> > the Access (.mdb) driver, and have a username and password. What's going
> > on?? Thanks, Bill
> >
> >
> >
> > The code I have used is as follows:
> >
> >
> >
> > ************************************************************************
> >
> >
> >
> > <?php
> >
> >
> >
> > //connect to database
> >
> > $connectionstring = odbc_connect("meteoritecatalog", "username",
> > "password");
> >
> > //line 14 is immediately above
> >
> >
> >
> > //SQL Query
> >
> > $query = "SELECT sample, type FROM sample";
> >
> >
> >
> > //execute query
> >
> > $queryexe = odbc_do($connectionstring, $query);
> >
> > //line 20 above
> >
> >
> >
> > //output results to standard output
> >
> > odbc_result_all($queryexe, "BORDER=1");
> >
> > //line 23 above
> >
> >
> >
> > //disconnect from the database
> >
> > odbc_close($connectionstring);
> >
> > //line 26 above
> >
> >
> >
> > ?>
> >
> >
> >
> > ************************************************************************
> >
> > The error message I get is:
> >
> >
> >
> > Warning: SQL error: [Microsoft][ODBC Microsoft Access
> Driver]General error
> > Not enough information to connect to this DSN with SQLConnect. Use
> > SQLDriverConnect., SQL state S1000 in SQLConnect in
> > C:\inetpub\wwwroot\PHP\data_tap.php on line 14
> >
> > Warning: odbc_do(): supplied argument is not a valid ODBC-Link
> resource in
> > C:\inetpub\wwwroot\PHP\data_tap.php on line 20
> >
> > Warning: odbc_result_all(): supplied argument is not a valid ODBC result
> > resource in C:\inetpub\wwwroot\PHP\data_tap.php on line 23
> >
> > Warning: odbc_close(): supplied argument is not a valid
> ODBC-Link resource
> > in C:\inetpub\wwwroot\PHP\data_tap.php on line 26
> >
> >
> >
> >
> >
> >
> >
>
>
>
> --
> PHP Windows Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
>
>
--- End Message ---
--- Begin Message ---
Try username="admin", password="".
Most databases start off with those u and p settings.
--
Scott Carr
OpenOffice.org
Whiteboard-Doc Maintainer
http://whiteboard.openoffice.org/doc/
Quoting Bill Hudspeth <[EMAIL PROTECTED]>:
> I am having problems connecting to an Access database. I am using Windows
> 2000, IIS 4, Access 2000, and PHP 4.2.1. I have created a system DSN using
> the Access (.mdb) driver, and have a username and password. What's going
> on?? Thanks, Bill
>
>
>
> The code I have used is as follows:
>
>
>
> ************************************************************************
>
>
>
> <?php
>
>
>
> //connect to database
>
> $connectionstring = odbc_connect("meteoritecatalog", "username",
> "password");
>
> //line 14 is immediately above
>
>
>
> //SQL Query
>
> $query = "SELECT sample, type FROM sample";
>
>
>
> //execute query
>
> $queryexe = odbc_do($connectionstring, $query);
>
> //line 20 above
>
>
>
> //output results to standard output
>
> odbc_result_all($queryexe, "BORDER=1");
>
> //line 23 above
>
>
>
> //disconnect from the database
>
> odbc_close($connectionstring);
>
> //line 26 above
>
>
>
> ?>
>
>
>
> ************************************************************************
>
> The error message I get is:
>
>
>
> Warning: SQL error: [Microsoft][ODBC Microsoft Access Driver]General error
> Not enough information to connect to this DSN with SQLConnect. Use
> SQLDriverConnect., SQL state S1000 in SQLConnect in
> C:\inetpub\wwwroot\PHP\data_tap.php on line 14
>
> Warning: odbc_do(): supplied argument is not a valid ODBC-Link resource in
> C:\inetpub\wwwroot\PHP\data_tap.php on line 20
>
> Warning: odbc_result_all(): supplied argument is not a valid ODBC result
> resource in C:\inetpub\wwwroot\PHP\data_tap.php on line 23
>
> Warning: odbc_close(): supplied argument is not a valid ODBC-Link resource
> in C:\inetpub\wwwroot\PHP\data_tap.php on line 26
>
>
>
>
>
>
>
>
> --
> PHP Windows Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
>
-------------------------------------------------
This mail sent through IMP: http://horde.org/imp/
--- End Message ---
--- Begin Message ---
I installed the latest version of php on a Windows NT box running IIS.
Everything is fine but when I elect to autoload the php_mssql.dll I get
a "Could not load php_mssql.dll ...Could not be found" error. I
quadruple checked the the path and that is fine. Several other of the
modules that are in the same directory are loading correctly it just
seems to be the mssql one.
I have successfully setup 3 other Windows 2000/IIS configurations
without any problems.
What things should I check for??
Thanks,
Ron
--- End Message ---
--- Begin Message ---
Hi!
I have this HTML form and its validation done in javascript. All this HTML and
Javascript inside echo""; in a PHP code. The Form loads fine and the validation also
works fine when the HTML and javascript are used independently as an HTML page. But
when put in PHP, the form is ok, but the validation simply does not work....it is
totally ignored.
Does someone know why this would happen?
thanks,
Prachi.
---------------------------------
Do You Yahoo!?
Sign-up for Video Highlights of 2002 FIFA World Cup
--- End Message ---
