Tracking Forums, Newsgroups, Maling Lists
Home Scripts Tutorials Tracker Forums
  Advanced Search
  HOME    TRACKER    MS SQL Server






SuperbHosting.net & Arvixe.com have generously sponsored dedicated servers and web hosting to ensure a reliable and scalable dedicated hosting solution for BigResource.com.







Microsoft OLE DB Provider For ODBC Drivers Error '80040e31'


 


View Complete Forum Thread with Replies
Sponsored Links:

Related Messages:
Microsoft OLE DB Provider For ODBC Drivers Error '
Hi guys

I wanna display the compname [in competencies tbl], firstname & surname [in users tbl], position level [in positions tbl] and userlevel [in compuser tbl] but i get the ff error msg

Microsoft OLE DB Provider for ODBC Drivers error '80040e14'
[Microsoft][ODBC SQL Server Driver][SQL Server]The column prefix 'CompUser' does not match with a table name or alias name used in the query.

My code:

SELECT compname, firstname,surname ,level AS positionlevel
FROM positions, compuser, users A, comppos
INNER JOIN Competencies
ON comppos.Compid = competencies.Compid
RIGHT JOIN Users
ON CompUser.UserID = Users.UserID
WHERE Users.UserID = '999209'
OR Users.UserID = 'helpdesk1'
OR Users.UserID = '999339'
OR Users.UserID = 'helpdesk5'
ORDER BY CompName

Pls kindly help
Noks

View Replies !   View Related
Microsoft OLE DB Provider For ODBC Drivers Error '80004005'
Hi everybodyMy problem with sql server is the following one:I've got my backoffice manager application done with asp technologythat works on sql server installed on Win2000 and running on IIS5.what I've done is simply doing a backup of my db and moving the aspapplication on another server: Windows 2003 with IIS6 and sql serververs.8.Then I tried to set up everything as in the beginning on the previousmachine(Win2K), but I'm getting this error:Microsoft OLE DB Provider for SQL Server error '80004005'[DBNETLIB][ConnectionOpen (Connect()).]Server SQL inesistente o accessonegato.(translated would be "SQL Server doesn't exist or access denied")/sitowebsite/bom/login.asp, line 13....where in the line 13 is set the connection to the database:Conn.Open Application("DBsource")which should be driven by what is set inside the global.asa file:Application("DBsource")="Provider=SQLOLEDB;server=127.0.0.1;database=db_nam e;uid=db_uid;pwd=db_pwd;"Application("WS_DB_TYPE") = ( "SQLSERVER" )I tried to restore the database just not losing information and nothinghappens.I tried also to create a new user and modify the properties as itshould be from the previous settings in the db(db_owner,....etc), stillnothing.any clue is appriciated.many thanks in advance.

View Replies !   View Related
Microsoft OLE DB Provider For ODBC Drivers Error '80040e14'
Hi guys, it's nice to join the forum. Can someone can help me?After 2 years of using a program, i suddenly got this error. I triedre-installing SQL but im still getting the message.Microsoft OLE DB Provider for ODBC Drivers error '80040e14'[Microsoft][ODBC SQL Server Driver][SQL Server]Cannot load the DLLxplog70.dll, or one of the DLLs it references. Reason: 193(error notfound).

View Replies !   View Related
Microsoft OLE DB Provider For ODBC Drivers Error '80040e07'
Microsoft OLE DB Provider for ODBC Drivers error '80040e07'

[Microsoft][ODBC SQL Server Driver][SQL Server]The conversion of a char data type to a datetime data type resulted in an out-of-range datetime value.

Our SQL - INSERT INTO tbl_WAAGUsage (logindate,logintime,countryname,subscriberid,ipad dress) VALUES ('2/16/2004','9:50:01 AM','Albania',62,'123456789')

Hi,

I was wondering if somebody could help me... the following error message appears when I run an asp page... I did a google search and nobody appears to have had a solution to the particular problem I have... it's completely baffling but I'm hoping it's a simple setting.

Firstly, I'm sure the coding the correct as the asp page runs on two different servers correctly. I recently got a new server and the script does not appear to work with the Date function in asp on this new server. I outputted the SQL to the browser and then ran it through the Query Analyser(QA) and guess what, it worked! But when I run the asp page the above error crops up... now when I run the SQL through QA and alter the date value in the format 'dd/mm/yyyy' the above error appears in QA.. if I've lost you at this point let me know...

The way ASP passes the Date value to my SQL DB appears to be confused and it's really confusing me as it works perfectly on two servers and not the new one... the new server runs newer versions of O/S and SQL so I'm not sure that is the case... I've changed the date settings on the server so they all three servers match each other... so I have no where else to turn... any help and pointers would be much appreciated!

Regards

Steve

View Replies !   View Related
Microsoft OLE DB Provider For ODBC Drivers Error '80040e4d'
hi all,

Can you please help me in following error , while connecting SQL Server and ASP



Microsoft OLE DB Provider for ODBC Drivers error '80040e4d'

[Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user 'Administrator'. Reason: Not associated with a trusted SQL Server connection.

/test2.asp, line 21

Thank you so much

Graceson

View Replies !   View Related
Microsoft OLE DB Provider For ODBC Drivers Error '80004005'
Microsoft SQL Server 6.50 - 6.50.416 (Intel X86)
Jan 23 1999 14:10:24
Copyright (c) 1988-1997 Microsoft Corporation

In a SP I generate the infor RDO in a temporate tables. When i call on ASP send this :
Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[Microsoft][ODBC SQL Server Driver]Protocol error in TDS stream
/asp/rdo/rdo_mty/automatico/rdoejecutivo.asp, line 10

View Replies !   View Related
Got Microsoft OLE DB Provider For ODBC Drivers Error '80004005' When Running Stored Procedures
when i am running a Stored Procedures, system always returns me error message below and Stored Procedures stops. please help

Microsoft OLE DB Provider for ODBC Drivers error
'80004005' 

[Microsoft][ODBC SQL Server Driver] Received an unrecognized datatype 0 from
TDS data stream  
 

sometime it returns error messge like, TDS Buffer Length Too Large
or
Unknown token received from SQL Server 

or 
Protocol error in TDS stream  
or 
Bad token from SQL Server: Datastream processing out of sync.  
or 
Invalid cursor state  
or 
TDS Buffer Link Too Large 
or 
Function sequence error

Many thanks, Please help, appreciated

View Replies !   View Related
Why I Get This Error:Microsoft OLE DB Provider For ODBC Drivers Error '80040e14'
When i run the web site in Windows 2003 Server,and I click on the "view" hyperlink to view customer infor,I got the error message as below:
Microsoft OLE DB Provider for ODBC Drivers error '80040e14'
[Microsoft][ODBC SQL Server Driver][SQL Server]Line 1: Incorrect syntax near '/'.
/bc/cust_info.asp, line 132
and the SQL statement in line 132 is as below:
strsql1 = "select sum(unit_price*qty) as SubTotal from dailySchedule where customer_code='" & request.QueryString("login") & _              "' and [date]=" & dbldate1
where [date] is reserved word
 
But,if I run the web in Windows 2000 Server,I don't get the error message as stated above.
Pls help.Thanks.

View Replies !   View Related
Microsoft Ole Db Provider For Odbc Drivers
I'm not able to see microsoft ole db provider for odbc drivers on sql server 2005. Anyone know which driver I should install to see it?
I'm trying to create a linked server from as400 to SS2K5.




http://www.sqlserverstudy.com

View Replies !   View Related
Can't Locate &&"Microsoft OLE DB Provider For ODBC Drivers&&" For Win Server 2003 X86
 

All,
 
Been serahcing frantically for this provider: "Microsoft OLE DB Provider for ODBC Drivers" for Windows Server 2003 x86.  However I can't seem to find it.  Supposedly MDAC 2.8 has it but when I go to install MDAC 2.8, nothing happens (this is acknowledged in fact in the support area on Microsoft and the given reason is that Win2K3 Server is already MDAC 2.8-compliant.  So no new stuff needs to be installed.  But alas this provider isn't in my list of available drivers).
 
Attempts to install any part of a lesser version of MDAC that says it has it are met with "Can't do that 'cause your current version of MDAC is higher that that."
 
I have been searching around all day on Msoft and other sites for such a beastie but like Brigadoon vanishing in the mist, it eludes me.  Msoft's main MDAC page is here:
 
http://msdn2.microsoft.com/en-us/data/aa937729.aspx
 
We need to use this kind of driver apparently with a certain Crystal Reports report or else it just won't run.
 

Thanks in advance for any advice/insights/DL links that work, etc...
 
