?
Solved

OleDB connection strings and query format

Posted on 2004-09-13
3
Medium Priority
?
351 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 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

Ransomware-A Revenue Bonanza for Service Providers

Ransomware – malware that gets on your customers’ computers, encrypts their data, and extorts a hefty ransom for the decryption keys – is a surging new threat.  The purpose of this eBook is to educate the reader about ransomware attacks.

Question has a verified solution.

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

In earlier versions of Windows (XP and before), you could drag a database to the taskbar, where it would appear as a taskbar icon to open that database.  This article shows how to recreate this functionality in Windows 7 through 10.
This article shows how to get a list of available printers for display in a drop-down list, and then to use the selected printer to print an Access report or a Word document filled with Access data, using different syntax as needed for working with …
In Microsoft Access, learn the trick to repeating sub-report headings at the top of each page. The problem with sub-reports and headings: Add a dummy group to the sub report using the expression =1: Set the “Repeat Section” property of the dummy…
With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks. Specify a start-up form through options: Specify an Autoexec macro: Us…
Suggested Courses

764 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