Hello,
I am new for MSDE.
Our ISA2004 server has report in *.mdf and *.ldf format.
We don't have SQL server. I installed MSDE on my workstation.
Is there any step-by-step instruction to show me, how to create Access
Project to view the ISA2004 report?
ThanksHi
Your mdf and ldf files are (probably) not a report but data and log files
for a SQL Server database. You can attach these to your MSDE instance with
the system stored procedure sp_attach_db see
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_sp_ae-az_52oy.asp.
To call this stored procedure you will need to use the osql utility at a
command prompt see
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/coprompt/cp_osql_1wxl.asp.
All this information is downloadable in Books Online which will allow you to
read and search for information at
http://www.microsoft.com/downloads/details.aspx?familyid=a6f79cb1-a420-445f-8a4b-bd77a7da194b&displaylang=en
This may help you get started with using Access as the from end for MSDE
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnacc2k2/html/odc_msdeintro.asp.
There are also dedicated newsgroups for access (microsoft.public.access) and
MSDE (microsoft.public.sqlserver.msde), there are also other language
specific groups which you can search/browse at
http://www.microsoft.com/communities/newsgroups/en-us/default.aspx
John
"Newbie" wrote:
> Hello,
> I am new for MSDE.
> Our ISA2004 server has report in *.mdf and *.ldf format.
> We don't have SQL server. I installed MSDE on my workstation.
> Is there any step-by-step instruction to show me, how to create Access
> Project to view the ISA2004 report?
> Thanks
>|||Thanks
"John Bell" wrote:
> Hi
> Your mdf and ldf files are (probably) not a report but data and log files
> for a SQL Server database. You can attach these to your MSDE instance with
> the system stored procedure sp_attach_db see
> http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_sp_ae-az_52oy.asp.
> To call this stored procedure you will need to use the osql utility at a
> command prompt see
> http://msdn.microsoft.com/library/default.asp?url=/library/en-us/coprompt/cp_osql_1wxl.asp.
> All this information is downloadable in Books Online which will allow you to
> read and search for information at
> http://www.microsoft.com/downloads/details.aspx?familyid=a6f79cb1-a420-445f-8a4b-bd77a7da194b&displaylang=en
> This may help you get started with using Access as the from end for MSDE
> http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnacc2k2/html/odc_msdeintro.asp.
> There are also dedicated newsgroups for access (microsoft.public.access) and
> MSDE (microsoft.public.sqlserver.msde), there are also other language
> specific groups which you can search/browse at
> http://www.microsoft.com/communities/newsgroups/en-us/default.aspx
> John
> "Newbie" wrote:
> > Hello,
> >
> > I am new for MSDE.
> >
> > Our ISA2004 server has report in *.mdf and *.ldf format.
> > We don't have SQL server. I installed MSDE on my workstation.
> >
> > Is there any step-by-step instruction to show me, how to create Access
> > Project to view the ISA2004 report?
> >
> > Thanks
> >
> >|||Hello John,
May I ask one more question?
1. I installed MSDE 2000 on ISA 2004 server.
2. I use Access 2003 to create a progect named ISA2004.adp connect to
ISA2004SQL. The connection test is OK. (I have 2 tables, FireWall and
WebProxy)
3. I use ODBC to create a DSN named ISA2004, ISA2004 use ISA2004SQL w/SQL
server driver. ('with Windows NT authentication using the network login ID'
checked)
4. I connect ISA 2004 server to this ODBC, then I got the error message.
The ISA Server Web filter was unable to open ODBC Data Source ISA2004,
Table: WebProxy, under User Name []. The ODBC Error description is:
[State=IM002][Error=0][Microsoft][ODBC Driver Manager] Data source name not
found and no default driver specified .
or with administrator login
The Microsoft Firewall was unable to open ODBC Data Source Isa2004, Table:
FireWall, under User Name [Server\Administrator]. The ODBC Error description
is: [State=IM002][Error=0][Microsoft][ODBC Driver Manager] Data source name
not found and no default driver specified .
Thanks
"John Bell" wrote:
> Hi
> Your mdf and ldf files are (probably) not a report but data and log files
> for a SQL Server database. You can attach these to your MSDE instance with
> the system stored procedure sp_attach_db see
> http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_sp_ae-az_52oy.asp.
> To call this stored procedure you will need to use the osql utility at a
> command prompt see
> http://msdn.microsoft.com/library/default.asp?url=/library/en-us/coprompt/cp_osql_1wxl.asp.
> All this information is downloadable in Books Online which will allow you to
> read and search for information at
> http://www.microsoft.com/downloads/details.aspx?familyid=a6f79cb1-a420-445f-8a4b-bd77a7da194b&displaylang=en
> This may help you get started with using Access as the from end for MSDE
> http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnacc2k2/html/odc_msdeintro.asp.
> There are also dedicated newsgroups for access (microsoft.public.access) and
> MSDE (microsoft.public.sqlserver.msde), there are also other language
> specific groups which you can search/browse at
> http://www.microsoft.com/communities/newsgroups/en-us/default.aspx
> John
> "Newbie" wrote:
> > Hello,
> >
> > I am new for MSDE.
> >
> > Our ISA2004 server has report in *.mdf and *.ldf format.
> > We don't have SQL server. I installed MSDE on my workstation.
> >
> > Is there any step-by-step instruction to show me, how to create Access
> > Project to view the ISA2004 report?
> >
> > Thanks
> >
> >|||Hi
From a command prompt can you use osql to connect to the instance and then
do select name from masters..sysdatabases
GO
If the name of your database does not appear then you will need to use
sp_attach_db as described in the previous links.
John
"Newbie" wrote:
> Hello John,
> May I ask one more question?
> 1. I installed MSDE 2000 on ISA 2004 server.
> 2. I use Access 2003 to create a progect named ISA2004.adp connect to
> ISA2004SQL. The connection test is OK. (I have 2 tables, FireWall and
> WebProxy)
> 3. I use ODBC to create a DSN named ISA2004, ISA2004 use ISA2004SQL w/SQL
> server driver. ('with Windows NT authentication using the network login ID'
> checked)
> 4. I connect ISA 2004 server to this ODBC, then I got the error message.
> The ISA Server Web filter was unable to open ODBC Data Source ISA2004,
> Table: WebProxy, under User Name []. The ODBC Error description is:
> [State=IM002][Error=0][Microsoft][ODBC Driver Manager] Data source name not
> found and no default driver specified .
> or with administrator login
> The Microsoft Firewall was unable to open ODBC Data Source Isa2004, Table:
> FireWall, under User Name [Server\Administrator]. The ODBC Error description
> is: [State=IM002][Error=0][Microsoft][ODBC Driver Manager] Data source name
> not found and no default driver specified .
> Thanks
>
> "John Bell" wrote:
> > Hi
> >
> > Your mdf and ldf files are (probably) not a report but data and log files
> > for a SQL Server database. You can attach these to your MSDE instance with
> > the system stored procedure sp_attach_db see
> > http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_sp_ae-az_52oy.asp.
> > To call this stored procedure you will need to use the osql utility at a
> > command prompt see
> > http://msdn.microsoft.com/library/default.asp?url=/library/en-us/coprompt/cp_osql_1wxl.asp.
> > All this information is downloadable in Books Online which will allow you to
> > read and search for information at
> > http://www.microsoft.com/downloads/details.aspx?familyid=a6f79cb1-a420-445f-8a4b-bd77a7da194b&displaylang=en
> >
> > This may help you get started with using Access as the from end for MSDE
> > http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnacc2k2/html/odc_msdeintro.asp.
> > There are also dedicated newsgroups for access (microsoft.public.access) and
> > MSDE (microsoft.public.sqlserver.msde), there are also other language
> > specific groups which you can search/browse at
> > http://www.microsoft.com/communities/newsgroups/en-us/default.aspx
> >
> > John
> >
> > "Newbie" wrote:
> >
> > > Hello,
> > >
> > > I am new for MSDE.
> > >
> > > Our ISA2004 server has report in *.mdf and *.ldf format.
> > > We don't have SQL server. I installed MSDE on my workstation.
> > >
> > > Is there any step-by-step instruction to show me, how to create Access
> > > Project to view the ISA2004 report?
> > >
> > > Thanks
> > >
> > >
Cobr94 wrote:
