Thanks It works now.
On Mon, 13 Dec 2004 23:43:06 -0800, Todd Lewis [EMAIL PROTECTED] wrote:
usually you have to log in as a local user before executing your
script.
I have written a simple program that should get data from a remote
database, but it is not working giving error:
I have written a simple program that should get data from a remote
database, but it is not working giving error:
DBI-connect(sugs:192.168.14.2) failed: Host 'www.sample.com' is not
allowed to connect to this MySQL server at testbug.pl line 12
code is below:
*
#! /usr/bin/perl -w
On Mon, 13 Dec 2004 17:55:12 +0500, Adam Saeed [EMAIL PROTECTED] wrote:
I have written a simple program that should get data from a remote
database, but it is not working giving error:
DBI-connect(sugs:192.168.14.2) failed: Host 'www.sample.com' is not
allowed to connect to this MySQL server
You might want to try this on your mysql server, might be a grant
permission issue.
1. GRANT ALL PRIVILEGES ON *.* TO [EMAIL PROTECTED] IDENTIFIED BY PASSWORD;
2. FLUSH PRIVILEGES;
3. exit.
Tor Hildrum wrote:
On Mon, 13 Dec 2004 17:55:12 +0500, Adam Saeed [EMAIL PROTECTED] wrote:
I have
identity. You almost certainly need to get your MySQL
administrator to allow the remote identity to connect.
Rgds, GStC.
-Original Message-
From: Adam Saeed [mailto:[EMAIL PROTECTED]
Sent: Monday, December 13, 2004 7:55 AM
To: Perl Beginners List
Subject: remote database access in perl
I have
Wow! This is news to me! I've been using Win32::ODBC and was very worried
about portability. Now I try perldoc and cannot find anything about using
DBI with ODBC. However, I search CPAN and I find this:
3.3 Is DBI supported under Windows 95 / NT platforms?
Finally, yes! Jeff Urlwin has been
documentation you may need on how to connect to
your DSN and manipulate the database.
-Brian
-Original Message-
From: Siegfried Heintze [mailto:[EMAIL PROTECTED]
Sent: Wednesday, September 01, 2004 11:17 AM
To: [EMAIL PROTECTED]
Subject: Which interface should I be using for Database Access
On Wed, Sep 01, 2004 at 09:16:53AM -0600, Siegfried Heintze wrote:
This is GREAT! But being a beginner, I don't know what to do next. Do I
download the source? Is there a PPM module? Where can I find an example that
accesses Microsoft Access?
Hi Siegfried,
I believe that there is a PPM for
Greetings!
Is there a Perl module --
Don't be silly!, I hear you reply. There's a Perl module for
everything!
OK, let me rephrase that. I would like a program, probably but not
necessarily in Perl, that can run on a Perl-equipped Unix server that
will give me remote access through the
phpMyAdmin is great for managing MySQL databases remotely using a web
browser interface. See http://www.phpmyadmin.net/
-tn
--
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
search google for Webmon.
also check out phpadmin.
good luck
Sam Harris,
Systems Administrator
Franklin University
201 S. Grant Avenue
Columbus, Ohio 43215-5399
Work: (614)-744-8322
Toll free: 1-877-341-6300 ext. 8322
[EMAIL PROTECTED]
http://www.franklin.edu/
[EMAIL PROTECTED] 09/29/03 09:56
Sam,
There's a lot of products named Webmon. The ones I found on Google
didn't do what I want. Which one are you thinking of? Can you give me
a company name?
Thanks again!
Rob
__
Do you Yahoo!?
The New Yahoo! Shopping - with improved product search
Rob,
why not try one of r-desktops. I use TridiaVNC, which you can carry with
ssh.
Mark G
- Original Message -
From: Rob Richardson [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Monday, September 29, 2003 3:33 PM
Subject: Re: Generic database access?
Sam,
There's a lot
I wrote a small program accessing a Mysql database.
All works fine when I run it from shell, but when I try to use it as CGI using apache
2.0 I'm
having this kind of trouble:
when he access to the database, looks like he append to the user name the domain...so
if all works
properly from shell
Francesco Del Vecchio [EMAIL PROTECTED] wrote:
I wrote a small program accessing a Mysql database.
All works fine when I run it from shell, but when I try to use it as CGI using
apache 2.0 I'm
having this kind of trouble:
when he access to the database, looks like he append to the user
--- Rob Dixon [EMAIL PROTECTED] wrote:
Hi Frank.
We can only speculate as to what your problem may be
until we know a little more about your script. Can you post
an extract of what you think is the relevant area?
Cheers,
Rob
Hi Rob...here you have the code:
Zentara [EMAIL PROTECTED] wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
On Mon, 30 Sep 2002 11:47:37 -0500, [EMAIL PROTECTED] (Scot Robnett)
wrote:
Define a lot of people.
I just did a quick google search for javascript statistics, and most
of the surveys show somewhere
On Fri, 27 Sep 2002 14:43:50 -0400, [EMAIL PROTECTED] (Jim Lundeen)
wrote:
Hello,
I'm creating a web site for our department at my school. We have a
sign-up form for a society that people can join. I want to create a
MySQL database of university names and allow the user to click on a
Lookup
PROTECTED]]On Behalf Of
zentara
Sent: Monday, September 30, 2002 10:02 AM
To: [EMAIL PROTECTED]
Subject: Re: pop-up window with database access
On Fri, 27 Sep 2002 14:43:50 -0400, [EMAIL PROTECTED] (Jim Lundeen)
wrote:
Hello,
I'm creating a web site for our department at my school. We have
On Mon, 30 Sep 2002 10:28:51 -0500, [EMAIL PROTECTED] (Scot Robnett)
wrote:
Avoid Javascript is a pretty far-reaching statement. If you want to launch
a popup window, Perl isn't going to do that, Javascript is. It only takes
one or two lines of client-side code. There are easy-to-follow
PROTECTED]
Subject: Re: pop-up window with database access
On Mon, 30 Sep 2002 10:28:51 -0500, [EMAIL PROTECTED] (Scot Robnett)
wrote:
Avoid Javascript is a pretty far-reaching statement. If you want to
launch
a popup window, Perl isn't going to do that, Javascript is. It only takes
one or two lines
On Mon, 30 Sep 2002 11:47:37 -0500, [EMAIL PROTECTED] (Scot Robnett)
wrote:
Define a lot of people.
I just did a quick google search for javascript statistics, and most
of the surveys show somewhere between 10% and 15 % of people
have disabled javascript.
I guess it depends how important the
Jim Lundeen wrote:
Hello,
I'm creating a web site for our department at my school. We have a
sign-up form for a society that people can join. I want to create a
MySQL database of university names and allow the user to click on a
Lookup button on the sign-up form when they get to the
Hello,
I'm creating a web site for our department at my school. We have a
sign-up form for a society that people can join. I want to create a
MySQL database of university names and allow the user to click on a
Lookup button on the sign-up form when they get to the field
University Affiliation
Jim Lundeen wrote:
Hello,
I'm creating a web site for our department at my school. We have a
sign-up form for a society that people can join. I want to create a
MySQL database of university names and allow the user to click on a
Lookup button on the sign-up form when they get to the
Hello,
I'm creating a web site for our department at my school. We have a
sign-up form for a society that people can join. I want to create a
MySQL database of university names and allow the user to click on a
Lookup button on the sign-up form when they get to the field
University Affiliation
Hello all again,
Solaris, Perl 5, Oracle 8.1.6
OK, so here I am... Now I am having issues accessing my database from my
Perl SQL query. I want to query my DB and put it's response into a variable
to be used later. I really think that I am structuring my perl query wrong.
How do I get my
();
I think I am screwing up the whole while loop.
-garrett
From: garrett esperum [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Subject: Database Access Problem (again)
Date: Thu, 02 May 2002 11:45:33 -0700
Hello all again,
Solaris, Perl 5, Oracle 8.1.6
OK, so here I am... Now I am having
on Thu, 02 May 2002 20:11:29 GMT, Garrett Esperum wrote:
This is the error message I recieve when I run my script:
DBD::Oracle::db prepare failed: ORA-00904: invalid column name (DBD
ERROR: OCIStmtExecute/Describe) at 3mfiles.pl line 63.
DBD::Oracle::db prepare failed: ORA-00904: invalid
OOPS!! Thank you! That a was the problem. :)
-garrett
From: Felix Geerinckx [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Subject: Re: Database Access Problem (again)
Date: 2 May 2002 20:25:22 -
on Thu, 02 May 2002 20:11:29 GMT, Garrett Esperum wrote:
This is the error message I recieve when
I'm not sure i follow you but if you use localhost or leave the host
blank it'll try localhost...
/Jon
Jefferson Ryan Lee wrote:
Hi,
Are there any way to access a database (SQL Server) not using the ODBC?
It is possible for a perl script to query a database not on a local
Hi,
Are there any way to access a database (SQL Server) not using the ODBC?
It is possible for a perl script to query a database not on a local
machine instead on a different location through tcp-ip/internet? Please
advise. Thanks.
Regards,
Jeff
--
To unsubscribe, e-mail: [EMAIL
http://www.perldoc.com/perl5.6.1/lib/DBI.html
-Original Message-
From: Jefferson Ryan Lee [mailto:[EMAIL PROTECTED]]
Sent: Thursday, January 31, 2002 8:52 PM
To: [EMAIL PROTECTED]
Subject: perl database access
Hi,
Are there any way to access a database (SQL Server) not using
You can if the database is accessible from the webserver.
Read about apache (www.apache.org) and perl (www.perl.org), especially
the modules CGI.pm and DBI.pm.
/Jon
Allison Davis wrote:
Can anyone tell me if you can have all the members of our origanization
access our database on the web
Can anyone tell me if you can have all the members of our origanization
access our database on the web to change their personal information only.
We want each member to have their own user id and password.
Thanks for your help
Allison
--
To unsubscribe, e-mail: [EMAIL PROTECTED]
For
35 matches
Mail list logo