agentsmith;254371 Wrote:
> I downloaded and installed the MySQL connector into my Vista machine.
>
> When trying to run the script, the GUI comes up, when I pressed Start,
> I got the error:
> ---------------------------------
> "An error occured while connection to the database, the error data is
> printed below:
> Error Number: 0
> Error Description:"
> ----------------------------------
>
> Squeezecenter is started with the following info:
>
> ----------------------------------
> SqueezeCenter Version: 7.0 - 15013 - Windows Vista - EN - cp1252
> Server IP address: 192.168.0.101
> Perl Version: 5.8.8 MSWin32-x86-multi-thread
> MySQL Version: 5.0.22-community-nt
>
> ---------------------------------
>
> Any idea what the problem is? Does the SQL connector need to be
> started manually? I cannot find a start option for it.
I have the same issue under XP - and unlike Siduhe, changing the UID to
"squeezecenter" doesn't fix the problem.
This is where the error is generated:
'Open connection with SlimServer DB
Set rs = CreateObject("ADODB.Recordset")
rs.ActiveConnection = ConnectString
rs.CursorType = adOpenKeyset 'Use openkeyset cursor to
enable cursor movement
If err.number = -2147467259 then
on error goto 0
msgbox "Error connecting to SlimServer database." & vbcrlf &_
"The required mySQL ODBC driver is not installed or is
not set to use the default credentials. Refer to Help screen for more
information on mySQL ODBC driver download and installation" & vbcrlf &
vbcrlf &_
"Click OK to quit script."
self.close
Elseif err.number Then
on error goto 0
msgbox "An error occured while connection to the database. The
error data is printed below." & vbcrlf &_
"Error number: " & err.number & vbcrlf &_
"Error description: " & err.description & vbcrlf &
vbcrlf &_
"Click OK to quit script."
self.close
End If
The error (which is not trapped by the code at the moment) is 3706
which is associated with the SQL ODBC driver not being installed
correctly...but it appears to be OK as far as I can test it. The XP
admin tools test out ok for this driver. Not sure how to debug it
further.
I am only posting this to help Frank in his testing of the SC7 version.
--
Phil Leigh
You want to see the signal path BEFORE it gets onto a CD/vinyl...it
ain't what you'd call minimal...SB3+Stontronics PSU - Altmann
JISCO/UPCI - TACT RCS 2.2X with Good Vibrations S/W - MF X-DAC
V3/X-PSU/X-10 buffer (Audiocomm full mods)- Linn 5103 - Linn Aktiv 5.1
system (6x LK140's, ESPEK/TRIKAN/KATAN/SEIZMIK 10.5), Kimber & Chord
cables
------------------------------------------------------------------------
Phil Leigh's Profile: http://forums.slimdevices.com/member.php?userid=85
View this thread: http://forums.slimdevices.com/showthread.php?t=41597
_______________________________________________
discuss mailing list
[email protected]
http://lists.slimdevices.com/lists/listinfo/discuss
