n J. Evans <martin.ev...@easysoft.com
<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
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
+44-7440 56 12 32
From: Ismail Chamseddine <ismail.chamsedd...@gmail.com>
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
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
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
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
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://www.easysoft.com
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
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
How can I list all of the table names in an access database?
Thanks,
Scott Berthold
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
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 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 = #4/5/2004 5:3:45
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:
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 to
recognise the 1st
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 to
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 modules, IIS on XP.
Here is the error
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.
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 now
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 your
, April 08, 2005 8:07 PM
To: Moreno, Javier; dbi-users@perl.org
Subject: Re: Accessing MS Access
From: Moreno, Javier [EMAIL PROTECTED]
Date: 2005/04/08 Fri PM 03:44:40 CDT
snip
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
On Apr 11, 2005 12:35 PM, Moreno, Javier [EMAIL PROTECTED] wrote:
Ok. I have tried ADO as well with no luck. Please help!
snip
# Include CPAN modules for DB communication
use DBI;
#use DBD::ODBC;
use DBD::ADO;
#use Win32::OLE;
# Use these pragmas to code correctly
use strict;
#
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!
snip
my ($path_to_mdb_file) = '\\slpmxwtstandclu\testdata$\Data_2.mdb';
Aha!
You are
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
From: Moreno, Javier [EMAIL PROTECTED]
Date: 2005/04/08 Fri PM 03:44:40 CDT
snip
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.
snip
I was wondering if there is a better way to get information
from
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?
If
, 2005 6:45 PM
To: Moreno, Javier
Cc: dbi-users@perl.org
Subject: Re: Accessing MS Access through the DBI ODBC
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
, Javier
Cc: dbi-users@perl.org
Subject: Re: Accessing MS Access through the DBI ODBC
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
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 =
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
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
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. Create an ODBC connection via
DBI users group,
Ive 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
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 do this? That's a file
that's used
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 cant complete the
formatting step. I have the shell of a read/format program below, which
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
records that look
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
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)
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
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 = DBI-connect(dbi:ODBC:$ARGV[0
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 message
news:[EMAIL PROTECTED]
Look in the docs
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 LongTruncOK
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 have specified that better in your
original posting
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 size 255 in MS ACCESS DB
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.
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 Microsoft
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, 'MMDD
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
, 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
for MS Access databases, but it also can easily run stored queries using
prepared statements. It also is the best
Message-
From: Tim Bunce [mailto:[EMAIL PROTECTED]
Sent: Tuesday, June 25, 2002 2:18 PM
To: Jeff Zucker
Cc: Orlando Andico; DBI-Users; dbi-dev; [EMAIL PROTECTED]
Subject: Re: MS Access
On Tue, Jun 25, 2002 at 10:27:20AM -0700, Jeff Zucker wrote:
Orlando Andico wrote
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 MS SQL Server, Visual Foxpro and any other Win32
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 the SQL-code used by MS access itself (creating a query at the
MS access
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();
Try to run the
://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 to MS Access using DBI and DBD::ODBC
I can read my
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 ActiveState
DBD-ODBC v
1.06 from ActiveState
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/2003
http
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
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
: 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've used PPM install DBI. I'm using
this code:
Did
]
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 using
this code:
Did you install DBD-ODBC?
#
# Perl script that talks with the Northwinds database using
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...No...no, not
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 actually use your DataBase Driver
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 = 1,
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;
my
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 could
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.
: 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 believe data
can
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-errstr;
.
But I get this error:
install_driver
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
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
You don't
, 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 the table that I
had been
trying
to write to before had been created manually in MS Access
(Tables-new-DesignView and entering
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 for the reply
Please always keep the dbi-users mailing list on the mails. Others can
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 did find another of your answers
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
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 FoxPro
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.
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 mean, DBF files, doesn't
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 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
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
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 files on a Linux box
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
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? :)
DBD::ODBC.
John
[EMAIL PROTECTED]
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 the database using
and apache, I took on a task of trying to set up a web
application to cut my teeth. The existing application has proven all too
successful and the user population has outgrown MS Access. An Oracle server
is in the works, but until then, I need to get it up and running using MS
Access.
I Know
-Access security?
Does the web server user have access to the admin database?
Regards,
Jeff
-Original Message-
From: MacGown, Peter [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, March 12, 2002 10:05 AM
To: [EMAIL PROTECTED]
Subject: RE: MS Access/CGI/Apache on WinNT questions
Jeff
To: MacGown, Peter; [EMAIL PROTECTED]
Subject: RE: MS Access/CGI/Apache on WinNT questions
Pete,
Right before the connect, do the following:
DBI-trace(5, c:/trace.txt);
Then, send me the trace.txt from the web server's C: drive. (and, look at
it yourself to see if the error is recognizable
Jeff,
In answer to your other questions:
What version of DBD::ODBC are you using?
PPMquery DBI
DBI [1.201] Database independent interface for Perl
Are you using MS-Access security?
I am not using mdw files, if that is what you mean, but I do have
the mdb file
To: [EMAIL PROTECTED]
Subject: RE: MS Access/CGI/Apache on WinNT questions
Hi Jeff:
This is a snippet of the code:
use DBI;
my $dsn = driver=Microsoft Access Driver
(*.mdb);dbq=nrent01\\fssdata\\Roster03b.mdb;
DBI-trace(5, c:/trace.txt);
my $dbh = DBI-connect
-Original Message-
From: Jeff Urlwin [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, March 12, 2002 1:32 PM
To: MacGown, Peter; [EMAIL PROTECTED]
Subject: RE: MS Access/CGI/Apache on WinNT questions
What version of DBD::ODBC are you using?
PPM query ODBC
DBD-ODBC [0.28
: MacGown, Peter [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, March 12, 2002 1:59 PM
To: 'Jeff Urlwin'; [EMAIL PROTECTED]
Subject: RE: MS Access/CGI/Apache on WinNT questions
-Original Message-
From: Jeff Urlwin [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, March 12, 2002 1:32 PM
-Original Message-
From: MacGown, Peter [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, March 12, 2002 1:59 PM
To: 'Jeff Urlwin'; [EMAIL PROTECTED]
Subject: RE: MS Access/CGI/Apache on WinNT questions
-Original Message-
From: Jeff Urlwin [mailto:[EMAIL PROTECTED]]
Sent: Tuesday
:\tmp and then install
c:\tmp\DBI.ppd, etc
Let me know if you have issues.
Thanks,
Jeff
-Original Message-
From: MacGown, Peter [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, March 12, 2002 5:11 PM
To: 'Jeff Urlwin'; [EMAIL PROTECTED]
Subject: RE: MS Access/CGI/Apache on WinNT questions
Hi,
I hope other people have been successful at getting CGI scripts running that
access MS Access because I haven't. Here is a snippet of code that I am
trying to get to work:
#!d:/perl/bin/perl -wT
use DBI;
my $dsn = driver=Microsoft Access Driver
(*.mdb);dbq=nrent01\\fssdata
CGI scripts
running that
access MS Access because I haven't. Here is a snippet of code that I am
trying to get to work:
#!d:/perl/bin/perl -wT
use DBI;
my $dsn = driver=Microsoft Access Driver
(*.mdb);dbq=nrent01\\fssdata\\Roster03b.mdb;
my $dbh = DBI-connect(DBI:ODBC:$dsn,admin,xyzzy
Hello,
I'm trying to insert image data into an OLE field in MS Access database
without success. I treat the image as a long binary field so if a 10k
jpeg file is inserted, it remains at 10k in the database... not the
bloated several hundred k or more that doing an 'insert object' produces
within
1 - 100 of 156 matches
Mail list logo