does DataDirect documentation exist?

[John Boyles]

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!

Topic

[Jim Kosloskey]

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.

[John Boyles]

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.  =)

[Jim Kosloskey]

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