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"