Re: [PHP-DB] MS Access Connection with database password

2014-06-06 Thread Kjell Hansen
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

Re: [PHP-DB] MS Access Connection with database password

2014-06-06 Thread Karl DeSaulniers
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

Re: [PHP-DB] MS Access Connection with database password

2014-06-05 Thread Richard Quadling
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

RE: [PHP-DB] MS Access Connection with database password

2014-06-05 Thread Kjell Hansen
...@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

[PHP-DB] MS Access Connection with database password

2014-06-04 Thread Kjell Hansen
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

[PHP-DB] MS Access, FoxPro and PHP

2003-12-02 Thread Robert Twitty
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

2003-12-02 Thread howard gramer
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

[PHP-DB] MS Access DSN for PEAR DB::connect

2003-06-03 Thread Bita Jooooooon
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.

[PHP-DB] MS Access DSN for PEAR DB::connect

2003-06-03 Thread Bita Jooooooon
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 =

[PHP-DB] MS Access

2002-10-18 Thread Steve Dodkins
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

[PHP-DB] MS Access Connectivity

2002-10-09 Thread Steve Dodkins
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 ...

[PHP-DB] MS Access - default value in create table

2002-07-15 Thread Nuttzy
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

RE: [PHP-DB] MS Access DB Open as file ?

2002-06-18 Thread Andrew Hill
, 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

[PHP-DB] MS Access DB Open as file ?

2002-06-07 Thread Ivan Lam
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

[PHP-DB] MS Access Error

2001-11-13 Thread Paul Lalli
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

[PHP-DB] Ms-Access to Mysql converter

2001-11-01 Thread sharmad
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

Re: [PHP-DB] Ms-Access to Mysql converter

2001-11-01 Thread Pierre-Alain Joye
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

RE: [PHP-DB] MS Access and MySQL

2001-03-12 Thread Allsebrook_Richard/askr
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]