Andreas2 Olesch 20.Nov.07 11:35 AM a Web browser LC LSX Lotus Connectors - All Releases All Platforms
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 )