PM, Martin J. Evans mailto:martin.ev...@easysoft.com>> wrote:
On 30/10/2015 13:21, Ismail Chamseddine wrote:
I am trying to connect to MS access database on my PC. I am getting an
error message of failure, data source not found, (ODBC driver manager) no
default driver is ment
On 30/10/2015 13:21, Ismail Chamseddine wrote:
I am trying to connect to MS access database on my PC. I am getting an
error message of failure, data source not found, (ODBC driver manager)
no default driver is mentioned . please help
Please try and help us help you and post more information
+44-7440 56 12 32
From: Ismail Chamseddine
Sent: Friday, October 30, 2015 6:51 PM
To: dbi-users@perl.org
Subject: MS access
I am trying to connect to MS access database on my PC. I am getting an error
message of failure, data source not found, (ODBC driver manager) no d
I am trying to connect to MS access database on my PC. I am getting an
error message of failure, data source not found, (ODBC driver manager) no
default driver is mentioned . please help
My email client had a load of problems with your non-text email so I've
not quoted it.
I presume you are using DBD::ODBC? If not, I don't know.
Could you provide a trace:
set DBI_TRACE=15=x.log
then run program and x.log should contain trace.
Don't post it here, it is probably too long. If po
I'm modifying an app that currently creates Microsoft Access 2003 files, but also needs
to create Access 2007 files.I updated the connection string in the function in a perl module so it specifies '.accdb' files in addition to '.mdb' files. However, when I try to test the code to create an Access
On 20/10/10 21:36, Memo Garcia wrote:
> Hi,
>
> Only for completeness of the manual, I include the results of
> perl_dbi_nulls_test.pl using MS Access
>
> Thanks,
Added, thanks.
Martin
--
Martin J. Evans
Easysoft Limited
http:
Hi,
Only for completeness of the manual, I include the results of
perl_dbi_nulls_test.pl using MS Access
Thanks,
-
Using dbi:ODBC:DRIVER={Microsoft Access Driver
(*.mdb)};DBQ=D:\Proyecto\STU-La Serena\SinDuplicados_Gustavo
01\Encuestas.mdb;PWD
Hi
I'm looking at creating some web apps from old excell and ms access
files. I'd like to find out which packages are best used with these
to extract and update information. I noticed roth's win32::odbc. I'm
just curious if there are other packages too.
Thanks
Mike
Hello,
I am facing the same issue described by this post:
http://groups.google.com/group/perl.dbi.users/msg/7509158a78fe28dc
Is there a workaround? This is in IIS6.0. Can I make my CGI script
impersonate the user who mapped the drive where the Access db
resides? To complicate matters, my user
On Mon, 2006-09-11 at 13:05 -0400, Berthold, Scott wrote:
> How can I list all of the table names in an access database?
>
> Thanks,
> Scott Berthold
Have you tried the table_info method?
Martin
--
Martin J. Evans
Easysoft Limited
http://www.easysoft.com
How can I list all of the table names in an access database?
Thanks,
Scott Berthold
http://savage.net.au/Ron/html/msaccess2rdbms.html
--
Cheers
Ron Savage, [EMAIL PROTECTED] on 3/07/2005
http://savage.net.au/index.html
Let the record show: Microsoft is not an Australian company
Well Thanks for all the feedback. I thought I had figured it out using
a combination of various pieces from everyone who posted to the
questions. But again, it wasn't working ... I had one script working and
another that wasn't ... what the [EMAIL PROTECTED] Anyway, "I think" I've figured
out
>
> On Thu, Apr 14, 2005 at 07:50:43AM -0400, Jeff Urlwin wrote:
> > > >
> > > > I would write as:
> > > > $dt = "#04-MAY-2004 17:03:34#";
> > >
> > > Wouldn't single quotes also work?:
> > >
> > > $dt = "'04-MAY-2004 17:03:34'";
> > >
> > > > Converting the month to a 3-character string ver
On Thu, Apr 14, 2005 at 07:50:43AM -0400, Jeff Urlwin wrote:
> > >
> > > I would write as:
> > > $dt = "#04-MAY-2004 17:03:34#";
> >
> > Wouldn't single quotes also work?:
> >
> > $dt = "'04-MAY-2004 17:03:34'";
> >
> > > Converting the month to a 3-character string version forces
> > Access
>
>
> On Thu, Apr 14, 2005 at 09:19:00AM +1000, Daniel Kasak wrote:
> > Robb wrote:
> >
> > > Hi,
> > >
> > > Does anyone have any idea what is up with Microsoft
> Access and its
> > > ridiculous Date/Time formatting options?
> >
> > :)
> >
> > In VB, I use the format:
> >
> > #dd-mmm-
On Thu, Apr 14, 2005 at 09:19:00AM +1000, Daniel Kasak wrote:
> Robb wrote:
>
> > Hi,
> >
> > Does anyone have any idea what is up with Microsoft Access and its
> > ridiculous Date/Time formatting options?
>
> :)
>
> In VB, I use the format:
>
> #dd-mmm- HH:mm:ss#
>
> Your example:
> $dt =
Robb wrote:
> Hi,
>
> Does anyone have any idea what is up with Microsoft Access and its
> ridiculous Date/Time formatting options?
:)
In VB, I use the format:
#dd-mmm- HH:mm:ss#
Your example:
$dt = "#4/5/2004 5:3:45 PM#";
I would write as:
$dt = "#04-MAY-2004 17:03:34#";
You have to pad
On Tue, 2005-04-12 at 23:34 -0700, Robb wrote:
> Does anyone have any idea what is up with Microsoft Access and its
> ridiculous Date/Time formatting options?
I asked that question daily in a previous life working with access, and
that that was with ms tools! I never got a sane answer.
I don't no
On Tue, 12 Apr 2005 23:34:09 -0700, Robb wrote:
>Does anyone have any idea what is up with Microsoft Access and its
>ridiculous Date/Time formatting options?
I am guessing that MS-Access formats dates according to your settings in
the "Regional Settings" control panel.
--
Bart.
ut that doesn't help much considering I would want to update the field.
There are no question marks in any of the field names as suggested on
many pages dicussing this error below. Thanks for any help! I'm using
MS Access, Perl, DBI & DBD::ODBC win32 modu
> From: Kevin Carothers <[EMAIL PROTECTED]>
> Date: 2005/04/11 Mon PM 03:06:59 CDT
> On Apr 11, 2005 12:35 PM, Moreno, Javier <[EMAIL PROTECTED]> wrote:
> > Ok. I have tried ADO as well with no luck. Please help!
> > my ($path_to_mdb_file) = '\\slpmxwtstandclu\testdata$\Data_2.mdb';
>
> Aha!
> Y
On Apr 11, 2005 12:35 PM, Moreno, Javier <[EMAIL PROTECTED]> wrote:
> Ok. I have tried ADO as well with no luck. Please help!
>
>
>
> # Include CPAN modules for DB communication
> use DBI;
> #use DBD::ODBC;
> use DBD::ADO;
> #use Win32::OLE;
>
> # Use these pragmas to code correctly
> use stric
TTWeb/cgi-bin/Welcome.pl
Regards,
Javier Moreno
-Original Message-
From: amonotod [mailto:[EMAIL PROTECTED]
Sent: Friday, April 08, 2005 8:07 PM
To: Moreno, Javier; dbi-users@perl.org
Subject: Re: Accessing MS Access
> From: "Moreno, Javier" <[EMAIL PROTECTED]>
> Dat
> From: "Moreno, Javier" <[EMAIL PROTECTED]>
> Date: 2005/04/08 Fri PM 03:44:40 CDT
> I posted a question and have tried several solutions on how to open
> up an MS Access DB from the DBI::ODBC but so far have been unable to.
> I was wondering if there is
Hi all,
This is probably a more DB oriented question, but it came out of the DBI. I
posted a question and have tried several solutions on how to open up an MS
Access DB from the DBI::ODBC but so far have been unable to. What I had to end
up doing was create a DTS that runs every 5 minutes
>
> Just my opinion, but I don't think this is good advice. For
> one, it creates extra administration on the system, by
> forcing the user/programmer /sysadmin/webadmin to create an
> ODBC DSN setting for every new setup. For two, DBI and ODBC
> both support dynamic DSNs, so why not use them
Hi Javier,
[---]
> And on the log I get:
> [Thu Mar 31 07:12:56 2005] [error] [client 151.110.117.153] DBI
> connect('CLUCTR','',...) failed: [Microsoft][ODBC Microsoft Access Driver]
> The Microsoft Jet database engine cannot open the file '(unknown)'. It is
> already opened exclusively by
> From: Kevin Carothers <[EMAIL PROTECTED]>
> Date: 2005/03/30 Wed PM 06:44:48 CST
> 1. Create an ODBC connection via %SystemRoot%\system32\odbcad32.exe
> Call the database connect name "ODBCName"
>
> 2. In your Perl code add:
> [---]
>use DBI;
> [---]
>$dbh = DBI->connect("db
; }
>
> # Unable to continue. We know why so just die
> die;
> }
>
> Regards,
>
> Javier Moreno
>
> -Original Message-
> From: Kevin Carothers [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, March 30, 2005 6:45 PM
> To: Moreno, Ja
$::rc = $::dbh->disconnect or die "FATAL ERROR. Unable to
disconnect from database.";
}
# Unable to continue. We know why so just die
die;
}
Regards,
Javier Moreno
-Original Message-
From: Kevin Carothers [mailto:[EMAIL PROTECTED]
Sent: Wednesda
Hi Javier,
> I am trying to access an MS Access database via perl DBI and I am unable to.
> I checked the security and there is only one 'Admin' user with no password
> and I use that in my connection string. However, I cannot connect. Please
> help.
>
1. Creat
Hi all,
I am trying to access an MS Access database via perl DBI and I am unable to. I
checked the security and there is only one 'Admin' user with no password and I
use that in my connection string. However, I cannot connect. Please help.
Regards,
Javier Moreno
> From: "Willis, Frank A" <[EMAIL PROTECTED]>
> Date: 2005/03/16 Wed PM 01:47:05 CST
>
> I?ve made one last attempt at looking for a way to read and parse
> out an (MS Access) .ldb (locked database) file
You know, I've been wondering, why are even trying to
DBI users group,
I’ve made one last attempt at looking for a way to
read and parse out an (MS Access) .ldb (locked database) file independent of
using the DBI. One suggestion that I received today was to split the
contents of my buffer ($buf) up using the split command as follows
Jeff Zucker wrote:
Willis, Frank A wrote:
With slight modifications it could handle the data you describe. Just
look at AnyData::Format::Paragraph.
And if it works for you, rename it AnyData::Format::LDB and submit it to
CPAN or submit to me and I'll include it (with you as author) in a
future
Willis, Frank A wrote:
Perl dbi users:
(This task might be able to be done independent of the DBI). I am
trying to format and parse a colon-delimited MS Access .LDB (Locking
Database) file out to a .csv file
DBD::AnyData includes a "paragraph" format that supports "vertical
Perl dbi users:
(This task might be able to be done independent of the DBI).
I am trying to format and parse a colon-delimited MS Access .LDB (Locking
Database) file out to a .csv file but really can’t complete the
formatting step. I have the shell of a read/format program below
It worked just fine for me with no changes.
Dennis
-Original Message-
From: David N Murray [mailto:[EMAIL PROTECTED]
Sent: Thursday, 25 March 2004 2:38 PM
To: Bart Lateur
Cc: [EMAIL PROTECTED]
Subject: Re: getting table structure out of MS-Access
I thought this worked, but when I test
On Wed, 24 Mar 2004 22:37:37 -0500 (EST), David N Murray wrote:
>I thought this worked, but when I test it now, I can't get it to work.
It works for recent enough versions of DBD::ODBC. More or less.
Except that column_info returns NULLABLE true for columns that can't be
NULL, doubles (float) ha
I thought this worked, but when I test it now, I can't get it to work.
YMMV. -- Dave
#!/usr/bin/perl -w
# this does a 'describe' for MS access
use DBI;
use strict;
$|++;
#DBI->trace(8);
die "usage: desc.pl DSN table_name\n" if $#ARGV != 1;
my $dbh = DB
I'd like to automate exporting data out of an existing Access database,
using DBI/DBD::ODBC, I guess. I need a proper description of each column
in a table, in order to reconstruct a complete CREATE TABLE statement.
My guess is that the func() method in DBD::ODBC could help. I've
experimented a li
> -Original Message-
> From: Jason [mailto:[EMAIL PROTECTED]
> Sent: Friday, March 05, 2004 11:38 AM
> To: [EMAIL PROTECTED]
> Subject: Re: MS ACCESS text field truncated
>
>
> Hello Jeff,
>
> At first, I did put type longvarchar, then I read the doc and
Hello Jeff,
At first, I did put type longvarchar, then I read the doc and copy the type
"LONGVARCHAR" to my code. All the other parts very simple because I use the
default way to make connection and create prepared statement. The field
$address is mapped to "Text" field of s
>
> Hi Tim,
>
> The doc says LongTruncOK and LongReadLen have nothing to do
> with writing data into DB. They are only for reading. In
> addition, I am dealing with "Text" type data in MS ACCESS,
> not "LONG" type.
Just to butt in here...you should ha
D'oh! You're right. I guess I should get more sleep before answering
questions...
-Original Message-
From: Jason [mailto:[EMAIL PROTECTED]
Sent: Thursday, March 04, 2004 2:16 PM
To: [EMAIL PROTECTED]
Subject: Re: MS ACCESS text field truncated
Hi Tim,
The doc says LongT
Hi Tim,
The doc says LongTruncOK and LongReadLen have nothing to do with writing
data into DB. They are only for reading. In addition, I am dealing with
"Text" type data in MS ACCESS, not "LONG" type.
Thanks,
J.
"Tim Johnson" <[EMAIL PROTECTED]> wrote in mes
Look in the docs for the $dbh->LongTruncOk and $dbh->LongReadLen
properties.
-Original Message-
From: Jason Q. [mailto:[EMAIL PROTECTED]
Sent: Thursday, March 04, 2004 12:50 PM
To: [EMAIL PROTECTED]
Subject: MS ACCESS text field truncated
Hi there,
I am using DBI to access Mic
Hi there,
I am using DBI to access Microsoft ACCESS database. I found the data of "text" field
logged by DBI has been truncated to 50 characters. I have changed the field size from
50 to 255, but it still doesn't work. Anyone can help?
Thanks,
J.
I am reading from a MS Access database and want to convert the date
returned in a select statement. Without the conversion, the date looks
like this when printed:
01954-03-25 00:00:00
$requests = "SELECT
person_name,
sex_code,
Age,
DOB,
#to_char(DOB,
ager.
>
> Tim.
>
> On Sun, Feb 01, 2004 at 03:10:11PM -0500, Robert Twitty wrote:
> > Hi Tim
> >
> > ODBTP is a solution that provides full support for MS Access from any
> > platform. Not only does it provide write access and complete SQL suppot
> > f
Hi Tim
ODBTP is a solution that provides full support for MS Access from any
platform. Not only does it provide write access and complete SQL suppot
for MS Access databases, but it also can easily run stored queries using
prepared statements. It also is the best Open Source solution for
ution that provides full support for MS Access from any
> platform. Not only does it provide write access and complete SQL suppot
> for MS Access databases, but it also can easily run stored queries using
> prepared statements. It also is the best Open Source solution for
> connecting to
ess have a similar network protocol? I thought that ODBC was
> > about the only MS supported method of communicating to it...
> >
> > > -Original Message-
> > > From: Tim Bunce [mailto:[EMAIL PROTECTED]
> > > Sent: Tuesday, June 25, 2002 2:18 PM
> &g
>
> I have problems retrieving data from a Microsoft Access 97
> database using DBD::ODBC. Using the code
> ...
> $sth = $dbh->prepare("SELECT table.id,table.field FROM
> table WHERE
> (((table.field) Like \'${variable}*\'));");
> $sth->execute;
> $sth->dump_results();
T
ults();
...
leads to "0 rows" although there are many rows in the database that match
the given expression!?
First I tried somthing like
$sth = $dbh->prepare("SELECT id,field FROM table WHERE field Like \'
${variable}*\'");
with the same result.
Looking at
y Is Incorrect for IWAM Account"
http://support.microsoft.com/default.aspx?scid=kb;EN-US;297989
Good luck with the issue,
John
-Original Message-
From: Jim Whitcomb [mailto:[EMAIL PROTECTED]
Sent: Thursday, October 16, 2003 3:54 PM
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Subject: Writing t
I can read my MS Access DB using DBI but I cannot write, delete, or
update it. I have seen a couple relevant discussions posted but none
(I've seen) offered a solution.
The web site is using:
Windows
2000 Server
Perl v
5.8.0 build 805
DBI v 1.37
from Active
Folks
I'm using DBI to read an MS Access file. I don't have access to
Access. For dates, I get values like:
INS_DTE: 34590.721331.
UPD_DTE: 35416.518703.
VLD_FROM: 34458.0.
VLD_TO: 73415.0.
Any ideas on how to interpret these?
TIA.
--
Cheers
Ron Savage, [EMAIL PROTECTED] on 06/04
>
>
> Hi there,
>
> Is there a way to use Unicode SQL statement for MS Access
> 2002 through the DBI ODBC driver? I know Access stores text
> in Unicode internally and the ActiveState Perl 5.8 supports
> unicode pretty well. But I cannot make this combination w
Hi there,
Is there a way to use Unicode SQL statement for MS Access 2002 through the DBI ODBC
driver? I know Access stores text in Unicode internally and the ActiveState Perl 5.8
supports unicode pretty well. But I cannot make this combination work (I need to
insert Chinese, Japanese, Korean
I stand corrected.
-Original Message-
From: Jeff Urlwin [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, December 03, 2002 6:58 AM
To: 'Timothy Johnson'; 'Thomas A. Lowery'; [EMAIL PROTECTED]
Subject: RE: Connecting MS Access Database with DBI
>
>
> You never
>
>
> You never actually "use" your DataBase Driver, so DBI has no
> idea how to do what you've asked. I think this is what the
> error message is trying to tell you. Try installing
> DBD::ODBC and then putting the line "use DBD::ODBC" at the
> top of your script after" use DBI".
>
No...N
EMAIL PROTECTED]]
> Sent: Monday, December 02, 2002 7:50 PM
> To: [EMAIL PROTECTED]
> Subject: Re: Connecting MS Access Database with DBI
>
>
> On Mon, Dec 02, 2002 at 09:37:58PM -0600, jad wrote:
> > I have Active State Perl 5.6. I've used PPM install DBI. I'm u
e DBI".
-Original Message-
From: Thomas A. Lowery [mailto:[EMAIL PROTECTED]]
Sent: Monday, December 02, 2002 7:50 PM
To: [EMAIL PROTECTED]
Subject: Re: Connecting MS Access Database with DBI
On Mon, Dec 02, 2002 at 09:37:58PM -0600, jad wrote:
> I have Active State Perl 5.6. I'
>
> I have Active State Perl 5.6. I've used PPM install DBI. I'm using
> this code:
>
>
>
>
> #
> # Perl script that talks with the Northwinds database using
> an # ODBC DSN of Northwind. #
>
> use DBI;
> use Data::Dumper;
>
> my $dbh = DBI->connect( "dbi:ODBC:Northwind", "Admin", "",
>
On Mon, Dec 02, 2002 at 09:37:58PM -0600, jad wrote:
> I have Active State Perl 5.6. I've used PPM install DBI. I'm using
> this code:
Did you install DBD-ODBC?
> #
> # Perl script that talks with the Northwinds database using an
> # ODBC DSN of Northwind.
> #
>
> use DBI;
> use Data::Dumper;
I have Active State Perl 5.6. I've used PPM install DBI. I'm using
this code:
#
# Perl script that talks with the Northwinds database using an
# ODBC DSN of Northwind.
#
use DBI;
use Data::Dumper;
my $dbh = DBI->connect( "dbi:ODBC:Northwind", "Admin", "",
{RaiseError => 1, PrintError =
t: Re: Connecting to MS Access
See FAQ:
See DBI/FAQ http://xmlproj.dyndns.org/cgi-bin/fom
On Sun, Dec 01, 2002 at 12:01:50PM -0600, Mike(mickako)Blezien wrote:
> I'm sure this must have been discussed many time in the past, but I
just
> need to get some refresher information or directions. I bel
See FAQ:
See DBI/FAQ http://xmlproj.dyndns.org/cgi-bin/fom
On Sun, Dec 01, 2002 at 12:01:50PM -0600, Mike(mickako)Blezien wrote:
> I'm sure this must have been discussed many time in the past, but I just
> need to get some refresher information or directions. I believe data can be
--
Thomas A.
Hello all,
I'm sure this must have been discussed many time in the past, but I just need to
get some refresher information or directions. I believe data can be entered into
a MS Access database, via Perl and DBI, but not real sure how this is done. I
would be much appreciative if someone
go to ppm
at:
ppm> install dbd-odbc
you should be set once you've established a dsn.
-ap
--- Bart Lateur <[EMAIL PROTECTED]> wrote:
> On Thu, 14 Nov 2002 15:51:07 -0500, Changhong Tang wrote:
>
> >But I get this error:
> >install_driver(ODBC) failed: Can't locate DBD/ODBC.pm in @INC(@INC
>
>
On Thu, 14 Nov 2002 15:51:07 -0500, Changhong Tang wrote:
>But I get this error:
>install_driver(ODBC) failed: Can't locate DBD/ODBC.pm in @INC(@INC
You don't have DBD::ODBC installed.
>How do I tell if DBD::ODBC perl module is fully installed?
>I do have these files:
>c:/Perl/lib/Win32/Odbc.pm
Hello,
I want to use DBI to connect to MS Access database. In my code, I
have:
#!c:/perl/bin/perl.exe
use CGI qw(:standard :html);
use DBI;
$DBase="C:\db1.mdb";
my $dbh=DBI->connect('dbi:ODBC:$DBase')
or die "Can`t connect to database: " . DBI->
allow a clearer conclusion I will post again
Keep up the good work
thanks
Fred
Copies to: <[EMAIL PROTECTED]>
Subject:RE: insert LONG / BLOB in MS ACCESS == Brackets around names?
Date sent: Thu, 17 Oct 2002 14:10:40 -0400
> > Thanks f
RE: insert LONG / BLOB in MS ACCESS == Brackets
around names?
Date sent: Thu, 17 Oct 2002 17:52:00 +0100
Hi Jeff
Thanks for the reply
After having sent my email (with some trepidation as I felt
that I was asking something that seems to be not a new problem)
I actually di
es are
typically painful, especially when porting, so that may be an issue in your
case, but honestly, I haven't tested it.
>
> BUT IT ONLY seems to work for tables diretly created from
> perl::DBI
> => see below
>
>
> C) having seen that this worked, I realized that
Frederik,
In DBD::ODBC distribution under the mytest subdirectory, there is a
longbin.pl. Check that out for a sample which works on MS-Access *and*
inserts a long binary file (I used a .TIF file for my tests). The test
basically takes an MD5 hash of the input file, inserts it, retrieves it
Hi
Sorry for the inconvenience of yat another request for help on long blob
insertion:
I cannot manage to get MS access accept strings over 255 in a field
defined as TYPE MEMO;
despite the FAQS etc telling me to use placeholders, and to use
bind_param;
both the bind and the execute fail
Hi Jon,
Telemagic, assuming I'm talking about the same product, uses Microsoft
FoxPro as its database not dBase.
These files can be imported directly into MS Access, at least they can
into Access 97, which I just tried with.
Make sure that you specify the file type as
Microsoft F
On 8 Jul 2002, at 18:03, PARLEY,JON (HP-MountainView,e wrote:
> Is there any way to use DBI to move data in TeleMagic Database [DOS
> based v14.5] (dBase III+ compatible data file structures) to MS
> Access?
>
> What DBDs do I need?
>
> Can anyone provide a sk
On Mon, 8 Jul 2002 18:03:25 -0400 , PARLEY,JON (HP-MountainView,ex1)
wrote:
>Is there any way to use DBI to move data in TeleMagic Database [DOS based
>v14.5] (dBase III+ compatible data file structures) to MS Access?
>
>What DBDs do I need?
"dBase 3 compatible" does me
Is there any way to use DBI to move data in TeleMagic Database [DOS based
v14.5] (dBase III+ compatible data file structures) to MS Access?
What DBDs do I need?
Can anyone provide a skeleton for doing this?
Thanks.
Tim Harsch wrote:
>
> Forgive my naivity (or just flawed understanding) but how would one go
> about creating a DBD::Access? For instance DBD::Oracle is built on OCI,
> does Access have a similar network protocol? I thought that ODBC was
> about the only MS supported method of communicating to
The message further below went accidentally not to the list...
> Tim Harsch wrote:
>
> Forgive my naivity (or just flawed understanding) but how would one go
> about creating a DBD::Access? For instance DBD::Oracle is built on
> OCI, does Access have a similar network protocol? I thought that O
Actually since MDB Tools is also an ODBC driver, you could probably use
DBD::ODBC as well. Although to be honest, the SQL engine and ODBC driver
have a number of nasty bugs.
I haven't tried this arrangement myself, so buyer beware.
Brian
On 25 Jun 2002, Jeff Zucker wrote:
> Orlando Andico
With the freetds drivers you can connect directly from solaris to an
MS-Access database. I have done it many times and if you search on
google there is a webpage that tells how to do it.
keith
Jeff Zucker wrote:
> Orlando Andico wrote:
>
>> It IS possible to read MSAccess file
Orlando Andico wrote:
> It IS possible to read MSAccess files on a Linux box.
> http://mdbtools.sourceforge.net/
Hmm, I had no idea that was available, forget my advice about saving the
Access files as CSV.
At first glance it looks like it would be trivial to build an
AnyData::Format::Access
On 25 Jun 2002, Jeff Zucker wrote:
...
> Save the MS-Access file as CSV (Comma Separated Values), then on the
> Unix box, use DBD::CSV to read it directly, or else use an import
> routine for e.g. PostgresSQL or MySQL to import the CSV file into a
> different RDBMS and use the approp
> production environment.
...
> > If you want access MS Access files without connecting to a Windows
> > machine, instead just read the file, then you're out of luck. MS Access
> > files are a proprietary format based on the OLE file format (actually
> > every Access
Erick Nelson wrote:
> Ya, I saw that, I was just hoping that there was a way to do it without involving
> a Win32 box.
Save the MS-Access file as CSV (Comma Separated Values), then on the
Unix box, use DBD::CSV to read it directly, or else use an import
routine for e.g. PostgresSQL or
ple:
> <http://xmlproj.dyndns.org/faqomatic/cache/9.html>
>
> If you want access MS Access files without connecting to a Windows
> machine, instead just read the file, then you're out of luck. MS Access
> files are a proprietary format based on the OLE file format (act
I've connected my Unix machine running my Perl code to a MS Access database
using the DBI proxy modules, and all works well except that I can have
single treaded connections to the database only. This limits the size of the
application that you can support. Currently I have a script in
For example:
<http://xmlproj.dyndns.org/faqomatic/cache/9.html>
If you want access MS Access files without connecting to a Windows
machine, instead just read the file, then you're out of luck. MS Access
files are a proprietary format based on the OLE file format (actually
every Access
Below is a reply I made to someone wanted to access Oracle on NT from a
Linux box (client perl pgm). The same situation could apply to accessing MS
Access from a Unix or Linux machine. Why fool around with installing ODBC
drivers on Unix/Linux when you have a great pass-through facility like
Thanks,
But this is not being done on a Win32 box. Does anybody know how I go about
getting an ODBC driver for Sun Solaris ?
Bart Lateur wrote:
> On Mon, 24 Jun 2002 16:22:38 -0700, Erick Nelson wrote:
>
> >I've just spent the last 15 minutes looking at CPAN for a module
DBD::ADO or DBD::ODBC
Tom
On Mon, Jun 24, 2002 at 04:22:38PM -0700, Erick Nelson wrote:
> I've just spent the last 15 minutes looking at CPAN for a module to
> query a MS Access database.
> Which modules do I need to download?
> Can someone throw me a hint? :)
--
Thomas A. L
On Mon, 24 Jun 2002 16:22:38 -0700, Erick Nelson wrote:
>I've just spent the last 15 minutes looking at CPAN for a module to
>query a MS Access database.
>Which modules do I need to download?
You need DBD::ODBC.
>Can someone throw me a hint? :)
Well: first create a DSN for t
DBD::ODBC.
John
[EMAIL PROTECTED]
1 - 100 of 186 matches
Mail list logo
