iODBC vs unixODBC (which to use)
От | Laura Vance |
---|---|
Тема | iODBC vs unixODBC (which to use) |
Дата | |
Msg-id | 42F0E968.6090808@winfreeacademy.com обсуждение исходный текст |
Список | pgsql-odbc |
I've been trying to install ODBC to connect to a postgresql backend, and I've searched the net for examples in C++, but I can't seem to find much other than on the unixODBC site, and their example compiles, but I can't connect to my database. I get to a point where the environment has been created, then the database handle is created, but when I try to connect to the database, it fails with: SQLDriverConnect = Missing server name, port, or database name in call to CC_connect. (201) SQLSTATE=IM002 Which version of the system ODBC is better to use: iODBC or unixODBC If I have both versions installed, will it cause a problem? Are the two versions compatible? Which version does perl DBI / DBD::Pg use (if it even uses the system ODBC drivers)? (I got my perl apps to work, but I'm not having as much success with my C++ apps). Here are my installed packages for postgresql and odbc: # rpm -q -a | grep -i odbc unixODBC-2.0.8-7mdk libiodbc-3.52.2-1 libunixODBC2-2.0.8-7mdk unixODBC-gui-gtk-2.0.8-7mdk libiodbc-admin-3.52.2-1 postgresql-odbc-7.1.2-19mdk libiodbc-devel-3.52.2-1 # rpm -q -a | grep -i postgres postgresql-server-7.1.2-19mdk postgresql-libs-7.1.2-19mdk postgresql-perl-7.1.2-19mdk postgresql-devel-7.1.2-19mdk postgresql-7.1.2-19mdk postgresql-odbc-7.1.2-19mdk Yes, I know it's an old version, but I need to convert to ODBC before I upgrade, and I hope that it'll be more of a standard interface. When I had to upgrade our apps server, the proprietary PostgreSQL drivers were changed enough that the apps wouldn't work. Since ODBC is a standard interface, it shouldn't matter which version of the proprietary driver is used as long as I use standard ODBC function calls. Which brings up another point. There are some functions and prototypes defined in each of the ODBC versions that do not match in the other, so is ODBC truely standardized? Thanks for any help. -- Thanks, Laura Vance Systems Engineer
В списке pgsql-odbc по дате отправления: