|
Hello I am using vs2008. In that when i use Crystal Report in ASP.Net site it ask me for Database, username & password when i view it in browser? So what is the solution of this???
|
|
|
|
|
First of all you should correct your subject. there is no meaning of your subject.
are you using any external image in your crystal report ?
Thanks
-Amit Gajjar (MinterProject)
|
|
|
|
|
|
how to generate a link and send it by mail and when receiver receives this mail and when he first time click on this link then link has downloaded and then this link will automatically expire from the receivers mail?
|
|
|
|
|
Member 8600123 wrote: how to generate a link
Paste a Guid behind your query-string.
Member 8600123 wrote: send it by mail
Research the POP3-protocol, the internet is littered with examples
Member 8600123 wrote: when receiver receives this mail and when he first time click on this link then link has downloaded and then this link will automatically expire from the receivers mail?
Add abovementioned Guid to your database. Add a bit-column called "hasBeenSeen". Set the bit when the user requests abovementioned query-page with the corresponding Guid.
If you bring it as a story, then yes, sounds complex. If you divide it in smaller tasks, it becomes work.
Bastard Programmer from Hell 
if you can't read my code, try converting it here[^]
|
|
|
|
|
1. generate a link to a webpage with some query string parameter to uniquely indentify the link.
2. have a DB entry for "fresh/stale" it will be fresh till user has not visited the link, it will become stale once user has visited the link.
3. have a field for link generation time. if the link is not visited for say 6 hours after the generation. it will be considered as stale.
so when use want to generate link
1. create link, put fresh in DB, put current time.
2. when user visit the page check if the (linkstatus = fresh && genrationtime + 6hours < currenttime)
3. if above is true link is valid, perform operation n mark status as stale.
4. if 2 is false then tell the user link has expired
Every now and then say, "What the Elephant." "What the Elephant" gives you freedom. Freedom brings opportunity. Opportunity makes your future.
|
|
|
|
|
how to create a password protection on user level access means user can enter their password then first of all matgh the pwd to the user then show only their roles?
|
|
|
|
|
|
|
hi
Q1)
How to get the text "TestText" from below in code behind />.
"<input type='radio' name='rdoC' value ='21' />TestText
Q2)
How to find in child node of treeview by the value?<br />
Something like treeview1.findnode but to find in all childNodes aslo(not only in parents).
modified 18-Aug-12 3:42am.
|
|
|
|
|
Hi,
this[^] may help you for answering your first question
this[^] will help you for 2nd answer.
Google is really powerful tool to search anything, you only need a perfect searching string.
Hope next time you do search and then raise your question
Thanks
-Amit Gajjar (MinterProject)
|
|
|
|
|
Hi all,
In our ASP.Net application we are using Entity Framework 1.0, when I am trying to get data from entity framework, I am getting the following error (The underlying provider failed on Open and in inner exception login failed for user). And I am using SQL server 2008 R2 and Windows Authntication. In some forum, it is suggested to create User Id and Password for the AppPool and then add the same user id and password to the database also then change the connection string. That is not an option for me. My SQL Server is remote for my application from the development itself. I dont have local SQL Server, only client on my machine and Windows authentication is a must for me.
Can anybody please help me in resolving this issue at Entity Framework side or .Net side insteam of changing something in the Database, because its not owned by us.
Important: After I debugged it for a while I found that Database value is coming as empty string for the context's connection string object. Is it expected behavior entity frame work. Please can some body explain me. What would cause entity framework to get database name as empty string? Please help me in resolving this issue. and whats the importance of <dataConfiguration defaultDatabase="LocalSqlServer" />, is the database value picked depending on this? Should I change its value if I just have the client on my machine and SQL Server Database instance is running on the remote server. But still I connect the SQL Server using Windows Authentication. Please somebody help me in resolving this. And I am getting the following exception also:
System.Data.EntityException: The underlying provider failed on Open. ---> System.Data.SqlClient.SqlException: Login failed for user 'WADS\LNIDPC002580D$'.
at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
at System.Data.SqlClient.SqlInternalConnectionTds.CompleteLogin(Boolean enlistOK)
at System.Data.SqlClient.SqlInternalConnectionTds.AttemptOneLogin(ServerInfo serverInfo, String newPassword, Boolean ignoreSniOpenTimeout, Int64 timerExpire, SqlConnection owningObject)
at System.Data.SqlClient.SqlInternalConnectionTds.LoginNoFailover(String host, String newPassword, Boolean redirectedUserInstance, SqlConnection owningObject, SqlConnectionString connectionOptions, Int64 timerStart)
at System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection owningObject, SqlConnectionString connectionOptions, String newPassword, Boolean redirectedUserInstance)
at System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, Object providerInfo, String newPassword, SqlConnection owningObject, Boolean redirectedUserInstance)
at System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection)
at System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnection owningConnection, DbConnectionPool pool, DbConnectionOptions options)
at System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject)
at System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject)
at System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject)
at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection)
at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory)
at System.Data.SqlClient.SqlConnection.Open()
at System.Data.EntityClient.EntityConnection.OpenStoreConnectionIf(Boolean openCondition, DbConnection storeConnectionToOpen, DbConnection originalConnection, String exceptionCode, String attemptedOperation, Boolean& closeStoreConnectionOnFailure)
--- End of inner exception stack trace ---
at System.Data.EntityClient.EntityConnection.OpenStoreConnectionIf(Boolean openCondition, DbConnection storeConnectionToOpen, DbConnection originalConnection, String exceptionCode, String attemptedOperation, Boolean& closeStoreConnectionOnFailure)
at System.Data.EntityClient.EntityConnection.Open()
at System.Data.Objects.ObjectContext.EnsureConnection()
at System.Data.Objects.ObjectQuery`1.GetResults(Nullable`1 forMergeOption)
at System.Data.Objects.ObjectQuery`1.System.Collections.Generic.IEnumerable<t>.GetEnumerator()
at System.Collections.Generic.List`1..ctor(IEnumerable`1 collection)
at System.Linq.Enumerable.ToList[TSource](IEnumerable`1 source)
at DataAccessLayer.MessageObjectAdaper.GetMessages(Guid messageid) in D:\LNI Applications\Washington Stay at Work\SourceCode\StayatWork-VS2010\DataAccessLayer\MessageObjectAdaper.vb:line 46
Thanks & Regards,
Abdul Aleem Mohammad
St Louis MO - USA
|
|
|
|
|
Are the development machine and the DB server on the same domain?
|
|
|
|
|
Hi,
No they are not on the same domain, so does it matter? Can you please tell me what should I do if they are not on the same domain? And we are using Windows authentication.
Thanks in advance my friend.
Thanks & Regards,
Abdul Aleem Mohammad
St Louis MO - USA
|
|
|
|
|
Since the application pool user is not on the same domain, windows authentication won't work. How will SQL server know about your app pool user? It does not exist in Active Directory.
You need to enable SQL authentication or make your machine join the domain which has the SQL server.
|
|
|
|
|
Salam Eid Mabrook,
But the same thing is working in Enterprise Library, why only the Entity Framework giving the problems. But I don't have control on the SQL Server completely.
Just in case I am asking for the debugging reason, what could be the reason if we SQL Server and my machine is on the same domain. Because when I am logging in to the SQL Server I am logging without using any domain. May be its on the same domain. But Enterprise library is able to connect it without using any domain name.
If I am in the same domain what could cause the entity framework to get the database name in the context objects connection.
Thanks in advance.
Thanks & Regards,
Abdul Aleem Mohammad
St Louis MO - USA
|
|
|
|
|
Alikom AlSalam, Eid Mubarak 
Can you post the connection strings used in both cases? Does the DB admin allow public users on the database?
|
|
|
|
|
Hi,
Here are the connection strings.
<connectionStrings>
<add name="Connection String" connectionString="Database=Database;Server=LNIDDBTUMSQL24\STAYATWORK;Integrated Security=SSPI"
providerName="System.Data.SqlClient" />
<add name="StayAtWorkEntities" connectionString="metadata=res://*/StayAtWorkDataModel.csdl|res://*/StayAtWorkDataModel.ssdl|
res://*/StayAtWorkDataModel.msl;provider=System.Data.SqlClient;provider connection string="
Data Source=LNIDDBTUMSQL24;Initial Catalog=STAYATWORK;Integrated Security=True;MultipleActiveResultSets=True""
providerName="System.Data.EntityClient" />
</connectionStrings>
Thanks & Regards,
Abdul Aleem Mohammad
St Louis MO - USA
|
|
|
|
|
Can you try to change the EF connection to:
<add name="StayAtWorkEntities" connectionString="metadata=res://*/StayAtWorkDataModel.csdl|res://*/StayAtWorkDataModel.ssdl|
res://*/StayAtWorkDataModel.msl;provider=System.Data.SqlClient;provider connection string="
Data Source=LNIDDBTUMSQL24\STAYATWORK;Integrated Security=True;MultipleActiveResultSets=True""
providerName="System.Data.EntityClient" />
The difference between the connection strings is that the ENTLib connection connects to a named instance (LNIDDBTUMSQL24\STAYATWORK) while the EF connection connects to the default instance on LNIDDBTUMSQL24.
|
|
|
|
|
Hi,
I did it, I just copied database on my local machine and tried to connect using the following connection strings. In the place of Datasource value it is coming correct, but in the place of Database its always coming as empty String. Did I do any mistake during the entity frameworks mapping to the database because when I debugged following values are coming while connecting to my local database server also context.Connection.Datasource="(local)\STAYATWORK" or ".\STAYATWORK", context.Connection.Database="".
Something should be wrong. Do I need to change anything in this
<dataConfiguration defaultDatabase="LocalSqlServer" /> should put the server name or something here.
Following are the connection strings that I have used.
<add name="StayAtWorkEntities" connectionString="metadata=res://*/StayAtWorkDataModel.csdl|res://*/StayAtWorkDataModel.ssdl|
res://*/StayAtWorkDataModel.msl;provider=System.Data.SqlClient;provider connection string="
Data Source=(local)\STAYATWORK;Integrated Security=True;MultipleActiveResultSets=True""
providerName="System.Data.EntityClient" />
<add name="StayAtWorkEntities" connectionString="metadata=res://*/StayAtWorkDataModel.csdl|res://*/StayAtWorkDataModel.ssdl|
res://*/StayAtWorkDataModel.msl;provider=System.Data.SqlClient;provider connection string="
Data Source=.\STAYATWORK;Integrated Security=True;MultipleActiveResultSets=True""
providerName="System.Data.EntityClient" />
Thanks & Regards,
Abdul Aleem Mohammad
St Louis MO - USA
modified 19-Aug-12 19:53pm.
|
|
|
|
|
Try to add
Initial Catalog=STAYATWORK; to the connection string.
|
|
|
|
|
Hi,
Yes I added but its doing the same thing, its showing the database name as empty string, is entity framework having any problem connecting the database using Windows authentication. Thats what I am seeing when googling. Should I switch to SQL Server authentication? For that I need to talk to DBA.
Please help me.
Thanks & Regards,
Abdul Aleem Mohammad
St Louis MO - USA
|
|
|
|
|
Hi,
I found whats the problem is, if you can help me in solving it, it would be really great. When I am degging when Entity Framework class "StayAtWorkEntities" is trying to get the data from the SQL Server. There it is throwing exception, because application is trying to access the databse using "<domainname>\<machinename>" account instead of "<domainname>\<my user="" name="">" account.
But this "<domainname>\<machinename>" account, doesnt have access to the Database. Instead I have access to the database.
Now is there any way to force IIS to run these two applications Web Application and a WCF Service under my user account "<domainname>\<my user="" name="">".
I am also admin on the Server is there any way to force IIS to do that, I have tried by changing the Application Pool Identity to "LocalSystem", "Network Service" in both the cases its running under the same user account "<domainname>\<machinename>" which doesnt have access rights to access the database.
Thanks & Regards,
Abdul Aleem Mohammad
St Louis MO - USA
|
|
|
|
|
User accounts were lost from your post, but you can configure IIS App pool to run using any windows account.
as mentioned here[^]. But select "Custom Account"
|
|
|
|
|
Yeah Hesham,
I got it solved thanks for your help I have set my Windows user account on my Application pool Identity. Yes it has reolved all the problems.
Now its working fine.
Thanks a lot once again.
Thanks & Regards,
Abdul Aleem Mohammad
St Louis MO - USA
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
