Error accessing OLEDB from LotusScript

HCL Domino Domino Forum
1

Given this snippet of code:

use “*lsxlc”

Dim lcConn2 As New LCConnection(“oledb”)

lcConn2.provider = “SQLOLEDB”

lcConn2.server=“MainSQLServer”

lcConn2.init_datasource=“MainSQLServer”

lcConn2.database=“DatabaseToConnectTo”

lcConn2.auth_integrated = “SSPI”

lcConn2.fieldNames = “firstname, lastname”

lcConn2.metadata = “customers”

lcConn2.mapByName=True

Call lcConn2.connect

On every machine but my own, this works. On mine, NDCTEST works, but when I run this code, I get “The connection has been dropped, connector OLEDB.” I ran a network sniffer, and the difference I can find is that with the ones that work (and NDCTEST on my machine), the client starts a TDS:Prelogin transaction with a specific version number, whereas my workstation (which fails), the trace says “Version 7.30000000(No version information available, using the default version).” Oh, and my client is R9, but it’s not R9 that’s the problem…it works fine on R9 on another workstation.

So this smacks of a configuration somewhere, but for the life of me, I can’t find where that might be set. Anyone have any ideas?

Thanks

2

Subject: What is diffrent

Same os? 32 or 64

I would reinstall notes/sql driver

3

Subject: . What is diffrent

All 32-bit flavors of Windows, either Vista or Win7.

I uninstalled NotesSQL and it still failed. Which I expected. NotesSQL lets ODBC get to Notes, where I’m using Notes with OLEDB to get to SQL Server.

4

Subject: Can you

Search your pc for ndctest.exe. See if there is only one version and then compare that with the other pc that has Notes 9. Maybe it is picking up another version based on path?

If diffrent I would suggest you uninstall notes and reinstall. Was this pc upgraded vs reinstall?

5

Subject: NDCTEST

NDCTEST works on the problem machine.

6

Subject: Was

Checkign to make sure old versions are not being refrenced. That is why I asked to see if more than one was found.

Try a uninstall and reinstall of the client.