Extracting data from sql(LCLSX)

HCL Domino Domino Forum
1

I need to acces some data from SQL server,initially i was using @dbcommand,but the issue was we have to setup the ODBC connection on evry machine.I got many clues from notes.net,i used the following in the script using LCLSXDim DbSession As LCSession

Dim DbConnection As LCConnection

Set DbConnection = New LCConnection("OLEDB") 

dbconnection.provider="sqloledb"

Set DbSession = New LCSession



'DbConnection.Server="sql\production"

DbConnection.Server="10.2.152.102"

DbConnection.UserID = "Lotusapp"  

DbConnection.Password = "application"



DbConnection.Connect  (It is giving me error on this line)

I am very new in this technology,please guide me how to overcome from this

2

Subject: RE: Extracting data from sql(LCLSX)

What error message? Before you answer – please look up the error message, here, in the IBM technotes, in Google – to see whether someone has already explained what it means.

3

Subject: RE: Extracting data from sql(LCLSX)

Error isError Record:HRresult:0X80004005

Descriptin [Dbnetlibrary] connectionopen(invalid instance()).]invalid connection.

SQ

i am very new to in SQL,i tried to search this in this forum but all in vain and got confused.

4

Subject: RE: Extracting data from sql(LCLSX)

You seem to be under the mistaken impression that using the LC LSX will prevent you having to set up the connection on each user’s workstation. You still have to do this – unless you arrange to have the code run by a server process rather than by the user’s Notes program.

5

Subject: RE: Extracting data from sql(LCLSX)

That’s a very odd error message, one i have never seen. Do you have another tool you can connect to SQL Server with? If you don’t, you need to get one. Microsoft’s SQL Server Management Studio Express is a good, free tool. If you can get your hands on Query Analyzer, even better. Make sure you can connect to SQL Server using one of these before trying it in your script. I suspect there is something wrong with your server name, et cet.