Improve company productivity with a Business Account.Sign Up

x
?
Solved

OleDB connection strings and query format

Posted on 2004-09-13
3
Medium Priority
?
362 Views
Last Modified: 2006-11-17
1) Can someone please show me an example of an Ole Connection String for MS Access, MS Sql Server, and MySql.
2) Are the following queries well-formed Ole querystrings?  If not, how do I fix them?
SELECT [template_DB_PurchasedCodes].[CreationDate] FROM [template_DB_PurchasedCodes] WHERE ([template_DB_PurchasedCodes].[Code] = ?)

INSERT INTO [template_DB_PurchasedCodes] ([Code], [CreationDate]) VALUES (?, ?)

UPDATE [template_DB_TrialCodes] SET [RunsLeft]=? WHERE ([template_DB_TrialCodes].[Code] = ?)
0
Comment
Question by:thedude112286
3 Comments
 
LVL 41

Accepted Solution

by:
shanesuebsahakarn earned 2000 total points
ID: 12049369
Have a look here:
http://www.able-consulting.com/MDAC/ADO/Connection/OLEDB_Providers.htm

As for the queries, they all look pretty standard and should work on most (if not all) dialects of SQL.
0
 
LVL 34

Expert Comment

by:flavo
ID: 12049482
0
 
LVL 75

Expert Comment

by:Anthony Perkins
ID: 13790800
Please maintain this abandoned question.  See here dro more information:
What are my choices?
http://www.experts-exchange.com/Databases/MS_Access/help.jsp#hi67
0

Featured Post

Get 10% Off Your First Squarespace Website

Ready to showcase your work, publish content or promote your business online? With Squarespace’s award-winning templates and 24/7 customer service, getting started is simple. Head to Squarespace.com and use offer code ‘EXPERTS’ to get 10% off your first purchase.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

If you’re using QODBC to update QuickBooks data from Microsoft® Access but Access is not showing the updated data, you could have set up QODBC incorrectly.
In a use case, a user needs to close an opened report by simply pressing the Escape (Esc) key. This can be done by adding macro code in Report_KeyPress or Report_KeyDown event.
In Microsoft Access, learn how to use Dlookup and other domain aggregate functions and one method of specifying a string value within a string. Specify the first argument, which is the expression to be returned: Specify the second argument, which …
This lesson discusses how to use a Mainform + Subforms in Microsoft Access to find and enter data for payments on orders. The sample data comes from a custom shop that builds and sells movable storage structures that are delivered to your property. …

606 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question