Problem With 1 Table In MSDE DB

Nov 17, 2005

Hello all.

First I will be the first to say that I'm very inexperienced when it comes to working with MS SQL DBs. I'm doing my best to learn though.

Here is my problem. I have a piece of software that connects up to an MSDE instance. Within this instance there is a database called TTUSER. And within the TTUSER database, there are several tables, one of which called User. I can not seem to do anything with this table. For example when I just try to see the contents of the UserID column, I get:

1> select UserID from User
2> go
Msg 156, Level 15, State 1, Server <MyMsdeServerName>, Line 1
Incorrect syntax near the keyword 'User'.

However, when I try the exact same command above, but use the Logon table instead of the User table, it works just fine, and I see the contents of the UserID column from the Logon table.

I also tried copying the User Table with this:

1> select * into Test from User
2> go
Msg 156, Level 15, State 1, Server 10250-JORUM, Line 1
Incorrect syntax near the keyword 'User'.

And again, if I just substitute the User table with the Logon table, it copies just fine. Both of these tables, Logon and User, are in the same database, TTUser.

I would just like to be able to view the contents of the User table from command line, and maybe send it into a text file. Thanks for your help.

Jnuw

View 2 Replies


ADVERTISEMENT

Sql MSDE Table Edit

Oct 23, 2004

I have a table with data in it. Now I want to change the Data Type from int to varchar. Is there anyway to do this because I don't want to delete all the data and re-enter it. That seems to be the only way I can see to change the data type. I would appreciate some help. thanks.

View 10 Replies View Related

ADP Don't Shows Table From MSDE

Sep 27, 2005

Hi,

I created one blank ADP to connect default tempdb database on MSDE on server ASHFAQUEPC (name of my msde server). Tested the connection was successful.

I created a table called Testtable from command prompt (MSSQL/Binn) in default tempdb of MSDE using following lines:

…Binn>osql/U sa mypassword

1> use tempdb
1> go
1> Create table Testtable (Cnum integer NOT NULL PRIMARY KEY, City Varchar(15))
1> go

Table Created successfully then I added 2-3 records using following lines;

1> INSERT INTO testable (cnum, city)
1> values (1, ‘abc’)
1> go

1 Record affected and I did same to add 2-3 more records. Then I used following lines to see all the records I entered.

1> select * from testable
1> go

And a list of records displayed at command prompt. After exit from command prompt I found a ‘Testtable’ appeared in the above ADP.

But next day when I opened my pc and opened ADP, I did not found the Testtable even though I re-connected to tempdb on MSDE from File menu. I reached then to command prompt to see whether the table itself is existing. Strange it was not there.

Can somebody tell me how can I get connected to testable automatically when I open my ADP? Where might have gone wrong? Do I need to create table again and input records?
I want to make sure before I do anything with my real dbs.

Any help would be highly appreciated.

With kind regards,
Ashfaque :confused:

View 7 Replies View Related

How Do I Step Thru A MSDE Data Table

Aug 9, 2006

Seems like there is no cursor support for MSDE.  Is there a way other than clicking a DataGrid to step thru a selection of some tables?
I'd like to do some updating and insertion to another table using some selection criteria of two tables.  Is there a way to do that in MSDE and ASP.NET environment?
I'm pretty new to MSDE and ASP.
Thanks.
 

View 7 Replies View Related

MSDE Text Datatype - Unable To Store More Than 900 Characters. (msde + Visual Studio 2003)

Jun 6, 2005

Hello,

I'm not sure if it's the setup I did wrong, but I can't seem to get my
text datatype in my database to store more than 900 characters. 
I'm trying to setup a news database for my website, which will populate
the information into a datagrid.  To test, I manually added a news
item in the database through the visual studio 2003 gui.  I
immediately noticed a problem as the I was getting an error after a
long news item saying:

"The value you entered is not consistent with the data type or length of the column, or over grid buffer limit."

I couldn't find anthing to set the buffer limit and the datatype is
"text" filled with simple text in the column.  As a further test,
I
simply entered 12334567890123... up to 900 characters and still
recevied the error.

