I'm a developer for a nationwide program. One of our features is using adodb/oledb to hook up Word with our database. Many of our users have started receiving an error after the most recent Norton update. If I uninstall Norton it works again. If I reinstall, it works until I do a check for updates. Sample code below is a simple demonstration of what is happening:
cDatabasePath = 'c:\lmsng\temp\docmgr.dbc'
cConnectString = "Provider=VFPOLEDB.1;Data Source=" & cDatabasePath & ";" & _
"Mode=ReadWrite|Share Deny None;Password='';Collating Sequence=MACHINE"
Set oConnection = CreateObject("ADODB.Connection")
oConnection.ConnectionString = cConnectString
oConnection.ConnectionTimeout = 30
oConnection.Open (run-time error '2147467259' at this point)
Any wisdom from anybody?
I've been programming a long time and seen stuff like this before (actually a Norton Script blocking issue back in early 2000s). But as of today, no setting or combination of settings help.