473,373 Members | 1,188 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,373 software developers and data experts.

Pear and ODCB Access DSNs?

Having issues with a Pear DSN for odbc Microsoft access. The Manual
is not too helpful and the best one I can find is

odbc///map

where map is the ODBC DSN name.

Or does one need to create a DSN string like

dbc(access)://tcp()driver=Microsoft Access Driver
(*.mdb);dbq=C:\\htdocs\\map.mdb"

Both do not work and result in a "not found" error.

Also, this works with the PHP ODBC commands, so I know that the DSN is
correctly set up

Thanks

Sep 13 '05 #1
1 1765
Hello,

on 09/13/2005 04:46 PM David said the following:
Having issues with a Pear DSN for odbc Microsoft access. The Manual
is not too helpful and the best one I can find is

odbc///map

where map is the ODBC DSN name.

Or does one need to create a DSN string like

dbc(access)://tcp()driver=Microsoft Access Driver
(*.mdb);dbq=C:\\htdocs\\map.mdb"

Both do not work and result in a "not found" error.

Also, this works with the PHP ODBC commands, so I know that the DSN is
correctly set up


I don't know about PEAR DB because I do not use it, but you can use
Metabase PHP database abstraction package that has an MS Access driver
via ODBC that lets you connect to Access databases by specify the ODBC
DNS as the User argument of Metabase connection setup:

http://www.phpclasses.org/metabase
--

Regards,
Manuel Lemos

PHP Classes - Free ready to use OOP components written in PHP
http://www.phpclasses.org/

PHP Reviews - Reviews of PHP books and other products
http://www.phpclasses.org/reviews/

Metastorage - Data object relational mapping layer generator
http://www.meta-language.net/metastorage.html
Sep 13 '05 #2

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

0
by: Analysis&Solutions | last post by:
Greetings: Crack open the beer, PEAR DB 1.6.0 is here! (Hey, I'm a bit giddy with excitement that my intense work during the past seven weeks has come to fruition.) For those unfamiliar with...
6
by: NotGiven | last post by:
My hosting company has pre-intalled PEAR in a directory out of the web directory (and not in php-includes). I've tried including the absolute /to/path/ in the requre statement but it does not...
9
by: Earl Partridge | last post by:
Windows XP, Frontpage 2000, IIS 5.1, Access 2000 When I attempt to open a connection to my database I get an error the page cannot be found... this on my local machine, using localhost. The page...
0
by: Matthew Wells | last post by:
Good morning... I have an Access front end that uses SQL Server linked tables. SQL Server uses Windows authentication. I have one Windows group that all Access users are a member of. I added...
2
by: Matthew Wells | last post by:
Good morning... I have an Access front end that uses SQL Server linked tables. SQL Server uses Windows authentication. I have one Windows group that all Access users are a member of. I added...
0
by: Lewt | last post by:
I am aware of the 'hack the registry' approach. This is just not a safe way to accomplish this on a user's PC. I need to do this the right way. Is there anyone -perhaps from Microsoft - out there...
9
by: Mitchell Vincent | last post by:
I would like to start a discussion of what everyone is using as an embedded application database with .NET - specifically VB.NET. The MSDE package is *far* to huge to be of any real use at over...
1
by: webguynow | last post by:
I've installed PEAR in my local area, on my shared host, under htdocs but I'm anticipating a number of issues. I'm forcing use of PHP5 with an .htaccess file, but by default the host runs ...
5
by: Jim Michaels | last post by:
I downloaded a PEAR module, but it came with this XML file and a PHP file. I figure I just include the PHP file somehow, but what do I do with the XML file?
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...
0
by: ryjfgjl | last post by:
In our work, we often need to import Excel data into databases (such as MySQL, SQL Server, Oracle) for data analysis and processing. Usually, we use database tools like Navicat or the Excel import...
0
by: taylorcarr | last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: aa123db | last post by:
Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.