I would appreciate someone leading me in the right direction on this one.

Thanks a lot.

View 1 Replies View Related

How Do I Change The Name Of A Computer Running MSDE With Out Reinstalling MSDE

May 27, 2000

I am trying to change the computer name of a machine running MSDE but I get an error when SQL Server starts. With regular SQL when I change the name of a computer I re-run setup and setup fixes this problem. MSDE can only be installed from unattended mode so I can’t rerun setup and fix the problem.

My question is "How do I change the name of a computer running MSDE with out reinstalling MSDE"

View 1 Replies View Related

MSDE: Renaming Machine Without Reinstall Of MSDE

Mar 27, 2001

We currently have the problem, that all our machines are produced with the
same name and afterwards the name is changed. So we have the problem that
the checksum key for the MSDE isn't valid anymore. As MSDE can only be installed
from unattended mode so I can’t rerun setup and fix the problem. Does anyone
know a solution for this problem ?? A program recalculating the cheksum ??

regards,

Manfred

View 3 Replies View Related

MSDE Worth Using Or Should I Invest In MySQL? (was MSDE)

Mar 9, 2005

I'm not sure if this is the correct forum for this this question but I'll give it a shot.

The only db development that I have ever done is in MS Access. I have a project at work that is being accomplished in VB and I need a db engine to use as the back end. Visual studio came with a copy of MSDE. Is this tool worth using or should I invest in mySQL? Are there any advantages to using MSDE over mySQL?

View 4 Replies View Related

Maximum Capacity Specifications Comparison Table For Access, SQL Server 7, 2000 And MSDE 2000

May 27, 2008











Parameter
Access 2000/XP
SQL Server 7.0
SQL Server 2000
MSDE 2000

Number of instances per server
n/a
n/a
16
16

Number of databases per instance / server
n/a
32,767
32,767
32,767

Number of objects per database
32,768
2,147,483,647
2,147,483,647
2,147,483,647

Number of users per database
n/a
16,379
16,379
16,379

Number of roles per database
n/a
16,367
16,367
16,367

Overall size of database (excluding logs)
2 GB
1,048,516 TB
1,048,516 TB
2 GB

Number of columns per table
255
1024
1024
1024

Number of rows per table
limited by storage
limited by storage
limited by storage
limited by storage

Number of bytes per row





(Excluding TEXT/MEMO/IMAGE/OLE)
2 KB
8 KB
8 KB
8 KB

Number of columns per query
255
4,096
4,096
4,096

Number of tables per query
32
256
256
256

Size of procedure / query
64 KB
250 MB
250 MB
250 MB

Number of input params per procedure / query
199
1,024
2,100
2,100

Size of SQL statement / batch
64 KB
64 KB
64 KB
64 KB

Depth of subquery nesting
50
32
32
32

Number of indexes per table
32
250 (1 clustered)
250 (1 clustered)
250 (1 clustered)

Number of columns per index
10
16
16
16

Number of characters per object name
64
128
128
128

Number of concurrent user connections
255
32,767
32,767
5

View 1 Replies View Related

MSDE

Nov 15, 2003

I looking for some guidance here. I have database which has exceeded the 2 gig limit. I deleted some old tables in an attempt to acquire some space. This worked out. However when I look at the size of my *.mdf it still appears in excess of the 2 gigs . I know this isn't true since I deleted 500 megs of stuff. How do i reclaim the space (get the file size to report correctly) or do I need to even worry about it.

Andy

View 2 Replies View Related

Need Help With MSDE(anybody)

Nov 18, 2003

Hi

I have visual studio .net and i recently installed MSDE specific for visual studio.

The name of my server is FRANKNETSDK.

String strConnection ="server=FRANK\NETSDK;database=Northwind;integrated security=true";
SqlConnection objConnection = new SqlConnection(strConnection);
objConnection.Open();
objConnection.Close();

I created an instance which is NETSDK
I created a password
I don't know why my server choose the name FRANK i was expecting local.
I have to use FRANKNETSDK or else i can't get my server to Start.


This is the error: Login failed for user 'FRANKASPNET'.

[SqlException: Login failed for user 'FRANKASPNET'.]
System.Data.SqlClient.ConnectionPool.GetConnection(Boolean& isInTransaction) +474
System.Data.SqlClient.SqlConnectionPoolManager.GetPooledConnection(SqlConnectionString options, Boolean& isInTransaction) +372
System.Data.SqlClient.SqlConnection.Open() +384
sqlconnect.WebForm1.Page_Load(Object sender, EventArgs e) in c:inetpubwwwrootsqlconnectwebform1.aspx.cs:27
System.Web.UI.Control.OnLoad(EventArgs e) +67
System.Web.UI.Control.LoadRecursive() +35
System.Web.UI.Page.ProcessRequestMain() +731


Any help would greatly be appreciated.

View 1 Replies View Related

Need Help With Msde(please Anyone)

Nov 22, 2003

Hi

For quite some time nowI have been trying to give user rights to my MSDE , needless to say the fruits of my labor have turned up very little success.

So far i have tried using the osql commands to grant user access to my database. I have run the stored procedures(sp_grantlogin ,sp_grantdbaccess ) but to little avail!

So now i have taken a new approach i installed the Enterprise Manager. I have just a minor problem with this new strategy , i don't know how to use it!!

This is what i have prensently installed on my system: Visual studio.Net ,Microsoft SQL(MSDE)
and finally the Enterprise Manager.

My Servername is FRANK.
I have created an instance which is NetSDK (FRANKNETSDK)
My SAPWD is Kildare
I have Mixed Mode

Can anyone please tell me how i can use the Enterprise Manager to grant access to MSDE.
I am sure you have all realized from all these insipid post that i have no experience.
So please be explicit in all your details.

My email roti@videotron.ca

Thank you
Frank

View 3 Replies View Related

MSDE

Jan 17, 2004

Having Problem connecting to Database with WebMatrix

When I try to ADD Database in WebMatrix through Sql Connection & enter USERNAME & PASSWORD it fails. Is there a way to create New USERNAME & PASSWORD? Perhaps through
the Command Line Prompt?

Any Help/Advice TIA

Tristen

View 1 Replies View Related

MSDE Help

Jan 31, 2004

I have never done anything with databases, so I am a newbie. My goal is to install an ASP.NET forum, but I need MSDE installed. I downloaded MSDE from the Microsoft website. When I run the setup.exe file, I get an error. It says:


A strong SA password is required for security reasons. Please use SAPWD switch to supply
same. Refer to readme for more details. Setup will now exit.



I looked at the documentation but could not find anything usefull, what do I have to do to install it. Thanks in advance for responses.

View 2 Replies View Related

MSDE

Mar 19, 2004

How does MSDE handle data mangement? Does it come with sql analyser or some sort of database manager?
Thanks.

View 5 Replies View Related

New In MSDE, Please Help!

Aug 25, 2004

Hi,

I am newbie in ASP.NET and MSDE arena. I understand that MSDE has no GUI and I need to have MSDE tools to work with it. I have already installed ASP.NET 1.1 and Microsoft.NET SDK 1.1 and MSDE in my Windown Professional 2000 PC and I have run and tested for .aspx and its working perfectly. But I want to use MSDE to create some database driven web applications.

Could you please help me how I can do that? BTW, I installed Microsoft SQL Web Data Administrator and its giving me SQLWebAdminStart.exe Application error and asking for debugging while opening the program. I am stranded what to do now?

I really appreciate your help.


regards,
Peter-Toronto
(Linux, PHP, MySQL)

View 1 Replies View Related

Help Me Set Up Msde

Sep 6, 2004

I just installed MSDE off of disk that came with teach yourself asp.net in 24 hours. To get the program started you must go to run and type cmd and wait for the C prompt. I get this far, but I can't get a C prompt. It always comes up C:sql2ksp3> How do I get a C prompt from here. I know it must be something easy that I am just overlooking or forgot.
Thanks
Del Dobbs

View 1 Replies View Related

NEED HELP WITH MSDE!!!!!

Feb 27, 2005

Hi ,

