Hi All, I am stuck up in a very difficult situation.
I am using SQL Server 6.5 at the backend as my server and from which I am fetching data. My SQL server is placed on that machine which uses winNT as OS. I have installed my palm desktop on the same machine and have registered my conduit also. My Conduit accesses SQL Server Database through an ODBC DSN connection. When I run HotSync Manager, My Conduit is called but two functions in it are giving the result which were not expected. The Functions are SQLConnet () and SQLDriverConnect().. It is expected that both these functions to return SQL_SUCCESS but they are returning SQL_SUCCESS_WITH_INFO... and here the whole problem starts... Can anyone tell me why these functions are not returning SQL_SUCCESS ? One more interesting thing is that, When I use my laptop having OS as Win98 with an ODBC connection for my SQL Server (Server still resides on WinNT) then My conduit runs properly.. I have not checked for the return values here for the above two functions but my conduit fetches data from SQL Server. Well, I havent checked for the return codes in the above two functions.. but if my conduit fetches data, I assume that the connection has been established properly (not sure...is it right ?) Can anyone tell me as to how shall I overcome the first problem (i.e. why my conduit is not running properly on winNT system) and what precisely is going on in both the cases. Is it a problem with Windows OS compatibilty or is it something other than what I am thinking ? Urgently, I need guidance in this regard.. Awaiting all the replies. Regards, Atul -- For information on using the Palm Developer Forums, or to unsubscribe, please see http://www.palmos.com/dev/tech/support/forums/
