Regarding Database-Reply early-Urgent #1

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • sonia.sardana
    New Member
    • Jul 2006
    • 95

    Regarding Database-Reply early-Urgent #1

    In Vb we can connect to all the databases like SQL 2000/SQL 2005,Oracle,Acc ess.
    Out of the given databses we can connect to which databases.

    Secondly,told me dat if I want to connect to SQL-any version(2000/2005), To connect to the database i go to
    Control Panel-->Admintrative Tools-->Data sources(ODBC)-->ODBC Data source Administrator Screen cones,4m which I click on ADD Button--> Now tell me to coonect to SQL,From CREATE NEW DATASOUCE, which option I have to choose.

    Plz Reply early,Its urgent.
  • debasisdas
    Recognized Expert Expert
    • Dec 2006
    • 8119

    #2
    You can connect to any of the SQL 2000/SQL 2005,Oracle,Acc ess.

    It is not compulsary to use DSN.

    Try using the OLEDB providers.

    Comment

    Working...