I m trying to install MSDE database at my machine to Test my queries and page so i can upload them. I did changed the Path and added osql. and all that things. Its still giving me an error. Which is
" Server Error in '/QuickStart/aspplus/samples/grocertogo/VB' Application.

SQL Server does not exist or access denied.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. "

not sure what exactly to do. Also if have SQL server runing on remote machine is there any other way i can check my pages. Any help wikk be greatfull. Many thanx in advance

KHan

View 4 Replies View Related

Using MSDE

Mar 4, 2005

Hi all,
I have a web application that uses SQL Server. I have 6 clients that all use the same SQL Server database structure.
I know have a new client who is using MSDE as there Database. The Database should have the same table structures as the SQL ones.

So my questions are this:
1. I have a backup of the new clients data. How do I attach it to SQL Server?
2. Does MSDE have stored procedures?
3. Can I write stored procedures in a SQL Database, that reference tables in an MSDE database.
4. Can someone point me in a direction, that can walk me through this?

Thanks

Scott

View 5 Replies View Related

Using MSDE

Apr 2, 2005

Hi,
Well i want to ask, Is this true that 
 We can use the MSDE on commercial basis for a  limited usagage  with out paying.
The limited usage means that may be upto 20 - 25 concurent users can be  use the Engine at a time.
   thx for the comments  

View 1 Replies View Related

MSDE

Oct 24, 2005

I installed MSDE 2000 in my system. There is no icon & gui screen. How can i create/alter database using MSDE without using any programming language? from where can i get stored data in msde? How can i take backup for this data?

View 2 Replies View Related

MSDE

Nov 23, 2005

Hello,
Is it possible that i have my webapplication on a webserver and my database on another server?The database is MSDE.Thanks for your respond

View 1 Replies View Related

MSDE

Dec 29, 2005

I want to connect to the MSDE database and create database and tables etc.., I am successful in creating the database and tabels etc.., as shown below:
string ConnString;
ConnString = "data source=(local);" +
"database=;integrated security=sspi";
SqlConnection SqlConn = new SqlConnection(ConnString);SqlConn.Open();
SqlCommand SqlCmd = new SqlCommand("Create DATABASE dbase1", SqlConn);SqlCmd.ExecuteNonQuery();SqlConn.Close();
but Instead of connecting to the MSDE without giving any database name,canI create the instance of MSDE on the fly  and connect to it. Like creating a MSDE OBject to start the MSDE and then connect to it using Windows NT authentication
 

View 1 Replies View Related

MSDE And W98

Dec 21, 2001

How do you deal with MSDE on a W98 machine since it can not run as a service?

View 1 Replies View Related

MSDE

Nov 19, 2001

Hi,
I have developed a site for a client using asp and sql server, and now want to roll this out to the client using MSDE, since the only application using the database will be the website, so they really don't need full sql server.
I've seen plenty of articles telling me how this is possible, but I can't find anything telling me how to start.
The webserver will be on the client site, and controlled by myself as this is an intranet application.
Do I install MSDE on the client site from my Microsoft CD's or do I install particular files, and that's just for starters.If anyone has done something similar I would really appreciate their advice.
Regds Paul McGirr

View 1 Replies View Related

Msde

Jul 15, 2004

Hi,

Please guide me.

All our customers have sybase as thier backend and VB as thier front end and now we want to migrate to SQL server. So I have to send a CD to our customers with the free SQL version(MSDE) and everything has to be automated.My CD shud be able to install MSDE in the clients machine and create the schema and transfer the data from thier db to our .mdf(MSDE DB-Free SQL server version) db.
Can the above be achecived thru installshield.I have install shield xpress 2.1.
I even have the .SQL script files to create the schema.
Can anyone guide me the best approach to proceed with this.
Very urgent
Thanks

View 1 Replies View Related

Msde

Jan 24, 2005

Hi Yar,

This might seem like a silly question but please bare with a newbie. I've discovered a few MSDE installations around the place, & most are on a RTM version. I know no -one else cares about them as they came with small apps. But I would like someone to confirm or deny that they are just as vunerable as any other SQL installation i.e. std edition & should apply the Service Packs ?

Cheers
Suze

View 8 Replies View Related

