connect to sql server

From: TJS (nospam_at_here.com)
Date: 01/04/05 

Date: Tue, 4 Jan 2005 01:48:56 -0800

I can connect to my database with everything but my ASP page.

>From the page I get this error message:
---------------------------------------------------
"[Microsoft][ODBC SQL Server Driver][DBNETLIB]
SQL Server does not exist or access denied"

the connection string is:
--------------------------------
strConnect= "Driver={SQL Server};" & _
           "Server= (local);" & _
           "Database=mybd;" & _
           "Uid=myuid;" & _
           "Pwd=mytpwd"
Set objconn = Server.CreateObject("ADODB.Connection")
objconn.ConnectionTimeout = 30
objconn.open strConnect

why this error?

Relevant Pages

  • Re: Cant connect from ASP app
    ... as well - try to ping the server from the ASP box, ... telnet to the listening port on the server from the ASP box, ... try creating a TCP IP alias for the SQL Server instance ... Also with the connection string, ...
    (microsoft.public.sqlserver.connect)
  • Re: SQL Server 7.0 Security Patch MS03-031
    ... > I've been using a connection string within an ASP page to ... > Everything worked fine until SQL Server 7.0 Security ... > Microsoft OLE DB Provider for SQL Server error '80004005' ...
    (microsoft.public.sqlserver.security)
  • Cant connect from ASP app
    ... My SQL server is on one PC, and the ASP web application is on ... executed simple dotNET program that uses the very same connection string to ...
    (microsoft.public.sqlserver.connect)
  • RE: SA Account Cant Access Views After Password Change
    ... changed the password for the sa account in the connection string on the ASP ... SQL Server does not cache standard login passwords locally so this cannot ...
    (microsoft.public.sqlserver.clustering)
  • RE: How do I configure Analysis Services for Excel 2003 users?
    ... they had had Office 2003 installed AFTER SQL Server. ... > I have been preparing a set of cubes in Analysis Services 2005 to be viewed ... > Excel reports have been designed as pivot tables based on AS cubes, ... > Surely it must be that the connection string is incorrect but I seem to have ...
    (microsoft.public.sqlserver.olap)