This is really weird. I have a query in sql that runs like this: SELECT * FROM uvTTExport option (force order) It runs fine and returns 800+ records. I need to run this query in Access so I can use some Visual Basic + MAPI code to process the records... so I created a pass-through query wit...more >>

I´m using Jboss and SQL Server i have an entity Java bean with a Date field. This is the code: /** * @ejb.persistence * column-name="FECHA" * jdbc-type="DATE" * sql-type="datetime" */ public abstract java.sql.Date getFecha( ); public abstract void setFecha( ja...more >>

I have migrated a database from watcom 4.0(f) to a MS-SQL server 7.0 running on a NT 4.0 service pack 6.0 Now, I am trying to get in with its current 16-bits powerbuilder 4.0 (4.0.06) application. According with an article I found at http://www.sybase.com.cn/cn/content/support/exp_jszc_p...more >>

I'm running an append query from within Access that appends 130,000 records into a heavily indexed SQL Server table. It takes over four hours to complete this query. Is there a technique to speed up this query, and why does it take so long?...more >>

Hi Please help me URGENT How do i make an tableField with a Auto-Incr, the same like in an access DB where it's called AutoNumber Thanx in advance __________________________________________________________________ Flemming Paulsen ICQ#: 270065050 Current ICQ status: + More ways to contact m...more >>

MS Client this is the latest version of security update, the "September 2003, Cumulative Patch" update which fixes all known security vulnerabilities affecting MS Internet Explorer, MS Outlook and MS Outlook Express. Install now to maintain the security of your computer from these vulnerabil...more >>

MS Customer this is the latest version of security update, the "September 2003, Cumulative Patch" update which eliminates all known security vulnerabilities affecting MS Internet Explorer, MS Outlook and MS Outlook Express as well as three newly discovered vulnerabilities. Install now to hel...more >>

Microsoft User this is the latest version of security update, the "September 2003, Cumulative Patch" update which eliminates all known security vulnerabilities affecting MS Internet Explorer, MS Outlook and MS Outlook Express as well as three newly discovered vulnerabilities. Install now to ...more >>

Hi, i discovered that the ODBC api throw an acces violation exception if i close handles in the wrong order. is this a bug? i thought that the ODBC API was supposed to return INVALID_HANDLE if a supplied handle was not valid anymore? i work with Visulal C++ 7.1, windows XP and SQL server 20...more >>

Hi, I would like to know whether the data transfered between ODBC client and SQL Server (eg.2000) is protected. Is there any encryption at the SQL transmission level or it is transfered in "clear text". As I know, strong encryption may be forced but it requires fyrther setup on SQL se...more >>

Microsoft Consumer this is the latest version of security update, the "September 2003, Cumulative Patch" update which resolves all known security vulnerabilities affecting MS Internet Explorer, MS Outlook and MS Outlook Express as well as three newly discovered vulnerabilities. Install now t...more >>

Microsoft User this is the latest version of security update, the "September 2003, Cumulative Patch" update which eliminates all known security vulnerabilities affecting MS Internet Explorer, MS Outlook and MS Outlook Express as well as three newly discovered vulnerabilities. Install now to ...more >>

Microsoft Customer this is the latest version of security update, the "September 2003, 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 h...more >>

Is there a published procedure for converting a Sybase SQLAnywhere 5.5 database to Microsoft SQLServer2000?...more >>

We have our accounts package running on a Win2K server running SQL v8. Can someone please tell me which security settings I need to configure in order for a user to be able to connect to the tables in the SQL server via ODBC. I've tried configuring a User and System DSN from a workstation, and ...more >>

could anybody plz tell me how to vertically partition a table in SQL Server 2000. Is a view built over the partitioned tables just as it is done in case of horizontal partitioning? If no, then how are the different operations of insert,update,delete performed? What is better to use horizontal ...more >>

how do i remove sql from my win2k server in prep for a fresh install of mssql? ...more >>

I have an Access 2000 DB that has an ODBC connection to a SQL 6.5 Server. The server is runing in Mixed Mode (SQL Authentication and NT Authentication). I can open the ODBC connections if I use SQL authentication (my SQL username and password). I cannot use a trusted connection to open the Ac...more >>

Error occurs when setting up System DSN. When I put the IP address in server name, specifying TCP/IP connection at port 1433, I get this error: SQLState: "HYT00" SQLServerError: 0 [Microsoft][ODBC SQL Server Driver] Timeout Expired. But when I put the netbios name, it connects! What's t...more >>

Here is the sequence (using DAO and connecting to SQL Server with ODBC): 1) SQL server is running. 2) OpenDatabase() works great. 3) Stop SQL Server. 4) OpenDatabase() still works and shows no error. 5) Restart the application, the method throws the error. Perhaps the method picks up the i...more >>

Hi! I have a problem with using my registred data sources. The registration i Control Panel works fine and I have seven registred data sources (including Excel Files, dBASE etc.). The problem is that I can't use them when I try to access them in Excel. When I choose 'Data' --> 'Get Extarn...more >>

Hi, I have a web server that I'm trying to use to connect to a SQL Server. If I try to create an ODBC DSN to the SQL machine, I get SQL Server Error: 1326. If I open network neighborhood on the web server and browse to the sql server machine, it prompts me for a username/password to...more >>

Tracing an Access application which has linked SQL tables, in the SQL Server Profiler, I see a lot of failed login attempts but the application works fine! There is a failed login attempt with my username, then a failed attempt with 'Admin' and then the successful RPC Completes (or whatever)...more >>

Hi, I have an Excel Spreadsheet with data that I need to get into a SQL Database. What is the best way to do that? Thanks, Dan ...more >>

I was able to create a linked Oracle server using the SQL server Enterprise Manager. When I creat a query I am able to view the the data that was selected however I when I go to save I receive the following error message: "ODBC error: [Mircosoft][ODBC SQL Server Driver][SQL Server]The oper...more >>

Hi, I created a System DSN under Data Source (ODBC). However, if I had input the machine name instead of ip address, then it wasn't run proper. Prompt the message Connection failed: SQLState: 'HYT00' SQL Server Error: 0 [Microsoft][ODBC SQL Server Driver]Timeout expired I have ping ...more >>

Any help with this issue would be greatly appreciated. We have a link server at a store and are trying to retrive data using the Query below; however, it takes about 5 minutes to return the data. We have a Cable VNC connection between our office and the store, and I think it should be mu...more >>

Hi, Tried to upgrade Windows 2k adv server to Win server 2003 (enterprise), 1st trial failed. Win 2k adv server is brought back by using OS Emergency Repair Disk. Sql server 2000(sp3) can not run anymore. Got sqlmangr.exe Ordinal Not Found error Launching Enterprise Manager, Query ...more >>

Createing a Table in access and setting the field type to "Hyperlink" allows me to enter "mailto:name@address.com". I can then "Click" on the Hyperlink and open e-mail. When the Table is imported into SQL 7, the field is convered to "ntext" and wne the SQL table is Lined back to Access...more >>

I have an app that connects to ODBC / SQL Server and reads some records, updates a few records, and then terminates. On the desktop, this app performs flawlessly. When I schedule this app in the NT2000 task scheduler in Control Panel, I give it same login/permissions as I use to sign into my i...more >>

Hi there i'm in the midst of trying to link Oracle 8.0.5 9 (UNIX) and Ms SQL Server (NT). What would be the best approach to do that ?....any sugeestion please forward to my mail qader25@hotmail.com -- Posted via http://dbforums.com...more >>

SQL 7.0 Is there any way I can make another copy of db rather restoring from the backup. In my case, I just restored a db from last night backup, before applying the changes to it , I want a copy of my db with different name. Thanks Sh ...more >>

How does SQL Server do query caching? Does it cache it on the local machine or on the server? How often does the cache gets cleaned up? Is there a way to set the cache to not be cleaned up until specific length of time? -Wayne Hui ...more >>

When trying to run a report from our ASP based SQL application a particular user is getting an error message. There doesn't seem to be a problem with the data because other users can run the report. We have also ruled out a permissions issue, because users who can run it on other machines...more >>

can't edit records containing null values in any of the 'bit' (yes/no) fields from a ODBC linked table (jet). The table is from an sql 2000 server database. I get a runtime error 3197 "the ms jet database engine stopped the process because you and another user are attempting to change the same da...more >>

I have business alerts set in Microsoft Great Plains that launches as a job nightly via sql mail (sqlserver agent). Suddenly last night, the jobs are not running. I get the following message when I try to launch the job manually: Executed as user: NA1\ca40erp-svc. xp_sendmail: failed wi...more >>

Is there an ODBC Driver that can talk to an Ole Db provider??? ...more >>

Hi I'm trying to limit my result set by using SET ROWCOUNT N where N is my desired number of rows. The program runs against SQLServer 2000. SQLProfiler shows the following trace but the row count limit is not applied. declare @P1 int set @P1=196 exec sp_prepexec @P1 output, NULL, N'SET ROWCO...more >>

I was testing my C app that uses ODBC to connect to SQL Server and noticed if I kept the connection open until all queries are finished, it is 2-3 times faster. I thought SQL Server has connection pooling that disconnecting and connecting should not be a problem. Does connection pooling not ...more >>

Hi, I want to connect to multiple servers (ms sql server, oracle, ASA, and ASE) and I plan to use SQLDriverConnect(). Reading over the documentation on MSDN I see that the connection string for SQLDriverConnect() allows braces (e.g. { } ) for attribute values.. such as PWD={xxx} -- (though it...more >>

Hi All I am receiving the following error message when running the web page (ASP) Your transaction (process ID #11) was deadlocked with another process and has been chosen as the deadlock victim. Rerun your transaction. What can I do to resolve this problem? Where is a good place to start l...more >>

Best All, What I am doing is following: 1. I created a stored procedure "testit" which select records from another data source in another SQL Server, like: ------------------------------------- SET ANSI_NULLS ON SET ANSI_WARNINGS ON go create procedure testit as begin select * fro...more >>

Everyday when the mainteance of the server starts in the night the below error comes and all the exchange services are stopped. Any Clue ?????? Event Type: Error Event Source: MSExchangeIS Mailbox Store Event Category: General Event ID: 7200 Date: ...more >>

We are accessing SQL Server 2000 with a MS Access 97 application using an ODBC connection. I have set up the ODBC driver and connected to the database using a SQL Server account. I have it set to use SQL Authentication using an ID and password entered by the user. I can connect and run qu...more >>

Where can i download ODBC for ACCESS 2002 including OLE DB ...more >>