Tutorials
Code
Knowledge Base
News
Forums
Pictures
Videos
Bargains
Icons
Newsgroups
|
Search
Tutorials and Code
Syndication
My Account
Community Forums
Webmaster Tools
Tech Jobs
|
Build ADO Connection String, VistaHi, 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...
Msdasql Default ProviderI'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...
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...
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...
DataTable.Column["string"].UniqueI 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...
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...
Data Access PerformanceHi. 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...
HDBC Handle In DAODoes 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...
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...
Access Runtime Database On Terminal ServerI 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...
I Keep Getting Error "Problem In Mapping Fragment...COUNTRY_MODE_RTable 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...
I Keep Getting Error "Problem In Mapping Fragment...COUNTRY_MODE_RTable 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...
Datatype BIGINT Seen As DECIMALI'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 = ......
Datatype BIGINT Seen As DECIMALAccessing 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...
Read Through A Datatable More Than OnceI 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...
Efficient Way For Retrieving Shaped DataHi, 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...
MSDART.dll ErrorHi 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...
Calculated Field Criteria Fails In ADO SyntexHi, 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-...
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...
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...
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?...
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...
GUID Datatype Issues Concerning JET EngineHi 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...
Excel Meta Data - Empty WorksheetsHello, 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...
Excel-File Is LockedHello, 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...
Double Quotes Executed On Connection But Not On QueryWhen 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...
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:...
Recordset.open, With SS2005, Changes CursorType To AdOpenStaticI'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(...
How To "read" Rec Fr Access Table W/o Creating Recordset Every TiI 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...
Query Code, Access 2003 And VbscriptHi, 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...
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...
Recordset Resync & Self-Join TableHi 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...
Excel: Microsoft.Jet.OLEDB.4.0: Empty Lines On Top Of A SheetI 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...
=?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...
ADO2.8 XMLHi 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...
Compare DataSetsWe'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...
ADOX Linked Tables Schema NameAll, 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...
Vista: CoCreateInstance On ADOConnection Fails In DLLI'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.
Entity FrameworkIs 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...
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...
Re: Problem With Expression ColumnMy 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...
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...
Query TimeoutHi 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...
ISAM Error Connecting To MDB And Using A Linked Sharepoint ListI 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...
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...
ADO Returns Empty Recordset Sporadically Under Interop ScenariosHello, 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...
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...
Problemas Using "Unique Table" In PostgreSQLWorking 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....
VB6 Async Connection Locks Up Closing ConnectionI 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...
OO4O 2.1 Vs MDACHi 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...
|
Latest Tech Bargains
Advertisement
Free Magazine Subscriptions
Today's Pictures
Today's Video
Other Resources
Latest Download
Latest Icons
|
PageRank™ Checker
Alexa Rank Checker
Domain-Name Lookup
ADO Newsgroups
RSS Feed
Klip
View More Magazines
View More Downloads
About Geekpedia |
Legal |
More Resources |
Closed Sections |
Geekpedia Network |
Copyright © Geekpedia 2004 - 2010. All Rights Reserved.
