Wade Wright
4/2/2002 10:23:00 PM
I am just taking a guess, but ASP by default uses an account it creates
called ASP_NET that is kinda like the old IUSER of classic asp. Even if your
DSN has a user and password in it, I find that I have to pass it when I
build my connection string, as in "DSN=MyDSN;UID=Wade;Password=MyPassword;"
(NOTE: Make sure you connection string syntax is right, sometimes its
Password or Pwd... just use what is right for your connection"
"sam" <sam@oncontact.com> wrote in message
news:1c1b01c1da5f$2db80ef0$39ef2ecf@TKMSFTNGXA08...
> I have no problem using ODBC.NET with C# in client /
> server applications, but am getting "Data source name not
> found" error in ASP.NET.
> Apparently, this is a permission issue, because ASP.NET
> connects as a different user. If someone can jump-start me
> on where to look - it would be very much appreciated.
>
> TIA,
>
> Sam.