Solved

System.Exception: Unsupported TYPE attribute: Bit  Problem

Posted on 2004-10-05
3
268 Views
Last Modified: 2010-04-25
i keep getting these errors when i upload the pages to the server , while they work perfect on my local server

System.Exception: Unsupported TYPE attribute: Bit
at DreamweaverCtrls.DataSet.GetDbTypeFromString(String str)
at DreamweaverCtrls.DataSet.AddParameters(IDbCommand myCommand)
at DreamweaverCtrls.DataSet.DoInit()

please i need your help


for example see www.palpeople.org/english

0
Comment
Question by:daouddajani
3 Comments
 
LVL 9

Accepted Solution

by:
prifre earned 250 total points
ID: 12241781
I have not really a solution, but on
http://www.charon.co.uk/aspnetforums/ShowPost.aspx?PostID=2040

they write:
"This is probably because I'm moving from asp (recordsets) to asp.net (datasets) and I'm not fully aware of the differences in queries! When developing for asp I always used the advanced query option and hand typed my queries, but in asp.net they don't work the same.

In my SQL query I had the following which didn't work:

SELECT *
FROM dbo.orderinfo
WHERE orderid = @orderid

with the following params
Name: @orderid
Type: Integer
Value: IIf((Not Session("orderid") Is Nothing), Session("orderid"), "")

I flipped from 'Advanced' to 'Simple' in the DataSet window and let it generate the following

SELECT *
FROM dbo.orderinfo
WHERE orderid = ?

............ with the following params
Name: @orderid
Type: Integer
Value: IIf((Not Session("orderid") Is Nothing), Session("orderid"), "")

This now works .............. I guess it's all part of the learning and transition to .net. I'm now treading very carefully!"

might that help?

with a smile
/prifre
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

I still run into .cgi files every now and then. In some instances, I actually prefer the simplicity of a .cgi script to other options. Since I use DreamWeaver extensively, what I needed was a way to open .cgi scripts in Dreamweaver. And I wanted to …
Adobe Dreamweaver CS5 is a WYSIWYG web page editor that has advanced HTML, CSS, and Javascript rendering functionality and is probably the most well-known HTML editor available. Much of Dreamweaver's appeal centers around the Design View interfac…
Video by: Mark
This lesson goes over how to construct ordered and unordered lists and how to create hyperlinks.
Both in life and business – not all partnerships are created equal. As the demand for cloud services increases, so do the number of self-proclaimed cloud partners. Asking the right questions up front in the partnership, will enable both parties …

896 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now