Wrox Programmer Forums
| Search | Today's Posts | Mark Forums Read
SQL Server 2000 General discussion of Microsoft SQL Server -- for topics that don't fit in one of the more specific SQL Server forums. version 2000 only. There's a new forum for SQL Server 2005.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the SQL Server 2000 section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old August 28th, 2003, 02:36 AM
Authorized User
 
Join Date: Jul 2003
Location: , , Thailand.
Posts: 40
Thanks: 0
Thanked 1 Time in 1 Post
Default Identity

How to I detect Identity column in SQL SERVER 2000 by using VB6 and ADOX object.??

 
Old August 28th, 2003, 06:19 AM
Friend of Wrox
 
Join Date: Jun 2003
Location: Hudson, MA, USA.
Posts: 839
Thanks: 0
Thanked 1 Time in 1 Post
Default

I don't think you can.

ADOX is a generic mechanism for database schema manipulation. As such, it is made to operate with a variety of providers, most of which don't have an IDENTITY attribute (e.g Oracle and JET).

It may be a provider-specific property of the OLEDB for SQL Server provider, but I couldn't find any mention of it in any documentation I had.

You might try the SQL-DMO objects as an alternative. That does expose an explicit identity property of a (table) column object.

Jeff Mason
Custom Apps, Inc.
www.custom-apps.com
 
Old September 2nd, 2003, 03:16 AM
Authorized User
 
Join Date: Jul 2003
Location: , , Thailand.
Posts: 40
Thanks: 0
Thanked 1 Time in 1 Post
Default

Thanks for your information. I want to know more about SQL-DMO Object. Thanks in advance.

 
Old September 2nd, 2003, 07:05 AM
Friend of Wrox
 
Join Date: Jun 2003
Location: Hudson, MA, USA.
Posts: 839
Thanks: 0
Thanked 1 Time in 1 Post
Default

Look in BOL index for 'SQL-DMO'. There is an extensive and detailed discussion of the SQL Server Distributed Management Objects. Anything you can do in EM, you can do with SQL-DMO.

Jeff Mason
Custom Apps, Inc.
www.custom-apps.com




Similar Threads
Thread Thread Starter Forum Replies Last Post
@@IDENTITY use... neo_jakey Classic ASP Professional 1 May 3rd, 2008 06:47 AM
User Identity stonesbg ASP.NET 2.0 Basics 1 February 9th, 2007 11:14 AM
select into and identity joxa83 SQL Server 2000 2 August 30th, 2006 10:08 AM
@@IDENTITY Problem datagram Pro VB.NET 2002/2003 2 May 19th, 2005 01:34 PM
what does identity do amruthhr SQL Server 2000 2 January 6th, 2005 09:45 AM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.