Re: MS access

On 02/11/15 07:51, Ismail Chamseddine wrote: I am using Active Perl 5.18.4 64 bit on Windows 7 64 bit The connect string code my $dbh = DBI->connect('dbi:ODBC:driver=microsoft access driver (*.mdb); database= C:\Users\User\Documents\Mydb.accdb'); On Fri, Oct 30, 2015 at 4:07 PM, Martin J.

Re: MS access

Ismail, Not much information to answer your query. However, please refer below link for debug, http://www.easysoft.com/support/kb/kb01039.html [http://www.easysoft.com/style/images/easysoft_logo.png] Why do I get error "Data source name not

Re: MS access

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.

Re: MS ACCESS text field truncated

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

RE: MS ACCESS text field truncated

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

RE: MS ACCESS text field truncated

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.

Re: MS ACCESS text field truncated

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,

RE: MS ACCESS text field truncated

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

RE: MS Access 2002, DBI ODBC and Unicode

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,

Re: MS Access

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

Re: MS Access

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

Re: MS Access

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.

Re: MS Access

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

Re: MS Access

DBD::ODBC. John [EMAIL PROTECTED]

Re: MS Access

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 the

RE: MS Access/CGI/Apache on WinNT questions

; [EMAIL PROTECTED] Subject: RE: MS Access/CGI/Apache on WinNT questions That, unfortunately, can be a bad message because of the way that DBD::ODBC handles opening the database. What's happening is that DBI can't open the database using the DSN-less style open (SQLDriverConnect) which fails

RE: MS Access/CGI/Apache on WinNT questions

-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

RE: MS Access/CGI/Apache on WinNT questions

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

RE: MS Access/CGI/Apache on WinNT questions

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

RE: MS Access/CGI/Apache on WinNT questions

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

RE: MS Access/CGI/Apache on WinNT questions

-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

RE: MS Access/CGI/Apache on WinNT questions

: 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

RE: MS Access/CGI/Apache on WinNT questions

-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

RE: MS Access/CGI/Apache on WinNT questions

:\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

RE: MS Access/CGI/Apache on WinNT questions

That, unfortunately, can be a bad message because of the way that DBD::ODBC handles opening the database. What's happening is that DBI can't open the database using the DSN-less style open (SQLDriverConnect) which fails and then tries to call SQLConnect, which expects a 32? character or less

Re: Fw: RE: MS Access file - accessing from Linux?

About-tw.com §K¶O¤H¤O»È¦æ wrote: You should use the openlink sdk connect to windows.Use the Multi-tie version of oprnlink software and SDK. Download the l3br.taz ,l3ko.taz ,l3kuz.taz ,l3oc.taz and install.sh for linux.And remeber setup the $ENV before you make. Download

Re: MS Access Too Few Parameters Error Help

On Thu, 01 Nov 2001 11:03:56 -0800, Alan Hogue wrote: I am trying to execute an update to an Access database. The statement has two placeholders, and I put two variables between the parentheses in the execute statement, and yet Access tells me it expects 3 parameters. This behaviour has had me

RE: MS Access Driver for Linux

Please review the dbi-users mailing list archives. There are plenty of answers to this and similar questions there. The short answer is that there is no direct Linux driver for MS Access. You can: use DBI proxy and have DBI installed on an NT machine use EasySoft's ODBC bridge

RE: MS-Access, timestamp, input/update problems

Following situation: I'm using DBI and MS-Access, and my tables contain timestamp fields. I have a number of variables that need to either be inputted or updated into the table, and my statement looks like this: #Update: $state = update table set var1 = ?, var2 = ? where primkey = ? ;

RE: MS Access

Try using DBI::Proxy -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: 01 June 2001 11:20 To: [EMAIL PROTECTED] Subject: MS Access Dear Friends, I would like to access Microsoft Access database file ie .mdb, through perl under Unix/ Linux

Re: MS Access

On Fri, 1 Jun 2001 15:50:04 +0530 (IST), Suresh Kannan wrote: I would like to access Microsoft Access database file ie .mdb, through perl under Unix/ Linux platform. Please guide me whether this is possible or not with some resources. Not directly. You can connect to a Windows machine which

RE: MS Access

I hope you plan on having Access on win32 :-) If you want to access the Access db on win32 from Unix/Linux, must install third party ODBC software and connect through DBD::ODBC. You can also use DBD::Proxy/DBI::ProxyServer. Ilya Sterin -Original Message- From: Suresh Kannan To:

Re: MS Access

Install DBI Install DBD-ODBC Use a DSNLess Connction On Fri, 1 Jun 2001 15:50:04 +0530 (IST), Suresh Kannan wrote: I would like to access Microsoft Access database file ie .mdb, through perl under Unix/ Linux platform. Please guide me whether this is possible or not with some

RE: MS ACCESS Date Fields

I'm not positive if your actual statement looks like your model you gave to us, but the main thing I see wrong with your model is how you are using BETWEEN. If you have the Northwind Traders example database, here is an example query to do basically the same thing: SELECT * FROM Orders

RE: MS Access

ccess db. my $dbh = DBI-connect($database,$db_user,$db_password); You should be there. Steve Howard -Original Message- From: Michael A. Chase [mailto:[EMAIL PROTECTED]] Sent: Monday, March 19, 2001 2:06 PM To: Alex; [EMAIL PROTECTED] Subject: Re: MS Access Microsoft provides O

Re: MS Access

Microsoft provides ODBC drivers for Access. That should mean you can use DBD::ODBC with DBI to work with Access. Exactly how useful this is for you depends on you platform. Without knowing what you have already tried, and what problems you had, it will be difficult for anyone on the list to

RE: MS Access

-Original Message- From: Michael A. Chase [mailto:[EMAIL PROTECTED]] Sent: Monday, March 19, 2001 2:06 PM To: Alex; [EMAIL PROTECTED] Subject: Re: MS Access Microsoft provides ODBC drivers for Access. That should mean you can use DBD::ODBC with DBI to work with Access. Exactly how useful