SQL 6.5

[Ricardo Sánchez]

Hi people.

I have a situation that you might have seen before. I'm
trying to connect with a 6.5 version SQL Server using
ASP.Net. The thing is that I'm getting the following
error:

SQL Server not found or Access denied

I'm certain that I'm using the right login and password
because I use them to connect by other means (SQL
Analyzer). I've tryed almost every data provider
supported by .Net framework but still won't work.

My preferred option to connect with this server is OLEDB,
but it does't seem to work properly. It is strange
because the same code used on a W32 application works
fine, but when I use it on a ASP page, it crash & burns!!

Any help would be appreciated,

Ricardo S.

[Srini]

Hi ricardo,
What type of authentication are u using.
If you are using windows authentication to connect to SQL
server 6.5 and it is not working I think I have got the
idea what is wrong. I think the user ASP.NET (Win 2000
user) is not able to access SQL server 6.5 database.
Because the ASP.NET worker process impersonates the
asp.net user which has limited rights.

Regards,
Srini

-----Original Message-----
Hi people.

I have a situation that you might have seen before. I'm
trying to connect with a 6.5 version SQL Server using
ASP.Net. The thing is that I'm getting the following
error:

SQL Server not found or Access denied

I'm certain that I'm using the right login and password
because I use them to connect by other means (SQL
Analyzer). I've tryed almost every data provider
supported by .Net framework but still won't work.

My preferred option to connect with this server is OLEDB,
but it does't seem to work properly. It is strange
because the same code used on a W32 application works
fine, but when I use it on a ASP page, it crash & burns!!

Any help would be appreciated,

Ricardo S.
.

[Tim Stephenson]

Hi,
You'd need to use SQL authentication to access the server, along with OLEDB.
You can't use the SQL Data Provider objects as they only support SQL Server
7 or above.

As a start, make sure you can ping your SQL server from the webserver
console. There might be some sort of firewall issue between the two
machines. Once you are sure you can connect, another test to eliminate
connectivity problems would be to setup an ODBC DSN connection to the
server. You would then be able to try using the DSN from ASP.NET.

If that all works, then you shouldn't have a problem with OLEDB.
--
Regards

Tim Stephenson MCSD.NET
Charted MCAD & MCSD.NET Early Achiever
"Ricardo Sánchez" <ri*****************@roche.com> wrote in message
news:08****************************@phx.gbl...

Hi people.

I have a situation that you might have seen before. I'm
trying to connect with a 6.5 version SQL Server using
ASP.Net. The thing is that I'm getting the following
error:

SQL Server not found or Access denied

I'm certain that I'm using the right login and password
because I use them to connect by other means (SQL
Analyzer). I've tryed almost every data provider
supported by .Net framework but still won't work.

My preferred option to connect with this server is OLEDB,
but it does't seem to work properly. It is strange
because the same code used on a W32 application works
fine, but when I use it on a ASP page, it crash & burns!!

Any help would be appreciated,

Ricardo S.