Msde

Aug 24, 2007

When setting up the MSDE should you be able to connect to it ... from another machine using Sql client tools via enterprise manager....like you would connecting to machines that have sql standard edition

View 4 Replies View Related

MSDE Help

Mar 8, 2004

Hey,

I have produced an asp.net application, and it's time for me to look to installing it at my clients site.

The application uses MS SQL. I have a redistribution license for MSDE 2000. So I have spent all morning ( :-( ) trying to work out how I can distribute it.

I have worked out how to install MSDE, however I can't find any information on:

1. How to connect to the MSDE instance (both for admin and through the asp.net pages).
2. What tools I can use to add/import a database to the MSDE instance.
3. If there is a way to create a distribution package other than using Visual Studio (which I don't have)

I have named the instance WENS, I set the password to XXXXX (not that)

I have worked out how to start the service by opening the service manager. However there are no admin tools provided, and when I use the MS SQL admin tools I can't connect, it doesn't accept the user account
sa, XXXXX

So, basically, any help you can give me would be fantastic, I'm at a loose end, lol.

Thanks a lot for your help.

(Tools I have at my disposal, web matrix, MS SQL Enterprise Edition, MSDE, and I'll download anything that will help (and is legal to use) )

View 2 Replies View Related

MSDE UDF?

Jul 20, 2005

I have scoured the user groups for an answer to this UDF-MSDE questionand see a lot of conflicting info.I am using MSDE Version 7.00.623 to develop an MS Access2K applicationthat is being used with a SQL Server 2000 backend.I need to create some User Defined Functions.Can it be done using MSDE?Can it be done using the MSDE version I have (there doesn't appear tobe an obvious way?Can I create a UDF using by running a stored procedure?Thanks.lq

View 1 Replies View Related

MSDE

Jul 20, 2005

I would appreciate any help, I'm trying to connect a web front-end to anAccess 2000 database using MSDE, and I have it working using Jet but wouldlike to connect the database using MSDE.I would appreciate any advice to where I need to edit the code, the code isas follows:<%@ Language=VBScript %><HTML><HEAD><TITLE>Add New Record</TITLE><%strDBPath=server.MapPath("Employer.mdb")Set Conn = Server.CreateObject("ADODB.Connection")Conn.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & strDBPath & ";"set RS = Server.CreateObject("ADODB.Recordset")Conn.BeginTransRS.Open "Employer",Conn,3,3RS.AddNewRS("Employer ID") = Request("Employer ID")RS("Employer Name") = Request("Employer Name")RS("TitleID") = Request("TitleID")RS("Forename") = Request("Forename")RS("Surname") = Request("Surname")RS("Web Address") = Request("Web Address")RS("Email Address") = Request("Email Address")RS("Date Recorded") = Request("Date Recorded")RS("Employer ClassificationID") = Request("Employer ClassificationID")RS.UpdateConn.CommitTransRS.CloseConn.Close%></HEAD><BODY>Member Registered</BODY></HTML>As mentioned I would be very grateful for any advice.Love,Joanne

View 2 Replies View Related

Msde

Jul 20, 2005

Can MSDE be used on computer in different cities? Say the server in Dallasand the client computer in Houston. Or is the full SQL Server required?

View 1 Replies View Related

MSDE && SQL2000

Jul 13, 2006

I am developing a Crystal Reports App in VS2005 (VB).  I was originally working on an XP machine with MSDE and stored procedures where it worked fine.
I then transferred the development to a Win2003 machine with SQL2000 and am now getting the following error;
 Failed to open a rowset. Description: 'Get_Calls_By_MLO_Date' expects parameter '@DT1' which was not supplied.  Plus some other error detail.
Here is the SP.
CREATE PROCEDURE Get_Calls_By_MLO_By_Date  @DT1 datetime, @DT2 datetimeASSELECT MLO, CallNo, DT, Type FROM ActionsWHERE dt >= @DT1 AND dt <= @DT2 AND ActionID=1 ORDER BY MLO, DTGO
If I transfer everything back to the XP machine it works fine.
Any ideas?
Thanks
Terry.

View 3 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved