sql server msde: Connection failure on MSDE 2000/XP installation -- sql server msde

Connection failure on MSDE 2000/XP installation

Fintan
3/30/2005 1:27:01 PM

sql server msde:

We have installed MSDE 2000 on XP For Tablet PC. All
applications that use ODBC to connect to the database work
well, however those applications that use either DBLIB or
E/SQL (embedded SQL built on top of DBLIB) return a "Failed
to get DBPROCESS" error. MSDE was installed with
SQL-Authentication and all apps are started locally on the
server running MSDE. All applications run succesfully under
SQL 2000. Using SQL Profiler to trace application-activity
results in NO events being logged/traced, suggesting that
no SQL commands ever reach the server. Any ideas ?

Re: Connection failure on MSDE 2000/XP installation

Greg Low [MVP]
3/31/2005 9:19:16 AM

If they are connecting via tcp/ip, do you have an exception in the firewall
(presuming XP SP2 is installed)?

Is the protocol they are connecting on enabled? (see svrnetcn.exe).

HTH,

--
Greg Low [MVP]
MSDE Manager SQL Tools
www.whitebearconsulting.com

[quoted text, click to view]