Can not connect to SQL Server database with http://Localhost

I followed an example from the Chap 12 of "Beginning Active Server
Pages 3.0 (Wrox 1999)" to connect to my Access and SQL Server databases
with the following Coonection Strings.
objConn.Open "Provider=Microsoft.Jet.OLEDB.4.0;" & _
"Data Source=G:\databases\Movie2000.mdb;" & _
"Persist Security Info=False"
objConn.Open "Provider=SQLOLEDB" & _
"User ID=sa;Initial Catalog=Movie;" & _
"Data Source=G:\Program Files\Microsoft SQL
Server\MSSQL\Data\Movie2000.mdf"
I copied the Movie2000.mdb to my HD, G:\databases. It worked very well
with the http://Localhost, where my Connect.asp file is located. I can
open and display a Recordset object from the ASccess Movies table. But
the connection to SQL Server database failed.
Do I need to modify the ADO connection string properties, i.e.
Provider and/or Dara Source?
TIA,
Jeffrey
Hi
With SQL Server, the client does not know where the DB is on disk, you just
refer to it by name.
objConn.Open "Provider=SQLOLEDB" & _
"User ID=sa;Initial Catalog=Movie;" & _
"Data Source=Movie2000"
This can be accessed after the database is restored or attached into SQL
Server.
Regards
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
<cjeffwang@.gmail.com> wrote in message
news:1118821257.151086.23940@.g43g2000cwa.googlegro ups.com...
> I followed an example from the Chap 12 of "Beginning Active Server
> Pages 3.0 (Wrox 1999)" to connect to my Access and SQL Server databases
> with the following Coonection Strings.
> objConn.Open "Provider=Microsoft.Jet.OLEDB.4.0;" & _
> "Data Source=G:\databases\Movie2000.mdb;" & _
> "Persist Security Info=False"
> objConn.Open "Provider=SQLOLEDB" & _
> "User ID=sa;Initial Catalog=Movie;" & _
> "Data Source=G:\Program Files\Microsoft SQL
> Server\MSSQL\Data\Movie2000.mdf"
> I copied the Movie2000.mdb to my HD, G:\databases. It worked very well
> with the http://Localhost, where my Connect.asp file is located. I can
> open and display a Recordset object from the ASccess Movies table. But
> the connection to SQL Server database failed.
> Do I need to modify the ADO connection string properties, i.e.
> Provider and/or Dara Source?
> TIA,
> Jeffrey
>
|||Hi Mike,
I tried using your connection string, but still got an error message:
Error Type:
Microsoft VBScript compilation (0x800A0408)
Invalid character
/Bch12/ConnectSQL.asp, line 30
"User ID=sa;Initial Catalog=Movie;" & _
Any suggestions? Thanks.
Jeffrey
sql

Can not connect to SQL Server database with http://Localhost

I followed an example from the Chap 12 of "Beginning Active Server
Pages 3.0 (Wrox 1999)" to connect to my Access and SQL Server databases
with the following Coonection Strings.
objConn.Open "Provider=Microsoft.Jet.OLEDB.4.0;" & _
"Data Source=G:\databases\Movie2000.mdb;" & _
"Persist Security Info=False"
objConn.Open "Provider=SQLOLEDB" & _
"User ID=sa;Initial Catalog=Movie;" & _
"Data Source=G:\Program Files\Microsoft SQL
Server\MSSQL\Data\Movie2000.mdf"
I copied the Movie2000.mdb to my HD, G:\databases. It worked very well
with the http://Localhost, where my Connect.asp file is located. I can
open and display a Recordset object from the ASccess Movies table. But
the connection to SQL Server database failed.
Do I need to modify the ADO connection string properties, i.e.
Provider and/or Dara Source?
TIA,
JeffreyHi
With SQL Server, the client does not know where the DB is on disk, you just
refer to it by name.
objConn.Open "Provider=SQLOLEDB" & _
"User ID=sa;Initial Catalog=Movie;" & _
"Data Source=Movie2000"
This can be accessed after the database is restored or attached into SQL
Server.
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
<cjeffwang@.gmail.com> wrote in message
news:1118821257.151086.23940@.g43g2000cwa.googlegroups.com...
> I followed an example from the Chap 12 of "Beginning Active Server
> Pages 3.0 (Wrox 1999)" to connect to my Access and SQL Server databases
> with the following Coonection Strings.
> objConn.Open "Provider=Microsoft.Jet.OLEDB.4.0;" & _
> "Data Source=G:\databases\Movie2000.mdb;" & _
> "Persist Security Info=False"
> objConn.Open "Provider=SQLOLEDB" & _
> "User ID=sa;Initial Catalog=Movie;" & _
> "Data Source=G:\Program Files\Microsoft SQL
> Server\MSSQL\Data\Movie2000.mdf"
> I copied the Movie2000.mdb to my HD, G:\databases. It worked very well
> with the http://Localhost, where my Connect.asp file is located. I can
> open and display a Recordset object from the ASccess Movies table. But
> the connection to SQL Server database failed.
> Do I need to modify the ADO connection string properties, i.e.
> Provider and/or Dara Source?
> TIA,
> Jeffrey
>|||Hi Mike,
I tried using your connection string, but still got an error message:
Error Type:
Microsoft VBScript compilation (0x800A0408)
Invalid character
/Bch12/ConnectSQL.asp, line 30
"User ID=sa;Initial Catalog=Movie;" & _
Any suggestions? Thanks.
Jeffrey

