TECHNOLOGIES
FORUMS
JOBS
BOOKS
EVENTS
INTERVIEWS
Live
MORE
LEARN
Training
CAREER
MEMBERS
VIDEOS
NEWS
BLOGS
Sign Up
Login
No unread comment.
View All Comments
No unread message.
View All Messages
No unread notification.
View All Notifications
Answers
Post
An Article
A Blog
A News
A Video
An EBook
An Interview Question
Ask Question
Forums
Monthly Leaders
Forum guidelines
dc
NA
663
0
C# linq to sql designer
Feb 4 2013 10:16 PM
In a C# 2008 desktop application that uses linq to sql to connect to a sql server 2008 r2 database, I am getting an error message. The error message did not occur when I was executing the application on my own workstation and I am pointing to a test database where I have sa priviledges. This database also has 3 new triggers on one particular database. This error occurs when I am pointing to a different test database.
I am getting the following error:
2013-02-04 16:13:58.5695|ERROR|sampleclient.Sample|Error Processing --> Specified cast is not valid.
2013-02-04 16:13:58.5695|ERROR|sampleclient.Sample|************* Stack Trace *******************
2013-02-04 16:13:58.5851|ERROR|sampleclient.Sample| at System.Data.Linq.SqlClient.SqlProvider.Execute(Expression query, QueryInfo queryInfo, IObjectReaderFactory factory, Object[] parentArgs, Object[] userArgs, ICompiledSubQuery[] subQueries, Object lastResult)
at System.Data.Linq.SqlClient.SqlProvider.ExecuteAll(Expression query, QueryInfo[] queryInfos, IObjectReaderFactory factory, Object[] userArguments, ICompiledSubQuery[] subQueries)
at System.Data.Linq.SqlClient.SqlProvider.System.Data.Linq.Provider.IProvider.Execute(Expression query)
at System.Data.Linq.DataQuery`1.System.Linq.IQueryProvider.Execute[S](Expression expression)
at System.Linq.Queryable.SingleOrDefault[TSource](IQueryable`1 source)
Can you tell me if my problem can be permissions on the database? If so can you tell me what type of permission I need to give to the triggers?
Reply
Answers (
0
)
C# linq to sql permissions
Import data from access to excel using VBA & SQL