On Wed, 2006-04-12 at 17:18 +0200, Daniel Göhl wrote: > > >On Wed, 2006-04-12 at 16:50 +0200, Daniel Göhl wrote: > >> > What type of database are you wanting to access with read/write > >> >abilities? Which version of OpenOffice.org are you using? > >> > >> >Dan > >> > >> > >> I am using OpenOffice 2.0.2 and I want to connect to a "real" MS SQL > >> Databse. No Acces mdb or something. In VBA one connects via a ADO > >> interface. The Database >is on a server in the network. > >> > > >I am not sure I understand. Are you saying that you cannot register the > >MSSQL database via ADO or something else? > >-- > >PLEASE KEEP MESSAGES ON THE LIST. > >OpenOffice.org Documentation Co-Lead > >http://documentation.openoffice.org/ > > > Well, what I want to do is to read/write data out of a database. I DO NOT > want to use OO BASE. My questions was whether it is possible to use OO Basic, > or any other language, to directly connect to the Database. > > In VBA it looks something like this: > > Dim SQLConnection As New Connection > Dim Data As New Recordset > > SQLConnection.Open (ConnectionProperties) > Data.Open sql, SQLConnection > > The important thing is that I must be able to write Data into the DB. If that > is not possible then we can not switch to OpenOffice! >
Ah! coding. Your question is more appropriate for user@@dba.openoffice.org but I will try. First go to http://documentation.openoffice.org and get the VB to OOoBASIC cross-reference tools. Chances are these will help. If not try the dba project mailing list above. -- PLEASE KEEP MESSAGES ON THE LIST. OpenOffice.org Documentation Co-Lead http://documentation.openoffice.org/ --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
