Hi all, I have an asp page that writes to an ntext field in SQL Server 2000. All was going well until I had to put in a section of text greater than 8000 bytes. Then I got a timeout error and the update wouldn't go through. After reading that 2000 only accepts chunks of 8000 bytes or under at...more >>

Is it possible to connect to an ODBC driver (e.g. SQL Server or Oracle) directly without having to create a DSN before hand. This would be great as dumb users can't handle creating a DSN. Would be nice if I could ask them SQL Server or Oracle, server name, user name and password only and progr...more >>

after executing a Stored procedure that returns about 10 strings I get a "String data, right truncation" error in ODBC. how do I know which string was too long? Leon ...more >>

Will there be a compatibility issue between my client ODBC version 2000.80.194 and the SQL server 2003....more >>

I am hoping to import a file exported from mainframe (packed decimal) into a SQL Server database. Is it possible and if so, what is the best way to accomplish this? Thanks in advance....more >>

I am writing an application that calls numbers of stored procedure wrapped in an ADO.NET transaction. Some of the stored procedure implements T-SQL transactions. Is it safe to call Stored Procedure like this or there is potential of data corruption. Have anyone seen any document or article...more >>

Hi, is there a possibility to create automaticaly a ODBC database connection on the multiple client computers (equal for all of them), in ex. on windows 2000 Profesional or XP? And secont thing. Is there a possibility to automaticaly change all of the ODBC connections without changing one by on...more >>

Hi How can I find out what version of MDAC is installed on a Machine. And would there be any problem with me installing both MDAC 2.7 and 2.8 on the same machine Ian ...more >>

I'd like to do the following query update myTable set myField = not (myField) But it looks like not isn't a function. How can I write this? Thank you ...more >>

I've been able to import tables successfully from Oracle to a SQL Server database. However, when I try to import views from Oracle it wants to import them as tables in SQL Server. Any ideas how I can import views as views from Oracle to SQL Server?...more >>

