Hello I am trying to display an ID which is a primary key in my table by selecting the corresponding name in my table. the names have been saved in a combo box and depending on the name selected the textbox will display that Id. the code I have so far only gets the names from sql server but doesnt show the id in the textbox. can you guide me on this please.. this is the code for combobox. i placed it in the formload [CODE] Public Sub RtnCmbVal() Dim conn As SqlConnection Dim str As String = "select ConsultantId, …

Member Avatar
Member Avatar
+0 forum 8

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.