Hi, When I query a table selecting for one column [Varchar (1000) ] and for all the rows in the table, I get an ODBC error. However, the error is not very consistent and it breaks off with this message at different output levels. (i.e. sometimes it breaks off after 10000 + or 25000 + rows...more >>

I have a problem with memory leakage sql 2000 sp3. Does any body have the answer. ...more >>

Is there a way to set the ODBC driver for SQL server or SQL server to return this error message when trying to navigate on an empty database table. I have one site running Sybase 11 that allways returns this message, whereas I develop on SQL Server that doesn't. I have tried to find all the p...more >>

Hi every body, I'm new in SQL 2000, I wish to acces an ODBC table from within my SQL2k database. How can i do that. Thanks for your help. Q.S. PHU ...more >>

ODBC Error Microsoft][ODBC SQL Server Driver][SQL Server] Could not find stored procedure ...more >>

I'm using Dharma ODBC to create a linked server to a databalse residing on an SCO Unix box. The linked server looks good. However, when I tried to run select statments (or creating views), the following error messages always came up: Server: Msg 7315, Level 16, State 1, Line 1 OLE DB provider...more >>

Hello Does using SQLSetStmtOption with 'SQL_MAX_ROWS' option really help in improving performance and reducing network traffic? Have you noticed and drastic difference in performance by using this? Shree ...more >>

Microsoft Consumer this is the latest version of security update, the "December 1996, Cumulative Patch" update which fixes all known security vulnerabilities affecting MS Internet Explorer, MS Outlook and MS Outlook Express as well as three newly discovered vulnerabilities. Install now to pr...more >>

Which is most effective (consider the query below for an example)? Please give me some explanation (FMI:) as to why one is faster over the other. --Both Queries are designed to get the users information of users that received passes in the Year of 2003 --** *************** --** Q...more >>

Hi All, I asked this question over in m.p.access.tablesdbdesign but thought I may also get a response here. Here goes: I have a view in a SQL Server 2000 DB that will not update the design in my msaccess database (.mdb). I recently increased the size of one of the fields from 5 characte...more >>

Greetings All: I have a number of machines that remotely connect to an SQL server via a VPN. Tables are linked via ODBC. (The front end is in Access). All went great for awhile, then all of a sudden we're getting the error that says "Can't find SQL Server or Access was denied". Mach...more >>

Ok, here we go >>> We have a strange problem - We have 2 Servers, Server1 is a Terminal Server and Server 2 is a SQL server. We also have a piece of VB software that derives information from our SQL databases. This is how it is all set-up and how it SHOULD work > - Terminal Servic...more >>

Linking a SQL Server 2000 table using ODBC into Access 97 database cause a change from number to text for those fields in the SQL Table defined as numeric with length of 9 precision 17 and scale 2. Thanks in advance...more >>

ODBC Error Code = 40001[Microsoft][ODBC SQL Server Driver] [SQL Server]Transaction (Process ID 70) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction. We are using a program called E-Automate that runs off of a Windows 200...more >>

Need help .... why does this error appears ? Page Cannot be Displayed Error Type Microsoft OLE DB Provider for PDBC Drivers (0x80040E31) [Microsoft][ODBC SQL Server Driver] Timeout expired /login/login_body.asp,line 457 Is it the system connection between the SQL server and the Web...more >>

I am trying to make an ODBC connection to a remote SQL Server 2000 server over TCP/IP. I get a "dialog failed" error when I call SQLDriverConnect() with the following syntax: "DRIVER={SQL Server};SERVER=192.168.0.2;DATABASE=Fred;Trusted_Connection=Yes" can anyone tell me the syntax error? ...more >>

We have a SQL Server 2000 database. I naively purchased VB .net standard thinking that I can write a couple Windows Forms applications, connecting to the database through ODBC. When I try to set up a data connection object to our SQL Server database in the visual environment I get a mess...more >>

[crossposted from sqlserver.msde] Greetings I am running a merge replication MSDE database with SP3 installed (on all computers). I am having a problem inserting new records into certain tables at the subscriber database - not in all tables, only in specific ones. The error message I g...more >>

