473,749 Members | 2,356 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

How To Connect To Access Database Using C API's?

3 New Member
I am trying to connect to the Access database for querying, inserting and updating the data using 'C' API's.

If somebody has code to connect to Access Database using C API's can you you please paste it here.

Thanks in advance.
Mar 27 '07 #1
7 10451
sicarie
4,677 Recognized Expert Moderator Specialist
I am trying to connect to the Access database for querying, inserting and updating the data using 'C' API's.

If somebody has code to connect to Access Database using C API's can you you please paste it here.

Thanks in advance.
Here are the Posting Guidelines for this site. Nobody is going to give you code, however, we will help you if you tell us what you have tried and where it's not working.
Mar 27 '07 #2
mahipalerasani
3 New Member
I searched and found out that there are some ways to connect to access using c from ProC and ODBC but I don't have any idea how to start and where to start as I am not a C Programmer.

I am in need of the answer.

Thanks
Mar 28 '07 #3
RedSon
5,000 Recognized Expert Expert
Using a database in any code is a difficult matter, why would you pick a language you are not familiar with to do it in? You should first learn the basics of the C language before you move on to advanced topics like database connectivity.
Mar 28 '07 #4
sicarie
4,677 Recognized Expert Moderator Specialist
I searched and found out that there are some ways to connect to access using c from ProC and ODBC but I don't have any idea how to start and where to start as I am not a C Programmer.

I am in need of the answer.

Thanks
A Google search of 'c programming odbc' returned: this.

(But RedSon has a good point - this will be frustrating and difficult without mastering some of the basics first)
Mar 28 '07 #5
mahipalerasani
3 New Member
Thanks For all your replies.

I know basics of c language but not as much as dedicated c programmers. The reason I choosed the C language to connect to access database is I am basically a Performance Analyst and as you all know that LoadRunner (Performance Testing Tool) uses C language. So that's why I am trying to get answers from professional C programmers like you guys. Please help me in this regards and post some code if somebody has out there.
Mar 28 '07 #6
sicarie
4,677 Recognized Expert Moderator Specialist
Thanks For all your replies.

I know basics of c language but not as much as dedicated c programmers. The reason I choosed the C language to connect to access database is I am basically a Performance Analyst and as you all know that LoadRunner (Performance Testing Tool) uses C language. So that's why I am trying to get answers from professional C programmers like you guys. Please help me in this regards and post some code if somebody has out there.
And again: Nobody is going to give you code.

Post a line you're having trouble with, and a question, and we will help, but nobody here is going to give you code.
Mar 28 '07 #7
RedSon
5,000 Recognized Expert Expert
This is information about Microsoft's ODBC
http://msdn.microsoft.com/library/de...his_manual.asp

This should give you an idea of what you are in for.

Just a note, this site recommends that you read 23 books to help with your understanding of ODBC and C/C++. Let me say that again *twenty-three* books. You are asking us to write code for you in which we would need a vast amount of knowledge about your system, application, environment, network topography, and server, not to mention ODBC and 23 other books.

Sorry friend, you are on your own for this one. We can help with specific problems like "why isnt this line of code working" or "why do I get XYZ error when compiling" but a whole program, not possible.
Mar 28 '07 #8

Sign in to post your reply or Sign up for a free account.

Similar topics

20
4821
by: Mr Dygi | last post by:
Hi, PHP 4.3.4 installed manually from package *.zip and Apache 2. I have a problem with this simple code: <?php $link = mysql_connect("127.0.0.1","","") or die("Could not connect: " . mysql_error()); echo "Connected successfully"; mysql_close($link);
13
3406
by: SectorUnknown | last post by:
I've written a database (Access mdb) front-end using Python/wxpython/and ADO. However, the scope of the project has changed and I need to access the same data on an MSSQL server. Also, the front-end needs to be cross- platform (Windows and Linux). Does anyone have any suggestions on what database connectivity I should use? I've looked at mxODBC and wxODBC briefly, but am not sure what is the best way to go. BTW, although I would love...
11
27262
by: Marcus | last post by:
Hello! I'm trying to write a VB.NET program that connects to a AS/400 Server. I've tried almost everything, but it will not connect. I've tried to set up a DSN using the Client Access ODBC-driver (v8.00.04.08) but with no result. I've also tried a DSN-less connection. From VB.NET i'm using oleDbConnection to create the connection. If I don't supply a provider in the connection string, the program hangs saying that a provider is...
4
3914
by: Development at American Savings | last post by:
I'm having some trouble being able to connect to my db2 server (it lives on an os/2 warp 3 connect box) from my Windows2000 workstation using vs.net 2003. Any suggestions? I have a local user account on the server "readonly", i have created a user in the database of "readonly" and I can connect through the command line, but from within visual studio .net 2003 I cannot make a connection. Better stated: I can make a connection but I...
3
5738
by: Fabian Knopf | last post by:
Hi friends, i have a unix machine PC1 where a database is running ( IBM DB2 V8.1 ) . Then i have another machine PC2 i installed there also ( IBM DB2 V8.1 ). On PC2 i installed unixODBC. To connect to the database over ODBC on unix i did this: on db2 console: catalog tcpip node archiv remote PC1 server DB2_db2inst1
11
6598
by: Grasshopper | last post by:
Hi, I am automating Access reports to PDF using PDF Writer 6.0. I've created a DTS package to run the reports and schedule a job to run this DTS package. If I PC Anywhere into the server on where the job is running, the job runs sucessfully, PDF files got generated, everything is good. If I scheduled the job to run at the time that I am not logged into the server, Access is not able to print to the printer. The error is pretty...
2
3331
by: vikas.bhatia | last post by:
Is this still true? http://groups.google.com/group/comp.databases.ibm-db2/browse_thread/thread/58c6c36ce9006d50/778f98749d8e2983?lnk=st&q=DB2+Connect+product+license&rnum=6#778f98749d8e2983 would a standard type 4 driver, jar file copy into the WEB-INF/lib folder not work? I am trying to access db2 8 on z/os though a java app server. thanks.
1
2212
by: Oleg Ogurok | last post by:
Hi there, My ASP.NET application has impersonation turned on in web.config as follows: <identity impersonate="true" /> However, now I need to connect to a SQL database. Rather than allowing every single AD user access to the database, I'd like to connect to SQL server as the computer account, e.g. MYWEBSERVER$. This should simplify
6
4600
by: Al G | last post by:
Can someone tell me what I need to get connected to our AS400? I am trying to write an app in VS2005(Data source, Gridview) that requires data from files on our AS400. I've downloaded DB2, and installed it, but apparently I need an additional product, "DB Connect" to actually make a connection. "DB connect" says that it will only display tables with a type of "T", and as far as I know, we are using files, not tables on the 400. Can...
0
8996
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...
0
8832
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
0
9566
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
0
9388
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
1
9333
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
0
8256
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
0
6078
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
0
4879
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
3
2217
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.