Odbc Sql Server Driver Error 42000
Contents |
ASP.NET Community Standup Forums Help Home/ASP.NET Forums/Data Access/SQL Server, SQL Server Express, and SQL Compact Edition/ERROR [42000] [Microsoft][ODBC error 42000 microsoft odbc sql server driver sql server cannot open database SQL Server Driver][SQL Server]Cannot o... ERROR [42000] [Microsoft][ODBC SQL Server
Error 42000 Netezza
Driver][SQL Server]Cannot open database "ResourceUtilization" requested by the login. The login failed. [Answered]RSS 5 replies Last error 42000 microsoft odbc sql server driver sql server incorrect syntax near ' ' post Jun 05, 2012 04:18 PM by xbaldxaaronx ‹ Previous Thread|Next Thread › Print Share Twitter Facebook Email Shortcuts Active Threads Unanswered Threads Unresolved Threads Support odbc error codes Options Advanced Search Reply xbaldxaaronx Member 1 Points 18 Posts ERROR [42000] [Microsoft][ODBC SQL Server Driver][SQL Server]Cannot open database "ResourceUtiliz... Jun 05, 2012 03:19 PM|xbaldxaaronx|LINK I'm new to asp.net and managed to get a web page setup on my workstation that pulls info from a SQL database to display in Gridview. However; I've
Sql Native Error Code
had some trouble getting that working on a server. Whenever I browse to a page that uses DB info, I get an error. ERROR [42000] [Microsoft][ODBC SQL Server Driver][SQL Server]Cannot open database "ResourceUtilization" requested by the login. The login failed. I have an ODBC connection setup on the server. The database is also hosted on the same server. What am I missing? thanks. Reply Mikesdotnett... All-Star 179346 Points 26084 Posts ModeratorMVP Re: ERROR [42000] [Microsoft][ODBC SQL Server Driver][SQL Server]Cannot open database "ResourceUt... Jun 05, 2012 03:24 PM|Mikesdotnetting|LINK The user account you are using to connect to SQL Server does not have permission to connect. As an aside, you should not be using ODBC with SQL Server. It was deprecated 10 or more years ago. You should be using SqlClient:http://www.connectionstrings.com/sql-server-2008#p1 Cheers, Mike ASP.NET Tutorials Reply xbaldxaaronx Member 1 Points 18 Posts Re: ERROR [42000] [Microsoft][ODBC SQL Server Driver][SQL Server]Cannot open database "ResourceUt... Jun 05, 2012 03:47 PM|xbaldxaaronx|LI
(4060) : [Microsoft][ODBC SQL Server Driver][SQL Server]Cannot open database "DatabaseName" ODBC: 5 - ODBC error, 42000 (4060) : [Microsoft][ODBC SQL Server Driver][SQL Server]Cannot open database "DatabaseName" Silk Performer Improve customer satisfaction by delivering error 42000 microsoft odbc sql server driver syntax error or access violation reliable, high performing applications. Join group Get this RSS feed Home Forum Blog Wikis sqlstate 42000 error 102 Files Members Table of Contents Knowledge Base Silk Performer 9.5 reports WebPageForm(WebEngine: 100 - Uncompressing content failed., internal error-code: -3) '0'
Sql State 42000 Native Error 18456
Virtual Users shown in Help | About 'Could not Create AppLauncher' thrown when opening Silk Performer 2011 'Host Key is cached but in Registry' error reported when monitoring vmstat(ssh) measures in Silk Performance Explorer http://forums.asp.net/t/1811074.aspx?ERROR+42000+Microsoft+ODBC+SQL+Server+Driver+SQL+Server+Cannot+open+database+ResourceUtilization+requested+by+the+login+The+login+failed+ 'MeasureGet(RT: 18 - Measure not defined for measurepoint)' 'More than one server configured in client. First server is used' & 'Could not start session recording for server...' warnings returned at the start of a load test in Silk Performer when dynaTrace plugin is enabled 'Show TrueLog' option is disabled within the 'Analyze Errors' section of Silk Performance Explorer. 'Start' option disabled in the 'Evaluate Agent VUser Capacity' Dialog "A script http://community.microfocus.com/borland/test/silk_performer_-_application_performance_testing/w/knowledge_base/22034.odbc-5-odbc-error-42000-4060-microsoft-odbc-sql-server-driver-sql-server-cannot-open-database-databasename.aspx is trying to attach to the GUI..." when launching SAPGUI during the recording. "An error occurred while opening the project file" when trying to open a .Net Explorer Project "BrowserEngine: 32 - Internet Explorer request failed, INET_E_RESOURCE_NOT_FOUND" when running Browser-Driven LoadTests on CloudBurst instances "Change TM ART Folder Configuration" tool does not move "teechart5.ocx" "CitrixEngine: 6 - Connect failed, Could not get session interface" during record or replay. "CitrixWaitForWindowCreation(Citrix Engine: 21 - WaitForWindowCreation failed, Window should not be maximized - subsequent operations may fail). "Class Definition Not Found" error while recording against Oracle Forms 6i. "Could not create the Java Virtual Machine" error when installing SilkPerformer "Document Not Found" in TrueLog Explorer. "DOTNET: 3 - Loading object throw exception! Possible reasons: Wrong version of perfdotnetfw.dll, unhandled exception in constructor or insufficient permissions!". "DotNetCallMethod(DOTNET: 15 - Exception has been logged!, Only one
here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and policies of this site About Us Learn more http://stackoverflow.com/questions/38635983/error-42000-microsoftodbc-sql-server-driversql-servercannot-open-databas about Stack Overflow the company Business Learn more about hiring developers or posting ads with us Stack Overflow Questions Jobs Documentation Tags Users Badges Ask Question x Dismiss Join the Stack Overflow Community Stack Overflow is a community of 6.2 million programmers, just like you, helping each other. Join them; it only takes a minute: Sign up ERROR [42000] [Microsoft][ODBC SQL Server Driver][SQL Server]Cannot open database up vote 0 down error 42000 vote favorite ODBC DSN works nice from source but after deployment in IIS is shows ERROR [42000] [Microsoft][ODBC SQL Server Driver][SQL Server]Cannot open database "MyDatabaseName" requested by the login. The login failed. asp.net sql-server odbc database-connection dsn share|improve this question asked Jul 28 at 12:11 user3079383 63 If on IIS, anonymous access is enabled the Windows authentication to database server will fail. What I meant is that, odbc sql server the user which the web application is using for database login might be different than the one you test manualy. In general, for web applications we use a general database login user which is sent with connection string. –Eralper Jul 28 at 12:20 add a comment| active oldest votes Know someone who can answer? Share a link to this question via email, Google+, Twitter, or Facebook. Your Answer draft saved draft discarded Sign up or log in Sign up using Google Sign up using Facebook Sign up using Email and Password Post as a guest Name Email Post as a guest Name Email discard By posting your answer, you agree to the privacy policy and terms of service. Browse other questions tagged asp.net sql-server odbc database-connection dsn or ask your own question. asked 2 months ago viewed 30 times Related 3What is the simplest, most maintainable way to create a SQL Server ODBC Data Source?2Losing ODBC connection with SQL Server 2005 Database0Extended Stored Procedure with ODBC DSN0Access to Sql Server via ODBC from C# : ERROR [IM002] [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified0('42000', '[42000] [Microsoft][ODBC SQL Server Driver][SQL Server]Error converting data type nvarchar to int. (8114) (SQLExecDirectW)')0SQL Server 2