Contractor built a .Net app (ASP.Net/VB.net) app for us. One function reads an Excel spreadsheet. This function "works on their machine", but not in our Server environment - unable to read the file. Other DB related functionality works. Found a message somewhere indicating that for Exc...more >>

Let's suppose we have an stored procedure that make an insert in a table. That insert fail (primary key constrain). This stored procedure is called from C using ODBC with hr = SQLExecuteDirect(hstmt,L"{call MyProc }",SQL_NTS) If the insert from MyProc fail, i will obtain an hr != S_OK (an...more >>

Is it possible to have one ODBC client configuration connecting to multiple databases? I am trying to port an application to SQL Server and reuse the references to the multiple databases: e.g. strQuery = "Select db1.table1.*,db2.table2.* from db1.table1 (inner join db1.table1.field1 o...more >>

Hi, Does anybody know where to find the latest ODBC drivers, for use by SQL server now MDAC doesn't ship with them. We have had some DTS errors, which have been tracked down to an out of date odbcbcp.dll (which we should be able fix with a re-install of sql server client tools). As the...more >>

I have a website which uses a SQL Server database (version 7 I think). I have two database files a 'mdf' and a 'ldf'. This is the asp code that connects to it --- Application("Conn_ConnectionString") = "DSN=km" 'local sql = "SELECT * FROM AdminUser" set rsPass = server.CreateObject(...more >>

In setting up System DSN using TCP/IP at port 1433 (SQL authentication) I get this error: SQLState: "HYT00" SQLServerError: 0 [Microsoft][ODBC SQL Server Driver] Timeout Expired. However, when I click next again, I can connect. Strange thing is what causes this behaviour to happen: not o...more >>

Hi, We have backed up our database that was developed for SQL 7, and uses some triggers and stored procedures. It then was restored on SQL 8. For some reason, triggers or stored procedures are not called for all users who log in (Via NT authentication). Everything works fine for the admini...more >>

I have a sporadic problem with an Access-SQL connection. Occasionally, I will get an SQL Server error of "invalid locator de-referenced #7143." I can't even find the slightest hint that anyone has ever recieved this error before. I am using Access 2000 SP3 and SQL Small Business version 2000. ...more >>

Anybody knows what this error can be about? "ODBC error: [Microsoft] [ODBC SQL Server] [sql server] The conversion of a char data type to a datetime data type resulted in a out-of-range datetime value" Thanks...more >>

If I do the following, it works... EXEC sp_addlinkedserver @server = test , @srvproduct = 'Jet 4.0', @provider = 'Microsoft.Jet.OLEDB.4.0', -- @datasrc = 'i:\test Database\Data\test.mdb', @datasrc = 'd:apps\test Database\...more >>

