create and try, please
suggest some a/c to create, and I'll do that see if that eliminate the
error.
Thanks.
Samuel
- Original Message -
From: "Jenda Krynicky" <[EMAIL PROTECTED]>
To:
Sent: Wednesday, August 01, 2007 3:54 PM
Subject: Re: dbi access ODBC
Hi Marti
> Hi Martin,
>
> you directed me to an article by microsotf to fix an error which is
> caused when my perl script access a access97 file.The article tell to
> chk the windows temp folders. that time I got the problem fixed on my
> XP machine. This time, I am having the same error on a windows serv
Hi Martin, the error is different this time. It said SQL-42000, please help!
- Original Message -
From: Samuel_Zheng
To: dbi-users@perl.org
Sent: Tuesday, July 31, 2007 11:04 PM
Subject: dbi access ODBC
Hi Martin,
you directed me to an article by microsotf to fix an error which is
Hi Martin,
you directed me to an article by microsotf to fix an error which is caused when
my perl script access a access97 file.The article tell to chk the windows temp
folders. that time I got the problem fixed on my XP machine. This time, I am
having the same error on a windows server 2003.
On reflection, I think the right fix for this (apart from fixing
DBD::mysql to support the ParamValues attribute if the latest one
doesn't) is to store the information in a private attribute and
use an overridden FETCH method to return that value.
Tim.
On Wed, Feb 23, 2005 at 09:23:42AM +, Go
It's a DBI bug (or at least mis-feature) that I'll fix for the next
release.
Meanwhile a workaround is to bypass the implicit tie STORE method
and store the attribute directly into the hash. This is probably
the simplest way (untested):
tied(%$sth)->{ParamValues} = \%ParamValues;
Tim.
On Wed
Hi,
I'm trying to subclass DBI, but I'm having problems accesing DBI::st
attributes. Say I want to override the DBI::st::execute() function to
add the ParamValues attribute contents that is missing with using the
MySQL driver.
sub execute
{
my $Self= shift;
my @Bound
They correct syntax for ODBC is:
{ts '-MM-DD HH:MM:SS'}
Jeff
> -Original Message-
> From: Mark Riehl [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, April 30, 2002 9:36 PM
> To: [EMAIL PROTECTED]
> Subject: DBI, Access, and DATETIME
>
>
> All -
All - I'm trying to use DBI to read a MS Access db. One of the columns in
the DB is a Date/Time type. I'm trying to query on a range of times.
The following works in MySQL off the command line where S_TIME is a DATETIME
column, so I thought the MS Access call would be the same:
select * from s
racle docs.
Ilya
-Original Message-
From: Nicolas MENANT
To: [EMAIL PROTECTED]
Sent: 3/5/02 7:05 AM
Subject: DBI + access oracle accross SQLNET server
I'm looking for a way to create a perl script which test the oracle
database accross SQLNet Server
It seems possible with this modu
I'm looking for a way to create a perl script which test the oracle database accross
SQLNet Server
It seems possible with this module but i prefer to be sure...i'm short in time that's
why i don't push my research further and prefer ask now...
So can anyone confirm me that's possible?
If yes
I'm looking for a way to create a perl script which test the oracle database accross
SQLNet Server
It seems possible with this module but i prefer to be sure...i'm short in time that's
why i don't push my research further and prefer ask now...
So can anyone confirm me that's possible?
If yes
Look at comments below.
-Original Message-
From: Tim Scott
To: Trevor Webster
Cc: DBI Users
Sent: 05/30/2001 2:09 AM
Subject: Re: DBI -> Access
Thanks for your input on this guys. Here's some more information which
might
help, but I think it precludes these problems...
Th
Thanks for your help.
Tim
- Original Message -
From: "Tim Scott" <[EMAIL PROTECTED]>
To: "DBI Users" <[EMAIL PROTECTED]>
Sent: Wednesday, May 30, 2001 9:43 AM
Subject: Re: DBI -> Access
>
> Some further fiddling found a problem with 'workdate'. I
om: "Tim Scott" <[EMAIL PROTECTED]>
To: "Trevor Webster" <[EMAIL PROTECTED]>
Cc: "DBI Users" <[EMAIL PROTECTED]>
Sent: Wednesday, May 30, 2001 9:09 AM
Subject: Re: DBI -> Access
>
> Thanks for your input on this guys. Here's some more inf
so it was able to support what
you're
>doing. DBI can't solve the problem. You can probably accomplish what you
need
>to while still using Access, if you break up your operation into smaller
>queries, or only update one table at a time.
>
>HTH.
>
>Wes
- Original
into smaller
queries, or only update one table at a time.
HTH.
Wes
"Tim Scott" <[EMAIL PROTECTED]> on 05/29/2001 12:16:38
PM
To: "DBI Users" <[EMAIL PROTECTED]>
cc:(bcc: Wesley Sheldahl/Lex/Lexmark)
Subject: DBI -> Access
All,
New to Access
All,
New to Access I'm finding:-
[Microsoft][ODBC Microsoft Access Driver] Operation must use an updateable
query. (SQL-S1000)(DBD: st_execute/SQLExecute err=-1)
And thinking "how do I tell it that it's an updateable query?"
The same sort of thing worked fine with Oracle...
Any help appreciate
host in connect.
> -Original Message-
> From: Simon Chan [SMTP:[EMAIL PROTECTED]]
> Sent: Friday, May 25, 2001 9:43 PM
> To: [EMAIL PROTECTED]
> Subject: DBI access from a CGI script
>
> Hey all,
>
> Using a CGI script, I want to access a database from A
[EMAIL PROTECTED]]
Sent: Saturday, May 26, 2001 12:43 AM
To: [EMAIL PROTECTED]
Subject: DBI access from a CGI script
Hey all,
Using a CGI script, I want to access a database from A DIFFERENT server than
the mysql database is
hosted. What is the proper syntax to access the mysql database on a
diffe
Hey all,
Using a CGI script, I want to access a database from A DIFFERENT server than the mysql
database is
hosted. What is the proper syntax to access the mysql database on a different server?
They're 2 levels of secruity:
1. Log into Telnet shell
2. Log into database
This is what I have der
21 matches
Mail list logo
