hi,
how can i connect sql server 2005 with Lotus Notes. please help me ASAP.
Subject: lotus and sql server connectivity
You may use an ODBC connection.
Have a look at the Deisgner’s Help on the sub ject ODBCConnection class.
Subject: lotus and sql server connectivity
Use search ASAP
If you can think of the question, you can expect that somebody has already asked it. Search first, post second.
Really, there is a ton of great information in this forum and you owe it to your self to search for the answers. You’ll save yourself time and decrease the clutter of duplicate questions in the forum.
If you get a good solution, remember to post it so others can share what you’ve learned.
Doug
Subject: lotus and sql server connectivity
You will need to setup an ODBC in your OS and than you can use toe related functions.
Have a look at the Designer’s Help on the subject ODBC and ODBCConnection-class.
Subject: lotus and sql server connectivity
When you refer to connecting to SQL Server you almost always mean scripting. For this, you should use the Lotus Connectors scripting extension. This is and lsx file – basically a dll in a Lotusscript wrapper – installed with both the server and the client. The import statement is
Uselsx “*lsxlc”
You also get connectors for odbc and, if you’re in Windows, oledb. The syntax is much the same across all connectors.
First you set up an LCConnection object, set various properties on it – this is where odbc and oledb are a little different – and then you set up an LCFieldList to hold your resultset (if any) and LCfields to represent either columns in your resultset or arguments to your stored procedure, and so on.
The simplest method for fetching a resultset is LCconnection.Execute(). This one takes a SQL string.
There is also a Select() method, where you set various properties and the LCConnection creates the query for you. This one is supposed to be more efficient than Execute.
There are some code samples in the Enterprise Integration forum.
Subject: lotus and sql server connectivity
I have been using ado db, it is very easy to use and reliable. You just define a variant Dim RS As Variant
and a connection string
strCon = “DRIVER={SQL Server};SERVER=yourSQLserver;UID=yourSQLuser;PWD=yourSQLuserpassword;DATABASE=yourdatabase”
RS.open “Select yourfield1,yourfield2 from yourtable where something = '” & somevariant & " ’ ", strCon