[PHP-DB] ODBC: access

2007-02-05 Thread bedul
?php
$txt.=h1TEST CONNECT/h1;
// to have this working:
// 1- u  have first to creat ur access database using MS
// Access  (i asume u know how to do this). My database
// that i used in my example is called Questionaire.mdb.
// the table in it is called Results
//
// 2- then u have to add this database to ODBC in the
// control panel.
//
// 3- the adition happens by adding MS Access Driver to the
// System DNS tab in ODBC Data Source Administrator. if
// u have that MS Access Driver in User DNS tab, then
// u have to delete it.
//
// 4- click on Add in the System DNS tab.
//
// 5- choose MS Access Driver from the Creat New
// Database Source window and click finish.
//
// 6- then the ODBC MS Access Setup window will pop-up.
//
// 7- give the driver the name that you want to use in your
// PHP scripting. i used here MSAccessDriver.
// 8- after this, choose the Select button in ODBC MS
// Access Setup to set the path of your Access database.
//
// 9-then u r done!!
// this odbc_connect does the connection to the driver i
// created in the ODBC Administrator

$con= odbc_connect(gundamDB, gunawan,'' ); //= for the first i don't use
config yet
if ($con)
{
 echo odbc connected
;

}
else
 echo odbc not connected
;

odbc_close($con) ;


 echo 'p a href=index.htmreturn/a';
?

the question is..
$con= odbc_connect(gundamDB, gunawan,'' );
in odbc.. i make the user landavia and password landavia
but this return able to connect.. is there something wrong???

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php



Re: [PHP-DB] Trying to add primary key to existing database.

2007-02-05 Thread OKi98
I think you also should read this 
http://en.wikipedia.org/wiki/Database_normalization


--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php



RE: [PHP-DB] OLAP Multidimensional databases and PHP

2007-02-05 Thread Bastien Koert

http://en.wikipedia.org/wiki/Multidimensional_database

http://en.wikipedia.org/wiki/OLAP


bastien


From: Santiago Zarate [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: php-db@lists.php.net
Subject: [PHP-DB] OLAP Multidimensional databases and PHP
Date: Sun, 4 Feb 2007 13:37:01 -0400

Hello...

I'm the kind of PHP guy that people is scared of... i am Too curious :D.

So lately at the company i've been working for like 6 months, they are 
going

to migrate a OLAP program, to vb.net, since i think php could do a better
work... since it can be expanded... well i was looking for information 
about

how to work with OLAP and PHP, but that's not all.. i also would like to
know if someone here knows about multidimensional databases~ and could
explain me a lil bit... i've got some vague ideas... but they arent that
good for me to explain very well...

Note that this program its called Rotator it has 2 parts, the Modeler 
(The

one which builds your tests), and the analyzer (The one who takes your
tests, and lets you analyze it via OLAP) its a very powerfull tool... and
welll... my boss (He did the whole thing in Vb) agreed to work with it 
under

BSD licence if he can do it with PHP... so consider the BOOM thatr
something like this will help PHP and more the Opensource comunity...

Anyone interested in helping?~

Can anyone tellme where to go?... i really wanna know how to work with olap
and multidimensional databases, not just for teh fact of the rotator's
migration, but for the knowledge it has...


_
Your Space. Your Friends. Your Stories. Share your world with Windows Live 
Spaces. http://discoverspaces.live.com/?loc=en-CA


--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php