How to configure SQL Database?

Results 1 to 2 of 2

Thread: How to configure SQL Database?

  1. #1
    Louis Toyama Guest

    Default How to configure SQL Database?

    I recently installed SQL Server on my machine. I followed all the instruction of how to configure ODBC in the Control Panel and test OK. However, when I tried to do a query, it gave me a message:<BR><BR>Microsoft OLE DB Provider for ODBC Drivers error &#039 80040e4d&#039<BR>[Microsoft][ODBC SQL Server Driver][SQL Server] login faild<BR>/sql.asp, line 6<BR><BR>Here is my code:<BR><BR>&#060;%@ LANGUAGE="VBSCRIPT"%&#062;<BR><BR><BR>&#060;%<BR> set objConn = Server.CreateObject("ADODB.Connection")<BR> objConn.Open "LouisDatabase"<BR> set GetInfo=objConn.execute("select * from employee")<BR>%&#062;<BR><BR><BR><BR>Can anyone help me with this? <BR><BR>Thank you in advance.<BR><BR>Louis Toyama

  2. #2
    Join Date
    Dec 1969

    Default RE: How to configure SQL Database?

    Try:<BR><BR>objConn.Open "LouisDatabase", "sa", "whatever Password you chose for sa"<BR><BR>

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts