Sql and DB Brand

N

Nice Chap

My application can use both SQLClient and OleDBClient, how can I write a
common SQL for both the options ? OleDB uses ? as a parameter and SqlClient
expects @Name as the parameter. I don't want to inject literal values into
the Sql. Is there is a way out at all ?
 
A

Armin Zingler

Nice Chap said:
My application can use both SQLClient and OleDBClient, how can I
write a common SQL for both the options ? OleDB uses ? as a parameter
and SqlClient expects @Name as the parameter. I don't want to inject
literal values into the Sql. Is there is a way out at all ?
Click to expand...

Please ask in the database group instead. This group is about VB.Net related
questions.

microsoft.public.dotnet.framework.adonet


--
Armin

How to quote and why:
http://www.plig.net/nnq/nquote.html
http://www.netmeister.org/news/learn2quote.html
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

SQL and Database Brand/Provider 1
Problem importing Date Field into SQL DB. 3
Oledb VS Sql. Oledb works with Sql Server; Sql doesn't...why 5
SQL Server 2005 throught OLEDB : Named parameter problem ? 3
Can you use the OleDb classes for SQL Server? 8
Is it SQL 2008 or VB 2008 problem? I don't know 1
DB abstraction 1
Visual Studio 2005 to 2008 with problem 2

Top