by Tom Toew » Wed, 06 Mar 2002 23:41:20
Tom
by Narayana Vyas Kondredd » Thu, 07 Mar 2002 00:10:16
Quote:> I'm connecting from Access 97 (Win 98 client) via ADO 2.6 connection to a
> SQL Server 7.0 (NT 4.0) using Integrated Security. When I run "SELECT
> Currenct_User", it returns dbo. How is this determined? I am the
database
> administrator (scary... huh seeing as I don't know the answer to this
> question) but how does it know that I am dbo based upon my NT account?
> Tom
by Tom Toew » Thu, 07 Mar 2002 00:12:23
Tom
> > I'm connecting from Access 97 (Win 98 client) via ADO 2.6 connection to
a
> > SQL Server 7.0 (NT 4.0) using Integrated Security. When I run "SELECT
> > Currenct_User", it returns dbo. How is this determined? I am the
> database
> > administrator (scary... huh seeing as I don't know the answer to this
> > question) but how does it know that I am dbo based upon my NT account?
> > Tom
1. How to connect to SQL Server through ADO (SOL Server uses Integrated Security)
Hi, everyboday! Please help me!
I have the following error when I run the asp page in which I call COM
component. This COM component accesses the SQL server through ADO.
The error is:
pubserver.titleupdate.Post error '80004005'
[Microsoft][ODBC SQL Server Driver][DBNMPNTW]ConnectionOpen (CreateFile()).
The SQLServer Security is configured as Integrated Securtiy. The user
account, admin, is assigned as privilege "sa" using SQL Server Security
Manager.
The SQLServer sits in different machine from the IIS. The SQLServer used
Named Pipe protocol.
<%
Set obj = Server.CreateObject("pubserver.titleupdate")
strtitle = "BU1032"
amount = 1
strdsn = "tryjiangsu"
id="admin"
pwd="author"
'call the COM component
result = obj.Post(strtitle,amount,strdsn,id,pwd)
%>
Com component written in VB5:
Public Function Post( ) As String
On Error GoTo ErrorHandler
' obtain the ADO environment and connection
Dim adoConn As New ADODB.Connection
Dim varRows As Variant
adoConn.ConnectionString = "driver={SQL
Server};server=140.184.132.199;uid=admin;pwd=author;database=pubs"
adoConn.ConnectionTimeout = 60
adoConn.Open
' update the price
Dim strSQL As String
strSQL = "UPDATE titles SET price = price + " + Str$(amount) + " WHERE
title_id ='" + title + "'"
adoConn.Execute strSQL, varRows
...
If I use the Standard Security of SQL Server and user ID as "sa", password
as "", everything is fine.
Thanks,
Yie Wang
2. DTS Wizard error (license issue)
4. Using NT Integrated Security in the ADO Connection
5. SQL Server 7 Service Pack 2 Upgrade to SP3 on W2K Server Failure
6. SQL Server 7.0 Integrated security
7. Pdox V8 and Outlook Express (IE 4.0)
8. Integrated security- SQL Server 7.0
9. Web site - SQL Server 7.0 users and integrated security
10. IIS and SQL SERVER connection-integrated security
11. NT4.0 /SQL-Server integrated security and odbc-connections