Please excuse if you feel this is posted in wrong group (I have posted in Access groups as well)... I do know there is at least some some cross-over base here that may help... I am trying to establish links from Ms Access to tables in a SQL server database. There is an Access table (tblLinkMa...more >>

We have several machines where multiple people login. Normally we set the ODBC to 'with NT auth with network login id' When we change it from this to 'SQL server auth asking for login id/pwd' our Visual Basic apps no longer work. Our VB apps do have a login screen & pwd and that string...more >>

Hi All, I am using OpenLink's ODBC in order to transfer data from Progress Data Server into the SQL. When trying to transfer a field which has a character format on the Progress Server, the DTS transfer only the first 8 characters of this field. The format of the field in the progress databa...more >>

I am using an ODBC connection to a SQL Server 2000 database to retrieve information for a Crystal Report. When I am logged onto the network as domain admin and create an ODBC DSN using SQL Server authentication and my database admin logon everything works fine. If I use another SQL Server ...more >>

Hi, We have several applications that connect to SQL Server using ODBC. We have some mysterious issues of record loss without any error messages. Has anyone seen anything like this? SQL Server SP3 is installed. Are there MDAC issues that could be at play? Thanks, Tim...more >>

Hi All, I created a SQL Server DTS package when connecting to the SQL server on my machine. We have a batch file created which was scheduled to run every Tue. night on the server where SQL server really sits. In the batch file, we use dtsrun to call this package. It has been running well. I sh...more >>

How do you get SQL server to keep a note of amendments to records in tables? We use MS Access 2000 & 2003 and SQL 2000, XP Pro / NT4 and Win 2003 server. Also, why do I always have to re-link all the tables on the NT4 workstations on an .mdb which works fine on all XP w/s? ...more >>

Hello, I'm not sure if this message belongs in microsoft.public.sqlserver.msde or is more appropriate here. Please accept my apologies if I have the wrong list. I've written ODBC source in C++ that accesses an MSDE instance on a local machine. I perform the usual steps: 1. Allocate ...more >>

hello, I'm trying to create a linked server from an SQL2000 to a Unify ELS (very old, odbc is version 1) database on SCO unix. The odbc driver is old but it works fine when used by applications for creating reports. What I want to do is make a linked server from the SCO box to the win2k box...more >>

Why does this crash SQL7 with SP4 and latest MDAC? CREATE TABLE #test ( [year] smallint, [month] tinyint, [product] varchar(100), [value] money ) GO INSERT INTO #test VALUES (2000, 2, 'p-01', 1.00) INSERT INTO #test VALUES (2000, 2, 'p-02', 2.00) INSERT INTO #test VALUES (2001, 2, 'p-0...more >>

In a Union query, I have initialized one new column for sorting purpose. For ex : select ORD = 1 , t1.a, t1.b from table1 as t1 Union select ORD = 0, t2.a, t2.b from table2 as t2 order by ORD. ORD column is not present in thw table. It is used here for putting all the rows of the second ...more >>

Hi all, I stupidly setup a database as a userDSN but now want to make it a system dsn so that I can access it from another machine. I have an access db that uses msde linked tables for the back end, which is installed locally on 1 machine in the network. I want to be able to add new features...more >>

I have an ODBC driver to a non-SQL database that contains legacy data that I need to reference in my application/reports. I had originally hoped to use a linked server using the OLEDB for ODBC provider to access the data and so be able to create applications/reports using data stored in SQL Se...more >>

Dear Support Team, I had installed sqlserver 2000 with sp3 on windows 2003 server. Navision ERP client software 3.70 installed in this server. Sql server service is running as local system account and sql agent service is configured to run as local system account. sql agent service is not ...more >>

Problem: SQL Server 2000 blocking locks on Access upsized database. Tools used: SQL Server 2000 SP3a, Access 2003, DAO 3.6 My project is to upsize an Access 2000 database to SQL Server 2000. I have migrated the data to SQL Server, re-linked the tables, and converted the database to Access...more >>

Hello, I'm trying to delete an existing varchar(10) column called "abc1" o in a table on a SQL 2000 database and I'm getting the following error message in Enterprise Manager.: 'web_cartOrders' table - Unable to modify table. ODBC error: [Microsoft][ODBC SQL Server Driver][SQL Server]Lin...more >>

"The instruction at 0x4174f6ff referenced memory at 0x4174f6ff. The memory could not be read" i am getting when i am working on sq server enterprise manager...more >>

Hi I read data from a db2 database on an IBM mainframe through ODBC and transfer it to a dabase on our SQL Server. Everything is done using a DTS and it works fine. For serveral resons I would like to implement a stored procedure doing the same task. Does anybody know how to solve this? Speci...more >>

Is it possible to use a SQL Server stored procedure as a datasource for MS Word mail merge? If yes then how? ...more >>

I have my java based application that works fine with SQL server 6.5. I upgraded DB to SQL Server 2000 and now the application give me "Connection is busy with results for another hstmt " ODBC error after I do couple of queries or updates through the application. Is it anything to do ...more >>

I IMPORTED A DATABASE FROM AN SQL SERVER 7.0 TO AN SQL SERVER 2000. I CAN UPDATE THE TABLES DIRECTLY ON THE SERVER, BUT WHEN I TRY TO DO IT WITH THE PROGRAM THAT USES THE DATABASE, IT GIVES ME ERROR 3027: CAN'T UPDATE, DATABASE OR OBJECT IS READ-ONLY. I HAVE GIVEN ALL THE USERS THEIR RESPE...more >>

Hi All I have a excel spread sheet that i need data from. This is the Data. MyID TextField DateField IntField FloatField 1 Ian One 01/04/04 10 10.0304455900 2 Ian Two 02/04/0...more >>

hello, My friend and I are working on a project involving oracle 9i and an old Unify database. We got the oracle to see the unify (oracle running on windows) by using the heterogenous services on oracle. However, that was a test environment. The production environment has oracle running on...more >>