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