Results 1 to 4 of 4
  1. #1
    Join Date
    Nov 2012
    Posts
    2

    Red face 4D database as a linked server in MSSQL

    I need to get access to a 4D database from MSSQL.
    I tried with this script, using an ODBC connection, with bad results:

    EXEC sp_addlinkedserver
    @server = 'yourLinkedDBName',
    @srvproduct = 'mydb.4db',
    @provider = 'MSDASQL',
    @provstr = 'dsn=myDB4Dv11;UID=Designer;'

    I get the message error:
    Data source name not found and no default driver specified.

    Please someone can help me?
    Thank you

  2. #2
    Join Date
    Aug 2004
    Location
    Dallas, Texas
    Posts
    793
    Quote Originally Posted by jazzking View Post
    I need to get access to a 4D database from MSSQL.
    I tried with this script, using an ODBC connection, with bad results:

    EXEC sp_addlinkedserver
    @server = 'yourLinkedDBName',
    @srvproduct = 'mydb.4db',
    @provider = 'MSDASQL',
    @provstr = 'dsn=myDB4Dv11;UID=Designer;'

    I get the message error:
    Data source name not found and no default driver specified.

    Please someone can help me?
    Thank you
    If you are going to use a dsn then you need to create a dsn first which as all the connection information. It's an ODBC connection. Try looking on your start-->control panel--> ....

    Good luck...

  3. #3
    Join Date
    Nov 2012
    Posts
    2
    Of course I created a dsn connection, which works right. The problem is using it in sql!

  4. #4
    Join Date
    Jan 2003
    Location
    Massachusetts
    Posts
    5,506
    Did you create the DSN on the server, or on your client machine? It should be on the server.

Tags for this Thread

Posting Permissions

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