SQL express on pc / svr questions
I have a few questions about SQL express.
Will SQL express make my workstation (regular PC on network) act as a server? Or does it just allow VB express / Web Developer Express to write code that will work on an actual My SQL server?
The goal is to make a simple DB that will then be used on a website on a live server which has My SQL on it. I don't need SQL express on that server also do I? MY knowledge about SQL is next to null.
Thanks
[475 byte] By [
Lockey] at [2007-12-19]
Hi,
the name SQL Server (Express) implies that it can be used to serve all clients (as a server) The service is running the same way (listening to a port on TCP or every other protocol) and does the same things for connecting.
HTH, Jens Suessmeyer.
http://www.sqlserver2005.de
Ok, so my PC essencially turns basically into a server then.
Can I keep SQL Express from communicating with other computers, especially the server? I didn't install it yet, I want to avoid network conflicts at all costs basically. All I'd want to use SQL Express to do is test the code before it goes on the live server. This workstation is turned off every night around the time when remote users will be updating the DB on the site.
Will I need SQL Express on the webserver to run any hosted code done in VB and Web Developer Express? Or will My SQL handle the code?
Ok, so my PC essencially turns basically into a server then.
-Yes.
Can I keep SQL Express from communicating with other computers, especially the server?
SQL Server Express or any SQL Server doesn′t communicta eby themselves with any other servers as long as you code them to. :-)
I didn't install it yet, I want to avoid network conflicts at all costs basically. All I'd want to use SQL Express to do is test the code before it goes on the live server.
It just listens on the network adress / port.
This workstation is turned off every night around the time when remote users will be updating the DB on the site.
-OK, what was the question ?
Will I need SQL Express on the webserver to run any hosted code done in VB and Web Developer Express? Or will My SQL handle the code?
If you mean .NET code (CLR) within the SQL Server (liek function procedure etc. in CLR) you don′tneed to have a webserver. YOu just need to install the CLR 2.0 on the machine where SQL Server Express is hosted (as this is a prerequisite) in the machine to install it.
If you have any further question, don′t hesitate to ask, sometimesits hard to understand the questions the right way.
HTH, Jens Suessmeyer.
There is already and existing webserver with My SQL and an existing website.
I know from the help files that I need SQL Express to build a database. I only plan on using SQL Express to build and test the Database on this computer. When it is complete, I want to then transfer the Database on the webserver.
Will I still need SQL Express on the live server since it has My SQL on it?
I don't want this machine to work as a server. Only purpose for the SQL Express to even be on it is to build and test the DB until I'm ready to put it on the live server. I don't want the SQL Express to communicate with any other computers at all.
I'm still in the research phaze, so I might try out the Web Developer and see which program will work best.
"Will I still need SQL Express on the live server since it has My SQL on it?"
MySQL and SQL Server databases are not compatible, so you either develop on a SQL Server OR a MySQL box.
"I don't want this machine to work as a server."
Hmmh, what is a server by definiton ? If a machine is listening on a specific port, is it a server then ? Then a computer listening to messages on MSN Messenger service is also a server.
"Only purpose for the SQL Express to even be on it is to build and test the DB until I'm ready to put it on the live server. I don't want the SQL Express to communicate with any other computers at all."
So disable all the protocols that you don′t need and don′t want.
HTH, Jens Suessmeyer.
http://www.sqlserver2005.de
The 'server' is a web server, a different system then what I'm working on. The computer I'm working on is only being used as a regular workstation. I don't want the program to be hosted on this workstation, it will be on a different system.
I define a server as bascially a central system that stores files, websites, and offers network configurations such as DHCP services. In this case it is a webserver hosing websites to multiple clients.
Is it possable to use the Express products for MySQL or do I need the standard editions? I'm pretty new to programming, only past experiance has been a 3 month course 2 years ago and going threw the Visual Basic Guided Tour that MS built in VB Express product (and current plans are to take my studies deeper).
Hi,
ok. Just to take us to the same level of understanding, you are talking about the combination VB.NET Express and MYSQL (You are not talking about MSSQL, aka. Microsoft SQL Server, with the newest edition SQL Server 2005, with the LowBudget Version database Express, as a whole spoken --> SQL Server 2005 Express). Just to make sure that we are talking about the same database, we are talking about MYSQL *not MSSQL*
As long as you have the driver libraries for MYSQL, that should be no problem connecting to the database. I am sure there are many samples out there showing how to connect to a MYSQL database. But I don′t think if you are really right in this Group, which is actually about MSSQL.
Hope I got you right, if so just raise a hand and I will move this over to the VB.NET group as these guys might know better to follow up.
HTH, Jens Suessmeyer.
http://www.sqlserver2005.de
I plan on using at least one of the following, if not both: Web Developer Express and VB Express which both seem to be using SQL Express.
I don't directly deal with the web server, I've been told that it has MySQL and Linux on it and is regularly updated. The reason why I posted in this group was asking if I needed to use SQL Express on the webserver with the database that I'm designing, or if I just needed SQL Express on my workstation to build and test out the program.
P.S. I probably won't get on a computer until tomarrow (it is 4p.m. now) because my evening is full. Had I known how complex this would have been, I would have posted on a day where I would be home to check up on this thread every once in a while.
Thanks you answered a lot of questions for me.
ok,
(...)MySQL and Linux(...)
then SQL Express is out. SQL Server Express can′t be installed on a Linux system. It is only supported on a couple of Windows OS.
-Jens.
Thanks for your help! I'll have to research on a VB express forum on how to code this for a server that runs MySQL.
