|
 |
asp_web_howto thread: How many rows can be insert into MS Access
Message #1 by "Anthony Delcy" <DELCYAN@l...> on Thu, 29 Mar 2001 10:04:28 -0500
|
|
Hi,
I know you guys don't deal with MS Access but I am giving a try anyway.
How many entries can be inserted into MS Access 97. Ex: lines and rows of
data.
My guest would be about 25 000 rows to 30 000 rows. I maybe wrong. Does
someone happens to know this please let me know.
Thank you
Anthony
>>> Don Eilenberger <done@b...> 03/29 9:17 AM >>>
"Daniel O'Dorisio" wrote in reply to my question on *yuck* FP..
>FP and Visual InterDev will work together.
Haven't tried VID..
>what i did was after the other site was created in fp (code was nice and
>ugly:) www.yourfriendinflowers.com) i used visual Interdev to open the
web
>and add my own page, similar to what you are talking about
Close but not quite - if I understand you - you've created a page
in VID and added it to the FP generated web?
>(www.yourfriendinflowers.com/wedview.asp?book=3Dtwsg) all the data on
this
>page(image url) are drawn from a access db (couldnt use sql, no budget
for
>it) however, i just ftp all my images to the dir that the db says they
are
>located in. but i guess the difference could be that i created my .asp in
>vid.
Yup.
>
>what kinds of errors do you get?
The images don't display. You see the placeholder for them but
they don't load in the users browser.
Dumb isn't it?
>Daniel
Thanks!
Don
Message #2 by "O'Hara, Elliott M" <EMOHARA@k...> on Thu, 29 Mar 2001 11:49:33 -0500
|
|
2 gigs
however many rose you can squeeze in...
I wouldnt' recommend it though
use SQL or MYSQL
-----Original Message-----
From: Anthony Delcy [mailto:DELCYAN@l...]
Sent: Thursday, March 29, 2001 10:04 AM
To: ASP Web HowTo
Subject: [asp_web_howto] How many rows can be insert into MS Access
Hi,
I know you guys don't deal with MS Access but I am giving a try anyway.
How many entries can be inserted into MS Access 97. Ex: lines and rows of
data.
My guest would be about 25 000 rows to 30 000 rows. I maybe wrong. Does
someone happens to know this please let me know.
Thank you
Anthony
>>> Don Eilenberger <done@b...> 03/29 9:17 AM >>>
"Daniel O'Dorisio" wrote in reply to my question on *yuck* FP..
>FP and Visual InterDev will work together.
Haven't tried VID..
>what i did was after the other site was created in fp (code was nice and
>ugly:) www.yourfriendinflowers.com) i used visual Interdev to open the web
>and add my own page, similar to what you are talking about
Close but not quite - if I understand you - you've created a page
in VID and added it to the FP generated web?
>(www.yourfriendinflowers.com/wedview.asp?book=twsg) all the data on this
>page(image url) are drawn from a access db (couldnt use sql, no budget for
>it) however, i just ftp all my images to the dir that the db says they are
>located in. but i guess the difference could be that i created my .asp in
>vid.
Yup.
>
>what kinds of errors do you get?
The images don't display. You see the placeholder for them but
they don't load in the users browser.
Dumb isn't it?
>Daniel
Thanks!
Don
Message #3 by "Daniel O'Dorisio" <dodorisio@h...> on Thu, 29 Mar 2001 12:01:26 -0500
|
|
so you can use mysql with asp?
i am kinda interested in linux, but i know windows...somewhat
how would i go about accessing mysql from an asp?
Daniel
-----Original Message-----
From: O'Hara, Elliott M [mailto:EMOHARA@k...]
Sent: Thursday, March 29, 2001 11:50 AM
To: ASP Web HowTo
Subject: [asp_web_howto] RE: How many rows can be insert into MS Access
2 gigs
however many rose you can squeeze in...
I wouldnt' recommend it though
use SQL or MYSQL
-----Original Message-----
From: Anthony Delcy [mailto:DELCYAN@l...]
Sent: Thursday, March 29, 2001 10:04 AM
To: ASP Web HowTo
Subject: [asp_web_howto] How many rows can be insert into MS Access
Hi,
I know you guys don't deal with MS Access but I am giving a try anyway.
How many entries can be inserted into MS Access 97. Ex: lines and rows of
data.
My guest would be about 25 000 rows to 30 000 rows. I maybe wrong. Does
someone happens to know this please let me know.
Thank you
Anthony
>>> Don Eilenberger <done@b...> 03/29 9:17 AM >>>
"Daniel O'Dorisio" wrote in reply to my question on *yuck* FP..
>FP and Visual InterDev will work together.
Haven't tried VID..
>what i did was after the other site was created in fp (code was nice and
>ugly:) www.yourfriendinflowers.com) i used visual Interdev to open the web
>and add my own page, similar to what you are talking about
Close but not quite - if I understand you - you've created a page
in VID and added it to the FP generated web?
>(www.yourfriendinflowers.com/wedview.asp?book=twsg) all the data on this
>page(image url) are drawn from a access db (couldnt use sql, no budget for
>it) however, i just ftp all my images to the dir that the db says they are
>located in. but i guess the difference could be that i created my .asp in
>vid.
Yup.
>
>what kinds of errors do you get?
The images don't display. You see the placeholder for them but
they don't load in the users browser.
Dumb isn't it?
>Daniel
Thanks!
Don
Message #4 by "O'Hara, Elliott M" <EMOHARA@k...> on Thu, 29 Mar 2001 12:03:48 -0500
|
|
rose = rows....
sorry about that
-----Original Message-----
From: O'Hara, Elliott M [mailto:EMOHARA@k...]
Sent: Thursday, March 29, 2001 11:50 AM
To: ASP Web HowTo
Subject: [asp_web_howto] RE: How many rows can be insert into MS Access
2 gigs
however many rose you can squeeze in...
I wouldnt' recommend it though
use SQL or MYSQL
-----Original Message-----
From: Anthony Delcy [mailto:DELCYAN@l...]
Sent: Thursday, March 29, 2001 10:04 AM
To: ASP Web HowTo
Subject: [asp_web_howto] How many rows can be insert into MS Access
Hi,
I know you guys don't deal with MS Access but I am giving a try anyway.
How many entries can be inserted into MS Access 97. Ex: lines and rows of
data.
My guest would be about 25 000 rows to 30 000 rows. I maybe wrong. Does
someone happens to know this please let me know.
Thank you
Anthony
>>> Don Eilenberger <done@b...> 03/29 9:17 AM >>>
"Daniel O'Dorisio" wrote in reply to my question on *yuck* FP..
>FP and Visual InterDev will work together.
Haven't tried VID..
>what i did was after the other site was created in fp (code was nice and
>ugly:) www.yourfriendinflowers.com) i used visual Interdev to open the web
>and add my own page, similar to what you are talking about
Close but not quite - if I understand you - you've created a page
in VID and added it to the FP generated web?
>(www.yourfriendinflowers.com/wedview.asp?book=twsg) all the data on this
>page(image url) are drawn from a access db (couldnt use sql, no budget for
>it) however, i just ftp all my images to the dir that the db says they are
>located in. but i guess the difference could be that i created my .asp in
>vid.
Yup.
>
>what kinds of errors do you get?
The images don't display. You see the placeholder for them but
they don't load in the users browser.
Dumb isn't it?
>Daniel
Thanks!
Don
Message #5 by "Ken Schaefer" <ken@a...> on Fri, 30 Mar 2001 13:25:02 +1000
|
|
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
: so you can use mysql with asp?
:
: i am kinda interested in linux, but i know windows...somewhat
:
: how would i go about accessing mysql from an asp?
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
a) Install mySQL
b) Install the ODBC driver for mySQL
c) Create connection string using OLEDB Provider from ODBC Drivers
d) Use ADO to open a connection based on the above
NOTE: If you can find a native OLEDB Provider for mySQL that would probably
be better, but I don't that the mySQL people see that as a priority.
Cheers
Ken
Message #6 by "O'Hara, Elliott M" <EMOHARA@k...> on Thu, 29 Mar 2001 12:49:44 -0500
|
|
never used it myself.. I happen to work for a company that spend money on
everything but my paycheck...
I know there are people in here that use it, and from what I've heard its
pretty much the same as SQL
-----Original Message-----
From: O'Hara, Elliott M [mailto:EMOHARA@k...]
Sent: Thursday, March 29, 2001 12:04 PM
To: ASP Web HowTo
Subject: [asp_web_howto] RE: How many rows can be insert into MS Access
rose = rows....
sorry about that
-----Original Message-----
From: O'Hara, Elliott M [mailto:EMOHARA@k...]
Sent: Thursday, March 29, 2001 11:50 AM
To: ASP Web HowTo
Subject: [asp_web_howto] RE: How many rows can be insert into MS Access
2 gigs
however many rose you can squeeze in...
I wouldnt' recommend it though
use SQL or MYSQL
-----Original Message-----
From: Anthony Delcy [mailto:DELCYAN@l...]
Sent: Thursday, March 29, 2001 10:04 AM
To: ASP Web HowTo
Subject: [asp_web_howto] How many rows can be insert into MS Access
Hi,
I know you guys don't deal with MS Access but I am giving a try anyway.
How many entries can be inserted into MS Access 97. Ex: lines and rows of
data.
My guest would be about 25 000 rows to 30 000 rows. I maybe wrong. Does
someone happens to know this please let me know.
Thank you
Anthony
>>> Don Eilenberger <done@b...> 03/29 9:17 AM >>>
"Daniel O'Dorisio" wrote in reply to my question on *yuck* FP..
>FP and Visual InterDev will work together.
Haven't tried VID..
>what i did was after the other site was created in fp (code was nice and
>ugly:) www.yourfriendinflowers.com) i used visual Interdev to open the web
>and add my own page, similar to what you are talking about
Close but not quite - if I understand you - you've created a page
in VID and added it to the FP generated web?
>(www.yourfriendinflowers.com/wedview.asp?book=twsg) all the data on this
>page(image url) are drawn from a access db (couldnt use sql, no budget for
>it) however, i just ftp all my images to the dir that the db says they are
>located in. but i guess the difference could be that i created my .asp in
>vid.
Yup.
>
>what kinds of errors do you get?
The images don't display. You see the placeholder for them but
they don't load in the users browser.
Dumb isn't it?
>Daniel
Thanks!
Don
---
SoftArtisans helps developers build robust, scalable Web applications!
Excel Web reports, charts: http://www.softartisans.com/excelwriter.html
File uploads: http://www.softartisans.com/saf.html
Transactional file management: http://www.softartisans.com/saf1.html
Scalability: http://www.softartisans.com/saxsession.html
ASPstudio value pack: http://www.softartisans.com/aspstudiosuite.html
emohara@k...
$subst('Email.Unsub')
Message #7 by "Daniel O'Dorisio" <dodorisio@h...> on Fri, 30 Mar 2001 07:48:03 -0500
|
|
which do you recommend, mysql or mssql? php or asp? win2k or linux/unix?
im kinda stuck wondering which way to turn.. linux/unix web/networking or
win2k web/networking
Just whatever you think(i wont hold you accountable for any bad decision i
make:))
Daniel
-----Original Message-----
From: Ken Schaefer [mailto:ken@a...]
Sent: Thursday, March 29, 2001 10:25 PM
To: ASP Web HowTo
Subject: [asp_web_howto] RE: How many rows can be insert into MS Access
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
: so you can use mysql with asp?
:
: i am kinda interested in linux, but i know windows...somewhat
:
: how would i go about accessing mysql from an asp?
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
a) Install mySQL
b) Install the ODBC driver for mySQL
c) Create connection string using OLEDB Provider from ODBC Drivers
d) Use ADO to open a connection based on the above
NOTE: If you can find a native OLEDB Provider for mySQL that would probably
be better, but I don't that the mySQL people see that as a priority.
Cheers
Ken
Message #8 by "Alex Shiell, ITS, EC, SE" <alex.shiell@s...> on Fri, 30 Mar 2001 14:57:06 +0100
|
|
Well as this is an ASP list, I imagine we all swing the Microsoft way here.
SQL server can be very expensive though, so ultimately it depends on
budgetary constraints.
If you want to work for big companies with lots of money to spend, learn the
Microsoft stuff as that is invariably what they use (although of course
Oracle is probably the prefered database platform where the budgets are
really big). if you want to work for yourself or for small start-ups, go
the linux way.
-----Original Message-----
From: Daniel O'Dorisio [mailto:dodorisio@h...]
Sent: Friday, March 30, 2001 1:48 PM
To: ASP Web HowTo
Subject: [asp_web_howto] RE: How many rows can be insert into MS Access
which do you recommend, mysql or mssql? php or asp? win2k or linux/unix?
im kinda stuck wondering which way to turn.. linux/unix web/networking or
win2k web/networking
Just whatever you think(i wont hold you accountable for any bad decision i
make:))
Daniel
-----Original Message-----
From: Ken Schaefer [mailto:ken@a...]
Sent: Thursday, March 29, 2001 10:25 PM
To: ASP Web HowTo
Subject: [asp_web_howto] RE: How many rows can be insert into MS Access
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
: so you can use mysql with asp?
:
: i am kinda interested in linux, but i know windows...somewhat
:
: how would i go about accessing mysql from an asp?
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
a) Install mySQL
b) Install the ODBC driver for mySQL
c) Create connection string using OLEDB Provider from ODBC Drivers
d) Use ADO to open a connection based on the above
NOTE: If you can find a native OLEDB Provider for mySQL that would probably
be better, but I don't that the mySQL people see that as a priority.
Cheers
Ken
Message #9 by "O'Hara, Elliott M" <EMOHARA@k...> on Fri, 30 Mar 2001 08:46:43 -0500
|
|
definatly MSSQL and Win2K
I might be a little biased here (MSCE and all)
-----Original Message-----
From: Daniel O'Dorisio [mailto:dodorisio@h...]
Sent: Friday, March 30, 2001 7:48 AM
To: ASP Web HowTo
Subject: [asp_web_howto] RE: How many rows can be insert into MS Access
which do you recommend, mysql or mssql? php or asp? win2k or linux/unix?
im kinda stuck wondering which way to turn.. linux/unix web/networking or
win2k web/networking
Just whatever you think(i wont hold you accountable for any bad decision i
make:))
Daniel
-----Original Message-----
From: Ken Schaefer [mailto:ken@a...]
Sent: Thursday, March 29, 2001 10:25 PM
To: ASP Web HowTo
Subject: [asp_web_howto] RE: How many rows can be insert into MS Access
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
: so you can use mysql with asp?
:
: i am kinda interested in linux, but i know windows...somewhat
:
: how would i go about accessing mysql from an asp?
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
a) Install mySQL
b) Install the ODBC driver for mySQL
c) Create connection string using OLEDB Provider from ODBC Drivers
d) Use ADO to open a connection based on the above
NOTE: If you can find a native OLEDB Provider for mySQL that would probably
be better, but I don't that the mySQL people see that as a priority.
Cheers
Ken
Message #10 by "Daniel O'Dorisio" <dodorisio@h...> on Fri, 30 Mar 2001 08:59:26 -0500
|
|
yeah i kinda figured it would swing microsoft's direction...:-)
but what about the Linux servers that NEVER have to re-boot... i kinda like
that:-)
i am more into microsoft then linux, since it is all arround me... and it
breaks alot.. .and i am cheap labour for my aunt.. dad... dads friends :-)
(im 15) and also.. i like the GUI in ms.. but i like the stability of
linux... ill probally end up ms with a little on linux. anyway.. thanks for
your imput.. that helps
Daniel
-----Original Message-----
From: Alex Shiell, ITS, EC, SE [mailto:alex.shiell@s...]
Sent: Friday, March 30, 2001 8:57 AM
To: ASP Web HowTo
Subject: [asp_web_howto] RE: How many rows can be insert into MS Acces s
Well as this is an ASP list, I imagine we all swing the Microsoft way here.
SQL server can be very expensive though, so ultimately it depends on
budgetary constraints.
If you want to work for big companies with lots of money to spend, learn the
Microsoft stuff as that is invariably what they use (although of course
Oracle is probably the prefered database platform where the budgets are
really big). if you want to work for yourself or for small start-ups, go
the linux way.
-----Original Message-----
From: Daniel O'Dorisio [mailto:dodorisio@h...]
Sent: Friday, March 30, 2001 1:48 PM
To: ASP Web HowTo
Subject: [asp_web_howto] RE: How many rows can be insert into MS Access
which do you recommend, mysql or mssql? php or asp? win2k or linux/unix?
im kinda stuck wondering which way to turn.. linux/unix web/networking or
win2k web/networking
Just whatever you think(i wont hold you accountable for any bad decision i
make:))
Daniel
-----Original Message-----
From: Ken Schaefer [mailto:ken@a...]
Sent: Thursday, March 29, 2001 10:25 PM
To: ASP Web HowTo
Subject: [asp_web_howto] RE: How many rows can be insert into MS Access
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
: so you can use mysql with asp?
:
: i am kinda interested in linux, but i know windows...somewhat
:
: how would i go about accessing mysql from an asp?
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
a) Install mySQL
b) Install the ODBC driver for mySQL
c) Create connection string using OLEDB Provider from ODBC Drivers
d) Use ADO to open a connection based on the above
NOTE: If you can find a native OLEDB Provider for mySQL that would probably
be better, but I don't that the mySQL people see that as a priority.
Cheers
Ken
Message #11 by "Alex Shiell, ITS, EC, SE" <alex.shiell@s...> on Fri, 30 Mar 2001 15:45:16 +0100
|
|
You've got to make up your mind whether you want to be a developer or a
support analyst... sure we all do a bit of both, and understand issues on
both sides, but everyone's got their forte. If you want to be a developer
then concentrate on learning how to write good efficient code, and leave
things like operating system stability and server resiliency to the support
guys to worry about!
-----Original Message-----
From: Daniel O'Dorisio [mailto:dodorisio@h...]
Sent: Friday, March 30, 2001 2:59 PM
To: ASP Web HowTo
Subject: [asp_web_howto] RE: How many rows can be insert into MS Acces s
yeah i kinda figured it would swing microsoft's direction...:-)
but what about the Linux servers that NEVER have to re-boot... i kinda like
that:-)
i am more into microsoft then linux, since it is all arround me... and it
breaks alot.. .and i am cheap labour for my aunt.. dad... dads friends :-)
(im 15) and also.. i like the GUI in ms.. but i like the stability of
linux... ill probally end up ms with a little on linux. anyway.. thanks for
your imput.. that helps
Daniel
-----Original Message-----
From: Alex Shiell, ITS, EC, SE [mailto:alex.shiell@s...]
Sent: Friday, March 30, 2001 8:57 AM
To: ASP Web HowTo
Subject: [asp_web_howto] RE: How many rows can be insert into MS Acces s
Well as this is an ASP list, I imagine we all swing the Microsoft way here.
SQL server can be very expensive though, so ultimately it depends on
budgetary constraints.
If you want to work for big companies with lots of money to spend, learn the
Microsoft stuff as that is invariably what they use (although of course
Oracle is probably the prefered database platform where the budgets are
really big). if you want to work for yourself or for small start-ups, go
the linux way.
-----Original Message-----
From: Daniel O'Dorisio [mailto:dodorisio@h...]
Sent: Friday, March 30, 2001 1:48 PM
To: ASP Web HowTo
Subject: [asp_web_howto] RE: How many rows can be insert into MS Access
which do you recommend, mysql or mssql? php or asp? win2k or linux/unix?
im kinda stuck wondering which way to turn.. linux/unix web/networking or
win2k web/networking
Just whatever you think(i wont hold you accountable for any bad decision i
make:))
Daniel
-----Original Message-----
From: Ken Schaefer [mailto:ken@a...]
Sent: Thursday, March 29, 2001 10:25 PM
To: ASP Web HowTo
Subject: [asp_web_howto] RE: How many rows can be insert into MS Access
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
: so you can use mysql with asp?
:
: i am kinda interested in linux, but i know windows...somewhat
:
: how would i go about accessing mysql from an asp?
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
a) Install mySQL
b) Install the ODBC driver for mySQL
c) Create connection string using OLEDB Provider from ODBC Drivers
d) Use ADO to open a connection based on the above
NOTE: If you can find a native OLEDB Provider for mySQL that would probably
be better, but I don't that the mySQL people see that as a priority.
Cheers
Ken
________________________________________________________________________
Scottish Enterprise Network
http://www.scottish-enterprise.com
Message #12 by "Daniel O'Dorisio" <dodorisio@h...> on Fri, 30 Mar 2001 09:49:51 -0500
|
|
very true... i am trying to decide that as well :-) decisions decisions
decisions:-)
i like networking.. but i also like coding... so im kinda stuck....
i am going through a book for MCSE 70-216..(just to clear up my head on DNS,
DHCP, NAT, and all that stuff) and i get to help configure a router next
week.. so i guess ill get a very mild taste of networking.... ill come up
with something soon.. and head straight for that:-)
Daniel
-----Original Message-----
From: Alex Shiell, ITS, EC, SE [mailto:alex.shiell@s...]
Sent: Friday, March 30, 2001 9:45 AM
To: ASP Web HowTo
Subject: [asp_web_howto] RE: How many rows can be insert into MS Acces s
You've got to make up your mind whether you want to be a developer or a
support analyst... sure we all do a bit of both, and understand issues on
both sides, but everyone's got their forte. If you want to be a developer
then concentrate on learning how to write good efficient code, and leave
things like operating system stability and server resiliency to the support
guys to worry about!
-----Original Message-----
From: Daniel O'Dorisio [mailto:dodorisio@h...]
Sent: Friday, March 30, 2001 2:59 PM
To: ASP Web HowTo
Subject: [asp_web_howto] RE: How many rows can be insert into MS Acces s
yeah i kinda figured it would swing microsoft's direction...:-)
but what about the Linux servers that NEVER have to re-boot... i kinda like
that:-)
i am more into microsoft then linux, since it is all arround me... and it
breaks alot.. .and i am cheap labour for my aunt.. dad... dads friends :-)
(im 15) and also.. i like the GUI in ms.. but i like the stability of
linux... ill probally end up ms with a little on linux. anyway.. thanks for
your imput.. that helps
Daniel
-----Original Message-----
From: Alex Shiell, ITS, EC, SE [mailto:alex.shiell@s...]
Sent: Friday, March 30, 2001 8:57 AM
To: ASP Web HowTo
Subject: [asp_web_howto] RE: How many rows can be insert into MS Acces s
Well as this is an ASP list, I imagine we all swing the Microsoft way here.
SQL server can be very expensive though, so ultimately it depends on
budgetary constraints.
If you want to work for big companies with lots of money to spend, learn the
Microsoft stuff as that is invariably what they use (although of course
Oracle is probably the prefered database platform where the budgets are
really big). if you want to work for yourself or for small start-ups, go
the linux way.
-----Original Message-----
From: Daniel O'Dorisio [mailto:dodorisio@h...]
Sent: Friday, March 30, 2001 1:48 PM
To: ASP Web HowTo
Subject: [asp_web_howto] RE: How many rows can be insert into MS Access
which do you recommend, mysql or mssql? php or asp? win2k or linux/unix?
im kinda stuck wondering which way to turn.. linux/unix web/networking or
win2k web/networking
Just whatever you think(i wont hold you accountable for any bad decision i
make:))
Daniel
-----Original Message-----
From: Ken Schaefer [mailto:ken@a...]
Sent: Thursday, March 29, 2001 10:25 PM
To: ASP Web HowTo
Subject: [asp_web_howto] RE: How many rows can be insert into MS Access
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
: so you can use mysql with asp?
:
: i am kinda interested in linux, but i know windows...somewhat
:
: how would i go about accessing mysql from an asp?
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
a) Install mySQL
b) Install the ODBC driver for mySQL
c) Create connection string using OLEDB Provider from ODBC Drivers
d) Use ADO to open a connection based on the above
NOTE: If you can find a native OLEDB Provider for mySQL that would probably
be better, but I don't that the mySQL people see that as a priority.
Cheers
Ken
Message #13 by "Alex Shiell, ITS, EC, SE" <alex.shiell@s...> on Fri, 30 Mar 2001 16:38:09 +0100
|
|
Depends what kind of brain you've got... if you're a "techie" with an
analytical brain go for networking, if you thrive on creativity go for
development...
I think we've lost the original conversation thread by a long way by now!
-----Original Message-----
From: Daniel O'Dorisio [mailto:dodorisio@h...]
Sent: Friday, March 30, 2001 3:50 PM
To: ASP Web HowTo
Subject: [asp_web_howto] RE: How many rows can be insert into MS Acces s
very true... i am trying to decide that as well :-) decisions decisions
decisions:-)
i like networking.. but i also like coding... so im kinda stuck....
i am going through a book for MCSE 70-216..(just to clear up my head on DNS,
DHCP, NAT, and all that stuff) and i get to help configure a router next
week.. so i guess ill get a very mild taste of networking.... ill come up
with something soon.. and head straight for that:-)
Daniel
-----Original Message-----
From: Alex Shiell, ITS, EC, SE [mailto:alex.shiell@s...]
Sent: Friday, March 30, 2001 9:45 AM
To: ASP Web HowTo
Subject: [asp_web_howto] RE: How many rows can be insert into MS Acces s
You've got to make up your mind whether you want to be a developer or a
support analyst... sure we all do a bit of both, and understand issues on
both sides, but everyone's got their forte. If you want to be a developer
then concentrate on learning how to write good efficient code, and leave
things like operating system stability and server resiliency to the support
guys to worry about!
-----Original Message-----
From: Daniel O'Dorisio [mailto:dodorisio@h...]
Sent: Friday, March 30, 2001 2:59 PM
To: ASP Web HowTo
Subject: [asp_web_howto] RE: How many rows can be insert into MS Acces s
yeah i kinda figured it would swing microsoft's direction...:-)
but what about the Linux servers that NEVER have to re-boot... i kinda like
that:-)
i am more into microsoft then linux, since it is all arround me... and it
breaks alot.. .and i am cheap labour for my aunt.. dad... dads friends :-)
(im 15) and also.. i like the GUI in ms.. but i like the stability of
linux... ill probally end up ms with a little on linux. anyway.. thanks for
your imput.. that helps
Daniel
-----Original Message-----
From: Alex Shiell, ITS, EC, SE [mailto:alex.shiell@s...]
Sent: Friday, March 30, 2001 8:57 AM
To: ASP Web HowTo
Subject: [asp_web_howto] RE: How many rows can be insert into MS Acces s
Well as this is an ASP list, I imagine we all swing the Microsoft way here.
SQL server can be very expensive though, so ultimately it depends on
budgetary constraints.
If you want to work for big companies with lots of money to spend, learn the
Microsoft stuff as that is invariably what they use (although of course
Oracle is probably the prefered database platform where the budgets are
really big). if you want to work for yourself or for small start-ups, go
the linux way.
-----Original Message-----
From: Daniel O'Dorisio [mailto:dodorisio@h...]
Sent: Friday, March 30, 2001 1:48 PM
To: ASP Web HowTo
Subject: [asp_web_howto] RE: How many rows can be insert into MS Access
which do you recommend, mysql or mssql? php or asp? win2k or linux/unix?
im kinda stuck wondering which way to turn.. linux/unix web/networking or
win2k web/networking
Just whatever you think(i wont hold you accountable for any bad decision i
make:))
Daniel
-----Original Message-----
From: Ken Schaefer [mailto:ken@a...]
Sent: Thursday, March 29, 2001 10:25 PM
To: ASP Web HowTo
Subject: [asp_web_howto] RE: How many rows can be insert into MS Access
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
: so you can use mysql with asp?
:
: i am kinda interested in linux, but i know windows...somewhat
:
: how would i go about accessing mysql from an asp?
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
a) Install mySQL
b) Install the ODBC driver for mySQL
c) Create connection string using OLEDB Provider from ODBC Drivers
d) Use ADO to open a connection based on the above
NOTE: If you can find a native OLEDB Provider for mySQL that would probably
be better, but I don't that the mySQL people see that as a priority.
Cheers
Ken
________________________________________________________________________
Scottish Enterprise Network
http://www.scottish-enterprise.com
Message #14 by "Daniel O'Dorisio" <dodorisio@h...> on Fri, 30 Mar 2001 11:00:54 -0500
|
|
LOOONNNGG lost but thanks:-)
Daniel
-----Original Message-----
From: Alex Shiell, ITS, EC, SE [mailto:alex.shiell@s...]
Sent: Friday, March 30, 2001 10:38 AM
To: ASP Web HowTo
Subject: [asp_web_howto] RE: How many rows can be insert into MS Acces s
Depends what kind of brain you've got... if you're a "techie" with an
analytical brain go for networking, if you thrive on creativity go for
development...
I think we've lost the original conversation thread by a long way by now!
-----Original Message-----
From: Daniel O'Dorisio [mailto:dodorisio@h...]
Sent: Friday, March 30, 2001 3:50 PM
To: ASP Web HowTo
Subject: [asp_web_howto] RE: How many rows can be insert into MS Acces s
very true... i am trying to decide that as well :-) decisions decisions
decisions:-)
i like networking.. but i also like coding... so im kinda stuck....
i am going through a book for MCSE 70-216..(just to clear up my head on DNS,
DHCP, NAT, and all that stuff) and i get to help configure a router next
week.. so i guess ill get a very mild taste of networking.... ill come up
with something soon.. and head straight for that:-)
Daniel
-----Original Message-----
From: Alex Shiell, ITS, EC, SE [mailto:alex.shiell@s...]
Sent: Friday, March 30, 2001 9:45 AM
To: ASP Web HowTo
Subject: [asp_web_howto] RE: How many rows can be insert into MS Acces s
You've got to make up your mind whether you want to be a developer or a
support analyst... sure we all do a bit of both, and understand issues on
both sides, but everyone's got their forte. If you want to be a developer
then concentrate on learning how to write good efficient code, and leave
things like operating system stability and server resiliency to the support
guys to worry about!
-----Original Message-----
From: Daniel O'Dorisio [mailto:dodorisio@h...]
Sent: Friday, March 30, 2001 2:59 PM
To: ASP Web HowTo
Subject: [asp_web_howto] RE: How many rows can be insert into MS Acces s
yeah i kinda figured it would swing microsoft's direction...:-)
but what about the Linux servers that NEVER have to re-boot... i kinda like
that:-)
i am more into microsoft then linux, since it is all arround me... and it
breaks alot.. .and i am cheap labour for my aunt.. dad... dads friends :-)
(im 15) and also.. i like the GUI in ms.. but i like the stability of
linux... ill probally end up ms with a little on linux. anyway.. thanks for
your imput.. that helps
Daniel
-----Original Message-----
From: Alex Shiell, ITS, EC, SE [mailto:alex.shiell@s...]
Sent: Friday, March 30, 2001 8:57 AM
To: ASP Web HowTo
Subject: [asp_web_howto] RE: How many rows can be insert into MS Acces s
Well as this is an ASP list, I imagine we all swing the Microsoft way here.
SQL server can be very expensive though, so ultimately it depends on
budgetary constraints.
If you want to work for big companies with lots of money to spend, learn the
Microsoft stuff as that is invariably what they use (although of course
Oracle is probably the prefered database platform where the budgets are
really big). if you want to work for yourself or for small start-ups, go
the linux way.
-----Original Message-----
From: Daniel O'Dorisio [mailto:dodorisio@h...]
Sent: Friday, March 30, 2001 1:48 PM
To: ASP Web HowTo
Subject: [asp_web_howto] RE: How many rows can be insert into MS Access
which do you recommend, mysql or mssql? php or asp? win2k or linux/unix?
im kinda stuck wondering which way to turn.. linux/unix web/networking or
win2k web/networking
Just whatever you think(i wont hold you accountable for any bad decision i
make:))
Daniel
-----Original Message-----
From: Ken Schaefer [mailto:ken@a...]
Sent: Thursday, March 29, 2001 10:25 PM
To: ASP Web HowTo
Subject: [asp_web_howto] RE: How many rows can be insert into MS Access
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
: so you can use mysql with asp?
:
: i am kinda interested in linux, but i know windows...somewhat
:
: how would i go about accessing mysql from an asp?
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
a) Install mySQL
b) Install the ODBC driver for mySQL
c) Create connection string using OLEDB Provider from ODBC Drivers
d) Use ADO to open a connection based on the above
NOTE: If you can find a native OLEDB Provider for mySQL that would probably
be better, but I don't that the mySQL people see that as a priority.
Cheers
Ken
________________________________________________________________________
Scottish Enterprise Network
http://www.scottish-enterprise.com
---
SoftArtisans helps developers build robust, scalable Web applications!
Excel Web reports, charts: http://www.softartisans.com/excelwriter.html
File uploads: http://www.softartisans.com/saf.html
Transactional file management: http://www.softartisans.com/saf1.html
Scalability: http://www.softartisans.com/saxsession.html
ASPstudio value pack: http://www.softartisans.com/aspstudiosuite.html
$subst('Email.Unsub')
|
|
|
View Cart
