|
 |
asp_web_howto thread: ASP and SQL server
Message #1 by Aaron.Mintz@d... on Mon, 30 Apr 2001 11:38:43 -0400
|
|
I have done several sites using ASP and MS Access and using my NT computer
loaded with PWS to be the development environment. I have recently loaded
SQL server 6.5 on my computer so I can try to migrate the access databases
to SQL. I can't seem to set up a SQL database on my computer as the server.
When i enter enterprise mananger to set up a database, it only allows me to
see the networked server locations. How can I set up my computer as a
server?
Thanks,
Aaron
-----Original Message-----
From: Ken Schaefer [mailto:ken@a...]
Sent: Wednesday, April 25, 2001 8:40 PM
To: ASP Web HowTo
Subject: [asp_web_howto] Re: Concurrency control with Access Database
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
: Is it possible to more than 1 person to read/write to the same Access
: database on the web? If not, would Microsoft Transaction Server or Queue
: server help in anyway?
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
http://support.microsoft.com/support/kb/articles/Q176/6/70.ASP
contains a link to download the Jet Locking Whitepaper by Kevin Collins.
Excellent stuff on how Jet handles locking and concurrency.
Cheers
Ken
Message #2 by "O'Hara, Elliott M" <EMOHARA@k...> on Mon, 30 Apr 2001 12:14:02 -0400
|
|
NT workstation or Server
You can't set up SQL server on workstation (only the "tools")
-----Original Message-----
From: Aaron.Mintz@d... [mailto:Aaron.Mintz@d...]
Sent: Monday, April 30, 2001 11:39 AM
To: ASP Web HowTo
Subject: [asp_web_howto] ASP and SQL server
I have done several sites using ASP and MS Access and using my NT computer
loaded with PWS to be the development environment. I have recently loaded
SQL server 6.5 on my computer so I can try to migrate the access databases
to SQL. I can't seem to set up a SQL database on my computer as the server.
When i enter enterprise mananger to set up a database, it only allows me to
see the networked server locations. How can I set up my computer as a
server?
Thanks,
Aaron
-----Original Message-----
From: Ken Schaefer [mailto:ken@a...]
Sent: Wednesday, April 25, 2001 8:40 PM
To: ASP Web HowTo
Subject: [asp_web_howto] Re: Concurrency control with Access Database
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
: Is it possible to more than 1 person to read/write to the same Access
: database on the web? If not, would Microsoft Transaction Server or Queue
: server help in anyway?
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
http://support.microsoft.com/support/kb/articles/Q176/6/70.ASP
contains a link to download the Jet Locking Whitepaper by Kevin Collins.
Excellent stuff on how Jet handles locking and concurrency.
Cheers
Ken
Message #3 by Aaron.Mintz@d... on Mon, 30 Apr 2001 12:36:04 -0400
|
|
it is a workstation. how can i use my computer as a "web server" for
development with a sql database then? is it possible?
-----Original Message-----
From: O'Hara, Elliott M [mailto:EMOHARA@k...]
Sent: Monday, April 30, 2001 12:14 PM
To: ASP Web HowTo
Subject: [asp_web_howto] RE: ASP and SQL server
NT workstation or Server
You can't set up SQL server on workstation (only the "tools")
-----Original Message-----
From: Aaron.Mintz@d... [mailto:Aaron.Mintz@d...]
Sent: Monday, April 30, 2001 11:39 AM
To: ASP Web HowTo
Subject: [asp_web_howto] ASP and SQL server
I have done several sites using ASP and MS Access and using my NT computer
loaded with PWS to be the development environment. I have recently loaded
SQL server 6.5 on my computer so I can try to migrate the access databases
to SQL. I can't seem to set up a SQL database on my computer as the server.
When i enter enterprise mananger to set up a database, it only allows me to
see the networked server locations. How can I set up my computer as a
server?
Thanks,
Aaron
Message #4 by "Morgan, Rob" <Rob.Morgan@o...> on Mon, 30 Apr 2001 12:38:01 -0400
|
|
Just a point. I do have sql7 loaded on Win2kpro.
-----Original Message-----
From: O'Hara, Elliott M [mailto:EMOHARA@k...]
Sent: Monday, April 30, 2001 12:14 PM
To: ASP Web HowTo
Subject: [asp_web_howto] RE: ASP and SQL server
NT workstation or Server
You can't set up SQL server on workstation (only the "tools")
-----Original Message-----
From: Aaron.Mintz@d... [mailto:Aaron.Mintz@d...]
Sent: Monday, April 30, 2001 11:39 AM
To: ASP Web HowTo
Subject: [asp_web_howto] ASP and SQL server
I have done several sites using ASP and MS Access and using my NT computer
loaded with PWS to be the development environment. I have recently loaded
SQL server 6.5 on my computer so I can try to migrate the access databases
to SQL. I can't seem to set up a SQL database on my computer as the server.
When i enter enterprise mananger to set up a database, it only allows me to
see the networked server locations. How can I set up my computer as a
server?
Thanks,
Aaron
Message #5 by "Drew, Ron" <RDrew@B...> on Mon, 30 Apr 2001 12:35:20 -0400
|
|
First, migrating from Access to SQL 6.5 (why not 7.0) will not be easy.
What userid are you signing on to enterprise manager as? SA??
If you can sign on make sure you are not in MASTER, PUBS or initial
installation databases. You want to be on your own database. You may have
to go to the server first and create the database because of space
requirements (not sure a client enterprise manager can do the database, but
it can do the tables once the instance space has been established).
Once the database has been established, go on enterprise manager and create
the table(s).
Then go into access and add a linked table using ODBC to the 6.5 database
picking the table you just created.
Then in access write a query to insert into the 6.5 table selecting from the
access table you want to convert.
Then copy your ASPs to a new name or separate directory and test changing
the connection.
That should do it.
NOTE: biggest problem I ran into is the definition of fields i.e. text
to char/varchar and date/time and currency. So be very careful and do so
upfront designing.
Ron
-----Original Message-----
From: Aaron.Mintz@d... [mailto:Aaron.Mintz@d...]
Sent: Monday, April 30, 2001 11:39 AM
To: ASP Web HowTo
Subject: [asp_web_howto] ASP and SQL server
I have done several sites using ASP and MS Access and using my NT computer
loaded with PWS to be the development environment. I have recently loaded
SQL server 6.5 on my computer so I can try to migrate the access databases
to SQL. I can't seem to set up a SQL database on my computer as the server.
When i enter enterprise mananger to set up a database, it only allows me to
see the networked server locations. How can I set up my computer as a
server?
Thanks,
Aaron
Message #6 by "Daniel O'Dorisio" <dodorisio@h...> on Mon, 30 Apr 2001 12:29:02 -0400
|
|
look into msde it is a desktop version of sql
Daniel
-----Original Message-----
From: Aaron.Mintz@d... [mailto:Aaron.Mintz@d...]
Sent: Monday, April 30, 2001 12:36 PM
To: ASP Web HowTo
Subject: [asp_web_howto] RE: ASP and SQL server
it is a workstation. how can i use my computer as a "web server" for
development with a sql database then? is it possible?
-----Original Message-----
From: O'Hara, Elliott M [mailto:EMOHARA@k...]
Sent: Monday, April 30, 2001 12:14 PM
To: ASP Web HowTo
Subject: [asp_web_howto] RE: ASP and SQL server
NT workstation or Server
You can't set up SQL server on workstation (only the "tools")
-----Original Message-----
From: Aaron.Mintz@d... [mailto:Aaron.Mintz@d...]
Sent: Monday, April 30, 2001 11:39 AM
To: ASP Web HowTo
Subject: [asp_web_howto] ASP and SQL server
I have done several sites using ASP and MS Access and using my NT computer
loaded with PWS to be the development environment. I have recently loaded
SQL server 6.5 on my computer so I can try to migrate the access databases
to SQL. I can't seem to set up a SQL database on my computer as the server.
When i enter enterprise mananger to set up a database, it only allows me to
see the networked server locations. How can I set up my computer as a
server?
Thanks,
Aaron
Message #7 by Aaron.Mintz@d... on Mon, 30 Apr 2001 14:05:41 -0400
|
|
is 7.0 that much easier? Yes i am logging onto the enterprise manager as
SA. Can you explain what you mean by going to the server first and create
the database. How can i do that, if not from enterprise manager?
Thanks for all your help.
Aaron
-----Original Message-----
From: Drew, Ron [mailto:RDrew@B...]
Sent: Monday, April 30, 2001 12:35 PM
To: ASP Web HowTo
Subject: [asp_web_howto] RE: ASP and SQL server
First, migrating from Access to SQL 6.5 (why not 7.0) will not be easy.
What userid are you signing on to enterprise manager as? SA??
If you can sign on make sure you are not in MASTER, PUBS or initial
installation databases. You want to be on your own database. You may have
to go to the server first and create the database because of space
requirements (not sure a client enterprise manager can do the database, but
it can do the tables once the instance space has been established).
Once the database has been established, go on enterprise manager and create
the table(s).
Then go into access and add a linked table using ODBC to the 6.5 database
picking the table you just created.
Then in access write a query to insert into the 6.5 table selecting from the
access table you want to convert.
Then copy your ASPs to a new name or separate directory and test changing
the connection.
That should do it.
NOTE: biggest problem I ran into is the definition of fields i.e. text
to char/varchar and date/time and currency. So be very careful and do so
upfront designing.
Ron
-----Original Message-----
From: Aaron.Mintz@d... [mailto:Aaron.Mintz@d...]
Sent: Monday, April 30, 2001 11:39 AM
To: ASP Web HowTo
Subject: [asp_web_howto] ASP and SQL server
I have done several sites using ASP and MS Access and using my NT computer
loaded with PWS to be the development environment. I have recently loaded
SQL server 6.5 on my computer so I can try to migrate the access databases
to SQL. I can't seem to set up a SQL database on my computer as the server.
When i enter enterprise mananger to set up a database, it only allows me to
see the networked server locations. How can I set up my computer as a
server?
Thanks,
Aaron
---
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')
Message #8 by "Drew, Ron" <RDrew@B...> on Mon, 30 Apr 2001 15:22:49 -0400
|
|
I have both 6.5 and 7.0 here. 7.0 is newer and the touch and feel is
different. Not to mention sooner or later good old Bill Gates will stop
supporting 6.5. Some differences are:
In 7.0 you do a TOOLS ..SQL Server Query Analyzer and get the script on the
top and the results below.
In 6.5 you do a TOOLS ..SQL Query Tool and get 3 tabs Query..Results..Stats
(I like this one better but I am only a user).
Enterprise Manager can run on both the client and server. First you load MS
SQL 6.5 on the server which will automatically load EM for use. Then you
can load manually EM on the client machine where your PWS is. I always
create a new database on the server EM and do my queries, table creates and
monitoring on the client (too lazy to walk to the network room)
The reason I indicated to get on the server is when you create a database
(not the tables) you first normally create a "database device". This is
done by going to Database devices within the Enterprise Manager (yes..you
can do this from the client however..) When you create the device you have
to point to a hard drive somewhere and indicate how much space you need for
the database (and dont forget the log device). To do this you really need
to be on the server since that is where you can determine one, which hard
drive to use if you have multiples and two, how much space is available for
both your database and log files. They will get created as an example:
c:\mssql\data\xxxxx.dat assuming you entered xxxxx as the database name
and
c:\mssql\data\xxxxxlog.dat for the log
On both you need to specify the size. The devices are nice because you can
schedule backups just knowing the device name. Once the device is built,
you can create the database on either the client or server but since you are
at the server for the device create..what the heck...create the database...
Hope this helps.
Ron
-----Original Message-----
From: Aaron.Mintz@d... [mailto:Aaron.Mintz@d...]
Sent: Monday, April 30, 2001 2:06 PM
To: ASP Web HowTo
Subject: [asp_web_howto] RE: ASP and SQL server
is 7.0 that much easier? Yes i am logging onto the enterprise manager as
SA. Can you explain what you mean by going to the server first and create
the database. How can i do that, if not from enterprise manager?
Thanks for all your help.
Aaron
Message #9 by Aaron.Mintz@d... on Mon, 30 Apr 2001 16:19:01 -0400
|
|
Thanks so much,
That is exactly the information i needed. I was in the dark about creating
the database on the client. I thought you could do it just like access and
treat any computer as a development server. I now realize that i need to
set the db up on a server and manipulate it from the client.
thanks again,
aaron
-----Original Message-----
From: Drew, Ron [mailto:RDrew@B...]
Sent: Monday, April 30, 2001 3:23 PM
To: ASP Web HowTo
Subject: [asp_web_howto] RE: ASP and SQL server
I have both 6.5 and 7.0 here. 7.0 is newer and the touch and feel is
different. Not to mention sooner or later good old Bill Gates will stop
supporting 6.5. Some differences are:
In 7.0 you do a TOOLS ..SQL Server Query Analyzer and get the script on the
top and the results below.
In 6.5 you do a TOOLS ..SQL Query Tool and get 3 tabs Query..Results..Stats
(I like this one better but I am only a user).
Enterprise Manager can run on both the client and server. First you load MS
SQL 6.5 on the server which will automatically load EM for use. Then you
can load manually EM on the client machine where your PWS is. I always
create a new database on the server EM and do my queries, table creates and
monitoring on the client (too lazy to walk to the network room)
The reason I indicated to get on the server is when you create a database
(not the tables) you first normally create a "database device". This is
done by going to Database devices within the Enterprise Manager (yes..you
can do this from the client however..) When you create the device you have
to point to a hard drive somewhere and indicate how much space you need for
the database (and dont forget the log device). To do this you really need
to be on the server since that is where you can determine one, which hard
drive to use if you have multiples and two, how much space is available for
both your database and log files. They will get created as an example:
c:\mssql\data\xxxxx.dat assuming you entered xxxxx as the database name
and
c:\mssql\data\xxxxxlog.dat for the log
On both you need to specify the size. The devices are nice because you can
schedule backups just knowing the device name. Once the device is built,
you can create the database on either the client or server but since you are
at the server for the device create..what the heck...create the database...
Hope this helps.
Ron
-----Original Message-----
From: Aaron.Mintz@d... [mailto:Aaron.Mintz@d...]
Sent: Monday, April 30, 2001 2:06 PM
To: ASP Web HowTo
Subject: [asp_web_howto] RE: ASP and SQL server
is 7.0 that much easier? Yes i am logging onto the enterprise manager as
SA. Can you explain what you mean by going to the server first and create
the database. How can i do that, if not from enterprise manager?
Thanks for all your help.
Aaron
---
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')
Message #10 by "Drew, Ron" <RDrew@B...> on Mon, 30 Apr 2001 16:54:20 -0400
|
|
Good luck...if you need any examples of add/change/delete ASP scripts let me
know.
Ron
-----Original Message-----
From: Aaron.Mintz@d... [mailto:Aaron.Mintz@d...]
Sent: Monday, April 30, 2001 4:19 PM
To: ASP Web HowTo
Subject: [asp_web_howto] RE: ASP and SQL server
Thanks so much,
That is exactly the information i needed. I was in the dark about creating
the database on the client. I thought you could do it just like access and
treat any computer as a development server. I now realize that i need to
set the db up on a server and manipulate it from the client.
thanks again,
aaron
|
|
|
View Cart
