Access cannot see MSDE when network cable disonnected

When my users are in the field and try to switch databases the
connection tool cannot see any servers even thought I know they are
there. The data link properties dialog does not see them. Also my data
entry program also cannot see them but is using sqldmo to list the
servers. However my SQL Service manager (inside my task bar) Can see
them. Any pointers on how to let the access project or the sqldmo
objects see the servers when they are disconnected. I even tried using
ODBC with no luck.
Thanks for any help.
Shane
Hello,
Personnaly, I use the following
Dim ListSvr As NameList
Set ListSvr = SQLDMO.ListAvailableSQLServers
' I add the servers to a collection after removing the ones I don't want
to show
' After that,
Set oServer = New SQLDMO.SQLServer2
Set ListSvr = oServer.ListInstalledInstances
' This function always work but only for the local instances (named or not)
' I add the needed servers to the other collection but I don't put the
servers already listed before
Marc Allard
Allcomp
Shane Lim wrote:
> When my users are in the field and try to switch databases the
> connection tool cannot see any servers even thought I know they are
> there. The data link properties dialog does not see them. Also my data
> entry program also cannot see them but is using sqldmo to list the
> servers. However my SQL Service manager (inside my task bar) Can see
> them. Any pointers on how to let the access project or the sqldmo
> objects see the servers when they are disconnected. I even tried using
> ODBC with no luck.
> Thanks for any help.
> Shane
>
|||That is PERFECT!!
On Fri, 25 Feb 2005 10:39:39 +0100, Allcomp <marc@.nospam.allcomp.be>
wrote:
[vbcol=seagreen]
>Hello,
>Personnaly, I use the following
>Dim ListSvr As NameList
>Set ListSvr = SQLDMO.ListAvailableSQLServers
>' I add the servers to a collection after removing the ones I don't want
>to show
>' After that,
>Set oServer = New SQLDMO.SQLServer2
>Set ListSvr = oServer.ListInstalledInstances
>' This function always work but only for the local instances (named or not)
>' I add the needed servers to the other collection but I don't put the
>servers already listed before
>Marc Allard
>Allcomp
>
>Shane Lim wrote:

Access

Is Access the best tool to use with SQL 2000 Server for a medium sized
company. This is the direction they plan to go with & it doesn't seem right
to me.
mare
Define "best." Yes, it is a tool, but there are many. It is easy to
develop and query attached SQL Server files.
Sincerely,
Anthony Thomas

"mare" <mare@.discussions.microsoft.com> wrote in message
news:62DC38BD-53BE-4B31-BF5D-92B8B29AFF66@.microsoft.com...
Is Access the best tool to use with SQL 2000 Server for a medium sized
company. This is the direction they plan to go with & it doesn't seem right
to me.
mare
|||mare,
To do what? Reporting, querying, full blown app? I personally would say
no. Depends on the skills you have in-house, budget, requirements, etc.
Many variables...
Define medium-sized company for us too. The UK govenment consider a
small or medium sized enterprise (SME) to be fewer than 250 employees,
and annual turnover not exceeding €40million. Your idea might be different.
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602m.html
mare wrote:
> Is Access the best tool to use with SQL 2000 Server for a medium sized
> company. This is the direction they plan to go with & it doesn't seem right
> to me.
>
> mare

Access

Is Access the best tool to use with SQL 2000 Server for a medium sized
company. This is the direction they plan to go with & it doesn't seem right
to me.
mareDefine "best." Yes, it is a tool, but there are many. It is easy to
develop and query attached SQL Server files.
Sincerely,
Anthony Thomas
"mare" <mare@.discussions.microsoft.com> wrote in message
news:62DC38BD-53BE-4B31-BF5D-92B8B29AFF66@.microsoft.com...
Is Access the best tool to use with SQL 2000 Server for a medium sized
company. This is the direction they plan to go with & it doesn't seem right
to me.
mare|||mare,
To do what? Reporting, querying, full blown app? I personally would say
no. Depends on the skills you have in-house, budget, requirements, etc.
Many variables...
Define medium-sized company for us too. The UK govenment consider a
small or medium sized enterprise (SME) to be fewer than 250 employees,
and annual turnover not exceeding â?¬40million. Your idea might be different.
--
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602m.html
mare wrote:
> Is Access the best tool to use with SQL 2000 Server for a medium sized
> company. This is the direction they plan to go with & it doesn't seem right
> to me.
>
> mare

