SoPatch cannot open database for satellite

Hi,

we are trying to get SoPatch running on a Windows server 2012 (64bit) with Excel 32 bit but we are stuck with an error while connecting:

"Error opening database:

DSN: ODBC:...

Database: ...

UserID: ...

Prefix: ..."

 

This appears to be the critical VBA code part:

Set SoApp = New SOApplication
Set SoDb = SoApp.Database
intVersion = Int(SoDb.Version)
' OLEDB-Connection
Set SoConn = New ADODB.Connection
SoConn.ConnectionString = SoDb.GetADOConnectionString

Debug.Print SoConn.ConnectionString
SoConn.Open

 

This is how our connection string starts: 

Provider=SODBP32.SOProvider.1;Data Source=CRM7;Location=ODBC:

 

Does anyone have any ideas? We are running out of them...

 

Best regards,

Christoph

Ingen svar så langt