conecting cgi and mdb? help please:)

[maxa]

I have install ActivePerl 5.6.1.630 in folder c:\perl
then I have run ppm and do the fallowing:

PPM> install dbi
Install package 'dbi?' (y/N): y
Installing package 'dbi'...
Error installing package 'dbi': Could not locate a PPD file for package dbi
PPM>

this is error message and my question is:

1.way I can't install dbi when I am offline? This package I can install only when I am 
online like others pelage ("INSTALL DBD-Mysql")

2.Can I connect cgi with Microsoft access database " *.mdb " and how to configure 
those relationship?
3. Can I use Microsoft access database " *.mdb " on servers where is supported mysql?
4.How can I reply on messages because I don't see button "reply"??

Thanks,
Dragan

Re: conecting cgi and mdb? help please:)

[Mo Holkar / UKG]

At 13:43 17/04/02, you wrote:
>I have install ActivePerl 5.6.1.630 in folder c:\perl
>then I have run ppm and do the fallowing:
>
>PPM> install dbi
>Install package 'dbi?' (y/N): y
>Installing package 'dbi'...
>Error installing package 'dbi': Could not locate a PPD file for package dbi
>PPM>

This operation is case-sensitive -- you need to type 'install DBI'.

best,

Mo




Mo Holkar
Undying King Games
[EMAIL PROTECTED]
Free games! at http://www.ukg.co.uk


-- 
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

Re: conecting cgi and mdb? help please:)

[Kamali Muthukrishnan]

I would like to know what all needs to be done to connect to a Microsoft Access 
database using perl script. Can somebody guide me please ?
One of the perl books' website has some information , but I think the server where the 
document resides has problems and so I am not able to get to it.
Any website, books etc.?
Kamali

>>> "maxa" <[EMAIL PROTECTED]> 04/17/02 07:43AM >>>
I have install ActivePerl 5.6.1.630 in folder c:\perl
then I have run ppm and do the fallowing:

PPM> install dbi
Install package 'dbi?' (y/N): y
Installing package 'dbi'...
Error installing package 'dbi': Could not locate a PPD file for package dbi
PPM>

this is error message and my question is:

1.way I can't install dbi when I am offline? This package I can install only when I am 
online like others pelage ("INSTALL DBD-Mysql")

2.Can I connect cgi with Microsoft access database " *.mdb " and how to configure 
those relationship?
3. Can I use Microsoft access database " *.mdb " on servers where is supported mysql?
4.How can I reply on messages because I don't see button "reply"??

Thanks,
Dragan


--
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

RE: conecting cgi and mdb? help please:)

[David Gray]

> I would like to know what all needs to be done to connect to 
> a Microsoft Access database using perl script.

1) You need two modules: DBI and DBD::ODBC

2) You need to create an ODBC data source referring to the database
file.

3) Connect to the database like this:

$dbh = DBI->connect("DBI:ODBC:$DSN_NAME")
  or die "Couldn't connect to $DSN_NAME: $DBI::errstr\n\n";
# where $DSN_NAME is the name of the ODBC data source
# you created in step 2

> 1.way I can't install dbi when I am offline?

Because ppm needs a net connection so it can download the module for you
 
> 2.Can I connect cgi with Microsoft access database " *.mdb " 
> and how to configure those relationship?

See above

> 3. Can I use Microsoft access database " *.mdb " on servers where is 
> supported mysql?

A quick google search turned up:


> 4.How can I reply on messages because I don't see button "reply"??

What mail client do you use?

 -dave



-- 
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

RE: conecting cgi and mdb? help please:)

[Kamali Muthukrishnan]

Hi :  
Thanks a bunch.   For the first module, I would do -
   install dbi
 For the second module for the Open DB Connectivity , will I do something
similar like this ? -
  install dbd::odbc
 "need to create an ODBC data source referring to the database file" - could you 
please explain this ? does it mean creating a db and populating tables?
I appreciate all the help I get from this discussion group.
Kamali

>>> "David Gray" <[EMAIL PROTECTED]> 04/19/02 08:39AM >>>
> I would like to know what all needs to be done to connect to 
> a Microsoft Access database using perl script.

1) You need two modules: DBI and DBD::ODBC

2) You need to create an ODBC data source referring to the database
file.

3) Connect to the database like this:

$dbh = DBI->connect("DBI:ODBC:$DSN_NAME")
  or die "Couldn't connect to $DSN_NAME: $DBI::errstr\n\n";
# where $DSN_NAME is the name of the ODBC data source
# you created in step 2

> 1.way I can't install dbi when I am offline?

Because ppm needs a net connection so it can download the module for you
 
> 2.Can I connect cgi with Microsoft access database " *.mdb " 
> and how to configure those relationship?

See above

> 3. Can I use Microsoft access database " *.mdb " on servers where is 
> supported mysql?

A quick google search turned up:


> 4.How can I reply on messages because I don't see button "reply"??

What mail client do you use?

 -dave



-- 
To unsubscribe, e-mail: [EMAIL PROTECTED] 
For additional commands, e-mail: [EMAIL PROTECTED] 



--
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

RE: conecting cgi and mdb? help please:)

[David Gray]

> Hi :  
> Thanks a bunch.   For the first module, I would do -
>install dbi
>  For the second module for the Open DB Connectivity , will I 
> do something similar like this ? -
>   install dbd::odbc
>  "need to create an ODBC data source referring to the 
> database file" - could you please explain this ? does it mean 
> creating a db and populating tables? I appreciate all the 
> help I get from this discussion group. Kamali

Hmm... Are you on a Win32 or *nix machine?

If you're on a *nix machine, you should probably look into some of the
links from that google search and import your .mdb into mysql before you
try to access it using perl.

My Favorite DBI/DBD Reference:


If you're on a Win32 machine, you can create an ODBC data source from
"Control Panels->ODBC"

HTH,

 -dave



-- 
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

RE: conecting cgi and mdb? help please:)

[Kamali Muthukrishnan]

Thank you once again.  I am on Win32 machine using ActivePerl.
I had been doing Google search for the past few hours.  There, sometimes you hit dirt 
( like in my case for the past 5 hours) and sometimes gold .  I hit one site which 
seems to give a lot of information on this -
http://www.wdvl.com/Authoring/Languages/Perl/PerlfortheWeb/prepare_access.html 
I will look into the site, you have given too.
Kamali

>>> "David Gray" <[EMAIL PROTECTED]> 04/19/02 09:23AM >>>
> Hi :  
> Thanks a bunch.   For the first module, I would do -
>install dbi
>  For the second module for the Open DB Connectivity , will I 
> do something similar like this ? -
>   install dbd::odbc
>  "need to create an ODBC data source referring to the 
> database file" - could you please explain this ? does it mean 
> creating a db and populating tables? I appreciate all the 
> help I get from this discussion group. Kamali

Hmm... Are you on a Win32 or *nix machine?

If you're on a *nix machine, you should probably look into some of the
links from that google search and import your .mdb into mysql before you
try to access it using perl.

My Favorite DBI/DBD Reference:


If you're on a Win32 machine, you can create an ODBC data source from
"Control Panels->ODBC"

HTH,

 -dave



-- 
To unsubscribe, e-mail: [EMAIL PROTECTED] 
For additional commands, e-mail: [EMAIL PROTECTED] 



--
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]