Jump to content

Archived

This topic is now archived and is closed to further replies.

khots

Conexão com MSDE

Recommended Posts

Olá, tdo bom pesoal ?gostaria da ajuda pra fazer uma conexão ao MSDE estou ultilizando ASP.Net WEB Matrixe banco de dados MSDE..se puderem me ajudar eu agradeço..vlw...n to conseguindo fazer a conexão..quero exibir os resultados em um dbgridabraçoss

Share this post


Link to post
Share on other sites

Agradeço muito a atenção.. mas deu o seguinte erro como dava antes :Server Error in '/' Application.--------------------------------------------------------------------------------Runtime Error Description: An application error occurred on the server. The current custom error settings for this application prevent the details of the application error from being viewed remotely (for security reasons). It could, however, be viewed by browsers running on the local server machine. Details: To enable the details of this specific error message to be viewable on remote machines, please create a <customErrors> tag within a "web.config" configuration file located in the root directory of the current web application. This <customErrors> tag should then have its "mode" attribute set to "Off".<!-- Web.Config Configuration File --><configuration> <system.web> <customErrors mode="Off"/> </system.web></configuration> Notes: The current error page you are seeing can be replaced by a custom error page by modifying the "defaultRedirect" attribute of the application's <customErrors> configuration tag to point to a custom error page URL.<!-- Web.Config Configuration File --><configuration> <system.web> <customErrors mode="RemoteOnly" defaultRedirect="mycustompage.htm"/> </system.web></configuration> já configurei o arquivo web.config pra off e continua dando erro.se puder ajudar eu agradeçovlwabraçoss

Share this post


Link to post
Share on other sites

E ae pessoalAproveitando os comantários estou querendo trabalhar também com o MSDE, e estou com dúvidas.O que eu quero saber é se o MSDE é apenas para trabalhar com aplicaticos WEB ou eu posso usar para distribuir com aplicativos desktops que serão distribuidos em máquinas individuais que não terão SqlServer instalado?Fiz uma aplicação em vb.net que usa SqlServer 2000 e vou instalar em uma máquina que não tem SqlServer

Share this post


Link to post
Share on other sites

pode usar para desktop tmb... ele é um SQL Server simplificado... mas o problema é q ele limita as conexoes simultaneas... e mais algumas coisas... q não lembro no momentoAtt,Carlos

Share this post


Link to post
Share on other sites

Me ajudem plzz hehehevou levar a maior ferrada se n conseguir arrumar isso a tempo..se alguém puder me salvar eu agradeço muito..abraçoss

Share this post


Link to post
Share on other sites

posta todo o seu web.config, só retire o q estiver com dados sigilosos!!!

Share this post


Link to post
Share on other sites

<?xml version="1.0" encoding="utf-8" ?><configuration> <system.web> <!-- DYNAMIC DEBUG COMPILATION Set compilation debug="true" to insert debugging symbols (.pdb information) into the compiled page. Because this creates a larger file that executes more slowly, you should set this value to true only when debugging and to false at all other times. For more information, refer to the documentation about debugging ASP.NET files. --> <compilation defaultLanguage="vb" debug="true" /> <!-- CUSTOM ERROR MESSAGES Set customErrors mode="On" or "RemoteOnly" to enable custom error messages, "Off" to disable. Add <error> tags for each of the errors you want to handle. "On" Always display custom (friendly) messages. "Off" Always display detailed ASP.NET error information. "RemoteOnly" Display custom (friendly) messages only to users not running on the local Web server. This setting is recommended for security purposes, so that you do not display application detail information to remote clients. --> <customErrors mode="Off"/> <!-- AUTHENTICATION This section sets the authentication policies of the application. Possible modes are "Windows", "Forms", "Passport" and "None" "None" No authentication is performed. "Windows" IIS performs authentication (Basic, Digest, or Integrated Windows) according to its settings for the application. Anonymous access must be disabled in IIS. "Forms" You provide a custom form (Web page) for users to enter their credentials, and then you authenticate them in your application. A user credential token is stored in a cookie. "Passport" Authentication is performed via a centralized authentication service provided by Microsoft that offers a single logon and core profile services for member sites. --> <authentication mode="Windows" /> <!-- AUTHORIZATION This section sets the authorization policies of the application. You can allow or deny access to application resources by user or role. Wildcards: "*" mean everyone, "?" means anonymous (unauthenticated) users. --> <authorization> <allow users="*" /> <!-- Allow all users --> <!-- <allow users="[comma separated list of users]" roles="[comma separated list of roles]"/> <deny users="[comma separated list of users]" roles="[comma separated list of roles]"/> --> </authorization> <!-- APPLICATION-LEVEL TRACE LOGGING Application-level tracing enables trace log output for every page within an application. Set trace enabled="true" to enable application trace logging. If pageOutput="true", the trace information will be displayed at the bottom of each page. Otherwise, you can view the application trace log by browsing the "trace.axd" page from your web application root. --> <trace enabled="false" requestLimit="10" pageOutput="false" traceMode="SortByTime" localOnly="true" /> <!-- SESSION STATE SETTINGS By default ASP.NET uses cookies to identify which requests belong to a particular session. If cookies are not available, a session can be tracked by adding a session identifier to the URL. To disable cookies, set sessionState cookieless="true". --> <sessionState mode="InProc" stateConnectionString="tcpip=xxx.xxx.xxx.xx:xxxx" sqlConnectionString="data source=xxx.xxx.xxx.xx;Trusted_Connection=yes" cookieless="false" timeout="20" /> <!-- GLOBALIZATION This section sets the globalization settings of the application. --> <globalization requestEncoding="utf-8" responseEncoding="utf-8" /> </system.web></configuration>

Share this post


Link to post
Share on other sites

troquei o localonly pra false e agora esta aparecendo a página em branco..tipo coloquei um datagrid e um botao e aparece tdo em bracno..vlw a ajuda..abraços

Share this post


Link to post
Share on other sites

mas num exibe o erro ainda??sem eu ver o erro nao saberei informar o q pode ser!!!

Share this post


Link to post
Share on other sites

Puts cara, sinceramente não sei o pq não está exibindo a msg de erro!!!Att,Carlos

Share this post


Link to post
Share on other sites

×

Important Information

Ao usar o fórum, você concorda com nossos Terms of Use.