Map ADO data types to SQL

Tech-Archive recommends: Fix windows errors by optimizing your registry

Does anyone know where there is available a complete mapping of ADO data
types to SQL (mainly MS Jet but also SQL Server and MySQL flavours)? If I
want to create a new table in database B, based on a recordset in database
A, I need to loop through the elements of the recordset and add to a CREATE
TABLE command. However, where do I find the documentation which relates, eg
adInteger to "int" adLongVarChar to "text" and an autonumber field to
"identity" etc. These are just the Jet database versions. My method up to
now was randomly to try anything vaguely right until it worked eg adDate ->
"date" but there must be a better way!

Help much appreciated.

Dave


.

Relevant Pages

  • Re: Im very confused about the different databases!
    ... There's DAO, ADO, ADO.NET, Jet, SQL, SQL Server ... What database & version comes with VB6 LE? ... What is the most current database that I can use with VB6 LE? ... Why isn't Jet or whatever VB6 LE uses listed in Add-Remove Programs? ...
    (microsoft.public.vb.general.discussion)
  • Re: Any reason why accessing Access should slowdown?
    ... On the MSACCESS / JET OLEDB front, you responded to a query I had about the ... Declared connection to Access database using string based on Jet OLDB ... Set up recordset filter in response to earlier input / selection ... ¤ I am writing a VB6 App using an Access database backend ...
    (microsoft.public.vb.database)
  • Re: Database Connectivity
    ... Never was Jet mentioned anywhere at anytime. ... >> Microsoft Access Database Solutions, with not a single mention of Jet. ... front end, and the underlying database engine, JET. ... like SQL Server, Sybase, MySQL, etc. ...
    (comp.lang.python)
  • Re: Duplicate Values Question
    ... My general approach when working with SQL server does NOT include the use of ... If you think that Access 2007 means that Jet ... database code will remain the same forever... ... constraints correct and maintain the data integrity... ...
    (microsoft.public.access.tablesdbdesign)
  • Re: Why not Access...?
    ... The first point is, yes, Jet, not Access, is a file based, Pseudo-RDBMS. ... Jet database will corrupt and become ... MS Jet/Access, MSDE, and SQL Server 2005 Express Edition. ... > I am developing a desktop application using VB as front-end for some clients> where the a large number of regular entries are done but there is a rare need> to delete old customers. ...
    (microsoft.public.sqlserver.server)