|
 |
asp_databases thread: RE: Urgent - Can I use ASP to access Paradox database and are there any books on this?
Message #1 by "Ben Lew" <formula1@o...> on Sat, 16 Dec 2000 01:54:14 -0500
|
|
I posted this before and no answer, it's pretty urgent for me to know if
this is possible...I need to give an estimate to a potential client...I'm
not asking for code or how to do it, just to know if it's possible and to
point me in the right direction.
The subject says it all...I have (by now) a pretty decent amount of
experience with ASP 2.0 and SQL 7.0 but I have a potential client whose
database is Paradox and I need to know if ASP can be used to access a
Paradox database and is there a good book on this? Or can I use my ASP
knowledge and just pick up a Paradox book to learn the equivalent
expressions, schema, etc. corresponding to what I know in T-SQL?
Thanks,
Ben
---
FREE SOFTWARE DEVELOPMENT CODE, CONTENT, AND
INSIGHTS IN YOUR INBOX!
Get the latest and best C++, Visual C++, Java, Visual Basic, and XML tips, tools, and
developments from the experts. Sign up for one or more of EarthWeb?s
FREE IT newsletters at http://www.earthweb.com today!
---
You are currently subscribed to asp_databases as: $subst('Recip.EmailAddr')
To unsubscribe send a blank email to leave-asp_databases-$subst('Recip.MemberIDChar')@p2p.wrox.com
Message #2 by "StephenB" <stephen@v...> on Sat, 16 Dec 2000 10:42:51 -0000
|
|
Yes you can. There will be an ODBC driver which you use with ASP in the
same way as the ODBC driver for Access or any other database. Whether this
would work well enough for your purposes you will have to test.
Stephen
"Ben Lew" <formula1@o...> wrote in message
news:25891@a..._databases...
>
>
> I posted this before and no answer, it's pretty urgent for me to know if
> this is possible...I need to give an estimate to a potential client...I'm
> not asking for code or how to do it, just to know if it's possible and to
> point me in the right direction.
>
> The subject says it all...I have (by now) a pretty decent amount of
> experience with ASP 2.0 and SQL 7.0 but I have a potential client whose
> database is Paradox and I need to know if ASP can be used to access a
> Paradox database and is there a good book on this? Or can I use my ASP
> knowledge and just pick up a Paradox book to learn the equivalent
> expressions, schema, etc. corresponding to what I know in T-SQL?
>
> Thanks,
>
> Ben
>
> ---
> FREE SOFTWARE DEVELOPMENT CODE, CONTENT, AND
> INSIGHTS IN YOUR INBOX!
> Get the latest and best C++, Visual C++, Java, Visual Basic, and XML tips,
tools, and
> developments from the experts. Sign up for one or more of EarthWeb?s
> FREE IT newsletters at http://www.earthweb.com today!
$subst('Recip.EmailAddr')
leave-asp_databases-$subst('Recip.MemberIDChar')@p2p.wrox.com
>
>
---
FREE SOFTWARE DEVELOPMENT CODE, CONTENT, AND
INSIGHTS IN YOUR INBOX!
Get the latest and best C++, Visual C++, Java, Visual Basic, and XML tips, tools, and
developments from the experts. Sign up for one or more of EarthWeb?s
FREE IT newsletters at http://www.earthweb.com today!
---
You are currently subscribed to asp_databases as: $subst('Recip.EmailAddr')
To unsubscribe send a blank email to leave-asp_databases-$subst('Recip.MemberIDChar')@p2p.wrox.com
Message #3 by "Dallas Martin" <dmartin@z...> on Sat, 16 Dec 2000 10:02:13 -0500
|
|
Ben,
You can create an ODBC connection for a Paradox file.
Open the ODBC32 icon in Control Panel or Administrators
Panel , select SYSTEM DSN, then click ADD. You'll see
a list of available ODBC drivers. Paradox is among them.
I don't know if the is an OLE DB driver. But you can go
to www.microsoft.com and search for Paradox in the
ADO area.
Dallas
----- Original Message -----
From: "Ben Lew" <formula1@o...>
To: "ASP Databases" <asp_databases@p...>
Sent: Saturday, December 16, 2000 1:54 AM
Subject: [asp_databases] RE: Urgent - Can I use ASP to access Paradox
database and are there any books on this?
>
> I posted this before and no answer, it's pretty urgent for me to know if
> this is possible...I need to give an estimate to a potential client...I'm
> not asking for code or how to do it, just to know if it's possible and to
> point me in the right direction.
>
> The subject says it all...I have (by now) a pretty decent amount of
> experience with ASP 2.0 and SQL 7.0 but I have a potential client whose
> database is Paradox and I need to know if ASP can be used to access a
> Paradox database and is there a good book on this? Or can I use my ASP
> knowledge and just pick up a Paradox book to learn the equivalent
> expressions, schema, etc. corresponding to what I know in T-SQL?
>
> Thanks,
>
> Ben
>
---
FREE WEB DEVELOPMENT CODE, CONTENT, AND INSIGHTS
IN YOUR INBOX!
Get the latest and best HTML, XML, and JavaScript tips, tools, and
developments from the experts. Sign up for one or more of EarthWeb's
FREE IT newsletters at http://www.earthweb.com today!
---
You are currently subscribed to asp_databases as: $subst('Recip.EmailAddr')
To unsubscribe send a blank email to leave-asp_databases-$subst('Recip.MemberIDChar')@p2p.wrox.com
Message #4 by "Ben Lew" <formula1@o...> on Sat, 16 Dec 2000 11:29:42 -0500
|
|
Does anyone know if Paradox uses TSQL or any other flavor/variation of SQL
langauge?
Thanks,
Ben
-----Original Message-----
From: StephenB [mailto:stephen@v...]
Sent: Saturday, December 16, 2000 5:43 AM
To: ASP Databases
Subject: [asp_databases] Re: Urgent - Can I use ASP to access Paradox
database and are there any books on this?
Yes you can. There will be an ODBC driver which you use with ASP in the
same way as the ODBC driver for Access or any other database. Whether this
would work well enough for your purposes you will have to test.
Stephen
"Ben Lew" <formula1@o...> wrote in message
news:25891@a..._databases...
>
>
> I posted this before and no answer, it's pretty urgent for me to know if
> this is possible...I need to give an estimate to a potential client...I'm
> not asking for code or how to do it, just to know if it's possible and to
> point me in the right direction.
>
> The subject says it all...I have (by now) a pretty decent amount of
> experience with ASP 2.0 and SQL 7.0 but I have a potential client whose
> database is Paradox and I need to know if ASP can be used to access a
> Paradox database and is there a good book on this? Or can I use my ASP
> knowledge and just pick up a Paradox book to learn the equivalent
> expressions, schema, etc. corresponding to what I know in T-SQL?
>
> Thanks,
>
> Ben
>
---
FREE WEB DEVELOPMENT CODE, CONTENT, AND INSIGHTS
IN YOUR INBOX!
Get the latest and best HTML, XML, and JavaScript tips, tools, and
developments from the experts. Sign up for one or more of EarthWeb's
FREE IT newsletters at http://www.earthweb.com today!
---
You are currently subscribed to asp_databases as: $subst('Recip.EmailAddr')
To unsubscribe send a blank email to leave-asp_databases-$subst('Recip.MemberIDChar')@p2p.wrox.com
Message #5 by "Dallas Martin" <dmartin@z...> on Sat, 16 Dec 2000 14:41:50 -0500
|
|
It uses standard SQL, but like all the rdbms, it has its own extensions.
If you DELPHI or PARADOX installed on your machine, why don't
you use the help?
Also goto http://community.borland.com/
Select DELHI, select SEARCH from leftside bar, search on PARADOX.
I found over 203 topics.
Good Luck,
Dallas Martin
----- Original Message -----
From: "Ben Lew" <formula1@o...>
To: "ASP Databases" <asp_databases@p...>
Sent: Saturday, December 16, 2000 11:29 AM
Subject: [asp_databases] Re: Urgent - Can I use ASP to access Paradox
database and are there any books on this?
> Does anyone know if Paradox uses TSQL or any other flavor/variation of SQL
> langauge?
>
> Thanks,
>
> Ben
>
> -----Original Message-----
> From: StephenB [mailto:stephen@v...]
> Sent: Saturday, December 16, 2000 5:43 AM
> To: ASP Databases
> Subject: [asp_databases] Re: Urgent - Can I use ASP to access Paradox
> database and are there any books on this?
>
>
> Yes you can. There will be an ODBC driver which you use with ASP in the
> same way as the ODBC driver for Access or any other database. Whether
this
> would work well enough for your purposes you will have to test.
>
> Stephen
>
> "Ben Lew" <formula1@o...> wrote in message
> news:25891@a..._databases...
> >
> >
> > I posted this before and no answer, it's pretty urgent for me to know if
> > this is possible...I need to give an estimate to a potential
client...I'm
> > not asking for code or how to do it, just to know if it's possible and
to
> > point me in the right direction.
> >
> > The subject says it all...I have (by now) a pretty decent amount of
> > experience with ASP 2.0 and SQL 7.0 but I have a potential client whose
> > database is Paradox and I need to know if ASP can be used to access a
> > Paradox database and is there a good book on this? Or can I use my ASP
> > knowledge and just pick up a Paradox book to learn the equivalent
> > expressions, schema, etc. corresponding to what I know in T-SQL?
> >
> > Thanks,
> >
> > Ben
> >
>
---
FREE WEB DEVELOPMENT CODE, CONTENT, AND INSIGHTS
IN YOUR INBOX!
Get the latest and best HTML, XML, and JavaScript tips, tools, and
developments from the experts. Sign up for one or more of EarthWeb's
FREE IT newsletters at http://www.earthweb.com today!
---
You are currently subscribed to asp_databases as: $subst('Recip.EmailAddr')
To unsubscribe send a blank email to leave-asp_databases-$subst('Recip.MemberIDChar')@p2p.wrox.com
Message #6 by "Ben Lew" <formula1@o...> on Sat, 16 Dec 2000 20:16:50 -0500
|
|
Thanks for the advice, this helps a lot, unfortunately I don't have Paradox
on my machine though, situation is that I am considering taking on a job
where I need to put a database on the web as the backend for a B2B site
where the client uses Paradox and I need to be able to take their db and put
it onto a SQL 7.0 machine.
Ben
-----Original Message-----
From: Dallas Martin [mailto:dmartin@z...]
Sent: Saturday, December 16, 2000 2:42 PM
To: ASP Databases
Subject: [asp_databases] Re: Urgent - Can I use ASP to access Paradox
database and are there any books on this?
It uses standard SQL, but like all the rdbms, it has its own extensions.
If you DELPHI or PARADOX installed on your machine, why don't
you use the help?
Also goto http://community.borland.com/
Select DELHI, select SEARCH from leftside bar, search on PARADOX.
I found over 203 topics.
Good Luck,
Dallas Martin
----- Original Message -----
From: "Ben Lew" <formula1@o...>
To: "ASP Databases" <asp_databases@p...>
Sent: Saturday, December 16, 2000 11:29 AM
Subject: [asp_databases] Re: Urgent - Can I use ASP to access Paradox
database and are there any books on this?
> Does anyone know if Paradox uses TSQL or any other flavor/variation of SQL
> langauge?
>
> Thanks,
>
> Ben
>
> -----Original Message-----
> From: StephenB [mailto:stephen@v...]
> Sent: Saturday, December 16, 2000 5:43 AM
> To: ASP Databases
> Subject: [asp_databases] Re: Urgent - Can I use ASP to access Paradox
> database and are there any books on this?
>
>
> Yes you can. There will be an ODBC driver which you use with ASP in the
> same way as the ODBC driver for Access or any other database. Whether
this
> would work well enough for your purposes you will have to test.
>
> Stephen
>
> "Ben Lew" <formula1@o...> wrote in message
> news:25891@a..._databases...
> >
> >
> > I posted this before and no answer, it's pretty urgent for me to know if
> > this is possible...I need to give an estimate to a potential
client...I'm
> > not asking for code or how to do it, just to know if it's possible and
to
> > point me in the right direction.
> >
> > The subject says it all...I have (by now) a pretty decent amount of
> > experience with ASP 2.0 and SQL 7.0 but I have a potential client whose
> > database is Paradox and I need to know if ASP can be used to access a
> > Paradox database and is there a good book on this? Or can I use my ASP
> > knowledge and just pick up a Paradox book to learn the equivalent
> > expressions, schema, etc. corresponding to what I know in T-SQL?
> >
> > Thanks,
> >
> > Ben
> >
>
---
NEED TECHNICAL TIPS, TOOLS, AND INSIGHTS? Is FREE okay?
Visit EarthWeb for the latest in IT Management, Software Development,
Web Development, Networking & Communications, and Hardware & Systems.
Click on http://www.earthweb.com for FREE articles, tutorials,
and discussions from the experts.
---
You are currently subscribed to asp_databases as: $subst('Recip.EmailAddr')
To unsubscribe send a blank email to leave-asp_databases-$subst('Recip.MemberIDChar')@p2p.wrox.com
|
|
 |