Hi, Please see the attached ZIP file for sample database access Thanks & Regards Raghu J. -----Original Message----- From: wine-users-bounces@xxxxxxxxxx [mailto:wine-users-bounces@xxxxxxxxxx]On Behalf Of Raghu Sent: Friday, February 17, 2006 4:58 PM To: wine-users Subject: 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@xxxxxxxxxx [mailto:wine-users-bounces@xxxxxxxxxx]On Behalf Of Dan Kegel Sent: Sunday, January 08, 2006 11:19 PM To: raghu.jonnalagadda@xxxxxxxxxx; wine-users Subject: 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@xxxxxxxxxx http://www.winehq.org/mailman/listinfo/wine-users _______________________________________________ wine-users mailing list wine-users@xxxxxxxxxx http://www.winehq.org/mailman/listinfo/wine-users
Attachment:
DB.ZIP
Description: Zip compressed data
_______________________________________________ wine-users mailing list wine-users@xxxxxxxxxx http://www.winehq.org/mailman/listinfo/wine-users
