Home > Ask the Domino Experts > ARCHIVE: Enterprise Integration Questions & Answers > Use LSX code to connect to SQL Server 2000
Ask The Domino Expert: Questions & Answers
EMAIL THIS

Use LSX code to connect to SQL Server 2000

Scott Lemieux EXPERT RESPONSE FROM: Scott Lemieux

Pose a Question
Other Domino Categories
Meet all Domino Experts
Become an Expert for this site


Digg This!    StumbleUpon Toolbar StumbleUpon    Bookmark with Delicious Del.icio.us   


>
QUESTION POSED ON: 14 May 2004
I'm running Domino 6.0.1 and SQL Server 2000 on my machine. I was able to connect to the SQL server using DECS, but DECS didn't give me the programmable power I required. I need to use LCX; but with LotusScript, I get the error message, "Instance member DATABASE does not exist," when I run this connection test code behind a button:
Dim connect As New 
LCConnection ("odbc2") 
 
' set the appropriate 
properties to connect to odbc2
' note the use of dynamic 
properties to do this
' all properties of a connection 
may be referenced
' by name
 connect.Database = "Northwind"
 connect.Userid = "user id here"
 connect.Password = "pwd here"
 
REM try the connect
 connect.Connect
 Print "Successfully connected
 to ODBC2."
End Sub

How can I successfully use LSX code to connect to SQL Server 2000?


>
Ah yes, the nuances of LC-LSX! The ODBC LCConnection Object uses the Server property to set the Data Source name. Try changing your code to: connect.Server = "Northwind."

It should connect.

I've been writing LC-LSX code since 1998, and I'm still not sure of all the correct properties for the various connectors. To see what the field names are for a particular connector, I look at the DECS or LEI connection form in Designer. Most often, the field names used on the Connection Document form have the same names as the properties used by the LC-LSX.

Do you have comments on this Ask the Expert question and response? Let us know.


Digg This!    StumbleUpon Toolbar StumbleUpon    Bookmark with Delicious Del.icio.us   



RELATED CONTENT
ARCHIVE: Enterprise Integration
Restricted in connecting LEI to Notes databases?
Integrate Domino 7 beta with DB2
Can I use LSXDB2 in a scheduled agent on AIX, Domino version 5?
Tracking interdependent LEI activities
Oracle table updates not transmitting to Notes
Oracle through DECS via the Web connection returns 'Error creating product object'
Managing user rights for Domino docs transferred to SAP
Two stored procedure events not working with DECS and SQL Server backend
Can I code a Notes script to bundle LEI-polling sequence activity?
Creating a database that will support concurrent entries with automatic updates

LEI and DECS for Lotus Notes Domino
Top 10 Lotus Notes Domino programming and development tips of 2007
An introduction to Lotus Enterprise Integrator (LEI)
A smorgasbord of Notes/Domino development tips
DECS and DCR external data access considerations
Importing data once from Oracle app into Notes app
Moving data (text) from Lotus database to Oracle
Restricted in connecting LEI to Notes databases?
Lotus Enterprise Integrator (LEI)
Integrate Domino 7 beta with DB2
Automated export of selected public NAB information

RELATED RESOURCES
2020software.com, trial software downloads for accounting software, ERP software, CRM software and business software systems
Search Bitpipe.com for the latest white papers and business webcasts
Whatis.com, the online computer dictionary



Search and Browse the Expert Answer Center
Search and browse more than 25,000 question and answer pairs from more than 250 TechTarget industry experts.
Browse our Expert Advice



Lotus Notes Domino on Blackberry and mobile devices
HomeTopicsITKnowledge ExchangeTipsAsk the ExpertsMultimediaWhite PapersDomino IT Downloads
About Us  |  Contact Us  |  For Advertisers  |  For Business Partners  |  Site Index  |  RSS
SEARCH 
TechTarget provides technology professionals with the information they need to perform their jobs - from developing strategy, to making cost-effective purchase decisions and managing their organizations' technology projects - with its network of technology-specific websites, events and online magazines.

TechTarget Corporate Web Site  |  Media Kits  |  Site Map




All Rights Reserved, Copyright 1999 - 2009, TechTarget | Read our Privacy Policy
  TechTarget - The IT Media ROI Experts