ODBC Error: [Microsoft][ODBC SQL Server Driver]Communication Link Failure
Hi
When I open design table in 2000 Enterprise Manager and clicked on Index properties tab ,I am getting following error "ODBC error: [Microsoft][ODBC SQL Server Driver]Communication link failure"
Please help me.
thanks in advance
mike
View Complete Forum Thread with Replies
Related Forum Messages:
Microsoft ODBC Sql Server Driver Communication Link Failure
I get the message Microsoft [ODBC Sql server driver]communication link failure error message in my VB 6 application with MSDE engine. This error does not happen often. My connection string is as below. "Provider=MSDASQL;Driver={SQL Server};Server=" & mSvrName & ";DATABASE=cnsClient;uid=uid;pwd=pwd" Please help.
View Replies !
[Microsoft][ODBC SQL Server Driver]Communication Link Failure
All, I need a help from you all. I am getting this error if the users are running the application which is connecting from MSAccess97 to SQL Server 2000. Error: [Microsoft][ODBC SQL Server Driver]Communication link failure I would appreciate if you send me the resolution for this problem. Thanks, Reddy
View Replies !
[Microsoft][ODBC SQL Server Driver]Communication Link Failure
Several of our customers are getting a message intermitantly throughout the day where the connection is closed. The message being generated is [Microsoft][ODBC SQL Server Driver]Communication Link Failure. These messages started in the last two weeks. Thanks for any direction that can be thrown my way. David
View Replies !
ODBC Communication Link Failure To SQL Server
Okay-- if anyone can solve this they are truly the SQL genius! We are getting this error when we run a VB program that we use to access an SQL database on a server across our network on a workstation. In fact we get this same error when we even run the program on the server where the SQL database is running or on any of our workstations. Here is the error message: 08501:[Micorsoft][odbc sql server driver] communications link failure Now the odd thing is that many other functions in the workstation application work fine and retrieve data from SQL but certain data requests by the workstation application fail with the above error message and we get this message consistently. Even though it appears that different workstations running the identical Vb application will get this error consistently but in different locations when running the application. We were running SQL 6.5 on an old server, with the workstation application for literally years without any problems. We also decided to upgrade to a new server, installed server 2000 operating system and the latest version of SQl -- moved all the databases pointed the workstations odbc at this new server and get exactly the same error in the same location in the workstation applications. The programmer that wrote the application and designed the database in SQL can't find the problem and a number of other computer "experts" also could not find the error. We did add a new linksys DSL router/firewall but everything kept working after this installation for several weeks so I don't know if this is the problem on the network. THe programmer also noted that he had problems using terminal services on our network to connect to his office computer and decided that there must be some network issues that are causing the ODBC communicaitions to fail and also terminal services to fail-- or of course they may be unrelated. Has anyone ever seen this ODBC communication error in their travels through SQL implementations? Any help will be greatly appreciated. If we can't fix this we will have to abandon a software application that has been used for over five years and just too complex to rewrite. Jeff Kilpatrick
View Replies !
Microsoft.Data.Odbc.OdbcException: ERROR [42000] [Microsoft][ODBC SQL Server Driver][SQL Server]
Hi Everybody, 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. Stack Trace: [OdbcException: ERROR [42000] [Microsoft][ODBC SQL Server Driver][SQL Server]Line 1: Incorrect syntax near ')'.] Microsoft.Data.Odbc.OdbcConnection.HandleError(IntPtr hHandle, SQL_HANDLE hType, RETCODE retcode) +27 Microsoft.Data.Odbc.OdbcCommand.ExecuteReaderObject(CommandBehavior behavior, String method) +838 Microsoft.Data.Odbc.OdbcCommand.ExecuteNonQuery() +80 Calgary.venues.Page_Load(Object sender, EventArgs e) in c:inetpubwwwrootCalgarySitevenuesvenues.aspx.vb:32 System.Web.UI.Control.OnLoad(EventArgs e) +67 System.Web.UI.Control.LoadRecursive() +35 System.Web.UI.Page.ProcessRequestMain() +731
View Replies !
[Microsoft][ODBC SQL Server Driver] Error
Hi everyone, I am getting the below error when I try to access the table in 2005 database through 3rd party application from the application server. “[Microsoft][ODBC SQL Server Driver]Connection is busy with results for another hstmt� This database was restored from sqlserver 2000, so the ODBC connection in the application server first was pointing to 2000 database and now its dropped and recreated to point to the 2005 database. I dont get this error message when I do the same action from my pc. I google'd on this error message, and I am not sure if the driver has to be upgraded or if there is anything else that I am missing here. Thanks much.
View Replies !
Error = [Microsoft][ODBC SQL Server Driver]String Data, Right Truncation
Hi ! I'm trying to load data in sql server table with Bulk Copy Program (BCP). I have the following errors. SQLState = 22001, NativeError = 0 Error = [Microsoft][ODBC SQL Server Driver]String data, right truncation SQLState = 22001, NativeError = 0 Error = [Microsoft][ODBC SQL Server Driver]String data, right truncation SQLState = 22001, NativeError = 0 Error = [Microsoft][ODBC SQL Server Driver]String data, right truncation SQLState = S1000, NativeError = 0 Error = [Microsoft][ODBC SQL Server Driver]Unexpected EOF encountered in BCP data-file In my File to load i have this : Hello1¤Hello2¤17/02/2004 TOTO1¤TOTO2¤17/02/2004 TITI1¤TITI2¤17/02/2004 My definition table is : create table tab1 ( TABLE varchar(20) null , PK varchar(50) null , DATE datetime null ) go I launch bcp with this command : bcp.exe "BASETEST.dbo.tab1" in "c: ab1.out" -c -CRAW -t¤ -m100 -Smyserver -U -P -o"c: ab1.log" The file "table1.out" is making with a C program. Do you have an idea ? Thanks.
View Replies !
[Microsoft][ODBC SQL Server Driver]Syntax Error Or Access Violation
Hi guys! I am using SQL 2005 and I wonder why I am encountering the error "[Microsoft][ODBC SQL Server Driver]Syntax error or access violation" everytime I am trying to create stored procedure with temp table and table variable. See my code below with temp table. Any thoughts will be appreciated! CREATE PROCEDURE DBO.SAMPLESP (@DETAILS AS VARCHAR(8000), @ID AS VARCHAR(15)) AS BEGIN TRANSACTION CREATE TABLE DBO.#TEMPTABLE { ASSET VARCHAR(50) } DECLARE @INSTINSERT AS NVARCHAR(4000) SET @INSTINSERT= 'INSERT INTO #TEMPTABLE(ASSET)' SET @INSTINSERT= @INSTINSERT+ @DETAILS EXEC sp_ExecuteSQL @INSTINSERT INSERT INTO InstDetail (TrackNum, ASSETID) SELECT @ID, A.ASSE FROM #TEMPTABLE A DROP TABLE #TEMPTABLE IF @@ERROR != 0 BEGIN ROLLBACK TRANSACTION RAISERROR('There was an error in here', 11, 1) RETURN END ELSE COMMIT TRANSACTION
View Replies !
How Can I Use Create Or Alter Statements With ODBC And Microsoft Access ODBC Driver (*mdb)?
Hi, I am using VB.NET 2005 and set up an ODBC connection via ODBC.ODBCConnection to a MDB database. Therefor, I use the "Microsoft Access ODBC Driver (*.mdb)". When I set up a ODBCCommand like "ALTER DATABASE..." or "CREATE TABLE..." and issue it with the com.ExecuteNonQuery() command, I get an error from ODBC driver, that a SQL statement has to begin with SELECT, INSERT, UPDATE or DELETE. How can I use DDL statements via ODBC? I would appreciate if you could help me to use ODBC for that - no OLE, no ADO. Thanks for help! Regards, Stefan D.
View Replies !
Runtime Error: [Microsoft][ODBC SQL Server Driver]Invalid Time Format
Hello All,I am getting the following error when attemping to open a table inSQL2kSP3a.________________________________________SQL Server Enterprise ManagerDatabase Server: Microsoft SQL ServerVersion: 08.00.0760Runtime Error: [Microsoft][ODBC SQL Server Driver]Invalid time format_________________________________________I cannot find it in sysmessages, or on the web.Any ideas about how to resolve this? And how it occured...Thanks,TGru*** Sent via Developersdex http://www.developersdex.com ***Don't just participate in USENET...get rewarded for it!
View Replies !
[Microsoft][ODBC SQL Server Driver][DBMSLPCN]General Network Error - While Installing 2k On VM Ware Machine.
Hi, In a VMWare machine already 2k5 has been installed. i am trying to install 2000 as a named instance on that machine . But at the end of Installation i am getting setup failed and to check the sqlstp.log file. The following error is found on that text File Starting Service ... SQL_Latin1_General_CP1_CI_AS -m -Q -T4022 -T3659 Connecting to Server ... driver={sql server};server=d1w9841gI01;UID=sa;PWD=;database=master [Microsoft][ODBC SQL Server Driver][DBMSLPCN]General network error. Check your network documentation. [Microsoft][ODBC SQL Server Driver][DBMSLPCN]ConnectionRead (WrapperRead()). driver={sql server};server=d1w9841gI01;UID=sa;PWD=;database=master [Microsoft][ODBC SQL Server Driver][DBMSLPCN]General network error. Check your network documentation. [Microsoft][ODBC SQL Server Driver][DBMSLPCN]ConnectionRead (WrapperRead()). driver={sql server};server=d1w9841gI01;UID=sa;PWD=;database=master [Microsoft][ODBC SQL Server Driver][DBMSLPCN]General network error. Check your network documentation. [Microsoft][ODBC SQL Server Driver][DBMSLPCN]ConnectionRead (WrapperRead()). SQL Server configuration failed. Could you please tell me what could be the issue. ?
View Replies !
Error String: [Microsoft][ODBC SQL Server Driver][SQL Server]Login Failed For User '(null)'. Reason: Not Associated With A Trus
Hi all This Job ran yester day fine,to day It got failed with this error any suggestion to troubleshoot problem is appreciated. DTSRun OnError: DTSStep_DTSTransferObjectsTask_1, Error = -2147203052 (80044814) Error string: [Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection. Error source: Microsoft SQL-DMO (ODBC SQLState: 28000) Help file: SQLDMO80.hlp Help context: 1131 Error Detail Records: Error: 0 (0); Provider Error: 0 (0) Error string: [Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection. Error source: Microsoft SQL-DMO (ODBC SQLState: 28000) Help file: SQLDMO80.hlp Help context: 1131 DTSRun OnFinish: DTSStep_DTSTransferObjectsTask_1 DTSRun: Package execution complete.
View Replies !
Help! SQL Server Error - [Microsoft][ODBC SQL Server Driver][SQL Server] Invalid Object Name ...
Dear all,On Win2000 server with SP3, I am trying to access a SQL Server 7.0database, "TestDB", from VB6 via a SQL Server ODBC system DSN using ADO2.7. In SQL Server Enterprise Manager, there is a login named "Tester".In its property window, NO "Server Roles" was assigned but its"Database Access" was set to "TestDB". This login was also made as theuser of "TestDB" with "public", "db_datareader" and "db_datawriter"selected as its "Database role membership". All the tables I am tryingto access in "TestDB" were created under "Tester".My code is like:Set conn = New ADODB.Connectionconn.Open "DSN=TestDSN;UID=Tester;PWD=test"Set cmd = New ADODB.Commandcmd.ActiveConnection = conncmd.CommandText = SQLset rs = cmd.Execute()If I set the SQL to something like "SELECT * FROM tbl_test", I alwaysget an error of "-2147217865" saying "[Microsoft][ODBC SQL ServerDriver][SQL Server] Invalid object name tbl_test". If I set the SQL to"SELECT * FROM Tester.tbl_test", everything runs properly. Could anyoneplease kindly advise why the first SQL is not working? Or in otherwords, why must I prefix the table name with its owner while the DBconnection is already made under that owner name? Thanks in advance.Tracy
View Replies !
Compatible Versions Of Ms SQL Server, ODBC Driver, Driver Manager And ODBC API Spec
Hi, Please help share with me if you know the version compatibility matrix of Ms SQL Server, ODBC driver (sqlsrv32.dll), Driver Manager (odbc32.dll) and ODBC API spec. For instance, how can I know Ms SQL Server 2000 can work with which version of sqlsrv32.dll, a particular version of sqlsrv32.dll can work with which version of odbc32.dll and a certain version of sqlsrv32.dll/odbc32.dll conforms to which version of ODBC API spec (e.g. 3.5). Any help will be appreciated. Thanks, vtluu.
View Replies !
[Microsoft][ODBC SQL Server Driver] Timeout Expired
Hello, I've registered another SQL Server 2000 via another SQL Server 2000 and I'm getting the error message in the title line above when I try to open a view in SQL Server, this is after about 15 seconds. It looks like an ODBC connection timesout while connecting to the remote server, but I do not know how to access it's properties. I'm unable to find where this time out can be reset. I reset the query timeout in the properties of where the server is registered but this is not having any impact. MDAC 2.7, 2.7 and 2.8 are installed on this machine. Any help would be very much appreciated. TIA, Rod
View Replies !
[Microsoft] [ODBC SQL Server Driver] Timeout Expired
I've tried every websearch possible to try and get a solution for this problem but can't. Development Software: SQL Server 2000 Enterprise Manager 8.0 Query Analyzer 8.00.194 Error: When I run a mildly complex view in Enterprise Manager I get the error:[Microsoft][ODBC SQL Server Driver]Timeout Expired after about 30 seconds. When I copy and paste and run the exact same code in Query Analyzer the Query runs for longer than 30 seconds and runs until completion. Now my question is since this apparently seems to be an Enterpise Manager problem and not on the server end, where do I go in Enterprise Manager to change that setting? I've looked everywhere in Enterpise manager and can't find a "command timeout" setting. Thanks!
View Replies !
[Microsoft][ODBC SQL Server Driver] Timeout Expired
Hello, I installed MS SQL Server 2000 Evaluation Edition on Windows XP Pro. I have database on the same PC. When I am running a query(view) from Query Analyser I get "[Microsoft][ODBC SQL Server Driver] Timeout Expired" error message . When I am running the same view on smaller amount of data it works. :confused: Could you please help me with that? Thanks DJ
View Replies !
Microsoft][ODBC SQL Server Driver]Timeout Expired
Hi all, I inherited some really twisted asp pages from another developer that crank for a long time. They used to work, albeit slowly. Now when I try to run one I get the error: Microsoft OLE DB Provider for ODBC Drivers error '80040e31' [Microsoft][ODBC SQL Server Driver]Timeout expired Short queries run fine. IIS4 & SQL Server are on the same box. I didn't the ASP pages or the IIS or SQL server config. I did install VStudio 6.0 a while back. Anybody got any clues?
View Replies !
[Microsoft][ODBC SQL Server Driver]Timeout Expired
I am running a query which pulls back about 200,000 records. When I run this in ISQL (SQL Server 6.5), it runs in almost 2 minutes. When I put it in a store procedure and run it off my ASP application, I get this error [Microsoft][ODBC SQL Server Driver]Timeout Expired We've tried many things including: 1) Increased connection and command time outs in Global ASA 2) Have the ODBC driver log long Quires to a file 3) Changed Query Time out in Enterprise Manager(360 seconds) Go to tools --> Preferences/configure -->Connection Tab 4) Changed Maximum allowed open database from 20 to 200 5) Changed resource timeout to 360 seconds from 5 seconds 6) Changed remote query timeout to 0, allowing infinite wait. What else can we try??? Thanks for taking the time to read this Joyce
View Replies !
[Microsoft][ODBC SQL Server Driver]Timeout Expired
Thank you to all who reply to this perplexing question. Mike Database VMFGSRVRVMFG is SQL 2000 Std. Database NT002P_GL is SQL 7.0. All SQL versions are at the current SP levels. I receive the timeout message when I am in EM, database,VMFG(database), Views, Open View, Return All Rows. I can successfully run the code in QA. I believe I am running up against a time parameter in SQL Server. I have reviewed all time parameters that I can find. However, I still receive the error. What parameters should I be looking at? I am attempting to create a view with the following code: -------------- CREATE view uv_olap_adj_co_profit as select customer.id as customer_number, customer.name as customer_name, customer_order.salesrep_id as salesperson, isnull(customer.country, 'USA') as country, '7' as business_unit, customer_order.order_type as order_type, uv_olap_co_profit.customer_order, uv_olap_co_profit.work_order, uv_olap_co_profit.close_date, uv_olap_co_profit.period_year, uv_olap_co_profit.gl_period, isnull((uv_olap_co_profit.billing + ut_man_adj.billing) *ut_fin_adj.billing, uv_olap_co_profit.billing*ut_fin_adj.billing) as billing, isnull((uv_olap_co_profit.material_cost + ut_man_adj.material)*ut_fin_adj.material, uv_olap_co_profit.material_cost*ut_fin_adj.materia l) as material, isnull((uv_olap_co_profit.labor_cost + ut_man_adj.labor) *ut_fin_adj.labor, uv_olap_co_profit.labor_cost*ut_fin_adj.labor) as labor, isnull((uv_olap_co_profit.burden_cost + ut_man_adj.burden) *ut_fin_adj.burden, uv_olap_co_profit.burden_cost*ut_fin_adj.burden) as burden, uv_olap_co_profit.service_cost as service from uv_olap_co_profit, ut_man_adj, ut_fin_adj, customer_order, customer where uv_olap_co_profit.customer_order *= ut_man_adj.cust_order_id and uv_olap_co_profit.work_order *= ut_man_adj.work_order and uv_olap_co_profit.period_year = ut_fin_adj.year and uv_olap_co_profit.customer_order = customer_order.id and customer_order.customer_id = customer.id and (customer_order.salesrep_id = 'LABELAIREP' or customer_order.salesrep_id = 'OMOHUNDR' or customer_order.salesrep_id = 'EGGERSR') union all select customer.id as customer_number, customer.name as customer_name, customer_order.salesrep_id as salesperson, isnull(customer.country, 'USA') as country, customer.user_2 as business_unit, customer_order.order_type as order_type, uv_olap_co_profit.customer_order, uv_olap_co_profit.work_order, uv_olap_co_profit.close_date, uv_olap_co_profit.period_year, uv_olap_co_profit.gl_period, isnull((uv_olap_co_profit.billing + ut_man_adj.billing) *ut_fin_adj.billing, uv_olap_co_profit.billing*ut_fin_adj.billing) as billing, isnull((uv_olap_co_profit.material_cost + ut_man_adj.material)*ut_fin_adj.material, uv_olap_co_profit.material_cost*ut_fin_adj.materia l) as material, isnull((uv_olap_co_profit.labor_cost + ut_man_adj.labor) *ut_fin_adj.labor, uv_olap_co_profit.labor_cost*ut_fin_adj.labor) as labor, isnull((uv_olap_co_profit.burden_cost + ut_man_adj.burden) *ut_fin_adj.burden, uv_olap_co_profit.burden_cost*ut_fin_adj.burden) as burden, uv_olap_co_profit.service_cost as service from uv_olap_co_profit, ut_man_adj, ut_fin_adj, customer_order, where uv_olap_co_profit.customer_order *= ut_man_adj.cust_order_id and uv_olap_co_profit.work_order *= ut_man_adj.work_order and uv_olap_co_profit.period_year = ut_fin_adj.year and uv_olap_co_profit.customer_order = customer_order.id and customer_order.customer_id
View Replies !
[Microsoft][ODBC SQL Server Driver]Timeout Expired
Hi, I have tried updating the DSN configure option i.e. 30000 milliseconds. But I am still facing the problem of Timeout Expired. I am using sql server 2005 for daily importing data from Excel Dump Files into sql server table. Everyday the database gets updated. The Error mentioned in Subject normally gets once a month, due to daily updation of database whether each table structure gets changed like index, trigger, etc. Kindly let me know how to resolve this error. Regards, Srinivas Alwala
View Replies !
Resolution Of Following Error: IM010: [Microsoft][ODBC Driver Manager] Data Source Name Too Long
Hi SQL Server Team, In order to add a data source by using ODBC Administrator, programmatically i am using SQLConfigDataSource. Thus calling SQLConfigDataSource with the fOption set to either ODBC_ADD_DSN for creating a new DSN. Following is the stattement specified in the source code. where type_of_driver = "Microsoft Access Driver (*.mdb)"; and parameters contains the data source source credentials information such as DSN, UID, PSW, FIL, Description, DataDirectory,DEFAULTDIR and DBQ all separated by " ". rc = SQLConfigDataSource(NULL, ODBC_ADD_DSN, type_of_driver, parameters); after execution of below mentioned command an error is encountered i.e -1 is returned if the DataDirectory path exceeds certain nested directories link. for eg. the file path specified below. C:My DocumentsClients CurrentAHW Netcare BenefitsDeliverables1-5 Results Chain - system LevelAlberta NetcareBenefits Logic System Level V01.rcm Creating a datasource with the file name i.e Benefits Logic System Level V01 every time. rc = :: SQLConnect(hDbc, (unsigned char *)szSource, SQL_NTS, (unsigned char *)szUserName, SQL_NTS, (unsigned char *)szPassword, SQL_NTS); Also following error message was encountered during execution of SQLConnect command. /*szErrorMsg = 0x0012e834 "[Microsoft][ODBC Microsoft Access Driver]General error Not enough information to connect to this DSN with SQLConnect. Use SQLDriverConnect."*/ Thus followed the instruction smentioned in the error message an dtried using SQL DriverConnect() in the following manner. rc = :: SQLDriverConnect(hDbc, NULL,(SQLCHAR *)"DSN=RCM",SQL_NTS,outstr, sizeof(outstr), &outstrlen,SQL_DRIVER_NOPROMPT); Still an error is encountered but this time it returns a RETCODE of 100 whrease earlier it had returned -1. Inform the procedure to be followed using SQLConnect when DataDirectory path is too long. An early reply will be appreciated. Cheers & Regards, Saresh
View Replies !
[Microsoft][ODBC Driver Manager] Data Source Name Not Found And No Default Driver Specified
trying to install sql server2005 on a windows 2003 server box. getting msg below at the sql server . i looked at other posts on trying to uninstall SQL Native Access Client and norton antivirus. i could never find the snac on the add - remove programs and this server does not have a virus protection program yet. here's the history of the installs on the server: wanted to test a 2005 upgrade so: 1) installed sql server 2000 then sp4 then restored some databases to it - all OK 2) tried to upgrade to sql 2005 but ran into problems and left it at that. had a disk drive crash on the d drive so lost the installs but not the operating system when the drive was replaced, left alone for a while then wanted to test a straight 2005 install 1) removed the broken 2005 attempt 2) removed the 2000 3) installed 2005 and got the error on the subject line: TITLE: Microsoft SQL Server 2005 Setup ------------------------------ SQL Server Setup could not connect to the database service for server configuration. The error was: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified Refer to server error logs and setup logs for more information. For details on how to view setup logs, see "How to View Setup Log Files" in SQL Server Books Online. i've gone through as many of the forums that i can and have tried several things - like uninstalling 2005 and installing pieces and parts but but nothing seems to work. Thanks! Dan <><
View Replies !
[22003][0][Microsoft][ODBC SQL Server Driver]Numeric Value Out Of Range
Hi,I have a php application connected through odbc to a sqlserver database.When I try to execute select queries on a smalldatetime table field Ireceive this message:Warning: [22003][0][Microsoft][ODBC SQL Server Driver]Numeric value out ofrangeThe query is something like:select dateField from tableTha field is a normal smalldatetime one:10/17/2001 12:35:00 PMWhith Query Analyzer the query works fine.I'm using php mssql_query() and ODBTP as protocol to connect to the DBMSThanksLuigi--Message posted via http://www.sqlmonster.com
View Replies !
S1T00[Microsoft][ODBC SQL Server Driver]Timeout Expired
I created a new publication on the publishing server and then run the sync task. When I start the distribution task, it gives the error S1T00[Microsoft][ODBC SQL Server Driver]Timeout expired The changes made to the publishing database are reflected on the distribution database but are not commited on the subscribing database. I run the sync task again and restart the distribution task but does'nt work. Can anyone figure it out? Thanks in advance Pranav
View Replies !
28000: [Microsoft][ODBC SQL Driver][SQL Server] Login Failed
This one may stump the experts.... Feel like a challenge? The application is VB 4.0, running on a SQL 6.5 DB. The company downsized and only one pc was left to access the application/database, which is mission critical (don't get me started ;-) The current administrator rebuilt this pc and in the process application no longer connects to the DB. The error received is 28000: [Microsoft][ODBC SQL Driver][SQL Server] Login failed Here is where is gets strange. The I've tested from the pc and while I can connect with the appropiate ODBC source driver when using MS Access, when attempting the same with MS Query it gets weird. The tables are displayed, but attempting to access the data results in the following error: incorrect syntax near 'sps.dbo'. Attempting the same from another PC resulted in the ability to access the tables and the data. I removed the File and System and User DSNs that referenced the subject database and recreated them. They test fine, but the problem discribed above persists. Has anyone else experienced a similar problem?
View Replies !
Communication Link Failure Error
Hi Y'all, When i alter 1 single value in my sql server 2000 sometimes i get following error: 1) [MICROSOFT][ODBC SQL SERVER DRIVER] Communication link failure After clicking away: 2)CANNOT START MORE TRANSACTION ON THIS SESSION Maybe someone can help me out on this? Thanks!
View Replies !
Communication Link Failure Error
Hi, I am using ADO in my application to connect and retrieve data from Microsoft SQL Server 2000 SP4. When I start my application, it establishes connection to the server successfully and I am able to retrieve data from the server. here is my test scenario: 1. unplug the network cable from the client machine and put the cable back in after some time. I disconnect from the database in my code when the client machine disconnects from the network 2. Once the client machine comes back on the network, I try to reconnect and retrieve data from the sql server but I get the following error message when I try to execute a sql command: [Microsoft][ODBC SQL Server Driver]Communication Link failure This problem occurs only with Window XP SP2. With XP SP1 it works fine. It seems to be problem on the client side as with Windows XP SP1 I do not get this error message at all. Here are the various details: 1. The firewall is off on the client workstation. 2. the connection string is: driver={SQL Server};server=AA;uid=BB;pwd=CC;database=DD where AA = DNS name of server machine where sql server is running. BB = user name CC = password DD= database name 3. The client is remote to the server. 4. I can ping the server machine when the client machine reconnects to the network. 5. I can still telnet the server when the client machine reconnects to the network. 6. client database provider is MDAC odbc. 7. the client and server machines are in the same domain. 8. Shared memory and TCPIP protocols are enabled and TCP is at the top of the list. 9. No alias is being used. 10. Viris scan is not installed. 11. force encriptioned is NOT checked. Please reply.
View Replies !
[Microsoft][ODBC SQL Server Driver][Shared Memory]ConnectionRead (recv()).
I am getting following error from time to time while running my application. Stopping and starting application leads to sometimes resolve the issue and in some instances i have to perform few retries. Any idea as to what might be happening. I am working with SQL 2005 SP2. Addi SQL State: 01000, ErrorCode 10054, ErrorMessage: [Microsoft][ODBC SQL Server Driver][Shared Memory]ConnectionRead (recv()).
View Replies !
Communication Link Failure - Error 08S01
I have seen a couple of postings on this problem (http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=185471&SiteID=1), but I need to relate what is going on to see if there are any specific remedies. We are performing a replication fine on our own network. We are attempting to push a transactional replication to a SQL server located at another computer (contractual obligation). We made the first attemp this past Saturday, and it ran find during the initial tests. Come Monday morning, it was broken. We made another copy of the replicated database, delivered it to the other company, started up the replication again, and it was running fine for the rest of the day. The next morning, the same problem, it was broken - Communication link failure - error 08S01. Since we are performing replication internally without any problems, I know that the problem resides in the ISP network between us. Are there any settings within the SQL server that can keep the connection alive during the downtimes over night? We are both using SonicWALL firewalls, and have rules enabled to push the SQL traffic to each other, specifically. Should we see if there are any rules that we can try to use on the firewall to keep those connections alive? I'm trying to stay away from VPNs at this time as it will open up more that I want to on each other's networks (without really having to get into the nuts and bolts of the VPN settings). Any help would be greatly appreciated. Ken Schall
View Replies !
[Microsoft][ODBC Microsoft Access Driver] System Resource Exceeded
odbc_pconnect() [function.odbc-pconnect]: SQL error: [Microsoft][ODBC Microsoft Access Driver] System resource exceeded., SQL state S1001 in SQLConnect we got the error with access 2000 database and PHP as prog. language . we created dsn for the connection. reboot solves the problem. but we need another solution better than this.
View Replies !
Communication Link Failure + General Network Error
Hi Folks, This is regarding the intermittent failure of communication between the application server and database server in one of our customer environment. Application error as well as SQL error log shows "General Network Error","Communication Link Failure". Please find below the server configuration Application Server OS: Win 2003 server + Service Pack1, Standard Edition Database Server OS: Win 2003 server + Service Pack1, MS SQL Server 2000 + SP4 We have checked the Client/Server Network utility associated with SQL Server and found TCP/IP protocol is used in communication neither than Named Pipes. DSN is used. We have also followed and implemented as per one KB article which mentioned Win 2003 server's feature of preventing Denial of Service attacks (Chance may be there to prevent the valid login packets).We made the registry changes and disabled this feature. A scheduled job which updates the database happens every morning. Also backup was done using a backup utility which needs the exclusive access to DB. So we have asked the customer to use enterprise manager for back up the DB instead of using the other utility to backup. If any one have experienced the same issue, please let me know. Thanks, Pranav.
View Replies !
[Microsoft][ODBC SQL Server Driver][SQL Server]Login Failed For User 'ErrorLog'.
Hi, all recently, I use the following script(somebody else) to create a database on a remote server: the script is as follow: /*************************/ CREATE DATABASE [ErrorLog] GO Use ErrorLog CREATE TABLE [dbo].[Errors] ( [ID] [int] IDENTITY (1, 1) NOT NULL , [SessionID] [char] (12) NULL , [RequestMethod] [char] (5) NULL , [ServerPort] [char] (5) NULL , [HTTPS] [char] (3) NULL , [LocalAddr] [char] (15) NULL , [HostAddress] [char] (15) NULL , [UserAgent] [varchar] (255) NULL , [URL] [varchar] (400) NULL , [CustomerRefID] [varchar] (20) NULL , [FormData] [varchar] (2000), [AllHTTP] [varchar] (2000), [ErrASPCode] [char] (10) NULL , [ErrNumber] [char] (11) NULL , [ErrSource] [varchar] (255) NULL , [ErrCategory] [varchar] (50) NULL , [ErrFile] [varchar] (255) NULL , [ErrLine] [int] NULL , [ErrColumn] [int] NULL, [ErrDescription] [varchar] (1000) NULL , [ErrAspDescription] [varchar] (1000) NULL , [InsertDate] [datetime] NOT NULL ) ON [PRIMARY] --Create the user "ErrorLog" if not exists (select * from master.dbo.syslogins where loginname = N'ErrorLog') BEGIN declare @logindb nvarchar(132), @loginlang nvarchar(132) select @logindb = N'Navigator', @loginlang = N'us_english' if @logindb is null or not exists (select * from master.dbo.sysdatabases where name = @logindb) select @logindb = N'master' if @loginlang is null or (not exists (select * from master.dbo.syslanguages where name = @loginlang) and @loginlang <> N'us_english') select @loginlang = @@language exec sp_addlogin N'ErrorLog', 'secret', @logindb, @loginlang END GO if not exists (select * from dbo.sysusers where name = N'ErrorLog' and uid < 16382) EXEC sp_grantdbaccess N'ErrorLog', N'ErrorLog' GO Grant select, insert On Errors to ErrorLog /***************************/ in my *.asp program, I used the following string to connect to the database on the remote server. /******** con.open "dsn=ErrorLog;uid=ErrorLog;pwd=secret;" ********/ the following message comes up: /********/ Error Type: Microsoft OLE DB Provider for ODBC Drivers (0x80040E4D) [Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user 'ErrorLog'. /*********/ what is the problem here? when I set up dsn ErrorLOG, I used "abc" userID and password "XXX" which is our server database administrator assigned to me. I tested connection in odbc, it is OK I just don't get, ther user ErrorLog already had login id and granted access to database errorlog. any clue, please help! Betty
View Replies !
1[Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server Does Not Exist Or Access Denied.
Hi, when I was sending 50 simultaneous connections to the web services, I got these 2 errors: - "1[Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not exist or access denied. " - "An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: TCP Provider, error: 0 - A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond.)" Everything worked fine if I ran 10 simultaneous connections. I am using Microsoft ACT to load test the web service. The database is SQL Server 2000. Any idea about why this is happening? Appreciate your help! Thanks! Jason Zhu
View Replies !
28000[Microsoft][ODBC SQL Server Driver][SQL Server] Login Failed
The following error occurs whenever I attempt to start the distribution task which starts up using login 'repl_subscriber' ---> 28000[Microsoft][ODBC SQL Server Driver][SQL Server] Login failed <--- Now, I have publishing/subscriber operations going on with other SQL Servers and they are working. I am able to use ISQL/W and connect using repl_subscriber, sa, Administrator, repl_publisher from either of the 2 SQL Servers involved with the problem. All SQL Servers (4) are running 6.5; (3) have SP5a applied. (1) has only 6.5 w/o any SP applied. ODBCPING works fine to both SQL Servers involved using sa, Administrator, repl_subscriber, repl_publisher logins. All logins are set to using 'US_English' as the default language. All are in the same NT Domain. All are using named pipes for the default client library --- of the 2 involved, the named pipes versions are not the same. All are configured for Standard Login security. Does anyone know exactly what I am missing? T.J. Roberts mailto:roberts@organize-it.com
View Replies !
[Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]Encryption Not Supported On SQL Server
hi experts, I have two machines one has sql server 2000 over windows 2000 sp4 and another is oracle 9i over windows 2000 sp4 .. and so many other users are on the network .. all other users are using xp and connect easily with sql server . so there is no issue between the xp users and sql server .. but when i tried to connect win2k server ( Oracle machine ) it gives me error ......[Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]Encryption not supported on SQL Server.... i already checked that wither encryption is on or off ..... but encription is off on sql server and check each and everything that is possible .. but still i cant make connection between win2k to win2k machine .. ...after that i install one more machine with a same operating ssystem and make it connect .. it connect easily .. it means .. there is a problem with that machine ..and we cant install it again right now .. now any body tell me what is a reason and why it happins .. and what is the solutions regards anwer
View Replies !
37000[Microsoft][ODBC SQL Server Driver][SQL Server]Login Failed- User: Reason: Not Associated Wit
I have sql6.5 push replication to many remote subscribers. Need add one subscriber sql6.5 "XYZ"(all are in the same domain), got error of <<37000[Microsoft][ODBC SQL Server Driver][SQL Server]Login failed- User: Reason: Not associated with a trusted SQL Server connection>>. I apply the same settings for "XYZ" sql executive like other subscribers with domainuserABC and assign it as the target server "XYZ" admin group. There is no problem in stop and restart the "XYZ" sql executive service. But at the time from the publisher to subscribe the XYZ, the task list show above error. MSSQLServer service logon with System Account option. This is a production issue, and I have spent around 2 days already. Thanks for help David
View Replies !
37000[Microsoft][ODBC SQL Server Driver][SQL Server]Login Failed- User: Reason: Not Associated With
I have sql6.5 push replication to many remote subscribers. Need add one subscriber sql6.5 "XYZ"(all are in the same domain), got error of <<37000[Microsoft][ODBC SQL Server Driver][SQL Server]Login failed- User: Reason: Not associated with a trusted SQL Server connection>>. I apply the same settings for "XYZ" sql executive like other subscribers with domainuserABC and assign it as the target server "XYZ" admin group. There is no problem in stop and restart the "XYZ" sql executive service. But at the time from the publisher to subscribe the XYZ, the task list show above error. MSSQLServer service logon with System Account option. This is a production issue, and I have spent around 2 days already. Thanks for help David
View Replies !
Communication Link Failure C++ && SQL Server
Hi Guys, I am using C++ (Ver 6) that connects to a SQL Server 7 DB using ODBC drivers. The apps connects to the database in the start and listens to the users requests and replies with the required data. The apps is working fine, but once in a while it looses connection and gives "Communication link failure" message. I just restart the apps and it is able to reconnect and perform as normal without any problems. I am not able to find the reason as this behaviour as its very much unpredictable! The error is returned by SQLExecDirect() function. The question is, since I still have the Connection Handle, is it possible to just reconnect to the database re-using the same handle ? or do I have any other choices ? Thanks in advance. Faisal.
View Replies !
|
TRACKER
