hI iam getting error as 08s01 from the application end to connect to my database.It says communication link failure (odbc error)
no users were able to get into the database. (other applications accessing other DB's on the same server are able to connect )
In my error log i hav this
ERROR 602: severity 21
coudntfind row in sysindexes for dbid,obj id , INDEX 1. Rund dbcc checktable on sysindexes.
I haf run dbcc commands evrything is showing fine. I haf non-clustered inbdex defined on that particular object.
In sysindexes i haf indid as 0 & 2.
i am running out of ideas. can anyone PLEASE suggest anything for me. sqlserver 6.5, standard security.
Error when i try to execute a SP with ADO connection, or ADO COMMAND [ODBC SQL Server Driver][SQL Server]The identifier that starts (XXXXXX)is too long. Maximum length is 128. can anyone help me.
I am using ODBC (ODBCLink/SE) to connect to HP3000 system;Retrieving the data into Microsoft Excel goes fine usingMicrosoftQuery.But if I try to use SQLServer2000-DTS on Windows2003 to do the import,it always fails and gives the message:"ODBCLINKSE does not allow multiple thread"Does anybody knows how to do that?I need to synchronize data in HP3000 into my database in SQLServer; andI dont see any other ways to do that besides using DTS-scheduled-jobs.Pls help..
i installed ODBC drivers from openlink-install. and i don't know how to configure from ODBC from control panel. Test connection has failed. What are things i have to take care of.
In Windows Server 2003 SP1 (x86) with Sql Server 2000 I could use the following connectionstring no problem DSN=Hello;
Now I am using Windows Server 2003 x64 and SQL 2005 and I get this error: Provider is not specified and there is no designated default provider.
If i try Provider=MSDASQL;DSN=Hello; i get Provider cannot be found. It may not be properly installed.
for DSNless this works fine: Provider=sqloledb;driver={sql server};server=(local);database=Hello;uid=sa;pwd=p wd;
but i am forced to use DSN as it is in a closed source application which uses set DSNs (the idea there being that you can change the connections how you like in ODBC)
This means that i need the ODBC provider name that will work in here: Provider=...;DSN=Hello;
and then to use whatever works in there as the "default provider" but i cannot find any information anywhere on how to do this!
On localhost this application works fine but when I put on remote server. I am getting following errors. For both localhost and server, I am using same remote sql 2000. I will appreciate any help.
Thanks,
Arif
Server Error in '/' Application. --------------------------------------------------------------------------------
ERROR [42000] [Microsoft][ODBC SQL Server Driver][SQL Server]Line 1: Incorrect syntax near ')'. Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
Exception Details: Microsoft.Data.Odbc.OdbcException: ERROR [42000] [Microsoft][ODBC SQL Server Driver][SQL Server]Line 1: Incorrect syntax near ')'.
Source Error:
An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.
The following (VB.Net) code causes exceptions at seemingly random times. Any suggestions? Not sure if the problem is in .Net's ODBC support or in Sql Native Client.
If MARS is off, usually after less than 100 loops:
Code Snippet
System.Data.Odbc.OdbcException was unhandled ErrorCode=-2146232009 Message="ERROR [HY000] [Microsoft][SQL Native Client]Connection is busy with results for another command" Source="SQLNCLI.DLL" Turning MARS is on bypasses that error, so it will sometimes survive a thousand or so runs before hitting:
Code Snippet
System.Data.Odbc.OdbcException was unhandled ErrorCode=-2146232009 Message="ERROR [23000] [Microsoft][SQL Native Client][SQL Server]Cannot insert the value NULL into column 'Number', table 'tempdb.dbo.#TempTable___..(shortened to fit).. _________000000002F3F'; column does not allow nulls. INSERT fails. Source="SQLNCLI.DLL" Code here: (Console Application, empty database, Visual Studio 2005, .Net 2.0, Windows XP,SQL Server 2005 or SQL Express 2005, Local or Remote)
Code Snippet
Module Module1
Sub Main()
'Dim connection As New SqlClient.SqlConnection("database=TestDB;server=.sqlexpress;Integrated Security=SSPI;") 'Doesn't crash 'Dim connection As New OleDb.OleDbConnection("Provider=SQLNCLI;database=TestDB;Server=.sqlexpress;Trusted_Connection=yes;") 'Doesn't crash
'Dim connection As New Odbc.OdbcConnection("Driver={SQL Native Client};Database=TestDB;Server=.sqlexpress;Trusted_Connection=yes;") 'Crashes Dim connection As New Odbc.OdbcConnection("Driver={SQL Native Client};Database=TestDB;Server=.sqlexpress;Trusted_Connection=yes;MARS_Connection=yes") 'Crashes
VBMath.Randomize()
Dim run_count As Integer = 1 connection.Open() Console.WriteLine("Connected!!")
While True 'connection.Open()
Dim testcmd As New Odbc.OdbcCommand("CREATE TABLE [#TempTable] (Number int PRIMARY KEY)", connection) testcmd.ExecuteNonQuery() testcmd.Dispose() testcmd = Nothing
Dim dtTemp As New DataTable Dim daTemp As New Odbc.OdbcDataAdapter("SELECT * FROM [#TempTable]", connection) daTemp.MissingSchemaAction = MissingSchemaAction.AddWithKey daTemp.Fill(dtTemp) Dim cbTemp As New Odbc.OdbcCommandBuilder(daTemp) Dim viewTemp As New DataView(dtTemp, Nothing, "Number", DataViewRowState.CurrentRows)
Dim i As Integer For i = 1 To 1000 Dim test_number As Integer = CInt(Rnd() * 2000) If viewTemp.Find(test_number) = -1 Then 'Keep it unique Dim new_temp_row As DataRowView = viewTemp.AddNew() new_temp_row("Number") = test_number new_temp_row.EndEdit() End If Next
daTemp.Update(dtTemp)
'daTemp.Dispose() 'daTemp = Nothing
'cbTemp.Dispose() 'cbTemp = Nothing
'dtTemp.Dispose() 'dtTemp = Nothing
'viewTemp.Dispose() 'viewTemp = Nothing
Dim testcmd2 As New Odbc.OdbcCommand("DROP TABLE [#TempTable]", connection) testcmd2.ExecuteNonQuery() testcmd2.Dispose() testcmd2 = Nothing
'connection.Close() 'GC.Collect()
'Console.Write(".") run_count += 1 End While
End Sub
End Module
Usually the ".Update" triggers the exception, but sometimes the other sql commands do it. Have tried various experiments with disposing of objects immediately when finished, but no effect. Opening and closing the connection each loop seems to delay the errors, but it still happens eventually.
When our administrators login on the workstation the application works well. But when ordinary users login they get the following error. (We only have 1 domain)
SQLState: 28000
SQL Server Error: 18452
Login failed for user ". The user is not associated with a trusted SQL Server connection.
Then the standard SQL Server Login window pops up asking for the Login ID and Password. On the window the 'Use Trusted Connection' is checked and the name of the user on the workstation appears on the LoginID. What we do is uncheck the 'Use Trusted Connection' then login using the credentials above.
I keep getting this error: OLE DB error: OLE DB or ODBC error: You do not have permission to run 'SP_TRACE_CREATE'.; 42000
I do not want to add the login account to sysadmin role on my production server and giving the logon account db_reader rights to my database is not working. Is there another way around it.
I have been searching high and low for days and I am perplexed and appalled at the lack of information regarding what can not be an isolated incident.
We are trying to get an Analysis Services 2005 to process on a x64 server. We have both versions of the Oracle client installed and .ora file in both places. I have seen a couple of posts regarding this issue, but they are 2 years old and MS was supposed to have resolved the 'parentheses' issue long ago.
The test connection succeeds, and I can explore the data in the datasource view, but I cannot process the cube. All I get is the "OLE DB error: OLE DB or ODBC error: Class not registered"
Microsoft Windows Server 2003 R2 Enterprise x64 Editon Service Pack 2
Installed Oracle Client 10g and ODAC home
I tried a few things that were suggested in posts, but nothing has worked. I tried the cmd line starting SSMS from progra~2 instead of (x86). I tried renaming the directory with no parentheses. This is the second time we've tried to get it to work in 2 years. We'll probably give up again and stay with x86, um, because it works without all these silly mickey-mouse tricks. Most of our relational DBs are ORACLE so this is a showstopper for us as far as trying to go x64.
Sorry for the attitude, but I'm really frustrated!
If anyone can tell me a way to resolve this (or that it can't be resolved), I'd really appreciate it!
DB-Library Error 10007: General SQL Server error: Check messages fromthe SQLServer.CREATE PROCEDURE [dbo].[spu_Import_Export_Image](@srvr varchar(50),@db varchar(50),@usr varchar(15),@pwd varchar(50),@tbl varchar(50),@col varchar(50),@mod varchar(1),@imgpath1 varchar(1000),@pk varchar(50))ASBEGINdeclare @path varchar(50)declare @whr varchar(200)declare @fil varchar(100)declare @cmd varchar(1000)declare @imgpath varchar(800)declare @ext varchar(5)--declare @pk varchar(50)declare @KeyValue varchar(8000)declare @image varchar(50)--declare @imgpath1 varchar(1000)declare @imgpath2 varchar(1000)declare @sellist varchar(2000)set @path = 'c: extCopy.exe'select @sellist = 'DECLARE curKey CURSOR FOR SELECT ' + @pk +' FROM '+ @tbl + ' ORDER BY ' + @pkexec (@sellist)OPEN curKeyFETCH NEXT FROM curKey INTO @KeyValueWHILE (@@fetch_status = 0)BEGINset @whr = '"where '+ @pk +' = "' + @KeyValueset @fil = @imgpath1 + '' + @KeyValue --+ @extset @cmd = @path + ' /S ' + @srvr + ' /D ' + @db + ' /U ' + @usr+ ' /P ' + @pwd+ ' /T ' + @tbl + ' /C ' + @col + ' /W ' + @whr + '/F ' + @fil+ ' /' + @modexec Master..xp_cmdShell @cmdFETCH NEXT FROM curKey INTO @KeyValueENDCLOSE curKeyDEALLOCATE curKeyENDGOAbove srcipt runs fine with image data type in one table but when irun for some other table it gives me Error MessageTEXTCOPY Version 1.0DB-Library version 8.00.194SQL Server 'WSQL01' Message 170: Line 1: Incorrect syntax near '99'.(Concerning line 1)DB-Library Error 10007: General SQL Server error: Check messages fromthe SQLServer.ERROR: Could not use database 'test1'NULL-----------Aslo it only runs on server console if i run it from workstation uingsame files and tables it gives me an error again. Can anybody help meand reply me at Join Bytes! asap.thnx,dharmesh
a.I am developing a database application using VB5/VB6, SQL server 7 and Crystal reports.When I try to generate reports I get the message 'Automation error'. Please help-urgent.
b. I am using temperorary tables to generate reports.ie Table is created by user.Tables are generated runtime ie created as well as deleted. Sometimes Sometimes i get the message 'SQLServer error' What should I do.What are the rights to be assigned to LOGINS?.
c.Is there precaution while installing SQLserver in WIN98.
I got this error message while I was trying to backup the last transaction log before I start restoring a database that is marked SUSPECT. SQL Server is running on Windows 9x. Please how can I handle it because I can't even restore the db. Thanks for your help!
Server: Msg 4060, Level 16, State 1, Line 0 [Microsoft][ODBC SQL Server Driver][SQL Server]Cannot open database requested in login 'Memphis. Login fails.
We are using ASP to connect to a remote database running on SQL server 7.0. On our testmachine we get no trouble, maybe because the SQLserver and Webserver is running on the same machine. But when we upload our code to a webserver and make a copy of our database on a remote SQLserver we get this error :
Microsoft OLE DB Provider for ODBC Drivers error '80040e37'
[Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'Seksjon'.
As we are working on a student project and our deadline is tomorrow, any help whatsoever would be of great assistance!!
When I use the dsn to connect to the sybase system I get this error The setup routines for the sybase system 11 odbc driver could not be loaded due to system error code 127.
It also gives the following message when I hit ok for the above message Driver's configdsn,configdriver or config translator failed could not load the setup or translator library.
Hi All, I have a database using Access 2003 as a front end and SQL as a backend. I set up all permissions in SQL and linked all tables to the Access frontend. After putting the front end on the network for other users, they receive the following error: ODBC — connection to <name> failed. (Error 3151) What do I need to do please
Hi guys, I have not posted to this site before, but I am wondering if someone knows about DTS ODBC source files and maybe if I am having some kind of permsissions problem.
I am trying to create a DTS import through SQL Server 2000 and pull data via an Advantage Database ODBC. I can seem to get it to work on a remote server with the Management tools installed, but if I try to schedule it as a task it fails.
Anywas the files are on one server and the odbc is installed coorrectly, but when i try to import the tables I get this error message:
http://qa3.com/images/sqlbomb.bmp
Any one know why this is happening?
My goal is to set a scheduled task to import these tables every night from an export that is written by another team.
All, I have SQL 2005 on a virtual server. I have an access frontend and SQL backend. I need users to test the database I am working on. I gave the permissions to access the database. Now, I am trying to set up the odbc connection but I get an error:
Connection Failed: SQLSTATE: '01000' SQL Server Error: 233 [Microsoft] [ODBC SQL server driver][DBNETLIB]Connection open (PreLoginHandshake()) Connection failed: SQLState: '08001' SQL Server error: 11 [Microsoft] [ODBC SQL server driver][DBNETLIB]General Network error. Chcek your network documentation
Is there something am missing because this is a virtual server? Is it considered a remote connection and I need to do something else that am not aware of? Thanks
I am using Windows XP Pro to remotely connect to a Windows 2003 Server/SQL Server 2005 database. This connection works fine for some, but not all, remote PC's. On the PC's that have a connection failure I get the following error:
Microsoft SQL Server Login
Conection Failed:
SQL State: '28000'
SQL Server Error: 18452
[Microsoft][ODBC SQL Server Driver][SQL Server] Login failed for user ''. The user is not associated with a trusted SQL Server connection.
I have looked up this error and most people suggest using mixed mode authentication, which I already am. This odbc source is logging in with a SQL Server account. The account information works correctly on some machines with the same ODBC connection properties as the PC's that fail.
The SQL Server 2005 machine is on an Active Directory Domain, but the PC's are on a remote workgroup environment.
When I look in the Event log for the SQL Server machine, the following error is also displayed.
Source: MSSQLSERVER
EventID: 17806
SSPI handshake failed with error code 0x8009030c while establishing a connection with integrated security. The connection has been closed. When looking up this error, people usually descibe firewall issues. But there is no firewall running on the SQL Server machine and the networks between the remote pc's and the SQL Server machine have hardware VPN's. Any help would be appreciated. Michael Pusatera
I have a ASP.Net application. I'm trying to access access data using SQL Server my web config has <add key="connectionString" value="DRIVER={Sql Server};Server=(local);initial catalog=ymquizco_registration;User ID=sa;pwd=test"/> MY CONNECTION STRING HAS THIS VALUE "DRIVER={Sql Server};Server=localhost;initial catalog=ymquizco_registration;User ID=sa;pwd=test" But the conn.Open();is throwing this error: {"ERROR [28000] [Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user 'WORK\ASPNET'. ERROR [01S00] [Microsoft][ODBC SQL Server Driver]Invalid connection string attribute ERROR [28000] [Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user 'WORK\ASPNET'. ERROR [01S00] [Microsoft][ODBC SQL Server Driver]Invalid connection string attribute" } My SQL Server is configured at mixed mode authentication. This seems like a install issue. Can someone think of something.
I have a web site that provides sport news and I am using SQL Server 7.0 as my back end. The ASP page connect to SQL Server through ODBC(3.70) connection using DSN configured using TCP/IP protocol. This site has been running for 8 months with no problems.
Today, the website page was showing network errror when it was trying to get the infomation from the SQL Server. So, when tried to reconfigure the DSN using TCP/IP prtocol I got the following error.
Connection failed: SQLState: '08001' SQL Server Error: 11
[Microsoft][ODBC SQL Server Driver][DBMSSOCN] General Network error. Check your documentation. Connection failed: SQLState: '01000' SQL Server Error: 10061 [Microsoft][ODBC SQL Server Driver][DBMSSOCN]ConnectionOpen(connect()) Connection failed: SQLState: 08001 SQL Server Error: 11 [Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]General network error. Check your network documentation. Connection failed: SQLState: 01000 SQL Server Error: 10061 [Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]ConnectionOpen (connect())
I am trying to install 7.0 on an NT 4 server and get an error message that says that some ODBC files need to be updated but cannot be because they are marked as read-only or are currently in use by another process. After checking the installation log file, the files in question are in the Temp directory and appear to be created and in use by the installation program itself. Any idea why this is happening and how I can get around it? Any help would be greatly appreciated.
One of my user is having trouble connecting to the database,i have already reset his pwd bt when she is trying to connect trhough application , he keeps getting this error
"Unable to connect to database
Sytem Error codes:[microsoft][ODBC SQL Server driver] SQL Server Log in failed for user 'Username'. [microsoft]ODBC SQL Driver] Invalid connection string attribute Data provider could not be initialized. please try again or contact adminstrator!
i am sure it is not psw issue because i have reset his psw Please help me out.
Hi, I'm new to SQL Server, but regularly connect to Oracle via ODBC. I'm trying to a) connect to our SQL Server over an ISP and b) Run Enterprise Manager over the ISP. Both actions work fine over our campus network but fail across an ISP.
The first returns the message: Connection failed:SQLState: '01000' SQL server Error: 1326 [Microsoft][ODBC SQL Server Driver][Named Pipes]ConnectionOpen[CreateFile()]. Connection failed:SQLState:'08001' SQLServer Error 1326 [Microsoft][ODBC SQL Server Driver][Client unable to establish connection
The second returns the message: Unable to connect to server [reason:[DB-Library]Unable to connect. SQL Server is unavailable or does not exist. Register anyway.
I had previously received a different error (in case 1) and, through the knowledge Base discovered I needed MDAC drivers for named pipes. I installed them but get a new error. I can find nothing in the KB or previous SWYNK messages.
When trying to access an ASP page connecting to a SQL database, I receive the following error from the driver
[Microsoft][ODBC SQL Server Driver][SQL Server]Create of work table failed because the row size would be 3697. This exceeds the maximum allowable size of a row in a table, 2014.
I can't remember if one of the sp_configure options handles this or not. Can anyone refresh my memory?
I have just restored a database which is quared thru a program written in visual basic. I need to set up the ODBC data source on the workstations and keep getting the error Sql server Error:4064 can not open user default database. Any ideas? also when you restore a database do the users & permissions come with the restore?
I tried to connect to the database server (running MS SQL Server 2000) using ODBC, but I got the error message "Connection failed". The SQLState is "HYT00". Does anyone know how to fix it. Thanks.
