As others have pointed out, this is the wrong forum 
... but I'm going to take a stab at it.

Disclaimer: I haven't written a conduit, but I've done some
ODBC programming in the distant past. 

>Can anyone tell me why these functions are not returning SQL_SUCCESS ?

Don't know, but the resources are out there. Have you checked out 
the documentation on MSDN? A quick glance reveals detailed error
information.

SQLConnect is here:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/odbc/htm/odbcsqlconnect.asp

SQLDriverConnect is here:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/odbc/htm/odbcsqldriverconnect.asp

There's a huge table listing what the various SQL_SUCCESS_WITH_INFO
conditions are. There are cross-references to some functions that can
get more descriptive error info, such as SQLGetDiagRec:

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/odbc/htm/odbcsqlgetdiagrec.asp

Have you tried eliminating your code from the equation? What about
importing from your DSN into a new, empty local Access
database, or Excel, or whatever? Does it fail too? On 2000? NT? 98?

My guess is that this isn't a Palm or Conduit problem, at all...

Jaba Adams
Shinyfish Software
http://www.shinyfish.com



-- 
For information on using the Palm Developer Forums, or to unsubscribe, please see 
http://www.palmos.com/dev/tech/support/forums/

Reply via email to