|
 |
asp_databases thread: Error: SQL Server (0x80004005)
Message #1 by TIMOFEY@E... on Mon, 29 Jul 2002 07:42:56
|
|
Hi everybody:
I am strugling for a couple days to find my mistake, but have no results.
Environment:
SQL 2000 (Table: Contact; User: contactapp)
COM object (ContactObjects.Contact)
VB module (Option Explicit
Public Const DB_CONN = "Provider=SQLOLEDB.1;Password=contact;" & _
"User ID=contactapp;Initial Catalog=Contact;Data Source=PACIFIC-
YHGZCGR")
ASP code (
<%
Dim strContactID
Dim objContact
strContactID = Request.QueryString("ID")
Set objContact = Server.CreateObject("ContactObjects.Contact") <<<LINE
20>>> I have problem here.
objContact.Load CStr(strContactID)
%>
)
I am getting the following error:
Error Type:
Microsoft OLE DB Provider for SQL Server (0x80004005)
Login failed for user 'contactapp'. Reason: Not associated with a trusted
SQL Server connection.
/Contact/ContactDetails.asp, line 20
I have checked MS site for error (0x80004005) and found any use of it.
It seems like simple stuff but I am stuck.
I would appreciate any help.
Sincerely,
Sam
Message #2 by "Giovanni Salucci" <g.salucci@n...> on Mon, 29 Jul 2002 09:43:01 +0200
|
|
take a look
http://www.able-consulting.com/ADO_Conn.htm
-----Messaggio originale-----
Da: TIMOFEY@E... [mailto:TIMOFEY@E...]
Inviato: luned́ 29 luglio 2002 7.43
A: ASP Databases
Oggetto: [asp_databases] Error: SQL Server (0x80004005)
Hi everybody:
I am strugling for a couple days to find my mistake, but have no results.
Environment:
SQL 2000 (Table: Contact; User: contactapp)
COM object (ContactObjects.Contact)
VB module (Option Explicit
Public Const DB_CONN = "Provider=SQLOLEDB.1;Password=contact;" & _
"User ID=contactapp;Initial Catalog=Contact;Data Source=PACIFIC-
YHGZCGR")
ASP code (
<%
Dim strContactID
Dim objContact
strContactID = Request.QueryString("ID")
Set objContact = Server.CreateObject("ContactObjects.Contact") <<<LINE
20>>> I have problem here.
objContact.Load CStr(strContactID)
%>
)
I am getting the following error:
Error Type:
Microsoft OLE DB Provider for SQL Server (0x80004005)
Login failed for user 'contactapp'. Reason: Not associated with a trusted
SQL Server connection.
/Contact/ContactDetails.asp, line 20
I have checked MS site for error (0x80004005) and found any use of it.
It seems like simple stuff but I am stuck.
I would appreciate any help.
Sincerely,
Sam
Message #3 by "Pacific" <timofey@e...> on Mon, 29 Jul 2002 22:02:48 -0700
|
|
Hi Giovanni:
Thank you for your help. I will check the site.
Sincerely,
Sam
----- Original Message -----
From: "Giovanni Salucci" <g.salucci@n...>
To: "ASP Databases" <asp_databases@p...>
Sent: Monday, July 29, 2002 12:43 AM
Subject: [asp_databases] Re: Error: SQL Server (0x80004005)
>
> take a look
> http://www.able-consulting.com/ADO_Conn.htm
>
>
> -----Messaggio originale-----
> Da: TIMOFEY@E... [mailto:TIMOFEY@E...]
> Inviato: luned́ 29 luglio 2002 7.43
> A: ASP Databases
> Oggetto: [asp_databases] Error: SQL Server (0x80004005)
>
>
> Hi everybody:
>
> I am strugling for a couple days to find my mistake, but have no results.
>
> Environment:
> SQL 2000 (Table: Contact; User: contactapp)
> COM object (ContactObjects.Contact)
> VB module (Option Explicit
>
> Public Const DB_CONN = "Provider=SQLOLEDB.1;Password=contact;" & _
> "User ID=contactapp;Initial Catalog=Contact;Data Source=PACIFIC-
> YHGZCGR")
>
> ASP code (
> <%
> Dim strContactID
> Dim objContact
>
> strContactID = Request.QueryString("ID")
> Set objContact = Server.CreateObject("ContactObjects.Contact") <<<LINE
> 20>>> I have problem here.
> objContact.Load CStr(strContactID)
> %>
> )
>
> I am getting the following error:
>
> Error Type:
> Microsoft OLE DB Provider for SQL Server (0x80004005)
> Login failed for user 'contactapp'. Reason: Not associated with a trusted
> SQL Server connection.
> /Contact/ContactDetails.asp, line 20
>
> I have checked MS site for error (0x80004005) and found any use of it.
> It seems like simple stuff but I am stuck.
> I would appreciate any help.
> Sincerely,
> Sam
>
>
|
|
|
View Cart
