php - Connection to Access database on linux failed unixODBC -
currently have website running on windows machine @ hostingprovider. on windows machine have connection mdb database using following code:
new pdo("odbc:driver=microsoft access driver (*.mdb); dbq=$this->dbname; uid=; pwd=;");
this working fine.
now same, on linux machine @ hostingprovider (which cheaper). have ftp access webserver. can't install on webserver.
offcourse linux machine not have microsof acces driver, has unixodbc installed.
i can't create dsn think need dsn-less connection.
can unixodbc used connect access database?
how should create connection mdb database on linux webserver?
you might have unixodbc installed still need microsoft access odbc driver , 1 not come unixodbc. there 2 know of linux , both need installing (however, still possible ftp). 2 know mdb tools free , the easysoft ms access odbc driver need purchase. i've never had luck mdb tools (various odbc functions did not work , don't think maintained). know easysoft driver works i've used it.
Comments
Post a Comment