OK, I'm getting the following error on SQL Server connection in Win98 (referencing ADO 2.5). I DONT get the error in WinXP. I dont know why this is happening:

Error 430: Class does not support Automation or does not support expected interface.

VB Code:
  1. Private Sub ConnectDB(ByRef rID3Title, rID3Artist)
  2.  
  3. 768       On Error GoTo DB_err
  4.  
  5.           'DB Connect setting up
  6.           Dim SQLstatement As String
  7.  
  8. 771       SQLCON.ConnectionTimeout = 5  ' Time out for the connection
  9. 772       SQLCON.Provider = "sqloledb"   ' OLEDB Provider
  10. 773       SQLCON.Properties("Network Address").Value = "64.105.xx.xxx,80"  ' set the ip address of your sql server
  11. 774       SQLCON.CommandTimeout = 10 ' set timeout for 3 minutes
  12. 775       SQLCON.Properties("Network Library").Value = "dbmssocn" ' set the network library to use win32 winsock tcp/ip
  13. 776       SQLCON.Properties("Data Source").Value = "SERVER"
  14. 777       SQLCON.Properties("Initial Catalog").Value = "Database"
  15. 778       SQLCON.CursorLocation = adUseServer ' For ADO cursor location
  16.           'SQLCON.Properties("Integrated Security").Value = "SSPI"
  17. 779       SQLCON.Properties("User ID").Value = "xxxxxx"
  18. 780       SQLCON.Properties("Password").Value = "xxxxxx"
  19. 781       SQLCON.Open
  20.  
  21.           'Setup done
  22.  
  23. 782       SQLstatement = "SELECT dbo.Cover.Album, dbo.Cover.Cover, dbo.Artist.URL " _
  24.           & "FROM dbo.Artist INNER JOIN " _
  25.           & "dbo.Cover ON dbo.Artist.Artist = dbo.Cover.Artist INNER JOIN " _
  26.           & "dbo.Track ON dbo.Cover.Album = dbo.Track.Album " _
  27.           & "WHERE (dbo.Track.Track = N'" & Replace(rID3Title, "'", "") & "') AND " _
  28.           & "(dbo.Artist.Artist = N'" & Replace(rID3Artist, "'", "") & " ')"
  29.    
  30. 783       RS.Open SQLstatement, SQLCON
  31.    
  32. 784       Exit Sub
  33.  
  34. DB_err:
  35.  
  36. 792           RS.Close
  37. 793           SQLCON.Close
  38. 794           Set RS = Nothing
  39. 795           Set SQLCON = Nothing
  40. End Sub