|
| |
|
|
box
Posts: 117
Joined: 12/10/2002
Status: offline
 |
SQL Server Service Manager! - 9/14/2003 5:54:41
Hi everyone! I wanted to learn more about SQL 2000, so finally I download and ran
sql2kdesksp3a.exe file, now I have a icon that represent “SQL server service manager”
and it shows that SQL server is running! I’m confused! Can anyone please explain me how
can I use this, and how can I convert access 2000 to SQL 2000? Do I need to install something else? I want to convert a ms access to sql 2000 and use it with frontpage 2002. I did my homework and searched the net but I couldn’t find any simple article. Please help, thanks
|
|
|
|
box
Posts: 117
Joined: 12/10/2002
Status: offline
|
RE: SQL Server Service Manager! - 9/14/2003 17:48:55
Thanks 4 reply Spooky, my O/S is winxp pro, the only listed program is MS ASP.net web metrix! and also I can see the icon for SQL Server Manager on
toolbars!
| |
|
|
|
Doug G
Posts: 1189
Joined: 12/29/2001
From: SoCal
Status: offline
|
RE: SQL Server Service Manager! - 9/14/2003 18:34:00
You got MSDE, which doesn't include client tools
You can use Access 2000+ quite effectively to manage and play with your MSDE server. Open an Access Project, choose to create a new project, new database, and when you are asked for the database server use localhost or 127.0.0.1 or your computer name (there is a dropdown which should return your local server).
Use windows authentication.
This will create a new database on your MSDE server.
_____________________________
======
Doug G
======
| |
|
|
|
box
Posts: 117
Joined: 12/10/2002
Status: offline
|
RE: SQL Server Service Manager! - 9/14/2003 21:34:39
Hi there, do I need client tools? I did install web data admin, but I don't see it! Also I got the upsizing wizard report! My question is now what should I do? Where is the converted database and do I import it to the front page 2002, please forgive my ignorance!
I need your help!
| |
|
|
|
box
Posts: 117
Joined: 12/10/2002
Status: offline
|
RE: SQL Server Service Manager! - 9/15/2003 0:31:22
quote:
client tools
Thanks everyone specially Spooky, now I have client tools installed on my pc! Now
What would be the next step? thanks
| |
|
|
|
box
Posts: 117
Joined: 12/10/2002
Status: offline
|
RE: SQL Server Service Manager! - 9/15/2003 1:14:30
I have a program based on frontpage 2002 and DWR, I want to convert the MS Access
database to sql 2000 and make sure that program will work as before.
| |
|
|
|
rdouglass
Posts: 9228
From: Biddeford, ME USA
Status: offline
|
RE: SQL Server Service Manager! - 9/15/2003 11:55:23
quote:
Sorry I think I will give up!
Don't give up! You'll be glad you didn't!
If you installed the client tools, you should have a program called Enterprise Manager. That will allow you to see all the tables and queries that the upsizing wizard created. Open Enterprise Manager and add a new "Server Registration". You should now be able to see all your data.
To use the SQL Engine with FrontPage DRW, you build a ODBC connection (or DSN) and have the DRW access that. You can use existing DRW's by changing the connections under your database connections.
Any help there?
_____________________________
Don't take you're eye off your final destination.
ASP Checkbox Function Tutorial.
| |
|
|
|
box
Posts: 117
Joined: 12/10/2002
Status: offline
|
RE: SQL Server Service Manager! - 9/15/2003 15:00:02
quote:
you build a ODBC connection (or DSN) and have the DRW access Thanks a lot for you support, I did open a new "Server Registration", now do I need to build a connection to the new database? I’m afraid to say how can I do this! It would be very useful to have an example of that famous connection. So if understood correctly the concept is different because access lives inside of frontpage but sql Is in another location and I need to provide the link or address. To be honest with you here is more than forum is an university thank you all.
| |
|
|
|
rdouglass
Posts: 9228
From: Biddeford, ME USA
Status: offline
|
RE: SQL Server Service Manager! - 9/15/2003 15:07:08
If you're using the DRW and have access to the host, setup a database connection using the server's control panel. Then change your existing DRW connection to use the SQL connection from within FrontPage.
If you let me know which server OS and FP version you're using, I can give you more details....
_____________________________
Don't take you're eye off your final destination.
ASP Checkbox Function Tutorial.
| |
|
|
|
box
Posts: 117
Joined: 12/10/2002
Status: offline
|
RE: SQL Server Service Manager! - 9/15/2003 16:06:43
Thanks rdouglass, I use winxp pro with fronpage 2002 or xp,What I did I opened the fpdb folder then upsized the access database by running the wizard I left everything as default and also I got the upsizing report now the issue is How to create the new connection, and replace it I guess I need to run spooky diet too!
Thanks again
| |
|
|
|
box
Posts: 117
Joined: 12/10/2002
Status: offline
|
RE: SQL Server Service Manager! - 9/16/2003 1:06:18
Thanks a lot guys, with your help I’m getting close, my questions are:
1-What application changes do you want to make?
a-Create a new access client/server application
b-Link SQL server tables to existing application.
c-No application changes.
Next step
2-Do you want to open the resulting ADP file after the upsizing operation is completed?
-Open the new ADP file?
-Keep the MDB file open.
3- What is max size of this SQL database and what is the number of connection to it?
4- Now when I want to display result from the SQL database I get the following error:
Database Results Error
[Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user 'KELLY\IUSR_KELLY'.
I appreciate your help.
| |
|
|
|
box
Posts: 117
Joined: 12/10/2002
Status: offline
|
RE: SQL Server Service Manager! - 9/16/2003 15:51:02
Any Idea please!
| |
|
 New Messages |
 No New Messages |
 Hot Topic w/ New Messages |
 Hot Topic w/o New Messages |
 Locked w/ New Messages |
 Locked w/o New Messages |
|
Post New Thread
Reply to Message
Post New Poll
Submit Vote
Delete My Own Post
Delete My Own Thread
Rate Posts
|
|
|
Printable Version 
k¥ 