Can I Use Openoffice Base To Connect To Mysql?

jbitkill

Nov 21 2007, 09:33 PM

How can I connect to my database with OpenOffice 2.3 Base. I know MS Access won't do this since it is only compatible with MS Access/Oracle.

Thanks

xxxx-jozh-xxxx

yordan

Nov 22 2007, 12:28 PM

mysql should work with openoffice base. Have a look at their website here : http://www.openoffice.org/product/base.html
They claim that :

QUOTE

BASE supports many popular databases database natively (Adabas D, ADO, Microsoft Access, MySQL), or any database through industry-standard ODBC and JDBC drivers.

So, I would like to say that the best thing to do is to test it by yourself.
First go to your astahost control panel and create your database, name it for instance "mytesting".
Then, try to use the openoffice.base menus to create your forms. As database name, use the "mytesting" name of the database you created. openoffice will probably ask you the name of the database server, give yoursitename.astashost.com
Tell us if this worked.
Regards
Yordan

Recent Queries:-

openoffice-base basic sql - 89.69 hr back. (1)
openoffice base auto-increment mysql - 103.31 hr back. (1)
mysqldump to openoffice base - 253.56 hr back. (1)
openoffice mysql script - 255.43 hr back. (1)
demo openoffice base - 299.39 hr back. (1)

Similar Topics

Keywords : openoffice, base, connect, mysql,

Login System

I want to make a login system using Mysql. I am amateur in these thing (6)

I want to make a login system using Mysql. I am amateur in these things so please explain in detail
like spoon feeding. I have already made a database in http://www.sitebooth.com now what type of
table I should make and and the website or PHP for it . If you think i hav chosen wrong site please
give any better database hosting site. Please help me Best Regards Pritesh Gupta....

Which Language Is Easy And Secure Today For Web Development

is PHP MYSQL is easy and Secure ? (2)

Web development Application now a day using PHP MySQL Mostly as i observed on discussion topics on
Forums friends switch to PHP MYSqL, Did PHP MYSQL is Easy and Secure for todays environment what
you are say about this Hacking tracking stolen password are very much popular now a days his website
hacked by X person so many time comes to news please emphasis on security issue when you go to
develop any web tools . what is the right way to tight security on PHP what thing i kept in mind
which logic i use that any one can not hack webtools. when i was use java/j2ee languag....

Mysql Overhead

(3)

Sometimes in a table especially if i do alot of things in it i start seeing overhead then a size
near it? what is overhead? and is it essential to optimize the table to fix it? I know its just a
press of a button but i'd like to know what happens when i optimize a table. Also when you make
a new table you can limit the size of VARCHAR to a number, that number would be the number
characters allowed in that column per entry. I'd like to know how the limit works for texts, is
it in KB? or number of characters? Cuz i made a messaging system. And i remember reading s....

How To Connect Ps2 Output To Pc / Monitor?

(4)

A friend of mine is going to bring his PS2 at my place. The trouble is that I don't have a TV in
my apartment. Is it possible to connect the PS2 output to the monitor via an nVidia Graphics card?....

What You Need Before You Can Create A Text-based Game..

Using PHP, HTML and MySQL (7)

Please comment and rate, after you finished reading! /smile.gif" style="vertical-align:middle"
emoid=":)" border="0" alt="smile.gif" />
################################################################# Change log: Aug 22 2008: The
Tutorial Was Created. V1.0.0 Aug 30 2008: Added XHTML and a small CSS part. Also corrected some
small things and added this change log. V2.0.0
################################################################# OK.. Many people here want to
create text based games. Many of you ask us here on the forums: "how to create a text-based game....

Mysql Multiple Tables

(1)

It is good practice to use multiple tables to sort out big amounts of data. But once you do that it
becomes increasingly hard to cross reference the tables. Mysql has a little beautiful command
structure that they have added. You can select multiple tables within one sql query. Example of a
basic sql query CODE $sql = "SELECT * FROM table WHERE row=1"; If you noticed that I selected
all of the rows in the table. Normally you will try to not select the entire table from the database
unless you absolutely want all of the table. I would recommend against it; just gra....

Any Website Provide Free Host Mysql Host?

(4)

any website provide free host mysql host? i need it because i am using 000webhost.com now but it
only provide 2 mysql database... can i know where or how can i get more databases regards....

How To: Display A Members/user List.

With PHP, Mysql, and HTML. (3)

Alright, some of you might want to display your User's or Members on your site. Notes: 1.This
is to fit in with Feelay's register and Log-in scripts you can find in the tutorial section. 2.I
made this to show the members of my site who is a member and what their ID is. First off, we must
set up a connection to our MySQL Database. CODE $con =
mysql_connect("localhost","database_username","database_username_password"); if (!$con) {
die('Could not connect: ' . mysql_error()); } What it does: 1.It is starting a PHP
document. 2.Next it sets....

Mysql Database Entry By Excel Sheets

(2)

Hello .. I would like to ask if i can use use Microsoft excel files in order to make entries to
mysql database. Thanks....