can not browse to http://localhost/reports

This is the error I get:

Object not found!

The requested URL was not found on this server. If you entered the URL manually please check your spelling and try again.

If you think this is a server error, please contact the webmaster.

Error 404

localhost
Thursday, February 15, 2007 12:50:47
Apache/2.0.54 (NETWARE) mod_jk/1.2.14

Are you trying to access Report Manager from your own machine? If so, do you have Reporting Services installed on your machine? Did you install Reporting Services with an instance name?

Try this: http://<ServerName>/Reports

Where <ServerName> is the name of the server with Reporting Services installed.

Hope this helps.

Jarret

|||

Hi,
I now use the ip address instead of the localhost.
The problem is that when I get to the Report Services Home, I do not see any links to the report that I had created.
Not sure where the report is now?
But in development, I deploy the project to http://localhost/ReportServer and still do not see the report in the home site.

Thanks

|||

Connect to your instance of sqlserver that houses the RS database, then query to find out what's all there:

select * from ReportServer.dbo.Catalog

can not access reports

This was working before but all of a sudden when I try to access reports server
http://myserver/reports/
I get the following error:
Access to the path "C:\Program Files\Microsoft SQL Server\MSSQL\Reporting
Services\ReportManager\global.asax" is denied.
Please help..Looks like permissions or users have changed. The Web service user needs
access to this file. Make sure the Web service identity user has
permissions to that file.
| Thread-Topic: can not access reports
| thread-index: AcXEcWiSSksr+4EXS/e+bsnVf1Lr4w==| X-WBNR-Posting-Host: 216.89.4.2
| From: "=?Utf-8?B?c3Fsc3Rlcg==?=" <nospam@.nospam.com>
| Subject: can not access reports
| Date: Wed, 28 Sep 2005 14:13:01 -0700
| Lines: 12
| Message-ID: <CED59F58-B2D0-4768-B03B-64B9590467A1@.microsoft.com>
| MIME-Version: 1.0
| Content-Type: text/plain;
| charset="Utf-8"
| Content-Transfer-Encoding: 7bit
| X-Newsreader: Microsoft CDO for Windows 2000
| Content-Class: urn:content-classes:message
| Importance: normal
| Priority: normal
| X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
| Newsgroups: microsoft.public.sqlserver.reportingsvcs
| NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.2.250
| Path: TK2MSFTNGXA01.phx.gbl!TK2MSFTNGXA03.phx.gbl
| Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.sqlserver.reportingsvcs:53316
| X-Tomcat-NG: microsoft.public.sqlserver.reportingsvcs
|
| This was working before but all of a sudden when I try to access reports
server
|
| http://myserver/reports/
|
| I get the following error:
|
| Access to the path "C:\Program Files\Microsoft SQL Server\MSSQL\Reporting
| Services\ReportManager\global.asax" is denied.
|
| Please help..
|
|
|

Can I use KB 303459 to increase FT performance in 2005 and 2008?

