Wrox Programmer Forums
| Search | Today's Posts | Mark Forums Read
Classic ASP Databases Discuss using ASP 3 to work with data in databases, including ASP Database Setup issues from the old P2P forum on this specific subtopic. See also the book forum Beginning ASP.NET Databases for questions specific to that book. NOT for ASP.NET 1.0, 1.1, or 2.0.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Classic ASP Databases section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
  #1 (permalink)  
Old May 11th, 2004, 07:58 AM
Registered User
 
Join Date: May 2004
Location: , , .
Posts: 9
Thanks: 0
Thanked 0 Times in 0 Posts
Default Which and How?? ---Urgent

Mayb the question i ask is stupid. But i really dunno... LOL

1. How to create *.mdf for SQlServer? and How to open it (using wat kind of programs, prehaps) ?

2. My company is using SQL Server, can i use Access as my database of my pages? and How to do the connection string with the server?

Thanks.



  #2 (permalink)  
Old May 12th, 2004, 09:44 AM
Friend of Wrox
 
Join Date: Jun 2003
Location: Bangalore, KA, India.
Posts: 2,480
Thanks: 0
Thanked 1 Time in 1 Post
Default

1) To create database - using TSQL
http://msdn.microsoft.com/library/de...reate_1up1.asp

You can use Enterprise manager to open the database even to create that.
Enterprise Manager(EM)--> expand your "Server" --> expand "Database", you will find your database there(If created). Else right click and click "New database"... and proceed from there.

2) It depends up on your requirements and limitations to go with ACCESS or SQL Server. It is your call anyways.
for connection strings you can check http://www.connectionstrings.com

Hope that helps
Cheers!

-Vijay G
  #3 (permalink)  
Old May 14th, 2004, 08:27 PM
Registered User
 
Join Date: May 2004
Location: , , .
Posts: 9
Thanks: 0
Thanked 0 Times in 0 Posts
Default

That mean, however my company server is SQL, but i still can use Access database to ceate my data. It all depend on wat is my connection string. Right?

Thanks for help

  #4 (permalink)  
Old May 15th, 2004, 04:56 AM
Friend of Wrox
 
Join Date: Jun 2003
Location: Bangalore, KA, India.
Posts: 2,480
Thanks: 0
Thanked 1 Time in 1 Post
Default

I am not sure, why you wanted to use ACCESS when your company is using SQL server.

May be dont have permissions to work with SQL server, but remember that SQL statements that you use for ACCESS databse is not always the same with that you could use for SQL server. There needs to be some slight changes done to the SQL statements in case you wish to you port your data from ACCESS to SQL server in future.

Yes, you are right, depending on the connection string you can get connected to either SQL or ACCESS.

Hope that helps.
Cheers!

-Vijay G


Similar Threads
Thread Thread Starter Forum Replies Last Post
urgent deb_kareng ASP.NET 2.0 Professional 1 August 13th, 2007 07:29 AM
it's urgent deb_kareng ASP.NET 2.0 Professional 3 August 7th, 2007 07:40 AM
urgent help yash_coolbuddy_forindia BOOK: Wrox's ASP.NET 2.0 Visual Web Developer 2005 Express Edition Starter ISBN: 978-0-7645-8807-5 1 May 7th, 2007 08:40 AM
urgent???????????? nsr35 Beginning VB 6 1 October 3rd, 2005 10:57 AM
urgent ??????????????? nsr35 Pro VB Databases 0 October 3rd, 2005 04:53 AM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.