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
- Unable to add date to access database
- Hi I am trying to add a date field from vb 2005 to access database. However when I try to run the following code I gets error message that reads "Syntax error in INSERT INTO statement." Any help regarding this is highly apprecited. [code]Imports System.DataImports System.Data.CommonPublic Class Form1 ...
- Tags: Databases, database, hemant.mukherjee@..., Table1, ByVal
- Discussion threads 2007-10-28
- ADO console (exe)
- ADO console is a simple program that allows to query various databases, that have OLE DB or ODBC providers. It was created to execute SQL queries against different databases and to exchange data between them. It was mainly used with these providers: Microsoft OLEDB provider for Visual FoxPro (allows connecting...
- Tags: Console, SQL, Microsoft Corp., InformService, Programming Languages, Databases, Software Development, Software/Web Development, Enterprise Software, Software, Data Management
- Software downloads 2008-06-02
- Oledb / reading from an access database into textboxes using C#
- i'm having problems reading information from my database and posting them into textboxes on my windows form so i can perform functions on them/ i'm trying to use the OLedb but i just can't figure it out/ any help would be greatly appreciated ...
- Tags: Storage, karatj@..., OLEDB, database, C#
- Discussion threads 2007-04-24
- Link Excel Spreadsheet to another Excel Spreadsheet
- I have an Excel Spreadsheet that I am using like a database, and another to format and sort the data in multiple different ways. To explain this easier, I will call the first spreadsheet with all of the information in it, spreadsheet #1, and the other spreadsheet I will...
- Tags: Excel spreadsheet, ethomas1@..., spreadsheet, XLS1
- Discussion threads 2007-05-01
- GURA OLEDB DataGate (zip)
- The DataGates role is to provide the common data access methods required for communicating with a data source. The DataGate implements a standard interface that provides communication channels for an Object Director to perform data processes. As well as this, it implements standard CRUD functionality available for any calling application...
- Tags: Data Source, Data Access, D2O P/L, DataGates Role, DataGate
- Software downloads 2008-03-31
- Importing from Access into Oracle 10g?
- Hi, Does anyone have some suggestions on how to import Access data into Oracle 10 Express? Any suggestions will be appreciated.Thanks in advance.SQL Data ConnectorCan Oracle 10 create an oledb data connector? If so, access is just a connector away.
- Tags: Microsoft Office, Databases, pixelperson, Oracle 10, Oracle Corp., Microsoft Access, Oracle Application Server 10g
- Discussion threads 2007-04-09
- On-Demand Access to Distributed and Heterogeneous Data
- This paper discusses the variety of ways companies using Oracle Database 10g can share information in a heterogeneous environment. Oracle provides Transparent Gateways to common data stores and Generic Connectivity for data stores supporting OLEDB or ODBC. Transparent Gateways and Generic Connectivity make the non-Oracle system look like a remote...
- Tags: Microsoft Access, Oracle Corp., On-demand, Databases, E-mail, Enterprise Software, Software, Data Management, Online Communications
- White papers 2005-09-01
- DataGen 2006 (exe)
- DataGen is a test data generator. Generating true random data is not always the best solution because no human eye can see a bug among thousand of data records when all fields are looking like garbage. If there is a bug in a report, nobody will see that xT1LlOxe0zrzPd is...
- Tags: DataGen, XML, Programming Languages, Databases, Storage, Software/Web Development, Web Development, Software Development, Enterprise Software, Software, Data Management, Hardware
- Software downloads 2007-03-30
- Build a data-bound grid with C# and ADO.NET
- Data access is the basis of any application. In thisarticle, I will show you how to access SQL Server-based data using C# andADO.NET, as well as how to display the data in a data-bound grid control. I usea simple C# application as an example.ADO.NET architectureADO.NET allows you to work without...
- Tags: C#, data access, data source, grid, Irina Medvinskaya, Microsoft ADO.NET, Microsoft SQL Server, namespace, server
- Technical articles 2006-08-30
- SQLXML 2.0 RTM (msi)
- SQLXML enables XML support for your SQL Server Database. SQLXML 2.0 RTM allows developers to bridge the gap between XML and relational data. You can create XML View of your existing relational data and work with it as if it was an XML file. SQLXML allows you to: Build data...
- Tags: Microsoft SQL Server, SQLXML, SQLXML 2.0 RTM, XML, Databases, Enterprise Software, Software/Web Development, Web Development, Software, Data Management
- Software downloads 2007-09-17
- Access Database
- How do i connect to an access database from VB6?There are several ways (ODBC, DAO, etc). The problem is that it depends on the Access version and VB6 service pack. Which Access do you need to connect to?It will be an access 2000 database i want to connect to. I...
- Tags: Databases, database, Microsoft Visual Basic 6.0, Microsoft Access
- Q&A 2005-06-09
- Access data in a network
- I am have vb6 application with access database.It works fine on a standalone pc.But when I tryto run the application through a network from another pc it fails to connect the database . originally I use this to connect :con.open "Provider=Microsoft.Jet.oledb.4.0;" ...
- Tags: Access Data, App.Path, database, Microsoft Access, network, programming, tesfaye
- Q&A 2005-11-24
- ATReport (zip)
- The purpose of ATReport is to produce reports and charts from any database connectable via OLEDB, for this reason it is particularly suited for all programs based on databases that need a quick and easy tool for reporting and charting.
- Tags: Storage, Databases, Hardware, Enterprise Software, Software, Data Management
- Software downloads 2006-03-14
- TreeSharp (zip)
- TreeSharp is an easy to use querying tool designed to extract information from any odbc/oledb database (like SQL Server, Access, FoxPro) producing reports and charts in seconds. Thanks to its tree view of data you can select the desired subset of information from your database and render it as table,...
- Tags: TreeSharp, Databases, Business Intelligence, Storage, Enterprise Software, Software, Data Management, Hardware
- Software downloads 2006-07-03
- ASP website in Win2003 SBS Compared to online webhost
- I have a website containing a lot of asp code. I currently have it hosted at my webhost site running a Windows server and everything works great. I recently purchased a server running Win2003 SBS and am trying to set it up to run my site. I have everything set...
- Tags: Servers, Web site development, Databases, kq@..., Microsoft ASP, server, Win2003 SBS, Web site
- Discussion threads 2007-04-18
- Combining XML, ADO, and ASP
- Want to see how you can combine XML, ADO, and ASP? This project, outlined in our Web Development Zone TechMail, uses all three to put together a phone list program.Editor’s note: This article originally appeared in TechRepublic’s Web Development Zone TechMail. Subscribe, and you’ll receive information on Web-development-related projects and...
- Tags: Les Hamilton, XML, Microsoft ASP, XSL
- Technical articles 2001-08-06
- TreeSharp Express (zip)
- TreeSharp is an easy to use querying tool designed to extract information from any odbc/oledb database (like SQL Server, Access, FoxPro) producing reports and charts in seconds. Thanks to its tree view of data you can select the desired subset of information from your database and render it as table,...
- Tags: TreeSharp, Databases, Business Intelligence, Storage, Enterprise Software, Software, Data Management, Hardware
- Software downloads 2007-05-30
- 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
- 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
- << Previous
- page 1 of 1
- Next >>
