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 >>