MSDE timeout with wireless network enabled

Hi,
I have local MSDE installed on my laptop. When I am physically
connected to our network I can connect through my ODBC application
without issue.
However, when I have wireless networking enabled the first time I try to
connect I get a timeout. But, I'm able to immediately connect after
that initial timeout without a problem. This only occurs when wireless
networking is enabled, as the timeout does not occur with a physical LAN
connection.
I have the following installation:
MDAC SDK 2.8
MSDE 8.00.761
XP SP2
VS.NET 7.1
Any help would be greatly appreciated.
Thanks,
John
I am having a similar issue using SQL querries over a wireless connection.
Is there a technology that is better suited for wireless? Say .net?
Thanks in advance...
"JohnD" wrote:

> Hi,
> I have local MSDE installed on my laptop. When I am physically
> connected to our network I can connect through my ODBC application
> without issue.
> However, when I have wireless networking enabled the first time I try to
> connect I get a timeout. But, I'm able to immediately connect after
> that initial timeout without a problem. This only occurs when wireless
> networking is enabled, as the timeout does not occur with a physical LAN
> connection.
> I have the following installation:
> MDAC SDK 2.8
> MSDE 8.00.761
> XP SP2
> VS.NET 7.1
> Any help would be greatly appreciated.
> Thanks,
> John
>
|||Do you have the same problem if you use an IP address instead of the MSDE
instance name? Perhaps you're having a name resolution problem?
Jim
"Chris James" <Chris James@.discussions.microsoft.com> wrote in message
news:B19527EB-85E1-4DBC-9E51-A8CD463C1A89@.microsoft.com...[vbcol=seagreen]
>I am having a similar issue using SQL querries over a wireless connection.
> Is there a technology that is better suited for wireless? Say .net?
> Thanks in advance...
> "JohnD" wrote:
|||Thanks for the post Jim, Ive tried it using IP and Instance name... The
funny thing is that not all wireless installations have this issue, I have
two sites across the street and down about 1/4 mile. One site with approx
250' between wireless access point and client work fairly reliably, the other
is only 50' apart and they fail all the time. I wonder if its the
application making too many querries and boging down the wireless. Both
sites are using identical equipment as well.
"Jim Young" wrote:

> Do you have the same problem if you use an IP address instead of the MSDE
> instance name? Perhaps you're having a name resolution problem?
> Jim
> "Chris James" <Chris James@.discussions.microsoft.com> wrote in message
> news:B19527EB-85E1-4DBC-9E51-A8CD463C1A89@.microsoft.com...
>
>

msde speed issue

i have msde installed and running on my local pc. i have 2 db's which both reside on my loacl pc as well. both db's are the same. i have an app that access and retrives data for a db. when i run the app connected to db1 it takes abount 3 seconds to retrive and dispaly my data. when i connect to db2 with the same app, it takes about 35 seconds to retrive the same data. is there some sort of setting on db1 that needs to be set for db2 or can it be some sort of worm on db2 which has not effected db1. if you have any ideas please let me know.

Thank You,
ThomasHave you tried to rebuild index on both db ?|||how do you rebuild the index? can this be done using enterprise manager?

Thomas|||The simplest way to do it if you don't know much SQL is to execute the next command line tool:

sqlmaint -U login -P password -D dbname -RebldIdx 100
See SQL Server Books On Line (http://www.microsoft.com/sql/techinfo/productdoc/2000/books.asp) for more help|||when i try to run the following line:

sqlmaint -U sa -P eicon_dev -D belmont -RebldIdx 100

i get the following error

execution cannot continue as the language dependent resource file c:\resource\1033\sqlmaint.rll could not be loaded.|||Maybe sqlmaint is not installed (try to see if the file exists).

Otherwise, you should execute this T-SQL command on the tables called by your apps:

USE yourdb
GO
DBCC DBREINDEX (yourtable)
GO|||sorry i ran the command from the wrong location. i ran it from the proper p;ace and it update my indexes with out error and now my app runs perfectly. thak you very much. one question how often should i run this command? also is there any negative effects to running this comand?

Thanks,
Thomas|||Good ! :)

This frequency depends of the modification level of your data (insert / delete).

I've never had problem with this command. Maybe someone else have had here ?|||can i run this command on an sql database as well or does it only work on msde databases.|||No, you can run it on other edition of SQL Server (as Standard or Enterprise or Personal).

MSDE service manager just stops???

HI every one
I hope i dont sound too dumb here but i am having some problems with MSDE
I have it installed on my local machine and SQL server 2000 is also installed as i use the Enterprise manager to work on my database.
I dont have server software as my OS is win XP pro.
The problem i have is that after a while the MSDE service manager just stops and i cant get it to restart. and the only way is to uninstall it and reinstall.
i have tried to get the 2000 MSDE installed but i seem to not be able to get that working.
It is frustrating as i am developing a databse at home for a client (work experience) but i spend so much time keeping my shonky system running i loose time in developing.
is there somewhere i can learn to set my system up so i can develop a sql DB at home, or am i flogging a dead horsse.
any help greatly appreciated
Greg
Have you looked in the event log for errors?
"GREGO" wrote:

