I have a 'notes' field. Entries in there are time-stamped as well. so lines
looks sort of below...
01/01/2001 10:00 am
Called him. Sent him some info.
03/01/2001 2:00 pm
Nice guy. Fun talking
etc
Is there a SQL function/way by which I can grab entries from 'notes' field by date ?
Thanks a lot in advance.
Derek
hi all,
i am having a problem. In my table i have defined a logtime field as a datatype datetime. Now i want to query the table on a particular date which is not possilbe i supposed. so how can i break the datetime field into date field. Is there any method.... I don't want to create the table once again.
manish
I need to expand the size of one column which has been defined as varchar(32) to varchar(50).Is this possible?Already there are many old records in the table,in what way it will effect the old records?Any help is appreciated.
Thanks!!
Basically i make use of FormView in Web Developer Express Edition to create and store information to the database .... what i want to do further is to capture the value within the primary key of the newly created recordset that I set it become auto increament .....this value would be stored within a session string in global condition that allowed any page able to access it .....
View 3 Replies View RelatedHello all. I have a nvarchar field in the format dd:hh:mm:ss I need to get a sum of these fields in the same format. So for example if the values are 01:23:00:00 and 00:01:00:00 then the sum of these fields should be 02:00:00:00. Can someone help me? Thanks.
View 12 Replies View RelatedI have a text file like this :
K045|13/03/1997
When I upload this text file to SQL Server 6.5, with the following fields :
Code Chraracter 4
Tdate Smalldatetime
I use BCP to upload this text file to SQL tables, but I got a wrong date,
like :
Text file :
K045|13/03/1997
SQL Tables data :
K045 Nov 19 1935 7:00PM
Can anyone on the net can help me ?
Thank's
Hi everyone -
I need to remove the formatting characters
from the phone field in the database.
The data entry scrubber did not perform correct,
and now, a LOT of records have the ( in the field.
Is there a quick way to remove the ( from the field in the database??
MSSQL 2000
thanks
tony
I am new at ASP.net and I am having problems inserting data using C# in ASP.netI have created a table named "Profile" in the MS sql server database named "MyDataBase". There is a field named "ID" that has data type 'uniqueidentifier'.I am confused how to INSERT data into this data field. I have used MS Access and MYSQL in which there is an option of auto increment so we don't a unique identifier for each record.Please tell me what can I do to If I want to have a uniqueidentifier for each new record I INSERT in the "Profile" table of MS sql server database.While trying to insert, I get following errorsCannot insert the value NULL into column 'ID'and I don't know how I can insert something in this field that is of value type unique identifier.Please help me I will be very thankfull of you.
View 5 Replies View RelatedI was under the impression that SQL 7 could utilize any MAPI compliant email application for
use with the Mail Agent. I have been unable to confirm this. I am using Lotus Notes for company
email and would like to set the Agent to email failure messages to my Lotus Notes mailbox.
Does anyone know anything about this??? And if so, how do I set this up???
Greetings
I am attempting to set up a DTS package for transferring user information from a Lotus Domino server into the MS-SQL2K backend server in my web application.
My problem lies with creating the innitial connection item in the DTS package designer.
My actions:
Connection -> Lotus NotesSQL Driver (*.nsf) -> Data Source (Same) -> User/System DSN (LNotesNames)
I have tested this DSN by setting up a Linked Server in SQL Server and I can browse the tables and views in the Domino server through there.
When I press "OK" on the Connection Properties dialog I get the following error:
Package Error
HResult of 0x80004005(-2147467259) returned
Unexpected error occurred. An error result was returned without an error message.
The event viewer shows no error concurrent with this event. I have Lotus Notes client installed on the same system as the SQL Server.
I am wondering if anyone has had similar problems and perhaps resolved them, or if there are other resolutions available to me. I do not have development access to the Domino server, and such is not forthcoming, so I am limited to what I can pull out with client means.
Best regards
Klumhru
DTS to Lotus notes
I must import/export some data from SQL Server to Lotus Notes.
I downloaded and installed NotesSQL ODBC drivers.
I met no problem importing from a Lotus Notes view to an SQL Server table: I used DTS and everything succeded.
But I can't do the reverse process (exporting from SQL Server to Lotus Notes): DTS keeps on giving an error without description and it fails.
Does anybody know how to export a table or a view from SQL Server to Lotus Notes using DTS?
Thanks in advance.
Hello chapies,
Does anyone know where I can download notes for taking the MCDBA exam?
Cheers
Can any one send me a link to step by step instructions on how to setup SQL mail for lotus notes.Thanks for the help!
Reddy.
I want to use stored procedures to email people on Lotus Notes. Any ideas? TIA George.
View 1 Replies View RelatedHello,
I am using Lotus Notes 5.0 for email and would like to set the MS SQL Server Agent to email failure messages to my Lotus Notes
mailbox. I setup a profile in exchange (after installing Microsoft Messaging) called "Lotus Notes Mail". This profile actually works..
I can send and receive email from microsoft exchange.. But when I go in SQL server agent to setup the mail profile, first of all,
the mail profile drop down list is empty (my profile I created with Microsoft Exchange is not there) so I typed it (Lotus Notes Mail)..
When I click on the TEST button, I get the following error message:
Error 22030: A mapi error {error number 87} occured: MapiLogonEx failed due to mapi error 87: Invalid parameter.
Can someone help?? Does this means that there is something not setup properly in Notes??
Thanks in advance
I need to set up SQLMail togheter with Notes, We have SMTP server and profiles but I canīt get it to work. SQL sends the mail but it disappears into the cyberspace.. Someone help me pls...
View 1 Replies View RelatedI am having difficulty trying to get SQLMail to work via Notes4.6.1 as the mail system. Firstly the Notes client is working correctly on my machine but SQLMail will simply not start with the SQL-DMO error 17952, and on trying to configure it I type in my profile name(which has been successfully setup previously through the Ctrl Panel Mail and Fax icon with the Lotus Notes Mail information service selected ) and get the error 21002 RegCreateKeyEx - #5 access is denied - which seems to be something to do with permissions but the SQLServer service is logging in a member of Local Admins group.
Has anyone had this before - there seems to be a painful lack of information about this area generally.
Regards.
David Shaw
I have just started a position at a new company and
want to set up the SQLMail option on each of the
20+ servers. One problem I see is that the e-mail
package here is Lotus Notes. Does anyone have any
experience or information they can pass on to me
regarding SQLMail and Lotus Notes? I would appreciate
any advice.
Thanks!
Toni Eibner
I am currently working on the SQLMail in SQL Server ver. 6.5 and don`t know
how to start. SQL Server is already installed in the NT Server and some
applications are using this. The problem is how to send mail and receive mail from a Lotus Notes ver. 4.5, not a MS Exchange Mail. Can anybody provide me step-by-step approach to do this? The NT server dont MS exchange installed in it.
thnks.
Hi everyone,
I have read every article in the kb and read every message in the newsgroup but still I cannot make SQL mail to work with lotus notes. Can someone describe in details on how to do this?
Any suggestion is greatly appreciated...
Hi,
I am moving data from Lotus notes to SQL and I am getting the below error. [Lotus][ODBC Lotus Notes]Invalid Character.
Does anybody have any idea, if so please let me know asap.
Hey guyz,
I have to import .nsf file into the SQL Server. Can anyone suggest a tool or any method to do that. Thank you.
Regards,
Sri..
I have to create ssi pkg in sql server 2005, that gets data from lotus notes db, into sqlserver 2005. Do i use ODBC With notessql driver or is there an oledb for notes ?
View 6 Replies View RelatedHello,
Anyone planning to take the exam 70-431?
It would be nice to share experience and motivation ... I am currently using SQL Server 2005 Bible as a reference, any other references you suggest? Any place where I could find exam samples?
LLOYD
This is from the previous notes err that i reported.
If Lotus Notes 6 or higher is installed on your machine, you already have everything you need. You can create and work with the Notes database as a set of OLE objects.
Try this code for a start, replacing the dummy strings with your own values as appropriate:
Sub Main()
Dim sess As Object
Dim db As Object
Dim vu As Object
Dim doc As Object
sess = CreateObject("Lotus.NotesSession")
Call sess.Initialize("myPassword")
db = sess.GetDatabase("NotesServerName", "path/DBFileName.nsf")
vu = db.Views(0)
doc = vu.GetFirstDocument
MsgBox(doc.UniversalID)
End Sub
To understand the properties and methods for these objects, and to explore others, check out the LotusScript classes documentation at http://publib-b.boulder.ibm.com/lotus/c2359850.nsf/b3266a3c17f9bb7085256b870069c0a9/16d78c3f9148e7eb8525731b0049e880?OpenDocument. You'll find the syntax is similar to VB, and the descriptions often contain hints about calls from COM and OLE...meaning Microsoft.
My question is from this code above-
What is the sess = CreateObject("Lotus.NotesSession")
what do I need to put here in the notessession?
Has anyone setup Lotus Notes as the email client for SQLMail? I currently have Lotus Notes client installed on dedicated MS SQL Servers but am
having trouble configuring the SQL Mail in order to get it working. Does anyone have any suggestions or instructions on how this is done? I've
researched all of the "Books on line" but they are all slanted to Exchange.
Jim
Hello,I have successfully linked a Lotus Notes server to our SQL Serverdatabase using an ODBC connection.This works fine when wanting to select recordseg openquery(LOTUSNOTES2, 'select * from Person' )The problem I have is when I try to update the record I get an erroregupdate openquery(LOTUSNOTES, 'select * from Person whereMailAddress=''nick.bloor@sandh-ltd.com''' )set JobTitle='Test'Produces the following error==========OLE DB provider 'MSDASQL' reported an error. The provider did not giveany information about the error.OLE DB error trace [OLE/DB Provider 'MSDASQL' IRowset::GetNextRowsreturned 0x80004005: The provider did not give any information aboutthe error.].===========I have tested the ODBC connection using an Access database. The linktables facilities enable me to select what I think should be theprimary key. If I select a primary key then I can use Access to updatethe lotus notes database, however if I don'k select a primary key, thetable is not updateable.I believe that if I can somehow create an index on the linked tablewithin SQL Server, I should be able to update the Lotus Notes databasefrom SQL Server, but I cannot find a way of doing so.As the Lotus Notes software is third party, I cannot actually changeanything on that server.Thanks for any help.RegardsNick Bloor
View 5 Replies View RelatedHello All,
I have opened a new ssis package in which i am trying to connect to lotus notes driver using ODBC Connection. But I am not able to connect it and gives me the following Error below:
Test Connection Failed because of an error in initializing provider. ERROR [S1000] [Lotus] [ODBC Lotus Notes] You are not authorized to perform that operation
ERROR [IM006] [Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr failed
ERROR [01000] [Microsoft][ODBC Driver Manager] The driver doesn't support the version of ODBC behaviour that the application requested (see SQLSetEnvAttr)
Furthermore, I have created the DSN and configured in SQL 2000 DTS to use the same system dsn without any errors.
My Lotus Notes Driver is Lotus NotesSQLDriver (*.nsf) having the Version Number is 3.02
.
Hi,
I am new to lotus notes.
I have a requirement of transfering data stored in lotus notes to sql server7.0. Can somebody please give any info on how to do this....
All help is appreciated,
gp
I saw from SWYNK that you were able to set up SQL Mail using Lotus
Notes. I tried following the post by Edward Alexander but got into some trouble:
We were using MAPI to get to Notes Mail.
1. We know that MAPI works because we were able to send mail by
a. using the exchange client (Windows Messaging client)
b. using VB script to send a message with MAPI.Session
The problem is that SQL server cannot see the Exchange Profile that was defined on the SQL box.
Hello, everyone:
There are some commented notes in the stored procedure from clients. Is there any way to remove these notes automatically, I mean using scripts etc.
Thanks
ZYT
I am hoping this is a quick easy question for someone! :)I am trying (struggling) with moving data from Sql Server to a LotusNotes table.I am using SQL Server 2000, I have a Lotus Notes linked server (usingNotesSQL), and I wasnt to clear the table (delete all records) and thenreload 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 thisone....select * from openquery([LinkedServer], 'delete from NotesTable') wherelastName='Smith'(this doesnt work)Thanks!
View 9 Replies View RelatedHi, there,
We intended to create a report that allows users to enter remarks, comments or additional notes in supporting the report.
Can it be done in SSRS? FYI, we are using SQL Server 2005 Enterprise.
Thank you.
Regards,
Yong Hwee