Hello again, Am Samstag, den 05.01.2008, 22:53 +0100 schrieb Frank Schönheit - Sun Microsystems Germany: > Hi Marc, > > > But after all I'couldn't make it run that easy: > > > > ... > > Dim oSourceDesc as Object > > oSourceDesc = createDataAccessDescriptor() > > oSourceDesc.ConnectionResource = > > "sdbc:file:file:///e:/Daten/Dokumente/OOo_DB/Massendaten/"'datagen7.csv" > > oSourceDesc.CommandType = com.sun.star.sdb.CommandType.TABLE > > 'oSourceDesc.Command = "datagen7" > > oSourceDesc.Command = "datagen7.csv" > > ... > > Hmm. In general, don't append the .csv to the ConnectionResource, and > don't append the .csv to the Command.
Okay, good to know. Finding the subprotocol was somewhat difficult, wouldn't it be worth time documenting the available subprotocols somewhere (besides the scattered occurences in the dev guide)? Would css.sdb.ConnectionResource be the right place? > Other than that: I'd say you need to specify additional settings for the > field delimiter and such. The thread Ariel referred you to should > contain his findings about this. I remember seeking the implementation of the dialog interface taking .csv setting from calc. I'll se what I can do, that'll take some time. > > I tried that way iterating over some variants and got an > > uno.RuntimeException saying: > > > > "invalid attempt to assign an empty interface of type > > css.sdbc.XConnection!" > > Which means (well, better *indicates* for me knowing the code) that the > flat file driver, instead of complaining about the missing settings, > decided to return a NULL connection. Not really nice. Cannot comment, but sounds easy to fix. ;) Thank you, Marc --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