Matt

View Replies !   View Related
Microsoft OLE DB Provider For DB2 In SSIS Vs. ODBC In DTS
I finally made data transfer between AS400 and SQL2005  work by using Microsoft OLE DB provider for DB2. I have tried other methods, some do not have build-in destination, some have unicode conversion problem. The only issue I have with this method is the peformance. For example, 300,000 rows load from AS400 take only 3 minutes with the ODBC connection in DTS, but more than 5 minutes with the microsoft OLD DB provider for DB2 in SSIS.

 

Does anyone have the same issue or figured out any tweaking that may speed up the transfer?

 

Thanks.

View Replies !   View Related
ODBC Drivers Error '80040e4d'
[Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user ''

How to fix this error...

View Replies !   View Related
ODBC Drivers Error '800040e31
Hi

I have encountered a following error:

Microsoft OLE DB Provider for ODBC Drivers error '800040e31
Microsoft ODBC SQL Server Driver timeout expired.

It is pointing to a line number in one the application's asp file.

Appreciate assistance very much. thks.
Krishna

View Replies !   View Related
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 !   View Related
Error :(provider: Named Pipes Provider, Error: 40 - Could Not Open A Connection To SQL Server) (Microsoft SQL Server, Error: 53)
Hi,

   I am trying to connect to my SQL Server 2005 but it gave me following error message.

 


TITLE: Connect to Server
------------------------------

------------------------------
ADDITIONAL INFORMATION:

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: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) (Microsoft SQL Server, Error: 53)

 

So, Please help me to solve this problem.

 

tnks.

View Replies !   View Related
ODBC Drivers, .NET Providers, OLE DB Providers, JDBC Drivers: Updated Lists
The driver and provider lists (below) have recently been updated and moved to anew web site (www.SQLSummit.com):ODBC drivershttp://www.sqlsummit.com/ODBCVend.htm..NET Providershttp://www.sqlsummit.com/DataProv.htmOLE DB Providershttp://www.sqlsummit.com/oledbven.htmJDBC drivershttp://www.sqlsummit.com/JDBCVend.htmDB2 Extendershttp://www.sqlsummit.com/extenven.htm

View Replies !   View Related
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 Replies !   View Related
Issues Using Parameterised Reports Connecting To Oracle Using ODBC And Microsoft OLE DB Provider For Oracle
I have an issue using parameterised reports connecting to Oracle using "ODBC" and "Microsoft OLE DB Provider for Oracle" using parameteried reports. The following error is generated "ORA-01008 not all variables bound (Microsoft OLE DB Provider for Oracle)" and a similiar one for ODBC. It works fine for simple reports. Do these 2 drivers have issues passing parameters for a remote Oracle query?
Thanks.
 

View Replies !   View Related
Microsoft OLE DB Provider For SQL Error
I have created a new dts job from my client SQL Server but I am not able to run it from here. If I run it on the server it runs fine but when I try to run it from my client I am getting an error
"Error Source: Microsoft OLE DB Provider for SQL Server

Error description:[DBNETLIB] [Connection open (Connect())] SQL Server does not exist or Access denied"

Query analyser is working fine with all my databases but not my jobs.

Can anyone help me please??

