Changing Careers - Software Developer To Database Developer
Jul 10, 2006
Hello all. I'm giving serious thought on changing gears withing the IT world. For several years I have been a software developer who has been fortunate enough to have been involved in the needed databases. From just sketching out tables for the DBA to doing the database from the ground up and maintaining it during production. Along the way I've known that I didn't do as quality of a job as a knowledgeable DBA would do but given the situations I made do just fine.
I am considering switching gears to the database side only, coding as secondary. Since I am basically familier with most aspects of SQL Server in a general way, I am looking to take that knowledge and become a "Professional". What I am looking for is a few books to help out. Maybe a "Become a DBA for Software Developers" or something. I know that mining these and other forums are very valuble but I'd like some other training materials as well.
Have I been clear enough on what I am looking for? I don't quite feel like I have.
Basically, what would you recommend for a good software developer who is looking on switching to becoming a good database person?
I'd like to stay in SQL Server for now, since that is what they use here and it would give me an opportunity to practice.
Also, do you see value in the studying process for certifications in this area?
View 14 Replies
ADVERTISEMENT
Jun 19, 2006
I can't tell if the SQL Developer install upgraded the service, but left the SqlExpress version information, or if I'm still really only using SqlExpress.
Also, my intended target is SQL Enterprise, so if I am using SQL Express am I asking for trouble when I go to move the database over? Are the database formats compatible?
I've poked around trying to search for this answer for a while and haven't turned anything up. Maybe I'm searching on the wrong terms...
Thanks,
Geoff
View 6 Replies
View Related
Nov 24, 2007
There are conflicting postings everywhere about this. I built a small site using VWD and SQL Server Express, but need to convert to Sql Server 2005 Developer because the DB will exceed 4Gb. Tried to install and could not connect or use from VWD. Tried to uninstall, got into large mess with the byzantine uninstall process, and have now started with a clean machine.
I installed SQL Server 2005 Developer first, then installed VWD Express 2008 without installing SQL Server Express. VWD won't let me connect to an existing database, won't let me add a new database and doesn't even show the Database Tools option under the Tools menu.
Is there someone with specific knowledge that can provide any enlightenment? Would be much appreciated.
View 2 Replies
View Related
Nov 5, 2007
I am currently using SQL Server Enterprise Evaluation which runs out after 6months. When this happens or even sooner I plan to install SQL Server Developer.
My questions is can I copy all the things I develop (databases, cubes, reports,) from enterprise evaluation & import/load them into SQL Developer with no problems? Will everything integrate? Is there any implications?
View 1 Replies
View Related
May 4, 2006
Can someone here confirm or deny that Visual Web Developer 2005 Express Edition doesn't work with SQL Server Developer Edition 2005?
I
was about to order SQL Server Developer Edition 2005 on Amazon, to use
with Visual Web Developer 2005 Express, when I read a user comment that
the two are incompatible with each other. Does anyone know for sure if
that is true?
What I'm wanting to do is develop an ASP.NET web
application on a web host using a SQL Server database. I use VS2003 and SQL
Server Enterprise 2000 at work, but I'd like to learn the 2005 editions
for this side project. I don't own any of the developer tools/IDEs
personally, so I'm trying to find the most affordable way to do this
for my home business.
Thanks for any advice,
Keith
View 3 Replies
View Related
Jun 1, 2007
Hi, all -
I'm trying to register a developer's 2000 pc from my 2005 pc.
i'm not sure this is even something possible from Dev Edition to Dev Edition- I can register a 2000 server just fine.
I can ping him. Both our systems have remote access 'on'. His server is (local), i've tried connecting to it by just entering his machine name and by using just the ip address. The error I get is "timeout expired. The timeout elapsed prior to completion of the operation or the server is not responding."
Am I just not registering this properly? I entered just the ip address in the 'server' box. I am connecting as sa with the pw he gave me. When i connect to my server, I use the ip addressinstance. However, I am not sure what to use for the instance when all I see when I look at his machine is (local).
I haven't needed to do this before.
Suggestions?
View 2 Replies
View Related
Oct 30, 2007
I am wondering if it is possible to change from SQL Server Enterprise Evaluation Version to Developer Version. The reason is because the Enterprise Evaluation version expires after 180 days. So if I create reports and cubes in Enterprise Evaluation I can import them into Developer Edition right? Should I remove the Enterprise Evaluation version after 180 days or leave it then install Developer Edition?
View 1 Replies
View Related
Feb 17, 2004
Here is a job we are currently looking for. If you have or are working on your MCDBA please apply.
https://www2.mdanderson.org/sapp/webhire/index.cfm?pagename=details&JobID=04-0015432
Trey
View 1 Replies
View Related
Nov 1, 2005
I tried to install this on the same box and I'm not sure how to reply to setup questions since I want to keep my SQL Server 2000 intact.
View 5 Replies
View Related
Jul 24, 2006
I Am developing a simple app with a database. All has been going fine until now, the following is occuring:In Visual Web Developer 2005 Express if I connect to the database and view some table data I can do that fine but then as soon as I try to view a page in the browser I get the error:Login failed for user 'MachineNameASPNET'If in web developer I go to the database explorer and close the connection to the database then refresh the page it all works fine.Anyone have anyideas on how to correct this? ThanksScott
View 1 Replies
View Related
Jan 18, 2008
hi., i need help.,i Created a database using the SQL Server 2005 Express SQL Server Management Studio Express (SQL Server MSE)but i don't know how can i get the database that i made to put it in the Folder "App_Data" in my Visual Web Developer (VWD). is there any process or something to connect my database that i make using the SQL Server MSE to the VWD?Please help me, THanks
View 3 Replies
View Related
Jul 17, 2007
Hi, i am now using the visual web developer 2005 express edition. i have tried to create a search button to search for my SQL database by using the VB in VWD. i tried to enter the code but i dun seems to get it right... can any 1 help me by teaching me steps" by steps".?
View 1 Replies
View Related
Feb 10, 2008
when i am running both sql server management studio and beb developer and i try to connect to a database in web developer simultaneously it gives me errorfile used by another process file located on UNC sharebut if i am only running web developer it gives me no errorso please tell me how to connect to a same database simultaneously
View 1 Replies
View Related
Dec 16, 2006
I can access an SQL Server 2005 database from VWD, but for ease of uploading to a server and to maintain the database within just VWD environment would like to import it directly into VWD and its App_Data folder from the local machine SQL Server.
I guess this is more than copy and paste ('especially since this is not allowed becase the database is being used by another program').
I've seen posts about the reverse process but not this way. Any simple pointers please?
View 3 Replies
View Related
Oct 19, 2007
OK.
I'm using Microsoft SQL Server 2005 Developer Edition and I installed it under "Local System" on Microsoft Windows Vista Ultimate.
I understand that there are issues of course that occur with this, however I can't seem to understand why what I'm doing isn't working. I'm not using this on any server, just to test out ASP.NET 2.0 applications - nothing more.
I'm getting this error:
TITLE: Connect to Server
------------------------------
Cannot connect to RUSSPC.
------------------------------
ADDITIONAL INFORMATION:
An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) (Microsoft SQL Server, Error: 2)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLServer&EvtID=2&LinkId=20476
------------------------------
BUTTONS:
OK
------------------------------
I've installed this via a mixed authentication (as suggested by www.wrox.com).
I tried enabling the TCP/IP and named pipe connections, just as previous people have done, but it hasn't worked. Nor has enabling the SQL Browser.
I'm really at a loss on what to do.
View 3 Replies
View Related
Mar 7, 2008
Can I know about this ? I prefer to apply locks on database level and also to row level.
Is it possible or advicable ?
View 4 Replies
View Related
Jan 17, 2007
I have a SQL database table with all languages used in my application.
I would like to use an enum or constant class with all the languages, so every developer of the app sees directly what languages are available.
Can this be done?
View 5 Replies
View Related
May 30, 2007
Hi
I am trying to create a sql server database in the app_data folder of visual studio 2005. It keeps telling me I need the express version. Can I not use the developer version
Thanks
View 4 Replies
View Related
Jul 5, 2007
I have made my website using SQL Server Express edition. It is totally database driven and manypages use databases to display data. My problem is that after paying for webhosting fees my web host told me that they do not support SQL Server express edition. Instead they have support for MySQL and Ms Access. Except that there is this MS 2000 Database service for an additional cost. Any recommendations what I should do except changing the host? If I pay for MS 2000 Database servicem, will my website work? My user management(i.e ASPNETDB database) was created by Visual Web developer and I don't want to do user management myself. Any advice?
View 2 Replies
View Related
May 16, 2007
Please Help!!!.
I Installed everything but database Engine...
Error Log:
Property(S): SqlVerComBin.8E491190_3328_49D2_9FFE_2D036D847DE2 = C:Program FilesMicrosoft SQL Server90COM
Property(S): Ver.8E491190_3328_49D2_9FFE_2D036D847DE2 = C:Program FilesMicrosoft SQL Server90
Property(S): SqlVerComBin.EB8FB35E_3FC3_41F6_9721_7400C2070A66 = C:Program FilesMicrosoft SQL Server90COM
Property(S): Ver.EB8FB35E_3FC3_41F6_9721_7400C2070A66 = C:Program FilesMicrosoft SQL Server90
Property(S): SqlTarget.EB8FB35E_3FC3_41F6_9721_7400C2070A66 = C:Program FilesMicrosoft SQL Server
Property(S): SqlInstance.EB8FB35E_3FC3_41F6_9721_7400C2070A66 = C:Program FilesMicrosoft SQL ServerMSSQL.3MSSQL
Property(S): SqlInstanceBin.EB8FB35E_3FC3_41F6_9721_7400C2070A66 = C:Program FilesMicrosoft SQL ServerMSSQL.3MSSQLBinn
Property(S): sqlreps_dll.EB8FB35E_3FC3_41F6_9721_7400C2070A66 = C:Program FilesMicrosoft SQL ServerMSSQL.3MSSQLBinnsqlrepss90.dll
Property(S): SqlInstance.E4D6F7B0_3639_4517_9BA2_30823DE19CEB = C:Program FilesMicrosoft SQL ServerMSSQL.3MSSQL
Property(S): SqlTarget.E4D6F7B0_3639_4517_9BA2_30823DE19CEB = C:Program FilesMicrosoft SQL Server
Property(S): SqlInstanceInstall.E4D6F7B0_3639_4517_9BA2_30823DE19CEB = C:Program FilesMicrosoft SQL ServerMSSQL.3MSSQLInstall
Property(S): CommonFilesFolder.D9BC9C10_2DCD_44D3_AACC_9C58CAF76128 = C:Program FilesCommon Files
Property(S): MSShared.D9BC9C10_2DCD_44D3_AACC_9C58CAF76128 = C:Program FilesCommon FilesMicrosoft Shared
Property(S): DatabaseRepl.D9BC9C10_2DCD_44D3_AACC_9C58CAF76128 = C:Program FilesCommon FilesMicrosoft SharedDatabase Replication
Property(S): DatabaseReplRes.D9BC9C10_2DCD_44D3_AACC_9C58CAF76128 = C:Program FilesCommon FilesMicrosoft SharedDatabase ReplicationResources
Property(S): DatabaseReplRes1033.D9BC9C10_2DCD_44D3_AACC_9C58CAF76128 = C:Program FilesCommon FilesMicrosoft SharedDatabase ReplicationResources1033
Property(S): WindowsFolder = C:WINNT
Property(S): Gac.A6DEDA64_4924_4EA9_84E5_DC507BA0794B = C:Program FilesMicrosoft SQL Server90GAC
Property(S): Ver.A6DEDA64_4924_4EA9_84E5_DC507BA0794B = C:Program FilesMicrosoft SQL Server90
Property(S): Gac.4845A713_8D8A_4100_8CAA_164C5AC9E452 = C:Program FilesMicrosoft SQL Server90GAC
Property(S): Ver.4845A713_8D8A_4100_8CAA_164C5AC9E452 = C:Program FilesMicrosoft SQL Server90
Property(S): SqlVerComBin.8B75390F_DF2F_4C2C_92F5_9B83F3B36340 = C:Program FilesMicrosoft SQL Server90COM
Property(S): Ver.8B75390F_DF2F_4C2C_92F5_9B83F3B36340 = C:Program FilesMicrosoft SQL Server90
Property(S): SqlVerComBin.889BED4C_E3F4_4943_956C_6FFD882F721F = C:Program FilesMicrosoft SQL Server90COM
Property(S): Ver.889BED4C_E3F4_4943_956C_6FFD882F721F = C:Program FilesMicrosoft SQL Server90
Property(S): SqlVerComBin.CC4DBEA7_CD8B_4AAE_A10F_657CBA390BD6 = C:Program FilesMicrosoft SQL Server90COM
Property(S): Ver.CC4DBEA7_CD8B_4AAE_A10F_657CBA390BD6 = C:Program FilesMicrosoft SQL Server90
Property(S): SqlVerComBinRes.CC4DBEA7_CD8B_4AAE_A10F_657CBA390BD6 = C:Program FilesMicrosoft SQL Server90COMResources
Property(S): SqlVerComBinRes1033.CC4DBEA7_CD8B_4AAE_A10F_657CBA390BD6 = C:Program FilesMicrosoft SQL Server90COMResources1033
Property(S): SqlInstance.7827AB3E_7041_406A_9591_4DB66042927F = C:Program FilesMicrosoft SQL ServerMSSQL.3MSSQL
Property(S): SqlTarget.7827AB3E_7041_406A_9591_4DB66042927F = C:Program FilesMicrosoft SQL Server
Property(S): SqlInstanceBin.7827AB3E_7041_406A_9591_4DB66042927F = C:Program FilesMicrosoft SQL ServerMSSQL.3MSSQLBinn
Property(S): Data.7827AB3E_7041_406A_9591_4DB66042927F = C:Program FilesMicrosoft SQL Server
Property(S): DataInstance.7827AB3E_7041_406A_9591_4DB66042927F = C:Program FilesMicrosoft SQL ServerMSSQL.3MSSQL
Property(S): FTDataDir.7827AB3E_7041_406A_9591_4DB66042927F = C:Program FilesMicrosoft SQL ServerMSSQL.3MSSQLFTData
Property(S): DataInstanceTxt.7827AB3E_7041_406A_9591_4DB66042927F = C:Program FilesMicrosoft SQL ServerMSSQL.3MSSQL
Property(S): DataInstanceFTData.7827AB3E_7041_406A_9591_4DB66042927F = C:Program FilesMicrosoft SQL ServerMSSQL.3MSSQLFTData
Property(S): ModuleID_FTSSV = 68C6D15C_77E0_11D5_8528_00C04F68155C
Property(S): SqlFullTextDefaultPath = C:Program FilesMicrosoft SQL ServerMSSQL.3MSSQLFTData
Property(S): FTERefPath.68C6D15C_77E0_11D5_8528_00C04F68155C = C:Program FilesMicrosoft SQL ServerMSSQL.3MSSQLFTData
Property(S): QuotedServiceGroupFTS.CC1A8C58_27D1_4D38_BF1B_C0A5CBB90616 = B0019B91BCDB3SQLServer2005MSFTEUser$B0019B91BCDB3$SQL2005PDI1
Property(S): FTEInstName.68C6D15C_77E0_11D5_8528_00C04F68155C = SQL2005PDI1
Property(S): FTERudeInstName.68C6D15C_77E0_11D5_8528_00C04F68155C = MSSQL.3
Property(S): FTERegRoot.68C6D15C_77E0_11D5_8528_00C04F68155C = SOFTWAREMicrosoftMicrosoft SQL ServerMSSQL.3MSSearch
Property(S): FTEInstanceSubDir.68C6D15C_77E0_11D5_8528_00C04F68155C = MSSQL.3MSSQL
Property(S): FTEStartupType = 0
Property(S): FTEStatus = 3
Property(S): InstanceRegKey.7827AB3E_7041_406A_9591_4DB66042927F = Microsoft SQL ServerMSSQL.3
Property(S): InstanceName.7827AB3E_7041_406A_9591_4DB66042927F = SQL2005PDI1
Property(S): SqlVerComFT.BB43EC2E_1D73_400F_AE2F_F370407BC222 = C:Program FilesMicrosoft SQL Server90COM
Property(S): Ver.BB43EC2E_1D73_400F_AE2F_F370407BC222 = C:Program FilesMicrosoft SQL Server90
Property(S): FTESqlInstanceBin.68C6D15C_77E0_11D5_8528_00C04F68155C = C:Program FilesMicrosoft SQL ServerMSSQL.3MSSQLBinn
Property(S): FTESqlInstance.68C6D15C_77E0_11D5_8528_00C04F68155C = C:Program FilesMicrosoft SQL ServerMSSQL.3MSSQL
Property(S): FTESqlInstanceBinRef.68C6D15C_77E0_11D5_8528_00C04F68155C = C:Program FilesMicrosoft SQL ServerMSSQL.3MSSQLBinnFTERef
Property(S): FTESqlInstanceDotNumber.68C6D15C_77E0_11D5_8528_00C04F68155C = C:Program FilesMicrosoft SQL ServerMSSQL.1
Property(S): SqlVer.68C6D15C_77E0_11D5_8528_00C04F68155C = C:Program FilesMicrosoft SQL Server90
Property(S): FTESharedCompRoot.68C6D15C_77E0_11D5_8528_00C04F68155C = C:Program FilesMicrosoft SQL Server90
Property(S): Sql.68C6D15C_77E0_11D5_8528_00C04F68155C = C:Program FilesMicrosoft SQL Server
Property(S): SqlTarget.68C6D15C_77E0_11D5_8528_00C04F68155C = C:Program FilesMicrosoft SQL Server
Property(S): ProgramFilesFolder.68C6D15C_77E0_11D5_8528_00C04F68155C = C:Program Files
Property(S): CAFTERemovePerfCounters.68C6D15C_77E0_11D5_8528_00C04F68155C = $SQL2005PDI1
Property(S): CAFTEUninstallFTERef.68C6D15C_77E0_11D5_8528_00C04F68155C = C:Program FilesMicrosoft SQL ServerMSSQL.3MSSQLBinnFTERef|C:Program FilesMicrosoft SQL ServerMSSQL.3MSSQLFTData
Property(S): CAFTEUpgradeFTERefFiles.68C6D15C_77E0_11D5_8528_00C04F68155C = SQLServer$SQL2005PDI1:C:Program FilesMicrosoft SQL ServerMSSQL.3MSSQLBinnFTERef
Property(S): CAFTEUpgradeFTERefFilesRollBack.68C6D15C_77E0_11D5_8528_00C04F68155C = C:Program FilesMicrosoft SQL ServerMSSQL.3MSSQLBinnFTERef
Property(S): CAFTEInstallFTERef.68C6D15C_77E0_11D5_8528_00C04F68155C = C:Program FilesMicrosoft SQL ServerMSSQL.3MSSQLBinnFTERef|C:Program FilesMicrosoft SQL ServerMSSQL.3MSSQLFTData
Property(S): CAFTEAddCertificate.68C6D15C_77E0_11D5_8528_00C04F68155C = C:Program FilesMicrosoft SQL ServerMSSQL.3MSSQLBinn
Property(S): CAFTEInstallPerfCounters.68C6D15C_77E0_11D5_8528_00C04F68155C = C:Program FilesMicrosoft SQL ServerMSSQL.3MSSQLBinnSQL2005PDI1
Property(S): CASetLaunchPermissions.68C6D15C_77E0_11D5_8528_00C04F68155C = {68C6D318-77E0-11D5-8528-00C04F68155C}:NT AUTHORITYSYSTEM
Property(S): FTERegInstName.68C6D15C_77E0_11D5_8528_00C04F68155C = SQL2005PDI1
Property(S): FTERegRudeInstName.68C6D15C_77E0_11D5_8528_00C04F68155C = MSSQL.3
Property(S): FTEUPGRADE.68C6D15C_77E0_11D5_8528_00C04F68155C = 0
Property(S): FTEUpgrade30.68C6D15C_77E0_11D5_8528_00C04F68155C = 0
Property(S): FTEUpgradeMSSearchApp.68C6D15C_77E0_11D5_8528_00C04F68155C = SQLServer$SQL2005PDI1
Property(S): FTEUpgradeMSSearchStandalone.68C6D15C_77E0_11D5_8528_00C04F68155C = 0
Property(S): CostingComplete = 1
Property(S): FTEInstID.68C6D15C_77E0_11D5_8528_00C04F68155C = 1
Property(S): FTEAppID.68C6D15C_77E0_11D5_8528_00C04F68155C = {68C6D318-77E0-11D5-8528-00C04F68155C}
Property(S): FTEAdminCLSID.68C6D15C_77E0_11D5_8528_00C04F68155C = {68C6D37C-77E0-11D5-8528-00C04F68155C}
Property(S): FTEIFTEAdmin.68C6D15C_77E0_11D5_8528_00C04F68155C = {64f6bd6f-cc0d-11d6-9a15-505054503030}
Property(S): FTEMSFTEPXY.68C6D15C_77E0_11D5_8528_00C04F68155C = {64f6bdd4-cc0d-11d6-9a15-505054503030}
Property(S): FTEDollarInstName.68C6D15C_77E0_11D5_8528_00C04F68155C = $SQL2005PDI1
Property(S): FTEServiceName.68C6D15C_77E0_11D5_8528_00C04F68155C = msftesql$SQL2005PDI1
Property(S): OutOfDiskSpace = 0
Property(S): OutOfNoRbDiskSpace = 0
Property(S): PrimaryVolumeSpaceAvailable = 0
Property(S): PrimaryVolumeSpaceRequired = 0
Property(S): PrimaryVolumeSpaceRemaining = 0
Property(S): RSVirtualDirectoryServer = ReportServer$SQL2005PDI1
Property(S): SqlStateManaged = 2
Property(S): SqlActionManaged = 3
Property(S): SqlNamedInstance = 1
Property(S): RSVirtualDirectoryManager = Reports$SQL2005PDI1
Property(S): SOURCEDIR = S:PDIPDI ToolsSQL 2005 DeveloperCD1Setup
Property(S): SourcedirProduct = {2373A92B-1C1C-4E71-B494-5CA97F96AA19}
Property(S): InstallNgenTicks = 20000
Property(S): DebugClsid.CC1A8C58_27D1_4D38_BF1B_C0A5CBB90616 = {BF3C1964-6601-4DBB-A782-1848FD4A2109}
Property(S): SQLBROWSERACCOUNT = CORPNBDG3C3
Property(S): ProductToBeRegistered = 1
MSI (s) (F8:64) [14:22:43:217]: Note: 1: 1708
MSI (s) (F8:64) [14:22:43:217]: Product: Microsoft SQL Server 2005 -- Installation failed.
MSI (s) (F8:64) [14:22:43:233]: Cleaning up uninstalled install packages, if any exist
MSI (s) (F8:64) [14:22:43:233]: MainEngineThread is returning 1603
MSI (s) (F8:48) [14:22:43:342]: Destroying RemoteAPI object.
MSI (s) (F8:C0) [14:22:43:342]: Custom Action Manager thread ending.
=== Logging stopped: 5/16/2007 14:22:43 ===
MSI (c) (7C:84) [14:22:43:342]: Decrementing counter to disable shutdown. If counter >= 0, shutdown will be denied. Counter after decrement: -1
MSI (c) (7C:84) [14:22:43:342]: MainEngineThread is returning 1603
=== Verbose logging stopped: 5/16/2007 14:22:43 ===
View 4 Replies
View Related
Dec 22, 2006
In trying to upgrade my sql express install from express to developer edition, I ended up having to delete all things express from my computer and do a clean install of developer edition (as i installed developer edition initially over sql express but this didnt seem to work; express edition still appeared in add remove programs etc). Anyway so i blew away the install and have a clean install of developer edition. Now when I create a new website in Visual Studio 2005 and try to add a database to the project, it gives me an error stating that i need to have sql server express 2005 installed to function properly... Do i need to have express AND developer edition of sql installed to do this? I would think developer edition of sql would enable me this functionality...http://img277.imageshack.us/img277/4228/sqlerrorie2.jpgThanks!It is also worth noting that I get the dreaded remote connection error when trying to connect to a db that I used to be able to connect to when I was using sql express (the aspnetdb database that is created when you user their membership stuff)"An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified) "However, I did the following successfully:1. create a database using the sql management studio2. added a table and some data to it3. threw a dataset into the website4. added a gridview to a page in the website, pulling data from the dataset5. and the website runs successfully populating the page with data...fyi: My sql services: http://img158.imageshack.us/img158/2020/sqlserviceshj6.jpg
View 15 Replies
View Related
May 5, 2008
in visual studio web developer express edition 2008 i added a new item this was a sql server database which i called test2. I added a table called comments, and the fields name, email, comments, IPAddress, and Date and in my comments.aspx page i added a name textbox, a texbox for email, a textbox for comments and the submit button i double clicked on the submit button and added the following code
Protected Sub Button1_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles Button1.Click Dim mydS As New SqlDataSource mydS.ConnectionString = ConfigurationManager.ConnectionStrings("testConnectionString1").ToString mydS.InsertCommandType = SqlDataSourceCommandType.Text mydS.InsertCommand = "INSERT INTO comments(Name,Email,Comments,IPAddress,Date) VALUES (@Name,@Email,@Comments,@IPAddress,@Date)" mydS.InsertParameters.Add("Name", TextBox1.Text) mydS.InsertParameters.Add("Email", TextBox2.Text) mydS.InsertParameters.Add("Comments", TextBox3.Text) mydS.InsertParameters.Add("Date", Date.Now) mydS.InsertParameters.Add("IPAddress", Request.Params("REMOTE_ADDR")) Dim rowsaffected As Int16 = 0 Try rowsaffected = mydS.Insert Catch ex As Exception Server.Transfer("errors.aspx") Finally mydS = Nothing End Try If rowsaffected <> 1 Then Server.Transfer("errors.aspx") Else Server.Transfer("confirm.aspx") End If End Sub Protected Sub TextBox1_TextChanged(ByVal sender As Object, ByVal e As System.EventArgs) Handles TextBox1.TextChanged End Sub but when i run it it gives me a problem with this line mydS.ConnectionString = ConfigurationManager.ConnectionStrings("testConnectionString2).ToString and says something abt unidentified object and I want to know how do i set the connection string or alternatively where?????? and my table does not update with the corresponding values i enter on the webpage. i also changed the authentication mode to forms instead of windows as i was advised but i'm still having a problem
View 12 Replies
View Related
Apr 16, 2007
When I downloaded/started using Visual Web Developer I was under the impression that I needed to install SQL Server Management Studio Express in order to create/manage databases, and to provide the engine to access the data.
Since then I have found tutorials and have successfully created/used databases solely from within Visual Web Developer. I'm assuming that Visual Web Developer includes a database engine, much like the webserver that is included. (This is an awesome thing).
When I tried to upload my web application with database to my production server, the database would not work, it started working after I installed SQL Server Management Studio Express on the server.
Is it my understanding that you need SQL Server Management Studio Express if you do not have Visual Web Developer Express installed in order to provide the data access engine?
Also, I am unable to "attach" my Visual Web Developer Express created database to SQL Server Management Studio Express. Are there any posts that provide more information about this topic?
The only reason I'm asking is that I have extra whitespace on the end of my text fields, and I thought ANSI_PADDING was turned on. I do not see the option in Visual Web Developer Express, but have found it in SQL Server Management Studio Express.
View 14 Replies
View Related
Mar 17, 2007
Hi i have two version of SQL server express (with Visual Studio 2005) and developer edition i am trying to access an sql database file -created by the express edition integrated with Visual studio- using a developer edition instance can i just attach it and access it. and can i use BI and reporting services on that file
View 1 Replies
View Related
Apr 7, 2006
I found that when I install MSDE, then I can create/edit database objects for MSDE database in Visual Studio 2003 Server Explorer, but when I try to create/edit database objects under the default database created by the SQL Server 2000 installation, I cannot do these tasks as no option for these tasks appear when I right-click on the database object in Server Explorer. Anyone knows why this is happening?
View 3 Replies
View Related
Apr 7, 2006
Here is the error message I get:http://img109.imageshack.us/my.php?image=error2ug.jpgI have just installed both packages and havent done much in the way of configuration... What do i need to do? Thanks!
View 2 Replies
View Related
Apr 30, 2006
Hi, I'm completely new to SQL Server and ASP.NET, so please bear with me on my learning curve! I've installed Visual Web Developer Express and SQL Server Express (on the same PC). I then used Web Developer Express to successfully create a new database with a couple of tables in it. So far so good. I then installed SQL Server Management Studio Express on the same PC and tried to connect to my new database. The connection to the SQL Server instance appears to work OK (using Windows Authentication) but I can't see the database I previously created. All I can see are the System Databases. Does anyone know what the solution might be?
View 4 Replies
View Related
May 11, 2008
I was wondering if it is worth purchasing mssql developer 05 when I have mssql developer 2000
Thanks Jonny
View 2 Replies
View Related
Jan 11, 2005
i hope this is in the right place
i have just downloaded .net framework and web matrix, this is so i can test my .aspx pages witout going directly on the web. but i now have a new problem because i'm not on the web i can't access my sql, so i need to be able to create sql databases on my desktop and test them. obviously i can't afford the full sql server but there is a developer edition for £35 would this allow me to create and link to them through web matrix and if it does would i then be able to upload the created sql database to the web or is the software for testing only and will it block me from actually publishing the database?
View 3 Replies
View Related
Apr 10, 2006
Dear all,
I have been working in MS SQL Server for around 6 years ( versions : 7.0 and 2000 ). I have been extensively involved in database design and development. I have not much involved much in administrative activites.
I need to know what are the core activities which makes a Database Developer as a complete DBA ?
Thanks in advance,
Hari Haran Arulmozhi
View 8 Replies
View Related
Jan 1, 2007
I am web developer and i decided to use sql server 2005 for my projects ... is there a book you recommended for learning SQL Server 2005 Programming
Thank you
View 7 Replies
View Related
Jan 7, 2008
Wanted to get different opinions about how SQL Developer is being used.
We are fixing to upgrade from SQL 2000 to 2005 and are going to need to buy some licenses. I told my manager I didn't know why they had a processor license for the SQL test box and not just buy the developer copy for each developer to use on the server. This would free up 4 processor licenses.
From my understanding Developer is licensed per person to be used for development, and testing.
Now if you want to load test this do you have to buy a license for every machine? Is this where they stick it to you?
Was wondering what other people are doing out there.
View 1 Replies
View Related
Aug 31, 2007
hey everyone...guys i'll be honest i am a noob to web developer but i want to learn this real bad..i have been given a task from my teacher to make a table in SQL...i am really confused how to create a table? i have used the sql+ an old version before but i dont find any sort of an editor excep for the visual web developer itself..i can see a table designer but it is not accessible...i am really sorry for my noobness but i really want to learn...awaiting replies
View 2 Replies
View Related
