php-windows Digest 6 Feb 2002 09:04:43 -0000 Issue 988
Topics (messages 11855 through 11860):
Re: Embeded MySQL
11855 by: alain samoun
11857 by: Josh Seward
Re: Crystal Reports and COM
11856 by: Nicole Amashta
Re: Apache variables
11858 by: B Thomas
Re: Unable to access Access DB via ODBC under IIS under WIN2K
11859 by: Bill Seeley
Re: undefined variable
11860 by: Martin Lindhe
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 ---
MySql is already compiled with the distri
A+
Alain
-----Original Message-----
From: Josh Seward [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, February 05, 2002 1:14 AM
To: [EMAIL PROTECTED]
Subject: [PHP-WIN] Embeded MySQL
Is it possible to compile php with libmySQL.dll or use it as an extention?
Any documentation would help great!
Thanks,
Josh Seward
[EMAIL PROTECTED]
--- End Message ---
--- Begin Message ---
Yes! MySQL is install with the distribution, but I want to run mysql not on
the server but along with my application. Embeded MySQL runs from a library
libmysql.dll. Mysql.com just mentions that this makes it possible to
distribute mysql with cd-rom applications.
I just need more info about using it with php?
Thanks again,
----- Original Message -----
From: "alain samoun" <[EMAIL PROTECTED]>
To: "Josh Seward" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Tuesday, February 05, 2002 10:28 AM
Subject: RE: [PHP-WIN] Embeded MySQL
> MySql is already compiled with the distri
> A+
> Alain
>
> -----Original Message-----
> From: Josh Seward [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, February 05, 2002 1:14 AM
> To: [EMAIL PROTECTED]
> Subject: [PHP-WIN] Embeded MySQL
>
>
> Is it possible to compile php with libmySQL.dll or use it as an extention?
>
> Any documentation would help great!
>
> Thanks,
> Josh Seward
> [EMAIL PROTECTED]
>
>
>
--- End Message ---
--- Begin Message ---
OK, so far I have narrowed it down to the fact that Crystal Reports 8.0 does
not support export of PDF format. SO, does anyone know if there is a fix for
this? In other words, is there a way to keep CR8.0 and use something with
it, say, a dll, to support this PDF format ???
Help ?
Thanks!
Nicole Amashta
www.aeontrek.com
"Nicole Amashta" <[EMAIL PROTECTED]> wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> Hello. This is slightly off topic, but I am doing this through PHP, so
it's
> somewhat relevant to this list.
>
> I am running crystal reports through PHP with a COM object. Now, I have
this
> working just fine on several computers and has been fine for months now.
The
> PHP calls the com object and that talks to Crystal Reports. A report is
> returned in the PDF format and displayed in the web page. This is all
> working fine.
>
> Now, I am setting this up again; however, I am doing it over the phone.
So,
> I am directing someone else set this all up.
>
> Here are *my* current specs:
>
> Win2k
> PHP 4.0.6
> Apache 1.3
> Crystal Reports version 8.5
> Adobe Acrobat full (reader and distiller)
>
> Here are *his* current spects:
>
> Win2k
> PHP 4.0.6
> Apache 1.3
> Crystal Reports version 8.0 <-- he has an older version.
> Adobe Acrobat full (reader and distiller)
>
> Question to anyone who knows: Does Crystal Reports 8.0 support the export
of
> PDF? He does not see the option through Crystal in the export feature.
>
> Anyhow, we've attempted to test the reports through the web page and get
the
> NULL pointer error. We are sure that the permissions and all is set up -
> matching mostly what I have on my machine, which works - through DCOMCNFG.
>
> So, I do not believe, anymore, that the error is because of this. I
believe
> it could be his version of crystal simply does not support the PDF export
> feature.
>
> One error he gets when using a COM test exe is this:
>
> Error: 692 Error in file E:\Apps\Apache\htdocs\....\thereport.rpt:
> Invalid export DLL or export format
> Export.Send <PEExportTo>.
>
> Anyone have any ideas or suggestions?
>
> TIA
> nicole,
> www.aeontrek.com
>
> --
> Nicole Amashta
> Web Applications Developer
> ABOL Software, Inc.
> ( 678 ) 494 - 3172
> [EMAIL PROTECTED]
>
>
--- End Message ---
--- Begin Message ---
"Steve Yates" <[EMAIL PROTECTED]> wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> "B Thomas" <[EMAIL PROTECTED]> wrote in message
> [EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> > echo $SCRIPT_NAME;
> >
> > Returns: nothing.
>
> What does phpinfo() show? There are some variables that are
> web-server dependent.
>
> - Steve Yates
> - Debrief: Wife listening while you talk in your sleep.
>
> / Taglines by Taglinator - www.srtware.com /
>
>
>
>
I've recently worked it out, thank you :))
track_vars in php.ini had been turned off, so the variable had to be called
by $HTTP_SERVER_VARS["SCRIPT_NAME"]; etc. :)
Thank you for your time
B
--- End Message ---
--- Begin Message ---
I already have a working ODBC DSN for the database that is accessible from
both the API version of 4.1.1 PHP under Apache and from Crystal Reports. My
problem is that I can't access it from PHP (CGI or ISAPI versions) under
IIS.
"Nicole Amashta" <[EMAIL PROTECTED]> wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> You must set up the ODBC source you want access to. Go to control panel,
> administrative tools, ODBC ... (if you haven't done this already).
>
> Go to the DSN tab and create a new datasource there. Are you familiar with
> this?
>
> If you need further help setting up an ODBC source, let me know. After
> creating this source, you can then use it through your PHP scripts.
>
> hope that helps any.
>
> ~Nicole Amashta
> www.aeontrek.com
>
>
> "Bill Seeley" <[EMAIL PROTECTED]> wrote in message
> [EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> > When attempting to query an Access 2K DB with the odbc_connect function,
I
> > get the messsage:
> >
> > Warning: SQL error: [Microsoft][ODBC Driver Manager] Data source name
not
> > found and no default driver specified, SQL state IM002 in SQLConnect in
> > e:\vnpweb\html\getcontact.php on line 14 IM002
> >
> > I have tried both the CGI (installer version) and ISAPI versions of PHP
> > 4.1.1 (manual install) and get the same messages. I am able to access
this
> > same data source name with Crystal Reports and was previously able to
> access
> > it with a PHP script under an Apache server (php4apache.dll version) on
> the
> > same machine. I've enabled both ODBC and PHP logging, but PHP logging
> > doesn't give me any more than the above messages. Curiously the ODBC log
> is
> > empty, even though the above messages would indicate that the MS ODBC
> driver
> > returned a legitimate error code.
> >
> > Has anyone seen anything like this and can you offer any suggestions?
> >
> > Thanks, Bill Seeley
> >
> >
> >
>
>
--- End Message ---
--- Begin Message ---
> Hello everyone,
> I have a small question:
> How can I get rid of "Warning: Undefined variable: user1(&
> password1) in C:\WebShare\wwwroot\netk\5\login.php on line 4"
> in that program?
>
> <?php
> include ("config.php");
> session_register("userpassword");
> if($user1==$USER && $password1==$PASSWORD) {
> $userpassword = $user1.$password1;
> header("Location:index.php");
> exit();
> }
> ?>
-[snip]-
the proper way of doing this would be
if (isset($user1) && isset($password1) && $user1==$USER &&
$password1==$PASSWORD) {
...
Or you can just turn off warnings in php.ini, as Nicole suggests :)
/Martin
--- End Message ---