ASP.NET, SQL Server, WPF, C#, VB.NET

i cant get join to work with visual foxpro driver... 
 
this is the query im running... 
 
SELECT     item.itemnumber, item.mfgr, item.description, 
 
item.extendeddescription, Oinvcount.conditioncode, Oinvcount.qty, 
 
totalsub.totalsubst, Oinvcount.qty + totalsub.totalsubst AS sellable 
 
FROM         item, 
 
{ oj   (SELECT     itemid, conditioncode, COUNT(itemid) AS 
 
qty 
 
FROM          inventory 
 
WHERE      (conditioncode <> 'REP') 
 
AND (conditioncode <> 'TBE') 
 
AND (conditio ...

CENTRAL ÚNICA DE VENDAS 
 
10 Marcas de ratreadores, Compare e Compre. 
 
Rastreador de Veículo 
 
Rastreadores de Veículos 
 
Rastreador GPS 
 
Rastreadores GPS 
 
Rastreador Ituran 
 
Rastreadores Ituran 
 
Rastreador Portátil 
 
Rastreadores Portáteis. 
 
Assistência 24 Horas 
 
Visite agora mesmo nosso site. 
 
http://tel011-50523122.vila.bol.com.br/ 
 
Graber - Teletrim - Tele Trim - Ituran - 
 
Rastreadores gps , Localizadores, Bloqueadores 
 
Graber - Teletrim - Tele Trim - Ituran - 
 
Ra ...

ASP.NET 2.0 (VB.NET) 
 
MS Access 2003 DB 
 
Connection string : 
 
<add name="XXXXXConnectionString" 
 
connectionString="Provider=Microsoft.Jet.OLEDB.4.0;Data 
 
Source=E:\XXXXX\XXXXX.mdb;Persist Security Info=True;" 
 
providerName="System.Data.OleDb" /> 
 
---------------------------------------------------- 
 
The thing is that the "Unspecified Error" is random, and with a random error 
 
there is nothing you can do. 
 
Thanks....

I'd like to pass to my provider rather complicated commands, which are user 
 
unfriendly, when typed by hand. I would like to allow users to create such 
 
command (specify property?) in custom way when they use my provider from (for 
 
example) Excel or any other application using Data Link Dialog Box. Is there 
 
any way to create additional tab on this dialog or to create custom editor 
 
for properties, so I could let my users create commands (properties) in more 
 
friendly way? Any help will be appriciated.

Hi All, 
 
I am trying to develop an OLE DB Provider using the ATL template “UpdatePV 
 
Sample”. I have a problem that crystal report shows only one row of a table 
 
from this provider. Where as the same provider is returning complete table in 
 
a C# application. Can someone please help me to identify the problem or 
 
implementation I need in provider to get complete table in Crystal Report? 
 
Also the server explorer in Visual Studio 2003 doesn’t fetch any record from 
 
the provide  ...

Hi, 
 
Does ADO always get out parameter IMultipleResults in 
 
ICommandText::Execute or in some cases it can be IRowset ? If you know 
 
one case that will call IRowset please write what is it. 
 
Thanks, 
 
Gilad.

Hi, 
 
I'm trying to follow ADO calls for the scenario of select statement, 
 
change value and update it. 
 
set rs = CreateObject("ADODB.RecordSet") 
 
.. 
 
.. 
 
rs.fields("name").value = "new_value" 
 
rs.update 
 
Select statement in ADO creates ICommandText object. Its method Execute 
 
creates IRowset object. 
 
I understand IRowsetUpdate should be created so its method Update can 
 
be used. However, I don't see any QueryInterface from IRowset to 
 
IRowsetUpdate or anything else after  ...

Hey all-- 
 
At work, we recently upgraded the Terminal Server from the 2000 version to 
 
Windows Server 2003 R2 Enterprise Edition SP1. Actually, the 2000 box had a 
 
catastrophic disc failure and is DEAD. 
 
Anyways, a vb6 application that connects to an Access database is now 
 
throwing an error on this new Terminal Server, specifically: 
 
-2147024769 Automation Error The specified procedure could not be found 
 
The form of the connection is: 
 
Global gconn as New ADODB.Connection 
 
gc ...

Hello 
 
I've written a simple OLE DB provider from scratch (without ATL) and I have 
 
problems with registering my provider with Microsoft Data Link. 
 
These are steps I performed in order to register my DLL. 
 
regsvr32 ComDll.dll 
 
which makes following keys appear in the registry: 
 
[HKEY_CLASSES_ROOT\ComDll.DummyDataSource] 
 
@="Zbyszkowy Testowy OLE DB" 
 
[HKEY_CLASSES_ROOT\ComDll.DummyDataSource\CLSID] 
 
@="{af30aaaa-aaaa-abcd-ceE0-0F4A44FC38C4}" 
 
[HKEY_CLASSES_ROOT\ComDll.DummyD ...

Hello, 
 
in the newsgroups are some entries around about hidden but working System 
 
DSNs without a solution. 
 
I Experienced the same Problem, and found with luck a solution. 
 
It seems that the empty standard entry which exists in every Key was invalid. 
 
I just deleted him - he reappeared - and everything was working fine. 
 
Regards. 
 
-- 
 
Martin Forster 
 
Atos Origin Austria

Hello, 
 
i read rows from table using: 
 
CTable<CDynamicAccessor> table; 
 
...... 
 
table.GetStatus(l+1,&status); 
 
table.GetColumnType(l+1,&type); 
 
table.GetLength(l+1,&length); 
 
table.GetValue(l+1); 
 
For varchar data type variable "length" contains maximal size of 
 
column. How can i get real length of varchar string? 
 
Besides, i can't use GetColumnInfo(...), because it returns 
 
DBCOLUMNINFO structure and this structer either contains ulColumnSize 
 
member with maximal leng ...

Hi, 
 
I would like to know when the consumer access the DB. Is it just when 
 
using ICommandText::Execute or could be other methods ? 
 
Thanks, 
 
Gilad.

Hi, 
 
I've written a small application that has a serach feature and a datagrid. 
 
It uses an Access database as the backend. I am having difficulties updating 
 
or deleting data through the datagrid. Below is a snippet of the code that I 
 
am using. Can any one tell me what is wrong with the way I am trying to 
 
accomplish this? Possibly point me to an example. Thanks 
 
private void QuerySelect() 
 
{ 
 
string ConnectionString = 
 
ConfigurationSettings.AppSettings.Get("ConnStr"); 
 
Ole ...

Windows 2000 sp4 
 
Unable to install MDAC 2.8 sp1, the installation proceeds fine until it 
 
starts to install the files and then returns error, ** INF : Access denied ** 
 
The log file contains the same information. 
 
This was discovered trying to install vs2005 ent ed trail version 
 
I have re-installed MDAC 2.8 without any problems 
 
Any ideas or links 
 
Thanks

Hi, 
 
When calling CreateObject("ADODB.Connection") using oracle oledb there 
 
is a call to ProgIDFromCLSID followed by CoCreateInstance all the way 
 
to IDBCreateSession running CreateSession. 
 
When calling CreateObject("ADODB.RecordSet") from asp page, what oledb 
 
code is running ? 
 
Thanks, 
 
Gilad.

Hallo, 
 
we use SQLOLEDB.1, 
 
when we want to select a table with more then one binary column, 
 
at the MoveFirst commans, we get E_NOINTERFACE. 
 
I have found some text about this in the intenet, but no solutions. 
 
I want to use a DynamicAccessor and select all columns at one time. 
 
Thanks 
 
Arno

Hi, 
 
I need to be able to add or remove columns from an Access database 
 
table (table is bound to a DataGridView). I know I have to use ALTER 
 
TABLE to do this. After I add a System.String column (AllowDBNull = 
 
false, MaxLength = 35) to my DataSet and a VARCHAR(35) column to the DB 
 
("ALTER TABLE tbl ADD col VARCHAR(35) NOT NULL" -> 
 
cmd.ExecuteNonQuery()) I'm able to generate correct INSERT, DELETE and 
 
UPDATE commands using CommandBuilder, but dAdapter.Update(dSet, "tbl") 
 
end ...

Highest rate for all type / brand 
 
24-Hrs +91 9810577227 Puri

Many applications (Crystal Reports, Excel, SQL Server etc.) are OleDB 
 
consumers with built in support that allow non-DBA users to quickly and 
 
easily retrieve data from sources that have OleDB providers.  I have not seen 
 
similar support for sources that only provide a Managed provider.  ADO.NET 
 
has been around for many years now. 
 
Assuming the data is generated in a .NET application, how does Microsoft or 
 
this community recommend exposing data to these OleDB consumer applications ...

Hi, 
 
I am trying to deploy an C# implementation from Developemnt PC to 
 
deployment pc.  Am trying to access a Microsoft Access 2003 database 
 
using Oledb commands.  I get an error when the code tries to open the 
 
connection i.e 
 
O.Open(); 
 
Below is the error 
 
Request for the permission of type 'System.Data.OleDb.OleDbPermission, 
 
System.Data, Version=2.0.0.0, Culture=neutral, 
 
PublicKeyToken=b77a5c561934e089' failed. 
 
My current code works fine when my database is on local ha ...

I've implemented code that I'm posted below that compacts an MDB database. 
 
It works every single time EXCEPT in the same session that the database was 
 
created (and populated).  Restart the app and populate some more and it works 
 
perfectly fine. 
 
Why would this be happening? 
 
Robert 
 
/// <summary> 
 
/// Created from here: 
 
http://www.codeproject.com/cs/database/mdbcompact_latebind.asp 
 
/// </summary> 
 
/// <param name="connectString"></param> 
 
/// <param name ...

I Have a Business   Object 6.5.Ihave to connect the sample database PUBS of 
 
SQL server2000. 
 
I created the .udl file ,but still , iget the error as"THE SERVER NOT 
 
Responding" 
 
the same I did with ODBC driver I get "Sucessful Connection". 
 
Could you please explain.

I need to get the DB Literals for a data source from the connection string in 
 
a native C++ app using COM. 
 
I've tried opening the schema with adSchemaDBInfoLiterals and it appears to 
 
return values (field count is 7) but when I try to access a field I get error 
 
800a0cc1 "Item cannot be found in the collection corresponding to the 
 
requested name or ordinal" 
 
This is the basic code...can anyone see what's wrong? 
 
_ConnectionPtr  pConnection    = NULL; 
 
_RecordsetPtr  pRstSchema  ...

Hi everyone, 
 
I have a database implementing row-level security with views and 
 
INSTEAD OF triggers. OLE DB (SQL Server 2005, Native Client, C++) can 
 
open a view as if it were a table with read-only access (even 
 
DBPROP_IRowsetFind is supported properly), but requesting 
 
DBPROP_IRowsetChange for IOpenRowset::OpenRowset always fails with 
 
DB_E_ERRORSOCCURRED, DBPROP_IRowsetChange showing status of 
 
DBPROPSTATUS_CONFLICTING. 
 
Docs state that this might happen if "a property is set ...

Hi, 
 
Am tring to get the raise error message and error number after executing the 
 
sp from c# code and namespace we are using System.Data.OleDb namespace. Even 
 
if the sp raises different error number but it gives error return code 0 
 
after exec the sp in the C# and when sp raise any error it goes to catch 
 
block when we try to execute this sp. Any idea of how to do that 
 
Thanks in Advance