.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

DBTIME2 in standard OLEDB

Posted By:      Posted Date: September 07, 2010    Points: 0   Category :Sql Server
Hi I read the documentation about MSSQL 2008 and found the new data type - DBTYPE_DBTIME2 This type id (and DBTYPE2 structure) is defined in sqlncli.h Do you plan add this very usefull data type into official oledb technology (oledb.h)? Or OLEDB structures from "SQL Native Client" can be interpreted as standard OLEDB structures? --- What you can say about support of DBTYPE_DBTIME2 in ADODB? Thanks.

View Complete Post

More Related Resource Links

Microsoft SharePoint Online Standard Developer Guide

Developers Guide for SharePoint Online (Standard Offer). Microsoft® Office SharePoint® Online is a collection of Web-based tools and technologies built on Microsoft Office SharePoint Server 2007 that help you store, share, and manage digital information within your company. This white paper describes the customization (or extensibility) capabilities that are supported with the Standard offering of SharePoint Online

Insert data to Excel using OLEDB



I am trying to insert data to Excel Document using OLEDB as follows:-

 sql = "Insert into [MyFirstSheet$] (" + Title1 + "," +Title2 + "," + Title3 + ") 
values('" + Value1 + "','" + Value2 + "','" + Value2 + "')";
myCommand.CommandText = sql;

 sql = "Insert into [MyFirstSheet$] (" + Title1 + "," +Title2 + "," + Title3 + ") 

values('" + Value1 + "','" + Value2 + "','" + Value2 + "')";

myCommand.CommandText = sql;


But, the Title1 ,Title2, Title3 are in the 3rd row of the Excel Document. So, the data is not inserted.

Device detection: standard & mobile web applications


I would like to host standard web pages as well as mobile web pages on a single website/virtual directory.


Is there a simple way of sniffing out the machine type and then presenting either web or mobile application depending on the device?

Or is there a better solution other than creating separate website?

Many thanks

Data Points: Standard Query Operators with LINQ


LINQ to Objects and LINQ to Entities have an arsenal of Standard Query Operators that operate on sequences to perform a wide variety of operations.

John Papa

MSDN Magazine March 2008

OPC: A New Standard For Packaging Your Data


Open Packaging Conventions (OPC) defines a structured means for storing application data together with related resources. Learn about the benefits here.

Jack Davis and Andrey Shur

MSDN Magazine August 2007

Standard I/O: Console Appplications in .NET, or Teaching a New Dog Old Tricks


The Microsoft .NET Framework is not just about Windows Forms and Web services. This article discusses the simplest kind of Framework-based application-the console app-along with the frequently overlooked constructs of standard input/output and the pipe. When designed carefully, console applications offer a surprisingly powerful way of solving complex programming problems. One of the more exciting aspects of this approach is that while each application in the pipe is fairly simple, the result of their interaction can be a relatively complex task. Here the author explores the ins and outs of writing these console apps.

Michael Brook

MSDN Magazine February 2004

Encrypt It: Keep Your Data Secure with the New Advanced Encryption Standard


The Advanced Encryption Standard (AES) is a National Institute of Standards and Technology specification for the encryption of electronic data. It is expected to become the accepted means of encrypting digital information, including financial, telecommunications, and government data. This article presents an overview of AES and explains the algorithms it uses. Included is a complete C# implementation and examples of encrypting .NET data. After reading this article you will be able to encrypt data using AES, test AES-based software, and use AES encryption in your systems.

James McCaffrey

MSDN Magazine November 2003

How to use a drop down list to edit in the standard Edit.aspx with DD?


Hey All,

I'm brand new to Dynamic Data and to ASP.NET.  I've been able to fumble around and get the calendar extender up and running and a few other customization options implemented, but I can't seem to get this drop down list to work - even after reading tons of online info.  The good news is that my web page/application is VERY simple, so hopefully you guys can help me out.  I'm working in VB btw.

I have a list of road projects submitted to me by local governments.  One of the fields is SponsoringAgency, which has a limited number of possible entries (the names of member governments).  Thus, when they submit a new project, or edit an existing one, I want to limit the input into the field "SponsoringAgency." I'm trying to use a dropdownlist because I'm familiar with it from Access, but it may not be the best approach.  Imagine you just setup a brand new, standard DD website, how would you get this to work?

