ODBC port 1433 is insecure. What is the best document at M$ or TechNet that provides a concise review of how to maintain a secure ODBC connection...more >>

Hi, Haven't found an answer yet but I'm still hoping. When we try to import data using the Other (ODBC Data Source) and select the DSN created for the Excel spreadsheet then no data is listed. However, if we choose "Microsoft Excel 97-2000" as the Data Source and select the appropriate excel f...more >>

I'm tring the the following where strDBtoOpen is the UNC path to an Access Database: ..ASP page ADO Connection object Source property. cn.Source = "SELECT DD.* FROM OPENROWSET('Microsoft.Jet.OLEDB.4.0','" & strDBtoOpen & "';'admin';'', DueDiligence) as DD WHERE ReviewedBy IS NOT NULL" ...more >>

Hi, We are trying to import Excel data (Excel 2002) into some SQL server tables. However, we have tried several things but they all seem to fail. 1) The following command on our production server (Windows NT SP6a - MS SQL Server 2000 SP3) fails when we run it in Query Analyzer: select * f...more >>

I'm sure this is a real simple one , whats the best trick when your select conditions have a ' in the value "WHERE (People.FullName = 'Example O'Toole' )" ? Chris Example strSQLPeople = "SELECT People.FullName " strSQLPeople = strSQLPeople & "FROM People " strSQLPeo...more >>

There is a problem with my ODBC connection. Usually after about 30 mins, a connection time out occurs and the error message displayed is as foolows: Connection failed: SQLState: 'S1000' SQL Server Error: 0 SQL Server Error: 0 [Microsoft][ODBC SQL Server Driver]Cannot generate SSPI conte...more >>

Running SQLS7 on an NT4 server at 500MHz, with 768MB RAM (256MB dedicated to SQLS). Using ODBC to get data into an Excel spreadsheet on a desktop machine. SQL database is about 3GB; spreadsheet comes to about 14MB. Data from 3 tables is being used, related by a field common to all 3; data fo...more >>

Hi Microsoft OLE DB Provider for SQL Server error '80040e14' [OLE/DB provider returned message: System resource exceeded.] I get this error message frequently on my asp page which uses sql 2000. When I resart the sql server ( just the sql service not the SQL Box) the error goes off...more >>

Hi i am trying to make an odbc connection with a remote sql server using windows authentication which fails with the following error. __________________________________________________________ Microsoft SQL Server ODBC Driver Version 03.80.0194 Running connectivity tests... Attempting ...more >>

A user creates forms in dBase5.7 and now uses a SQL2000 database on our network to access tables via dBase. He has made an application that requires an ODBC DSN (System DSN) to be created on the local machine and this gets posted to a config file called BDE Configuration (part of dBase) a...more >>

Rowguid column ( globally unique identifier) was added to all tables in the database. What may cause that? Thanks for help in advance. ...more >>

Hi! I'm accessing an MS Access database from an ASP server. I just added a new text column (field) to one of my tables. I have not added any data to this new field in any of the rows. I read the field in and compare it to "" and it's coming up as false. How do identify the empty fields?...more >>

I have a customer that wants me to create a database and use a back end of SQL Server (hosted on the Internet for his site). This would normally be easy to create the front end with an ADP and continue life as normal. But, in order to connect his accounting program to this program that I am cr...more >>

Hi all. I have a procedure in my database whose code is more or less the following: CREATE PROCEDURE Fnt ( @Name nvarchar(20) ) AS declare @number1 int; declare @number2 int; CREATE TABLE #Table1 ( ValueRet int, ) set @number1=(select SUBSTRING( pol, 1 , 2 ) from table where...more >>

Using a local instance of SQL Server 2000 and .NET I have managed to insert 4000 rows across multiple tables using the OLE DB provider in 11 seconds but when using the native provider it takes 13 seconds. I was under the impression the native provider should enhance performance not decrease it? ...more >>

I'm curious, can you set up a ODBC connection on one server, that points to another computer on the network where the database is? I've tried the computer name as //server2, but it doesn't seem to find it, yet, I can get to it via the RDC within WinXP Pro. Thanks, Steve...more >>

Hi I'm running peoplesoft 8.8 on MS-SQL 2000 SP3. When I try to access my peoplesoft application I get some error like "SQL error. Stmt #: 651 Error Position: 0 Return: 8601 - [Microsoft][ODBC SQL Server Driver][SQL Server] fetch: The fetch type refresh not allowed with forward only curso...more >>

Hi, I am trying to rename columns or move column in a simple table that has data in it. Each time I am getting an "Invalid Cursor State" error message. I am doing that all the time in Access 97/2000/2002/2003. Why is it not working in SQL Server 2000? Any idea? Thanks vbdev ...more >>

