Wrox Programmer Forums
Go Back   Wrox Programmer Forums > .NET > .NET 1.0 and Visual Studio.NET > VS.NET 2002/2003
VS.NET 2002/2003 Discussions about the Visual Studio.NET programming environment, the 2002 (1.0) and 2003 (1.1). ** Please don't post code questions here ** For issues specific to a particular language in .NET, please see the other forum categories.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the VS.NET 2002/2003 section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
Old February 19th, 2005, 01:12 AM
Authorized User
Join Date: Oct 2004
Posts: 39
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via AIM to dotnetprogrammer
Default Connecting and retrieving data from postgresql dat

I'm a bit confused about the best way to connect to a database server
from .net. Basically I have a Linux machine running the PostgreSQL
database server which I routinely connect to from Windows 2000 Server,
via ODBC, using a database admin tool.

I need to access and modify the contents of tables on my PostgreSQL
database from .net in C#. There seem to be a lot of ways of doing this
and I don't know the difference between them nor which is the best way
for my purposes. Should I use ADO, OLEDB? Can I achieve what I want just
using the SqlConnection and SqlCommand classes? Do I need to download
and install Oracle.NET and what is the relevance of the
System.Data.Odbc.dll file?

With MFC (Microsoft Foundation Class) things were a lot simpler, I used
the CDatabase and CRecordset classes; you connected using ODBC with
CDatabase and used CRecordset to manage your sql queries/commands. Is
there a similar pair of classes in .net?

Many thanks for your help, as you can see I am a bit unsure of my ground




Similar Threads
Thread Thread Starter Forum Replies Last Post
trouble connecting to PostgreSQL with Tomcat /JSF raindogs Apache Tomcat 0 October 31st, 2006 01:31 PM
Retrieving Data From Server x_ray Word VBA 0 June 12th, 2006 10:33 AM
Connecting to dat file from access or VB shaiss Access VBA 0 December 31st, 2005 02:21 PM
Connecting with database in postgresql using c# dotnetprogrammer VS.NET 2002/2003 1 April 29th, 2005 07:05 AM
export data to .dat format chacquard Access VBA 6 January 10th, 2005 03:50 PM

Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.