Results 1 to 1 of 1
  1. #1
    Join Date
    Sep 2002
    Posts
    30

    Unanswered: Development software

    Hi, I want to ask about development software for MS SQL Server, kind like Oracle Designer if any. Can someone give me a name? Thank you.

    Also, I want to know how to open a text source using openrowset command. How I can know provider list and how I can provide a driver at provider string? I tried to write these statement but it says that it cannot find driver, and the other says that it cannot find provider.

    select * from openrowset('MSDASQL', '{Driver=Microsoft Text Driver (*.txt; *.csv)};DefaultDir=C:\', 'SELECT * FROM sample.csv')
    OLE DB provider 'MSDASQL' reported an error.
    [OLE/DB provider returned message: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified]

    select * from openrowset('Text', 'DefaultDir=C:\', 'SELECT * FROM sample.csv')
    Could not locate registry entry for OLE DB provider 'Text'.

    I used entries written at DSN I made.

    Another question fetching the data from exec statement. Something like
    set @trdate = exec('SELECT top 1 Tgl FROM Sales_' + @t1 + ' WHERE ID = 20')
    Last edited by prd00; 01-15-03 at 00:15.

Posting Permissions

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