> HI every one
> I hope i dont sound too dumb here but i am having some problems with MSDE
> I have it installed on my local machine and SQL server 2000 is also installed as i use the Enterprise manager to work on my database.
> I dont have server software as my OS is win XP pro.
> The problem i have is that after a while the MSDE service manager just stops and i cant get it to restart. and the only way is to uninstall it and reinstall.
> i have tried to get the 2000 MSDE installed but i seem to not be able to get that working.
> It is frustrating as i am developing a databse at home for a client (work experience) but i spend so much time keeping my shonky system running i loose time in developing.
> is there somewhere i can learn to set my system up so i can develop a sql DB at home, or am i flogging a dead horsse.
> any help greatly appreciated
> Greg
|||Do you mean the windows event log?
i cant access the SQL server log as it is shut down and i cant access it
regards
greg
"Nigel Rivett" wrote:
[vbcol=seagreen]
> Have you looked in the event log for errors?
> "GREGO" wrote:
|||The SQL Server log is just a text file under the SQL Server directory,
normally in the LOG directory. Load the most recent one into Notepad and see
if there are any errors.
Jim
"GREGO" <GREGO@.discussions.microsoft.com> wrote in message
news:B074205A-A3A6-48DB-8EBB-350E3118AFDE@.microsoft.com...[vbcol=seagreen]
> Do you mean the windows event log?
> i cant access the SQL server log as it is shut down and i cant access it
> regards
> greg
> "Nigel Rivett" wrote:
MSDE[vbcol=seagreen]
installed as i use the Enterprise manager to work on my database.[vbcol=seagreen]
stops and i cant get it to restart. and the only way is to uninstall it and
reinstall.[vbcol=seagreen]
to get that working.[vbcol=seagreen]
(work experience) but i spend so much time keeping my shonky system
running i loose time in developing.[vbcol=seagreen]
sql DB at home, or am i flogging a dead horsse.[vbcol=seagreen]

msde security - windows mode?

Hi,
I want to be able to use SQL authentication on my local MSDE 2000 , I've
added a user using sp_addlogin, and try to connect using it, however it
always gives me 'not associated with a trusted SQL server connection'. Is
there any way I can force it to go to SQL mode without reinstalling it?
Thanks> I want to be able to use SQL authentication on my local MSDE 2000 , I've
> added a user using sp_addlogin, and try to connect using it, however it
> always gives me 'not associated with a trusted SQL server connection'. Is
> there any way I can force it to go to SQL mode without reinstalling it?
Yes - check the article at http://support.microsoft.com/kb/285097/EN-US/.
Dejan Sarka, SQL Server MVP
Associate Mentor
Solid Quality Learning
More than just Training
www.SolidQualityLearning.com|||> I want to be able to use SQL authentication on my local MSDE 2000 , I've
> added a user using sp_addlogin, and try to connect using it, however it
> always gives me 'not associated with a trusted SQL server connection'. Is
> there any way I can force it to go to SQL mode without reinstalling it?
Look at my answer in .security group.
Dejan Sarka, SQL Server MVP
Associate Mentor
Solid Quality Learning
More than just Training
www.SolidQualityLearning.com

MSDE on a local computer (not into a LAN)

I try to develop an installer that should install MSDE and an app that needs an MSDE database. But the problem is, that the ODBC (and my installer too) see no MSDE installation if the computer is no part of a network. If i plug the network cable, i can find the MSDE (SQL Server) without a problem. If i unplug it, my installer (and ODBC too) find no MSDE/SQL installation.

Can anyone help me? Maybe should i set another option when i install MSDE to make it work on a local computer that is no part of a network? Any advice would be a bid help.

Thank you,
IulianI don't know why i cannot work with MSDE when my computer is no more in network.. pls ..some help would be so needed|||So? Anyone any idea?|||I've got a .CAB and Setup.exe that installs for clients :

- MSDE
- Minimum SQL Server with the db Master, tempdb,... (free part)

Plus a little free Entreprise-Manager-Look-A-Like program

