[PHP-DB] Oracle to Sybase PHP question

2003-11-25 Thread Jon Davis
Hello PHP gurus,

I have just started to learn PHP, since I have inherited some previous PHP 
scripts that I must maintain.

My question is this:  I have to write a script that gets data from a view in 
Oracle.  I then need to insert that data into a Sybase database.  Can this 
be done?  This will run every 5 minutes.  The view could produce 0 rows of 
data or multiple rows of data, so I guess I would need to use an array of 
some kind.

Anyone have any ideas that could point me in the right direction?

Thanks
Jion
_
From the hottest toys to tips on keeping fit this winter, you’ll find a 
range of helpful holiday info here.  
http://special.msn.com/network/happyholidays.armx

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


RE: [PHP-DB] Oracle to Sybase PHP question

2003-11-25 Thread Ryan Jameson (USA)
I haven't done it in a while but Oracle can write to Sybase directly
using a linked server connection. PHP should not be necessary in this
case. Though PHP is the best scripting language out. :-)

 Ryan 

-Original Message-
From: Jon Davis [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, November 25, 2003 9:13 AM
To: [EMAIL PROTECTED]
Subject: [PHP-DB] Oracle to Sybase PHP question

Hello PHP gurus,

I have just started to learn PHP, since I have inherited some previous
PHP scripts that I must maintain.

My question is this:  I have to write a script that gets data from a
view in Oracle.  I then need to insert that data into a Sybase database.
Can this be done?  This will run every 5 minutes.  The view could
produce 0 rows of data or multiple rows of data, so I guess I would need
to use an array of some kind.

Anyone have any ideas that could point me in the right direction?

Thanks
Jion

_
From the hottest toys to tips on keeping fit this winter, you'll find a
range of helpful holiday info here.  
http://special.msn.com/network/happyholidays.armx

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

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