Interview Question: How did you connect to the database?

Maelstrom

Maelstrom

@maelstrom-jwDZvD • Oct 26, 2024
First up, background info: I did my BE project in .NET (Visual Basic), it was a standard two-tier application.

So, the interviewer asks me...
HIM: Which database did you use?
ME: SQL2005
HIM: How did you connect to the database?
ME: ??!???
.
.
.
Um... we used the SqlConnection object...

HIM: ???!!???




Help me out guys, I'm feeling really foolish here. What was I supposed to say?
Like 0 Replies 6

Replies

Welcome, guest

Join CrazyEngineers to reply, ask questions, and participate in conversations.

Sign up Log in

CrazyEngineers powered by Jatra Community Platform

  • NDL

    NDL

    @ndl-XpBSAS • Feb 25, 2010

    I think he wanted to ask you what interest you to use this database or why are using this database and from when.
    0
  • silverscorpion

    silverscorpion

    @silverscorpion-iJKtdQ • Feb 26, 2010

    I think he was asking how you made a connection to the sql server that;s running on your machine.

    I'm not familiar with .net. But I used SQL with Java using JDBC. In that, we used to connect to the database from Java via something called the JDBC driver for SQL.

    Maybe, there's something like that in .net too.. And that would probably be what he asked..
    0
  • Ashraf HZ

    Ashraf HZ

    @Ash • Feb 27, 2010

    "How did you connect to the database?"

    It could be a philosophical question. You never know interviewers these days..
    0
  • optimystix

    optimystix

    @optimystix-4yMPKC • Feb 27, 2010

    well it could be like ash said. but i believe the guy just expected a proper answer from you. whether ur answer's a philosophical or not, if you answered well, it would mean that you have done your job well and he would have been satisfied.

    your answer was a bit loose one. there are ways to connect but i think your connection must have used adodc(object) connection using MS OLEDB provider for SQL server.
    am i right ??

    or did u make use of sql only to make these connections ? its possible both the ways. i know only 2 ways 'cos i have used them. dunno if there are more ways to do. must be though for different servers and objects
    0
  • MaRo

    MaRo

    @maro-Ce3knx • Feb 28, 2010

    I don't think you've never connected to a database!
    0
  • Maelstrom

    Maelstrom

    @maelstrom-jwDZvD • Mar 1, 2010

    I checked a textbook, and here's a tentative answer:

    "I used the .NET Data Provider for Sql Server"

    Howzzat?
    0