OpenOffice Database connection string

[mcgyvr]

Looking for the equivalent for an OpenOffice database versus the following code for MS Access.
Thanks in advance

' Create an ADO Connection to connect to the sample database.
Set cnnSearch = Server.CreateObject("ADODB.Connection")

' This line is for the Access db connection string
cnnSearch.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & strDBPath & ";

 

[PaulBricker]

Have a look here

http://www.unixodbc.org/doc/OOoMySQL9.pdf

and see if anything helps.
I googled 'ODBC connection to OpenOffice' and got quite a few hits.

Paul

 

[mcgyvr]

Everything I see talks about connecting TO an access database from within openoffice.

I just want to stop using access and use openoffice database for a simple website product catalog built using asp.

Anyone else

 

[PaulBricker]

OpenOffice.org has tutorials and forums for OpenOffice questions. Your question might have a better chance of getting answered there but you may not have a choice with OpenOffice. It may require you to connect to an ODBC compliant database to do what you want.

Paul