revdberr,invalid database type - ODBC - library not loaded

[mfstuart]

Hi Robert,
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.
> 
> Thanks
> Robert Eppich
> _______________________________________________
> use-revolution mailing list
> use-revolution at lists.runrev.com
> Please visit this url to subscribe, unsubscribe and manage your
> subscription preferences:
> http://lists.runrev.com/mailman/listinfo/use-revolution
> 
> 

-- 
View this message in context: http://www.nabble.com/revdberr%2Cinvalid-database-type-----ODBC---library-not-loaded-tp15110942p15115552.html
Sent from the Revolution - User mailing list archive at Nabble.com.