Methods tried and failed (probably because I don't understand them fully):

UIHint - The closest I can get with this is an error saying that since SponsoringAgency isn't a Foreign Key, I'm out of luck.

Creating a SponsoringAgency Table - In my data layer, I created a second table with a list of government names.  I then tried se

Connect to MS Access via OLEDB provider


I am attempting to use the 64-bit OLEDB Provider for Access found in the "Microsoft Access Database Engine 2010 Redistributable" to connect to and query an Access 2003 database that is on another server separate from my SharePoint server. I have not had any success making the connection. My SharePoint server is Windows Server 2008 SP2 and I am running MOSS 2007 (patched up to the April 2010 CU)

Here is the connection info in my Application Definition XML:

    <LobSystemInstance Name="LessonsLearnedDevOLEDB_Instance">
        <Property Name="AuthenticationMode" Type="Microsoft.Office.Server.ApplicationRegistry.SystemSpecific.Db.DbAuthenticationMode">RevertToSelf</Property>
        <Property Name="DatabaseAccessProvider" Type="Microsoft.Office.Server.ApplicationRegistry.SystemSpecific.Db.DbAccessProvider">OleDb</Property>
        <Property Name="rdbconnectionData Source" Type="System.String">\\server1\share1\Lessons.mdb</Property>
        <Property Name="rdbconnectionProvider" Type="System.String&qu

How can I get it back to a standard view?

I already convert the standard view from Sharepoint to XSLT Data View. I also change the column width, how can I get it back to a standard view?

Video: Standard Web Parts for SharePoint 2010 in Action

This video demonstrates how to build a Standard Web Part for SharePoint 2010. (Length 4:36)

System.Data.OleDb.OleDbException: Could not find installable ISAM.


Hi, i got the following error while i am trying to get my web application to run on windows server 2003. I've installed 2007 data access components on windows server 2003 but the web application does not seem to work. The codes that i use is as follows:

string strConn = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + address + ";Extended Properties=Excel 12.0;"; OleDbConnection objConn = new OleDbConnection(strConn); string strSQL = "SELECT * FROM [Sheet 1$]"; OleDbCommand objCmd = new OleDbCommand(strSQL, objConn);

OleDbDataReader oddReader = null;


oddReader = objCmd.ExecuteReader();







I've read a lot of forum posts and almost all of them mentioned ab out the connectionstring being wrong. However, when i ran the codes on my local machine, there were no errors. The error only show when i was running on windows server 2003.

I've underlined where the error is pointing to. Please advise. Thanks

Tooltips for rectangles - there must be a standard way of doing this

I am implementing a graphic display that shows a bar with lighting changes over time.  Lights turn on and off according to a schedule. I already have code to show a series of different colored adjacent rectangles, with the color indicating the light level.  This is all drawn on a Graphics object, using FillRect. I would like to have a ToolTip for each rectangle, showing the lighting value (in Lux).  There seems to be no way to assign a ToolTip to a FillRect area, so I assume that I will have to dynamically create either Panel or PictureBox objects that show the colors.  Of course these will have to be Disposed when the window is redrawn. In some cases, I need to show a Hatch pattern (with HatchStyle) so it will not always be a solid color. Is there a simple and straightforward way to do this?  Is there another component that I am overlooking. I'm using VS2008 and C#, .NET 2.0. Thanks in advance, Michael Bate    

Output parameters in OLEDB Command component - SSIS 2008

I have a package that I developed in SSIS 2005 and recently ported to 2008. Everything runs great except an OLE DB Command component that calls a stored procedure that uses output parameters. When I try to run this, I get this error: Error: 0xC0202009 at Data Flow Task, OLE DB Command [100]: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80004005. An OLE DB record is available. Source: "Microsoft SQL Server Native Client 10.0" Hresult: 0x80004005 Description: "Syntax error, permission violation, or other nonspecific error". Error: 0xC004701A at Data Flow Task, SSIS.Pipeline: component "OLE DB Command" (100) failed the pre-execute phase and returned error code 0xC0202009. When I do the same thing in SSIS2005, it works fine. So I setup a new package with 1 data flow. In that data flow, I added a source component, an OLE DB Command, and a destination.  I then tested this with a stored procedure that took no parameters. It worked fine. I then tested it with a stored procedure with 1 parameter defined as OUTPUT. This generated the error.   Is there an issue with output parameters in an OLE DB Command in SSIS 2008?   Thanks!http://bobp1339.blogspot.com

SQL2008 Standard setup failed. The performance counter registry hive is corrupted.

OS: Windows7 Ultimate 64bit (Traditional Chinese HKSAR) SQL: SQL Sever2008 RC2 Standard English (either x86 or x64) I have searched for answers on the web, tried all of them and still cannot get pass. 1. manually rebuild Performance Counter Library values as suggested in http://support.microsoft.com/kb/300956/en-us 2. string test = string.Format ("{0,3}", CultureInfo.InstalledUICulture.Parent.LCID.ToString ("X")).Replace (" ", "0"); which shows "31748" for me, added it under HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows NT\CurrentVersion\Perflib (with values from 009) 3. C:\windows\systrem32\lodctr /r to rebuild counters.   The error just won't go. Actually, I just want to use the management studio to connect to SQL Server2008.. Is there a way to install only the management studio? I am willing to give up installing SQL Server2008 on my Windows7.   Thanks in advance.

Will SQL Server Compact feature an updated and more capable OLEDB driver

Hi, Earlier, we found problems with using SQL CE 3.5 via OLEDB. While some limited functionality was available and data can be accessed via commands and recordset via OLEDB/ADO from, say, Excel or Access, we were unable to access SQL CE directly from other data-driven packages that nominally support OLEDB, most importantly SAS and SPSS. So our question is whether SQL Server Compact will feature an updated and more capable OLEDB driver? Thx and regards, Ralph

OLEDB Source Problem?

Hi all, My source is oracle am loading the based on process date. I took one variable. Changed evaluate as expression=true. In expression I wrote below query. My total records 696148.only 695590 are loaded in my staging table. After 30 min also its showing yellow color with same records. I changed my process date. Same thing happened. What is the problem I didn’t find? "select member_number,tran_id,tran_dt,store_no,tran_line_id,tier_id, disc_prog_id,disc_prog_lev_id,sku_no,coupon_amt,total_qty,total_price_amt, earned_amt,stmt_amt,paid_dt,sales_stmt_status_code,process_date, orig_tran_id,stmt_num,discount_amt,master_number,order_channel_cd, category,tran_type  from sales_stmt_detail  where to_char(process_date,'MM/DD/YYYY') =" + "'" + @[User::V_SQLProcessDate] +"'" Thanks cmk..
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend