Create ODBC Connection from Access to SQL Server

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

General SQL Server Forums

New to SQL Server Programming

Create ODBC Connection from Access to SQL Server

Author

Topic

Scriptonaut
Starting Member

2 Posts

Posted - 2012-05-01 : 19:09:22

Hey guys,

I need help connecting from a blank access 2010 database to my remote SQL Server 2005 database. This is because I'm going to write all my client apps in Access, and store everything on the server with SQL Server. I'm using the wizard, and trying to make a new DSN. What do I put for:

Which SQL Server do you want to connect to?
Server:

The server is windows server 2008, and it is remote. I've been connecting to it with a .RDP file, but I'm not sure how to set up the link. The .RDP connects to mail.blahblahblah.com, where blahblahblah is the domain name. So I put:

mail.blahblahblah.com\SQLEXPRESS
I've also tried:

blahblahblah.com\SQLEXPRESS
I keep getting SQL Server Error: 53, server does not exist or access denied. Could you guys help me figure out what I put for the server name? Thanks

Please ask me to clarify anything that doesn't make sense.

Thanks.

Lumbago
Norsk Yak Master

3271 Posts

Posted - 2012-05-02 : 04:54:13

It's probably a firewall issue. Try to open up a command prompt and type "telnet mail.blahblahblah.com 1433" and see if you get an error message or of the screen goes blank. Blank screen = good, errormessage = firewall/connectivity issue.

- Lumbago
My blog-> http://thefirstsql.com/2011/07/08/how-to-find-gaps-in-identity-columns-at-the-speed-of-light/

Scriptonaut
Starting Member

2 Posts

Posted - 2012-05-02 : 13:19:45

quote:
Originally posted by Lumbago

It's probably a firewall issue. Try to open up a command prompt and type "telnet mail.blahblahblah.com 1433" and see if you get an error message or of the screen goes blank. Blank screen = good, errormessage = firewall/connectivity issue.

- Lumbago
My blog-> http://thefirstsql.com/2011/07/08/how-to-find-gaps-in-identity-columns-at-the-speed-of-light/

I tried to telnet into:
- "mail.blahblahblah.com 1433"
- "TERM.mail.blahblahblah.com 1433"
- "blahblahblah.com 1433"

mail is the subdomain I connected to with my .RDP file, and TERM is the name of the server. None of these worked, said connection failed. Do you happen to know the absolute syntax of the string that denotes the path from any computer to this server? Do I include my username, etc? Sorry for all the questions.

Thanks for the help.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources