Search results for query: *

I was asking about the NDX file. Thanks for all the help. Much appreciated.

How do I reindex DBASE III/IV specific table from a command prompt?

I have a weird problem, I have created a linked server to a Dbase database. It works perfectly from SQL Server A, but not from SQL Server B. On SQL Server B, I am getting this error: [Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]ConnectionCheckForData (CheckforData()). Server: Msg 11, Level...

The Storeprocedure works fine in SQL 2000, but not in SQL 2005. I am getting the error: Invalid column name '19' when running the Storeprocedure. However, if I just run this as query it works fine (on both 2005 and 2000). Once it is a store procedure, and I call for example dbo.testprocedure...

Actually fixed the problem this PM, and it was as simple as change to reject client certificates in IIS Directory security, edit, configuration.

Information below might be helpful. I appreciate if anyone knows the answer to this. [PS] C:\Documents and Settings\Administrator.GASTON>test-outlookwebservices | fl Id : 1003 Type : Information Message : About to test AutoDiscover with the e-mail address...

Have a valid certificate and correct DNS entries, but getting this error id: 1019 When contacting https://..... /autdiscover/autodiscover.xml receive the error the underlying connection was closed. An unexpected errored on a send. And then on the next row: xml received the error authentication...

Getting this error when creating a DTS PACKAGE that has a data driven query task. ActiveX scripting requires script TEXT AND LAGNUAGE AND AT LEAST ONE PHASE FUNCTION TO BE SPECIFIED INSERT INTO TEST (aa, ba,ca) VALUES (?, ?, ?)

We have bought CAL Enterprise licenses for Exchange 2007 server via MS Open License program. The licenses have been activated on the MS Eopen website and everything looks OK. The question how do we make our Exchange Server (Standard) 2007 recognize these CAL Enterprise licenses. I have been told...

The problem is that I have the problem with formatting. I can create the linked server, but then I am getting an ODBCD error when running the query. So I think the DBASE driver is incorrect. I also tried a DSN Name, but that's giving the same problem. EXEC master.dbo.sp_addlinkedserver @server...

How do I create a linked server to a DBASE database. I have the ODBCD connection set up. Does anyone have an example?

Trying to insert data from SQL to Dbase using DTS. The problem is that I have it just "cloning" the data, only inserting data where the record already exists (so I end up having two record in the Dbase table), and it is ignoring any new records that exists in the SQL table. Obviously I need an...

Works. Thank you.

Tried that but the error happens before the execution. It appears that the error happens at the SET @SQL line

Getting error converting to float when comparing (greater than) two values although both values are float. I have even tried to convert to values to float, and still getting the error (see down at the bottom). CREATE PROCEDURE dbo.SetNTP as SET QUOTED_IDENTIFIER OFF declare @SQL...

I have a program where the user can modify a user query, but how do I validate (in SQL) that the query is OK??

I have the above statement in a where clause, but it doesn't work. The accountinfo.NTP is an INT value and has the value of 4, and Y.CALLNUM is a calculated value (COUNT) and has the value of 1. So if 4 is greater than 1 how come it doesn't recognize it?? I tried everything. It works if I remove...