I notice that KB 303459 (http://support.microsoft.com/kb/303459/en-us)
increase the FT performance in SQL Server 2000 and previous versions. The
increase is accomplished only by a registry setting which is very easy to
achive. I am wondering if I can use this article in SQL Server 2005 or SQL
Server 2008 to improve the performance as well.
Many thanks!
Felix Jiang
No, consult this white paper for performance tweaks in SQL 2005!
http://www.microsoft.com/technet/prodtechnol/sql/bestpractice/ftslesld.mspx
http://www.zetainteractive.com - Shift Happens!
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Felix_Jiang" <FelixJiang@.discussions.microsoft.com> wrote in message
news:53C15A1D-1D9C-4DD8-94EC-F95C814D2F9D@.microsoft.com...
>I notice that KB 303459 (http://support.microsoft.com/kb/303459/en-us)
> increase the FT performance in SQL Server 2000 and previous versions. The
> increase is accomplished only by a registry setting which is very easy to
> achive. I am wondering if I can use this article in SQL Server 2005 or SQL
> Server 2008 to improve the performance as well.
> Many thanks!
> Felix Jiang

can I use * to specify 'Output Column' for OLD DB Source Editor?

I am working on a situation similar to 'Get all from Table A that isn't in Table B' http://www.sqlis.com/default.aspx?311

I noticed that if one column's name of source table changes,(say Year to Year2) I have to modify all 'data flow transformations' in the task.

I am new to SSIS.

thanks! -ZZ

ZZhang wrote:

I am working on a situation similar to 'Get all from Table A that isn't in Table B' http://www.sqlis.com/default.aspx?311

I noticed that if one column's name of source table changes,(say Year to Year2) I have to modify all 'data flow transformations' in the task.

I am new to SSIS.

thanks! -ZZ

You could use '*' if you wanted but this is about as bad as bad practice gets. Don't do it. If the name of a column changes then SSIS will break because it stored the metadata of the external data source. This is by design.

-Jamie

|||

Hi, Jamie,
Thanks so much for your quick response! I have two questions then.

1. How to use * ? I can not find it in the 'OLD DB Source Editor'.

2. Let me simplifing my case. I have a remote source table ( which has may columns, incluing 'ID' and 'Date'). The schema may change, but not 'ID' and 'Date' columns. The DTS job is to get all rows ( select * from myTable where [Date] = getdate() ), and output to a delimited flat file.

What is the best practice SSIS for this case?

Thanks again!

-ZZ

|||

Like I said. You can't do it. If the external metadata changes then your data-flow will error.

-Jamie

|||

thanks, Jamie!

Honestly, this surprised me, if it can not use *. I will choose NOT to use SSIS for my simple job, because it does not make sense to modify ( and test) SSIS package every time the schema changes. I hope there is a workaround to meet my job requirement in SSIS.

-ZZ

|||

What? Your problem is the fact that your schema is changing, not that SSIS can't handle it. Are you saying that its impossible to know what your schema will look like from one day to the next? I've never seen a company that would run its systems like that nor would i want to.

Sorry to sound rude but it just sounds crazy to me!

-Jamie

|||

Thanks Jamie for your time to answer my question!

I am new to SSIS, and have not used variable, expression, and sricpt much. I am open-mind, and believe there is a way (simple or difficult), to solve my issue. Maybe you are right, but here I am searching 'how-to' solution, like ( select * from MyTable). Should I use *? it is another question.

Thanks again!

-ZZhang

|||

Again,

Yes you can use "SELECT * FROM MyTable"|||

It seems that MS has solution for 'Dynamic Metadata', although SSIS pipeline requires static metadata.

"Advacned ETL: Embedding Integration Services" from PDC05 mentioned this issue. SMO is needed.

I am still searching for the samples.

-ZZhang

can I use * to specify 'Output Column' for OLD DB Source Editor?

I am working on a situation similar to 'Get all from Table A that isn't in Table B' http://www.sqlis.com/default.aspx?311

I noticed that if one column's name of source table changes,(say Year to Year2) I have to modify all 'data flow transformations' in the task.

I am new to SSIS.

thanks! -ZZ

ZZhang wrote:

I am working on a situation similar to 'Get all from Table A that isn't in Table B' http://www.sqlis.com/default.aspx?311

I noticed that if one column's name of source table changes,(say Year to Year2) I have to modify all 'data flow transformations' in the task.

I am new to SSIS.

thanks! -ZZ

You could use '*' if you wanted but this is about as bad as bad practice gets. Don't do it. If the name of a column changes then SSIS will break because it stored the metadata of the external data source. This is by design.

-Jamie

|||

Hi, Jamie,
Thanks so much for your quick response! I have two questions then.

1. How to use * ? I can not find it in the 'OLD DB Source Editor'.

2. Let me simplifing my case. I have a remote source table ( which has may columns, incluing 'ID' and 'Date'). The schema may change, but not 'ID' and 'Date' columns. The DTS job is to get all rows ( select * from myTable where [Date] = getdate() ), and output to a delimited flat file.

What is the best practice SSIS for this case?

Thanks again!

-ZZ

|||

Like I said. You can't do it. If the external metadata changes then your data-flow will error.

-Jamie

|||

thanks, Jamie!

Honestly, this surprised me, if it can not use *. I will choose NOT to use SSIS for my simple job, because it does not make sense to modify ( and test) SSIS package every time the schema changes. I hope there is a workaround to meet my job requirement in SSIS.

-ZZ

|||

What? Your problem is the fact that your schema is changing, not that SSIS can't handle it. Are you saying that its impossible to know what your schema will look like from one day to the next? I've never seen a company that would run its systems like that nor would i want to.

Sorry to sound rude but it just sounds crazy to me!

-Jamie

|||

Thanks Jamie for your time to answer my question!

I am new to SSIS, and have not used variable, expression, and sricpt much. I am open-mind, and believe there is a way (simple or difficult), to solve my issue. Maybe you are right, but here I am searching 'how-to' solution, like ( select * from MyTable). Should I use *? it is another question.

Thanks again!

-ZZhang

|||

Again,

Yes you can use "SELECT * FROM MyTable"|||

It seems that MS has solution for 'Dynamic Metadata', although SSIS pipeline requires static metadata.

"Advacned ETL: Embedding Integration Services" from PDC05 mentioned this issue. SMO is needed.

I am still searching for the samples.

-ZZhang

Can I still redistribute MSDE after SQL Express is out?

I wonder if I can still redistribute MSDE after SQL Express is released. I
read in this page http://lab.msdn.microsoft.com/express/faq/default.aspx that
SQL Server Express is the replacement of MSDE. So, I wonder if the
redistributable license for MSDE is still valid after SQL Server Express is
out..?
Thanks,
Don't see why not, as you can still distribute MSDE 1.0 apps even though
MSDE 2000 is its "replacement"...
http://www.aspfaq.com/
(Reverse address to reply.)
"Hani Atassi" <hani@.community.nospam> wrote in message
news:82682AA8-A5C9-405E-B809-A2A051A7485C@.microsoft.com...
> I wonder if I can still redistribute MSDE after SQL Express is released. I
> read in this page http://lab.msdn.microsoft.com/express/faq/default.aspx
that
> SQL Server Express is the replacement of MSDE. So, I wonder if the
> redistributable license for MSDE is still valid after SQL Server Express
is
> out..?
> Thanks,
>
|||yes
the support lifecycles of these things will overlap by at least 2 years,
according to the stated MS support lifecycle policy.
-D
"Aaron [SQL Server MVP]" <ten.xoc@.dnartreb.noraa> wrote in message
news:eefJw1dxEHA.1196@.TK2MSFTNGP15.phx.gbl...
> Don't see why not, as you can still distribute MSDE 1.0 apps even though
> MSDE 2000 is its "replacement"...
> --
> http://www.aspfaq.com/
> (Reverse address to reply.)
>
>
> "Hani Atassi" <hani@.community.nospam> wrote in message
> news:82682AA8-A5C9-405E-B809-A2A051A7485C@.microsoft.com...
> that
> is
>

Can I just make the necessary registry changes to turn on error reporting in SQL2000 SP3

http://support.microsoft.com/default...b;en-us;328446
The part that describes how to turn off Error Reporting for a default =
instance is unclear in this article. It looks to be missing stuff. So =
maybe all I have to do to enable Error Reporting, is to manually make =
the change in the registry. That way if I want to turn it off I just =
change 1 to 0 as is in the article. Is that OK will that be sufficient? =
Thanks.
--=20
George Hester
__________________________________
You are correct that the artilce is missing something. The proper method to
enable this is as follows:
To turn on error reporting by using SQL Server Enterprise
Manager or Analysis Manager, follow these steps:
1. Click to select the name of the server.
2. Right-click the server name, and then click Properties.
3. Click to select the Enable Error Reporting Feature check box.
It is always best to use the interface than to manually edit the registry.
Thanks for the catch. I am getting the article updated.
Rand
This posting is provided "as is" with no warranties and confers no rights.
|||Oh cool yeah I'd rather do it that way. Thanks.
--=20
George Hester
__________________________________
"Rand Boyd [MSFT]" <rboyd@.onlinemicrosoft.com> wrote in message =
news:#PLYRQnPEHA.1516@.cpmsftngxa10.phx.gbl...
> You are correct that the artilce is missing something. The proper =
method to=20
> enable this is as follows:
>=20
> To turn on error reporting by using SQL Server Enterprise
> Manager or Analysis Manager, follow these steps:
>=20
> 1. Click to select the name of the server.
> 2. Right-click the server name, and then click Properties.
> 3. Click to select the Enable Error Reporting Feature check box.
>=20
> It is always best to use the interface than to manually edit the =
registry.
>=20
> Thanks for the catch. I am getting the article updated.
>=20
> Rand
> This posting is provided "as is" with no warranties and confers no =
rights.
>

Can I just make the necessary registry changes to turn on error reporting in SQL2000 SP3

http://support.microsoft.com/default.aspx?scid=3Dkb;en-us;328446
The part that describes how to turn off Error Reporting for a default = instance is unclear in this article. It looks to be missing stuff. So = maybe all I have to do to enable Error Reporting, is to manually make = the change in the registry. That way if I want to turn it off I just = change 1 to 0 as is in the article. Is that OK will that be sufficient? = Thanks.
-- George Hester
__________________________________You are correct that the artilce is missing something. The proper method to
enable this is as follows:
To turn on error reporting by using SQL Server Enterprise
Manager or Analysis Manager, follow these steps:
1. Click to select the name of the server.
2. Right-click the server name, and then click Properties.
3. Click to select the Enable Error Reporting Feature check box.
It is always best to use the interface than to manually edit the registry.
Thanks for the catch. I am getting the article updated.
Rand
This posting is provided "as is" with no warranties and confers no rights.|||Oh cool yeah I'd rather do it that way. Thanks.
-- George Hester
__________________________________
"Rand Boyd [MSFT]" <rboyd@.onlinemicrosoft.com> wrote in message =news:#PLYRQnPEHA.1516@.cpmsftngxa10.phx.gbl...
> You are correct that the artilce is missing something. The proper =method to > enable this is as follows:
> > To turn on error reporting by using SQL Server Enterprise
> Manager or Analysis Manager, follow these steps:
> > 1. Click to select the name of the server.
> 2. Right-click the server name, and then click Properties.
> 3. Click to select the Enable Error Reporting Feature check box.
> > It is always best to use the interface than to manually edit the =registry.
> > Thanks for the catch. I am getting the article updated.
> > Rand
> This posting is provided "as is" with no warranties and confers no =rights.
>

Can I just make the necessary registry changes to turn on error reporting in SQL2000 S

http://support.microsoft.com/defaul...kb;en-us;328446
The part that describes how to turn off Error Reporting for a default =
instance is unclear in this article. It looks to be missing stuff. So =
maybe all I have to do to enable Error Reporting, is to manually make =
the change in the registry. That way if I want to turn it off I just =
change 1 to 0 as is in the article. Is that OK will that be sufficient? =
Thanks.
--=20
George Hester
__________________________________You are correct that the artilce is missing something. The proper method to
enable this is as follows:
To turn on error reporting by using SQL Server Enterprise
Manager or Analysis Manager, follow these steps:
1. Click to select the name of the server.
2. Right-click the server name, and then click Properties.
3. Click to select the Enable Error Reporting Feature check box.
It is always best to use the interface than to manually edit the registry.
Thanks for the catch. I am getting the article updated.
Rand
This posting is provided "as is" with no warranties and confers no rights.|||Oh cool yeah I'd rather do it that way. Thanks.
--=20
George Hester
__________________________________
"Rand Boyd [MSFT]" <rboyd@.onlinemicrosoft.com> wrote in message =
news:#PLYRQnPEHA.1516@.cpmsftngxa10.phx.gbl...
> You are correct that the artilce is missing something. The proper =
method to=20
> enable this is as follows:
>=20
> To turn on error reporting by using SQL Server Enterprise
> Manager or Analysis Manager, follow these steps:
>=20
> 1. Click to select the name of the server.
> 2. Right-click the server name, and then click Properties.
> 3. Click to select the Enable Error Reporting Feature check box.
>=20
> It is always best to use the interface than to manually edit the =
registry.
>=20
> Thanks for the catch. I am getting the article updated.
>=20
> Rand
> This posting is provided "as is" with no warranties and confers no =
rights.
>