PDA

View Full Version : How do I accomplish a connection to an ODBC System DSN with .NET?


R. T. (Fortran Man)
07-19-2004, 11:37 PM
How do I accomplish a connection to an ODBC System DSN with .NET?

I am trying to build some simple .NET Windows Apps to evaluate L/F Fortran for .NET to determine if it would be a suitable platform for future work. I currently use MS VB6.0 (calling LF95 exe's) and ASP.

All programs are used only inside our company.

To support existing software, all of our work stations and IIS server are configured with one or more ODBC System DSN's. When I try to make a connection to one of them in a Fortran project I get this message:

"Unable to connect to database."
"It is only possible to connect to SQL Server Desktop Engine databases and Microsoft Access databases with this version of Visual Studio."

Is this a short-coming of the Fortran for .NET implementation? I know that it is not a problem with the MS .NET family or VS.NET.

Thanks

Lahey Support
07-19-2004, 11:45 PM
ODBC connectivity does not come with the Framework. Microsoft has a separate download that will install ODBC connectivity, and I have successfully used it with VS and Fortran. I found the download here:
http://www.microsoft.com/downloads/details.aspx?FamilyID=6ccd8427-1017-4f33-a062-d165078e32b1&displaylang=en
Once it is installed, some ODBC tools will appear in the data toolbox of VS, and you use them just like the OLE tools.