Loading...
 
Skip to main content

Features / Usability


DSN not found w/ app integration

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.

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.