DSN configuration Posted by Spyros Kroustalakis 11 May 2004 09:27 GMT-0000 posts: 32 Is it possible to connect to an ORACLE database using DSN? What must be the DSN string? ❓ Spyk
Posted by Damian Parker 11 May 2004 10:19 GMT-0000 posts: 2881 Hi Probably using an ODBC connection, A quick google on DSN Oracle PHP gave me some interesting results. Damian
Posted by Spyros Kroustalakis 11 May 2004 13:19 GMT-0000 posts: 32 Maybe, I don't express, very clearly, in English what I want to say. I would like to know how we form the DSN string in SQL Plugin in the case of an Oracle Database. Because the example in the previous Wiki page is about MySQL. Spyros UserPagespyk
Posted by zoen 12 Jul 2005 08:44 GMT-0000 posts: 2 Hi Spyros! I think I know you... Well, I have Oracle 8 Database and I use the following DSN configuration string oci805://username:password@serverIP/DBAlias everything works fine!!
Posted by Spyros Kroustalakis 11 May 2004 13:19 GMT-0000 posts: 32 Maybe, I don't express, very clearly, in English what I want to say. I would like to know how we form the DSN string in SQL Plugin in the case of an Oracle Database. Because the example in the previous Wiki page is about MySQL. Spyros UserPagespyk
Posted by zoen 12 Jul 2005 08:44 GMT-0000 posts: 2 Hi Spyros! I think I know you... Well, I have Oracle 8 Database and I use the following DSN configuration string oci805://username:password@serverIP/DBAlias everything works fine!!
Posted by Philippe Cloutier 15 Nov 2004 14:56 GMT-0000 posts: 1001 Hi spyk, for the the SQL plugin itself, the string is simple, like {SQL(db=>oracle)} assuming you named your DSN "oracle". The real question would be how you create your DSN. Did you try with the info in AdminDSN? What's not working? I hope that helps, if not you can try asking on the IRC channel.
