revdberr,invalid database type - ODBC - library not loaded

[Robert Eppich]

Thanks Mark, I have made the correction you suggested but it didn't  
make a difference. I have loaded the software to a Mac Mini with  
Leopard and it doesn't work either. I am using Actual Technologies  
drivers, version 2.8c, the latest for Leopard.

I have a Windows XP and iMac with Tiger (10.4) using Actual  
Technologies version 2.7. and both those systems work using the same  
code.

I have sent the following error message from the Console to Actual  
Technologies.

-------
1/27/08 9:02:56 PM Revolution[2902] Error loading /Users/epic1/Desktop/ 
Revolution Enterprise/2.8.1-gm-3/Externals/Database Drivers/ 
dbODBC.bundle/Contents/MacOS/dbodbc:  dlopen(/Users/epic1/Desktop/ 
Revolution Enterprise/2.8.1-gm-3/Externals/Database Drivers/ 
dbODBC.bundle/Contents/MacOS/dbodbc, 262): Library not loaded: /usr/ 
lib/libiodbc.2.1.6.dylib
  Referenced from: /Users/epic1/Desktop/Revolution Enterprise/2.8.1- 
gm-3/Externals/Database Drivers/dbODBC.bundle/Contents/MacOS/dbodbc
  Reason: image not found
------

Has anybody used Leopard with my setup successfully? I'm pondering a  
bugzilla report.

Thanks Rob


On Jan 27, 2008, at 10:00 AM, use-revolution-request at lists.runrev.com  
wrote:

> If I'm reading your revOpenDatabase script correctly, you're 3rd  
> parameter
> is incorrect.
> Try this:
> revOpenDatabase("ODBC","Remote_EBCO_ODBC",,"userName","password")
> (just remove the double quotes from the 3rd parameter, as in revs  
> doc copied
> below...)
> I use ODBC connections to MSSQL 2000 and that's the way I do it.
>
>> From Rev's Docmentation:
> "To use a DSN to identify an ODBC database, use the DSN as the host,  
> and
> leave the databaseName parameter empty."
>
> HTH
> Mark Stuart
>
>
> Robert Eppich wrote:
>>
>> Mac OS X 10.5.1(powerPC), Rev 2.8.1 I keep getting the error:
>>
>> "revdberr,invalid database type"
>>
>> using the function:
>>
>> revOpenDatabase("ODBC","Remote_EBCO_ODBC","","userName","password")
>>
>> ODBC Administrator is configured and tests correctly, as does 'Get
>> External Data' > 'New Database Query...' in MS Excel.
>>
>> Using other database types, like MySql, works fine, but ODBC always
>> returns " invalid database type.
>>
>> My console shows this error indicating a library was not loaded.
>>
>> 1/26/08 9:49:02 AM Revolution[1309] Error loading /Users/epic1/ 
>> Desktop/
>> eC Revolution Enterprise/2.8.1-gm-3/Externals/Database Drivers/
>> dbodbc.bundle/Contents/MacOS/dbodbc:  dlopen(/Users/epic1/Desktop/eC
>> Revolution Enterprise/2.8.1-gm-3/Externals/Database Drivers/
>> dbodbc.bundle/Contents/MacOS/dbodbc, 262): Library not loaded: /usr/
>> lib/libiodbc.2.1.6.dylib
>>  Referenced from: /Users/epic1/Desktop/eC Revolution Enterprise/
>> 2.8.1-gm-3/Externals/Database Drivers/dbodbc.bundle/Contents/MacOS/
>> dbodbc
>>  Reason: image not found
>>
>> Any ideas how to fix this? I have downloaded and re-installed Rev
>> 2.8.1 without success.