Open Office .asp Connection strings

Laguna

Howdy all, need a little help with some connections strings.

I've just downloaded Open office as a replacement for Access on my computer as I'm designing a new website and Access is well, ****e for the internet. Now all i'm trying to do is some simple connection strings like you would to Access on a bog standard .asp page a la

Set objConn = Server.CreateObject("ADODB.Command")
objConn.ActiveConnection = "Driver={Microsoft Access Driver (*.mdb)}; DBQ=" & Server.Mappath("../DB/Database.mdb")

Fair enough

How the hell do you go about doing it with Open Office's Base database program? what's the driver I use? the connection string etc. I really need help! Thanks in advance!

Baz_

did you try the documentation, not trying to be smart but the type of people who make that program would usually write up the more technical parts (exactly like this) first. Try googling, I'd be surprised if you didn't find it...

stevenmu

I'm not sure, but I'd guess that Open Office comes with ODBC drivers. If that's the case just set up a system DSN using the ODBC control panel icon and connect to it that way.

Alternately you could try downloading MSDE instead, it's the free version of SQL server.

rsynnott

OpenOffice doesn't come with a database; it just comes with a database access system. Try MySQL or PostGreSQL.

Laguna

Thanks for the help everyone. I'll check out MSDE as I feel Open Office is too messy.