datareader.getfieldtype

Having issue getting my website working...keeps returning the error below when I try to select from the database....

DataReader.GetFieldType(5) returned null.

This post seemed relevant,
http://social.msdn.microsoft.com/forums/en-US/sqlnetfx/thread/eae17407-2910-455c-92eb-8c28e5dabbc5

but the assembly mentioned here fails to load... Does anybody have any suggestions?

 

Another note on this issue really quick....column 5 is one of the new sql server 2008 data types (I have hosting with sql server 2008)....geography. That's the root cause of the issue. Whenever I try to add the assembly reference though, I get issues (won't load). I'm assuming there's no way for applications to access assemblies in the GAC....is this accurate? Is there a workaround for all this? Thanks in advance....

 

Whats the assembly you are referencing. If it is in the Server GAC you can access it unless you are overriding it with your applications configuration file to look to somewhere else.

 

I am trying to access Microsoft.SqlServer.Types. I put the reference in my web.config this morning, but got a "failed to load assembly" error when I loaded up my website, which is why I've been somewhat confused. Here's a forum post that talks about the issue a bit... http://social.msdn.microsoft.com/forums/en-US/sqlnetfx/thread/eae17407-2910-455c-92eb-8c28e5dabbc5 I didn't add a reference to the assembly's physical path directly, just to the gac assembly.

Admittedly, I'm still somewhat confused as to why this is happening (It works fine on my testing box (vista, vs 08, ss 08) but when I upload it I get these errors. Thanks for the post Raymond....

 

Any comments on this particular assembly and using geospatial data here? I really need to get this site up today.... thanks....

Aaron

 

Have you tried uploading the 'Microsoft.SqlServer.Types.dll' in your applications bin directory. You will also need to setup your web.config file to reference this component to your applications bin directory.