Solved

OleDB connection strings and query format

Posted on 2004-09-13
3
339 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
3 Comments
 
LVL 41

Accepted Solution

by:
shanesuebsahakarn earned 500 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

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In a multiple monitor setup, if you don't want to use AutoCenter to position your popup forms, you have a problem: where will they appear?  Sometimes you may have an additional problem: where the devil did they go?  If you last had a popup form open…
This article describes two methods for creating a combo box that can be used to add new items to the row source -- one for simple lookup tables, and one for a more complex row source where the new item needs data for several fields.
Basics of query design. Shows you how to construct a simple query by adding tables, perform joins, defining output columns, perform sorting, and apply criteria.
In Microsoft Access, learn how to “cascade” or have the displayed data of one combo control depend upon what’s entered in another. Base the dependent combo on a query for its row source: Add a reference to the first combo on the form as criteria i…

730 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