GornHorse
|
| Posted: 07/01/2002, 6:44 PM |
|
I am trying to link a grid to a connection for an MS ACCESS database, which has links to tables within an sql server database. If i cannot successfully do that, I have developed an sql query to use if i can only connect to the sql server. I have tried all I can think of (all different connections) and cannot come up with an answer! When I test the server connection within the connections setup, the test runs ok; but, when i go to use the datasource, i cannot get it to work.
When i connect the grid to the sql server, and use the sql query to configue the data source, and press on 'review data', I can see all the data that i need; however, when i press on connections (under properties for the grid), and test the connection, it says:
'[Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user:*******.'
WHY????
Also, when i preview the page, it does not show any data, just exactly the same as what it looks like in design view!
PLEASE HELP ASAP!!!!!!!!!!!!!!!!!!!!!
|
|
|
 |
Nicole
|
| Posted: 07/02/2002, 6:58 AM |
|
Hello,
1. please check SQL Server Login settings used: Windows NT authentication or SQL Server authentication. When connecting to db in CCS select the same authentication option in connection settings.
2. use fully qualified table names: select * from database_name.table_owner.table_name
3. You need to give the IUSR_<user_name> account access to the database. The ASP pages are logging in using that account.
|
|
|
|
|