Hello. I have problem with connection to my SQL server 2000 through 'sa' user without password. On my windows XP with Access XP I created ODBC Source, user DSN source for default user 'sa'. On SQL this user has not a password. Now, in Access, when I try to open linked (from SQL Server) tables...more >>

[Microsoft}{ODBC SQL Server Driver][SQL Server] INSERT statement conflicted with COLUMN FOREIGN KEY constraint 'Attachment_FK00'. The conflict occured in database 'assay', table 'suborders', column 'suborderid'. (#547) [Microsoft}{ODBC SQL Server Driver][SQL Server]The statement has been t...more >>

Hi, I receive this intermmitent "[ODBC SQL Server Driver] Timeout Error" eventhough i have set the Query Timeout in Enterprise Manager to '0' (unlimited). However when running the query in Query Analyser, it returns a result in just a few seconds. Is there someplace else that i need to c...more >>

I just installed the SQL into my SBS2000 server. The reason why i'm doing this is i'm trying to install MS Project Central Server. Anyway, i'm following the directions off MS and i'm came across a problem. I'm trying to create the database, tables and fields by using the 'osql' command. I'm getting ...more >>

I am on a win 2003 server and have run the component checker and found 2 errors. The files obdcbcp.dll and sqlsrv32.dll have mismatch errors. There errors say expecting version 2000.85.1022.0; but the problem is that I have 2000.85.1025.0 How can I fix this? Thanks in advance, Ste...more >>

Hi all I can not delete the odbc manager tracing file. Even after disabling tracing (in the odbc manager) i get a windows massage saing another program is using the odbc tracing file... Can i stop the odbc manager service?? What other programs may be using this log? There is no other runing p...more >>

I have a Visual C++ program that reads through a set of records and updates some of them. Here is some pseudocode: Open the recordset; while not EOF { if ( some condition ) update the record; Move to Next Record; } I am using the MFC libary classes CRecordset and CDatabas...more >>

Hi all I need some guiding to best practices for tracing odbc errors. I'm using a propriatary odbc driver (for a tabula rdbms server) which i suspect does not pass some errors to sqlsserver (where i run a job which includes a connection using such driver). Are there any generic tracing methods...more >>

Hi All I am using ASP and SQL Server 2000 for an application. The problem that i am facing is that I get INVALID OBJECT NAME error. to be precise... "Error Type Microsoft OLE DB Provider for SQL Server (0x80040E37 Invalid object name '<table name>' the application runs for some days without a...more >>

Hi, I’m using SQL server 2000 with sp3a. I have Oracle 9i Drivers installed (also tried 7.3 and 8i). I’m trying to run a query joining my SQL tables with Oracle 9i server. I used the DTS Query builder to build my statement. Every time I run the query I get a time out. If I change the where stat...more >>

Hello, I use Unicode in my program to enter data in Chinese into a nvarchar field. When inserting or updating records, my application does not use Unicode escape sequences but rather the Unicode characters themselves. Thus, my app may have SQL statements like: UPDATE table SET field1 = ...more >>

Hello, I have a C++ / MFC app which uses CDatabase and CRecordset to connect to a ODBC data source for a SQL Server 7 database. The application worked properly with a MySQL database, but after swapping it for SQL Server problems emerged. In particular, any calls to CRecordset::AddNew() and CR...more >>

Please can someone help. I have a DTS job that uses datapump to extract data from an Oracle Server to my SQL Server. When executing the DTS direcly from Enterprise manager there is no problem. When running it from a Command screen using dtsrun there is no problem. The problem occurs wh...more >>

Hi - I have real performance issues on a Linked Server connection from SQL Server 2000 to an ORACLE 9i DB setup using OLE DB. A query that should take milliseconds is taking an unacceptable 45 seconds. As this is the deciding factor on whether we go ORACLE or SQL Server for a solution, I w...more >>

Hi everybody, I want to develop an ODBC driver to connect a normal windows application to a middleware product. I can't find any examples or hints with regard to ODBC driver development. Here are the questions: - Does anybody have experience with ODBC driver development? - Can anybody prov...more >>

I wonder if any of you good people can help? I am running a SQL2K client on Win2K Pro. No matter which SQL2K instance I try to connect to (using Named Pipes) I get the following error: "Client unable to establish connection NP_PROV: The system cannot find the file specified." If I switch...more >>

Does anyone know of an ODBC driver that can be used from DOS? ie not from a DOS window, but from a system booted into DOS 6.22? Wanting to read a SQL or Access Database after making a network connection from DOS. Thanks, Rob...more >>