sqlstate 01000

TechRepublic Resources

• sort by:
• Relevance
• Date
• Popularity

Ignore or eliminate ODBC messages in output of the scheduled SQL Agent job

I have a specified text format output file created in SQL Management studio, it has a corresponding result in it, but after I scheduled it via SQL Agent as a Job, the ODBC?insert [SQLSTATE 01000] message after every row and 'statistics' in teh first row, so it looks like this...

Tags: Programming languages, Databases, zsoltfodor@..., SQLSTATE 01000, SQL, ODBC

Discussion threads 2007-06-04

Additional Resources

After upgrading to Server 2003, ODBC clients don't connect to System DSN

After upgrading to Windows Server 2003 Standard from W2k Server, I can not get the clients to connect via ODBC System DSN to the SQL 2000 MSDE. I can however connect and run my application at the Server.Error at the client-Connection failed:SQLState: '01000'SQL Server Err0r: 11001[Microsoft][ODBC SQL Server Driver][TCP/IP...

Tags: matterofacts@..., Microsoft Corp., Microsoft SQL Server, ODBC, registry, server, software, SQL

Discussion threads 2005-03-14

ODBC CONECTION FAILED

I am trying to connect to an MSSQl Server on windows 2003 from a linux box specificly suse linux enterprise desktop via ODBC in crossover office. And this is what I getCONNECTION FAILEDSQLSTATE: 01000SQL SERVER ERROR: 11001[MICROSOFT][ODBC SQL SERVER DRIVER][TCP/IP SOCKET]CONNECTIONOPEN (CONNECT).CONNECTION FAILEDSQLSTATE: 08001SQLSERVER ERROR: 6[MICROSOFT][ODBC SQLSERVER DRIVER][TCP/IP SOCKET] SPECIFIEDSQL...

Tags: Databases, TCP/IP, Linux, folawise, ODBC, Microsoft SQL Server

Discussion threads 2007-06-30

Connection Failed SQL server error 768

Hello, We have an unusual setup at where we have an MSACCESS application(access 97) front end on a NT4 server that links to an SQL 2005 database running on a HP Proliant Server 2003 server. This works well mostly but when we have to import a large file into the...

Tags: TCP/IP, Databases, Microsoft Windows NT, Servers, rgoldsack@..., SQL Server Error, Microsoft SQL Server, server, SQLState, ODBC SQL Server Driver, TCP/IP Sockets

Discussion threads 2007-07-19

DSN connection failure with SQLEXPRESS in local net

I have 12 workstations in the network and all but one can connect to my SQLEXPRESS instance. When I try to create a DSN in the ODBC tool I get the following error.Connection FailedSQLState '01000'SQL Server Error: 11004[Microsoft][ODBC SQL Server Driver][TCP/IP Socket]ConnectionOpen(Connect)Connection FailedSQLState '08001'SQL Server Error: 6[Microsoft][ODBC SQL Server...

Tags: Databases, problem workstation, Microsoft Data Access Components, database, SQLEXPRESS, OLE DB, OLE, OLE DB connection, ODBC, Microsoft Corp., Microsoft SQL Server

Discussion threads 2008-08-23

Trouble connecting to SQL Server 2005

I get the following error when trying to create a DSN to connect to SQLSVR2005 from Windows XP client to W2K3 Server.Connection failed:SQLState: '01000'[Microsoft][ODBC SQL Server Driver][TCPIP Sockets]ConnectionOpen (SECCreateCredentials).Connection failed:SQLState '08001'SQL Server Error: 18[Microsoft][ODBC SQL Server Driver][TCPIP Sockets] SSL Security errorAppreciate any advice to resolve this.

Tags: Databases, Microsoft SQL Server 2005, SQLState, ODBC SQL Server Driver, Connection Failed, Microsoft SQL Server

Q&A 2009-09-27

Connecting SQL Server 2000 with Visual Basic 6.0 and Crystal Report 9

Hi! I have a problem regarding to my thesis application. I used Visual Basic 6 as my PL and MS SQL Server 2000 as my remote server database. Every time I run my projects It has an error message: Connectin Failed: SQLState: '01000' SQL Server Error: 53 [Microsoft][ODBC SQL Server...

Tags: Databases, Crystal Reports, Microsoft SQL Server, SQLState, DBNETLIB, ODBC SQL Server Driver, Microsoft Visual Basic 6.0, Microsoft Visual Basic

Discussion threads 2009-12-31