[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,
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
More information about the wine-users
mailing list