Odbc<< Oledb? - .NET Framework

ram_palavalasa

Hi all,

I have a assignment of vc++.net and sybase to populate data and
generate reports which is the best one?
is OLEDB more efficient than ODBC? i think OLEDB itself is a layer on
the ODBC..then how it can be?
Thanks,
RAM
--
ram_palavalasa
------------------------------------------------------------------------
ram_palavalasa' s Profile: http://www.hightechtalks.com/m320
View this thread: http://www.hightechtalks.com/t365341

Apr 21 '06 #1

Subscribe Reply

1503

Marcus Heege

ODBC is a WIN32 based DB agnostic data access API
ODLEDB is a COM based DB agnostic data access API

Whether one is layered on top of the other depends on the concrete
implementations . AFAIK the early versions of the SQL Server OLE DB provider
have been layers on top of the SQL Server ODBC driver, but that is long long
ago. What you may think of is the OLEDB provider for ODBC, which is in fact
a bridge provider, but you are not forced to use it. If you choose a DB
specific OLE DB provider, chances are very good that it is a native one (not
layered on another DB api). Ask the developer of the provider if you need to
make that sure.

Marcus
"ram_palavalasa " <ra************ *******@no-mx.forums.yourd omain.com.au>
wrote in message
news:ra******** ***********@no-mx.forums.yourd omain.com.au...

Hi all,

I have a assignment of vc++.net and sybase to populate data and
generate reports which is the best one?
is OLEDB more efficient than ODBC? i think OLEDB itself is a layer on
the ODBC..then how it can be?
Thanks,
RAM
--
ram_palavalasa
------------------------------------------------------------------------
ram_palavalasa' s Profile: http://www.hightechtalks.com/m320
View this thread: http://www.hightechtalks.com/t365341

Apr 21 '06 #2

pvdg42

"ram_palavalasa " <ra************ *******@no-mx.forums.yourd omain.com.au>
wrote in message
news:ra******** ***********@no-mx.forums.yourd omain.com.au...

Hi all,

I have a assignment of vc++.net and sybase to populate data and
generate reports which is the best one?
is OLEDB more efficient than ODBC? i think OLEDB itself is a layer on
the ODBC..then how it can be?
Thanks,
RAM
--
ram_palavalasa
------------------------------------------------------------------------
ram_palavalasa' s Profile: http://www.hightechtalks.com/m320
View this thread: http://www.hightechtalks.com/t365341

Have you contacted Sybase and asked them what they recommend? Typically the
best and most up to date technologies are provided by the DBMS vendor. They
should be able to tell you what's best for your application.

Apr 21 '06 #3

Similar topics

3431

Access <- > SQL Server

by: Jegger | last post by:

Hello! We have following situation; network with 100 users, aplication developed in Access, user DB deployed on SQL Server. Is it better to create query inside aplication (with code) and then pass it to SQL Server for execution or is it better to have all these queries saved like stored procedures and then called from aplication?

Microsoft SQL Server

7128

Column XXXX not in specified tables. (#-206) <--- Please HELP!

by: Gb | last post by:

Hi There, I have: select myTable.*, Case When myTable.problem_CLOSE_date = myTable.problem_creation_date then 2 When myTable.problem_CLOSE_date >0 and myTable.problem_status='C' then 3 When myTable.problem_CLOSE_date >0 and myTable.problem_status='R'

DB2 Database

1747

IIS 6.0 ASP.NET Process Identity and ODBC

by: Aras Kucinskas | last post by:

Hi, My WS ASP.NET application runs on IIS 6.0 and should connect to FoxPro DB on file server over OLE DB ODBC connection. Special user is created on file server for this application. I cannot find the right solution how to change Process Identity. App impersonates some user identity <identity impersonate="true" userName="MyUser" password="MyPass" />

ASP.NET

1789

ODBC module and strange date reference <...>

by: dananrg | last post by:

Been using the ODBC module for Python 2.1 (Win32) and had another question. When I return data from date columns, it's in a strange object form, e.g. <something or other> (don't have the output in front of me>. What's an easy way to convert date objects into a human-readable string? I'm using this module to extract data from an Oracle database, then converting it to a flat-file for import into an old flat-file database on a mainframe. I...

Python

5716

Update <table Name> Set <fields> where condition

by: komatouch09 | last post by:

Hi I am new to visual basic. I write program to navigate & update data from table. My database is in Informix & use ODBC connection. When I nevigate the data it works properly. When I Update the record its also updated but after that if I try to navigate it its giving error "Row cannot be located for updating. Some values may have been change since it was last read". My code is as follows - Option Explicit Dim cnn As Connection Dim...

Visual Basic 4 / 5 / 6

9190

Oracle 10g RC2 ODBC Access - odbc failed - where xyz <> "S"

by: network-admin | last post by:

We have Problems with Access query on Oracle 10g Database with ODBC Connection. The Query_1 is such as select * from xtable where ycolumn <"S" Result = ODBC Faild ----------------------------------------------------

Microsoft Access / VBA

2444

ODBC connection gives Token <END-OF-STATEMENT> was not valid

by: PeterA | last post by:

I have a Windows PC connecting to ISeries with ODBC. The windows PC uses various SQL statements to connect to DB2 and download/upload data. Data downloads/uploads appear to be OK and I can't see any data errors but I'm getting this message in the job log: Token <END-OF-STATEMENT> was not valid. Valid tokens: + - AS <IDENTIFIER>. Message ID . . . . . . : SQL0104 Severity . . . . . . . : 30 Message type . . . . . : Diagnostic ...

DB2 Database

2822

ODBC error "could not open file <path>\dba.mdb"

by: dryajov | last post by:

Hi I'm not sure if this should go here in the first place, this is more likely an ODBC driver issue. I'm having the strangest behavior when trying to do an insert into an access database from a C++ application, thru ODBC. I'm able to successfully open a connection to the DB and perform selects, but when I try to do an insert the strangest thing happens, ODBC throws an error saying that it can't open the "dba.mdb" file, which is not the db...

Microsoft Access / VBA

1411

<newbie> ODBC issues!

by: Jeff | last post by:

hi asp.net 2.0 i've used connectionstrings like this one for my webproject: connectionString="Server=Pdc1;Database=Testing;Integrated Security=false;User ID=tester;Pwd=hardtoguesspwd;" /> But now I need to change to using odbc as the webhosting company only support odbc. So from my understanding I need to change my

ASP.NET

9672

What is ONU?

by: marktang | last post by:

ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...

General

9519

Changing the language in Windows 10

by: Hystou | last post by:

Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...

Windows Server

10439

Problem With Comparison Operator <=> in G++

by: Oralloy | last post by:

Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...

C / C++

10215

Maximizing Business Potential: The Nexus of Website Design and Digital Marketing

by: jinu1996 | last post by:

In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...

Online Marketing

9043

AI Job Threat for Devs

by: agi2029 | last post by:

Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...

Career Advice

7541

Access Europe - Using VBA to create a class based on a table - Wed 1 May

by: isladogs | last post by:

The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...

Microsoft Access / VBA

5437

Trying to create a lan-to-lan vpn between two differents networks

by: TSSRALBI | last post by:

Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...

Networking - Hardware / Configuration

5563

Windows Forms - .Net 8.0

by: adsilva | last post by:

A Windows Forms form does not have the event Unload, like VB6. What one acts like?

Visual Basic .NET

4113

transfer the data from one system to another through ip address

by: 6302768590 | last post by:

Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system

C# / C Sharp