Enterprise Integration Forum : Accessing a MSSQL Server via LCLSX

Hi there,

i have a problem connecting to a MSSQL Server using LotusScript Extensions.

I have installed a MSSQL Express Server (defaults) and I am able to connect to it with the SQL Server Management Studio Express. Also I am able to create a new ODBC Connection to it. So my conclusion so far is, that the server is running :) .

After that I created an agent to test the connectivity from my Notes Client (the server is running on local machine).

The code is:

Const SERVER = "AOL0002N/SQLEXPRESS"
Const USER = "sa"
Const PASS = "****" 'my password
Const DATABASE = "Northwind"

Const BUILD = "0001"

Dim nl As New NotesLog( "" )
Call nl.OpenFileLog( "c:\MSSQLTest_" & Format( Now, "yyyymmddhhnnss" ) & ".txt" )
Call nl.LogAction( "MSSQLTest Build " & BUILD )

Call nl.LogAction( "Server: " & SERVER )
Call nl.LogAction( "Database: " & DATABASE )
Call nl.LogAction( "User: " & USER )
Call nl.LogAction( "Pass: *******" )

Dim clcSession As LCSession
Dim clcConnection As LCConnection

Set clcSession = New LCSession

bIsValid = clcSession.LookupConnector( "oledb" )
Call nl.LogAction( "LookupConnector: " & bIsValid )

'test connection
Set clcConnection = New LCConnection( "oledb" )
clcConnection.Provider = "SQLOLEDB"
clcConnection.Database = DATABASE
clcConnection.Server = SERVER
clcConnection.UserID = USER
clcConnection.Password = PASS

Call clcConnection.Connect() 'FAILING!!!
connect = clcConnection.IsConnected

Call nl.LogAction( "IsConnected: " & connect )

Call nl.LogAction( "Status: " & clcsession.GetStatusText() )

The created logfile:

: 20.11.2007 17:27:18: MSSQLTest Build 0001
: 20.11.2007 17:27:18: Server: AOL0002N/SQLEXPRESS
: 20.11.2007 17:27:18: Database: Northwind
: 20.11.2007 17:27:18: User: sa
: 20.11.2007 17:27:18: Pass: *******
: 20.11.2007 17:27:18: LookupConnector: True
: 20.11.2007 17:27:35: Error (12325): Error:
ErrorRecord: HResult: 0x80004005
Description: [DBNETLIB][ConnectionOpen (Connect()).]SQL Server existiert nicht oder

(Translation of the error msg: SQL Server does not exist or)

Yes, correct, its cut off.

What am I doing wrong? I can connect to Oracle or SAP Systems using similar code.

Thanks for your help,
Andreas

Enterprise Integration Forum

Resources

Lotus Support

Wikis

Lotus Forums