Loading...
 
Features / Usability

Features / Usability


DSN not found w/ app integration

posts: 11 United States

I'm trying to plugin my own app into the tikiwiki 1.8.5 architecture to take advantage of the templating et al. My page keeps throwing this:

Warning: odbc_connect() C:\apache2triad\php\manual\function.odbc-connect.html: SQL error: MicrosoftODBC Driver Manager Data source name not found and no default driver specified, SQL state IM002 in SQLConnect in C:\XeroCost\src\web\tiki\lib\adodb\drivers\adodb-odbc.inc.php on line 60 odbc error: IM002: Connection error to server 'localhost' with user 'sa' in CONNECT('localhost', ?, ?, 'xerocost')


TikiWiki is running inside Apache2Triad on WinXP. When I run this same app logic outside TikiWiki it works fine. I've made certain that the apache2triad user has read perm on the ODBC DSN config in the registry.

I've noticed that TikiWiki has it's own version of Pear DB, so the possible difference in versions may be the issue.

posts: 11 United States
well, all my code was using the Pear DB connection mechanisms ala DB::connect and such. I found it curious that when I stuck it in TikiWiki the error that I was getting claimed to be related to ADOdb even though I was not using that syntax. So, I converted all my DB code over to the ADOdb syntax and all is well. Not sure what is up with that, but it does look like ADOdb has more features. Now if only there documentation would allow for user comments they would have a good thing going.

Upcoming Events

1)  18 Apr 2024 14:00 GMT-0000
Tiki Roundtable Meeting
2)  16 May 2024 14:00 GMT-0000
Tiki Roundtable Meeting
3)  20 Jun 2024 14:00 GMT-0000
Tiki Roundtable Meeting
4)  18 Jul 2024 14:00 GMT-0000
Tiki Roundtable Meeting
5)  15 Aug 2024 14:00 GMT-0000
Tiki Roundtable Meeting
6)  19 Sep 2024 14:00 GMT-0000
Tiki Roundtable Meeting
7) 
Tiki birthday
8)  17 Oct 2024 14:00 GMT-0000
Tiki Roundtable Meeting
9)  21 Nov 2024 14:00 GMT-0000
Tiki Roundtable Meeting
10)  19 Dec 2024 14:00 GMT-0000
Tiki Roundtable Meeting