[Wine] VB on Linux with Wine - Database

Raghu raghu.jonnalagadda at cmcltd.com
Fri Feb 17 05:28:00 CST 2006

 I created an MS-Access database.
 Created a simple VB application, giving reference to DAO 3.6
 Application is not able to create workspace and failing at ...

 Set WS = DBEngine.CreateWorkspace("mydb", "myusr", "mypwd")

 error : Object or Withblock variable not set

Here is the piece of code:
Private Sub Form_Load()
    On Error Resume Next
    DBEngine.SystemDB = "z:\app\system.mdw"
    Set WS = DBEngine.CreateWorkspace("mydb", "myuser", "mypwd")
    Set DB2 = WS.OpenDatabase("z:\app\db.mdb")
End Sub

Private Sub b_GetDescription_Click()
Dim qry As String, NewMesg As String
    qry$ = "Select * from t where ItemNumber=" & Val(txt_val.Text)
    Set RS_Change = DB2.OpenRecordset(qry$, dbOpenDynaset)
    NewMesg$ = RS_Change.Fields("Description").Value
    MsgBox "Description = " & NewMesg
End Sub

Thanks & Regards
Raghu J.

-----Original Message-----
From: wine-users-bounces at winehq.org
[mailto:wine-users-bounces at winehq.org]On Behalf Of Dan Kegel
Sent: Sunday, January 08, 2006 11:19 PM
To: raghu.jonnalagadda at cmcltd.com; wine-users
Subject: [Wine] Re: VB on Linux with Wine

Raghu wrote:
>We have 50 complex applications written in Microsoft Visual Basic 6.0
>providing banking solutions. We are seriously thinking of porting
>our applications to Linux under WINE. Is it possible to do so?

Yes.  It will take some effort, though.
Please see my Wine for Windows ISVs page,
I'd be happy to help you get started down the
- Dan

wine-users mailing list
wine-users at winehq.org

More information about the wine-users mailing list