I just wanted to know the following things if u can just help me. I made a website in Visual Studio 2008 and used the database provided by the VS [I dont know which version is this]. That website runs successfully on the machine having visual studio[As in that i just attach my database through the GUI provided by VS]. Now I want to deploy that website on a LAN. I have the database in .ldf and .mdf format. But I dont know whether it is in sql 2005 or sql 2008[as i made it through Visual Studio GUI] Now …

Member Avatar
+0 forum 0

Hi there. Im new to asp programming. And I am doing a research project for my school. I'm create a website with MS SQL SERVER 2005 with ASP. But the problem is the right connection. I have searched the web almost 2 weeks but nothing happened. Here's what my code for the connection [QUOTE]<% <% dim con, Rs set con=server.CreateObject("adodb.connection") con.Open "Provider=sqloledb;SERVER=localhost;DATABASE=SMS;UID=sa;PWD=;" set Rs=server.CreateObject("adodb.recordset") %> [/QUOTE] and here's the error message [QUOTE]Microsoft OLE DB Provider for SQL Server (0x80004005) Login failed for user 'sa '. The user is not associated with a trusted SQL Server connection. /SEARCH MANAGEMENT SYTEM WEBSITE/sample.asp, …

Member Avatar
+0 forum 0

The End.