I've been developing an ASP application that was working fine with Access, but I decided to switch to MSDE thinking that it will be the smarter thing to do down the road, but I can't get a logon and my other resources are of no help. I'm sure that that I'm missing something in the security settings, but I'll be damned it I can find it. Any help will be appreciated.
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
ASP page can't logon to MSDE
- Thread starter Roo2000
- Start date
What error message are you getting? Robert Bradley
- Thread starter
- #3
foxdev,
Thank you for your interest. The error codes are at the bottom of this document. I'm narrowing it down to the sign on syntax on my asp. The MSDE is set for SQL authentication and the DSN/connections seem to be fine. I'm just starting to learn ASP. I'm using 'Beginning ASP Database' by WROX which assumes that you are using Access Jet. I've made the switch to MSDE and now I need to update the page to reflect the new sign-on requirements. As of yet, I have not located the exact coding required, I'm hoping that you will help. I'm very comfortable in Access Jet and HTML, and I've also have numerous courses in VB, Java, and C++, but all in all, I'm still just a student. I need to make this final connection in order to complete my design environment. I know I'll find it somewhere soon, but your help would be enormously appreciated. Thanks again.
Microsoft OLE DB Provider for ODBC Drivers error '80004005'
Microsoft OLE DB Provider for ODBC Drivers error '80040e4d'
Thank you for your interest. The error codes are at the bottom of this document. I'm narrowing it down to the sign on syntax on my asp. The MSDE is set for SQL authentication and the DSN/connections seem to be fine. I'm just starting to learn ASP. I'm using 'Beginning ASP Database' by WROX which assumes that you are using Access Jet. I've made the switch to MSDE and now I need to update the page to reflect the new sign-on requirements. As of yet, I have not located the exact coding required, I'm hoping that you will help. I'm very comfortable in Access Jet and HTML, and I've also have numerous courses in VB, Java, and C++, but all in all, I'm still just a student. I need to make this final connection in order to complete my design environment. I know I'll find it somewhere soon, but your help would be enormously appreciated. Thanks again.
Microsoft OLE DB Provider for ODBC Drivers error '80004005'
Microsoft OLE DB Provider for ODBC Drivers error '80040e4d'
Microsoft OLE DB Provider for ODBC Drivers error '80040e4d'
[Microsoft][ODBC SQL Server Driver][SQL Server]Login failed- User:
Reason: Not defined as a valid user of a trusted SQL Server connection.
Microsoft OLE DB Provider for ODBC Drivers (0x80004005) [Microsoft][ODBC Microsoft Access Driver] The Microsoft Jet database engine cannot open the file '(unknown)'. It is already opened exclusively by another user, or you need permission to view its data.
br
Gerard
(-:
Better a known bug then a new release.
[Microsoft][ODBC SQL Server Driver][SQL Server]Login failed- User:
Reason: Not defined as a valid user of a trusted SQL Server connection.
Microsoft OLE DB Provider for ODBC Drivers (0x80004005) [Microsoft][ODBC Microsoft Access Driver] The Microsoft Jet database engine cannot open the file '(unknown)'. It is already opened exclusively by another user, or you need permission to view its data.
br
Gerard
(-:
Better a known bug then a new release.
- Status
Similar threads
- Locked
- Question
- Locked
- Question