SQL2000-Database, SQLExpress, Access

[Guest]

I have a big MSSQL2000-Database. I want to query the data. I have no
SQL-Server yet. Is it a good Idea to install SQLExpress, attach the Datafile
and connect to Access 2003? Who has experiences?

 

[Sylvain Lafontaine]

IMHO, iIf the database is smaller than 4Gigs (if I remember correctly); you
shouldn't have any problem detaching it, copying it and reattaching it to
SQL-Express 2005.

You can also try with MSDE 2000 if you want to be absolutely sure to not
have any compatibility problem but I don't thing that you will any.

If you want only to query data and that you already have your Access 2003
application (MDB or ADP), Access 2003 will be fine for both; however, if you
want to make some design changes in ADP, I'm not sure that you will be able
to do so if you are using SQL-Express 2005 instead of MSDE 2000.

 

[Guest]

Hello Silvain,
installation of SQLExpress and attachment of the database to SQLExpress are
without problems. But with Access I can't get connection to the data.
Now I try MSDE.

 

[Sylvain Lafontaine]

First, take a look at these:

http://support.microsoft.com/default.aspx?scid=kb;EN-US;914277

http://www.datamasker.com/SSE2005_NetworkCfg.htm

http://msdn2.microsoft.com/en-us/library/ms345318(SQL.90).aspx

http://blogs.msdn.com/sqlexpress/archive/2004/07/23/192044.aspx

 

[Guest]

Hello Silvain,
thank you for the good resources.
I tryed sqlcmd -S.\sqlexpress. The SQLCMD window pops up, is waiting a while
an then disapears.
The SQLExpress-Server is running, I can see in the task bar. SQL Server
Management Studio Express is working well.
What can I do?

Thank you for helping.
Theo Weidmann

 

[Sylvain Lafontaine]

Did you install the SQL-Server Express Management Studio (or something like
that) and yes, what does it give?

With Access, you should be able to connect to an instance of SQL-Server
Express for retrieving data in either ODBC (for MDB file) or OLEDB modes.