Bluetooth Software

I need bluetooth software (free to download) for my phone to connect t (5)

Hi, I need free bluetooth software that can connect my Nokia 6233 to my Acer Aspire 5315 laptop.
Can anyone help me please?....

Login System Using A Mysql Db

How do i do this? (5)

Hi guys, ive got a registration system that looks something like the one below: Firstname:
Lastname: Then i have inset.php, which looks like the following: $con =
mysql_connect("localhost","autobot","abc123"); if (!$con) { die('Could not connect: ' .
mysql_error()); }mysql_select_db("my_db", $con);$sql="INSERT INTO person (username, password) VALUES
('$_POST ','$_POST ')";if (!mysql_query($sql,$con)) { die('Error: ' .
mysql_error()); } echo "1 record added";mysql_close($con) ?> Now my question is, how do i creat....

Php Tutorial: Making A Shoutbox

Requirements: PHP, MySQL (12)

Hi everyone, I'm going to tell you how to make a simple shoutbox using PHP and MySQL. To start
off, open up mysql in the command line, or phpmyadmin, and create a database called shoutbox. Next,
enter the following sql into the command line, or the phpmyadmin sql box, while using the shoutbox
database: CODE create table messages(author varchar(30), message text, time timestamp, mid int
auto_increment, primary key(mid)); This creates the table we need to store the messages, note the
"mid" column, this gives each message a seperate id number, we'll see why ....

Ajax + Php + Sql = Simply Superb! ( With Visitor Tracking )

A small tutorial to explain integrating php, ajax and MySQL Database (11)

Hi all.. I'm back with a new small tutorial! Introducation A tutorial to integrate
Ajax, Php And Database ( Im using MySQL) + Visitor Tracking! Here you can enter values to some
input fields, and by clicking some enter button, ( or u can call the function on some other event)
those values will be sent to the database, along with visitor details ( IP Address, Input Value,
Visitor Agent etc)! Those values will be stored in some database and you can retrieve the same using
some simple php code and even deleted some rows from those databases! Requiremen....

Qupis : Free Cpanel Web Hosting (one Line Text Ad At Bottom)

150 MB space, 10000 MB Bandwidth, php, mysql, CPanel (10)

Hello Members, We are proud to introduce a new member to Xisto group of sites.
Qupis : Free Web Hosting 150 MB space, 5000 MB Bandwidth, php,
mysql, CPanel (Latest). Emails, FTP, Addon domains, Parked Domains etc.
http://www.Qupis.com
Feel free to add your reviews and comments about it. -AstaHost
Management ....

Navcat For MySQL

is Navcat any good? (9)

Hello all, i ve recently come across NavCat (GUI tool) for MySQL. I have not bought a copy yet, just
played around with the demo. Has any one used it beore, if so please let me know if its worth
buying. I already have PhpMyadmin, Just wanna know if NavCat is better than PhpMyAdmin in usibility
and functionality. Regards....

PHP & MySQL: Displaying Content From A Given ID

(6)

Okay so I got this sample link (not working): http://www.acosta.com/joo.asp?id=654 Now suppose
I have a PHP file that would use MySql in order to get all values in the row where id 654 is found.
Here's a sample DB: Table: demnyc ______________________________________ | id |
Name | Age | Email | *----------------------------------------------------* | 1
| Albert | 17 | no email |
*----------------------------------------------------* | 2 | YaPow | 888 |
no email | |__________....

Connect Using Wireless And Wired Line

(17)

Hi, is it possible for me to use both my wireless and wireline connections at the same time? I'm
primarily online using my wireless PC card for the laptop. But sometimes I want to transfer some big
files over to the other laptop I have in the house. Doing this through the wireless card takes ages
since I'm also using the internet and the wireless transfer is limited to 54Mbps...in the ideal
world /dry.gif" style="vertical-align:middle" emoid=" I want to use a network cable and connect
between the two laptops using that method. That way it "should" give us al....

MySQL, Multiple Tables

(24)

Ok, I'm coding a project which is a leap than what I'd normally do. Before, I've always
learned ONE table... put EVERYTHING in one database table. I'm making a profile system so there
needs to be at least two tables: 1 for users, 1 for content. My problem is, how do I link the two
together? I could probably figure this out faster if someone explained and posted sample SQL code
that shows how the two are linked together. Thanks!! F....

CuteNews: PHP-based Blog System - No MySQL

(11)

I don't know if you guys have heard about CuteNews, but I think it's an awesome blogging
system. If you don't know where to get it or how to set it up, here is a quick run-down.
Download the zip file (virus free) from http://www.mysharebox.com/dl.php?key=8276639 . 1) Unzip
the file. 2) Make a folder titled "cutenews". 3) Upload the contents of the cutenews folder into the
one you've just created. 4) CHMOD the file index.php to 777. 5) CHMOD the folder "data" to 777.
6) Then CHMOD all the files and folders inside of "data" to 777. 7) Go to http://YO....

Important: Basics Of Using PHP And MySQL

(10)

I generally notice confusion with new users to PHP and or MySQL and first of all I believe that
unlike HTML which is automatically associated with a IE browser in a Microsoft system. HTML is
automatically rendered with whatever browser is the default browser, be it Internet Expolrer Firefox
Netscape or any other browser that has been set. PHP is a different matter to view the output of a
PHP file it must be run on a webserver, and if you do not have one set up on your local PC it simply
will not work. (Note serverside langauge requies a server) HTML is client side and ....

MySQL Output Database Question

(18)

I am new to MySql and have just created a database after using a script. My problem is not the
script, but what it says about putting it into the output file. I cant figure out the right terms
to put it in, I keep getting errors. I try using; SELECT*FROM 'database name' WHERE
'location' but it isnt working. I'm lost with this stuff, I really am. Can someone
please help me out?....

MySQL For EasyPHP Users

Does anyone use this program? (5)

I installed a program called EasyPHP because it was an easy install and I wanted to be able to learn
php and still be able to down the road learn MySQL. But I can't figure out how to use MySQL.
Does anyone out there use this program that could tell me alittle about it. Alot of the product
site is written in a different language, but everything on the program is english so that is good.
Any help would be appreciated.....

[PHP + MySQL] Encrypting Data

To protect the password of your DB, for example. (11)

Hi! This is my 2nd code of PHP + MySQL. This code is VERY simple: it encript the data in the MySQL
DB. Here we go! ------------------------------------------------------------------------ CODE
$password = "abc"; $new_password = md5($password); echo $new_password; ?> The password "abc"
was codfied using md5() This will be: 900150983cd24fb0d6963f7d28e17f72 CODE $normal_pass =
"abc"; $encripted_pass = "900150983cd24fb0d6963f7d28e17f72"; if(md5($normal_pass) ==
$encripted_pass) echo "Login Sucessful!"; else echo "Incorrect password."; ?> This c....

Ftp.abhiram.be - Unable To Determine Ip Address

Newly registered a domain, can't connect (8)

I registered for a new domain at .be, and looks like I can't connect to my ftp account. I'm
behind a firewall so I've got to use net2ftp . It's been quite some time since I used ftp.
I used to upload files using the upload script in cpanel. If I try to upload a file, I'm getting
the error: QUOTE Warning: ftp_connect(): php_network_getaddresses: getaddrinfo failed: Name or
service not known in /home/net2ftp/public_html/includes/filesystem.inc.php on line 48 I tried
to login using firefox as ' : @ftp.abhiram.be', but I keep getting: ....

How To Connect Dual/triple Monitor + Advantages

Guide on how to install mult. monitors (21)

I'm sure 95 % of you are running your system with one monitor. Primarily because that is the
default for any computer. What if i told you that running your system with dual monitors or even
triple monitors will increase your user performance extensively? Ways it helps: - can play some
games while instant messaging, writing emails, watching movie on other screen, looking up something
online, etc... - Helps with working on websites or other programming, because code can be on one
side, while the preview image is on the other monitor. - Spreads the space out so you h....

How To: Connect, Read, Write, Close A Database

VB.NET (5)

Here is a tutoral or a novice programmer. This tutorial assumes you have a basic knoladge of
databases and VB.NET. It also assumes that you have a MS access database named Testdb.mdb with a
table called "Table1" that has at least one column called "Col1". You must start with a form with
one label on it. If you need any help email me at bob3695@gmail.com. The first step is connecting
to the database. The first thing you must do is add the ADODB reference. To do this in the
"Project" menu click "Add Reference" then select ADODB from the list and click "Select". The next....

Recover Tables From A MySQL .frm File

(8)

I have a couple of .frm files with no corresponding data or index files. Is it possible to recover
the table structure (field names, types, sizes, rows,col, etc) from these files? The table type is
innodb....

MySQL Realtime Replication

how to replicate mysql in realtime (4)

i dont know if this might be useful to ppl here, but this is a very good knowledge for serious
siteadmins. while i was digging for mysql backup techniques, i've found that mysql is able to
do realtime replication. the idea is that there are master server and slave server. both are having
the same version of mysql installed. the data flows; Master >copy> Slave ( in realtime!)
you'll never have to manually copy the database file of wasting your time to manually use the
mysqldump command. here are the links; http://dev.mysql.com/doc/mysql/en/Replication_HOWTO.h....

Looking for openoffice, base, connect, mysql,

ADD REPLY / Got an Opinion!	a humble request :-)	RAPID SEARCH!	Free Hosting	[X]
Express your Opinions, Thoughts or Contribute your information that might help someone here. Ask your Doubts & Queries to get answers.. "Together, We enlight each other!"	Register FREE for AD-FREE forum, Create your own topics, Ask Questions, track topics, setup subscriptions & notifications and Get a Free Website w/ Email and FTP.		500MB Space No Ads, CPanel, FTP, PHP, MySQL, EMails - 100% FREE