PC Review


Reply
Thread Tools Rate Thread

Connection to SQL 2000 from the Compact Framework

 
 
Imar Spaanjaars
Guest
Posts: n/a
 
      3rd Sep 2003
Hi there,

I am designing and developing a data layer for a Compact
Framework application that connects to a SQL Server 2000
on our (wireless) network.
Things work pretty OK: I can connect and retrieve data
etc.

However, I am trying to use the Microsoft Application
Blocks for DataAccess. They compile fine against the
Compact Framework, but as soon as I use a parameter to
invoke a Stored Procedure, its type is changed to
sql_variant, causing the following error:

"Implicit conversion from data type sql_variant to int is
not allowed. Use the CONVERT function to run this query."

Any idea how this is possible? I define them correctly,
AFAIK:


SqlParameter[] arParms = new SqlParameter[2];

arParms[0] = new SqlParameter("@ID", SqlDbType.Int);
arParms[0].Direction = ParameterDirection.Input;
arParms[0].Value = 33;

arParms[1] = new SqlParameter("@Description",
SqlDbType.VarChar);
arParms[1].Direction = ParameterDirection.Input;
arParms[1].Size = 50;
arParms[1].Value = "Test";

The Application Block runs fine on the .NET Framework....

Suggestions, ideas etc are more than welcome.......

Regards,

Imar

 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
data connection of .net Framework & .net Compact Framework =?Utf-8?B?SGV6YWw=?= Microsoft Dot NET Compact Framework 13 25th Nov 2007 11:31 PM
RAS in .Net Compact Framework using DialUP Connection JereeshVijayan@gmail.com Microsoft C# .NET 0 17th Nov 2005 06:58 AM
Wifi Drops down connection compact framework =?Utf-8?B?V0tzcDIx?= Microsoft VB .NET 0 15th Mar 2005 10:39 AM
MSSupport: Compact Framework connection issue Mike Microsoft Dot NET Framework 6 6th Aug 2004 02:35 AM
MSSupport: Compact Framework connection issue Mike Microsoft Dot NET Compact Framework 0 3rd Aug 2004 08:25 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 09:42 AM.