Reputation
Next privilege 125 Rep.
Vote down
Badges
3
Newest
 Tumbleweed
Impact
~576 people reached

  • 0 posts edited
  • 0 helpful flags
  • 0 votes cast
Nov
19
awarded  Tumbleweed
Nov
16
awarded  Commentator
May
2
accepted Create ODBC Connection from Access to SQL Server
May
2
comment Create ODBC Connection from Access to SQL Server
The server is hosted in Blaine, WA. I'm in Bellingham. The guy who runs the server gave me a .RDP file and I just connect with that. The .RDP uses mail.blahblah.com. I'm not sure if I'm supposed to use this mail subdomain or what. He made an account for me, with a username and password. Maybe I am being blocked by firewalls, I'll try to figure that out, thanks.
May
1
comment Create ODBC Connection from Access to SQL Server
So, I've pinged both mail.blahblahblah.com and blahblahblah.com, they both resolve to IP's, but only blahblahblah.com responds. I'm convinced I'm using the wrong name, the only information I have about the server is the string that I connect through the .RDP file(mail.blahblahblah.com), and the instance name. I also know the name of the computer that I get remote access to(It's called TERM). How can I find the correct server name? Thanks for the help
May
1
asked Create ODBC Connection from Access to SQL Server
Apr
26
awarded  Scholar
Apr
26
accepted How Do I Configure SQL Server 2005 Backend?
Apr
26
comment How Do I Configure SQL Server 2005 Backend?
Alright, I think then I'll talk to the server manager and see if we can do it. I assume if we move to 2008/2012, and I back up the old databases, we can still go back by restoring the backups? I'm all for using a newer version, I just want to do what will be easiest/smoothest without sacrificing security/functionality. Thanks, you've been a lot of help, you seem to know a lot about databases.
Apr
26
comment How Do I Configure SQL Server 2005 Backend?
I feel like my employer is pretty strict as far as what we use, he is already using the SQL 2005 for other things on the same server. Do you think it's worth converting to 2008? I might be able to convince him if it's going to make a large difference. The database won't be very complex, there will be about 5 tables total, and the vast majority of queries will be uploading barcodes one at a time. I think there are around 50 employees max. I'm just giving you a little more information in case it helps you picture the whole setup. Thanks.
Apr
26
comment How Do I Configure SQL Server 2005 Backend?
Alright, I'll try to find a better forum for my question. Thanks for the help.
Apr
26
comment How Do I Configure SQL Server 2005 Backend?
Thank you for the help. I already have the SQL server 2005 Express installed, I'll check if TCP/IP is enabled, if not I'll enable it. The thing is, I actually have a decent amount of experience with databases(I have a CS degree). I just haven't ever used these Microsoft products. The part that is making this difficult is having to use all the business's software, and making sure that everything will remain compatible. I know what 3rd normal form, primary keys, Indexes, and foreign keys are. I want to find the best configuration for a database of my needs. Thanks Again
Apr
26
comment How Do I Configure SQL Server 2005 Backend?
Where should I post this then? I posted it over at StackOverflow and they directed me here. Tell me why this makes you sad, or why you don't believe me. I posted a similar thread last week and there was a guy who said the same thing. This is disheartening because I have to complete this job for this guy, on top of full time university and a part-time web-developer/admin job. I'm just looking for help man.
Apr
26
comment How Do I Configure SQL Server 2005 Backend?
There isn't much story, I'm being hired to develop these systems. I have lots of experience with database design, however I've never done it using these microsoft products. I always programmed them in the past(MySQL mostly, but a few others as well). Will you explain why you downvoted my thread and why it makes you sad?
Apr
26
asked How Do I Configure SQL Server 2005 Backend?