Shared Database Server

Sharing mysql database with another server?
I am wanting to link 2 domains with one database how can this be done?

I hope the 2 domains are on the same machine! then it's just sharing a password or setting up an extra user. if they are on 2 distinct machine, you have to get into the security of allowing only that machine using only that ip,user, and password. if you do it wrong... you can get hacked.

I have Access database, How can I upgrade it to SQL Server database?
I have a good experience in Using and Programming MS Access database and I am practicing it everyday. but it is a little bit slow because it is shared on the LAN with multiple users. As I know from a course I tooke about SQL sever database it is very fast . what are the basic steps to upgrade MS Access database to SQL server database?

Good answers, but no one has addressed the front end. Only your data can migrate over to SQL. Your forms, queries, reports, macros, and modules cannot migrate. You can however use Access Project for your front end. Queries get replaced by Stored procedures, which are all SQL Code. There is no nice GUI to help with the design. The good news is that you can take the SQL code for a query and make a stored procedure after some modifications. All your forms and reports will be OK in Project, but the code has to be ADO, not DAO. If you are using ADO Code now, then you are going to be able to debug it more easily than if you are using DAO now. It can be frustrating. Good Luck and have fun.

If I put my inventory software on my server, How can I access the database??
Hello: Have a quick question. I currently have a inventory software that I have on my computer. It uses sql server as the database. I have it installed on one other computer in the office, and that computer has a shared drive to my computer to access the database. This works fine for the office, but we have a few retail locations that would like to access the database a few times a day. Since I'm not a computer expert, but would imagine that I could put this application on a server with a dedicated ip address. I could use some sort of VPN software to make a connection to the directory that houses the database info. and have my retail location use this way to access information. Would this work? Also it seems like we can't have but one person hit the database at a time. I guess that we would need to pay for more people to access the database. Any help would be appreciated. Thanks

That really depends on the features of the inventory software that you have. Some inventory software would have multi-user access, some would just be stand-alone. But if the software can support multiple users, then yes, you can have multiple users across multiple sites accessing the same software. This is something that you'd have to bring up with your inventory software vendor. VPN access would be ideal to keep your network secure, and you can use the built-in VPN server feature of Windows Server and the VPN client feature of Windows 2000/XP/Vista. You're on the right track.

Best way to share a database between two locations with vpn?
Here is the set-up at location A we have a Windows 2000 server (with AD, full domain and static ip) that is set up as a vpn server. On this server is a fox pro (don't giggle too much) database that is shared to a vpn client in location B. As the dbase has gorwn it is now very slow for location B to do anything with the dbase. If I would put a Windows 2000 server at location B and I guess mirror the shared dbase from server in location A with the server inlocation B over the vpn, meaning that location A would be working with a local copy of the dbase and location B would be working with a local copy of the dbase speed sould increase. First off it this set up doable or what is a better option. Don't know too much about vpn and boss doesn't want to pay for faster ineternet. Please help. Thanks, Jase

No. This is not doable if you're accessing the database at both locations. A mirror or DFS will fail miserably. If you're entering data at both locations, you'll have two different versions of the same database. Reconciling the mirror/DFS will either totally corrupt the database (most likely) or overwrite one copy with the other. Either you will lose all your data, or all the data entered at one of the locations. This will happen every single day. Very, VERY bad idea. I can only think of three options. First, split up your database (I'm not familiar with fox pro, sorry). If you can create a sub-database for location B that links to the main database at location A, you'll dramatically reduce your network traffic. I don't know if this is possible with your setup. Second, you can tell your boss he either has to cough up the money for more bandwidth or pay a whole lot more in lost productivity because your workers can't work efficiently with what he's got. (Count up the man-hours lost each month because of the slowdown vs the cost of bandwidth. Couch it in terms of saving him money, not costing him any). Third, use telnet instead of vpn. With telnet sessions from the remote location all the data resides at location A. Very, very little data passes between the points. The trade-off is the cost of telnet licenses from Microsoft, but that would be less than a new server and OS at location B.

A transport-level error has occurred when receiving results from the server. (provider: Shared Memory Provider
This type of error is comming from last few days when i try to connect the server database before i was working fine. waiting fro ur answers Thanks & Regards Sudhakar

http://blogs.msdn.com/sql_protocols/archive/2005/09/28/474698.aspx

Server question for business?
I want to set up a server for a medium sized business - 10 - 30 users - using a database application so everyone will share database of one server. we have DSL internet so we have on router in the office - and all PCs are networked via the router - every PC has outlook installed - and gets emails via pop3 from web server - not outlook exchange ! what type of server should i buy? do i need dual core processor - 3 ghz? 2 gb ram - i was going to go for dell - but i thought HP would be better? more reliable. I was hoping to only spend £500 on server - what best advice - my networkign advisor was saying he needs a internet line to supply an Ip address in order to set up network i didnt understand that - im sur eyou can set up a netwirjk without the need for internet - as PCs communicate within the room - i know i need windows 2003 server -

If this is the first server you are putting in. Check out the Windows 2003 Small Business Edition. You will save a lot of money on Software (it come boudle with SQL database and Exchange and many other windows server software for about one half price of the windows 2003 server standard edition that does not incude those software.) The only thing to keep in mind is that only one small business edition server is allowed per window domain, so don't be thinking aobut buying another the next time around. Hardware wise, you should go with Dual Core Processor, I would even suggest 4gb if you plan on activate addtional services on the server after checking out Windows Samll Busines Edition. Dell and HP are both reliable, but from my experience it is the Technical support that makes the different. Dell in general has the best customer support when things do break. You don't need a internet connection for IP address. the company should be running in a private IP address. You can still use the current DSL for internet. Unless you have other requirements that not mentioned here such as allowing user to access the database from the internet.

SQL Server Express 2005 and VB 2005: I Can't Connect to Database.?
All protocols for SQL Express are enabled but i can't connect to DB using VB 2005 Express DataGridView! I can see the Server name in the Add Connection dialog box. But when I click on the Database button, no databases are displayed. I get an error. I can see the database from SQL Server Management Studio. SQL Server is on my desktop, from which I am also running VB. I have enabled the following three protocols: - Shared Memory - Named Pipes - TCP/IP but still, when i browse for the database,i am getting the following error on pressing the Test Connection button: 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) Please help me sort out this problem ________________________ Both SQL Server Express and my VB 2005 are on my desktop computer. The connection is local, not remote. _________________________ ___________ I am using Windows Authentication. ___________

I work tech support for a company whose software needs SQL. Whenever that message is displayed in our case it has been because the server name is incorrect or a firewall is blocking the connection. You can try temporarily disabling windows firewall and making sure the server and instance name are correct. If it's a local install, the server name should be (local)\instancename. You can try the osql commands from the command prompt to see if you have connectivity. type at the dos prompt: osql -L This will give a list of all SQL instances on all computers. To test connectivity: osql -S -U -P (where S is server\instance, U is user ID, and P is password.)

What Network Structure (database,webserver,mail server and software) should I choose?
Looking for a network infrastructure design: Overview: Need an intranet where 40 people are able to communicate and share files (including videos), should be able to access the internet. Its an ecommerce business, so customers will purchase products through the internet. The product information should be stored on some kind of database. Workers should be able to access the data (text, audio, video) from the database to work on it, and the website should be able to access the text, audio, video files for the webpage content. The workers should also be able to communicate with each other through email. An estimated number of customers visiting the website: 1000/day At the moment there is no intranet, no network structure. Could You suggest to me what kind of hardware I would require apart from the 40 PC's for the employees. E.g. Routers, Hubs? Webserver?Email Server? What Kind of database system would you propose? What software would you recommend for each of the main components? THANKS

Big load of stuff. Linux, preferably PCLinuxOS Business Edition. That comes with Apache, php, MySQL, Bastille, SMTP, POP3, etc., etc. Everything but your web pages and a shopping cart. Try VCD-DB as a video catalog. It's designed for commercial DVD releases, but it's open source php, so you can modify it. Openfire, if you want an internal chat facility, like AIM or Yahoo chat, without letting them chat over the internet. Pidgin clients on the computers. I'll let someone else tackle the hardware end. (If you want to use Windows domain logins for password protection on a Linux webserver, email me - I had to do that here.)

What database software to learn to get a job?
Oracle, MS SQL Server (with Transact SQL), or some smaller vendor's database such as mySQL? Or even MS Access? Oracle has the largest market share and it runs on multi-platforms. MS SQL is limited to MS Windows even though there's some movement to make it run on non-MS Windows platform. It's also easier to learn than Oracle. MS Access doesn't seem to be a marketable skill, even though most of small databases are in Access at most companies. What do you think is the best database software to get a job in database industry? I have field experience only with Access and Membership Plus.

you need to learn both, but SQL provides more long term opportunity. As a manager I had an immediate need for a MS Access expert. But the reality of the project and ultimate goal required a more in depth knowledge and framework such as your SQL. Think about your longterm goals. you probably want ot do real programming. Knowledge of both will keep you employed. Access may have you doing, financial analyst and other related work. (If you could bridge the two worlds it would do wonders for your carer as well.) While SQL will keep you moreso in your computer programming realm.

how to share a access database?
how can i share a ms access database on 2 or 3 computers. let both computers have the database opened at same time and when they modify something the other computer can see the change. I dont want to get involved with any servers because the database will only web used for one or two days. it will be working off workgroups. windows xp pro.

Easy. Create two types of access database the front end where the forms etc are held and the backend where the tables are held then tidy it up using the linked table manager. make sure the backend is where all the front ends can see it. and point each frontend to the single back end. You need any help let me know http://www.data-technology.co.uk Then go to the forums or contact me. I can split it in about an hour for you and tell you how to implement it on any network no servers nothing.