about unstructured data analysis again~~

well...actually I just want to know a brief concept about using this tool to
analyze unstructured information. Does SQL server only apply for structured
information?if not, then what advantages can we get if we use this tool to
analyze unstructured data?Thanks again for your reply : )
No need to repost. Replied in your previous thread.
David Portas
SQL Server MVP

about unstructured data analysis again~~

well...actually I just want to know a brief concept about using this tool to
analyze unstructured information. Does SQL server only apply for structured
information?if not, then what advantages can we get if we use this tool to
analyze unstructured data?Thanks again for your reply : )No need to repost. Replied in your previous thread.
--
David Portas
SQL Server MVP
--|||i'm really sorry about this.
i was just too eager to know the answer and i thought it may be no one
seeing my answer, so i post the same question repeatedly.sorry~~~
"David Portas" wrote:
> No need to repost. Replied in your previous thread.
> --
> David Portas
> SQL Server MVP
> --
>
>

about unstructured data analysis again~~

well...actually I just want to know a brief concept about using this tool to
analyze unstructured information. Does SQL server only apply for structured
information?if not, then what advantages can we get if we use this tool to
analyze unstructured data?Thanks again for your reply : )No need to repost. Replied in your previous thread.
David Portas
SQL Server MVP
--

About SQLH2 installation problem .....

hi,
I just tried to install SQL Health and Performance Tool (SQLH2), but when
set the schedule task procedure of the installation, it occured error. After
I read the guide, my server is Window 2000 server, it said it can only
support window server 2003 & window XP(I know that). And the wizard said
press "continue" to ignore that problem and need to set the schedule by
manual, but after I pressed "continue", it still occured that error and no
any other response of it.
So, anyone meet that error as like as me b4?
I feel appreciate anyone can help me ! ^^
Regards,
Tarek ^^'
Tarek's WorkShop
This is a bug in configuration utility.
At this point SQLH2 is installed and configured. You only need to add task
to run it on schedule. You have to do that manually on W2K.
Command to run (int the task) - sqlh2.exe
Thanks
Grigory
This posting is provided "AS IS" with no warranties, and confers no rights.
Please reply to the newsgroups only, thanks.
"Tarek" <Tarek@.discussions.microsoft.com> wrote in message
news:86829E85-5171-46DD-9B1F-35522EB726AF@.microsoft.com...
> hi,
> I just tried to install SQL Health and Performance Tool (SQLH2), but when
> set the schedule task procedure of the installation, it occured error.
After
> I read the guide, my server is Window 2000 server, it said it can only
> support window server 2003 & window XP(I know that). And the wizard said
> press "continue" to ignore that problem and need to set the schedule by
> manual, but after I pressed "continue", it still occured that error and no
> any other response of it.
> So, anyone meet that error as like as me b4?
> I feel appreciate anyone can help me ! ^^
>
> --
> Regards,
> Tarek ^^'
> --
> Tarek's WorkShop
|||thanks Grigory, let me try it.
Tarek ^^
"Grigory Pogulsky [MS]" wrote:

> This is a bug in configuration utility.
> At this point SQLH2 is installed and configured. You only need to add task
> to run it on schedule. You have to do that manually on W2K.
> Command to run (int the task) - sqlh2.exe
> --
> Thanks
> Grigory
> This posting is provided "AS IS" with no warranties, and confers no rights.
> Please reply to the newsgroups only, thanks.
>
> "Tarek" <Tarek@.discussions.microsoft.com> wrote in message
> news:86829E85-5171-46DD-9B1F-35522EB726AF@.microsoft.com...
> After
>
>