FlyBoy Posted October 30, 2004 Posted October 30, 2004 i've just installed the SQL 200 server desktop engine... now when i want to open a database..the northwind.mdb ,with the VS.NET 2003 like this File ---> new ----> project -->other projects --->database projects --> dataase project. then in the "connection tab" number 1....im trying to open the data base but dont know how...where should i copy the file(the northwind.mdb)....lets say my computer name is "SURFER"??????????? the sql server is runing in the backgournd....as a tray icon... plz help... 10x in advance. Quote
stustarz Posted October 30, 2004 Posted October 30, 2004 Firstly MDB's are usually associated with Microsoft Access. SQL Server uses an MDF file to store its database, and then an associated LDF file as its transaction log. In order to access the data within a SQL Server DB you need to register the database to the server. If it is Northwind i imagine this will already be done for you. On the connections tab for a DB project select your SQL server name from the dropdown, enter the username and password to connect, and then choose the database from the other dropdown. Quote Visit: VBSourceSeek - The VB.NET sourcecode library "A mere friend will agree with you, but a real friend will argue."
FlyBoy Posted October 30, 2004 Author Posted October 30, 2004 Firstly MDB's are usually associated with Microsoft Access. SQL Server uses an MDF file to store its database, and then an associated LDF file as its transaction log. In order to access the data within a SQL Server DB you need to register the database to the server. If it is Northwind i imagine this will already be done for you. On the connections tab for a DB project select your SQL server name from the dropdown, enter the username and password to connect, and then choose the database from the other dropdown. when im pressing the drop down to select a server nothing happens.....any ideA? Quote
stustarz Posted October 30, 2004 Posted October 30, 2004 that would most likely be because the server isnt actually running, you mentioned there is a tray icon, if u right click it: there should be options: MSSQLServer - Stop, MSSQLServer - Pause etc.... make sure that the MSSQLserver - Start option is disabled, if not click it to start the actual server, the tray icon is just the SQL server services manager. If it is started, restart it and try again. Quote Visit: VBSourceSeek - The VB.NET sourcecode library "A mere friend will agree with you, but a real friend will argue."
FlyBoy Posted October 30, 2004 Author Posted October 30, 2004 (edited) well its on...the server is runing... :o when im pressing the drop down to look for servers...(my computer name...<< the server) i get the following error: "Error enumerating data servers. Enumerator reports 'Unspecified error'" :confused: Edited October 30, 2004 by FlyBoy Quote
Administrators PlausiblyDamp Posted October 30, 2004 Administrators Posted October 30, 2004 Have you tried entering your computer's name in the box? Quote Posting Guidelines FAQ Post Formatting Intellectuals solve problems; geniuses prevent them. -- Albert Einstein
FlyBoy Posted October 30, 2004 Author Posted October 30, 2004 Have you tried entering your computer's name in the box? yep...and i figured out that it wont open MDB files (the nwind) so now im looking for a way of converting the MDB to MDF file...any idea???? when i try using access it says that it doesnt have the upsizin wizarad installed and when im trying to install it using the CD....still doesnt work. im sure that there is another way to do that...... 10x in advance. Quote
Administrators PlausiblyDamp Posted October 30, 2004 Administrators Posted October 30, 2004 If you can't install the upsizing wizard then you may want to look at the import wizard from within SQL Server's Enterpise Manager. Quote Posting Guidelines FAQ Post Formatting Intellectuals solve problems; geniuses prevent them. -- Albert Einstein
FlyBoy Posted October 30, 2004 Author Posted October 30, 2004 If you can't install the upsizing wizard then you may want to look at the import wizard from within SQL Server's Enterpise Manager. hmmm what is it? where do i find it???? :confused: thanks for the reply. Quote
Administrators PlausiblyDamp Posted October 30, 2004 Administrators Posted October 30, 2004 If you run Enterprise Manager and select your server then go to the tools menu and the top entry should be Data Transformation Services, under that select import data and follow the wizard. Quote Posting Guidelines FAQ Post Formatting Intellectuals solve problems; geniuses prevent them. -- Albert Einstein
stustarz Posted October 30, 2004 Posted October 30, 2004 I dont think he will have Enterprise Manager as it is only MSDE you have installed - am i right? Quote Visit: VBSourceSeek - The VB.NET sourcecode library "A mere friend will agree with you, but a real friend will argue."
FlyBoy Posted October 31, 2004 Author Posted October 31, 2004 i just want to learn sql ....and write some basic c# sql programs.....why why why it has to be that painful :( :( :o :o Quote
stustarz Posted October 31, 2004 Posted October 31, 2004 It isnt once you get past the initial learning curve! Have you done much work with Access as a database in a .NET app? is that the reason for moving upwards :) if so, then the only thing i would advise is to actually use the Enterprise or Developer versions of SQL Server. That way you will have enterprise manager, which will allow u to manage the databases directly, creating tables, views, stored procedures etc. It would also help in working out why your getting connection issues aswell. Just an idea, and a way of me saying "i really dont know why your having this problem with MSDE", and to let you know someone has paid attention to your last post :) :) Quote Visit: VBSourceSeek - The VB.NET sourcecode library "A mere friend will agree with you, but a real friend will argue."
FlyBoy Posted October 31, 2004 Author Posted October 31, 2004 (edited) It isnt once you get past the initial learning curve! Have you done much work with Access as a database in a .NET app? is that the reason for moving upwards :) if so, then the only thing i would advise is to actually use the Enterprise or Developer versions of SQL Server. That way you will have enterprise manager, which will allow u to manage the databases directly, creating tables, views, stored procedures etc. It would also help in working out why your getting connection issues aswell. Just an idea, and a way of me saying "i really dont know why your having this problem with MSDE", and to let you know someone has paid attention to your last post :) :) thanks for the attention...its really appreciated! ;) ok,i've uninstalled the MSDE and i gonna get the "Enterprise SQL Server". i hope it gonna solve the connection problems.... and by the way,lets say if the connection would work...how do i register a DB to the server,that when i'll press the drop down list (the second one...of the db's) i'll see the specific db? Edited October 31, 2004 by FlyBoy Quote
stustarz Posted October 31, 2004 Posted October 31, 2004 Once you have SQL Server enterprise installed, you will have an app(its actually an MMC snap-in but anyway) called Enterprise Manager, once opened you will see your server - right click>>all tasks>> and either choose to create a new db, or attach an MDF to add an existing db. Its pretty much wizard driven from that point. Quote Visit: VBSourceSeek - The VB.NET sourcecode library "A mere friend will agree with you, but a real friend will argue."
FlyBoy Posted October 31, 2004 Author Posted October 31, 2004 (edited) Once you have SQL Server enterprise installed' date=' you will have an app(its actually an MMC snap-in but anyway) called Enterprise Manager, once opened you will see your server - right click>>all tasks>> and either choose to create a new db, or attach an MDF to add an existing db. Its pretty much wizard driven from that point.[/quote'] ok, i've installed it...but when im right clicking it..it says that the server isnt runing and it cant connect....the server is my computer...(computer name) any idea? :o :o :o Oh and when im trying to install the Sql server 2000 enterprise..it says: "microsoft sql server 2000 components isnt suported by the operating system. ony client components wil be available" then when im installing ...it get the upper error......any idea??? i have WinXP pro. and when it finishes i dont see the small server icon in the tray like i had with the MSDE. and when i try to turn on the SQL server...i get some error that says that i dont have the sql server componenets installed...(maybe that becasue it didnt installed them :rolleyes: ) ??? Edited October 31, 2004 by FlyBoy Quote
stustarz Posted October 31, 2004 Posted October 31, 2004 Firstly, are you installing with Administrative rights? and secondly are you on a network? Quote Visit: VBSourceSeek - The VB.NET sourcecode library "A mere friend will agree with you, but a real friend will argue."
FlyBoy Posted October 31, 2004 Author Posted October 31, 2004 Firstly' date=' are you installing with Administrative rights? and secondly are you on a network?[/quote'] hmmm...what do u mean with administrative right??? im logged to the windows with my user name..i dont think its the admin. and my computer isnt connected to any network....except the internet. Quote
stustarz Posted October 31, 2004 Posted October 31, 2004 The only thing i can think of is that you need to be a member of the 'administrators' group for the PC. Ermmm, Control Panel >> User Accounts >> Look for your user name and check that it has "Computer Administrator" for your account type. If not, then you need to be an admin, if you are then......i really dont understand why you cant install the server part! Quote Visit: VBSourceSeek - The VB.NET sourcecode library "A mere friend will agree with you, but a real friend will argue."
FlyBoy Posted October 31, 2004 Author Posted October 31, 2004 ok,ive installed the MSDE + the enterprise SQL! and now it can connect to the server. now i didnt really got it how do i register the Northwind.mdb file that i have.... when im trying to go to the all tasks >> i see: import and export data i select import... then next ...i put my server name into the textbox. and in the db dropdown list..i see only thses db's: master model msdb and more.....how do i put my own db??? Quote
stustarz Posted October 31, 2004 Posted October 31, 2004 OK: Firstly, you should already have the Northwind database installed on SQL server - it is the sample that comes included. If you want to convert an MDB into a SQL database, its best to use the Upsizing Wizard available in MS Access - this option should now be available being that you have SQL Server installed. If not, then your best bet is to create a new SQL server database, and then import the data into the database. You cant just attach MDB files into SQL Server. Quote Visit: VBSourceSeek - The VB.NET sourcecode library "A mere friend will agree with you, but a real friend will argue."
FlyBoy Posted October 31, 2004 Author Posted October 31, 2004 The only thing i can think of is that you need to be a member of the 'administrators' group for the PC. Ermmm' date=' Control Panel >> User Accounts >> Look for your user name and check that it has "Computer Administrator" for your account type. If not, then you need to be an admin, if you are then......i really dont understand why you cant install the server part![/quote'] OK....I HAVE TO CONFIRM : MISSION SUCCESSFUL!!!!! MANY THANKS TO YOU!!!! YOU WERE AWESOM!!! AND THANKS TO ANYONE WHO HELPED ME...MANY MANY THANKS!!!! ok this is what i've done: Installed MSDE. Installed MS SQL Server 2000 enterprise went to all tasks >> import data...and then imported the MDF file. before that i used the "data transformation services" to convert the Nwind.mdb to Nwind.MDF. and thats all...now i can keep and study sql :cool: oh and p.s: mu user is admin...and still it doesnt install the server components..(the enterprise sql) so i've installed the MSDE and them the SQL Enterprise..and then it worked...wired but works fine! Quote
stustarz Posted October 31, 2004 Posted October 31, 2004 fantastic, took a while but im glad all is cool now!! :) No probs about helping! Stu Quote Visit: VBSourceSeek - The VB.NET sourcecode library "A mere friend will agree with you, but a real friend will argue."
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.