I am hoping this is a quick easy question for someone! :)
I am trying (struggling) with moving data from Sql Server to a Lotus
Notes table.
I am using SQL Server 2000, I have a Lotus Notes linked server (using
NotesSQL), and I wasnt to clear the table (delete all records) and then
reload it from my data on SQL Server.
What is the syntax to delete the records?
My select statement would be like this:
select * from openquery([LinkedServer], 'select * from NotesTable')
where lastName='Smith '
My delete statement ??? -- cant quite figure out the syntax of this
one....
select * from openquery([LinkedServer], 'delete from NotesTable') where
lastName='Smith '
(this doesnt work)
Thanks!
9  7321 
Yes, I dont think I can use this syntax.
select * from [Notes_DRS_CaseN ame DEV].[CaseName].[dbo].[case_name]
delete from [Notes_DRS_CaseN ame DEV].[CaseName].[dbo].[case_name] where
CaseNum='PROD05 5344'
Returns:
Server: Msg 7312, Level 16, State 1, Line 1
Invalid use of schema and/or catalog for OLE DB provider 'MSDASQL'. A
four-part name was supplied, but the provider does not expose the
necessary interfaces to use a catalog and/or schema.
OLE DB error trace [Non-interface error].
ProgrammerGal (ca**********@a hm.honda.com) writes: Yes, I dont think I can use this syntax.
select * from [Notes_DRS_CaseN ame DEV].[CaseName].[dbo].[case_name]
delete from [Notes_DRS_CaseN ame DEV].[CaseName].[dbo].[case_name] where
CaseNum='PROD05 5344'
Returns:
Server: Msg 7312, Level 16, State 1, Line 1
Invalid use of schema and/or catalog for OLE DB provider 'MSDASQL'. A
four-part name was supplied, but the provider does not expose the
necessary interfaces to use a catalog and/or schema.
OLE DB error trace [Non-interface error].
You should certainly not specify dbo for something in Lotus Notes,
as dbo is very SQL Server-specific.
Try one of
select * from [Notes_DRS_CaseN ame DEV].[CaseName]..[case_name]
select * from [Notes_DRS_CaseN ame DEV]...[case_name]
You could also try
delete from openquery(Linke dServer, 'SELECT * FROM ...')
although it looks completely crazy!
--
Erland Sommarskog, SQL Server MVP, es****@sommarsk og.se
Books Online for SQL Server 2005 at http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at http://www.microsoft.com/sql/prodinf...ons/books.mspx
I tried all different versions of the selects... no luck.
Still the same "no schema exposed message"
Here is the error from the delete...
delete from openquery([Notes_DRS_CaseN ame DEV],'select * from CaseName'
) where CaseNum='PROD00 7586'
Server: Msg 7390, Level 16, State 1, Line 1
The requested operation could not be performed because the OLE DB
provider 'MSDASQL' does not support the required transaction interface.
OLE DB error trace [OLE/DB Provider 'MSDASQL' IUnknown::Query Interface
returned 0x80004002].
Hi
Try using two part names for your oracle table by adding the schema that
your oracle table is in.
John
"Programmer Gal" <ca**********@a hm.honda.com> wrote in message
news:11******** **************@ t31g2000cwb.goo glegroups.com.. . I tried all different versions of the selects... no luck.
Still the same "no schema exposed message"
Here is the error from the delete...
delete from openquery([Notes_DRS_CaseN ame DEV],'select * from CaseName'
) where CaseNum='PROD00 7586'
Server: Msg 7390, Level 16, State 1, Line 1
The requested operation could not be performed because the OLE DB
provider 'MSDASQL' does not support the required transaction interface.
OLE DB error trace [OLE/DB Provider 'MSDASQL' IUnknown::Query Interface
returned 0x80004002].
ProgrammerGal (ca**********@a hm.honda.com) writes: I tried all different versions of the selects... no luck.
Still the same "no schema exposed message"
Here is the error from the delete...
delete from openquery([Notes_DRS_CaseN ame DEV],'select * from CaseName'
) where CaseNum='PROD00 7586'
Server: Msg 7390, Level 16, State 1, Line 1
The requested operation could not be performed because the OLE DB
provider 'MSDASQL' does not support the required transaction interface.
OLE DB error trace [OLE/DB Provider 'MSDASQL' IUnknown::Query Interface
returned 0x80004002].
I'm afraid that I'm out of ideas. Maybe you should try a LotusNotes forum,
to here if anyone in that community has been able to solve this.
--
Erland Sommarskog, SQL Server MVP, es****@sommarsk og.se
Books Online for SQL Server 2005 at http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at http://www.microsoft.com/sql/prodinf...ons/books.mspx
Hi Erland
You are right I confused the ODBC OLE DB Provider MSDASQL with the Oracle
OLE DB Provider MSDAORA!
John
"Erland Sommarskog" <es****@sommars kog.se> wrote in message
news:Xn******** **************@ 127.0.0.1... John Bell (jb************ @hotmail.com) writes: Try using two part names for your oracle table by adding the schema that
your oracle table is in.
ProgrammerGal is using LotusNotes... (Of course, I don't know LotusNotes
at all. Maybe there is an Oracle database in the bottom?)
--
Erland Sommarskog, SQL Server MVP, es****@sommarsk og.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx
Hi
Check out http://tinyurl.com/kj3ow on how to determine how to use 4 part
naming. I am not sure if you need this now http://www.databasejournal.com/featu...le.php/3462011 but you
may want to check it out.
You may also want to check that this is not a read-only interface, also see
if there is a OLEDB interface available so you don't have to go through
ODBC.
John
"Programmer Gal" <ca**********@a hm.honda.com> wrote in message
news:11******** **************@ t31g2000cwb.goo glegroups.com.. . I tried all different versions of the selects... no luck.
Still the same "no schema exposed message"
Here is the error from the delete...
delete from openquery([Notes_DRS_CaseN ame DEV],'select * from CaseName'
) where CaseNum='PROD00 7586'
Server: Msg 7390, Level 16, State 1, Line 1
The requested operation could not be performed because the OLE DB
provider 'MSDASQL' does not support the required transaction interface.
OLE DB error trace [OLE/DB Provider 'MSDASQL' IUnknown::Query Interface
returned 0x80004002]. This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics | |
by: NickBlooruk |
last post by:
Hello,
I have successfully linked a Lotus Notes server to our SQL Server
database using an ODBC connection.
This works fine when wanting to select records
eg openquery(LOTUSNOTES2, 'select * from Person' )
The problem I have is when I try to update the record I get an error
eg
update openquery(LOTUSNOTES, 'select * from Person where
|
by: teddysnips |
last post by:
In the script below is the DDL to create some tables and a UDF.
What I'm interested in is the UDF at the end. Specifically, these few
lines:
--CLOSE OTRate
--DEALLOCATE OTRate
ELSE -- @NumRecords <= 0
If I uncommment CLOSE and DEALLOCATE and check the syntax I get a
|
by: LaurenW |
last post by:
After many years of working with Access, I am FINALLY required to
delete a single field from a table in a linked back-end data base and
I must do it fro the FRONT end! There MUST be a way to do this.
SQL ALTER TABLE code does not work because the table is linked. I
cannot find a "Delete field" method in DAO. I hope I'm overlooking
it.
Any advice will be appreciated.
|
by: Smartin |
last post by:
I have tblEvents which includes a Memo field for "Notes". I have a main
form to display various data from tblEvents, including a small space to
display the Notes field.
I'm trying to create a separate form (frmNotes) that displays the Notes
in a much larger area and allows editing.
I have a command button and code that opens frmNotes, no problem there.
frmNotes has tblEvents as its RecordSource. It has a text box bound to
|
by: Neil |
last post by:
I am getting time-out errors when I try to perform a simple delete on a
linked server. The command is:
Delete From MyTable Where PKID=12345
I have tried executing this command directly from Query Analyzer, but it
just times out. However, when I run it from QA against the server itself
(rather than from my local server against a linked server), it executes
immediately. Similarly, if I run the same SQL command through an ODBC linked...
| | |
by: snoonan |
last post by:
The company in quesiton does construction work. Tables look like this:
***Job Table***
JobNumberID*
JobName
***JobNote Table***
JobNoteID*
JobNumberID*
JobNoteCreateDate
|
by: nma |
last post by:
Hi all,
Could someone help me how to delete the rows for the listed row below? How do I write the codes at this line? I want to click on 'Delete' to delete the specific row.
<td colspan="2" align="right">Delete</td>
Many thanks
nma
|
by: scott.tang |
last post by:
I'm experiencing a very strange problem. My application is MS Access
front-end and MS SQL server back-end database. I have a SQL statement
that deletes records from a table after an export process. The
problem is occasionally when the delete statement is executed, these
records no longer display on List Box (not even in the MS Access link
table). But when close and reopen the form, those records reappear.
It almost like MS SQL server...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
| | |
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |
