This ASPX/SqlServer stuff is driving me nuts.
1 - In a previous post I said I had four tables and all were showing up in
Object Explorer (MS SQL Server Management Studio Express), but when I went
to do a query using the query text editor, only two of the tables showed up.
Then, mysteriously, the problem went away. Now, it is back.
2 - My insert into a table failed from the debug version in Web Developer,
so I copied that SQL call and pasted it into SQL Server Management Program
and ran the query. It worked. I then did a select * and only that entry
showed up, not all the others. However, from my localhost website, when I
do that select all the others show up but not the new one. This tells me
that I must be looking at two different databases. The one from the site is
the same as the one outlined in Object Explorer, but query window is
connected to a different one. Try as I might, I have not been able to get
the query window one to attach to the one in Object Explorer. In that app,
the one that I want is listed as LAPTOP\SQLEXPRESS(Server 9,0.3042 -
LAPTOP\Sheldon) and then the db name. The "other one" is SQL Server
Compact Edition [MyComputer\...\thedbname]. In my app, the connection
string in the config file is "Data Source=LAPTOP\SQLEXPRESS;Initial
Catalog=thedbname;Integrated Security=True"
providerName="System.Data..SqlClient"
3 - I still can't figure out why my submit button will not fire an event if
the last event was the one fired by that submit button.
Please, someone, help me out here.
Shelly
5  1394 
One more thing: The sql query window indicated that it is using
LAPTOP\SQLEXPRESS -- the correct database, the one that I want. Doing a
change_connection to that one still results in the same thing. If I do a
select * from one of the tables that show up in Object Explorer (other than
this one), it gives me "Invalid object name" -- because it doesn't have that
table.
Could this be a problem with my configuration in that I should only have one
or the other? If that is the case, how do I get rid of the Compact Edition?
Also, how do I find out where the actual database file is located?
"Shelly" <sh************@asap-consult.comwrote in message
news:13*************@corp.supernews.com...
This ASPX/SqlServer stuff is driving me nuts.
1 - In a previous post I said I had four tables and all were showing up in
Object Explorer (MS SQL Server Management Studio Express), but when I went
to do a query using the query text editor, only two of the tables showed
up. Then, mysteriously, the problem went away. Now, it is back.
2 - My insert into a table failed from the debug version in Web Developer,
so I copied that SQL call and pasted it into SQL Server Management Program
and ran the query. It worked. I then did a select * and only that entry
showed up, not all the others. However, from my localhost website, when I
do that select all the others show up but not the new one. This tells me
that I must be looking at two different databases. The one from the site
is the same as the one outlined in Object Explorer, but query window is
connected to a different one. Try as I might, I have not been able to get
the query window one to attach to the one in Object Explorer. In that
app, the one that I want is listed as LAPTOP\SQLEXPRESS(Server 9,0.3042 -
LAPTOP\Sheldon) and then the db name. The "other one" is SQL Server
Compact Edition [MyComputer\...\thedbname]. In my app, the connection
string in the config file is "Data Source=LAPTOP\SQLEXPRESS;Initial
Catalog=thedbname;Integrated Security=True"
providerName="System.Data..SqlClient"
3 - I still can't figure out why my submit button will not fire an event
if the last event was the one fired by that submit button.
Please, someone, help me out here.
Shelly
Well,
it certainly does sound like you've got more than one of the same database
going on.
What I'd do is:
1) Script out your "best" database using the Database Publishing Wizard to a
SQL text file.
2) Remove ALL database connections from management studio including the
compact edtion.
3) scour your machine(s) for *.MDF database files and get rid of them.
4) Create a new database in the exact place where you want it - ONLY ONE.
5) execute your saved SQL script against it to recreate your database.
6) connect to the same single database from anywhere you work so you don't
run into issues.
good luck.
Peter
--
Recursion: see Recursion
site: http://www.eggheadcafe.com
unBlog: http://petesbloggerama.blogspot.com
BlogMetaFinder: http://www.blogmetafinder.com
"Shelly" wrote:
This ASPX/SqlServer stuff is driving me nuts.
1 - In a previous post I said I had four tables and all were showing up in
Object Explorer (MS SQL Server Management Studio Express), but when I went
to do a query using the query text editor, only two of the tables showed up.
Then, mysteriously, the problem went away. Now, it is back.
2 - My insert into a table failed from the debug version in Web Developer,
so I copied that SQL call and pasted it into SQL Server Management Program
and ran the query. It worked. I then did a select * and only that entry
showed up, not all the others. However, from my localhost website, when I
do that select all the others show up but not the new one. This tells me
that I must be looking at two different databases. The one from the site is
the same as the one outlined in Object Explorer, but query window is
connected to a different one. Try as I might, I have not been able to get
the query window one to attach to the one in Object Explorer. In that app,
the one that I want is listed as LAPTOP\SQLEXPRESS(Server 9,0.3042 -
LAPTOP\Sheldon) and then the db name. The "other one" is SQL Server
Compact Edition [MyComputer\...\thedbname]. In my app, the connection
string in the config file is "Data Source=LAPTOP\SQLEXPRESS;Initial
Catalog=thedbname;Integrated Security=True"
providerName="System.Data..SqlClient"
3 - I still can't figure out why my submit button will not fire an event if
the last event was the one fired by that submit button.
Please, someone, help me out here.
Shelly
OK, here is an update. Can someone please explain this to me?
I got it down to one database in the Object Explorer. When I then went into
the query editor, once again only two of the four tables showed up, and if I
queried one of them I got the wrong data.
I then went to Object Explorer and right clicked on each of the tables and
picked the "Script Table As...". Each one produced a query and each query
worked properly giving the correct data. That is for all four tables. I
then went back to the Query Editor and now all four tables show up?
What happened behind the scenes here?
Oh, I still have the second click on the button problem.
Shelly
"Shelly" <sh************@asap-consult.comwrote in message
news:13*************@corp.supernews.com...
One more thing: The sql query window indicated that it is using
LAPTOP\SQLEXPRESS -- the correct database, the one that I want. Doing a
change_connection to that one still results in the same thing. If I do a
select * from one of the tables that show up in Object Explorer (other
than this one), it gives me "Invalid object name" -- because it doesn't
have that table.
Could this be a problem with my configuration in that I should only have
one or the other? If that is the case, how do I get rid of the Compact
Edition? Also, how do I find out where the actual database file is
located?
"Shelly" <sh************@asap-consult.comwrote in message
news:13*************@corp.supernews.com...
>This ASPX/SqlServer stuff is driving me nuts.
1 - In a previous post I said I had four tables and all were showing up
in Object Explorer (MS SQL Server Management Studio Express), but when I
went to do a query using the query text editor, only two of the tables
showed up. Then, mysteriously, the problem went away. Now, it is back.
2 - My insert into a table failed from the debug version in Web
Developer, so I copied that SQL call and pasted it into SQL Server
Management Program and ran the query. It worked. I then did a select *
and only that entry showed up, not all the others. However, from my
localhost website, when I do that select all the others show up but not
the new one. This tells me that I must be looking at two different
databases. The one from the site is the same as the one outlined in
Object Explorer, but query window is connected to a different one. Try
as I might, I have not been able to get the query window one to attach to
the one in Object Explorer. In that app, the one that I want is listed
as LAPTOP\SQLEXPRESS(Server 9,0.3042 - LAPTOP\Sheldon) and then the db
name. The "other one" is SQL Server Compact Edition
[MyComputer\...\thedbname]. In my app, the connection string in the
config file is "Data Source=LAPTOP\SQLEXPRESS;Initial
Catalog=thedbname;Integrated Security=True"
providerName="System.Data..SqlClient"
3 - I still can't figure out why my submit button will not fire an event
if the last event was the one fired by that submit button.
Please, someone, help me out here.
Shelly
Now one more. From my code, I couldn't do the insert I wanted. I stopped
it in the debugger and copied the sql command. I then pasted that sql
command into the sql window in sql server manager and executed it. It
worked perfectly. I suspect it has to be a permissions problem. How can I
find what error was returned in the code from the attempted insert?
Shelly
"Shelly" <sh************@asap-consult.comwrote in message
news:13*************@corp.supernews.com...
OK, here is an update. Can someone please explain this to me?
I got it down to one database in the Object Explorer. When I then went
into the query editor, once again only two of the four tables showed up,
and if I queried one of them I got the wrong data.
I then went to Object Explorer and right clicked on each of the tables and
picked the "Script Table As...". Each one produced a query and each query
worked properly giving the correct data. That is for all four tables. I
then went back to the Query Editor and now all four tables show up?
What happened behind the scenes here?
Oh, I still have the second click on the button problem.
Shelly
"Shelly" <sh************@asap-consult.comwrote in message
news:13*************@corp.supernews.com...
>One more thing: The sql query window indicated that it is using
LAPTOP\SQLEXPRESS -- the correct database, the one that I want. Doing a
change_connection to that one still results in the same thing. If I do a
select * from one of the tables that show up in Object Explorer (other
than this one), it gives me "Invalid object name" -- because it doesn't
have that table.
Could this be a problem with my configuration in that I should only have
one or the other? If that is the case, how do I get rid of the Compact
Edition? Also, how do I find out where the actual database file is
located?
"Shelly" <sh************@asap-consult.comwrote in message
news:13*************@corp.supernews.com...
>>This ASPX/SqlServer stuff is driving me nuts.
1 - In a previous post I said I had four tables and all were showing up
in Object Explorer (MS SQL Server Management Studio Express), but when I
went to do a query using the query text editor, only two of the tables
showed up. Then, mysteriously, the problem went away. Now, it is back.
2 - My insert into a table failed from the debug version in Web
Developer, so I copied that SQL call and pasted it into SQL Server
Management Program and ran the query. It worked. I then did a select *
and only that entry showed up, not all the others. However, from my
localhost website, when I do that select all the others show up but not
the new one. This tells me that I must be looking at two different
databases. The one from the site is the same as the one outlined in
Object Explorer, but query window is connected to a different one. Try
as I might, I have not been able to get the query window one to attach
to the one in Object Explorer. In that app, the one that I want is
listed as LAPTOP\SQLEXPRESS(Server 9,0.3042 - LAPTOP\Sheldon) and then
the db name. The "other one" is SQL Server Compact Edition
[MyComputer\...\thedbname]. In my app, the connection string in the
config file is "Data Source=LAPTOP\SQLEXPRESS;Initial
Catalog=thedbname;Integrated Security=True"
providerName="System.Data..SqlClient"
3 - I still can't figure out why my submit button will not fire an event
if the last event was the one fired by that submit button.
Please, someone, help me out here.
Shelly
I figured it out. In the catch all I had to do was add "e as Exception" and
then e.ToString() gave me the text. It works now.
I still have the second click not working.
Shelly
"Shelly" <sh************@asap-consult.comwrote in message
news:13*************@corp.supernews.com...
Now one more. From my code, I couldn't do the insert I wanted. I stopped
it in the debugger and copied the sql command. I then pasted that sql
command into the sql window in sql server manager and executed it. It
worked perfectly. I suspect it has to be a permissions problem. How can
I find what error was returned in the code from the attempted insert?
Shelly
"Shelly" <sh************@asap-consult.comwrote in message
news:13*************@corp.supernews.com...
>OK, here is an update. Can someone please explain this to me?
I got it down to one database in the Object Explorer. When I then went
into the query editor, once again only two of the four tables showed up,
and if I queried one of them I got the wrong data.
I then went to Object Explorer and right clicked on each of the tables
and picked the "Script Table As...". Each one produced a query and each
query worked properly giving the correct data. That is for all four
tables. I then went back to the Query Editor and now all four tables
show up?
What happened behind the scenes here?
Oh, I still have the second click on the button problem.
Shelly
"Shelly" <sh************@asap-consult.comwrote in message
news:13*************@corp.supernews.com...
>>One more thing: The sql query window indicated that it is using
LAPTOP\SQLEXPRESS -- the correct database, the one that I want. Doing a
change_connection to that one still results in the same thing. If I do
a select * from one of the tables that show up in Object Explorer (other
than this one), it gives me "Invalid object name" -- because it doesn't
have that table.
Could this be a problem with my configuration in that I should only have
one or the other? If that is the case, how do I get rid of the Compact
Edition? Also, how do I find out where the actual database file is
located?
"Shelly" <sh************@asap-consult.comwrote in message
news:13*************@corp.supernews.com...
This ASPX/SqlServer stuff is driving me nuts.
1 - In a previous post I said I had four tables and all were showing up
in Object Explorer (MS SQL Server Management Studio Express), but when
I went to do a query using the query text editor, only two of the
tables showed up. Then, mysteriously, the problem went away. Now, it
is back.
2 - My insert into a table failed from the debug version in Web
Developer, so I copied that SQL call and pasted it into SQL Server
Management Program and ran the query. It worked. I then did a select
* and only that entry showed up, not all the others. However, from my
localhost website, when I do that select all the others show up but not
the new one. This tells me that I must be looking at two different
databases. The one from the site is the same as the one outlined in
Object Explorer, but query window is connected to a different one. Try
as I might, I have not been able to get the query window one to attach
to the one in Object Explorer. In that app, the one that I want is
listed as LAPTOP\SQLEXPRESS(Server 9,0.3042 - LAPTOP\Sheldon) and then
the db name. The "other one" is SQL Server Compact Edition
[MyComputer\...\thedbname]. In my app, the connection string in the
config file is "Data Source=LAPTOP\SQLEXPRESS;Initial
Catalog=thedbname;Integrated Security=True"
providerName="System.Data..SqlClient"
3 - I still can't figure out why my submit button will not fire an
event if the last event was the one fired by that submit button.
Please, someone, help me out here.
Shelly
This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics | |
by: Jim Davidson |
last post by:
Here's what I'm trying to do:
I have a string with 30 numbers in it. I want to generate a random
number between 0 an 30, go to that position in the string and get that
number. Here is the code...
|
by: Tom Szabo |
last post by:
cTemp = oNode.cName;
aStatList = "term";
window.alert(aStatList); -> "term"
window.alert(aStatList.length); -> "0"
the above code is going to display "term" and "0"
...
|
by: Fresh Air Rider |
last post by:
Hi
I understand that ASP.net 2.0 (Whidbey) is going to reduce coding by
70%.
Surely this is going to de-skill or dumb down the developer's task and
open up the task of web development to less...
|
by: Kevin |
last post by:
I don't know if I should even start this topic but here goes.
I'm an ex vb6 developer, now developing in C#.
The reason why I started developing in C# is because the company that I
worked for at...
|
by: Kathy Burke |
last post by:
Ugh. I'm using the following in an asp.net. I get an Syntax Error in
INSERT INTO Statement on line Cmd1.ExecuteNonQuery().
I've made all my database fields text (just to eliminate that as a...
| | |
by: Marty |
last post by:
It seems all of the sudden that user controls that
contain images are referencing image sources relative to
the document that I drop the control on. This obviously
does not work beacuase the...
|
by: Johnny Emde |
last post by:
Hello Newsgroup
I'm about going nuts!!!
Sometime when I coding a asp.net (using C#) I'll get this wierd error.
Configuration Error
Description: An error occurred during the processing of a...
|
by: windandwaves |
last post by:
Hi
I have the following file:
--myfile.php
<?php
if($s) {
echo $s;
session_id($s);
session_start;
|
by: jimmy.musselwhite |
last post by:
Hello all
It would be great if I could make a number that can go beyond current
size limitations. Is there any sort of external library that can have
infinitely huge numbers? Way way way way...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers,...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
| | |
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
| | |
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence...
| |
