display all data source types, using sql query

  • Hi,

    Where to find the following result stored in sql server:

    "microsoft access

    sql server native client

    sql server native client 10.0

    Flat File Source

    Microsoft Excel

    .net Framework data provider for sql server

    ...."

  • sys.dm_exec_sessions

  • Can you please clarify what you meant in the title by "data source types"?

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

  • Hi all members,

    To know what I mean, PLZ do the Following:

    1- Open the sql server management studio.

    2- Point to any user database, then press the right click.

    3- Choose "Tasks", then "Import Data".

    4- When the "Import and Export wizard" appears, Click "Next".

    5- A form allowing you to choose the data source and other details appears.

    6- Point to the list box at the top of the page, and see what it contains.

    Thank you all.

  • sweniosSqlSeeker (2/13/2013)


    Hi all members,

    To know what I mean, PLZ do the Following:

    1- Open the sql server management studio.

    2- Point to any user database, then press the right click.

    3- Choose "Tasks", then "Import Data".

    4- When the "Import and Export wizard" appears, Click "Next".

    5- A form allowing you to choose the data source and other details appears.

    6- Point to the list box at the top of the page, and see what it contains.

    Thank you all.

    What you launched was the "Import and Export Wizard" and what you see is a list of OLE DB providers you have installed on your system. Why do you ask? What are you trying to do?

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

Viewing 5 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply