Re: Need ODBC Jump Start
- From: "Guillem" <guillemvicens-nospam@xxxxxxxxxxxxxxxxxx>
- Date: Tue, 24 May 2005 17:43:18 +0200
Hi,
"Craig Leidy" <surfsoft@xxxxxxxxxxx> escribió en el mensaje
news:4293433c$1@xxxxxxxxxxxxxxxxxxxxxxxxx
> Initially I set it up with text files because all
> the records are memory based.
hate text files for db...
>
> Then I added a Paradox Bill of Materials.
> Later I changed it to an Advantage DB.
much better :)
>
> So now all files can come in via text or
> Advantage. I'm using 3 AdsConnections
> to allow users to locate files separately.
> All of the access to the Advantage is SQL.
by AdsConnections you mean ADOConnections? Or is it another component?
>
> I have a user that is SQL-Server based.
> He wants me to make this ODBC compliant
> so he can connect to it without Advantage.
> How much work is this?
> What's the learning curve?
> Where do I start?
> What question didn't I ask? :-)
mmm, not sure if i'm understanding it right. You want to connect from your
app to SQL Server using ADO, don't you? If that's the case, the answers to
your questions are:
1- not much. Depends on what you need exactly and how good you know ADO
2- Same as above
3- basically you need at least 1 TADODataset or descendant, 1 Datasource for
any visual components that will show data, and i would suggest to use a
TADOConnection too. Depending on how many tables you have and how the data
will be accessed (from the user's point of view) maybe you'll need more than
1 TADODataset and Datasource.
4- Why did the chicken cross the street? :)
--
Best regards :)
Guillem Vicens
Dep. informática Green Service SA
www.clubgreenoasis.com
--
In order to send me a mail, remove the -nospam
.
- References:
- Need ODBC Jump Start
- From: Craig Leidy
- Need ODBC Jump Start
- Prev by Date: Finding a record in a TADOTable
- Next by Date: insert datetime field losting time-part
- Previous by thread: Need ODBC Jump Start
- Next by thread: Finding a record in a TADOTable
- Index(es):
Relevant Pages
|
