Results 1 to 10 of 10

Thread: ODBC (SQL SERVER 2012) de 64 bits y ODBC(SQL SERVER 2012) de 32 bits....

  1. #1
    Junior Member
    Join Date
    May 2012
    Posts
    5

    ODBC (SQL SERVER 2012) de 64 bits y ODBC(SQL SERVER 2012) de 32 bits....

    Hola al establecer conexion con ODBC (SQL SERVER 2012) de 64 bits me generar error y al conectarse por ODBC de 32 bits me genera el siguiente mensaje :ODBC connection to focus successful
    Importing from ODBC connection 'focus' into local database ''
    7 tables to import
    Importing table 'dbo.MSreplication_options'
    Importing 3 records...
    3 records imported successfully in 105 ms
    Importing table 'dbo.spt_fallback_db'
    Importing 0 records...
    0 records imported successfully in 44 ms
    Importing table 'dbo.spt_fallback_dev'
    Importing 0 records...
    0 records imported successfully in 53 ms
    Importing table 'dbo.spt_fallback_usg'
    Importing 0 records...
    0 records imported successfully in 72 ms
    Importing table 'dbo.spt_monitor'
    Importing 1 records...
    1 records imported successfully in 124 ms
    Importing table 'trace_xe_action_map'
    ** Error 208 **
    [Microsoft][SQL Server Native Client 11.0][SQL Server]El nombre de objeto 'trace_xe_action_map' no es válido. Importing table 'trace_xe_event_map'
    ** Error 208 **
    [Microsoft][SQL Server Native Client 11.0][SQL Server]El nombre de objeto 'trace_xe_event_map' no es válido. ODBC database import operation completed with errors

  2. #2
    Lianja Development Team barrymavin's Avatar
    Join Date
    Feb 2012
    Location
    UK, USA, Thailand
    Posts
    5,726
    Are you using user defined columns? These cannot be mapped into any other database as they are MSSQL server specific and are non standard.
    Principal developer of Lianja, Recital and other products

    Follow me on:

    Twitter: http://twitter.com/lianjaInc
    Facebook: http://www.facebook.com/LianjaInc
    LinkedIn: http://www.linkedin.com/in/barrymavin

  3. #3
    Junior Member
    Join Date
    May 2012
    Posts
    5
    I'm just asking for odbc Connection is using the option in app builder lianja \ data \ import odbc database

  4. #4
    Lianja Development Team barrymavin's Avatar
    Join Date
    Feb 2012
    Location
    UK, USA, Thailand
    Posts
    5,726
    Hola Rodrigo,

    Yes I understand. Let me see table structure with data types for "trace_xe_action_map".
    Principal developer of Lianja, Recital and other products

    Follow me on:

    Twitter: http://twitter.com/lianjaInc
    Facebook: http://www.facebook.com/LianjaInc
    LinkedIn: http://www.linkedin.com/in/barrymavin

  5. #5
    Lianja Team yvonne.milne's Avatar
    Join Date
    Feb 2012
    Location
    Berkshire, UK
    Posts
    1,369
    Possibly also related to the current user / database owner not being the owner of the table:

    http://technet.microsoft.com/en-us/l...v=SQL.80).aspx
    http://technet.microsoft.com/en-us/l.../cc280443.aspx

  6. #6
    Junior Member
    Join Date
    May 2012
    Posts
    5
    the user is 'sa' and work fine from visual foxpro 9.0

  7. #7
    Lianja Development Team barrymavin's Avatar
    Join Date
    Feb 2012
    Location
    UK, USA, Thailand
    Posts
    5,726
    Ok that may well be so but in order to identify the issue that you are having I need to see the structure of that particular table. Let me see that then we can move on to resolve it.
    Principal developer of Lianja, Recital and other products

    Follow me on:

    Twitter: http://twitter.com/lianjaInc
    Facebook: http://www.facebook.com/LianjaInc
    LinkedIn: http://www.linkedin.com/in/barrymavin

  8. #8
    Lianja Development Team barrymavin's Avatar
    Join Date
    Feb 2012
    Location
    UK, USA, Thailand
    Posts
    5,726
    If you type this in the console:

    SET DEBUG ON

    Then go and import the MSSQL database again, when it fails attach the file c:\lianja\debug\debug_client.txt to your ticket. That will help us track down the problem.
    Principal developer of Lianja, Recital and other products

    Follow me on:

    Twitter: http://twitter.com/lianjaInc
    Facebook: http://www.facebook.com/LianjaInc
    LinkedIn: http://www.linkedin.com/in/barrymavin

  9. #9
    Junior Member
    Join Date
    May 2012
    Posts
    5
    Name:  linja dejo de funcionar.jpg
Views: 220
Size:  76.6 KB

  10. #10
    Lianja Development Team barrymavin's Avatar
    Join Date
    Feb 2012
    Location
    UK, USA, Thailand
    Posts
    5,726
    Hola Rodrigo,

    Please follow these instructions then submit a ticket with the contents of c:\lianja\debug\debug_client.txt so that we can investigate this.

    In the console:

    SET DEBUG ON

    Then import your MSSQL database.

    When it crashes please submit the debug_client.txt file as a ticket at Submit a Ticket.
    Principal developer of Lianja, Recital and other products

    Follow me on:

    Twitter: http://twitter.com/lianjaInc
    Facebook: http://www.facebook.com/LianjaInc
    LinkedIn: http://www.linkedin.com/in/barrymavin

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Journey into the Cloud
Join us