ADOExpress, SQL Server, connectioning externally.

Thread View: borland.public.cppbuilder.database.ado

3 messages

[T] Back to Threads [V] Tree View [G] Group Articles

3 total messages Started by Peter Dragun Thu, 09 Nov 2000 17:58

#6065

Author: Peter Dragun
Date: Thu, 09 Nov 2000 17:58

17 lines
1517 bytes

I am using C++ Builder 5.0, with ADOExpress, to connect to SQL Server 7.0
Database.  I setup my ADOConnection string
using the SQL Provider, and my Datasource is my external ip address.  When I
run the application internally, I can connect with no problem.   I tried
running the app externally, and I receive "cannot find server" error
message.  I figured that it was my Firewall, (winroute)  so I turned the
engine off.  I ran the app again, and now I received an error message of
access denied.  What I am missing?



--
Peter Dragun, pdragun@asifluid.com
Alternate Solutions
System/Software Designer
-
www.asifluid.com

Re: ADOExpress, SQL Server, connectioning externally.

#6067

Author: Mark Cashman (TeamB)
Date: Thu, 09 Nov 2000 16:46

15 lines
1375 bytes

Hi, Peter!

Please do not cross or multipost as that is against newsgroup guidelines
- http://www.borland.com/newsgroups

This is the best newsgroup for your question, however.

Thanks!

------
Mark Cashman, TeamB C++ Builder
http://www.temporaldoorway.com/programming/index.htm
C++ Builder, JBuilder programming information
Home of The C++ Builder Programmer's Webring - Join us!
------

Re: ADOExpress, SQL Server, connectioning externally.

#6069

Author: Peter Dragun
Date: Thu, 09 Nov 2000 20:22

10 lines
1453 bytes

I apologize for crossposting.  I read your post in the sql server group.

When I setup an account for my application to use, in the Security section,
I click on logins
Add a new login, for Authentication, should it be windows nt or sql server
auth?
If it is Windows nt auth, then I would have to make  a specific account, and
could that account just be a domain account?

Thank you,

Thread Navigation

This is a paginated view of messages in the thread with full content displayed inline.

Messages are displayed in chronological order, with the original post highlighted in green.

Use pagination controls to navigate through all messages in large threads.

Back to All Threads