[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 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: Access connection \n"; } else { echo "Connection NOT established\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 and MySQL
This join works perfectly in Access but if I use the same query in MySQL it shits it's pants. SELECT [tbl_medien].[titel], [tbl_medien].[ausgabe], [tbl_medien].[URL], [tbl_medien].[medientypID], [tbl_autor].[name], [tbl_autor].[vorname] FROM tbl_medien INNER JOIN (tbl_autor INNER JOIN tbl_zuordnung_autoren_medien ON [tbl_autor].[autorenID]=[tbl_zuordnung_autoren_medien].[autorenID]) ON [tbl_medien].[medienID]=[tbl_zuordnung_autoren_medien].[medienID] WHERE ((([tbl_medien].[medientypID])='$medium')); Thanks, Patrick Patrick Schäfer magna moliri Projektmanagementgesellschaft mbH & Co.KG Hanauer Landstraße 184 60314 Frankfurt am Main Telefon ++49 (0)69 / 904 322-0 Mobil ++49 (0)171 / 9928016 Fax ++49 (0)69 / 904 322-200 [EMAIL PROTECTED] -- 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]
[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]
[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
[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
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, 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=images&ie=UTF-8&oe=UTF-8&as_ugroup=*access*&as_usubject=php%20odbc&lr=&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 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
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 - 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
[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! 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'. getMessage()); } ?> 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"; Any hints from you are very welcome, regards, bjoon - Do you Yahoo!? The New Yahoo! Search - Faster. Easier. Bingo.
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 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" Sent: Thu, 5.6.2014 10:06 To: "Kjell Hansen" Cc: php-db 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 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
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 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" 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 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 >