AW: MS Access with SAPDB problem

"Hï¿½bschen, Peter" Thu, 07 Aug 2003 06:36:37 -0700

Hello, 

I've finally solved it. ADMIN was not my dba, it was my Access login Name
(If you don't login to Access, Admin with empty password is the default);
accidently they were identical, but I stumbled into a new problem (maybe in
a following posting, if I don't find a "google"-solution;-))


But first my working code:

    Dim rs As DAO.Recordset
    Dim wsp     As DAO.Workspace
    Dim dbsODBC As DAO.Database
    Dim ODBCCOnnect As String
    ODBCCOnnect =
"ODBC;Server=IP.Ad.re.ss;DATABASE=DEV_ANFR;UID=xxxx;PWD=xxxx"

    Set wsp = CreateWorkspace("NewODBCWS", "Admin", "", dbUseODBC)    ' This
seems to be the magic part, but please don't ask me why
    
    Set dbsODBC = wsp.OpenDatabase("DEV_ANFR", , True, ODBCCOnnect)
    SQLSTRING = "Select * from TBL_TEILE"
    Set rs = dbsODBC.OpenRecordset(SQLSTRING)

and at least I get an answer if I make a 'Msgbox rs(1)'

Thanks for any help
Peter

> -----Ursprï¿½ngliche Nachricht-----
> Von:  Hï¿½bschen, Peter 
> Gesendet am:  Mittwoch, 6. August 2003 13:08
> An:   'Koetter, Thomas Theodor'; Sapdb General List
> Betreff:      AW: MS Access with SAPDB problem
> 
> Hello, 
> 
> I've simply deleted the username and the password from the
> ODBCCOnnect-String, so that I'm getting asked for them. In the title bar
> is
> shown 7.4.3 and I know that I've installed the latest version of the
> ODBC-driver (.27), 'cause I download everything what I need through ftp.
> 
> Regards
> Peter
> 
> 
> > -----Ursprï¿½ngliche Nachricht-----
> > Von:        Koetter, Thomas Theodor
> [SMTP:[EMAIL PROTECTED]
> > Gesendet am:        Mittwoch, 6. August 2003 11:46
> > An: Hï¿½bschen, Peter; Sapdb General List
> > Betreff:    RE: MS Access with SAPDB problem
> > 
> > Hi Peter
> > 
> > 
> > > > > Since Access is version 97 I have to use DAO+ODBC. Now 
> > 
> > I've no Access 97 at my site, so I'm not sure, where the problem is.
> > 
> > > "ODBC;DSN=DEV_ANFR;SERVER=IP.Ad.re.ss;DATABASE=DEV_ANFR;UID=xx
> > > xx;PWD=xxxx"
> > > > >
> > > > >     Set dbsODBC = DBEngine.OpenDatabase("DEV_ANFR", 
> > > dbDriverNoPrompt,
> > > > False,
> > > > > ODBCCOnnect)
> > 
> > Can you please check, whether the right driver is called
> > (dbDriverNoPrompt)?
> > The SAP DB SQLDriverConnect-Box shows in the Windows title the version.
> > Which driver do you use?
> > 
> > 
> > Regards  Thomas
> > 
> > 
> > ----------------------------------------------
> > Dr. Thomas Kï¿½tter
> > SAP DB, SAP Labs Berlin
> > 
> > 
> > Hurry up, SAP DB is open source     www.sapdb.org 
> > 
> > 
> >  
> > 
> > 
> _______________________________________________
> sapdb.general mailing list
> [EMAIL PROTECTED]
> http://listserv.sap.com/mailman/listinfo/sapdb.general
> 
> 
_______________________________________________
sapdb.general mailing list
[EMAIL PROTECTED]
http://listserv.sap.com/mailman/listinfo/sapdb.general

AW: MS Access with SAPDB problem

Reply via email to