SQL Server + Linux + VB6 + Wine + Adodb.Recordset +Error 430

Questions about Wine on Linux
Locked
South Coast Software
Newbie
Newbie
Posts: 4
Joined: Wed Apr 08, 2020 5:18 am

SQL Server + Linux + VB6 + Wine + Adodb.Recordset +Error 430

Post by South Coast Software »

Hello everyone

I have a VB6.0 app running in Wine 5.0 on Ubuntu 18.04 LTS
I have a SQL Server database on a remote Linux server (also Ubuntu 18.04 LTS)
I have tested connectivity to the database in Wine using ODBC Manager
I have tested connectivity to the database in Linux using Azure Data Studio
The VB application references the Microsoft ActiveX Data Object 2.8 library
I create an ADODB.Connection object (early binding and late binding tested), and an ADODB.Recordset object.

With rec1
.ActiveConnection = gConn1
.CursorType = adOpenDynamic
.LockType = 1
.Source = "Select * from [tblUsers] WHERE Username='" & XXXXX & "'"
.Open
End With
I am getting an Automation error, Error 430, "Runtime error '430' class does not support Automation or does not support expected interface.

Please help, this is the last hurdle in a very long project.
Locked