Migrating from ASP

I have a bunch of contracts built in asp and I need them to be

published on report server. Is there any easier way than rebuilding

them in report designer?

There is not migration path from ASP to Reporting Services reports. You can store the asp contracts in reporting services as resources, but they will not be executed as reports.

migrating access to SQL

i am doing ASP small project using ACCESS database
i want to migrate access to SQL what i need to do?
it is very diificult. i studied sql very well.but i don't know what s/w i need to download how to make connection????

Quote:

Originally Posted by subashini Thiyagarajan

i am doing ASP small project using ACCESS database
i want to migrate access to SQL what i need to do?
it is very diificult. i studied sql very well.but i don't know what s/w i need to download how to make connection????

Hi there,

Make use of the Import and Export wizard, hope it helps. Good luck & Take care.|||How can i do that?

what changes i should make in my asp codings?

in order to export to SQL what s/w i need to download?

pls reply|||

Quote:

Originally Posted by subashini Thiyagarajan

How can i do that?

what changes i should make in my asp codings?

in order to export to SQL what s/w i need to download?

pls reply

Hi there,

Not much changes are required as long as you provide the source & destination database name correctly, that's more then enough i guess. Good luck & Take care.|||Here is a MS article about doing this although not sure what version of SQL Server you are using.

HTH,
Aric|||thanks for your reply.
can i get SQL server free download from Net.Not a trial version.|||

Quote:

Originally Posted by subashini Thiyagarajan

thanks for your reply.
can i get SQL server free download from Net.Not a trial version.

Hi there,

The answer will be NO & NOTHING BUT NO! Good luck & Take care|||It is confirmed "NO"

what did u mean that source and desrtination path should be correct.

using which source i should concentrate about the path.
i downloaded the express edition what i need to do in order to import my access file? pls give a clear viewsql

Migrate DB from MSDE to Sql Server 2005 Express

Hi - is it possible to migrate to SQL Server 2005 Express from MSDE - and still use ASP.Net 1.1? Or will Express only work with ASP.Net 2.0?
My MSDE database has simple SPs (no functions), and straight forward tables - can I just use DTS from Enterprise Manager to transfer this from MSDE to SQL Express, or create a backup, and import that into SQL Express 2005?
Also, there was a sort of Enterprise Manager available for SQL Server 2005 Express at one point - does anyone know where to find that?
Thanks for any pointers/help.
MarkSQL Server Express comes with Express manager a separate install but I don't think the new DTS Integration Services is part of it but the product is still in beta so download the developer edition and use the integration services to do the migration. The management studio the replacement of Enterprise manager is a separate install under management tools. Try the thread below to download the developer edition. Hope this helps.
http://forums.asp.net/1069636/ShowPost.aspx|||

Hi - thank you Caddre.

Can I still use the old ASP.Net 1.1 framwework with the SQL Server 2005 Express though? Or will it only work with .Net2?

Thanks, Mark

|||SQL Server 2005 Express was released July 29, 2004 with Asp.net 2.0 for public beta 1 so I am sure you can use it with Asp.net 1.1. All you need is permissions and connection string, try the link below for Microsoft provided tutorial. Hope this helps.
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnpag2/html/paght000010.asp|||Hi.
When I tried the SQL Express beta earlier this year, I had some troubleconnecting to the database from a ASP.NET 1.1 application.
I found out that (at least in my environment) I had to connect to thedatabase using tcp/ip. In may case (the database was on the samemachine as the ASP.NET application) I used Server=127.0.0.1,1433instead of Server=(local) in the connection string.
It should also be possible to use Server=servername,portnumber instead of hard coding theip number.

Migrate database from MS Access to SQL Server 2000

Hi All,
I had installed Internet Information Sevices (IIS) on
Windows 2000 to simulate a web server. The ASP code to
open the Access database is:
Set db = Server.CreateObject("ADODB.Connection")
db.open "Driver={Microsoft Access Driver (*.mdb)}; DBQ="
&server.MapPath("../data/test.mdb")&";"
The code works fine on IIS and Access database. Then I
installed the SQL Server 2000 and changed the ASP code to:
Set db = Server.CreateObject("ADODB.Connection")
db.open "DRIVER={SQL
Server};SERVER=myPC;UID=sa;PWD=myPasswd;DATABASE=test"
dbsql="Y"
Where "myPC" is the computer name, "myPasswd" is the
password for user "sa". But the ASP code did not work.
Anything wrong?
Thanks in advance.> But the ASP code did not work.
You're going to have to be more specific.|||what error do u get'
--
Shaju Thomas
"Nancy" <nlan2000@.hotmail.com> wrote in message
news:063401c39b88$7ea843c0$a301280a@.phx.gbl...
> Hi All,
> I had installed Internet Information Sevices (IIS) on
> Windows 2000 to simulate a web server. The ASP code to
> open the Access database is:
> Set db = Server.CreateObject("ADODB.Connection")
> db.open "Driver={Microsoft Access Driver (*.mdb)}; DBQ="
> &server.MapPath("../data/test.mdb")&";"
> The code works fine on IIS and Access database. Then I
> installed the SQL Server 2000 and changed the ASP code to:
> Set db = Server.CreateObject("ADODB.Connection")
> db.open "DRIVER={SQL
> Server};SERVER=myPC;UID=sa;PWD=myPasswd;DATABASE=test"
> dbsql="Y"
> Where "myPC" is the computer name, "myPasswd" is the
> password for user "sa". But the ASP code did not work.
> Anything wrong?
> Thanks in advance.
>|||Hi all,
Thanks for your kindness help.
The error message says:
HTTP 500.100 - Internal Server Error - ASP error
Internet Information Services
Error Type:
ADODB.Recordset (0x800A0E7D)
The connection cannot be used to perform this operation.
It is either closed or invalid in this context.
Which referred to the following code:
set rs=Server.CreateObject("ADODB.Recordset")
The reason is the database connection was not set up
successfully, where the cause was actually a typo in the
server name. It works now after I corrected it.
But thanks anyway!
Nancy
>--Original Message--
>Hi All,
>I had installed Internet Information Sevices (IIS) on
>Windows 2000 to simulate a web server. The ASP code to
>open the Access database is:
>Set db = Server.CreateObject("ADODB.Connection")
>db.open "Driver={Microsoft Access Driver (*.mdb)}; DBQ="
>&server.MapPath("../data/test.mdb")&";"
>The code works fine on IIS and Access database. Then I
>installed the SQL Server 2000 and changed the ASP code to:
>Set db = Server.CreateObject("ADODB.Connection")
>db.open "DRIVER={SQL
>Server};SERVER=myPC;UID=sa;PWD=myPasswd;DATABASE=test"
>dbsql="Y"
>Where "myPC" is the computer name, "myPasswd" is the
>password for user "sa". But the ASP code did not work.
>Anything wrong?
>Thanks in advance.
>.
>|||did u open the connection
--
Shaju Thomas
"Nancy" <nlan2000@.hotmail.com> wrote in message
news:055a01c39d0b$9fc67390$a601280a@.phx.gbl...
> Hi all,
> Thanks for your kindness help.
> The error message says:
> HTTP 500.100 - Internal Server Error - ASP error
> Internet Information Services
> Error Type:
> ADODB.Recordset (0x800A0E7D)
> The connection cannot be used to perform this operation.
> It is either closed or invalid in this context.
> Which referred to the following code:
> set rs=Server.CreateObject("ADODB.Recordset")
> The reason is the database connection was not set up
> successfully, where the cause was actually a typo in the
> server name. It works now after I corrected it.
> But thanks anyway!
> Nancy
>
> >--Original Message--
> >Hi All,
> >
> >I had installed Internet Information Sevices (IIS) on
> >Windows 2000 to simulate a web server. The ASP code to
> >open the Access database is:
> >
> >Set db = Server.CreateObject("ADODB.Connection")
> >db.open "Driver={Microsoft Access Driver (*.mdb)}; DBQ="
> >&server.MapPath("../data/test.mdb")&";"
> >
> >The code works fine on IIS and Access database. Then I
> >installed the SQL Server 2000 and changed the ASP code to:
> >
> >Set db = Server.CreateObject("ADODB.Connection")
> >db.open "DRIVER={SQL
> >Server};SERVER=myPC;UID=sa;PWD=myPasswd;DATABASE=test"
> >dbsql="Y"
> >
> >Where "myPC" is the computer name, "myPasswd" is the
> >password for user "sa". But the ASP code did not work.
> >
> >Anything wrong?
> >
> >Thanks in advance.
> >
> >.
> >

