Re: OLE TO ODBC connection...

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Lau Lei Cheong (leu_lc_at_yehoo.com.hk)
Date: 09/18/04 

Date: Sat, 18 Sep 2004 10:15:57 +0800

I think you'll give us more hints if you can post "sample SQL statement of
what you're going to do"
and a "sample database structure"(include which field is the unique key)

"Ross" <Ross@discussions.microsoft.com> ¦b¶l¥ó
news:152D1C37-751E-4921-A399-CC25409B8CA5@microsoft.com ¤¤¼¶¼g...
> Hello everybody,
>
> I am trying to convert an OLE access database to a ODBC connection.
> When I first start out trying to configure the odbcdataadapter it tells me
> that it cannot generate a delete or update statement because it cannot
> uniquely identify the rows. It is using the same table as the OLE
connection
> and it does generate a update and delete statement. I checked the access
> database table and found that I do have a primary key. I thought it might
be
> just the one specific table so I tried others from the same database and
it
> generates the same error. Am I missing something to do in the access
table
> or do I need to do something specific in ODBC connection????????
>
> Thanks,
> Ross
>

Relevant Pages

  • Re: Updating only fields which users have changed
    ... >> Thanks everyone for the responses. ... >> building a UPDATE statement of only the fields that have actually ... >> changed probably won't save much on the database end. ... > Yes there will be savings, but I regard it to be a case of premature ...
    (comp.lang.php)
  • Re: Mail merge process is printing out extra records
    ... FWIW I can easily replicate this problem here with some simple test data. ... when it connects to a Jet database by specifying properties in a .odc (or ... is to use an ODBC connection instead of an OLEDB one (check Word ...
    (microsoft.public.word.mailmerge.fields)
  • Why data could not be committed into table?
    ... I have a set of database which is replicated from production box. ... That means all objects are inherited from production box including the data. ... Wrote a console win32 application and use the same update statement. ... Instead of replication, recreate tables using TSQL and BCP in the data. ...
    (microsoft.public.sqlserver.programming)
  • Re: Passing parameter to a select query
    ... ' need to wait while the first query refreshes ... it works fine for external linking of the database within Access. ... you have an ODBC connection for your database? ...
    (microsoft.public.excel.programming)
  • Re: creating replication and not using default database name
    ... the datawh and has the db name in the ODBC connection. ... that when I've started replication before. ... > of the subscriber database name is. ... I am going to break and recreate replication to our datawarehouse. ...
    (microsoft.public.sqlserver.replication)