does DataDirect documentation exist?

This topic has 3 replies, 2 voices, and was last updated 13 years ago by Jim Kosloskey.

Creator

Topic
November 28, 2011 at 9:39 pm #52819
John Boyles
Participant
Hello,

I’m attempting to connect to SQL Server from TCL (Unix box) using the “Data Direct” ODBC drivers. There is supposed to be documentation available on datadirect.com but I’m unable to find anything useful on this site. Can anyone direct me to the actual technical documentation for the DataDirect ODBC drivers? Unfortunately, all I’ve found on clovertech are links to the homepage which does not help. Specifically, I need information about the handles for the supported datatypes for SQL Server and the meaning of some of the parameters meant to be passed to the various commands.

Thanks!
Creator

Topic

Viewing 2 reply threads

Author

Replies
- November 28, 2011 at 11:02 pm #75575
  Jim Kosloskey
  Participant
  John,
  
  Go here:
  
  http://www.datadirect.com/support/product-info/documentation/by-product.html
  
  From here select the DataDirect Connect for ODBC.
  
  Now as far as any particulars related to what you would put in each SQL Command another source that is very valuable is the Microsoft site for ODBC.
  
  Personally I use very little of the actual SQL commands and instead invoke Stored Procedures from Cloverleaf using DataDirect ODBC Drivers.
  
  Thus I leave it up to the owner of the system to which I am conncting to decide what they want to do with the data and how to do it. I just get the data to them or from them.
  
  email: jim.kosloskey@jim-kosloskey.com 29+ years Cloverleaf, 59 years IT - old fart.
- November 30, 2011 at 3:14 pm #75576
  John Boyles
  Participant
  Thank you, Jim! This is very helpful.
  
  In principle I agree with your approach completely. A lot of what I’m being asked to do from the engine, splitting an HL7 message field by field and inserting the contents into several tables, would make more sense if done on SQL Server in a procedure.
  
  Unfortunately, we’ve been asked to try it this way first. Such is life. =)
- November 30, 2011 at 3:23 pm #75577
  Jim Kosloskey
  Participant
  John,
  
  If you would like to discuss our methodology in case you ever get to the Stored Procedure point, email me.
  
  email: jim.kosloskey@jim-kosloskey.com 29+ years Cloverleaf, 59 years IT - old fart.
Author

Replies

Viewing 2 reply threads

The forum ‘Cloverleaf’ is closed to new topics and replies.