Re: Is it possible that OLEDB connection is not available on a PC?
- From: "Bob Barrows [MVP]" <reb01501@xxxxxxxxxxxxxxx>
- Date: Sat, 22 Sep 2007 08:14:54 -0400
Blackberry wrote:
Hi Bob
Thanks for the reply. Hope you are well.
When I installed MSDE I used these params in the setup.ini:
sapwd=mypassword
securitymode=sql
networkprotocols=0 << think I tried 1 as well can never remember
which way this has to go round
Anyway I went into the installed Microsoft Server/80/Tools/Bin folder
and ran the network config util, found that tcp/ip wasn't selected,
moved it across (also put named pipes over for the fun of it!!),
stopped and started the MSSQLServer service and still no joy.
Hmm, unlikely as it seems given your OS, corrupted MDAC installation? Go to
msdn and search for the Component Checker; download it and .
Give the guys in this group a little more time to see your post and respond.
If you still have no joy, I suggest you post to a SQL Server group.
Just whilst I've got you, I believe there MSDE has been updated quite
a bit and comes in 2 versions now:
SQL Express - MSDE updated
Sort of. It's the SQL2005 lite. MSDE no longer exists in SQL 2005. You can
read about it at www.microsoft.com/sql
and SQL Desktop - just a few single filesI'm not familiar with this one. You should ask on a SQL Server group
Am I right re the above?
Is SQL Express easier to install and allows more user connections?
If you cannot connect to MSDE, I don't imagine that it will be easier with
SQL Express. However, installing it may correct the problems you are having
with OLE DB ... it's worth a try.
--
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so I
don't check it very often. If you must reply off-line, then remove the
"NO SPAM"
.
- References:
- Is it possible that OLEDB connection is not available on a PC?
- From: Blackberry
- Re: Is it possible that OLEDB connection is not available on a PC?
- From: Bob Barrows [MVP]
- Re: Is it possible that OLEDB connection is not available on a PC?
- From: Blackberry
- Is it possible that OLEDB connection is not available on a PC?
- Prev by Date: Re: Is it possible that OLEDB connection is not available on a PC?
- Next by Date: Using ADO, all the records update instead of just 1. What am i doing wrong?
- Previous by thread: Re: Is it possible that OLEDB connection is not available on a PC?
- Next by thread: Using ADO, all the records update instead of just 1. What am i doing wrong?
- Index(es):
Relevant Pages
|
Loading
