DataAdapter.fill

[nahlous]

Hy,

I am facing a problem with the statement:

MyDataAdapter.fill(myDataSet)

The error is the following:

Server Error in '/Trial Projects/Accounting' Application
Login failed for user 'Server\Aspnet'.

I am user of the connection and so on, I tried many ways, by writing the codes, by using the wizard, and I tried with SQL Database and with SQL Server Database, in all cases I am not beeing able to fill my DataAdapter.

Any idea of how can I solve my problem, I want to link text fields to a database in a web application, couldn't be done??

[scostell]

Your problem is that User 'ASPNET' is not allowed to access your SQL Server. so you must add'm to Security|login of your SQL Server.

At least when i got that error you did, this solved my problem.

[nahlous]

Hy,

I will try it anyway, but I had the same problem with an access database which doesn't need any login, and the same connection I used with a window application it works.

So any new ideas??