How to enable PDO-ODBC on Ubuntu + XAMPP in order to connect to MS-Access DB?
I want to use a mdb Access Database with PHP 7.2 on Ubuntu 18 + XAMPP. So I've installed the following packages, although not all of them may be required:
sudo apt install php7.2-odbc
sudo apt install libodbc1
sudo apt install unixodbc
sudo apt install unixodbc-dev
sudo apt install odbc-mdbtools
sudo apt install tdsodbc
After the installation odbc is still not listed as below shown:
php -i | grep PDO
PDO
PDO support => enabled
PDO drivers => mysql, pgsql, sqlite
PDO Driver for MySQL => enabled
PDO Driver for PostgreSQL => enabled
PDO Driver for SQLite 3.x => enabled
So the following entries are missing, as described here:
PDO drivers => mysql, odbc
PDO_ODBC
PDO Driver for ODBC (unixODBC) => enabled
I've restarted the machine and apache, nothing could help.
So, how can I enable PDO-ODBC on Ubuntu + XAMPP in order to connect to MS-Access DB?
I hope, someone can help.
Thanks in advance
Beste regards
Asg
php odbc
asked Dec 9 at 16:43
Asg
11
add a comment |
I want to use a mdb Access Database with PHP 7.2 on Ubuntu 18 + XAMPP. So I've installed the following packages, although not all of them may be required:
sudo apt install php7.2-odbc
sudo apt install libodbc1
sudo apt install unixodbc
sudo apt install unixodbc-dev
sudo apt install odbc-mdbtools
sudo apt install tdsodbc
After the installation odbc is still not listed as below shown:
php -i | grep PDO
PDO
PDO support => enabled
PDO drivers => mysql, pgsql, sqlite
PDO Driver for MySQL => enabled
PDO Driver for PostgreSQL => enabled
PDO Driver for SQLite 3.x => enabled
So the following entries are missing, as described here:
PDO drivers => mysql, odbc
PDO_ODBC
PDO Driver for ODBC (unixODBC) => enabled
I've restarted the machine and apache, nothing could help.
So, how can I enable PDO-ODBC on Ubuntu + XAMPP in order to connect to MS-Access DB?
I hope, someone can help.
Thanks in advance
Beste regards
Asg
php odbc
asked Dec 9 at 16:43
Asg
11
1
This is older now: askubuntu.com/questions/187389/… If MDB, is it an older Access database?
– oldfred
Dec 9 at 17:41
mdb or accdb, both are ok for me. I don't want to open the db in an application like office or so. I want to access the mdb or accdb via PHP (see link above).
– Asg
Dec 9 at 19:37
Best not to use MS Access if at all possible. Or convert one time to any of the Linux compatible SQL databases.
– oldfred
Dec 9 at 21:02
It's not my choice. My customer wants MS Access, so I have to deal with it. I'm still interested in help :( Thanks
– Asg
Dec 10 at 20:02
add a comment |
I want to use a mdb Access Database with PHP 7.2 on Ubuntu 18 + XAMPP. So I've installed the following packages, although not all of them may be required:
sudo apt install php7.2-odbc
sudo apt install libodbc1
sudo apt install unixodbc
sudo apt install unixodbc-dev
sudo apt install odbc-mdbtools
sudo apt install tdsodbc
After the installation odbc is still not listed as below shown:
php -i | grep PDO
PDO
PDO support => enabled
PDO drivers => mysql, pgsql, sqlite
PDO Driver for MySQL => enabled
PDO Driver for PostgreSQL => enabled
PDO Driver for SQLite 3.x => enabled
So the following entries are missing, as described here:
PDO drivers => mysql, odbc
PDO_ODBC
PDO Driver for ODBC (unixODBC) => enabled
I've restarted the machine and apache, nothing could help.
So, how can I enable PDO-ODBC on Ubuntu + XAMPP in order to connect to MS-Access DB?
I hope, someone can help.
Thanks in advance
Beste regards
Asg
php odbc
asked Dec 9 at 16:43
Asg
11
I want to use a mdb Access Database with PHP 7.2 on Ubuntu 18 + XAMPP. So I've installed the following packages, although not all of them may be required:
sudo apt install php7.2-odbc
sudo apt install libodbc1
sudo apt install unixodbc
sudo apt install unixodbc-dev
sudo apt install odbc-mdbtools
sudo apt install tdsodbc
After the installation odbc is still not listed as below shown:
php -i | grep PDO
PDO
PDO support => enabled
PDO drivers => mysql, pgsql, sqlite
PDO Driver for MySQL => enabled
PDO Driver for PostgreSQL => enabled
PDO Driver for SQLite 3.x => enabled
So the following entries are missing, as described here:
PDO drivers => mysql, odbc
PDO_ODBC
PDO Driver for ODBC (unixODBC) => enabled
I've restarted the machine and apache, nothing could help.
So, how can I enable PDO-ODBC on Ubuntu + XAMPP in order to connect to MS-Access DB?
I hope, someone can help.
Thanks in advance
Beste regards
Asg
php odbc
php odbc
asked Dec 9 at 16:43
Asg
11
asked Dec 9 at 16:43
Asg
11
edited Dec 9 at 17:03
asked Dec 9 at 16:43
Asg
11
asked Dec 9 at 16:43
Asg
11
asked Dec 9 at 16:43
Asg
11
11
1
This is older now: askubuntu.com/questions/187389/… If MDB, is it an older Access database?
– oldfred
Dec 9 at 17:41
mdb or accdb, both are ok for me. I don't want to open the db in an application like office or so. I want to access the mdb or accdb via PHP (see link above).
– Asg
Dec 9 at 19:37
Best not to use MS Access if at all possible. Or convert one time to any of the Linux compatible SQL databases.
– oldfred
Dec 9 at 21:02
It's not my choice. My customer wants MS Access, so I have to deal with it. I'm still interested in help :( Thanks
– Asg
Dec 10 at 20:02
add a comment |
1
This is older now: askubuntu.com/questions/187389/… If MDB, is it an older Access database?
– oldfred
Dec 9 at 17:41
mdb or accdb, both are ok for me. I don't want to open the db in an application like office or so. I want to access the mdb or accdb via PHP (see link above).
– Asg
Dec 9 at 19:37
Best not to use MS Access if at all possible. Or convert one time to any of the Linux compatible SQL databases.
– oldfred
Dec 9 at 21:02
It's not my choice. My customer wants MS Access, so I have to deal with it. I'm still interested in help :( Thanks
– Asg
Dec 10 at 20:02
1
1
This is older now: askubuntu.com/questions/187389/… If MDB, is it an older Access database?
– oldfred
Dec 9 at 17:41
This is older now: askubuntu.com/questions/187389/… If MDB, is it an older Access database?
– oldfred
Dec 9 at 17:41
mdb or accdb, both are ok for me. I don't want to open the db in an application like office or so. I want to access the mdb or accdb via PHP (see link above).
– Asg
Dec 9 at 19:37
mdb or accdb, both are ok for me. I don't want to open the db in an application like office or so. I want to access the mdb or accdb via PHP (see link above).
– Asg
Dec 9 at 19:37
Best not to use MS Access if at all possible. Or convert one time to any of the Linux compatible SQL databases.
– oldfred
Dec 9 at 21:02
Best not to use MS Access if at all possible. Or convert one time to any of the Linux compatible SQL databases.
– oldfred
Dec 9 at 21:02
It's not my choice. My customer wants MS Access, so I have to deal with it. I'm still interested in help :( Thanks
– Asg
Dec 10 at 20:02
It's not my choice. My customer wants MS Access, so I have to deal with it. I'm still interested in help :( Thanks
– Asg
Dec 10 at 20:02
add a comment |
active
oldest
votes
Your Answer
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "89"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});
function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});
}
});
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2faskubuntu.com%2fquestions%2f1099597%2fhow-to-enable-pdo-odbc-on-ubuntu-xampp-in-order-to-connect-to-ms-access-db%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
active
oldest
votes
active
oldest
votes
active
oldest
votes
active
oldest
votes
Thanks for contributing an answer to Ask Ubuntu!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Some of your past answers have not been well-received, and you're in danger of being blocked from answering.
Please pay close attention to the following guidance:
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2faskubuntu.com%2fquestions%2f1099597%2fhow-to-enable-pdo-odbc-on-ubuntu-xampp-in-order-to-connect-to-ms-access-db%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
1
This is older now: askubuntu.com/questions/187389/… If MDB, is it an older Access database?
– oldfred
Dec 9 at 17:41
mdb or accdb, both are ok for me. I don't want to open the db in an application like office or so. I want to access the mdb or accdb via PHP (see link above).
– Asg
Dec 9 at 19:37
Best not to use MS Access if at all possible. Or convert one time to any of the Linux compatible SQL databases.
– oldfred
Dec 9 at 21:02
It's not my choice. My customer wants MS Access, so I have to deal with it. I'm still interested in help :( Thanks
– Asg
Dec 10 at 20:02