Oninit cdi / Archive
Talk to an expert →

Linked tables in SQL

Posted in 2006

Topics: General Discussion

Shew, Ken — — source: IIUG Forums & Mailing Lists

Is anyone using linked tables in SQL to connect to a ids9.4 db ken.shew@state.co.us

↪ replying to Shew, Ken
DL Redden — — source: IIUG Forums & Mailing Lists

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.

↪ replying to Shew, Ken
Jean Sagi — — source: IIUG Forums & Mailing Lists

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

↪ replying to DL Redden
Shew, Ken — — source: IIUG Forums & Mailing Lists

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.

↪ replying to Shew, Ken
DL Redden — — source: IIUG Forums & Mailing Lists

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.