Jump to content

linq to sql problems

- - - - -

  • Please log in to reply
3 replies to this topic

#1
doubleotwo

doubleotwo

    Newbie

  • Members
  • PipPip
  • 10 posts
Hello all,

I got the following problem,
im developing a web application locally on VS 2008 ( without SP1) and this all works like a charm.
Now i recently updated the app with some changes and reuploaded it to the IIS 6.0 server with windows server 2003.

This server has installed .NET framework 3.5 SP1 and all the other frameworks below it.

Now the error it state invalidcastexception when doing something with linq

So first tought was.... my datacontext is not up to date with the database on the server ...
I deleted all the linq to sql classes and re added them to my project... also did a complete backup of the database and restored it to the webserver.....

still the same **** .... i dont get it... why does this work locally with no error whatsoever and it crashes on the webserver.... do i need to put in extra lines in the webconfig, need to install something special for linq ?

actually i can blank out that last one, because i got another page in which i just insert a line in to the webserv db with the use of linq and no error at all...

mb is has to do with some asociations i made ? im really stuck here

what is the best next thing i can do ?, debug it on the webserver itself ? is it possible to debug it into the IIS itself, cuz installing VS 2008 on it and then do a debug will result in getting no error probably


**** i have a lot of questions :D

thx in advance !

#2
doubleotwo

doubleotwo

    Newbie

  • Members
  • PipPip
  • 10 posts
i recently added a dc.Connection.Open

where dc is the linq datacontext ... is this needed?

#3
doubleotwo

doubleotwo

    Newbie

  • Members
  • PipPip
  • 10 posts
35|error|500|De opgegeven conversie is ongeldig.|

which translated into, "the given conversion is not valid"

the only field i put in the database are 4 strings and a datetime, the datetime mb has a wrong format

#4
doubleotwo

doubleotwo

    Newbie

  • Members
  • PipPip
  • 10 posts
this isnt the problem, i converted the txt in the textbox to a datetime before i assign it to a linq entity
i tried every possible format before clicking the ADD button wich make a linq entity and inserts it in to the db

still get the error ...

now mb it has something to do with the combo box with has 60 000 rows ....




1 user(s) are reading this topic

0 members, 1 guests, 0 anonymous users