Add ODBC driver to Visual Studio 2012

John Novack

While I have coded in many languages and platforms over 40 years (including Windows since 3.0), this is my first project using .NET for a new client. I'm using ADO.NET MVC 4 on Visual Studio 2012. The application is an Intranet MVC application using Windows authentication. The database (for development) is an internal VS SQL Server Compact 4.0 Local Database within the project. I am having frustration getting the built-in connection mechanisms to the database to do exactly what I want to (.NET keeps doing what IT thinks I want to do and bloating out what should be simple queries). I just want to install an ODBC driver and use the ODBC connection to directly issue SQL statements. Unfortunately, there is no ODBC driver included in .NET.

1. How do I get an ODBC device driver for .NET and install it into Visual Studio?

2. What should my connection string be when I am using an Intranet app piggybacking on internal Windows authentication (no uid or pwd needed in connection string)?

FWIW, the database location is at C:\Dev\CriticalNotes\CriticalNotes\App_Data\CriticalNotes.spf

I will be very appreciative of a rapid response...

The only alternative would seem to be installing NHibernate, but that is also overkill for what this app has to do database-wise.

Thanks in advance

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

Nilesh Jadav11y ago
Hey John ! you are really a hack of a thing man ! Thats great that your passionate to learn many thins at one place, and yeah I agree with you ! BTW nice to talk with you and good luck with ado.net,mvc,C#, it will be very easy for you as you are good coder of C,C++, Thanks man!
0
John Novack11y ago
Thanks. Good stuff. I long for the days of the direct coding of assembly, C, C++, and even the original releases of C# and Core Java. I hate today's IDEs generating my final code for me after I have to write somewhat cryptic code bending around my elbow with @Html helpers and whatnot. It's never what I would have written as a direct solution and ends up with badly bloated systems. But, IMHO. YMMV.
Several academic studies in recent years have shown that the standard corporate web apps created each new year with our highly abstracted language/IDE/framework systems are actually running slower than those from the year before - and are slowing down at a greater rate than cpu speed in increasing. Does not bode well for the future. Give me 5 true ANSI C/C++ wizards and I'll blow away any 30-person team using Java. Ruby, Python/PHP , or .NET in speed of development, quality of production code, and elegance of design.
My generation recognized when PL/1 and ADA were introduced that they were grotesquely bloated and many would not touch them. Java and C# (aside from being too high an abstraction from the actual machine code being generated to be used for optimal performance) were still pretty elegant in their first releases. But (like the frog in the pot of room-temperature water where you raise the water a degree a day until he happily boils to death), both have shown that we programmers will stand still while our languages bloat out to baroque proportions as long as it happens over time. [sigh...]

I'll be using ADO.NET MVC and C# for the next year, so I'd better get used to it. I just hope things aren't getting even worse in VS 2015 :-(
0
Nilesh Jadav11y ago
Hey there john !

you first have to install a connector between vs10 and mysql [or odbc driver].

Read this article here for the same :

https://support.microsoft.com/en-us/kb/310988

This is the connection string list for all databases:"

www.dofactory.com/reference/connection-strings

when you get the drivers, just go to the server explorer, add new database - -> select odbc driver from the database.

Follow these steps:

https://msdn.microsoft.com/en-us/library/aa984313%28v=vs.71%29.aspx
0