garevn Posted October 31, 2011 Share Posted October 31, 2011 I have managed to create a succesful connection and when i run a query into recordset area runs without problem.When i am trying to display data on internet explorer i get"The website cannot display the page HTTP 500"Probably something i am doing wrong with connectivity since i am not experienced.The dreamweaver connecion is this: <%' FileName="Connection_odbc_conn_dsn.htm"' Type="ADO"' DesigntimeType="ADO"' HTTP="false"' Catalog=""' Schema=""Dim MM_conntest_STRINGMM_conntest_STRING = "dsn=test ;uid=username;pwd=12345;"%> When i log into management studio i use those info: server type:database engineserver name: username-PC\SQLEXPRESSauthentication: windows authentication Any idea about what i am doing wrong? Link to comment Share on other sites More sharing options...
justsomeguy Posted October 31, 2011 Share Posted October 31, 2011 Did you create a DSN for this? Link to comment Share on other sites More sharing options...
garevn Posted October 31, 2011 Author Share Posted October 31, 2011 Yes i have create one and it is succesfull. I am thinking about any security issues on sql server dont know searching Link to comment Share on other sites More sharing options...
justsomeguy Posted October 31, 2011 Share Posted October 31, 2011 Disable the "friendly" error messages in IE if you're using it, and also on the server. You need the actual error message if you want to solve this. It might also be writing errors to a log somewhere. If you can't find the actual error then you need to add lines one by one in your code and figure out which line causes it to fail. You still won't know why without the error message, but at least you'll know which line is the problem. Link to comment Share on other sites More sharing options...
garevn Posted October 31, 2011 Author Share Posted October 31, 2011 i get this without friendly.An error occurred on the server when processing the URL. Please contact the system administrator.If you are the system administrator please click here to find out more about this error. Link to comment Share on other sites More sharing options...
justsomeguy Posted October 31, 2011 Share Posted October 31, 2011 http://learn.iis.net/page.aspx/564/classic-asp-script-error-messages-no-longer-shown-in-web-browser-by-default/ Link to comment Share on other sites More sharing options...
garevn Posted October 31, 2011 Author Share Posted October 31, 2011 Ok i am doneeeeeeeeeee after hours.i had 2 problems.since i use 64bit os i had to change an option into iis so it would anable soume 32bit made featuers work properly.Also i had to create a new acc in sql server with the proper rights and arange its info with the dns one. Anyway thanks a lot i will start doing my projext now i see u soon since i am not experianced!! Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.