View Replies !   View Related
Error 7399: OLE DB Provider 'Microsoft.Jet.OLEDB.4.0' Reported An Error.Authentication Failed.
I am trying to create an excel file using openrowset in ms sql 2000.but i get the following error when I try to create the file...My stored procedure code is below as well...Error 7399: OLE DB provider 'Microsoft.Jet.OLEDB.4.0' reported an error.Authentication failed.What can I do?-- here is my codeCreate PROCEDURE MCA_SP_CREATE_EXCEL @File_Name as varchar(50) = ''ASBEGINSET NOCOUNT ONdeclare @File_Name as varchar(50)DECLARE @Cmd varchar(1000)DECLARE @fn varchar(500)DECLARE @provider varchar(100)DECLARE @ExcelString varchar(100)-- New File Name to be createdIF @File_Name = ''Select @fn = 'C:Test.xls'ELSESelect @fn = 'C:' + @File_Name + '.xls'-- FileCopy command string formationSELECT @Cmd = 'Copy C:Template.xls ' + @fn-- FielCopy command execution through Shell CommandEXEC MASTER..XP_CMDSHELL @cmd, NO_OUTPUT-- Mentioning the OLEDB Rpovider and excel destination filenameset @provider = 'Microsoft.Jet.OLEDB.4.0'set @ExcelString = 'Excel 8.0;Database=' + @fn-- Executing the OPENROWSET Command for copying the select contents to Excel sheet.exec('insert into OPENrowset(''' + @provider + ''',''' + @ExcelString + ''',''SELECT FirstName,LastName,Phone,Address,City,State,Zip FROM [Sheet1$]'') select au_fname as FirstName,au_lname as LastName,phone,address,city,State,Zip from authors')exec('insert into OPENrowset(''' + @provider + ''',''' + @ExcelString + ''',''SELECT StoreId, OrderNo, OrderDate, Quantity FROM [Sheet2$]'') select stor_id as StoreId,Ord_Num as OrderNo,Ord_Date as OrderDate,qty as Quantity from sales')SET NOCOUNT OFFEND

View Replies !   View Related
Microsoft OLE DB Provider For SQL Server Error '80004005'
Hi friends,

Can anyone help me in connecting sql server and asp.
Wheneever try to do the connection, I am getting following error. All the connection string which i am using are correct.

can you help me.

Following are the error line

----------------------------------------------------------------

Microsoft OLE DB Provider for SQL Server error '80004005'

Invalid connection string attribute

/MAsteringASP/global.asa, line 17

Microsoft OLE DB Provider for SQL Server error '80004005'

Invalid connection string attribute

/MAsteringASP/test2.asp, line 21
------------------------------------------------------

Please ckeck my code which I am using for connection


Thank you

Graceson MAthew

----------------------------------------------------------------
<%@ Language =VBScript %>
<% option explicit %>

<Html>
<head>
<title> Database Connection </title>
</head>
<body>
<%

<!-- #INCLUDE FILE="adovbs.inc" -->

dim conn
dim sql
dim r
dim aConnectionString

Set conn=Server.CreateObject("ADODB.Connection")

conn.Mode=adModeReadWrite
conn.Open="Provider=SQLOLEDB;UID=Administrator;Password=passw d;Initial Catalog=nrth;Datasource=server ip;Port Number= 80"


Response.Write (" Database Connectivity")

%>
</body>
</html>

View Replies !   View Related
Microsoft OLEDB Provider Error (with SQL Server And ASP)
Dear all,

Still i am having problem with connecting sql server with ASP (Intranet).

Following is the code which i am using for the connection now,

Set conn=Server.CreateObject("ADODB.Connection")
conn.open "DSN=aspfirst;Uid=;PWD=;"


The error mesage , generated by this code is attached with this mail. Please check the attachment and hel me in the same


Graceson

View Replies !   View Related
Microsoft OLE DB Provider For SQL Server Error &#39;80004005&#39;
Microsoft OLE DB Provider for SQL Server error '80004005'

Login failed for user 'TestMan'. Reason: Not associated with a trusted SQL Server connection.

/Default.asp, line 75


Please help me to solve this error. Thanks.

View Replies !   View Related
Microsoft OLE DB Provider For SQL Server Error '80040e37'
I get Microsoft OLE DB Provider for SQL Server error '80040e37'

Invalid object name '#t_testTemp484883646'. 
 when I run the following  ASP code:

------------------------------------------------------------Code is below---------------------------------------------------------

<!---#Include File="../includes/adovbs.inc" -->

<HTML>
<HEAD>
<META NAME="GENERATOR" Content="Microsoft Visual Studio 6.0">
<TITLE></TITLE>
</HEAD>
<BODY>

<%
 '----- Setup database connection
 Set DataCmd = Server.CreateObject("ADODB.Connection")
 Set rsData = Server.CreateObject("ADODB.RecordSet")
 Dim varTempTableName
 
 DataCmd.Open Application("DB")
 
 '----- Use a Temp Table so that it gets destroyed automatically in case the page times out
 '----- Use a Global Temp Table so that it is available across scopes when I open the record set below
 '----- Append a semi unique number to the end because its global it could conflict with another browser running the same report
 
 'varTempTableName = "##t_TestTemp" & Minute(Now()) & Second(Now())
 varTempTableName = "#t_TestTemp" & Session.SessionID
 
 
 strSQL = "Create Table " & varTempTableName & "(TestColumn2 int)"
 DataCmd.Execute strSQL
 

 strSQL = "select * from t_Test"
 rsData.Open strSQL, DataCmd, adOpenForwardOnly,adLockReadOnly
 
         
    
 Do While Not rsData.EOF
  varTestColumn2 = rsData("TestColumn2")
  
'Error occurs when I place the following insert statement. Code works with the global variable

  strSQL = "Insert into " & varTempTableName & " (TestColumn2) values (" & varTestColumn2 & ")"
  DataCmd.Execute strSQL
  
  rsData.MoveNext
 Loop
 
 rsData.Close

 strSQL = "Drop Table " & varTempTableName
 DataCmd.Execute strSQL

     
 Set rsData = Nothing
 Set DataCmd = Nothing
 %>
 
</BODY>
</HTML>


 

View Replies !   View Related
Microsoft OLE DB Provider For SQL Server Error '80004005' On Load Balancing
 

I have posted this also in one forum. Somebody might have idea here.

We have four Windows 2003 advance servers with SP 3 configured on NLB.
Each of them has one NIC.
Recently we started to get frequent time-out error messages from web applications on those servers when they try to establish the connection with the SQL 2005. If you run web pages application to connect to sql server 10 times, 9 times you will get good connection results and 1 time you will get time-out.

Microsoft OLE DB Provider for SQL Server error '80004005'
Timeout expired
/common/mypage.asp, line 20

Connection to sql server is established with the connection string. Any idea how to solve this problem? Is there a connectionproblem? from NLB to Web to SQL?


We have tried doing some suggestions (e.g. LMHOST, IP, domain account for WEb to SQL connection, the Query Wait in SQL advance property.), but seems this timeout expired still exist  

 

Thanks in advance...

View Replies !   View Related
Microsoft OLE DB Provider For SQL Server Error '80004005' On The Local Machine
 

Hi,
 
I using SQL 2005 on Vista machine.

 
After disconnected from VPN (Cisco) , I am not able to connect to my SQL. Getting the error Microsoft OLE DB Provider for SQL Server error '80004005'  Timed Out.
 
Restarting the SQL Server or Reset IIS, nothing works.
 
If I restart the machine, it works fine again.
If I don't connect to VPN, I have no problem. 
 
I am wondering that might be the problem. I enabled all the protocols.
 
Thanks
Venkat
 
 
 
 

View Replies !   View Related
OLE DB Destination - Microsoft OLEDB Drivers
Hi

 

I am using Microsoft OLE DB Drivers for DB2. Using these drivers, when i try to Build Query on the OLEDB Destination then the underlying DB2 schema is not visible. If I change the connection from DB2 to SQL Server/Oracle. I am able to view the underlying schema.

 

Is this a known issue for Microsoft DB2 Drivers?

 

Also when i try to insert data using these drivers and OLE DB Destination. For the columns which are not connected in the target component, i get this error:

 

Error: 0xC0202009 at MAPPING1 [694]: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80040E21.

An OLE DB record is available. Source: "Microsoft DB2 OLE DB Provider" Hresult: 0x80040E14 Description: "The value of input host variable or parameter number "36" cannot be used because of its data type. SQLSTATE: 07006, SQLCODE: -301".

 

If i remove these columns from the target component then the insert query executes.

 

Thanks,

Vipul

View Replies !   View Related
ODBC Drivers
Hi,

I have an ODBC question. They say that to use SQL server 7.0 'tools', one must use ODBC 3.70 drivers. Is there anywhere where I can find a list of these 'tools' that will need these drivers?

Thanks
Sach

View Replies !   View Related
Need Help For ODBC Drivers
Experts,

Will 32-bit ODBC Drivers work in 64- bit machine? I have already installed 32-bit ODBC drivers in 64-bit machine so i wanna make sure all applications work fine.

ALSO, Where can i get to download ODBC Drivers for
1) Oracle in Orahome 92
2)Sybase SQL Anywhere 5.0
3) Informix 3.8 32 bit
4) openlink

Is there any 64-bit drivers available for above ODBC Drivers?
PLease Help.Thanks

View Replies !   View Related
ODBC Drivers
Okay, this is a weird question/problem.  I have a 64 bit database server running on 64 bit Windows.  This is just fine until I moved a 32 bit database over to it.  My DB is trying to get some reporting to work and discovered that there are no ODBC drivers for Excel on this new 64 bit box.   Are there 64 bit drivers for MS Excel? And access for that matter?  If so, where are they?
 
Thanks.

View Replies !   View Related
SQL Server Error '80040e31': Please Help Me!
I have the following problem in a Win 2000 Server + SQL Server 2000environment and I hope somewhat can help me to resolve it (after manydays of useless attempts I am desperate).In my database I have two table:- master(id, field1, field2, ...)- detail(id0, id, progr, data, sede, esecutori, brani_autori)in a master-detail relation with "id" as foreign key.The fields of the "detail" table are:- id0: uniqueidentifier, primary key (newid() IsRowGuide=Yes);- id: uniqueidentifier, foreign key;- progr: bigint, Identity=Yes;- data: smalldatetime;- sede: varchar (100);- esecutori, brani_autori: text.In certain situations, in my asp site, I have to make a copy of a recordof "master" with all the linked record of the "detail" table.The code I've written to realize this task has been tested in manysimilar situations and has always worked fine (it is reported on the endof mail).With the two table above I have this strange behavior: when I attempt todo the copy of linked records in the "detail" table (using an "Insert"query), some records are correctly inserted, whereas for few otherrecords the Conn.Execute of the "Insert" query don't go and I receivethe message:Microsoft OLE DB Provider for SQL Server error '80040e31'Timeout expiredAfter many attempts I've reached these conclusions:1.It isn't the situation described in this faq:http://www.aspfaq.com/show.asp?id=2287because also using the IP for the "Data Source" the situation is thesame; on the other hand I have the problem also when there is only onerecord to copy in the "detail" table, so the problem is not the durationof the query.2.It isn't due to the contents of the record (at least not directly): if Isubstitute the contents of one of this records with simple text theerror persists, if I create manually a new record in "detail" and put init the data of the indicted record it is copied normally. So the problemseems to be the record itself and not its contents.3.The insert query work normally if I execute it from the Query Analizer.4.The problem seems to be due to the fact that, when I have a recordsetobject open on the table and pointed to one of this records, SQL Serverblocks the table and don't permit new insertion; in fact if I executethe same Insert query out of the code where the recordset object is openit works.Finally if the problem is the one of the point 4, I don't know thereason of this behaviour and how to resolve it.So, please, help me because it is of great importance for my work!Many, many thanksTonio Tanzi*** Code of the copy procedure ***....old_id_master= 'the id of the master record to copynew_id_master= 'the id of new master record (copy of the above)strsql="Select * From detail where id='" & old_id_master & "'"set rs=Conn.Execute(strsql)do while not rs.Eofstrsql="Insert Into detail (id, data, sede, esecutori, brani_autori)"& " Values ('" & new_id_master & "','" & data & "','" & _sede "','" & esecutori & "','" & brani_autori & "')"Conn.Execute(strsql)rs.movenextlooprs.closeThis code works good for the "good" records, don't words for the "bad"records, but if I force an insert for a "bad" record before or after thedo while-loop (i.e. when the rs is not pointed on a "bad" record) it works.

View Replies !   View Related
SQL Server ODBC Drivers
I have a lot of client machines that do not have the SQL Server ODBC driver installed. Without having to install SQL Server client on their computers, I'd much prefer to just install the driver itself. Where on earth do I get it? The microsoft website is about the most confusing site when it comes to looking for driver downloads.

View Replies !   View Related
Exchange ODBC Drivers?
Hi gang!

Are there any ODBC drivers or OLE DB providers for Exchange so that i can suck out data from Exchange 5.5 into SQL Server 7.0.

When i run DTS there are no drivers listed for Exchange at all.

Hope you can help.

Kyliedude :)

View Replies !   View Related
ODBC And SQL Server Drivers For 7.0
Hello,
We're upgrading to SQL Server 7.0 and need to update all our clients with the latest version of the ODBC and SQL Server Drivers. Can someone tell
how to update just these drivers? We tried to use the latest MDAC executable, but it broke applications on at least one client, so we were hoping
to narrow it down to just ODBC and SQL Server.
Thanks,
Dan Holland

dth@qad.com

View Replies !   View Related
Missing ODBC Drivers - Please Help!!
Hi all

For some reason, my Excel / Access drivers have disappeared from the list of available data sources when running the Import wizard or when trying to create a dts package. They are installed on the machine as I can see them through the ODBC Administrator. I have googled extensively, found some posts relating to TimeSlips (not relevant as not installed), re-installing MDAC.

Having done all the relevant stuff (updating to latest MDAC), still not coming up. Installed SQL 2005 Management Studio thinking that may help. Still nothing.Can someone please give me some advice, APART FROM RE-INSTALLING OS.

How does Import wizard pickup the available drivers, any registry settings...? Currently running XP SP2 with all the latest updates.

Need to get data uploaded to customer site from Excel spreadsheet. So any help / advice would be greatly appreciated!

TIA

Regan

View Replies !   View Related
Unexpected Error With Microsoft ODBC For Oracle
Hello Guy's

I've developed some DTS packages on SQL 7.0, transfering data from SQL 7.0 to Oracle 8.1.6.
Until a few day's ago, everthing worked fine. From my client workstation I
was able to edit, test and run these DTS packs.
But then, (after installing Oracle reports) it stop working. I've
already re-installed SQL 7.0 + SP3, Oracle 8.1.6 client, NT 4.0 service pack 6,
nothing works.

I always get the message :

HResult of 0x8000405(-2147467259) returned
Unexpected error occurred, An error result was returned without an error
message


Can anybody help me on this one??

Enrico Fantinel

e.fantinel@clivet.it

View Replies !   View Related
[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 !   View Related
How Do I Reinstall The SQL Server ODBC Drivers?
They are corrupt. I cannot get the odbc driver applet for sql serverto open when I click add and I cannot configure any existing ones. Andthe usage of the drivers fail.Other ODBC drivers work.Does anyone know how to reinstall the SQL Server set of ODBC drivers?MDAC wouldn't install, said it was already at current level.Thanks for any ideas.

View Replies !   View Related
Latest ODBC And SQL Server Drivers For SQL 6.5
What are the Latest ODBC and SQL Server Drivers for SQL 6.5? How can I upgrade them?

By the way, IS IT ABSOLUTELY NECESSARY to reboot the machine after application of a SQL Server service pack? (There is this dispute going on at my co.)

View Replies !   View Related
ODBC And SQL Server Drivers For 2000
Hello,

We're upgrading to SQL Server 2000 and need to update all our clients with the latest version of the ODBC and SQL Server Drivers. Can someone tell
after updating the ODBC driver to SQL 2000 would it support SQL Server 7.0 ?

Thanks

Sejal

View Replies !   View Related
ODBC Drivers And SQLServer 2000
Has anyone run into troubles connecting to an instance of SQLServer 2000
with older Microsoft ODBC drivers. In preparation for an upgrade, I am
trying to establish if there is a minimum ODBC version that is required for
client connectivity. I remember reading about such a minimum at one point,
but I can't relocate the reference

View Replies !   View Related
ODBC And SQL Server Drivers For 2000
Hello,
We're upgrading to SQL Server 2000 and need to update all our clients with the latest version of the ODBC and SQL Server Drivers. Can someone tell
How do I upgrade the ODBC driver so that they can connected to SQL 2000.
The client pc's have an older version of ODBC drivers which supports Sql 7.0 Which dll do I need ? ? Where do I get it? Does it have on sql 2000 cd?

Thanks

Priti

View Replies !   View Related
Using SSIS To Pull From ODBC Drivers?
Hi all,

I've been tasked to do some investigation at my workplace as to the best way to move forward with changing from our SQL 2000 DTS' to SQL 2005 SSIS packages.

Our main issue at the minute seems to be that we are using ODBC drivers to pull many of the raw tables which we then manipulate into our own SQL Server tables.

I've been looking about and am I right in saying there is an issue with this in SQL 2005?

Also, I've been looking for some Tutorials to help me on this, would anyone be able to push me in the right direction of any good tutorials that would help me in fixing these issues?

Cheers

View Replies !   View Related
Provider String For LinkedSrvr OLE DB Provider For ODBC (to Oracle RDB)
 

I have an ODBC connection setup for Oralce RDB. This works fine in say MSAccess. Now I would like to add a SQL Server Linked Server to this ODBC driver (it is for RDB not regular Oracle), but I am not able to get this to work. What is the Provider String and Location / Catalog for using this type of ODBC?  I setup DSN as 'name', Provider String as 'UID=user;PWD=pass;' and it seems it tries to connect but gives an error. "%SQL-F-SCHNOTDEF, Schema USER is not defined"
 
Any help is greatly appreciated.

View Replies !   View Related
Run-time Error 2147217871 (80040e31)&"
Hi guys,

I'm having a problem wiht this: Run-time error -2147217871 (80040e31)". There are times that this error does not occur. But there are times that this error occurs. I am using a third party software. And we don't have enough support at this moment. May I know what should I do. Moreover. We are using VB 6.0 for front end. Then SQL server 2000 for back end.

Thanks

View Replies !   View Related
Unix Client ODBC Drivers For MSSQL
Does anyone know of a good ODBC driver that allows a Unix client to access data on an MSSQL server? I found nothing listed in the Archives.

View Replies !   View Related
MySql SSIS Hangs With ODBC Drivers
Hi, we are writting a SQL Server Integration Services package to import data from a MySql database to a Sql Database.

We are using ODBC 3.51 Drivers to connect to the MySql Database in SSIS. The package runs perfectly in design mode. When we schedule the package to run, the package seems to hang about 1/3 of the times.

What can this be. We used to the package and ran it from a Sql Server 2005 to a Sql Server 2005 database. This setup works perfectly. When i'm doing MySql to Sql Server 2005, 1/3 of the times, it does not work.

Can anyone help me with this?

Giovan Gentile
Ayuda Media Systems

View Replies !   View Related
How Do You Reinstalling ODBC Drivers In Vista Business?
How do you reinstalling ODBC drivers in vista business?

I have installed SQL 2005 Express & SQL Server management Studio Express, with SP2

However, the required driver "SQL Server" is not showing up in the list when trying to add a datasource in System DSN.

Can someone help? please.

Regards
Solway

View Replies !   View Related
Different Behaviour SQLSERVER And SQLNative ODBC Drivers
I started a thread in the security forum because when my Legacy App called sp_setApprole in an implict transaction a Begin transaction was called (approle cannot be set in transaction so fails) in SQL2005, wheras the same code succeeds against SQL2000

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1124204&SiteID=1&mode=1

Have now established in a simple test bed that this is due to the use of a different ODBC driver. We used the SQLNative driver against SQL2005 when it failed. Using the SQLServer driver against SQL2005 meant that the call to sp_setapprole succeeds (ie the transaaction begins after, when required)

1) any thoughts on this?

2) Can I use the SQLServer driver against SQL2005 ? haven't seen anything that says I can or can't. As I am simply updating datastore (SQL2000 -> SQL2005) of a legacy application I don't need to access any new SQL2005 features until its completely written. If I can use the old driver has it been certified or tested against SQL2005 ?

Any assitance / guidance most welcome  

View Replies !   View Related
SQL Server Error '80040e31' Timeout Expired Strange.
 

Hi All,
 
we are working on a web application created in ASP & SQL 2000 environment.
In the code , we have a single connectionstring to connect database.
The application was running fine for the past 3 years, but all of a sudden we are getting "timeout expired" error only in someparts of the application but not on all database access.
The code which raises this error is a bit large which need to look into table of 8k recs with more conditions.
The same sql query took 1:01 minutes to execute in query qnqlyser.
I changes the script timeout to 900secs,
I herd we need to upgrade MDAC or we need to change connection timeout or we need to cahnge the code.
 
we cannot change the query, it is the most possible way we could get that.
 
Can somebody help me with the possible solution.

 
Thanks & Regards,
Sai. K.K

View Replies !   View Related
Latest Version Of ODBC Drivers For MSQL 2000
We are suffering from dropped connections to our MSSQL server which is version:

Microsoft SQL Server 2000 - 8.00.760 (Intel X86) Dec 17 2002 14:22:05 Copyright (c) 1988-2003 Microsoft Corporation Enterprise Edition on Windows NT 5.2 (Build 3790: Service Pack 2)

We are getting "ERROR: Prepare failed" from the application.

We suspect the ODBC drivers on the client may be old.

The ODBC driver on the client machine is version
2000.80.194.00. as taken from the driver tab in the odbc admin window.


I installed a 2000 base version of the client tools on my desktop and got an ODBC version of 2000.85.1117

I then installed the SP3a and the ODBC driver version did not change. What is the latest version of the driver for MSSQL 2000?

thanks
JB

View Replies !   View Related

Copyright © 2005-08 www.BigResource.com, All rights reserved