search for: sqldriverconnect

Hello, I have configured Wine in Ubuntu 9.04 to use the built-in odbc32.dll which in turn uses the Linux's unixodbc package. When I am trying to run my windows application which actually uses Windows API connecting to Unix ODBC is not working. The API uses is SQLDriverConnect (), that returns me error [unixODBC][Driver Manager]Can't open lib '/usr/lib/libtdsodbc.so' file not found. Since wine is clone to Windows API any application using that API should run also in Wine. Please let me know if wine windows API has any issues with unixODBC. Please advise how...

...non-odbc based database programs from the Mac, so I know it's not a Postgres setting (like no tcp/ip connections or something). > library(RODBC) > channel <- odbcConnect("nfl",uid="postgres", pwd="xxx") Warning messages: 1: [RODBC] ERROR: Could not SQLDriverConnect 2: ODBC connection failed in: odbcDriverConnect(st, case = case, believeNRows = believeNRows) > > channel2 <- odbcDriverConnect(connection="DSN=nfl, UID=postgres, PWD=vladdy79" ) Warning messages: 1: [RODBC] ERROR: state IM002, code 0, message [iODBC][Driver Manager] Data...

...e instructions at http://wiki.rubyonrails.com/rails/pages/HowtoConnectToMicrosoftSQLServerFromRailsOnOSX up to the point where you run the iodbctest where I get an error. The errors are: iODBC Demonstration program This program shows an interactive SQL processor Driver Manager: 03.52.0001.0928 1: SQLDriverConnect = [iODBC][Driver Manager]Data source name not found and no default driver specified. Driver could not be loaded (0) SQLSTATE=IM002 1: ODBC_Connect = [iODBC][Driver Manager]Data source name not found and no default driver specified. Driver could not be loaded (0) SQLSTATE=IM002 I found that the hel...

Graham, nice package this :-)-O. It was easy to set up MySQL but I struggled immensely to get the stock ODBC working with PostgreSQL (8.3), which has been discussed on the mailing list before (Prof Brian): Warning messages: 1: In odbcDriverConnect(st, ...) : [RODBC] ERROR: Could not SQLDriverConnect 2: In odbcDriverConnect(st, ...) : ODBC connection failed aka (DBD::ODBC in Perl) Missing server name, port, or database name in call to CC_connect. (SQL-IM002) aka (iodbctest) SQLDriverConnectW = Unknown connect option (Set) (205) SQLSTATE=S1009 Figured it out, though: Leopard comes with i...