Migrate ASP .net web site from sql 2005 express to sql 2005 standard edition

Dear all,

I've been using ASP.NET with SQL 2005 express for several months and everything has been fine. Now a customer asks me to install my application on an already existant instance of SQL Server standard edition.

I was not able to use nor my application, neither a HelloWorld example.

I created a simple Default.aspx that uses a simple database with a single table "Person" via a standard gridview. When I try to open the page I receive an error wich informs me that NT Network service is not able to access database.

I've been searching on google for hours and I've tryed unsuccessfully several different way.

Can anyone suggest me a scientific procedure to migrate an ASP .net web site from sql 2005 express to sql 2005 standard ?

Thank you very Much

Fabrizio

As I know the only think you have to change is a connection string because SQL express uses different syntax for it. You can move your database to SQL server standard just by connecting it to server, you have to create your users and give them correct rights, you also have to create ASP DB if you would like to use ASP authentication finally modify your connections stirings to point to SQL server not to local SQL server express file.

There are a lot of post about this on this ASP forum.

Good luck

Migrate Access2000 to SQL2000 database

I am working on new project that migration Access database and its ASP.NET
application to SQL2000 database. Please give me the guide and strategy how to
do it from beginning to the end.
Thank you very much and Happy New Year.
Kevin,
Microsoft suggests that you use the Upsizing wizard in Access 2k to
accomplish this. I have posted a url for you below that has a link to a very
detailed white paper that explains how to use this wizard.
I hope this helps.
http://support.microsoft.com/default...roduct=acc2000
|||That request is beyond the scope of a simple newsgroup question.
Migrating the data shouldn't be too difficult -- for best results,
create the schema and database objects in SQLS and migrate the data
using DTS or the Access upsizing wizard. As far as ASP.NET goes, take
a look at the ASP.NET security best-practices whitepaper,
http://www.microsoft.com/downloads/r...leaseID=44047. That
will get you started about thinking of your overall application and
security architecture. Also visit the ASP.NETand SQLS developer
centers at http://msdn.microsoft.com/asp.net/ and
http://msdn.microsoft.com/sql/, respectively.
--Mary
On Wed, 29 Dec 2004 07:50:25 -0800, "Kevin"
<Kevin@.discussions.microsoft.com> wrote:

>I am working on new project that migration Access database and its ASP.NET
>application to SQL2000 database. Please give me the guide and strategy how to
> do it from beginning to the end.
>Thank you very much and Happy New Year.
|||Thanks Brian.
Do you know which one is better between Upsizing or DTS approach?
"Brian Brown" wrote:

> Kevin,
> Microsoft suggests that you use the Upsizing wizard in Access 2k to
> accomplish this. I have posted a url for you below that has a link to a very
> detailed white paper that explains how to use this wizard.
> I hope this helps.
> --
> http://support.microsoft.com/default...roduct=acc2000
|||Thanks Mary.
"Mary Chipman" wrote:

> That request is beyond the scope of a simple newsgroup question.
> Migrating the data shouldn't be too difficult -- for best results,
> create the schema and database objects in SQLS and migrate the data
> using DTS or the Access upsizing wizard. As far as ASP.NET goes, take
> a look at the ASP.NET security best-practices whitepaper,
> http://www.microsoft.com/downloads/r...leaseID=44047. That
> will get you started about thinking of your overall application and
> security architecture. Also visit the ASP.NETand SQLS developer
> centers at http://msdn.microsoft.com/asp.net/ and
> http://msdn.microsoft.com/sql/, respectively.
> --Mary
> On Wed, 29 Dec 2004 07:50:25 -0800, "Kevin"
> <Kevin@.discussions.microsoft.com> wrote:
>
>

