Gareth Segree 4.Dec.09 03:35 PM a Web browser
Connector for OLE DB All Releases Windows
I am a newby to Lotus programming and I'm trying to wire up a lotus form and a view to a MSSQL database.
I used dctest and it returned ok?
My code:
Sub Initialize
Dim lc_connection As LCConnection
Dim lcf_results As LCfieldList
Dim lc_foo As LCfield
Dim sql As String
Set lc_connection = New LCConnection("oledb")
With lc_connection
.provider = "sqloledb"
.server = "trackit7\trackit80"
.Database = "trackit8_data2"
.Userid = "sa"
.Password = "crk_DIS08"
On Error Resume Next
Call .connect
On Error Goto 0
' try again
If Not .isconnected Then
On Error Resume Next
Call .connect
On Error Goto 0
End If
End With
sql = "select * from task"
Set lcf_results = New LCFieldList
Messagebox "Test!"
Call lc_connection.Execute(sql,lcf_results)
End Sub
the error returned is:
error: Metadata object does not exist, Connector 'oledb', Method -Execute-
How do I fix this?
and how do I tie the returned stuff to a view programatically?
Thanks
 Lotus Notes connect to MSSQL (Gareth Segree 4.Dec.09)
 . . RE: Lotus Notes connect to MSSQL (Thomas Kennedy 9.Dec.09)
| 
Return to top
Print this page
