Thank you very much! The datasource in question doesn't house any =
tables
that I will access directly, rather I will be running stored =
procedures, so
I need to form and execute my sql without using the usual spops =
objects...
So do you know of a way I can do this?
Thanks again,
Chris
-----Original Message-----
From: And...@Be... =
[mailto:And...@Be...]
Sent: February 20, 2003 3:51 AM
To: Chris McDaniel; ope...@li...
Subject: AW: [Openinteract-help] second db connection
Hi Chris,
you are almost right:
- yes, you can define more datasources in your server.ini / =
server.perl
like this
[db_info seconddb]
db_owner =3D
username =3D auser
password =3D apassword
dsn =3D host=3Dbigbox.dbs.com
db_name =3D adbname
driver_name =3D mysql
sql_install =3D
long_read_len =3D 65536
long_trunc_ok =3D 0
- to access this, you do not have to do anything special in your =
handler
- all you have to do is add a key to the SPOPS definition ( i.e.
conf/spops.perl ) like this:
'datasource' =3D> 'scounddb',
Hope this gets you up and running,
regards,
Andreas
-----Urspr=FCngliche Nachricht-----
Von: Chris McDaniel [mailto:Chr...@te...]
Gesendet: Donnerstag, 20. Februar 2003 09:20
An: 'ope...@li...'
Betreff: [Openinteract-help] second db connection
Hello,
Hope I'm not making a nuisance of myself, but I have yet another =
question.
In the server.ini it says things like:
[datasource]
default_connection_db =3D main
and
[db_info main]
which makes me think that you could have other non-default datasources =
and
do a [db_info whatever] type statement. I'm not sure if this is =
something
that is meant to be done, but if so, are there any docs on it? If not, =
what
would I need to add to my ini file and how would I access this =
secondary DB
from within a handler?
Thanks!=20
Chris McDaniel
-------------------------------------------------------
This SF.net email is sponsored by: SlickEdit Inc. Develop an edge.
The most comprehensive and flexible code editor you can use.
Code faster. C/C++, C#, Java, HTML, XML, many more. FREE 30-Day Trial.
www.slickedit.com/sourceforge
_______________________________________________
openinteract-help mailing list
ope...@li...
https://lists.sourceforge.net/lists/listinfo/openinteract-help
|
