Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
shwelch
Starting Member
33 Posts |
 Posted - 2006-10-13 : 07:39:14
|
| I am trying to setup a DTS package with an SQL query that will connect into an intersystems cache system (ODBC) each night and get records that are from the previous day and dump them into sql server 2000 table. I am having trouble getting a sql query that will pull back anything using the standard datediff or other formats to get the previous day. Sometimes I simply get nothing, other times the ODBC driver will just give an error as if the command is not proper. I tried installing intersystems cache 5.x on my client machine but had to revert back to 4.0 odbc driver because I couldnt get that to even connect with 5.0. Is anyone familiar with Intersystems cache? If so, does anyone know if they still have just the 5.0 drivers as a seperate download because the only thing I could find is a whole package of stuff, none of which would let me into the system. Thanks |
|
|
shwelch
Starting Member
33 Posts |
Posted - 2006-10-13 : 15:55:39
|
| Oh yeah, it seems like CONVERT and CAST do not work with the 4.0 intersystems cache ODBC driver but I cannot confirm. Anyone know if there is an equivalent command? |
 |
|
|
|
|
|
SQL with Intersystems Cache ODBC