I'm using the PHP-version of inAudio and want to use MS Access as data-provider.

You need to setup 2 ODBC-providers to to this.
 <-- Back to the F.A.Q mainpage

Open the Data Sources (ODBC) administrator which you can find in the Windows Control Panel (or in Windows Control Panel -> Administrative Tools on some systems)

Select System DSN from the tabs on top (a user DSN won't work):

Click the Add-button. The "Create New Data Source"-window will be displayed.

Select Microsoft Access Driver from the list and then click the Finish- button. The ODBC Microsoft Access Setup window will be displayed:

Give your connection a name (for example php_inaudio) and then click the Select..-button. The Select Database window will be displayed.

Navigate to the directory where you installed the application-files for Octagon inAudio (for example c:\program files\octagon inaudio). Then go to the subdirectory db and you should see 3 .mdb- files. Double-click on the file inaudio.mdb. You are now back in the ODBC Microsoft Access Setup-window. Click OK. Repeat the procedure with the file playlist.mdb which is situated in the same directory as inaudio.mdb.
When you are done setting up the 2 ODBC-providers, Open the inAudio Control Panel.

Click the Change-button in the Database Settings panel. The Database Provider and Settings window will be displayed.

Select Access. The Edit Php-access connections-window will be displayed.

Type in the names of the ODBC-connections you set up earlier or click browse to browse the available ODBC-connections on your system. When you are done, click Test Data Sources to make sure you have gotten everything right. Click OK, save your changes and re-index. All done :)
|