Hi, I am connecting a SQL Server 2k database to a website in Dreamweaver MX using a custom string database connection, obtained from a .udl file. Although I can preview the website when it only contains text, when I introduce a simple recordset and dynamic table, the following error message appears:
Microsoft OLE DB Provider for ODBC Drivers (0x80040E4D)
[Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for
user CARRERA-FP4CXS0IUSR_ CARRERA-FP4CXS0.
/TMP12yy2s61a4.asp, line 8
(Line 8 in Dreamweaver reads: Recordset1.ActiveConnection = MM_con23_STRING)
I would be extremely grateful if anone could help me to resolve this problem.