ADP2007/SQLServerExpress RIP

  • Thread starter Thread starter Burton Roberts
  • Start date Start date
B

Burton Roberts

I am giving up. I figured maybe there was a bug in the Data Link dialog in
finding a named instance of Express, and so I tried uninstalling and
reinstalling in order to create a default instance, but it keeps creating
the named instance. I even went so far as reinstalling VISTA before I
reinstallled SQL Server Express, and it still creates the named instance
without my prompting.

Anyway I can't create an ADP linked to my sql server file. I can create
links to tables from an accdb file, however, which according to some experts
is the prefered way to use Access with Sql Server.

I'm a bit OCD, so this is bothering me that I don't have the ADP option
anymore, and nobody from Microsoft made an effort to help. Being an MSDN
Universal subscriber, I am dissappointed.
 
One more thing. I turned on the SQL Browser service, and, at least the Data
Link dialog found the sql serever instance. But it still won't find the
database. Why would SQL Browser be disabled by default?
 
I don't have a copy of either Access 2007 or Vista or SQL-Server Express
installed but in IMHO, even if the Browser service is off, you don't need it
to access the named instance; all you have to do is to add yourself the name
of the instance after the name of the server (and add the name of the server
if it don't show up itself).

Same thing for the database: you can write the name yourself instead of
using the discovery service/combobox. However, in the case of the database,
the fact that its name doesn't show up might indicate that you may have a
permission problem.

Changing the protocol - for exemple using TCP/IP instead of a named pipe -
might also help you in solving your problem.
 
yes of course it makes it a named instance

it's not that big of a deal.. and it does work flawlessly
 
linking to SQL Server is not preferred

it requires a whole bunch more maintenance

anyone that uses MDB or ACCDB doesn't know SQL Server well enough to
pass a DBA certification.

I shoudl know; I'm a certified SQL Server 2005 DBA

-Hooker
 
Back
Top