Board index MS SQL Server

MS SQL7 problem

MS SQL7 problem

Post by Bria » Tue, 28 Nov 2000 04:00:00



Hope I got the right newsgroup.

We are having trouble getting server1 to talk to server2 (the SQL7) server.

When we setup the ODBC DSN on server1 it verifies and accesses the SQL7
server correctly with no errors. However when we call it from a web page ASP
we get the following error.

---------
Microsoft OLE DB Provider for ODBC Drivers error '80040e4d'
[Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user '\'.

/wargames/home.asp, line 18
----------

The \ above should be username wargames.

I noticed while running a trace on the SQL7 server that when we setup the
DSN on server1 through the NT control panel it logges on correctly using the
correct username BUT when accessed through the DSN and web page the username
is not parsed only internet information server is parsed and I think this is
the problem.

Any ideas?

Brian

 
 
 
Top

MS SQL7 problem

Post by User » Wed, 29 Nov 2000 04:00:00


Check whether you are using integrated or standard login.
If you are using integrated, then the credentials when you set up DSN on
server1 will be your login name
When you are using ASP, it will use the anonymous internet user account,
(unless you have disabled
anonymous authentication for the web site)


Quote:> Hope I got the right newsgroup.

> We are having trouble getting server1 to talk to server2 (the SQL7)
server.

> When we setup the ODBC DSN on server1 it verifies and accesses the SQL7
> server correctly with no errors. However when we call it from a web page
ASP
> we get the following error.

> ---------
> Microsoft OLE DB Provider for ODBC Drivers error '80040e4d'
> [Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user '\'.

> /wargames/home.asp, line 18
> ----------

> The \ above should be username wargames.

> I noticed while running a trace on the SQL7 server that when we setup the
> DSN on server1 through the NT control panel it logges on correctly using
the
> correct username BUT when accessed through the DSN and web page the
username
> is not parsed only internet information server is parsed and I think this
is
> the problem.

> Any ideas?

> Brian


 
 
 
Top

MS SQL7 problem

Post by Bria » Thu, 30 Nov 2000 04:00:00


Thanks for the reply. We have corrected the problem. It seemed to be a
problem with the ODBC driver. Installing MDAC 2.5 fixed it.

-Brian


> Check whether you are using integrated or standard login.
> If you are using integrated, then the credentials when you set up DSN on
> server1 will be your login name
> When you are using ASP, it will use the anonymous internet user account,
> (unless you have disabled
> anonymous authentication for the web site)



> > Hope I got the right newsgroup.

> > We are having trouble getting server1 to talk to server2 (the SQL7)
> server.

> > When we setup the ODBC DSN on server1 it verifies and accesses the SQL7
> > server correctly with no errors. However when we call it from a web page
> ASP
> > we get the following error.

> > ---------
> > Microsoft OLE DB Provider for ODBC Drivers error '80040e4d'
> > [Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user
'\'.

> > /wargames/home.asp, line 18
> > ----------

> > The \ above should be username wargames.

> > I noticed while running a trace on the SQL7 server that when we setup
the
> > DSN on server1 through the NT control panel it logges on correctly using
> the
> > correct username BUT when accessed through the DSN and web page the
> username
> > is not parsed only internet information server is parsed and I think
this
> is
> > the problem.

> > Any ideas?

> > Brian

 
 
 
Top

1. MS SQL7: Problems with GROUP BY

Hi,

I have some data structured a bit like this:

| Category | Field1 | Field2 | Field3 |
---------------------------------------
    10         0         0       1
    20         0         1       0
    70         0         1       0
    10         1         0       0
    50         0         1       0
    10         0         0       1
    50         0         1       0

I would like to be able to select the data while sumarizing the different
colums depending on the value in Category-field.

The result should be something like this:

| Category | Field1 | Field2 | Field3 |
---------------------------------------
    10         1         0       2          
    20         0         1       0
    50         0         2       0
    70         0         1       0

In other words I need to - for each Category-value - to summarize the sum of
ones for each Field(i).

I tried with

SELECT
 Category,Field1,Field2,Field3
FROM
 Table
ORDER BY Category ASC
GROUP CAtegory,Field1,Field2,Field3

But it gives me too many columns :(

What am I doing wrong ?

Thanks,

--
Jesper Stocholm
http://stocholm.dk
Copenhagen, Denmark

2. Microsoft OLE DB Provider for SQL Server (0x80040E37) Invalid object name

3. MS-SQL7.0 beta 3 - setup problem

4. Command buttoms problem in vba

5. Problem with change of MS SQL7.0 table permissions

6. HELP! INSERT error...

7. Problems with ODBC2.04, MS SQL7.0 and btrieve 6.15.451

8. SQL99 CONVERT() function

9. MS SQL7, DTS Problem

10. MS SQL7 - DSN connectivity problem

11. Upgrade from MS SQL7 to MS SQL 2000

12. copy database between MS SQL7 and MS SQL 2000 with different code pages


All times are UTC
Board index