Search found 4 matches

by SMooTH
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...
by SMooTH
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...
by SMooTH
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...
by SMooTH
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 ...

Go to advanced search