Dennis,
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?
dbLogin doesn't take any parameter, but returns a pointer, which point to
LOGINREC. Then I call dbsetlname to set username, make another dbsetlname
call to set password. Last, dbOpen sets SQL server I want to connect to.
Such works well in Windows apps.
Regards,
Jim
-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On
Behalf Of [EMAIL PROTECTED]
Sent: Monday, May 28, 2001 01:55 PM
To: [EMAIL PROTECTED]
Subject: RE: [DUG]: MS SQL, IIS, Delphi
Jim,
> Could you tell me how to set up TCP/IP connection to MS
> SQL.
One of the client utilities SQL server installs is the Client Network
Utility (Should be somewhere in the start menu). Run this, click on the add
button, type in the server name (or an alias name), select TCP/IP, type in
the host name (leave the port as default), and click OK.
> As my code is stuck in dbLogin, which doesn't take any parameter,
Where do you specify which server to connect to?
> how do I
> code to log in as another user?
Take a look at MS knowledgebase article: Q96005. Also look up help on
LogonUser, ImpersonateLoggedOnUser.
Regards,
Dennis.
> -----Original Message-----
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
> Sent: Monday, 28 May 2001 11:58
> To: Multiple recipients of list delphi
> Subject: RE: [DUG]: MS SQL, IIS, Delphi
>
>
> Thank you Dennis, Could you tell me how to set up TCP/IP connection to MS
> SQL.
>
> As my code is stuck in dbLogin, which doesn't take any parameter, how do I
> code to log in as another user?
>
> Regards,
>
> Jim
>
> -----Original Message-----
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On
> Behalf Of Dennis Chuah
> Sent: Monday, May 28, 2001 11:22 AM
> To: Multiple recipients of list delphi
> Subject: RE: [DUG]: MS SQL, IIS, Delphi
>
>
>
> Jim,
>
> I think your problem is security - when running under IIS, your Active-X
> component effectively runs under the guest user's privileges.
> This user may
> not be able to access the database, especially if you are using
> named pipes.
> Try setting up the connection as TCP/IP (use the client config tool). The
> other alternative is to code your Active-X component to log in as another
> user.
>
> Regards,
> Dennis.
>
> > -----Original Message-----
> > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
> > Sent: Friday, 25 May 2001 16:29
> > To: Multiple recipients of list delphi
> > Subject: [DUG]: MS SQL, IIS, Delphi
> >
> >
> > Hi,
> >
> > Does anyone have trouble to talk to MS SQL Server inside IIS?
> >
> > I've got this working in Windows program.
> >
> > Cheers,
> >
> >
> > Jim
> > ------------------------------------------------------------------
> > ---------
> > 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"
>
> ------------------------------------------------------------------
> ---------
> 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"
---------------------------------------------------------------------------
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"