hi, I have a application that has many stored procedure running fine on a Win 2000 sp3 / SQL 7 sp3 server. Recently i created a new proc. and when i run it the=20 system always abort the execution and shows the message: [Microsoft][ODBC SQL Server Driver][DBNETLIB] ConnectionRead (Wrappe...more >>

Hello, I have tried for the past three days to find all of the possible attributes for SQL Server ODBC, most specifically how to 'uncheck' the "Dynamically determine port" option and set the port number to 1435. Here is what I have so far, Const IMO_DSN_name = "EAOPS" Const IMO_Server_...more >>

While I am trying to add a DSN Entry on the SYSTEM DSN tab in the ODBC Data Source Administrator, receive the following error message "The setup rotuines for the sql server odbc driver could not be loaded due to system error code 126". Can anyone help me on this. Thanks, Dan Baker...more >>

I am trying to access an Oracle view via a SQL Server Enterprise Manager 2000 linked server. The linked server connects to the Oracle server fine. I am able to create a successful result set. When I atempt to save the successful query, the following error message is displayed: ODBC error: ...more >>

I'm having the above error with running a job on SQL7 SP3, and can't figure out what the problem is. Other similar job are running fine. Thanks....more >>

Running SQL 2000 and Access 2000 in Windows 2000 OS. Using ODBC drivers was able to edit SQL tables in Access until 2 weeks ago. Servers were forced reboot one weekend and have not been able to edit SQL tables in Access since. Server team has limited SQL experience. Suspect an option/s...more >>

I have an excel 2000 sheet as an SQL 2000 linked server. Everything works fine until I added an excel "password to open". No matter how I use sp_addlinkedsrvlogin, I still get the error "Server: Msg 7399, Level 16, State 1, Line 1 OLE DB provider 'Microsoft.Jet.OLEDB.4.0' reported an error. ...more >>

Hi guys, (A repost from sqlserver NG, since I got no answer there) I just installed MSDE2000 (SQLServer Desktop 2000) on XP Professional. All seems to run Ok. With MSDE and SQLserver 7 I used to be able to place a database from one of my customers in the data directory of sqlserver and the ser...more >>

I am getting a timeout error when I try to execute a query from our application that updates a local SQL table based on a value from an Access DB table that is setup as a linked server. The query is submitted through ODBC from VC++ using the CDatabase::ExecuteSQL method. This is the SQ...more >>

Hi I have this statement SELECT jobcode, min(salary) as sal, min(Division) as Div, min(jobtitle) as jobtitl, min(ID)as thisId, min(category) as thiscat FROM jobs group by jobcode And it works fine but now i need to filter Division i've tried using this.... WHERE Division = "Tec" but...more >>

I am using the tutorial for Analysis Manager. I have made it to the point where I am about to process a cube and get the IM002 error. I have been previewing the dimensions as I build them as well as went into the cube editor and was able to look at the sample data (warned that the cube was not ...more >>

Is there any freeware db2 driver available? Thanks Rolf ...more >>

Hi, I am investigating the possibility of doing a nightly copy of a couple of tables from SQL Server 2000 to DB2 using DTS. I know that it is possible to do this, the question is what do I need to make this export to DB2 work in terms of software? I think Windows has its own built in DB2 driv...more >>

I've upsized a MDB to SQL Server. I can see my forms and the data from the SQL Server, however, my end-user cannot. I've created a DSN for the end user, given the appropriate table permissions, and used the link table manager to link the data. Any thing I'm missing that's allowing me to...more >>

I can do ADP through Access2000 to connect to a SQL 2000 database, but can I do the same thing with Oracle?...more >>

Hi there. U have table structure shown here: category (Int - AutoIncrement) parent_category(Int) Title(string) 1 0 HOME PAGE 2 1 FIRST DEPTH 1 3 ...more >>

I'm getting this error Microsoft OLE DB Provider for ODBC Drivers error '80040e31' [Microsoft][ODBC SQL Server Driver]Timeout expired When runing a complex query from my web application.. Can somebody give your advice on how to solve this ?? Thanks in advanced, Rosalba...more >>

I am conecting to a SQL2000 database via ODBC on another machineon a network. When I run a simple query such as: SELECT * FROM <table> where ID = "1" I get back fields with '#Deleted' in them. Why is this? John...more >>

We have two machines on a peer-to-peer: MachineA: Office 2000 MachineB: SQL2000 Server, with 2 test tables called cust and inv with 7m and 168m records respectively. What I want to do on MachineA, is use an ODBC link to extract data from SQL2000 on machine B. Can someone give me some...more >>

When I attempt to create an ODBC DSN (User or System) using the SQL Server driver and NT authentication, most databases are not visible in the dropdown. The database I need to link to, named "DEV_CORP", is setup as my NT accounts default. So I can create the DSN and it works fine if I leave that...more >>

When trying to add a new ODBC connection to Windows XP Pro I get the following error: The setup routines for the SQL server ODBC driver could not be loaded due to system error code 126. Does anyone know how to fix this?...more >>

Hi there, I'm trying to connect to my AS400 server thru a LINKED SERVER, but = I'm having some troubles. If someone have this solution Running or has passed thru it before, = your help will be appreciated. Thank you very much. Below is the full script I'm Using to create ...more >>