field is limited to something like 1024 letters

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

SQL Server Development (2000)

field is limited to something like 1024 letters

Author

Topic

minimotorsport
Starting Member

13 Posts

Posted - 2002-04-09 : 15:10:24

I have a problem with my SQL Server 7 (SP 3). I can not store big text in varchar (8000) or text fields. What ever I do I can not put more that around 1024 letters in there.
Whats wrong ?

yours faithfully

Michael

setbasedisthetruepath
Used SQL Salesman

992 Posts

Posted - 2002-04-09 : 15:59:17

help us out a little ... what exactly happens when you try? do you get an error? what error? ...

setBasedIsTheTruepath
<O>

minimotorsport
Starting Member

13 Posts

Posted - 2002-04-09 : 16:16:51

Im using the Enterprise Manager and open the tabel. If I try to copy a text using the windows copy function nothing happens (nothing is inserted into the field) . If I manualy typ the text (ksgfkjgkfglkjfgkfgkf....) after approx. 1024 characters a beep comes up and I can not type more characters.

yours faithfully

Michael

setbasedisthetruepath
Used SQL Salesman

992 Posts

Posted - 2002-04-09 : 16:21:24

Then don't use EM ... use Query Analyzer

quote:

Im using the Enterprise Manager and open the tabel. If I try to copy a text using the windows copy function nothing happens (nothing is inserted into the field) . If I manualy typ the text (ksgfkjgkfglkjfgkfgkf....) after approx. 1024 characters a beep comes up and I can not type more characters.

yours faithfully

Michael

setBasedIsTheTruepath
<O>

robvolk
Most Valuable Yak

15732 Posts

Posted - 2002-04-09 : 16:22:26

You really shouldn't use Enterprise Manager for data entry. You are far better off using MS Access and linking the SQL Server table into the Access database. EM is not meant for heavy-duty data entry, and there are numerous limitations to what it can do (such as what you're experiencing now)

minimotorsport
Starting Member

13 Posts

Posted - 2002-04-09 : 16:24:29

so its a EM bug ?

How to use QA to typ text into a database ?

yours faithfully

Michael

minimotorsport
Starting Member

13 Posts

Posted - 2002-04-09 : 16:31:50

quote:

You really shouldn't use Enterprise Manager for data entry. You are far better off using MS Access and linking the SQL Server table into the Access database. EM is not meant for heavy-duty data entry, and there are numerous limitations to what it can do (such as what you're experiencing now)

How do I link the SQL Server table into the Access database ?

yours faithfully

Michael

robvolk
Most Valuable Yak

15732 Posts

Posted - 2002-04-09 : 16:53:32

Create an Access database. Either click the "New" table button, or choose the File:Get External Data menu option. You want to Link to a data source.

When the Link window opens, at the very bottom is a drop-down called "Files of Type". The very last option should be "ODBC Data Sources" or something similar. Choose that option.

The ODBC data source window will open. Since you probably haven't created a Data Source Name (DSN) yet, click the New button.

You'll see a list of ODBC data drivers. Choose the SQL Server driver (should be very last driver). Click Next, and enter a name for your DSN. Click Next or Finish.

The next step will allow you to choose which SQL Server you want to connect to. Choose the server from the list, or type the name or IP address of the server in the box. Click Next.

The next step will ask how you wish to login to the server. If you are using Windows NT logins, check that box, otherwise check the SQL authentication box and enter an appropriate SQL login and password. Click Next.

You will next be asked to select a default database. You should choose the database you want to connect to (if you need to connect to several different databases, create different DSNs for each one) Click Next until you reach the last screen, then click Finish.

You should Test Data Source to make sure the connection works. If it is successful, click OK, and you'll go back to the ODBC sources. Choose the DSN you just created and click OK.

The DSN will connect to the server and list the tables and views available in that database. Select each table you want to link. Unless security is a concern, check the "Save Password" checkbox, then click OK. You'll see all of the SQL tables now, with globe icons next to them. You can open these tables up and edit them as if they were regular Access tables.

You MUST have a primary key on your SQL tables in order to edit them. If you don't, Access will prompt you to select the column(s) that make up the primary key. I recommend against this. You should alter your table and add a primary key to it, then re-link it into Access.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources