Re: Supporting multiple database'
- From: "Cor Ligthert [MVP]" <notmyfirstname@xxxxxxxxx>
- Date: Sat, 6 Jan 2007 08:42:46 +0100
TCancey,
For this is the 2005 factory, however I have the idea that it is far from
ready.
http://www.vb-tips.com/dbpages.aspx?ID=8c3dc2d7-1232-4dd1-817e-22eaaebb2723
Cor
"TClancey" <tull@xxxxxxxxxxxxxxxx> schreef in bericht
news:Q9edncCLgYnq-QPYnZ2dnUVZ8sSrnZ2d@xxxxxxxxx
Hi all.
I have an app that needs to connect to either - an Access database, MySql
database or MsSql database. It will be the end users decision which they
want to use.
I've done a lot of work with Access in the past, and a good deal with
MySql and realise that there are syntax issues between these two back
ends. I haven't done a great deal with MsSql yet, but I would imagine
that syntax is going to be an issue here as well.
I really want to avoid writing,
If ConnType = "Access" then DoSql("update ....")
If ConnType = "MySql" then DoSql("update ....")
If ConnType = "MsSql" then DoSql("update ....")
for every single Sql statement in the application, but can't think of an
easy way to parse the commands and check syntax.
Has anyone got any ideas?
Cheers,
Tull.
.
- References:
- Supporting multiple database'
- From: TClancey
- Supporting multiple database'
- Prev by Date: Re: when to use stringBuilder vs string concatenation?
- Next by Date: Re: SelectedIndexChanged method always called
- Previous by thread: Supporting multiple database'
- Next by thread: Re: Supporting multiple database'
- Index(es):
Relevant Pages
|