does this interast you ?|||and functions and when the client have a local computer (that isn't in a network)?

Many thanks for your time and help!!!|||the file .Cab is too big to be sent by here
email me your e-mail so that i can send you the package|||i have send u my email adress.

I wait your file.

Tnks again|||i didn't receive your email

MSDE names instance as Replication publisher?

I'm trying to setup a named instance of MSDE on my local machine, as a
Replication Publisher and I always get an error. My named instance is called
"MSDE"
Error 18483: Could not connect to server 'mymachine\msde' because
'distributor_admin' is not defined as a remote login at the server.
The only remote thing I can find on the MS support site is:
http://support.microsoft.com/default...;en-us;Q324992
but that really didn't help, since it was talking about IP addresses and not
named instances of MSDE.
Can anyone help me get this resolved?
FYI... i also found this article:
http://support.microsoft.com/default...b;en-us;818334
which talks about server names... when I look at the @.@.ServerName variable,
it returns my hostname and instance name: CORPDALL140451\MSDE
is that the problem? I already have a SQL Server instance with no name
running on my machine, but I must have this MSDE instance be the replication
publisher.
"Derick Bailey" <DerickBailey@.srcp.com> wrote in message
news:eR7q4xUtEHA.3788@.TK2MSFTNGP09.phx.gbl...
> I'm trying to setup a named instance of MSDE on my local machine, as a
> Replication Publisher and I always get an error. My named instance is
> called "MSDE"
> Error 18483: Could not connect to server 'mymachine\msde' because
> 'distributor_admin' is not defined as a remote login at the server.
> The only remote thing I can find on the MS support site is:
> http://support.microsoft.com/default...;en-us;Q324992
> but that really didn't help, since it was talking about IP addresses and
> not named instances of MSDE.
> Can anyone help me get this resolved?
>

MSDE Memory Issue

I am curious if anybody has seen or had this proble before.
Starting today whenever I do anything to my local MSDE 2000 SP3 installmemory just gets eaten up on my machine until there is none left andthe machine starts crawling. I end up having to stop SQL Server andanything local that might have been using it to get control of mymachine back. As I speak I am looking at Task Manager on the the othermonitor and memory is just draining like there is no tomorrow. Andthere are no queries running right now. It happens when I try to runany SELECT, browse the local machine via Enterprise Manager, and alsowhen I have tried changing the width of a column. AFAIK it happens witheverything I have tried today. I am on SP3 so I am prettycurrent. I can't think of anything that has changed, and I am doingnothing except for some small time local Win32 development.
Any ideas would be appreciated. I'll keep looking around the Internet to see if I can find anything.
TIA
Hmmm, well you might check this KB article:INF: SQL Server Memory Usage. SQL Server will use whatever memory is available to it.

MSDE login problem

After installing MSDE 2000 in mixed mode local access worked fine.
Accessing through network with enterprice manager at first didn't work.
Fixed by activating network protocols "TCP/IP" and "Named pipes" in database properties.
But only the first time. After that login by SQL user and password is denied after restart local MSDE machine.

Anyone know why?

thanks in advanceAfter that login by SQL user and password is denied after restart local MSDE machine

With this I mean access from other machines on the network. Local login is working ok.|||Solution found!

Install MSDE again with DISABLENETWORKPROTOCOLS=0.
Changing it afterwards with SQL Server enterprice manager doesn't work.

just for those who are having the same problem

MSDE local host failure

Why would the localhost not install but rather our named instance will
install? We have an inconsistent problem with installations. Our app
depends on a named instance and a secondary app depends on local host
so we need both. However, systems that have previous installed,
uninstalled and try to reinstall the current app, only the local host
will install or the named instance will install, but not both. This
doesn't happen on all machines either. We encounter the usual errors
as seen in this group such as 'server not found', etc. and I can
usually get MSDE installed only if after I uninstall, I delete the MSDE
references in the registry. Yet I am baffled how MSDE would install
the named instance but not the local. This has primarily been occuring
on XP sp2 machines and all data resides on the client machine where
MSDE is installed.
Any suggestions?
Thanks.
hi,
Colleen wrote:
> Why would the localhost not install but rather our named instance will
> install? We have an inconsistent problem with installations. Our app
> depends on a named instance and a secondary app depends on local host
> so we need both. However, systems that have previous installed,
> uninstalled and try to reinstall the current app, only the local host
> will install or the named instance will install, but not both. This
> doesn't happen on all machines either. We encounter the usual errors
> as seen in this group such as 'server not found', etc. and I can
> usually get MSDE installed only if after I uninstall, I delete the
> MSDE references in the registry. Yet I am baffled how MSDE would
> install the named instance but not the local. This has primarily
> been occuring on XP sp2 machines and all data resides on the client
> machine where MSDE is installed.
just to test, I installed 2 additional named instances of MSDE (sp3 and sp4)
on a pc hosting 1 deafault instance of MSDE sp4...
and I am unable to reproduce the problem... of course, uninstalling an
instance requires you to manually clean the file system, or manually remove
all file system and windows registry entries...
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.14.0 - DbaMgr ver 0.59.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply

MSDE License when used with non-Microsoft database.

MSDE would make a great local cache in my app that uses dialup networking.
However, the App comminicates with sybase running on Linux.
Am I allows to use MSDE this way? Or should I use an open source database
for a local cache?
Thanks
From http://www.microsoft.com/sql/msde/howtobuy/msdeuse.asp it looks like
you're ok using MSDE.
joe.
"Karl" <Karl@.discussions.microsoft.com> wrote in message
news:F055A34F-DE27-4B55-A0B7-3E1B14F33097@.microsoft.com...
> MSDE would make a great local cache in my app that uses dialup networking.
> However, the App comminicates with sybase running on Linux.
> Am I allows to use MSDE this way? Or should I use an open source database
> for a local cache?
> Thanks
>