Hi I am having a problem with a SQL2000 client. When I try to create a ODBC driver to my server, it show the message: conection failed sqlstate : hyt00 sql server error : 0 The network connection is OK, and it only occurs with this machine. And before that it was actually working fine. ...more >>

After designing a database thoroughly, we encountered this error while trying to add a new record into an existing table. It says :"SQL Dump Exceptional Handler - Process 52 generated fatal exception......." If the similar project is opened via adp, after this error triggers, the connection...more >>

I have an Access XP application running on user's desktops. This application is linked to a SQL Server 2000 DB. For three weeks now we have been noticing an increasing number of ODBC timeout errors. Tracking down the cause of the errors has led us to run Profiler traces, SP_Who2 and SP_Lock...more >>

hi i am amit from india i am new to this field can you help to import a database from SQL Server to Oracle9i -- Message posted via http://www.sqlmonster.com...more >>

We are using SQL7 and are experiencing this problem when trying to update to the database. It is an intermitent problem. Any ideas??? The error code reads: Microsoft OLE DB Provider for ODBC Drivers error '80040e14' [Microsoft][ODBC SQL Server Driver][SQL Server]The request for procedure 't...more >>

Hello, The problem accured with the database that contains critical data, so it is very important to me to solve it as quickly as possible. So the problem is that I cannot attach my database to the SQL server. How all this began? At first I decided to back up my database. But by mistake in ...more >>

I have a web based application where my reports are run from an access front end (don't ask but the people who own the application did it this way) my issue is the following I have a report that shows all the proper records but: If I look at the linked tables used in this report the data does ...more >>

I have a local mdb file and remote sql server 2000 database.. i know only my remote table user name and password... my mdb file and sql database are same... I tried to link my remote database I click link table and odbc from my mdb... i choose machine data source and new ... i cho...more >>

I have an application that works just fine on several computers. {Delphi6 with ADO Components } We have a MSSQL2K DB with MDAC 2.81.1117 on EVERY machine. However, on one of them, when I try to run the program, I get a "Provider not found. It may not be properly installed" error, then an "Er...more >>

Using Microsoft SQL OLE DB to create the linked server, whether using Enterprise Manager or Analyzer script.... The linked server appears to be created successfully, and I can see the database tables, but I cannot see any of the data in the tables. Anyone have an idea of whay I might be mi...more >>

I've been discussing here a SQL 7 view which scrolls slowly when linked to an Access 2000 MDB. After trying various things, I've distilled it down to the following: when the linked view has a virtual primary key, it is slow; when there is no virtual primary key, it scrolls quickly. Looking ...more >>

Hi, I am trying to access data from a Sage Line 100 database to populate tables in SQL 2000. If I use the following syntax in Query Analyser I only get the first row of a table returned: select * FROM OPENROWSET ('MSDASQL','DSN=SageLine132',UID=admin;PWD=;','select * FROM STO_DEPOT_NA...more >>

I just resolved a strange situation I was having with an ODBC linked SQL 7 view in an Access 2000 MDB file, and I'm trying to get some understanding as to what happened. The linked view was scrolling very slowly in the MDB file; however, it scrolled very quickly when accessed through an ADP...more >>

I have a field in the query where I count the tech_area field. I have an Iif (Count Of([tech_field])=0, CountOf([id]),CountOf[tech_field]). My question is how do I translate that in SQL Server? I tried to write the query using the new view window but I kept erroring when I put the IIf st...more >>

I have a situation with an ODBC linked view in an Access 2000 MDB with a SQL 7 back end. The view is scrolling very slowly. However, if I open the view in an ADP file, it scrolls quickly. I needed to use an ODBC link for the view because it needs to be editable. Otherwise, I would have used...more >>

While working on MsSQL 2000 I'm trying to update table on remote server (Sybase) Here is the description of remote table (Sybase) IF OBJECT_ID('adm.TransClient') IS NOT NULL drop table adm.TransClient go CREATE TABLE adm.TransClient ( CUST_ID numeric(10,0) NOT NULL, NAME varchar(...more >>

Are previous versions compatible with later versions - i.e. a server with 2.71 communicates with a server on 2.8. any known problems?...more >>

I have an Access database with a SQL Server back-end. I am new to SQL, so the problem I have been having is a real puzzle to me. I have created an Access query called ‘qryIRCasesUnrouted’, which finds records in a table called ‘IR’ that do not have a matching key in another table c...more >>

Hello, i try to make some select queries using a linked oracle 10 server but for a few tables, only the first row is returned... i haved used "Microsoft OLE provider for OCBC driver" when declaring my linked server and my odbc link is using the lastest Oracle odbc driver (10.1.3.1). ...more >>

HI , My application runs fine when I am using SQL Server 2000 as its db, but it gives a message "Invalid attribute/identifier error" when the db is Oracle . Any help in this matter would be appreciated . Thanks , Sujay -- Sujay Ghosh Bangalore, INDIA Email : sujayg_mfc...more >>

We set up a MSDE 2000 database on a Windows 98 machine. We're trying to connect to the W98 DB from a XP machine using an ODBC and a Windows authentication. We get the following error when trying to test-connect the DB: SQL Server error 18452 : Login failed. Not associated with trusted SQL ...more >>

We have a production database that has worked fine in many installations. Several of our sites have larger databases with more activity and have no problems. One rouge site has recently encountered a blocking problem that we cannot explain. The problem site has about 20 clients which are XP...more >>

Has anyone managed to get update queries working on a mysql linked server. ...more >>

Is there a way to make an ODBC connection automatically fail to an alternative ODBC connection if the 1st fails? ...more >>

Our applications (MS Access 2000), all running from the same machine, access data from SQL server 2k via odbc. I mean setting up linked tables in MS Access. The sql server, runs on a different machine, support mix mode authentication. For a few applications that work with odbc dsn based o...more >>

I was wondering if anyone knew of a way to dynamically link a table from a COBOL (I think) database into a SQL database. I have an ODBC driver that I have been using to link the tables into Access, but would like to do the same in SQL Server 2000. Thanks in advance for any replies!...more >>

I've read through many posts regarding this type of issue and all posts were relevant but not exactly my problem. I use Access 2003 and I have a simple linked table to a Sql2000 DB table, I then have a form that I can use to view/amend data directly on the sql table. However, I then have an...more >>