Search found 4 matches
- Tue Jul 01, 2008 2:51 am
- Forum: Developers Discussion
- Topic: How do I open a second odbc connection?
- Replies: 9
- Views: 8359
Re: How do I open a second odbc connection?
Found Dee's code to work, however, had to change his Connect to NConnect . Hope this helps. Hmm, I tried the same in a UDT with a second MySQL connection (no mssql at my disposal), and that worked as expected: global $gCms; $sar =& ADONewConnection('mysql', 'pear:date:extend:transaction'); $con...
- Tue Jul 01, 2008 2:48 am
- Forum: Developers Discussion
- Topic: Issue connecting to multiple database sources using ADODB
- Replies: 1
- Views: 1888
Re: Issue connecting to multiple database sources using ADODB
Okay... so after a bit of fiddling, I found the following code ( slightly altered - change Connect to NConnect ) which seems to do the job just fine. Not sure why my previous attempts to use NConnect did not result in a working code, but it works now, so I'm not going to complain! For those whom may...
- Tue Jul 01, 2008 2:26 am
- Forum: Developers Discussion
- Topic: How do I open a second odbc connection?
- Replies: 9
- Views: 8359
Re: How do I open a second odbc connection?
I am also experiencing this issue. I have attempted what Dee has posted, but it still does not work. I will not argue that the connection to both databases does not work, however, when smarty is trying to display a global content, it does not work. Can anyone assist with the code THEO was suggesting...
- Tue Jul 01, 2008 1:56 am
- Forum: Developers Discussion
- Topic: Issue connecting to multiple database sources using ADODB
- Replies: 1
- Views: 1888
Issue connecting to multiple database sources using ADODB
Hi all. First time caller, long time listener. I am working on a project using an older version of CMS Made Simple ( I think its 1.02 ) and I'm encountering an issue when I create a 2nd connection to a different database ( both mysql ). DB connection 1 connects to the default database where all the ...