Hi All,

I haven't still solved the problem.

Let's go one step back to using BDE and ODBC to access MS SQL(version6.0)
database.

For testing, I have the following code,

   with TDatabase.Create(nil) do
      try
        AliasName:='MSSQL1';
        DatabaseName:='db1';
        LoginPrompt:=False;
        Connected:=True;
        with TQuery.Create(nil) do
          try
            DatabaseName:='db1';
            SQL.Clear;
            SQL.Add('select Field1 from table1');
            Active:=True;
            returnstring:=FieldByName('Field1').Value;
          finally
            Free;
          end;
      finally
        Free;
      end;

which runs in Windows application and get returnstring correctly.

Obviously we couldn't turn this into ActiveX/COM object and use for a web
page.

How do we do the similar thing in COM object? In other words, how do make a
data-aware COM objects?


Regards,

Jim

-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On
Behalf Of [EMAIL PROTECTED]
Sent: Monday, May 28, 2001 07:46 PM
To: [EMAIL PROTECTED]
Subject: Re: [DUG]: MS SQL, IIS, Delphi


> I am using SQL 6.0, the untility I could find is called SQL Server Client
> Configuration Utility. Then I go Advanced page add my server and TCP/IP
> sockets. Still not go. What else shall I do?

is this happening on a domain?   is it possible the user name you're
using to access the DB is a local user on the db host?

If so - try making this user a domain user instead - or set up a
new domain user and pass that name to your activex login.

-ns




---------------------------------------------------------------------------
    New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED]
                  Website: http://www.delphi.org.nz
To UnSub, send email to: [EMAIL PROTECTED]
with body of "unsubscribe delphi"

---------------------------------------------------------------------------
    New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED]
                  Website: http://www.delphi.org.nz
To UnSub, send email to: [EMAIL PROTECTED] 
with body of "unsubscribe delphi"

Reply via email to