Sponsored White Papers, Webcasts, and Downloads
TechRepublic Resources
- ADO.NET database access made easy
- ADO.NET and ADO are quite different in many areas, such as connection classes, commands, and data readers. But don't get them confused. This introduction to ADO.NET should help set you off on the right foot.Although ADO.NET and ADO share some common concepts, they are different enough in many areas to...
- Tags: .NET, Databases, System.Data, Lamont Adams, Microsoft .NET Framework, System.Data.SqlTypes, System.Data.OleDb, System.Data.SqlClient, Microsoft ADO.NET, connection class, Microsoft SQL Server, OLE-DB data source, SqlClient, OLEDB, database
- Technical articles 2002-12-16
Additional Resources
- Microsoft OLE DB Provider for Visual FoxPro 9.0 (exe)
- The Visual FoxPro OLE DB Provider (VfpOleDB.dll) exposes OLE DB interfaces that you can use to access Visual FoxPro databases and tables from other programming languages and applications. The Visual FoxPro OLE DB Provider is supported by OLE DB System Components as provided by MDAC 2.6 or later. The requirements...
- Tags: OLE DB, Microsoft Corp., Databases, Enterprise Software, Software, Data Management
- Software downloads 2007-08-24
- SSIS has a strange little bug with set rowcount
- Last week, I described how impressed I was with my first experience using SQL Server 2005 Integration Services SSIS. Well, I've run into a quirk with the way SSIS handles certain SQL constructs. It doesn't make me change my overall impression of SSIS, but it's enough to take the bloom off the rose....
- Tags: OLE DB, SQL, Microsoft SQL Server 2005 Integration Services, Programming Languages, Databases, Software Development, Software/Web Development, Enterprise Software, Software, Data Management, Rex Baldazo
- Blog posts 2008-02-25
- what is the best driver for SQL
- For a VB front end and a SQL 7 back end what driver is best for the connection string..there are so many OLE DB choices.The SQL Server books say use:Provider= SQLOLEDB orProvider = MSDASQLI'm confused and the text is overwhelming. Can someone break it down for me. I used to...
- Tags: ADO, ma407@..., MSDASQL, ODBC, programming, server, SQL, SQLOLEDB
- Q&A 2005-03-21
- ODBC .NET Data Provider (msi)
- The ODBC .NET Data Provider is an add-on component to the .NET Framework. It provides access to native ODBC drivers the same way the OLE DB .NET Data Provider provides access to native OLE DB providers. The ODBC .NET Data Provider is intended to work with all compliant ODBC drivers...
- Tags: ODBC, Microsoft .NET, Microsoft Corp., Databases, Enterprise Software, Software, Data Management
- Software downloads 2007-08-29
- SimbaEngine SDK Technical White Paper
- SimbaEngine SDK is a Software Development Kit SDK that enables to build an ODBC, JDBC, or OLE DB Driver, or an ADO.NET Data Provider for data access to proprietary data sources. The SimbaEngine SDK is a set of components and tools for building a high-performance data connectivity solution that allows...
- Tags: ODBC, OLE DB, Microsoft ADO.NET, High-performance, JDBC, SimbaEngine SDK, Databases, .Net, Java, Enterprise Software, Software, Data Management, Software Development, Software/Web Development, Programming Languages
- White papers 2006-09-06
- problem : starting distributed transaction on oracle from sql server
- begin distributed transactioninsert into openrowset('MSDAORA','SMPTEST';'scott';'tiger','select * from dept') select '56','OFFICER','DELHI' From ownercommit transactionServer: Msg 7391, Level 16, State 1, Line 3The operation could not be performed because the OLE DB provider 'MSDAORA' was unable to begin a distributed transaction.OLE DB error trace [OLE/DB Provider 'MSDAORA' ITransactionJoin::JoinTransaction returned...
- Tags: jaydeeps, server, software, SQL, sql server
- Discussion threads 2005-05-19
- Microsoft Data Access Components (MDAC) (EXE)
- Microsoft Data Access Components MDAC 2.8 contains core Data Access components such as the Microsoft SQL Server OLE DB provider and ODBC driver. This redistributable installer for the MDAC 2.8 release installs the same Data Access components as Microsoft Windows Server 2003. This release does not include Microsoft Jet, the...
- Tags: Microsoft Corp., Microsoft Data Access Components, Microsoft Data Access Components 2.8, Databases, Enterprise Software, Software, Data Management
- Software downloads 2004-04-07
- XML Conversion tool Pro Edition (zip)
- XML Converter Professional is a set of XML data conversion software tools to interactively create XML data transformation. XML Converter unites data from ODBC, MS SQL Server, Oracle, MySQL databases, or from MS Office files into XML documents. It gives you ability to predefine XML transformation template scenario to create...
- Tags: Tool, XML Converter Professional, XML Converter, XML, Software/Web Development, Web Development
- Software downloads 2007-10-16
- SimbaProvider SDK Technical White Paper
- SimbaProvider SDK contains a robust MDX engine and is the leading solution for OLE DB for OLAP ODBO and XML for Analysis XMLA connectivity to multi dimensional OLAP and star-schema relational data sources. With SimbaProvider SDK, one can integrate their multi-dimensional server with the newest generation of analytic applications and...
- Tags: OLE DB, OLAP, SimbaProvider SDK, Data Mining, Databases, Enterprise Software, Software, Data Management
- White papers 2006-08-31
- Visual Open DB (EXE)
- The Visual Open DB is a generic data analyzing application that allows you to query any valid data source. It can be used by end users to perform data analysis and developers to interrogate database tables and views. The program can work with files of the following formats: Microsoft Access...
- Tags: Data Source, SQL, Microsoft Corp., Visual Open DB, Databases, Programming Languages, Enterprise Software, Software, Data Management, Software Development, Software/Web Development
- Software downloads 2005-03-21
- DTM Data Editor (exe)
- DTM Data Editor is a data viewer and editor for database professionals who are tired of wasting their time on mundane tasks. The program uses form-based interface and works with any ODBC, IDAPI or OLE DB data source. SQL statements are generated automatically and can by modified later. For data...
- Tags: Editor, DTM Data Editor, Databases, Storage, Enterprise Software, Software, Data Management, Hardware
- Software downloads 2007-04-26
- Guide to Oracle Berkeley DB for SQL Developers
- The Oracle Berkeley DB team is frequently asked, "How do I do in Berkeley DB?" So, this is an introduction to implementing much of the favorite SQL functionality in Oracle Berkeley DB. Not all SQL applications should be implemented in Oracle Berkeley DB - an open source, embeddable database engine...
- Tags: Developer, Oracle Corp., SQL, Oracle Berkeley DB Team, Programming Languages, Databases, Software Development, Software/Web Development, Enterprise Software, Software, Data Management
- White papers 2007-09-01
- White Paper: Data Modeling With db.*
- db.* is an open source DataBase Management System DBMS designed to provide powerful, high-performance capabilities for embedded database applications. By combining the relational and the network data model, flexibility, tremendous speed of operation and minimization of data redundancy are possible. This paper presents a technical background of both supported data...
- Tags: High-performance, Modeling, Db.*, Storage, Databases, Hardware, Enterprise Software, Software, Data Management
- White papers 2005-08-02
- DB Tools for Oracle (exe)
- DB Tools for Oracle is an integrated set of 'must have' tools for Oracle DBAs and developers. It includes all the tools needed for Oracle database monitoring, tuning, diagnosing, coding, reverse-engineering, creating, editing, debugging, benchmarking, auditing, and reporting. DB Tools includes the following components: SQL Editor and Debugger, PL/SQL Profiler,...
- Tags: Oracle Corp., Tool, Productivity
- Software downloads 2007-02-22
- DBBlobEditor (exe)
- DBBlobEditor is a database blob field edit tool. View/edit Blob Field (plain text, RTF, image, hex, HTML, and XML). Connect to any data source accessible via ADO using OLE DB Provider or ODBC (Oracle, SQL Server, MySQL, Access). Common image formats support (JPEG, GIF, BMP, PNG, and TIFF). Editing Blob...
- Tags: DBBlobEditor, Databases, Enterprise Software, Software, Data Management
- Software downloads 2008-01-11
- Edwin (zip)
- Edwin is a wizard-based software application for creating Web-service based (Service Oriented Architecture - SOA) data layers from the structure of your underlying data source. All data-sources accessible via OLE-DB are supported, which includes the vast majority of popular databases. Edwin will automatically create a large set of Web methods...
- Tags: Web, Stored Procedure, Record, DreamState Software, Edwin, Service-Oriented Architecture (SOA), Channel Management, Web Services, Middleware, Enterprise Software, Software, Marketing
- Software downloads 2008-06-20
- VB & ACCESS CONNECTION QUERY
- Set db = New Connection db.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=\ASHOKD$VB PROJECTDATAA.mdb;Persist Security Info=False" Set XL = New Recordset XL.Open "DATA0607", db, adOpenStatic, adLockOptimistic*/////BUT I WANT TO USEXL.OPEN "SELECT * FROM DATA0607 WHERE MONTH="+MT+" OR MONTH = "+MT1+",DB, ADOPENSTATICBUT THE ABOVE SYNTEX IS NOT WORKINGUsual way to do this...
- Tags: ashok.sharma@..., Set DB, programming, Microsoft Access, Microsoft Visual Basic
- Discussion threads 2007-02-12
- updating tables in DB from data being entered in another DB
- Hi Folks, I'm new to SQL server and I have a project I'm working on.I'm at the point where I'd like to setup a job that will run everyday to update certain tables in my DB by querying tables that are in another DB. Can anyone point me to where...
- Tags: pierrehar@...
- Discussion threads 2007-07-26
- SQL Server on 2 disks
- We have a db on a server that has two hard drives: one has c: while the other is partitioned into d/e: (yeah, I'd like another disk but that is not happening anytime soon)c: has the OSd: has data and logs e: has db/log backups c: & e: get backed...
- Tags: backup, database mssql mssqlserver sql server backups, disk, it management, Microsoft SQL Server, programming, server, software, webmaster@...
- Discussion threads 2007-01-22
- << Previous
- page 1 of 1
- Next >>