Migrate Access2000 to SQL2000 database

I am working on new project that migration Access database and its ASP.NET
application to SQL2000 database. Please give me the guide and strategy how to
do it from beginning to the end.
Thank you very much and Happy New Year.Kevin,
Microsoft suggests that you use the Upsizing wizard in Access 2k to
accomplish this. I have posted a url for you below that has a link to a very
detailed white paper that explains how to use this wizard.
I hope this helps.
--
http://support.microsoft.com/default.aspx?kbid=241743&product=acc2000|||That request is beyond the scope of a simple newsgroup question.
Migrating the data shouldn't be too difficult -- for best results,
create the schema and database objects in SQLS and migrate the data
using DTS or the Access upsizing wizard. As far as ASP.NET goes, take
a look at the ASP.NET security best-practices whitepaper,
http://www.microsoft.com/downloads/release.asp?ReleaseID=44047. That
will get you started about thinking of your overall application and
security architecture. Also visit the ASP.NETand SQLS developer
centers at http://msdn.microsoft.com/asp.net/ and
http://msdn.microsoft.com/sql/, respectively.
--Mary
On Wed, 29 Dec 2004 07:50:25 -0800, "Kevin"
<Kevin@.discussions.microsoft.com> wrote:
>I am working on new project that migration Access database and its ASP.NET
>application to SQL2000 database. Please give me the guide and strategy how to
> do it from beginning to the end.
>Thank you very much and Happy New Year.|||Thanks Brian.
Do you know which one is better between Upsizing or DTS approach?
"Brian Brown" wrote:
> Kevin,
> Microsoft suggests that you use the Upsizing wizard in Access 2k to
> accomplish this. I have posted a url for you below that has a link to a very
> detailed white paper that explains how to use this wizard.
> I hope this helps.
> --
> http://support.microsoft.com/default.aspx?kbid=241743&product=acc2000|||Thanks Mary.
"Mary Chipman" wrote:
> That request is beyond the scope of a simple newsgroup question.
> Migrating the data shouldn't be too difficult -- for best results,
> create the schema and database objects in SQLS and migrate the data
> using DTS or the Access upsizing wizard. As far as ASP.NET goes, take
> a look at the ASP.NET security best-practices whitepaper,
> http://www.microsoft.com/downloads/release.asp?ReleaseID=44047. That
> will get you started about thinking of your overall application and
> security architecture. Also visit the ASP.NETand SQLS developer
> centers at http://msdn.microsoft.com/asp.net/ and
> http://msdn.microsoft.com/sql/, respectively.
> --Mary
> On Wed, 29 Dec 2004 07:50:25 -0800, "Kevin"
> <Kevin@.discussions.microsoft.com> wrote:
> >I am working on new project that migration Access database and its ASP.NET
> >application to SQL2000 database. Please give me the guide and strategy how to
> > do it from beginning to the end.
> >Thank you very much and Happy New Year.
>

Migrate Access2000 to SQL2000 database

I am working on new project that migration Access database and its ASP.NET
application to SQL2000 database. Please give me the guide and strategy how t
o
do it from beginning to the end.
Thank you very much and Happy New Year.Kevin,
Microsoft suggests that you use the Upsizing wizard in Access 2k to
accomplish this. I have posted a url for you below that has a link to a ver
y
detailed white paper that explains how to use this wizard.
I hope this helps.
http://support.microsoft.com/defaul...product=acc2000|||That request is beyond the scope of a simple newsgroup question.
Migrating the data shouldn't be too difficult -- for best results,
create the schema and database objects in SQLS and migrate the data
using DTS or the Access upsizing wizard. As far as ASP.NET goes, take
a look at the ASP.NET security best-practices whitepaper,
http://www.microsoft.com/downloads/...eleaseID=44047. That
will get you started about thinking of your overall application and
security architecture. Also visit the ASP.NETand SQLS developer
centers at http://msdn.microsoft.com/asp.net/ and
http://msdn.microsoft.com/sql/, respectively.
--Mary
On Wed, 29 Dec 2004 07:50:25 -0800, "Kevin"
<Kevin@.discussions.microsoft.com> wrote:

