PostGres ODBC MFC Application - PostgreSQL Database

Thomas

Hi,

I wish to write an MFC application to access a PostGres database which
will be implemented as a Snort Database. I'm wondering if it is
possible to connect to the database using an ODBC driver, and then
using CRecordset classes as one would when connecting to Access. I
would appreciate any information or direction that can be provided in
this area.

Regards
Thomas

Nov 23 '05 #1

Subscribe Post Reply

2657

mike g

There is an odbc driver for windows.

http://gborg.postgresql.org/project/...rojdisplay.php

One can connect to postgresql using MS Access to view, insert, update
etc.

Mike

On Wed, 2004-06-16 at 05:17, Thomas wrote:

Hi,

I wish to write an MFC application to access a PostGres database which
will be implemented as a Snort Database. I'm wondering if it is
possible to connect to the database using an ODBC driver, and then
using CRecordset classes as one would when connecting to Access. I
would appreciate any information or direction that can be provided in
this area.

Regards
Thomas

---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster

---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

http://archives.postgresql.org

Nov 23 '05 #2

mike g

Hi,

I wish to write an MFC application to access a PostGres database which
will be implemented as a Snort Database. I'm wondering if it is
possible to connect to the database using an ODBC driver, and then
using CRecordset classes as one would when connecting to Access. I
would appreciate any information or direction that can be provided in
this area.

Regards
Thomas

---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster

---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

http://archives.postgresql.org

Nov 23 '05 #3

Similar topics

Excel, OpenOffice and Postgres

by: Bob Powell | last post by:

Hello everyone: Can anyone tell me if it is possible to connect excel or openoffice via odbc directly to a postgres backend database. Also, if that is possible does either OpenOffice or Excel...

PostgreSQL Database

Access + Postgres SQL

by: Jesse | last post by:

Hi all, I need some help with Access database and Postgres Database i am trying to link some Acces tables to Postgres tabels but id doesn't seem to work. I have a Postgres running on a server...

Microsoft Access / VBA

PostGres ODBC MFC Application

by: Thomas | last post by:

Hi, I wish to write an MFC application to access a PostGres database which will be implemented as a Snort Database. I'm wondering if it is possible to connect to the database using an ODBC...

PostgreSQL Database

Postgres and Tools Intro?

by: Randy Yates | last post by:

This has probably been asked before so please be gracious. I have looked on the postgres site and didn't find anything "satisfying." Is there *good* overview of postgres and associated...

PostgreSQL Database

Off Topic - Access to Postgres

by: Hank | last post by:

We have just recently migrated the data from our Access 2000 backend to Postgres. All forms and reports seem to run correctly but, in many cases, very slowly. We do not want to switch over until...

Microsoft Access / VBA

Postgres on XP / ODBC setup / Visual C++ API

by: kalen | last post by:

Hi, (I'm brand new to Postgres.) I'd like to set up a Postgres db/server on an XP machine, and develop apps in Visual C++ (.NET) that access the database. Should I do this using the Windows...

PostgreSQL Database

storing SMALL large objects to postgres with C# (.NET ODBC layer)

by: NM | last post by:

Hello, I've got a problem inserting binary objects into the postgres database. I have binary objects (e.g. images or smth else) of any size which I want to insert into the database. Funny is it...

C# / C Sharp

why Postgres inserts null value for parameterized statement?

by: kishoramballi | last post by:

Hi, I have created table using following sql statement through psql tool in test database using create table t1(f1 int); table is created. Now I am using an odbc script to insert 5 records....

PostgreSQL Database

VB for Changing an ODBC connection to Postgres

by: complete newbie | last post by:

Hi everyone... I need to write a VB procedure for an Excel PivotTable that will change its cached ODBC connection to a new Postgres ODBC connection. I have part of the procedure written but I do...

Visual Basic 4 / 5 / 6

Cloud Servers without Credit Card and Email Registration: A Simpler Way to Get on the Cloud

by: CloudSolutions | last post by:

Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...

General

Access Europe: Command bars, the Access Shortcut Tool and a simple Audit Log - Wed 3 April

by: isladogs | last post by:

The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

General

Easy Steps to Fix "Canon Printer Won't Connect to WiFi Network"

by: taylorcarr | last post by:

A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...

General

How to turn on java script in a villaon keypad mobile phone

by: Charles Arthur | last post by:

How do i turn on java script on a villaon, callus and itel keypad mobile phone

Java

Basic Javascript concepts

by: aa123db | last post by:

Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...

Javascript

Batch import of multiple excel files into the database

by: ryjfgjl | last post by:

If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...

Data Management

Migrating Website to Cloud - Emmanuel Katto

by: emmanuelkatto | last post by:

Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel

General

Navigating the Data Structures and Algorithms (DSA)

by: BarryA | last post by:

What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...

Algorithms / Advanced Math

Is that possible of reading the .csv file in column wise and the column have different lengths ?

by: Sonnysonu | last post by:

This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...

C / C++