SQL Server error '80040e4d'

Forums

My Profile

Inbox

Address Book

My Subscription

My Forums

SQL Server error '80040e4d'

Logged in as: Guest

arrSession:exec spGetSession 2,2,173

	Active Users: There are 0 members and 0 guests.
	Users viewing this topic: none

Printable Version

All Forums >> [Scripting] >> WSH & Client Side VBScript >> SQL Server error '80040e4d'
Do you like VisualBasicScript.com? Link to us and help spread the word about our forum. Thanks!

Page: [1]

Message

<< Older Topic Newer Topic >>

SQL Server error '80040e4d' - 6/16/2001 4:04:51 AM

itan

Posts: 10
Score: 0
Joined: 5/31/2001
From: USA
Status: offline

I am trying to create a simple asp page connecting to an SQL Server Database. The web page lives on a
separate web server (in house).

I set up an ODBC DSN, tested connection successfully, but cannot get my ASP page to work.

Here's the code I used:
Dim oConn
Set oConn=Server.CreateObject("Adodb.Connection")
' DSN CONNECTION WITH INTEGRATED SECURITY
oConn.Open = "DSN=DCD_DSN"

I also tried DSN-less and got the same problem.

"Microsoft OLE DB Provider for SQL Server error '80040e4d'

Login failed for user "

Any guesses as to what I am missing?
Many thanks!

Post #: 1

Re: SQL Server error '80040e4d' - 6/16/2001 4:05:55 AM

dropme

Posts: 18
Score: 0
Joined: 5/23/2001
From: USA
Status: offline

Easiest is use SQL Server security. THe problem is the web server doesn't operate under your user account, for
NT normally the account is IUSR_computername

(in reply to itan)

Post #: 2

Re: SQL Server error '80040e4d' - 10/29/2002 4:12:54 AM

rkh

Posts: 5
Score: 0
Joined: 10/29/2002
From: Jordan
Status: offline

use this code
<%Dim ConnectionString
Dim ADO

ConnectionString="provider=SQLOLEDB.1;persist security info=false;User ID=rkh;password=kh;initial catalog=;Data Source= "

Set ADO=Server.CreateObject("ADODB.Connection")
ADO.ConnectionString =ConnectionString
ADO.Open
%>

rkh

(in reply to itan)

Post #: 3

If you found our site useful please link to us <a href="http://www.visualbasicscript.com">VisualBasicScript.com</a>.

All Forums >> [Scripting] >> WSH & Client Side VBScript >> SQL Server error '80040e4d'

Page: [1]

Jump to:

New Messages	No New Messages
Hot Topic w/ New Messages	Hot Topic w/o New Messages
Locked w/ New Messages	Locked w/o New Messages

Post New Thread

Reply to Message

Post New Poll

Submit Vote

Delete My Own Post

Delete My Own Thread

Rate Posts