[Wine] VB on Linux with Wine - Database

Raghu raghu.jonnalagadda at cmcltd.com
Mon Feb 20 01:36:58 CST 2006


Hi,

Please see the attached ZIP file for sample database access

Thanks & Regards
Raghu J.

-----Original Message-----
From: wine-users-bounces at winehq.org
[mailto:wine-users-bounces at winehq.org]On Behalf Of Raghu
Sent: Friday, February 17, 2006 4:58 PM
To: wine-users
Subject: [Wine] VB on Linux with Wine - Database


 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,
    http://kegel.com/wine/isv
I'd be happy to help you get started down the
path.
- Dan

_______________________________________________
wine-users mailing list
wine-users at winehq.org
http://www.winehq.org/mailman/listinfo/wine-users




_______________________________________________
wine-users mailing list
wine-users at winehq.org
http://www.winehq.org/mailman/listinfo/wine-users
-------------- next part --------------
A non-text attachment was scrubbed...
Name: DB.ZIP
Type: application/x-zip-compressed
Size: 9562 bytes
Desc: not available
Url : http://www.winehq.org/pipermail/wine-users/attachments/20060220/bc2b6550/DB-0001.bin


More information about the wine-users mailing list