The Black Forum 2 - The BN Village Home
WE ARE CURRENTLY UPGRADING & RELOCATING THE BLACK FORUM!!!! (BNVILLAGE)

------ THIS AREA WILL BE READ ONLY AS OF 18th JUNE 07 -----
----- PLEASE ONLY USE www.bnvillage.co.uk -----

THE BNVILLAGE WILL NOW BE LOCATED @ www.bnvillage.co.uk



Search
   
Login

Register

Members

Calendar

Help

Home
Search by username


DSN ERROR TO A MICROSOFT SQL SERVER DATABASE
 Moderated by: Saida.M, safetyblitz, Raven, Miss Brighter Days, LadyDay, Kunjufu, Kibibi, Happiness, Dillinger, Breadfruit, Backatya  

New Topic

Reply

Print
Author
Post
BN Village Guidelines
obal85
Villager
 

Joined: Saturday January 3rd, 2004
Location:  
Posts: 1240
Photo: 
Status:  Offline
Mana: 

Click here for your Black Profile

Search for Black Sites

 Posted: Thursday January 5th, 2006 03:19

Quote

Reply
Does anybody knows what this below shown error message means?. I was trying to set up a Data Source Name (DSN) to a Microsoft SQL server Database 2000, when i encountered it. Look forward to hearing from you.


connection failed:
SQLState: '01000'
SQL Server Error: 53
[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.




____________________
Click here for your Black Profile
umbrarchist
Villager


Joined: Monday May 2nd, 2005
Location: Wisconsin USA
Posts: 1402
Photo: [Download]
Status:  Offline
Mana: 

Click here for your Black Profile

Search for Black Sites

 Posted: Thursday January 5th, 2006 08:38

Quote

Reply
I don't know what it means but a Google search on this:

"SQLState: '01000'"   "Error: 53"

turned up these.

http://www.dbforums.com/t991536.html
http://www.dbforums.com/t700046.html
http://www.mcse.ms/archive86-2004-9-908137.html
http://www.eggheadcafe.com/ng/microsoft.public.sqlserver.odbc/post717382.asp

Last edited on Thursday January 5th, 2006 08:39 by umbrarchist



____________________
Beware of Vulcans from the Dark Side


____________________
www.blacksearch.co.uk - Helping to promote Black African and Caribbean Websites
safetyblitz
Super Moderator


Joined: Thursday January 20th, 2005
Location: Memphis 10, Tennessee USA
Posts: 3738
Photo: 
Status:  Offline
Mana: 

Click here for your Black Profile

Search for Black Sites

 Posted: Thursday January 5th, 2006 15:52

Quote

Reply
obal85 wrote: Does anybody knows what this below shown error message means?. I was trying to set up a Data Source Name (DSN) to a Microsoft SQL server Database 2000, when i encountered it. Look forward to hearing from you.


connection failed:
SQLState: '01000'
SQL Server Error: 53
[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.

In XP or 2000?

Also were you using NT authentication or SS authentication?

Another goofy thing about SS is that sometimes you have to check your network libararies.  You may have to go TCP/IP with the determine port box checked in.  Sometimes Named pipes just does not work

Even better question, is the name of the server, the database you are connecting to, the user name and password spelled correctly?  I cannot tell you how many times that it has looked correct to me only to later come back and see that ws the culprit.  LOL

Also are you trying to go from server to server or connecting an application to the server?



____________________
Click here for your Black Profile

 Current time is 20:43


Join the
Blacknet
mailing list

Name

Email address

Age

General




Search
   
Login

Register

Members

Calendar

Help

Home
Search by username



News>>> Black Chat>>> What's On>>> Black Search>>> Black Forums>>> Black History>>>
Games
>>> Homelands >>> Business>>> Entertainment >>> Beauty>>> Religion>>>
Recipe
>>> Magazines>>> Buy & Sell >>> Webpals>>>
Sponsors>>> Black Family Day >>> Homepage

Join Black net Mailing List!!! It's FREE!!

or or call us Tel: (+44) 0870 746 5000 - Fax: (+44) 020 8692 9755


BNVillage - More than just a web site...
© 1996-2006 Black net UK All rights reserved.
Blacksearch.co.uk / Blackchat.co.uk/ Blackprofessional.co.uk

Please read Disclaimer