Clinton Brand posted this link for RRAS and NAT issues "NAT Clients Cannot View Web Sites After You Install SQL 2000 SP2 or SP3 on an RRAS Server":

http://support.microsoft.com/?id=324288

HTH,

Andy

Your SQL actually returns multiple Recordsets. For ADO use the NextRecordset method:

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/ado270/htm/mdmthnextrec.asp

More on ADO and multiple recordsets:

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/ado270/htm/mdconreceivemultiplerecordsets.asp

Andy

Try:

CONTAINS (*,' "Laer" AND "Spontaneous" AND "corrections" ')

Andy

I think your example data will not allow this easily, however you probably do not have an actual row with A1, B1, C1, D1, right?

Here is one trick that I use...

You can try to convert your Declinations into a 2nd set of Latitude, Longitude, then use:

CREATE FUNCTION dbo.fn_GreatCircleDistance

 (@Latitude1 float = NULL,

 @Longitude1 float = NULL,

 @Latitude2 float = NULL,

 @Longitude2 float = NULL)

RETURNS...

Change "adrec2.open" to:

AdCn.Execute SQL, , adCmdText + adExecuteNoRecords

Since your connection string defaults to the master database, I would expect the demo1 table to be there!

You could change the connection...

If you want to restrict for 0 valued records for Both AZ and FG_ty

UPDATE DCR SET FG_AZ=FG.FG_AZ

  ,FG_ty = FG.FG_ty

FROM DCR

  INNER JOIN FG ON DCR.Customer = FG.CustomerID

WHERE FG.FG_AZ IS...

Use CONVERT(varchar(256),text_field) AS First256Text, you can adjust the varchar size for the desired length.

Andy

Darko,

Since no definition of the vehicule table was given, I did not attempt to guess. If it is a many table to car, then:

SELECT COUNT(DISTINCT marq) AS Marqs FROM vehicule

Or you may...

When:

SELECT DISTINCT marq FROM car

You are really doing:

SELECT marq FROM car GROUP BY marq

So:

SELECT COUNT(DISTINCT marq) AS Marqs FROM car GROUP BY marq

Is returning the rows you expect, verify using:

SELECT...

Check out this KB Article:

http://support.microsoft.com/default.aspx/kb/186133

Interesting ways to sequence a set of rows, I use an Update after the Insert, but you should be able to combine these into the...

Try:

declare @tamanho varchar(10)

select @tamanho=substring(name,1,10),

       --CAST((FILEPROPERTY(name, 'SpaceUsed')* 8)/1024 AS numeric(10,2))

FROM sysfiles

SELECT @tamanho

or:

declare @tamanho varchar(10)

select @tamanho=

       --substring(name,1,30) as Banco,

       CONVERT(varchar(10),CAST((FILEPROPERTY(name, 'SpaceUsed')* 8)/1024 AS numeric(10,2)))

FROM sysfiles

SELECT @tamanho

or:

declare @tamanho numeric(10,2), @banco varchar(30)

select @banco=substring(name,1,30),

       @tamanho=CAST((FILEPROPERTY(name,...

Once you link to the MDB from one server, that link has the file open,  since the MDB directory is ReadOnly it cannot create the LDF to share the file.

You...

The IP looks like an Internet address, if so then block port 1433 in your firewall.

If you have a valid DMZ access need then be sure to open port 1433...

Try changing:

WHERE c.OrderDate between '11/11/2004' AND '11/30/2004'

to:

WHERE c.OrderDate between '20041111' AND '20041130'

If that does not work, comment:

--join Orders c on b.OrderID = c.OrderID

--WHERE c.OrderDate between '20041111' AND '20041130'

Then see if...