Linked tables in SQL
Ken Shew asked whether anyone used SQL Server linked tables with IDS 9.4, and could connect by ODBC but not OLE DB. DL Redden said they used OLE DB from MSSQL 2005 to IDS 10 with CSDK 2.90.TC4 and advised running coledbp.sql against sysmaster from the client etc directory. No confirmation of the result.
Auto-generated by Claude from the posts below — may be imperfect; read the full thread.
Is anyone using linked tables in SQL to connect to a ids9.4 db ken.shew@state.co.us
We're using them, in limited fashion, but it's against IDS 10 from MSSQL 2005. DL Redden ----- Original Message ---- From: "Shew, Ken" <Ken.Shew@state.co.us> To: ids@iiug.org Sent: Friday, April 28, 2006 3:09:08 PM Subject: Linked tables in SQL [6624] Is anyone using linked tables in SQL to connect to a ids9.4 db ken.shew@state.co.us ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum.
It works well. I did it once long ago, but I don't exactly remember now how to dp it. J. Shew, Ken escribió: > Is anyone using linked tables in SQL to connect to a ids9.4 db > > ken.shew@state.co.us > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > >
Thanks for your reply. Are you connecting via odbc or ole/db. I can get the odbc to connect but not the ole/db. Again thanks for your replies Kenneth Shew Colorado Division of Wildlife Wildlife Technologies Law Enforcement Technology Specialist (303) 291-7240 ken.shew@state.co.us -----Original Message----- From: DL Redden [mailto:redden96@yahoo.com] Sent: Friday, April 28, 2006 3:37 PM To: ids@iiug.org Subject: Re: Linked tables in SQL [6625] We're using them, in limited fashion, but it's against IDS 10 from MSSQL 2005. DL Redden ----- Original Message ---- From: "Shew, Ken" <Ken.Shew@state.co.us> To: ids@iiug.org Sent: Friday, April 28, 2006 3:09:08 PM Subject: Linked tables in SQL [6624] Is anyone using linked tables in SQL to connect to a ids9.4 db ken.shew@state.co.us ************************************************************************ ******* Forum Note: Use "Reply" to post a response in the discussion forum. ************************************************************************ ******* Forum Note: Use "Reply" to post a response in the discussion forum.
We are using OLEDB. Make sure that you have ran the coledbp.sql file against sysmaster in the instance that you are trying to connect to. This file is in the etc directory of the client install. We're using CSDK 2.90.TC4, BTW. DL Redden ----- Original Message ---- From: "Shew, Ken" <Ken.Shew@state.co.us> To: ids@iiug.org Sent: Monday, May 1, 2006 4:38:38 PM Subject: RE: Linked tables in SQL [6636] Thanks for your reply. Are you connecting via odbc or ole/db. I can get the odbc to connect but not the ole/db. Again thanks for your replies Kenneth Shew Colorado Division of Wildlife Wildlife Technologies Law Enforcement Technology Specialist (303) 291-7240 ken.shew@state.co.us -----Original Message----- From: DL Redden [mailto:redden96@yahoo.com] Sent: Friday, April 28, 2006 3:37 PM To: ids@iiug.org Subject: Re: Linked tables in SQL [6625] We're using them, in limited fashion, but it's against IDS 10 from MSSQL 2005. DL Redden ----- Original Message ---- From: "Shew, Ken" <Ken.Shew@state.co.us> To: ids@iiug.org Sent: Friday, April 28, 2006 3:09:08 PM Subject: Linked tables in SQL [6624] Is anyone using linked tables in SQL to connect to a ids9.4 db ken.shew@state.co.us ************************************************************************ ******* Forum Note: Use "Reply" to post a response in the discussion forum. ************************************************************************ ******* Forum Note: Use "Reply" to post a response in the discussion forum. ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum.