Lost Password?


Go Back   CodeCall Programming Forum > Web Development Forum > Database & Database Programming
Reload this Page Odbc Api
Register FAQ Members List Calendar Search Today's Posts Mark Forums Read

Database & Database Programming MySQL, Oracle, SQL, PL/SQL, ABAP, Smart Forms, and other databases and languages. A database is an organized body of related information used in many websites (including CC).

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 05-03-2007, 10:26 AM
Tronman Tronman is offline
Newbie
  
Join Date: May 2007
Posts: 7
Rep Power: 0
Tronman is on a distinguished road
Default Odbc Api
Hi All,

I'm currently learning how to do ODBC connections with the ODBC API in Visual C++ 6.0


Is there another/a nicer way to use the ODBC API from one Visual Studio Express editions (i.e. VB 2005)? Specifically, I'm trying to determine primary/foreign keys in a table in a database that I'm connected to through ODBC, and I have not found a way to do it using the System.Data.Odbc objects, but the API has functions for this.

Thanks!
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote

Sponsored Links
  #2 (permalink)  
Old 05-03-2007, 10:47 AM
v0id's Avatar   
v0id v0id is offline
Retired
  
Join Date: Apr 2007
Location: Denmark
Posts: 2,630
Last Blog:
CherryPy(thon)
Rep Power: 28
v0id is a glorious beacon of lightv0id is a glorious beacon of lightv0id is a glorious beacon of lightv0id is a glorious beacon of lightv0id is a glorious beacon of lightv0id is a glorious beacon of light
Send a message via MSN to v0id
Default
A good place to start looking would be in the ODBC Reference on MSDN.

ODBC Programmer's Reference (Microsoft Open Database Connectivity (ODBC))
__________________
05-03-2007 - 11-13-2008
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #3 (permalink)  
Old 05-03-2007, 10:54 AM
Tronman Tronman is offline
Newbie
  
Join Date: May 2007
Posts: 7
Rep Power: 0
Tronman is on a distinguished road
Default
That's exactly what I have been using, mostly the ODBC API Reference.


I'm wondering if there is a way to open up it's functionality from .NET, System.Data.ODBC doesn't seem to have everything I want.
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #4 (permalink)  
Old 05-03-2007, 11:51 AM
Tronman Tronman is offline
Newbie
  
Join Date: May 2007
Posts: 7
Rep Power: 0
Tronman is on a distinguished road
Default
Okay...

I seem to be able to extract Primary Key info from a table with

OdbcDataAdapter.MissingSchemaAction = MissingSchemaAction.AddWithKey

Then checking the Primary Key on the table after using Fill.


Any idea about Foreign Keys?
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Reply

« Previous Thread | Next Thread »


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes
Linear Mode Linear Mode

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
ODBC API - Special Table and Column Names Tronman Database & Database Programming 0 07-30-2007 01:52 PM
ODBC with VS C++ 6 Problem MarkWasik C and C++ 0 04-10-2007 03:31 PM
java--ILOG rules roger Java Help 1 07-15-2006 02:03 PM


All times are GMT -5. The time now is 11:38 AM.

Contact Us - Programming Forum - Archive - Top

CodeCall

Contest Stats

WingedPanther ........ 2753.6
Xav ........ 2704
Brandon W ........ 1702.32
John ........ 1207.73
marwex89 ........ 1175.24
morefood2001 ........ 966.05
dcs ........ 655.75
Steve.L ........ 475.59
orjan ........ 418.58
Aereshaa ........ 383.54

Contest Rules

CodeCall Goal

Goal: 100,000 Posts
Complete: 97%

Sponsors

Linux Forums
Electronic Music
Podnet IRC Network

Ads