Hello, I'm perplexed since the ODBC System DSN tests OK (via the ODBC Data Source Administrator) and the entire SQL command string (copied from the ACC.log) succeeds with the MySQL Query Browser but the ACC script itself fails with an error 0.
My system config: Windows XP x64 SP2 (O/S on C:, Slimserver on D:, music on E:) mysql ODBC connector for XP x64 v3.51.23 mysql gui tools v5.0-r12-win32 SlimServer Version: 6.5.2 - 12047 - Windows Server 2003 - EN - cp1252 Perl Version: 5.8.8 MSWin32-x86-multi-thread MySQL Version: 5.0.22-community-nt ACC.cfg: SF|E:\Archived Music G2E| CF|E:\Archived Music\Various Artists DT|False DG|True ACS|True APPS|True SB|1 Acc.log: STATUS : fnReadSettings():ENTER:4:12:17 PM STATUS : fnReadSettings():LEAVE:4:12:17 PM STATUS : fnReadSettings():ENTER:4:12:17 PM STATUS : fnReadSettings():LEAVE:4:12:17 PM STATUS : fnReadSettings():ENTER:4:12:17 PM STATUS : fnReadSettings():LEAVE:4:12:17 PM STATUS : fnReadSettings():ENTER:4:12:17 PM STATUS : fnReadSettings():LEAVE:4:12:17 PM STATUS : fnReadSettings():ENTER:4:12:17 PM STATUS : fnReadSettings():LEAVE:4:12:17 PM STATUS : fnReadSettings():ENTER:4:12:17 PM STATUS : fnReadSettings():LEAVE:4:12:17 PM STATUS : fnReadSettings():ENTER:4:12:17 PM STATUS : fnReadSettings():LEAVE:4:12:17 PM STATUS : fnReadSettings():ENTER:4:12:17 PM STATUS : fnReadSettings():LEAVE:4:12:17 PM ACC Version : 1.0 Release Candidate 2a STARTED : 1/20/2008 --- 4:12:17 PM STATUS : Window created STATUS : fnStart():ENTER:4:12:20 PM OPTION SELEC: Display Tracks = False OPTION SELEC: Cover art size = True OPTION SELEC: Display Genre = True OPTION SELEC: Sort by = Artist OPTION SELEC: AutoPrintPageSep = True OPTION SELEC: Filter: Starting folder = E:\Archived Music OPTION SELEC: Filter: Compilation folder = E:\Archived Music\Various Artists OPTION SELEC: Filter: Genres to exclude = STATUS : fnStoreSettings():ENTER:4:12:20 PM STATUS : fnStoreSettings():LEAVE:4:12:20 PM STATUS : fnStart():LEAVE:4:12:20 PM STATUS : fnStart2():ENTER:4:12:20 PM STATUS : fnQueryLogic():ENTER:4:12:20 PM STATUS : fnCreateSQLQuery(1):ENTER:4:12:22 PM STATUS : fnCreateSQLQuery(1): STATUS : select CONVERT(contributors.name USING utf8) as artist,CONVERT(albums.title USING utf8) as album,albums.year AS year, tracks.url AS filepath, tracks.tracknum AS tracknumber, CONVERT(tracks.title USING UTF8) as tracktitle,CONVERT(SEC_TO_TIME(tracks.secs),CHAR) as duration, genres.namesort AS 'genre' from tracks join albums on albums.id=tracks.album AND albums.titlesort!='SINGLE TRACK' AND albums.titlesort!='NO ALBUM' left join contributor_track on contributor_track.track=tracks.id and (contributor_track.role in (1) or contributor_track.role in (5))left join contributors on contributor_track.contributor=contributors.id left join genre_track on genre_track.track=tracks.id left join genres on genre_track.genre=genres.id STATUS : WHERE INSTR(UCASE(tracks.url), 'FILE:///E:/Archived%20Music') AND !INSTR(UCASE(tracks.url), 'FILE:///E:/Archived%20Music/Various%20Artists') STATUS : group by tracks.id,lcase(convert(albums.title using utf8)) STATUS : order by artist,year DESC,lcase(convert(albums.titlesort using utf8)),tracks.disc,tracks.tracknum; STATUS : fnCreateSQLQuery(1):LEAVE:4:12:22 PM STATUS : fnPerformQuery(1):ENTER:4:12:22 PM STATUS : fnPerformQuery():Recordset opened:4:12:22 PM ERROR : fnPerformQuery():An error occured while connection to the database. Error number: 0 -- Error description: I agree that this should be basic included functionality with the Slimserver and would love to get this working. Does anyone have any ideas what could be wrong? Thanks in advance. Terry -- terry ------------------------------------------------------------------------ terry's Profile: http://forums.slimdevices.com/member.php?userid=14150 View this thread: http://forums.slimdevices.com/showthread.php?t=41597 _______________________________________________ discuss mailing list [email protected] http://lists.slimdevices.com/lists/listinfo/discuss
