Vannessa

It is possible to do this with a single query. I'll give you a hint; it involves a two step process. First you need to do four left...

Taken from MSDN:

Q176377 INFO: Accessing SQL Server with Integrated Security from ASP

Microsoft SQL Server Integrated Security requires NTLM authentication in order to map user accounts to SQL Server accounts....

alltrim in Foxpro means strip all leading and trailling spaces. Its like doing a Rtrim(Ltrim(desc)).

TSQL Rtrim - trims off trailling spaces

TSQL Ltrim - trims off leading spaces

However I don't...

How about saving it as XML? Once you have the recordset in VB you can call the save method of the recordset with the option to save as xml....

Unfortunately it is currently only available with the .NET Framework.

One other comment on this matter. I don't really think data shaping was ever that popular and look for it to disappear. If you have looked at the...

My experience is that it works very well but I can only think of very few nitch situations where I would consider using it because of the complexity. Also...

If my memory serves me correctly. WINs does NetBios Machine name to IP lookups. DNS does domain name to IP lookups. Host files work in conjunction with...

I don't know if this is your problem or not but just BEWARE: every time you do an update in trigger1 you will fire the update trigger (trigger2). Is...

I agree with Andy, get rid of the cursor. You can populate a recordset with from your stored procedure. Just use the command:

Set rs = command.execute

Remember: if you...

Thats your problem. The connection is Server side and your <SCRIPT> is client side. They do not know about each other. Notice your code uses Server.CreateObject

CreateObject

The CreateObject...

You may want to play with calling the sp using isql or osql (see bellow pulled from T-SQL help file):

Using the osql Utility (isql could be used too)

The osql utility...

This may sound strange but I had a problem once trying to get enterprise manager to register a SQL server over the Internet. For some reason I decided to...

Your sub is client side script is your include file initializing the connection object client side also? or is it maybe initializing it server side?

Sorry about that Should be working now