PROBLEM SOLVED.

The connection string that finally worked successfully for me included the direct path and filename to the SQL data file on the server. Something like this:

"Driver={SQL Server};Server=ServerNameNumber;DBQ=D:\INETPUB\Dat abases\SQL Databases\MSSQL\data\DBwebsite-Data.MDF;UID=UserName;PWD=password;"

I really appreciated the responses to my problem report posting here on p2p. I learned a lot in analyzing the issue and investigating potential resolutions. Interestingly enough, the suggestion for inserting the drive, direct path, and the file name to the database data file on the web server came from "Database Connections for ASP Developers" in "Using Dreamweaver MX" help documentation within DW program. Go figure!

Thanks to everyone for their suggestions,

buddyz

Hmm thats weird, i have never linked directly to an MDF file, glad you got it working though.

"The one language all programmers understand is profanity."

Maybe because the way our systems are set up is so that Programs (executable files & etc.) are on C: and the data files are on D: drive. My guess is that SQL was looking for data file on the same drive and perhaps in the same location as the program files. Just a guess. . .?

I don't think so. My SQL Server is setup on C and I have my data files stored on a secondary disk and I have never had any problems; very strange.

"The one language all programmers understand is profanity."