Sikh Philosophy Network » Sikh Philosophy Network » Current News » Information Technology » Access 2003 Front end SQL Server 2000 Back end via ODBC

Access 2003 Front end SQL Server 2000 Back end via ODBC

Our Donation Goal : Why Donate? : Donate Today! : Donate Anonymously (ਗੁਪਤ) : Our Family of Supporters

Goal this month: 500 USD, Received: 100 USD (20%)

Please Donate...

Related Topics...
Thread	Thread Starter	Forum	Replies	Last Post
Office 2003,Access 2003 and PMC 2000	ORRIRO	Information Technology	1	28-Jul-2006 08:36 AM
MS Access 2003 Link Table ODBC dialog box does not come up-fix?	Dan68	Information Technology	1	28-Jul-2006 08:28 AM
back end 2000 front end 2002-2003	simcon	Information Technology	2	28-Jul-2006 08:26 AM
Access 2000 and SQL Server 2000 connection string	David Kennedy	Information Technology	1	28-Jul-2006 08:23 AM
Connecting to ODBC through Access 2003	Kevin	Information Technology	2	28-Jul-2006 08:15 AM

Tags

2000, 2003, access, back, end, front, odbc, server, sql, via

Stay Connected to Sikhism, Click Here to Register Now!

LinkBack

Tools

Display Modes

#1 (permalink)

28-Jul-2006, 08:28 AM

Siross

Guest

Posts: n/a

Access 2003 Front end SQL Server 2000 Back end via ODBC

Donate Today! Tell a Friend Print Feedback

Register to Remove Advertisements

Hi
I'm not really an Access person but have had this problem sort of dropped on
me. Here is what I know ....
1. We have an Access MDB which connects to a SQL 2000 DB using an ODBC.
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/information-technology/12292-access-2003-front-end-sql-server.html
2. This works fine on our standard XP desktops
3. This does not work on our Windows Server 2003 Terminal Servers
4. On the W2K3 TS's we get
Connection failed:
SQLState: '01000'
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=12292
SQL Server Error: 11004
[Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]ConnectionOpen
(Connect()).
Connection failed:
SQLState: '08001'
SQL Server Error: 6
[Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]Specified SQL Server
not found.
5. When we recreate the ODBC it test out OK
6. If we use the ODBC in Excel it works fine.

Can anyone help or have they seen this before ? All help greatly
appreciated.

Do share your immediate thoughts or reactions on this issue? We value your views! Login Now! or Sign Up Today! to share your views with us.. Gurfateh!

Sponsored Links

Click Here to Donate Now!

Support Us! Become a Promoter!

Gurfateh ji, you can become a SPN Promoter by Donating as little as $10 each month. With limited resources & high operational costs, your donations make it possible for us to deliver a quality website and spread the teachings of the Sri Guru Granth Sahib Ji, to serve & uplift humanity. Every contribution counts. Donate Generously. Gurfateh!

Bookmarks

« Previous Thread | Next Thread »

(View-All) Members who have read this thread : 0
There are no names to display.

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)

Tools	Search
Show Printable Version Email to Friend	Search: Advanced Search
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is On HTML code is On Trackbacks are On Pingbacks are On Refbacks are On Forum Rules

» Blog
an apt quote - (harry haller) for madman only (II) - (harry haller) Another funny story, and Rory is castrated - (harry haller) the howling is a mere whisper - (harry haller) ouch - (harry haller)

» Active Discussions
Why are There so Many... By spnadmin Today 04:36 AM 48 Replies, 4,738 Views
BHOOTS (Ghosts) and... By findingmyway Today 04:22 AM 92 Replies, 13,711 Views
Thought of the Moment! By harry haller Today 04:01 AM 105 Replies, 4,970 Views
Map shows world's 'most... By harry haller Today 03:51 AM 10 Replies, 125 Views
Panjabi By findingmyway Today 02:14 AM 9 Replies, 197 Views
Textbooks Spotted... By akiva Today 02:14 AM 3 Replies, 43 Views
Fresno Sikh Who Was... By spnadmin Today 01:30 AM 0 Replies, 26 Views
Guns of the Nihangs... By spnadmin Today 01:24 AM 0 Replies, 27 Views
Saudi Woman Makes... By spnadmin Today 01:01 AM 0 Replies, 25 Views
Of Serpents, Pigs,... By japjisahib04 Today 00:55 AM 36 Replies, 891 Views
Do you believe in... By ravneet_sb Today 00:28 AM 165 Replies, 3,462 Views
The Great Imp Debate By harry haller Yesterday 23:12 PM 31 Replies, 460 Views
Sikhs making Their... By Chaan Pardesi Yesterday 20:51 PM 0 Replies, 78 Views
A Sydney [Aust] man who... By Ishna Yesterday 11:04 AM 0 Replies, 66 Views
Sikh Spokesman (ਪੰਜਾਬੀ... By spnadmin Yesterday 10:42 AM 164 Replies, 4,270 Views

» Books You Should Read...

All times are GMT +6.5. The time now is 04:40 AM.
Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2013, vBulletin Solutions, Inc.
Search Engine Optimization by vBSEO 3.6.0 PL2 Copyright © 2004-12, All Rights Reserved. Sikh Philosophy Network