Access 2000 Developer and SQL Server 7.0

Michael

I am using MS Access 2000 on an Windows XP machine and am trying to
use
the Upsizing Tool in Access 2000 to upsize an Access 2000 database to
use with Microsoft SQL Server 7.0.

My MS Access 2000 version is part of an Office 2000 Developer Edition
upgrade from Office 97. Included in the Office 2000 SR-1 Developer
package is a disk entitled Microsoft SQL Server 7.0 that I have
installed.

When I try to upsize a database using the Access 2000 tool a dialog
box comes up including the question "What Server would you like to use
for this database?" In this box "Microsoft SQL Server 7.0" is aleady
there. When I click OK the following error message comes up:
Connection failed:
SQLState '01000'
SQL Server Error: 1231
[Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionOpen( Connect())
Connection failed:
SQLState '08001'
SQL Server Error: 17
[Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server
does not exist or access denied.
Can anyone please enlighten me and provide some possible solutions.
Cheers
Michael

Nov 12 '05 #1

Subscribe Reply

4072

Ted Theodoropoulos

unfortunately, i can't provide any information on the particular error
you're getting. what i can tell you, however, that the upsizing tool
in A2K is a total piece of shit. i wouldn't waste my time with it if
i were you. most of the decisions the wizard makes are horrendous.
in almost all cases, the best way to upsize the database is to
recreate the access tables and queries manually in SQL. u can cut and
past the sql access uses sometimes but the joins are impossible to
read. there are several situations where the access sql is not
usuable by SQL Server.

mw*****@timaru. com (Michael) wrote in message news:<6d******* *************** ****@posting.go ogle.com>...

I am using MS Access 2000 on an Windows XP machine and am trying to
use
the Upsizing Tool in Access 2000 to upsize an Access 2000 database to
use with Microsoft SQL Server 7.0.

My MS Access 2000 version is part of an Office 2000 Developer Edition
upgrade from Office 97. Included in the Office 2000 SR-1 Developer
package is a disk entitled Microsoft SQL Server 7.0 that I have
installed.

When I try to upsize a database using the Access 2000 tool a dialog
box comes up including the question "What Server would you like to use
for this database?" In this box "Microsoft SQL Server 7.0" is aleady
there. When I click OK the following error message comes up:
Connection failed:
SQLState '01000'
SQL Server Error: 1231
[Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionOpen( Connect())
Connection failed:
SQLState '08001'
SQL Server Error: 17
[Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server
does not exist or access denied.
Can anyone please enlighten me and provide some possible solutions.
Cheers
Michael

Nov 12 '05 #2

Josh Armstrong

From just reading the error, you need to give the dialoge box that is
asking for the server that SQL7 is on you must enter the name of the
server itself. For example one of my SQL boxes is names "Max", when
that box comes up I would enter Max.

mw*****@timaru. com (Michael) wrote in message news:<6d******* *************** ****@posting.go ogle.com>...

I am using MS Access 2000 on an Windows XP machine and am trying to
use
the Upsizing Tool in Access 2000 to upsize an Access 2000 database to
use with Microsoft SQL Server 7.0.

My MS Access 2000 version is part of an Office 2000 Developer Edition
upgrade from Office 97. Included in the Office 2000 SR-1 Developer
package is a disk entitled Microsoft SQL Server 7.0 that I have
installed.

When I try to upsize a database using the Access 2000 tool a dialog
box comes up including the question "What Server would you like to use
for this database?" In this box "Microsoft SQL Server 7.0" is aleady
there. When I click OK the following error message comes up:
Connection failed:
SQLState '01000'
SQL Server Error: 1231
[Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionOpen( Connect())
Connection failed:
SQLState '08001'
SQL Server Error: 17
[Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server
does not exist or access denied.
Can anyone please enlighten me and provide some possible solutions.
Cheers
Michael

Nov 12 '05 #3

Ted Theodoropoulos

that error is a general error that can appear for a multitude of
reasons. the sql server not existing and access being denied are VERY
different situations yet u get the same error. if memory serves u get
that error in the client tools themselves such as QA and EM.

try pinging the box and see if u get a response. if so then make sure
ur sql is running on port 1433. if it isn't (which many servers
aren't after slammer) then you'll need the client network utility to
configure ur client.

jo***********@s ocal.rr.com (Josh Armstrong) wrote in message news:<b6******* *************** ****@posting.go ogle.com>...

From just reading the error, you need to give the dialoge box that is
asking for the server that SQL7 is on you must enter the name of the
server itself. For example one of my SQL boxes is names "Max", when
that box comes up I would enter Max.

mw*****@timaru. com (Michael) wrote in message news:<6d******* *************** ****@posting.go ogle.com>...
I am using MS Access 2000 on an Windows XP machine and am trying to
use
the Upsizing Tool in Access 2000 to upsize an Access 2000 database to
use with Microsoft SQL Server 7.0.

My MS Access 2000 version is part of an Office 2000 Developer Edition
upgrade from Office 97. Included in the Office 2000 SR-1 Developer
package is a disk entitled Microsoft SQL Server 7.0 that I have
installed.

When I try to upsize a database using the Access 2000 tool a dialog
box comes up including the question "What Server would you like to use
for this database?" In this box "Microsoft SQL Server 7.0" is aleady
there. When I click OK the following error message comes up:
Connection failed:
SQLState '01000'
SQL Server Error: 1231
[Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionOpen( Connect())
Connection failed:
SQLState '08001'
SQL Server Error: 17
[Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server
does not exist or access denied.
Can anyone please enlighten me and provide some possible solutions.
Cheers
Michael

Nov 12 '05 #4

Similar topics

6740

SQL-2000 GUI

by: Dagwood | last post by:

Good morning: At least it's morning where I am. :) I have a rather newbie question I'm afraid. I have VisualStudio.NET, and have installed it along with SQL server. However I can't seem to find an administration front-end to SQL, other than the VisualStudio, which is ok for creating databases and adding tables/columns. However when I go to generate create script, I'm told that I need client tools.

Microsoft SQL Server

2100

Access 2000 Developer Tools

by: Scott | last post by:

Hi all, Im trying to distribute Access 2000 APP. And I have a copy of "Office 2000 Premium SR-1" should this contain Developer Tools or is this located elsewhere. Any help would be gratefully appreciated. Thanks Scott

Microsoft Access / VBA

1087

Windows 2000 Server Listed as a User in an Access XP Dabase

by: rm | last post by:

Through the LDB viewer we are seeing one of our servers in the "users listed" list. The information is legitimate as we have code that is dependent on the non-presence of the LDB file. The code is failing to execute because even programmatic access to the MDB file produces the LDB file. While it is my understanding the accessing the MDB in "exclusive" mode will not produce the LDB file I am not certain if the developer opens in...

Microsoft Access / VBA

5952

Future of MS ACCESS ...

by: Uwe Range | last post by:

Hi to all! A customer of mine told me some days ago that her IT-people told her ACCESS would not be such a good idea for continuing with our project, because Access will not be continued in the future. I haven't heard of this. Does anybody know more about it? The IT-People usually prefer Oracle. If they really want to go in this direction, could our Access-application (if continued) be used as a front end with an Oracle back end? Does...

Microsoft Access / VBA

1624

ASP.NET Application - Migrating from Access 2000 to SQL Server 7

by: lcifers | last post by:

First off, sorry if my cross posting offends anyone. I'm posting this in Access and SQL Server groups - not sure which one is appropriate. I have a relatively simple ASP.NET/VB.NET application that is now hitting an Access 2000 database over an intranet. We have to migrate the database to SQL Server 7. My experience with ASP.NET is pretty limited and my experience with SQL Server is nonexistent. We have an MSDN subscription, so I went...

Microsoft Access / VBA

7673

Why do IT guys hate MS Access?

by: Jeffrey P via AccessMonster.com | last post by:

Our IT guys are on a vendetta against MS Access (and Lotus Notes but they've won that fight). What I can't understand is, what's the problem? Why does IT hate MS Access so much. I have tried to find out who it is that actually wants to get rid of it, but I can't find anyone who will admit to trying to get rid of it. Nevertheless, I'm always hearing about how their "phasing it out" or "getting rid of it". Because no-one owns up I can't...

Microsoft Access / VBA

4971

Access 2003 & SQL Server 2005

by: Neil | last post by:

We have an Access 2000 MDB with a SQL 7 back end. We are upgrading SQL Server to SQL 2005, and are considering upgrading to Access 2003. Someone mentioned that they had heard about some incompatibilities between Access 2003 and SQL Server 2005. Anyone hear of anything? And, if so, would staying with Access 2000 be better? Thanks! Neil

Microsoft Access / VBA

2915

Is There a Client/Server Version of Access ?

by: B1ackwater | last post by:

We've fooled around with Access a bit, but only using the single-user store-bought version. It seems to be a good database - versatile and infinitely programmable - and can apparently be used as a front end to SQL server if we ever needed to go that route. But - is there a client/server version of Access ? Looking on the CDW site there is a bewildering variety of packages and licences and such, but we can't figure out just which do...

Microsoft Access / VBA

6285

.NET Windows Forms Application VS MS Access client Application

by: Jordan S. | last post by:

SQL Server will be used as the back-end database to a non trivial client application. In question is the choice of client application: I need to be able to speak intelligently about when one client (MS Access vs ..NET Windows Forms) would be preferred over the other. While I have some good arguments on both sides, I would appreciate your points of view on the topic.

.NET Framework

9522

What is ONU?

by: marktang | last post by:

ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...

General

9336

Changing the language in Windows 10

by: Hystou | last post by:

Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...

Windows Server

9948

Maximizing Business Potential: The Nexus of Website Design and Digital Marketing

by: jinu1996 | last post by:

In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...

Online Marketing

9902

The easy way to turn off automatic updates for Windows 10/11

by: Hystou | last post by:

Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...

Windows Server

9765

Discussion: How does Zigbee compare with other wireless protocols in smart home applications?

by: tracyyun | last post by:

Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...

General

6603

Couldn’t get equations in html when convert word .docx file to html file in C#.

by: conductexam | last post by:

I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...

C# / C Sharp

5364

Windows Forms - .Net 8.0

by: adsilva | last post by:

A Windows Forms form does not have the event Unload, like VB6. What one acts like?

Visual Basic .NET

3866

transfer the data from one system to another through ip address

by: 6302768590 | last post by:

Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system

C# / C Sharp

3446

How to add payments to a PHP MySQL app.

by: muto222 | last post by:

How can i add a mobile payment intergratation into php mysql website.

PHP