Windows no sql connection

Databases
1

Hello,

i can’t get why this runs fine under Mac but it throws “Connection Error” when compiled for windows

[code]Dim db As New MySQLCommunityServer

db.Host = “myhost”
db.Port = 3306
db.DatabaseName = “xxx”
db.UserName = “xxx”
db.Password = “xxxxxxx”

If db.Connect Then
dim rs as RecordSet
rs= db.SQLSelect("SELECT mediaID,originalFilename FROM media")

If rs <> Nil Then
While Not rs.EOF
elements.append rs.Field(“mediaID”).StringValue+"#"+rs.Field(“originalFilename”).StringValue
rs.MoveNext
Wend
rs.Close
End If
db.Close

else
MsgBox “Connection Error”
end if[/code]

Anybody knows why?
Marco

2

strange… when using ip-address instead of hostname it works on windows, too

3

Its not strange. hostname is not defined in the host file of windows system.