Building a C# Chat Client and Server
A step by step tutorial teaching you how to create your own chat client and chat server easily in C#, for local networks or the Internet.
Getting Hard Drive Information
A C# tutorial showing you how to make use of WMI to extract information on disk drives, such as model, capacity, sectors and serial number.
UPS Shipping Calculator
This tutorial will teach you how to calculate the shipping cost based on the weight, height, length and depth of the box, the distance and the UPS service type.
Create Your Own Rich Text Editor
Creating a Rich Text Editor using JavaScript is easier to do than you might think, thanks to the support of modern browsers; this tutorial will walk you through it.
- ActionScript (5)
- ASP (7)
- ASP.NET (28)
- Assembly (1)
- C (6)
- C# (132)
- C++ (33)
- CSS (6)
- General (4)
- HTML (6)
- Java (28)
- JavaScript (38)
- MySQL (2)
- Objective C (1)
- Pascal (1)
- PHP (61)
- Python (3)
- Ruby (18)
- Silverlight (1)
- SQL (8)
- VB.NET (5)
- Visual Basic (3)
ADO Newsgroups
RSS Feed
Klip
Build ADO Connection String, Vista
Hi, expert, We recently upgrade from XP to vista. When I try to build a connection string for ADOConenction (I am using Delphi 5/6 TADOCONNECTION component). I got the error: "The procedure entry...
| On Wednesday, November 4th 2009 at 05:50 PM by Zhuo Li | No Replies |
Msdasql Default Provider
I've got an ADODB connection in VB6 code that is using a connection string without a provider specified, so it's defaulting to msdasql provider. I was wanting to know if there is a system wide or DSN...
| On Monday, October 12th 2009 at 03:16 PM by Sharmil | No Replies |
Disconnected Recordset Seek Failing?
Hi, I am trying to use the seek (ADO) method in some VBScript I am writing. This is using a disconnected recordset where this is no database involved so please keep that in mind. Anyway I...
| On Saturday, May 23rd 2009 at 08:35 AM by Anonymous | 1 Reply |
How To Execute This Parameter Query?
How do I run a simple ADO command execute query with a single parameter that is a long variable. Tried all sorts of contructions (passing the variable, Array(lngVar), etc.) but no success: Dim...
| On Sunday, May 10th 2009 at 01:13 PM by RB Smissaert | No Replies |
DataTable.Column["string"].Unique
I have a DataTable with two columns : GroupID which is primary key and second GroupName which I would like to hold groups name in a unique way, so that it may not be two groups with same name. Is there...
| On Saturday, May 9th 2009 at 05:17 PM by Aurora | 1 Reply |
How Does The OleDbDataAdapter Update Work?
I know this is really basic but I am baffled trying to get the DataAdapter Update to work. Let's say I simply want to change all names "Smith" to "Jones" and I want to use the DataAdapter and DataTable...
| On Thursday, May 7th 2009 at 11:26 AM by davepkz@hotmail.com | 1 Reply |
Data Access Performance
Hi. When dealing with large amounts of data (loading and updating one million of records), is there any new technology useful (linq, entity framework,...)? Or the only way is loading custom classes...
| On Wednesday, May 6th 2009 at 03:55 AM by Anonymous | 1 Reply |
HDBC Handle In DAO
Does anyone know how to get the raw HDBC handle from a VB ODBC ADODB SQL server connection. I have written a c++ dll that reads an encrypted password, decrypts it and then does an sp_SetAppRole...
| On Thursday, April 30th 2009 at 11:55 PM by Anonymous | No Replies |
Problems Setting Up References - ADO Vs DAO Conflicts (Error 3251)
I frequently have problems getting code to run, and it seems to be dependent on the order my libraries are listed in the Reference window. What most frustrates me is that even when I get all my code...
| On Thursday, April 30th 2009 at 01:52 PM by Anonymous | 1 Reply |
Access Runtime Database On Terminal Server
I am trying to get my Access 2000 mdb's to run on a Windows Server 2008 Terminal Server with only Access 2007 runtime installed. The first problem I have is that there is a security notice when opening...
| On Friday, February 27th 2009 at 04:32 PM by Anonymous | No Replies |
I Keep Getting Error "Problem In Mapping Fragment...COUNTRY_MODE_R
Table A: COUNTRY_LOOKUP COUNTRY_ID smallint Clustered, unique, primary key located on PRIMARY COUNTRY_ID TABLE B: COUNTRY_MODE_RULES CARRIER_ID int MODE_RULE_TYPE_ID int ORIG_COUNTRY_ID...
| On Wednesday, February 25th 2009 at 03:26 PM by Anonymous | No Replies |
I Keep Getting Error "Problem In Mapping Fragment...COUNTRY_MODE_R
Table A: COUNTRY_LOOKUP COUNTRY_ID smallint Clustered, unique, primary key located on PRIMARY COUNTRY_ID TABLE B: COUNTRY_MODE_RULES CARRIER_ID int MODE_RULE_TYPE_ID int ORIG_COUNTRY_ID...
| On Wednesday, February 25th 2009 at 03:26 PM by Anonymous | 2 Replies |
Datatype BIGINT Seen As DECIMAL
I'm accessing a SQL Server (2000) database from VC++ (VS2008, ported from VC6). There's a field defined as BIGINT in the database. The code is something like _RecordsetPtr rs; .... int ix = ......
| On Wednesday, February 11th 2009 at 01:58 PM by Anonymous | 1 Reply |
Datatype BIGINT Seen As DECIMAL
Accessing a SQL Server (2000) database from C++(VS2008, ported from VC6) There's a field with datatype BIGINT Code is something like _RecordsetPtr rs; .... ix = .. _bstr_t bs0 = rs->Fields->GetItem...
| On Wednesday, February 11th 2009 at 01:47 PM by Anonymous | No Replies |
Read Through A Datatable More Than Once
I have an application which has to export some data, then if the export is successful, update an sql database so that we don't export the same data more than once. The basic methodology is a timer...
| On Tuesday, February 3rd 2009 at 06:19 PM by Roger | 1 Reply |
Efficient Way For Retrieving Shaped Data
Hi, I'm writing a utility to retrieve a limited number of records from a database. The data I need is hierarchical Orders/Items/Modifiers. I want to retrieve 100 orders per iteration but I'm...
| On Tuesday, February 3rd 2009 at 04:55 PM by Anonymous | 1 Reply |
MSDART.dll Error
Hi All, I am getting this error in my application that has been running fine for couple years now. "Access violation at address 765B92DB in module 'MSDART.DLL'. Read of address 00002D36" I...
| On Monday, February 2nd 2009 at 03:14 PM by Anonymous | No Replies |
Calculated Field Criteria Fails In ADO Syntex
Hi, I am having ACCESS DB, using ADO trying to populates the result Field Names:GrossProfit,Sales GrossProfit/Sales- Calculated field is calculated GrossProfit-Sales-GrossProfit/Sales 1000-100-...
| On Thursday, January 15th 2009 at 03:40 AM by Anonymous | No Replies |
Is It Possible To Set A RowFilter Only Where A Column Exists?
I am reading in an xml document and storing it in a dataset ready to bind to a gridview. However, I would like to filter out all records that contain a field named ???AcHomeFeedId???. In my original...
| On Friday, November 7th 2008 at 01:18 PM by Anonymous | No Replies |
How Do I Tell If A Recordset Contains A Field?
Appologies if this is the wrong forum. I'm looking though AD using code like the following; objCommand.CommandText = _ "SELECT givenName,SN,telephoneNumber,mobile,facsimileTelephoneNumber...
| On Wednesday, October 29th 2008 at 04:28 PM by Anonymous | No Replies |
ADO 2.8 Reference???
I have created a VB6 SP6 project with a reference to ADO 2.8 library. I put the project on my laptop, but can only find a reference to the 2.7 library. How can I put the 2.8 library on my laptop?...
| On Friday, October 10th 2008 at 03:16 PM by Anonymous | No Replies |
VB; Status Or Error Of Oracle SQL 'update' Command .
If exist method for getting status or error in VB 6.0 See codes -- Dim Rs As New ADODB.Recordset Dim sSql As String On Error GoTo onError Rs.CursorLocation = adUseClient...
| On Wednesday, October 8th 2008 at 09:17 AM by TZ | 1 Reply |
GUID Datatype Issues Concerning JET Engine
Hi all. I'm experiencing some difficulties creating a field in a JET 4.0 mdb with ADO. The Task: Create a Field that contains GUIDs and at the same time is a AUTONUMBER. The Problem: Via using...
| On Thursday, October 2nd 2008 at 05:44 AM by Christian | No Replies |
Excel Meta Data - Empty Worksheets
Hello, with OpenSchema and adSchmemaColumns I read column information about worksheets. But on empty worksheets I always get one column named F1. How that? Here is the code: vCrit(0) = Empty...
| On Tuesday, September 16th 2008 at 09:16 AM by Klaus | No Replies |
Excel-File Is Locked
Hello, I want to copy some columns from an Excel worksheet to another document by ADO. First I connect to the XLS file, then I fetch some meta data and give it to a form where my user can selcet...
| On Tuesday, September 16th 2008 at 09:06 AM by Klaus | No Replies |
Double Quotes Executed On Connection But Not On Query
When edData.Text contains a double quote (") it will be executed on the Connection but not on the Query SQLString := 'UPDATE Categories SET [Description] = QuotedStr(edData.Text) WHERE CategoryID...
| On Wednesday, September 10th 2008 at 05:37 AM by DisturbedCookie | No Replies |
Will "Go" Cause The Error In ADO?
Hi, I want to make a program to execute some SQL script. I found some SQL sentences will be executed successfully in SQL Server Query Analyzer but failed in ADO. The SQL sentence like this:...
| On Wednesday, September 10th 2008 at 03:34 AM by bucher | No Replies |
Recordset.open, With SS2005, Changes CursorType To AdOpenStatic
I'm migrating a DB from SQLServer 2000 to SS2005, and code working fine with VB6 and SS2000, don't work with SS2005. I have a simple view: CREATE VIEW dbo.rptps_Compania AS SELECT Convert(...
| On Tuesday, September 2nd 2008 at 12:50 PM by Anonymous | 2 Replies |
How To "read" Rec Fr Access Table W/o Creating Recordset Every Ti
I need to access one record at a time in an unpredictable sequence using its primary key as the argument. I know that myRecordset.Find will sequentially scan the table to find the record, but that...
| On Monday, September 1st 2008 at 12:41 AM by Anonymous | 1 Reply |
Query Code, Access 2003 And Vbscript
Hi, I have a Access 2003 db which contains a query named "offers". I want to write in an ASP page (written in VBScript) the SQL text of this query. I tried this code: dim rs, rs2, fld set rs...
| On Thursday, August 21st 2008 at 07:59 AM by TeddyBoy | 1 Reply |
Retrie Stored-procedure Code (instead Of Execute It)
Hi, I'm coding a program that can browse through database schema and allow user to execute the SQL query, and view the result. something like a "mini" version of Visual C++ database project. The...
| On Wednesday, August 20th 2008 at 07:24 AM by Anonymous_5425 | 4 Replies |
Recordset Resync & Self-Join Table
Hi all, I need to refresh a row of a query (and a grid too). I overcome the problem with resync function. But if in the query, I join a table with itself, I got the following error : "Multiple-step...
| On Wednesday, August 20th 2008 at 03:12 AM by aestemp@yahoo.com | 9 Replies |
Excel: Microsoft.Jet.OLEDB.4.0: Empty Lines On Top Of A Sheet
I am trying to write an application wich will read excel sheet content I have to track excel sheet row numbers also. I use Microsoft.Jet.OLEDB.4.0 Provider To track sheet row numbers I use to loop...
| On Tuesday, August 19th 2008 at 04:26 AM by Anonymous | 1 Reply |
=?windows-1252?Q?SQLOLEDB_provider_internally_creates_multiple_connec?=
So the problem. Server logic uses its own implementation of secured access to data, so login and password used for ADO Connection object to its success connectiong to the server (via TCP/IP). Later...
| On Wednesday, August 13th 2008 at 05:54 AM by alex_wh@mail.ru | 6 Replies |
ADO2.8 XML
Hi all, I need to confirm something. I have an application using ADODB more specifically creating the dataset from xml. I have come across and problem when regional settings change. The format of...
| On Tuesday, August 12th 2008 at 11:55 AM by Anonymous | No Replies |
Compare DataSets
We're trying to minimize the number of postbacks to the server in our web application by allowing users to change rows in a grid on the client side. When they click the submit button, we need to update...
| On Monday, August 11th 2008 at 12:14 PM by Anonymous | 1 Reply |
ADOX Linked Tables Schema Name
All, I have written an access VBA program using ADOX which creates linked tables for every table seen in the SQL Database. We are using ADOX partially because it excludes the owner name and we avoid...
| On Monday, August 4th 2008 at 01:20 PM by codexpert71@gmail.com | No Replies |
Vista: CoCreateInstance On ADOConnection Fails In DLL
I'm unable to create an ADO connection from inside a DLL on Vista: hangs on CoCreateInstance and not a problem on XP. Any suggestions? Thanks.
| On Friday, August 1st 2008 at 10:09 AM by jonicorp | 3 Replies |
Entity Framework
Is the the entity framework available for VS 2008 professional edition? I have VS 2008 beta1 and .net 3.5 Sp1, but the ADO.net entity data model does not seem to be available for me. -- Arne Garvander...
| On Thursday, July 31st 2008 at 09:57 AM by Anonymous | 3 Replies |
MDAC/MSDORA Oracle Versions?
Hi all does anyone have any ideas as to what versions of oracle that MSDAORA (MDAC 2.8) supports? I've tried the MSDN website but havn't had any luck yet so thought perhaps i should ask here...
| On Wednesday, July 30th 2008 at 09:54 PM by buzz | 3 Replies |
Re: Problem With Expression Column
My following piece of code draws on Northwind sample database, in particular tables Orders and OrderDetails. Having added DataTables based on Orders and OrderDetails to a DataSet, I then added...
| On Wednesday, July 23rd 2008 at 06:11 AM by Mansoor A. Karim | 2 Replies |
Save/restore Recordset Doesn't Work With IStream (Q242249)
Hi, I need help with this. I tried everything (see below) but this doesn't work for a more real-life example. If you look at Q242249, it shows a simple example on how to serialize a Recordset into...
| On Wednesday, July 9th 2008 at 06:40 AM by Anonymous | 2 Replies |
Query Timeout
Hi Group, I using VB 6 and doing a query on an SQL server database. The query is on a view and has worked fine for a year or so. All of a sudden the user is getting query timeout. This is not due...
| On Friday, July 4th 2008 at 10:24 AM by david.cawkwell@tesco.net | 2 Replies |
ISAM Error Connecting To MDB And Using A Linked Sharepoint List
I have an MDB with a linked table to a Sharepoint List. Within Access 2007 I can read and write to this Sharepoint List, but when I use ADO to connect to the MDB with the OLE Jet provider and read...
| On Friday, June 27th 2008 at 12:31 PM by Anonymous | 2 Replies |
Disconnecting And Reconnecting Record Sets?
Can I perform a query, get a record set, and connect that record set to a different table in a different database as an alternative to executing a bunch of SQL INSERT statements? Thanks, Siegfried...
| On Thursday, June 12th 2008 at 11:17 AM by Siegfried Heintze | 1 Reply |
ADO Returns Empty Recordset Sporadically Under Interop Scenarios
Hello, I'm having a problem that actually is inside of a COM class with ADO that is used inside of interop scenarios from C#. I'm not sure if this is actually .NET specific or just a problem with...
| On Tuesday, June 10th 2008 at 11:09 PM by Josh | 1 Reply |
Appendchunk/Update Of Varbinary Column Fails On ODBC Linked Table?
I have a varbinary(max) column in a SQL Server table. I am trying to populate it through VBA code. The code fails when the update to this column is done with a large file and in a linked table environment...
| On Tuesday, June 10th 2008 at 05:07 PM by ash.sozoh@gmail.com | 1 Reply |
Problemas Using "Unique Table" In PostgreSQL
Working with SQL Server i havent any problem. But i start to work with PostreSQL and now i cannot update ADO.Recordset when de SELECT - SQL join other tables than de Principal or Updateable table....
| On Wednesday, June 4th 2008 at 11:54 AM by =?iso-8859-1?Q?Fabi=E1n_Tom=E1s_de_Paula?= | 1 Reply |
VB6 Async Connection Locks Up Closing Connection
I have a VB6 app using a SQL Server 2005 Express database as an event logger. The database is on the same PC as the app. The app opens an Async connection to the database and does a SQL INSERT to...
| On Tuesday, June 3rd 2008 at 04:24 PM by Anonymous | 1 Reply |
OO4O 2.1 Vs MDAC
Hi There, I have a typical scenario here. We're planning to move VB3 using OO4O 2.1 16-bit to VB6 with MDAC 2.8 / ADO or VB.NET with ADO.NET. Now I must distinguish and list out some of the features...
| On Tuesday, May 20th 2008 at 10:45 AM by Anonymous | No Replies |
News
Tutorials
Source Code
Pictures
Videos
Reviews
Special Reports
Bargains
Resources
Icons
Newsgroups
Knowledge Base
Books
Magazines
Downloads
Jobs
Forums
Search
About Geekpedia |
Legal |
More Resources |
Closed Sections |
Geekpedia Network |
