Search results

This is purely a shot in the dark, but I notice you don't include the Initial catalog parameter. Also, make certain that the user ID and password are correct and that you are using SQL authentication and not Windows authentication.

Actually, I prefer to use the URL (e.g. mssqln.mydomain.com) just in case the IP address happens to change, which evidently occurred here not too long ago.

Where do you specify the URI of the remote machine? I would expect to see "source=mssqln.mydomain.com;initial catalog=REPORTS;". Also, just curious as to why, if this is a SQL Server DB, you are using OLEDB classes instead of the SQL classes to connect.

In order to force MP3 streaming, post a text file with containing the URI of the MP3 file, e.g. "http://www.mydomain.com/audio/lecture.mp3". Name the file something.M3U. Nice low-tech way to get streaming without a special server or player, and the user can use whatever MP3 player they like.