Re: [PHP-DB] MS Access Connection with database password
Hi again,
It's an Access 2000 database and I've changed the password to a single a,
still no show :(
The database is downloaded on a regular basis and I need to extract some
data from it, so I have no control over version or password.
Thanks a lot
/Kjell
Richard Quadling skrev i meddelandet
news:CAKUjMCWXJfFvC_0vKq7Y4_QX-4mLumE=TOU4_v+s=yjspzq...@mail.gmail.com...
Did you read the notes regarding password length, password content and
Access version issues?
Do any of these apply to you?
I suspect one of them does.
On 4 June 2014 21:48, Kjell Hansen kj...@kejpa.com wrote:
Hi,
I'm trying to connect to a MS Access database that has a database password
set.
According to http://www.connectionstrings.com/access/ you use the
folowing as a connection string in such cases:
Provider=Microsoft.ACE.OLEDB.12.0;Data
Source=C:\myFolder\myAccessFile.accdb;
Jet OLEDB:Database Password=MyDbPassword;
Which I translate into
$dbcon = new PDO( 'odbc:Driver={Microsoft Access Driver
(*.mdb)};DBQ=C:\\exampledb.mdb;Jet OLEDB:Database Password=MyDbPassword;'
);
But it doesn't work :(
When I have removed the password, there's no problem connecting but not
with password set.
I don't make the database, it's maintained elsewhere and I plan to
download it regularly and extract data from it so I need to connect to the
database with the password set.
Any help or hints are deeply appreciated!
/Kjell
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
--
Richard Quadling
Twitter : @RQuadling
EE : http://e-e.com/M_248814.html
Zend : http://bit.ly/9O8vFY
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] MS Access Connection with database password
I think the code you translated might be for the .accdb file. In your
translated code I noticed .mdb so per that page, this apples for .mdb
With database password (mdb file)
This is the connection string to use when you have an Access 97 - 2003 database
protected with a password using the Set Database Password function in Access.
Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\myFolder\myAccessFile.mdb;
Jet OLEDB:Database Password=MyDbPassword;
Some reports of problems with password longer than 14 characters. Also that
some characters might cause trouble. If you are having problems, try change
password to a short one with normal characters.
Sent from losPhone
On Jun 6, 2014, at 1:27 PM, Kjell Hansen kj...@kejpa.com wrote:
Hi again,
It's an Access 2000 database and I've changed the password to a single a,
still no show :(
The database is downloaded on a regular basis and I need to extract some data
from it, so I have no control over version or password.
Thanks a lot
/Kjell
Richard Quadling skrev i meddelandet
news:CAKUjMCWXJfFvC_0vKq7Y4_QX-4mLumE=TOU4_v+s=yjspzq...@mail.gmail.com...
Did you read the notes regarding password length, password content and
Access version issues?
Do any of these apply to you?
I suspect one of them does.
On 4 June 2014 21:48, Kjell Hansen kj...@kejpa.com wrote:
Hi,
I'm trying to connect to a MS Access database that has a database password
set.
According to http://www.connectionstrings.com/access/ you use the
folowing as a connection string in such cases:
Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\myFolder\myAccessFile.accdb;
Jet OLEDB:Database Password=MyDbPassword;
Which I translate into
$dbcon = new PDO( 'odbc:Driver={Microsoft Access Driver
(*.mdb)};DBQ=C:\\exampledb.mdb;Jet OLEDB:Database Password=MyDbPassword;'
);
But it doesn't work :(
When I have removed the password, there's no problem connecting but not
with password set.
I don't make the database, it's maintained elsewhere and I plan to
download it regularly and extract data from it so I need to connect to the
database with the password set.
Any help or hints are deeply appreciated!
/Kjell
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
--
Richard Quadling
Twitter : @RQuadling
EE : http://e-e.com/M_248814.html
Zend : http://bit.ly/9O8vFY
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] MS Access Connection with database password
Did you read the notes regarding password length, password content and
Access version issues?
Do any of these apply to you?
I suspect one of them does.
On 4 June 2014 21:48, Kjell Hansen kj...@kejpa.com wrote:
Hi,
I'm trying to connect to a MS Access database that has a database password
set.
According to http://www.connectionstrings.com/access/ you use the
folowing as a connection string in such cases:
Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\myFolder\myAccessFile.accdb;
Jet OLEDB:Database Password=MyDbPassword;
Which I translate into
$dbcon = new PDO( 'odbc:Driver={Microsoft Access Driver
(*.mdb)};DBQ=C:\\exampledb.mdb;Jet OLEDB:Database Password=MyDbPassword;'
);
But it doesn't work :(
When I have removed the password, there's no problem connecting but not
with password set.
I don't make the database, it's maintained elsewhere and I plan to
download it regularly and extract data from it so I need to connect to the
database with the password set.
Any help or hints are deeply appreciated!
/Kjell
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
--
Richard Quadling
Twitter : @RQuadling
EE : http://e-e.com/M_248814.html
Zend : http://bit.ly/9O8vFY
RE: [PHP-DB] MS Access Connection with database password
No,
I haven't found them :( Please direct me...
Password lenght and content is not a problem (I guess!) since I tried changing
it to a simple small a without any further success.
Thanks a bunch!
/Kjell
From: Richard Quadling rquadl...@gmail.com
Sent: Thu, 5.6.2014 10:06
To: Kjell Hansen kj...@kejpa.com
Cc: php-db php-db@lists.php.net
Subject: Re: [PHP-DB] MS Access Connection with database password
Did you read the notes regarding password length, password content and Access
version issues?
Do any of these apply to you?
I suspect one of them does.
On 4 June 2014 21:48, Kjell Hansen kj...@kejpa.com wrote:
Hi,
I'm trying to connect to a MS Access database that has a database password set.
According to http://www.connectionstrings.com/access/ you use the folowing as a
connection string in such cases:
Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\myFolder\myAccessFile.accdb;
Jet OLEDB:Database Password=MyDbPassword;
Which I translate into
$dbcon = new PDO( 'odbc:Driver={Microsoft Access Driver
(*.mdb)};DBQ=C:\\exampledb.mdb;Jet OLEDB:Database Password=MyDbPassword;' );
But it doesn't work :(
When I have removed the password, there's no problem connecting but not with
password set.
I don't make the database, it's maintained elsewhere and I plan to download it
regularly and extract data from it so I need to connect to the database with
the password set.
Any help or hints are deeply appreciated!
/Kjell
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
--
Richard Quadling
Twitter : @RQuadling
EE : http://e-e.com/M_248814.html
Zend : http://bit.ly/9O8vFY
[PHP-DB] MS Access Connection with database password
Hi,
I'm trying to connect to a MS Access database that has a database password
set.
According to http://www.connectionstrings.com/access/ you use the folowing
as a connection string in such cases:
Provider=Microsoft.ACE.OLEDB.12.0;Data
Source=C:\myFolder\myAccessFile.accdb; Jet OLEDB:Database
Password=MyDbPassword;
Which I translate into
$dbcon = new PDO( 'odbc:Driver={Microsoft Access Driver
(*.mdb)};DBQ=C:\\exampledb.mdb;Jet OLEDB:Database Password=MyDbPassword;' );
But it doesn't work :(
When I have removed the password, there's no problem connecting but not with
password set.
I don't make the database, it's maintained elsewhere and I plan to download
it regularly and extract data from it so I need to connect to the database
with the password set.
Any help or hints are deeply appreciated!
/Kjell
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] MS Access, FoxPro and PHP
Is anyone using MS Access, FoxPro or any other file-based database via ODBC with PHP? -- bob -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP-DB] MS Access, FoxPro and PHP
Robert, I can not help directly but until you get a helpful response here you could try a Google Groups search. http://groups.google.com/groups?safe=imagesie=UTF-8oe=UTF-8as_ugroup=*access*as_usubject=php%20odbclr=hl=en Go to http://groups.google.com click on Advanced search for Newsgroup enter: *access* Subject enter: php odbc howard grämer New York City [EMAIL PROTECTED] From: Robert Twitty [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: [PHP-DB] MS Access, FoxPro and PHP Date: Tue, 2 Dec 2003 09:55:08 -0500 (EST) Is anyone using MS Access, FoxPro or any other file-based database via ODBC with PHP? -- bob _ Share holiday photos without swamping your Inbox. Get MSN Extra Storage now! http://join.msn.com/?PAGE=features/es -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] MS Access DSN for PEAR DB::connect
Hi!Does anyone know what DSN I must use to get connected to my MS Access database? BUSINESS is my OBDC connection on Windows 2000 to my database. As PHP database type I use 'odbc'. Please find the enclosed code snipet: getMessage());} ? When running it, I receive an DB Error: connect failed. Unfortunately with same result, I tried the following DSN:$dsn = odbc:///BUSINESS; $dsn = odbc://localhost/BUSINESS; $dsn = odbc://[EMAIL PROTECTED]/BUSINESS; $dsn = odbc://[EMAIL PROTECTED]/BUSINESS; $dsn = odbc://[EMAIL PROTECTED]/BUSINESS; Any hints from you are very welcome, regards, bjoon - Do you Yahoo!? The New Yahoo! Search - Faster. Easier. Bingo.
[PHP-DB] MS Access DSN for PEAR DB::connect
Sorry, the first email was unreadable, Here again!
pDoes anyone know what DSN I must use to get connected to my MS Access database?/p
p BUSINESS is my OBDC connection on Windows 2000 to my
database. As PHP database type I use 'odbc'. /p
p
?php require_once('DB.php');
$dsn = odbc:///BUSINESS;
$db = DB::connect($dsn);
if (DB::isError($db)) {
die ($db-getMessage());
}
?
/p
p
I tried the following DSN, unfortunately with same result:
$dsn = odbc:///BUSINESS; $dsn = odbc://localhost/BUSINESS; $dsn =
odbc://[EMAIL PROTECTED]/BUSINESS; $dsn =
odbc://[EMAIL PROTECTED]/BUSINESS; $dsn = odbc://[EMAIL PROTECTED]/BUSINESS;
/p
p
Any hints from you are very welcome, regards, bjoon
/p
-
Do you Yahoo!?
The New Yahoo! Search - Faster. Easier. Bingo.
[PHP-DB] MS Access
Hi Has anyone got a sample script that updates/adds and deletes records on an ms access database or can point me to a resource that will have one? Regards Steve Dodkins IMPORTANT NOTICE The information in this e-mail is confidential and should only be read by those persons to whom it is addressed and is not intended to be relied upon by any person without subsequent written confirmation of its contents. ebm-ZIEHL (UK) Ltd. cannot accept any responsibility for the accuracy or completeness of this message as it has been transmitted over a public network. Furthermore, the content of this e-mail is the personal view of the sender and does not represent the advice, views or opinion of our company. Accordingly, our company disclaim all responsibility and accept no liability (including in negligence) for the consequences of any person acting, or refraining from acting, on such information prior to the receipt by those persons of subsequent written confirmation. In particular (but not by way of limitation) our company disclaims all responsibility and accepts no liability for any e-mails which are defamatory, offensive, racist or in any other way are in breach of any third party's rights, including breach of confidence, privacy or other rights. If you have received this e-mail message in error, please notify me immediately by telephone. Please also destroy and delete the message from your computer. Any form of reproduction, dissemination, copying, disclosure, modification, distribution and/or publication of this e-mail message is strictly prohibited. If you have received this E-mail in error, or suspect that the message may have been intercepted or amended, please notify ebm-ZIEHL (UK) Ltd on +44(0)1245 468555. ebm-ZIEHL (UK) Ltd Chelmsford Business Park, Chelmsford, Essex CM2 5EZ -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] MS Access Connectivity
Hi I have a problem connecting to ms access over a network as follows. I have set up the system dsn with the correct path, I use odbc_connect( dsn, user, pwd ); to connect. I get a sql error [odbc Microsoft Access Driver] '(unknown)' is not a valid path sql state S1009 in sqlConnect ... If i copy the db to the local drive and amend the system dsn to map to the local drive it works, MS Excel can also connect to the db over the network. Any ideas? Regards Steve Dodkins IMPORTANT NOTICE The information in this e-mail is confidential and should only be read by those persons to whom it is addressed and is not intended to be relied upon by any person without subsequent written confirmation of its contents. ebm-ZIEHL (UK) Ltd. cannot accept any responsibility for the accuracy or completeness of this message as it has been transmitted over a public network. Furthermore, the content of this e-mail is the personal view of the sender and does not represent the advice, views or opinion of our company. Accordingly, our company disclaim all responsibility and accept no liability (including in negligence) for the consequences of any person acting, or refraining from acting, on such information prior to the receipt by those persons of subsequent written confirmation. In particular (but not by way of limitation) our company disclaims all responsibility and accepts no liability for any e-mails which are defamatory, offensive, racist or in any other way are in breach of any third party's rights, including breach of confidence, privacy or other rights. If you have received this e-mail message in error, please notify me immediately by telephone. Please also destroy and delete the message from your computer. Any form of reproduction, dissemination, copying, disclosure, modification, distribution and/or publication of this e-mail message is strictly prohibited. If you have received this E-mail in error, or suspect that the message may have been intercepted or amended, please notify ebm-ZIEHL (UK) Ltd on +44(0)1245 468555. ebm-ZIEHL (UK) Ltd Chelmsford Business Park, Chelmsford, Essex CM2 5EZ -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] MS Access - default value in create table
I can create tables and perform alterations just fine. However, if I try to specify a DEFAULT value in either CREATE TABLE or ALTER TABLE, it craps out on me. For example, this works ALTER TABLE phpbb_mytable ALTER COLUMN LastName TEXT(40) ...but this doesn't ALTER TABLE phpbb_mytable ALTER COLUMN LastName TEXT(40) DEFAULT Unknown ...even though I believe this is the correct syntax. Same thing happens for CREATE TABLE. Help!!! Thanks, -Nuttzy -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP-DB] MS Access DB Open as file ?
Hi Ivan, Check out the ODBC chapter in Professional PHP4 (Wrox Press) and also read the PHP HOWTO at www.iodbc.org for an explanation of ODBC in PHP - the short answer to your question can I connect to Access is maybe. A lot of it depends on your platform and available drivers. Best regards, Andrew Hill Director of Technology Evangelism OpenLink Software http://www.openlinksw.com Universal Data Access Virtuoso Universal Server -Original Message- From: Ivan Lam [mailto:[EMAIL PROTECTED]] Sent: Friday, June 07, 2002 11:24 PM To: [EMAIL PROTECTED] Subject: [PHP-DB] MS Access DB Open as file ? Hi All, I'm new in PHP and I whether I can open a MS Access database file directly with PHP? There is a thing called ODBC but in the function odbc_connect(), The first parameter is something called dsn, what's that? And does that mean I can't open the MS Access database directly by somehow only giving it's path? Thanks. Ivan -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] MS Access DB Open as file ?
Hi All, I'm new in PHP and I whether I can open a MS Access database file directly with PHP? There is a thing called ODBC but in the function odbc_connect(), The first parameter is something called dsn, what's that? And does that mean I can't open the MS Access database directly by somehow only giving it's path? Thanks. Ivan -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] MS Access Error
Hello,
I'm just beginning experimenting with MS Access and PHP. I found all the
tutorials online that explain how to create a DSN for my existing Access
database, and went through the procedure fine. The DSN I chose is
prototype and the database does not have a username or password. I then
created a very simple script:
HTML
HEAD
TITLEAccess connection/TITLE
BODY
?php
#Open a connection to an access database
$connection = odbc_connect(prototype,,);
if ($connection){
echo Connection establishedbr\n;
} else {
echo Connection NOT establishedbr\n;
}
?
When running this file, I get the following output:
Warning: SQL error: [Microsoft][ODBC Microsoft Access Driver] The Microsoft
Jet database engine cannot open the file '(unknown)'. It is already opened
exclusively by another user, or you need permission to view its data., SQL
state S1000 in SQLConnect in D:\www\Lalli\php\access.php on line 7
Connection NOT established
The server is running MS WinNT 4.0 SP6, with PHP 4.0. Can anyone help me
out?
Thank you,
Paul Lalli
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
[PHP-DB] Ms-Access to Mysql converter
can anyone tell me which is a good Ms-Access to MySQL converter under open source /demo /commercial/etc. -TIA Sharmad -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
Re: [PHP-DB] Ms-Access to Mysql converter
On Thu, 1 Nov 2001 16:17:38 +0550 [EMAIL PROTECTED] wrote: Most of them availalbe in the downloads section of mysql.com : http://www.mysql.com/downloads/contrib.html Look at the sections clients, converter and using MySql with Other Products hth pa -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
RE: [PHP-DB] MS Access and MySQL
BDY.RTF -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
