Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

MSDE vs SQL Server 2000

Status
Not open for further replies.
Yesca

Yesca

Programmer
Mar 19, 2002
20
CA
Given an ADO connection object set with provider and connection instructions, it is possible to connect to either a SQL Server 2000 or MSDE Server by altering the login info only. Same provider for both.

How would I connect, then tell if i'm connected to SQL Server or MSDE?
 
Status
Not open for further replies.

Similar threads

Krus1972
  • Locked
  • Question
Office Web Components on Server 2003 / IIS
Replies
0
Views
42
Krus1972
Krus1972
wshm
  • Locked
  • Question
ms access ole server/ active x ERROR
Replies
0
Views
54
wshm
wshm
jolan7
  • Locked
  • Question
Opening a local file from server
Replies
1
Views
41
Offmind
Offmind
kunai
  • Locked
  • Question
mswinsck with windows server 2003
Replies
0
Views
52
kunai
kunai
Manch
  • Locked
  • Question
Trapping SQL Server Errors
Replies
0
Views
44
Manch
Manch

Part and Inventory Search

Sponsor

Back
Top