Results 1 to 2 of 2

Thread: MSSQL + Create tables via VB

  1. #1

    Thread Starter
    Lively Member Maartin's Avatar
    Join Date
    Jan 2000
    Location
    Benoni, Gauteng, South-Africa
    Posts
    99

    Question

    Hi all,

    I need some help, I want to create a table in MSSQL 7.0 using VB6 with DAO and ODBC. I used a declaration of connection and when I try to go about creating the TableDef I keep on getting and error 'Object not supported for this type object.
    I tried various ways but no luck.

    Here is a snipet of the db open and the the create attempt:
    '|Db decl
    Dim wrkMain As Workspace
    Dim dbMain As Connection
    Dim rsMain As Recordset

    '|Connect
    Set wrkMain = CreateWorkspace("Transfers", "", "", bUseODBC)
    Set dbMain = wrkMain.OpenConnection("Transfers",dbDriverComplete,False,"ODBC;DATABASE=Emmadb;UID=sa;PWD=;DSN=Emma DB")

    '|create table
    Dim tblDef As TableDef
    Dim prpLoop As Property
    Dim dbTemp As Database

    Set dbTemp = dbMain.Database
    Set tblDef = dbTemp.CreateTableDef("Transfer_Hist") OR
    Set tblDef = dbMain.Database.CreateTableDef("Transfer_Hist")

    Both the last lines of code give the same error, anybody got ideas or suggestions ?

    Thanks.

    Maartin.
    Have Fun ;-)
    Maartin
    =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
    if it ain't broke don't fix, rewrite it.
    =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=

  2. #2
    Fanatic Member
    Join Date
    Oct 2000
    Location
    London
    Posts
    1,008
    I may be wrong on this, but I do not believe that you can use the Jet workspace this way. You need to use a SQL pass through query, such as "CREATE TABLE MyTable...."

    TableDefs are Jet representations of underlying SQL Server data structures, I don't think that you can use them directly to create tables like this.

    If I am wrong (and I may be), let me know. I am interested.

    For sure though, the pass-through stuff will work.

    Cheers,

    Paul.
    Not nearly so tired now...

    Haven't been around much so be gentle...

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width