>I am working on new project that migration Access database and its ASP.NET
>application to SQL2000 database. Please give me the guide and strategy how
to
> do it from beginning to the end.
>Thank you very much and Happy New Year.|||Thanks Brian.
Do you know which one is better between Upsizing or DTS approach?
"Brian Brown" wrote:

> Kevin,
> Microsoft suggests that you use the Upsizing wizard in Access 2k to
> accomplish this. I have posted a url for you below that has a link to a v
ery
> detailed white paper that explains how to use this wizard.
> I hope this helps.
> --
> http://support.microsoft.com/defaul...product=acc2000|||Thanks Mary.
"Mary Chipman" wrote:

> That request is beyond the scope of a simple newsgroup question.
> Migrating the data shouldn't be too difficult -- for best results,
> create the schema and database objects in SQLS and migrate the data
> using DTS or the Access upsizing wizard. As far as ASP.NET goes, take
> a look at the ASP.NET security best-practices whitepaper,
> http://www.microsoft.com/downloads/...eleaseID=44047. That
> will get you started about thinking of your overall application and
> security architecture. Also visit the ASP.NETand SQLS developer
> centers at http://msdn.microsoft.com/asp.net/ and
> http://msdn.microsoft.com/sql/, respectively.
> --Mary
> On Wed, 29 Dec 2004 07:50:25 -0800, "Kevin"
> <Kevin@.discussions.microsoft.com> wrote:
>
>

Migrate

I have developed a web application using MSDE. I do not have sql 2000. I now have to transfer this database to an asp host.
Is there a DTS package or osql commands that I can export the entire database sp and all to a sql script file.

Regards
S(:You can create scripts for all of the database objects (tables, view, sprocs, etc.) but I don't believe you can create scripts for the data too. You can use DTS to copy the data, however, after you create the objects.

I haven't tried this with MSDE but with Sql Server databases you can detach them from your local database and physically copy the database files to the remote destination and then re-attach them there. The database has to be compatible with where you are attaching it and whether it considers MSDE files compatible is the question.

Microsoft.Data.Odbc on 64-Bit Server

Hi!

Today we installed our ASP.NET Application on a 64-bit server for the first time. We got the error'Unable to find entry point named 'InterlockedIncrement' in DLL 'kernel32.dll''.

This error comes when we make a database query using Microsoft.Data.Odbc. I think it does not run on 64-bit machines.

Does anybody know something about this?

KaaN

I don't know why you need it with ODBC datasource but the link below Microsoft explains the reason for you error. Hope this helps.

(The variable pointed to by the Addend parameter must be aligned on a 32-bit boundary; otherwise, this function will behave unpredictably on multiprocessor x86 systems and any non-x86 systems.)

http://msdn2.microsoft.com/en-us/library/ms683614.aspx

|||

Thanks for your answer.

Actually I don't need this xxIncrement method, I only need the .Net Odbc Provider and probably this provider is using this function. Now I have to refactor my code to native providers or find another .Net ODBC Provider.

Microsoft.AnalysisServices.AdomdClient.AdomdCacheExpiredException

Hello,

I have a asp.net application that connects to a cube in Analysis Service 2005 to do graphs. It's possible that other user might be using the same cube at the same time and make changes to the cube. If I use the graphing tol right after the cube is updated, I sometimes get an error message : "Microsoft.AnalysisServices.AdomdClient.AdomdCacheExpiredException : The Cubes collection has been updated on the server".

Is there a way to refresh the cache or refresh the cube collection? Any suggestion on how to handle this exception is appreciated.

Thank you,

Sincerely,

Annie

I beleive the better solution for the user in this case is to prompt your user to re-connect.

User session on the server has been disvalidated as a result of the some else's activity. To see consistent picture prompt your user to reconnect and refresh all the stuctures.
BTW this is behavior you would see in SQL Management Studio's Cube browser. The minute cube becomes invalid cube browser will asks you to re-connect.

Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights.