Showing posts with label working. Show all posts
Showing posts with label working. Show all posts

Monday, March 26, 2012

Help with SOAP Lite client error problems - CGI code

Hi,

I have been working on a soap client project for over a week now and can not figure out what I am doing wrong. I am not an expert using Perl or SOAP so any help would be "greatly" appreciated.

I get basic errors throughout, starting with:
Error - SOAP::Transport::HTTP::Client::send_receive: POST
It seems as if the user access information is not carried through as it should, but I truly have no idea what the problem is.

Here is what I have put together so far.

Thanks,
Mark

sub procgetmemberinfo {

my $pin = "$form{'lPin'}";
my $password = "$form{'sPassword'}";

my $soap = SOAP::Lite
-> uri('https://xmlsql.XXXXX.xxx:441')
-> on_action( sub { join '/', 'https://xmlsql.XXXXX.xxx:441', $_[1] } )
-> proxy('https://xmlsql.XXXXX.xxx:441/service.asmx?WSDL');

my @.params = (
SOAP::Data->name(lPin => $pin),
SOAP::Data->name(sPassword => $password)
);

my $method = SOAP::Data->name('GetMemberInfo')->attr({xmlns => 'https://xmlsql.XXXXX.xxx:441/'});

my $result = $soap->call($method => @.params);
unless ($result->fault) {

my $title = $result->valueof('//GetMemberInfoResult/diffgram/NewDataSet/MEMBERS/TITLE');
my $firstname = $result->valueof('//GetMemberInfoResult/diffgram/NewDataSet/MEMBERS/FIRST');
my $middlename = $result->valueof('//GetMemberInfoResult/diffgram/NewDataSet/MEMBERS/MIDDLE');
my $lastname = $result->valueof('//GetMemberInfoResult/diffgram/NewDataSet/MEMBERS/LAST');
my $suffix = $result->valueof('//GetMemberInfoResult/diffgram/NewDataSet/MEMBERS/SUFFIX');
my $address1 = $result->valueof('//GetMemberInfoResult/diffgram/NewDataSet/MEMBERS/STREET_ADDRESS');
my $address2 = $result->valueof('//GetMemberInfoResult/diffgram/NewDataSet/MEMBERS/ADDRESS2');
my $city = $result->valueof('//GetMemberInfoResult/diffgram/NewDataSet/MEMBERS/CITY');
my $stateprovince = $result->valueof('//GetMemberInfoResult/diffgram/NewDataSet/MEMBERS/STATE_PROV');
my $postalcode = $result->valueof('//GetMemberInfoResult/diffgram/NewDataSet/MEMBERS/ZIP');
my $country = $result->valueof('//GetMemberInfoResult/diffgram/NewDataSet/MEMBERS/COUNTRY');
my $homephone = $result->valueof('//GetMemberInfoResult/diffgram/NewDataSet/MEMBERS/HOME_PHONE');
my $workphone = $result->valueof('//GetMemberInfoResult/diffgram/NewDataSet/MEMBERS/WORK_PHONE');
my $emailaddress = $result->valueof('//GetMemberInfoResult/diffgram/NewDataSet/MEMBERS/EMAIL');

print "<font face=arial size=2><b>PIN Number:</b> $pin</font><br>";
print "<font face=arial size=2><b>Password:</b> $password</font><br>";
print "<font face=arial size=2><b>Title:</b> $title</font><br>";
print "<font face=arial size=2><b>First Name:</b> $firstname</font><br>";
print "<font face=arial size=2><b>Middle Name:</b> $middlename</font><br>";
print "<font face=arial size=2><b>Last Name:</b> $lastname</font><br>";
print "<font face=arial size=2><b>Suffix:</b> $suffix</font><br>";
print "<font face=arial size=2><b>Address1:</b> $address1</font><br>";
print "<font face=arial size=2><b>Address2:</b> $address2</font><br>";
print "<font face=arial size=2><b>City:</b> $city</font><br>";
print "<font face=arial size=2><b>State:</b> $stateprovince</font><br>";
print "<font face=arial size=2><b>ZIP/Postal Code:</b> $postalcode</font><br>";
print "<font face=arial size=2><b>Country:</b> $country</font><br>";
print "<font face=arial size=2><b>Home Phone:</b> $homephone</font><br>";
print "<font face=arial size=2><b>Work Phone:</b> $workphone</font><br>";
print "<font face=arial size=2><b>Email Address:</b> $emailaddress</font>";

}

else {
print join ', ',
$result->faultcode,
$result->faultstring,
$result->faultdetail;
}


}

Here is a nice easy way to debug SSL issue with Windows 2003 that I discovered while working on SOAP projects.

1. Create batch file c:\ssltrace.cmd with following contents:

logman start http_ssl_trace -pf c:\guids.txt -o out.etl -ets
pause
logman stop http_ssl_trace -ets
tracerpt /y out.etl
notepad dumpfile.csv

2. Create file c:\guids.txt with following contents:

{1fbecc45-c060-4e7c-8a0e-0dbd6116181b} 0x000000FF 5 IIS: SSL Filter
{dd5ef90a-6398-47a4-ad34-4dcecdef795f} 0x000000FF 5 HTTP Service Trace

3. On the web service machine run c:\ssltrace.cmd to start tracing, then hit your web service with your POST. Once you are finished testing press the spacebar to in the ssltrace.cmd command window to stop tracing and display the trace file. You should see everything coming in and going out along with error codes, etc...

|||

Hello Matt,

your Message was helpfull to solve a problem with tracing.

Could you please tell me where you get the information

{1fbecc45-c060-4e7c-8a0e-0dbd6116181b} 0x000000FF 5 IIS: SSL Filter
{dd5ef90a-6398-47a4-ad34-4dcecdef795f} 0x000000FF 5 HTTP Service Trace

from?

Thanks

str01014

|||

Actually I updated my batch file to inline everything (i've included it below).

To get a list of trace providers, run this ->

C:\>logman query providers

Provider GUID
-
...

IIS: SSL Filter {1fbecc45-c060-4e7c-8a0e-0dbd6116181b}
...
HTTP Service Trace {dd5ef90a-6398-47a4-ad34-4dcecdef795f}.
...

This will list each trace provider and it's GUID. The 2nd and 3rd values are flags passed to the trace provider to turn on and off various traces. How these values are used are provider specific. However if you just want to turn on all the flags pass in 0xFFFFFFFF and 255 like in my example below. Search MSDN for HTTP Service Trace and SSL Filter for information on what these flags do.

Here is my updated batch file (note it requires logparser tool which is downloadable from Microsoft) ->

rem START SSL TRACE DEMO
if exist ssltrace.guids del ssltrace.guids
echo {1fbecc45-c060-4e7c-8a0e-0dbd6116181b} 0xFFFFFFFF 255 IIS: SSL Filter >> ssltrace.guids
echo {dd5ef90a-6398-47a4-ad34-4dcecdef795f} 0xFFFFFFFF 255 HTTP Service Trace >> ssltrace.guids
logman start ssltrace -pf ssltrace.guids -o out.etl -ets
rem PRESS <SPACEBAR> TO STOP SSL+HTTP TRACING AND VIEW RESULTS
pause
logman stop ssltrace -ets
if exist ssltrace.guids del ssltrace.guids
if exist ssltrace.log del ssltrace.log
logparser -i:ETW "select * from out.etl" -e:ON >> ssltrace.log
start notepad ssltrace.log
rem END SSL TRACE DEMO

Help with SOAP Lite client error problems - CGI code

Hi,

I have been working on a soap client project for over a week now and can not figure out what I am doing wrong. I am not an expert using Perl or SOAP so any help would be "greatly" appreciated.

I get basic errors throughout, starting with:
Error - SOAP::Transport::HTTP::Client::send_receive: POST
It seems as if the user access information is not carried through as it should, but I truly have no idea what the problem is.

Here is what I have put together so far.

Thanks,
Mark

sub procgetmemberinfo {

my $pin = "$form{'lPin'}";
my $password = "$form{'sPassword'}";

my $soap = SOAP::Lite
-> uri('https://xmlsql.XXXXX.xxx:441')
-> on_action( sub { join '/', 'https://xmlsql.XXXXX.xxx:441', $_[1] } )
-> proxy('https://xmlsql.XXXXX.xxx:441/service.asmx?WSDL');

my @.params = (
SOAP::Data->name(lPin => $pin),
SOAP::Data->name(sPassword => $password)
);

my $method = SOAP::Data->name('GetMemberInfo')->attr({xmlns => 'https://xmlsql.XXXXX.xxx:441/'});

my $result = $soap->call($method => @.params);
unless ($result->fault) {

my $title = $result->valueof('//GetMemberInfoResult/diffgram/NewDataSet/MEMBERS/TITLE');
my $firstname = $result->valueof('//GetMemberInfoResult/diffgram/NewDataSet/MEMBERS/FIRST');
my $middlename = $result->valueof('//GetMemberInfoResult/diffgram/NewDataSet/MEMBERS/MIDDLE');
my $lastname = $result->valueof('//GetMemberInfoResult/diffgram/NewDataSet/MEMBERS/LAST');
my $suffix = $result->valueof('//GetMemberInfoResult/diffgram/NewDataSet/MEMBERS/SUFFIX');
my $address1 = $result->valueof('//GetMemberInfoResult/diffgram/NewDataSet/MEMBERS/STREET_ADDRESS');
my $address2 = $result->valueof('//GetMemberInfoResult/diffgram/NewDataSet/MEMBERS/ADDRESS2');
my $city = $result->valueof('//GetMemberInfoResult/diffgram/NewDataSet/MEMBERS/CITY');
my $stateprovince = $result->valueof('//GetMemberInfoResult/diffgram/NewDataSet/MEMBERS/STATE_PROV');
my $postalcode = $result->valueof('//GetMemberInfoResult/diffgram/NewDataSet/MEMBERS/ZIP');
my $country = $result->valueof('//GetMemberInfoResult/diffgram/NewDataSet/MEMBERS/COUNTRY');
my $homephone = $result->valueof('//GetMemberInfoResult/diffgram/NewDataSet/MEMBERS/HOME_PHONE');
my $workphone = $result->valueof('//GetMemberInfoResult/diffgram/NewDataSet/MEMBERS/WORK_PHONE');
my $emailaddress = $result->valueof('//GetMemberInfoResult/diffgram/NewDataSet/MEMBERS/EMAIL');

print "<font face=arial size=2><b>PIN Number:</b> $pin</font><br>";
print "<font face=arial size=2><b>Password:</b> $password</font><br>";
print "<font face=arial size=2><b>Title:</b> $title</font><br>";
print "<font face=arial size=2><b>First Name:</b> $firstname</font><br>";
print "<font face=arial size=2><b>Middle Name:</b> $middlename</font><br>";
print "<font face=arial size=2><b>Last Name:</b> $lastname</font><br>";
print "<font face=arial size=2><b>Suffix:</b> $suffix</font><br>";
print "<font face=arial size=2><b>Address1:</b> $address1</font><br>";
print "<font face=arial size=2><b>Address2:</b> $address2</font><br>";
print "<font face=arial size=2><b>City:</b> $city</font><br>";
print "<font face=arial size=2><b>State:</b> $stateprovince</font><br>";
print "<font face=arial size=2><b>ZIP/Postal Code:</b> $postalcode</font><br>";
print "<font face=arial size=2><b>Country:</b> $country</font><br>";
print "<font face=arial size=2><b>Home Phone:</b> $homephone</font><br>";
print "<font face=arial size=2><b>Work Phone:</b> $workphone</font><br>";
print "<font face=arial size=2><b>Email Address:</b> $emailaddress</font>";

}

else {
print join ', ',
$result->faultcode,
$result->faultstring,
$result->faultdetail;
}


}

Here is a nice easy way to debug SSL issue with Windows 2003 that I discovered while working on SOAP projects.

1. Create batch file c:\ssltrace.cmd with following contents:

logman start http_ssl_trace -pf c:\guids.txt -o out.etl -ets
pause
logman stop http_ssl_trace -ets
tracerpt /y out.etl
notepad dumpfile.csv

2. Create file c:\guids.txt with following contents:

{1fbecc45-c060-4e7c-8a0e-0dbd6116181b} 0x000000FF 5 IIS: SSL Filter
{dd5ef90a-6398-47a4-ad34-4dcecdef795f} 0x000000FF 5 HTTP Service Trace

3. On the web service machine run c:\ssltrace.cmd to start tracing, then hit your web service with your POST. Once you are finished testing press the spacebar to in the ssltrace.cmd command window to stop tracing and display the trace file. You should see everything coming in and going out along with error codes, etc...

|||

Hello Matt,

your Message was helpfull to solve a problem with tracing.

Could you please tell me where you get the information

{1fbecc45-c060-4e7c-8a0e-0dbd6116181b} 0x000000FF 5 IIS: SSL Filter
{dd5ef90a-6398-47a4-ad34-4dcecdef795f} 0x000000FF 5 HTTP Service Trace

from?

Thanks

str01014

|||

Actually I updated my batch file to inline everything (i've included it below).

To get a list of trace providers, run this ->

C:\>logman query providers

Provider GUID
-
...

IIS: SSL Filter {1fbecc45-c060-4e7c-8a0e-0dbd6116181b}
...
HTTP Service Trace {dd5ef90a-6398-47a4-ad34-4dcecdef795f}.
...

This will list each trace provider and it's GUID. The 2nd and 3rd values are flags passed to the trace provider to turn on and off various traces. How these values are used are provider specific. However if you just want to turn on all the flags pass in 0xFFFFFFFF and 255 like in my example below. Search MSDN for HTTP Service Trace and SSL Filter for information on what these flags do.

Here is my updated batch file (note it requires logparser tool which is downloadable from Microsoft) ->

rem START SSL TRACE DEMO
if exist ssltrace.guids del ssltrace.guids
echo {1fbecc45-c060-4e7c-8a0e-0dbd6116181b} 0xFFFFFFFF 255 IIS: SSL Filter >> ssltrace.guids
echo {dd5ef90a-6398-47a4-ad34-4dcecdef795f} 0xFFFFFFFF 255 HTTP Service Trace >> ssltrace.guids
logman start ssltrace -pf ssltrace.guids -o out.etl -ets
rem PRESS <SPACEBAR> TO STOP SSL+HTTP TRACING AND VIEW RESULTS
pause
logman stop ssltrace -ets
if exist ssltrace.guids del ssltrace.guids
if exist ssltrace.log del ssltrace.log
logparser -i:ETW "select * from out.etl" -e:ON >> ssltrace.log
start notepad ssltrace.log
rem END SSL TRACE DEMO

sql

Wednesday, March 21, 2012

Help with relational query - many to many

Hi all! I am working on a piece of SQL at the moment and I'm getting a little confused.
I have 3 tables: Items, Attributes and a table linking them. I have 5 attributes and an item can have any of the 5 attributes. So my linking table holds the ItemID and the AttributeID and there can be 1-5 entries for each Item.
A user can search for items based on Attributes; so they can tick 5 checkboxes that represent the 5 Attributes. So I need to build a query based on their choices. At the moment I'm using:
Select * FROM Items
INNER JOIN linking on Link_ItemID = Item_ID
WHERE Link_AttributeID IN (10, 13, 17)

But this brings out the Item that have either AttributeID of 10 or 13 or 17 whereas I need it to pull outONLYitems that have a AttributeID of 10 AND 13 AND 17.
Can anyone help with this query? Sorry if this is badly worded. The solutions is prolly something really simple I have overlooked... :S
I've also tried:
Select * FROM Items
INNER JOIN linking on Link_ItemID = Item_ID
WHERE Link_AttributeID = 10 AND AttributeID = 13 etc
But obviously that won't work! :sSelect *
from items i
where exists (select null from linking where link_itemID = i.item_id and link_attributeID = 10) and
exists (select null from linking where link_itemID = i.item_id and link_attributeID = 13) and
exists (select null from linking where link_itemID = i.item_id and link_attributeID = 17)

Nick|||Sorry for the late reply! Thanks for your post nick!
i got it working :)

Friday, March 9, 2012

Help with problem from editing rsWebApplicationConfig

Our report server was being accessed by machine name, not alias, so I had an alias set up.

I was working to get the subscription emails to use the new alias, instead of machine name. I think I should have edited the rsreportserver.config file, but first I edited the rsWebApplication.config file, and added an URL into <ReportServerURL> tag.

At that point clicking on New Subscriptions stopped working - now I always get an Error page with this message "Object reference not set to an instance of an object". That's only for new subscriptions, not new Data driven subscriptions.

In the error logs, I got this message:

w3wp!library!c!2/5/2007-18:46:46:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException: The report server has encountered a configuration error. See the report server log files for more information., ;
Info: Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException: The report server has encountered a configuration error. See the report server log files for more information. > System.Exception: The configuration file contains an element that is not valid. The ReportServerUrl element is not a configuration file element.
at Microsoft.ReportingServices.Diagnostics.UIConfiguration.ParseXML(XmlNode node, RSConfiguration configObject)
at Microsoft.ReportingServices.Diagnostics.RSConfiguration.ParseDocument()
at Microsoft.ReportingServices.Diagnostics.RSConfiguration.Load()
End of inner exception stack trace
w3wp!configmanager!c!2/5/2007-18:46:46:: Error occured with a config file change. New config file will not be used. Error: The report server has encountered a configuration error. See the report server log files for more information.

Now, no matter what I do to correct the rsWebApplication.config file, it doesn't seem to fix the problem (ie, I continue to get the above error, when trying to add a new subscription.)

What do I do to fix this?

Thanks in advance for any help!

Kristi

You can specify either the ReportServerVirtualDirectory element or the ReportServerUrl element, but not both. I'm not 100% sure this is yoiur problem, but that's what I'd check first.|||Thanks!

I think you are correct about not having both, and I think that caused my original problem - for awhile, I did have both specified.

However, once I read that information, I blanked out the ReportServerUrl, and now only have the ReportServerVirtualDirectory filled in. (and I tried reversing the two), but nothing seems to take effect now.

I've stopped and restarted both the IIS service and the SSR service, and while that was enough to make the original change to take effect, it does not seem to be resetting it to the original (working) state.

So, it's been a day, and your response prompted me to try the new subscription one more time, and indeed it has now started working again!

Fixed?!?!? The server has over 3000 hours uptime, so it wasn't a power cycle, but something seems to have reset itself, and is allowing new Subscriptions to be entered again.

I don't like when things "fix themselves", but our IT department might very well have changed something without notifying me, so ...

Thanks again for your reply. Kristi

Help with problem from editing rsWebApplicationConfig

Our report server was being accessed by machine name, not alias, so I had an alias set up.

I was working to get the subscription emails to use the new alias, instead of machine name. I think I should have edited the rsreportserver.config file, but first I edited the rsWebApplication.config file, and added an URL into <ReportServerURL> tag.

At that point clicking on New Subscriptions stopped working - now I always get an Error page with this message "Object reference not set to an instance of an object". That's only for new subscriptions, not new Data driven subscriptions.

In the error logs, I got this message:

w3wp!library!c!2/5/2007-18:46:46:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException: The report server has encountered a configuration error. See the report server log files for more information., ;
Info: Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException: The report server has encountered a configuration error. See the report server log files for more information. > System.Exception: The configuration file contains an element that is not valid. The ReportServerUrl element is not a configuration file element.
at Microsoft.ReportingServices.Diagnostics.UIConfiguration.ParseXML(XmlNode node, RSConfiguration configObject)
at Microsoft.ReportingServices.Diagnostics.RSConfiguration.ParseDocument()
at Microsoft.ReportingServices.Diagnostics.RSConfiguration.Load()
End of inner exception stack trace
w3wp!configmanager!c!2/5/2007-18:46:46:: Error occured with a config file change. New config file will not be used. Error: The report server has encountered a configuration error. See the report server log files for more information.

Now, no matter what I do to correct the rsWebApplication.config file, it doesn't seem to fix the problem (ie, I continue to get the above error, when trying to add a new subscription.)

What do I do to fix this?

Thanks in advance for any help!

Kristi

You can specify either the ReportServerVirtualDirectory element or the ReportServerUrl element, but not both. I'm not 100% sure this is yoiur problem, but that's what I'd check first.|||Thanks!

I think you are correct about not having both, and I think that caused my original problem - for awhile, I did have both specified.

However, once I read that information, I blanked out the ReportServerUrl, and now only have the ReportServerVirtualDirectory filled in. (and I tried reversing the two), but nothing seems to take effect now.

I've stopped and restarted both the IIS service and the SSR service, and while that was enough to make the original change to take effect, it does not seem to be resetting it to the original (working) state.

So, it's been a day, and your response prompted me to try the new subscription one more time, and indeed it has now started working again!

Fixed?!?!? The server has over 3000 hours uptime, so it wasn't a power cycle, but something seems to have reset itself, and is allowing new Subscriptions to be entered again.

I don't like when things "fix themselves", but our IT department might very well have changed something without notifying me, so ...

Thanks again for your reply. Kristi

Wednesday, March 7, 2012

Help with OpenXML

Hi,
I am trying to insert an XML document into into 3 tables which match the
hierachy of the xml and which appears to be working. This data could be an
update or an insert so for simplicity I have an initial procedure which
clears down the existing data using a cascading delete. This too appears to
be working.
However, when I check the tables there appears to be hundreds of duplicate
rows ? Has anybody come across anything similar. The tables do have an
identity field within them, which might be causing an issue I guess.
I am using SQL Server 2000 (sp3) on a Windows 2000 Server box.
Grateful for any helpJust realised we are actually using sp4 which might explain the problem, as
I
am using @.mp/@.parentid ?
"Redowl" wrote:

> Hi,
> I am trying to insert an XML document into into 3 tables which match the
> hierachy of the xml and which appears to be working. This data could be a
n
> update or an insert so for simplicity I have an initial procedure which
> clears down the existing data using a cascading delete. This too appears
to
> be working.
> However, when I check the tables there appears to be hundreds of duplicate
> rows ? Has anybody come across anything similar. The tables do have an
> identity field within them, which might be causing an issue I guess.
> I am using SQL Server 2000 (sp3) on a Windows 2000 Server box.
> Grateful for any help

Monday, February 27, 2012

Help with moving DB from 2000 to 2005 folders

Hi.
After installing SQLExpress on my DB Server, I have
the following file directory:
80
90
MSSQL
MSSQL.1
I am noticing that the DB that I am working with is in
MSSQL > DATA > MY_DB.MDF
On the Web Server, I want to connect to (server name)/SQLEXPRESS so I
am guessing I need to move MY_DB.MDF from folder MSSQL > DATA to
folder MSSQL.1 > MSSQL > DATA.
How do I do this? Is this as simple as moving the MDF and LDF files
from the 2000 folder to the 2005 folder? Or, is it more involved?
Also, should I be keeping the 80 and MSQL folders
on my hard drive?
Thanks in advance!
When you connect to SQLExpress from your Web Server, you ask the rdbms to
give you some resultset. Why should you move your databases? I suppose you
migrate them or at least detach them from old instance and attach them to
SQLExpress.
The folders hierarchy you see is just the default location for SQL files
(You can find there, for example, the system databases SQL installed during
setup). You can locate your Databases everywhere you like.
Gilberto Zampatti
"pbd22" wrote:

> Hi.
> After installing SQLExpress on my DB Server, I have
> the following file directory:
> 80
> 90
> MSSQL
> MSSQL.1
> I am noticing that the DB that I am working with is in
> MSSQL > DATA > MY_DB.MDF
> On the Web Server, I want to connect to (server name)/SQLEXPRESS so I
> am guessing I need to move MY_DB.MDF from folder MSSQL > DATA to
> folder MSSQL.1 > MSSQL > DATA.
> How do I do this? Is this as simple as moving the MDF and LDF files
> from the 2000 folder to the 2005 folder? Or, is it more involved?
> Also, should I be keeping the 80 and MSQL folders
> on my hard drive?
> Thanks in advance!
>

Help with moving DB from 2000 to 2005 folders

Hi.
After installing SQLExpress on my DB Server, I have
the following file directory:
80
90
MSSQL
MSSQL.1
I am noticing that the DB that I am working with is in
MSSQL > DATA > MY_DB.MDF
On the Web Server, I want to connect to (server name)/SQLEXPRESS so I
am guessing I need to move MY_DB.MDF from folder MSSQL > DATA to
folder MSSQL.1 > MSSQL > DATA.
How do I do this? Is this as simple as moving the MDF and LDF files
from the 2000 folder to the 2005 folder? Or, is it more involved?
Also, should I be keeping the 80 and MSQL folders
on my hard drive?
Thanks in advance!When you connect to SQLExpress from your Web Server, you ask the rdbms to
give you some resultset. Why should you move your databases? I suppose you
migrate them or at least detach them from old instance and attach them to
SQLExpress.
The folders hierarchy you see is just the default location for SQL files
(You can find there, for example, the system databases SQL installed during
setup). You can locate your Databases everywhere you like.
Gilberto Zampatti
"pbd22" wrote:
> Hi.
> After installing SQLExpress on my DB Server, I have
> the following file directory:
> 80
> 90
> MSSQL
> MSSQL.1
> I am noticing that the DB that I am working with is in
> MSSQL > DATA > MY_DB.MDF
> On the Web Server, I want to connect to (server name)/SQLEXPRESS so I
> am guessing I need to move MY_DB.MDF from folder MSSQL > DATA to
> folder MSSQL.1 > MSSQL > DATA.
> How do I do this? Is this as simple as moving the MDF and LDF files
> from the 2000 folder to the 2005 folder? Or, is it more involved?
> Also, should I be keeping the 80 and MSQL folders
> on my hard drive?
> Thanks in advance!
>|||Ok, thanks. I am learning as I go.
I have a follow-up question. Its related, but different so
I will repost. Thanks for your help!
Gilberto Zampatti wote:
> When you connect to SQLExpress from your Web Server, you ask the rdbms to
> give you some resultset. Why should you move your databases? I suppose you
> migrate them or at least detach them from old instance and attach them to
> SQLExpress.
> The folders hierarchy you see is just the default location for SQL files
> (You can find there, for example, the system databases SQL installed during
> setup). You can locate your Databases everywhere you like.
> Gilberto Zampatti
> "pbd22" wrote:
> > Hi.
> >
> > After installing SQLExpress on my DB Server, I have
> > the following file directory:
> >
> > 80
> > 90
> > MSSQL
> > MSSQL.1
> >
> > I am noticing that the DB that I am working with is in
> >
> > MSSQL > DATA > MY_DB.MDF
> >
> > On the Web Server, I want to connect to (server name)/SQLEXPRESS so I
> > am guessing I need to move MY_DB.MDF from folder MSSQL > DATA to
> > folder MSSQL.1 > MSSQL > DATA.
> >
> > How do I do this? Is this as simple as moving the MDF and LDF files
> > from the 2000 folder to the 2005 folder? Or, is it more involved?
> > Also, should I be keeping the 80 and MSQL folders
> > on my hard drive?
> >
> > Thanks in advance!
> >
> >

Help with moving DB from 2000 to 2005 folders

Hi.
After installing SQLExpress on my DB Server, I have
the following file directory:
80
90
MSSQL
MSSQL.1
I am noticing that the DB that I am working with is in
MSSQL > DATA > MY_DB.MDF
On the Web Server, I want to connect to (server name)/SQLEXPRESS so I
am guessing I need to move MY_DB.MDF from folder MSSQL > DATA to
folder MSSQL.1 > MSSQL > DATA.
How do I do this? Is this as simple as moving the MDF and LDF files
from the 2000 folder to the 2005 folder? Or, is it more involved?
Also, should I be keeping the 80 and MSQL folders
on my hard drive?
Thanks in advance!When you connect to SQLExpress from your Web Server, you ask the rdbms to
give you some resultset. Why should you move your databases? I suppose you
migrate them or at least detach them from old instance and attach them to
SQLExpress.
The folders hierarchy you see is just the default location for SQL files
(You can find there, for example, the system databases SQL installed during
setup). You can locate your Databases everywhere you like.
Gilberto Zampatti
"pbd22" wrote:

> Hi.
> After installing SQLExpress on my DB Server, I have
> the following file directory:
> 80
> 90
> MSSQL
> MSSQL.1
> I am noticing that the DB that I am working with is in
> MSSQL > DATA > MY_DB.MDF
> On the Web Server, I want to connect to (server name)/SQLEXPRESS so I
> am guessing I need to move MY_DB.MDF from folder MSSQL > DATA to
> folder MSSQL.1 > MSSQL > DATA.
> How do I do this? Is this as simple as moving the MDF and LDF files
> from the 2000 folder to the 2005 folder? Or, is it more involved?
> Also, should I be keeping the 80 and MSQL folders
> on my hard drive?
> Thanks in advance!
>|||Ok, thanks. I am learning as I go.
I have a follow-up question. Its related, but different so
I will repost. Thanks for your help!
Gilberto Zampatti wote:[vbcol=seagreen]
> When you connect to SQLExpress from your Web Server, you ask the rdbms to
> give you some resultset. Why should you move your databases? I suppose you
> migrate them or at least detach them from old instance and attach them to
> SQLExpress.
> The folders hierarchy you see is just the default location for SQL files
> (You can find there, for example, the system databases SQL installed durin
g
> setup). You can locate your Databases everywhere you like.
> Gilberto Zampatti
> "pbd22" wrote:
>