473,324 Members | 2,501 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,324 software developers and data experts.

Access 2000 Developer and SQL Server 7.0

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
3 4036
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.google. 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
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.google. 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
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***********@socal.rr.com (Josh Armstrong) wrote in message news:<b6**************************@posting.google. 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.google. 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

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

10
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...
3
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...
0
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...
33
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...
2
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...
92
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...
9
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...
5
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...
22
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...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.