Using MSDE 2000 SP3
Sql Server 2000 SP3
Win XP Pro SP1
Microsoft.Jet.OLEDB.4.0
We have recently upgraded field laptops from Windows 2000 to XP Pro. One of our applications which was developed with Visual C++ 6.0 and using MSDE will just drop it's connection to our consolidated Sql Server 2000. This works on Windows 2000 machines.
I have ran the profiler, monitored Sql Processes for locks, checked Event logs and I am unable to find any type of error. Our sync process just drops off. I am uncertain if it is MSDE, Sql Server or XP.
I even set the application's compatiability settings to Windows 2000 but still same result. I am uncertain as to how to do anymore troubleshooting.
Any ideas would be much appreciated.
Thanks,
Vannie Keever
SQL Server (including the MSDE edition) cannot close a connection by itself
except when shutting down. The client, the OS, or the network has to tell
SQL Server to drop the connection. Try a netmon trace to get more details.
Cindy Gross, MCDBA, MCSE
http://cindygross.tripod.com
This posting is provided "AS IS" with no warranties, and confers no rights.
sql
Showing posts with label field. Show all posts
Showing posts with label field. Show all posts
Friday, March 30, 2012
Monday, March 19, 2012
MSDE max field size?
Hi,
I have MSDE installed on my computer and I'm usingWeb Data Administrator to manage my databses. The problem is that whenever I add a column with a length of more than 8000, I get the following error:
Length must be between 0 and 8000
If I create the column programmatically then i get this error:
The following error occured while executing the query:
Server: Msg 131, Level 15, State 2, Line 2
The size (8005) given to the column 'Article' exceeds the maximum allowed for any data type (8000).
I need several columns that can hold around32,000 characters. What's the deal? Is this a limit with MSDE, or am Imissing something?
Thanks![Smile [:)]](https://lh3.googleusercontent.com/blogger_img_proxy/AEn0k_tPIcxhqDoHmw3rRolaucVhfeHFVsI8YYTfmaHq1xaKonAIfH_d-BvDdZlrwb8JTefpsFQU4yGvBgdWM-MiySPP7ZTBfU1oxVymgpktygTc0jdVpkg8KA=s0-d)
Thanks![Yes [Y]](https://lh3.googleusercontent.com/blogger_img_proxy/AEn0k_tiyjwAE408B772d1yo5PEr0WJmHqNBLg3QGA9-ZekKQINpP3SYIEVg3lLRzqs6YrLeziV4lq1r1V1tUqkor_ZI5NbUCFcZGq84YH6lm7_0RDwaG29MFMg=s0-d)
|||That would be text (or ntext if you need to support international characters).
|||I'm sorry, but I should have asked this in my previous post...
What length should I specify?
Like... text(16), or text(32)?
Am I correct in assuming that (16) would give me 32768 characters?
Thanx
|||
I wouldn't specify a length at all -- it is not needed for the text data type.
As suggested, Books Online and MSDN are excellent references and youcould easily find this information yourself. According tontext, text, and image the text data type can store 2,147,483,647 characters.
|||
|||Try using OLE(Object Linking and Embedding) in Access to store them asWord and import them into MSDE as image files and most of your problemswill go away. Hope this helps.
Kind regards,
Gift Peddie
I have MSDE installed on my computer and I'm usingWeb Data Administrator to manage my databses. The problem is that whenever I add a column with a length of more than 8000, I get the following error:
Length must be between 0 and 8000
If I create the column programmatically then i get this error:
The following error occured while executing the query:
Server: Msg 131, Level 15, State 2, Line 2
The size (8005) given to the column 'Article' exceeds the maximum allowed for any data type (8000).
I need several columns that can hold around32,000 characters. What's the deal? Is this a limit with MSDE, or am Imissing something?
Thanks
::Is this a limit with MSDE, or am I missing something?
Yoou miss reading the documentation.
ROWS in SQL Server - not just MSDE - are limited to 8000 bytes. This means the whole row, not a single field.
For longer data there are special datatypes (like text or ntext) that do not store the data in the row, but use separate tables. They are limited (no indexing and some other limitations).They work wonderfully with up to 2gb per field.
This is properly documented in the documentation for SQL Server, which I suggest you ahve a look at. It is also available online at Microsoft.
The documentation to which thona is referring (but for which he never provides a link) is calledSQL Server 2000 Books Online. It is a free reference from Microsoft and is one which I personally refer to many times a day. It is a large download but well worth the time.
The same content is available at the MSDN site:Getting Started with SQL Server Books Online.
|||What Sql Server datatype would give me the equivalent of the "Memo" type in Access?
Thanks
|||That would be text (or ntext if you need to support international characters).
|||I'm sorry, but I should have asked this in my previous post...
What length should I specify?
Like... text(16), or text(32)?
Am I correct in assuming that (16) would give me 32768 characters?
Thanx
|||
stevesimon wrote:
I'm sorry, but I should have asked this in my previous post...
What length should I specify?
Like... text(16), or text(32)?
Am I correct in assuming that (16) would give me 32768 characters?
Thanx
I wouldn't specify a length at all -- it is not needed for the text data type.
As suggested, Books Online and MSDN are excellent references and youcould easily find this information yourself. According tontext, text, and image the text data type can store 2,147,483,647 characters.
|||
Just a qwuestion -why are you so reluctant to even LOOK into the online documentation ONCE?
Btw, tehe equivalent of Access "Memo" is NOT text - it is ntext. Access has no notion of non-unicode strings.
|||I did look at the documentation, but could not find the answer to my specific question.|||Try using OLE(Object Linking and Embedding) in Access to store them asWord and import them into MSDE as image files and most of your problemswill go away. Hope this helps.
Kind regards,
Gift Peddie
Friday, March 9, 2012
MSDE Installation Failures
We have a custom client/server application that runs against MSDE. This
application is distributed to the field through a Setup CD. We used the
Installshield to create the setup program. Most of the times when the user
tries to install the application it fails after MSDE install saying that
"Your SQL Server is either corrupt or has been tampered with.". We try to
install a named instance. I haven't been able to find a solution to this
persistent and annoying problem. Most of my users use xp sp2 os.
Sometimes i have noticed that there is already a default instance of MSDE on
their laptops that came with some other application or the laptop itself. If
I remove that installation and then re-run our installation process it goes
smoothly.
Any help is appreciated.
Thanks
Maan
hi Maan,
Maan Thakur wrote:
> We have a custom client/server application that runs against MSDE.
> This application is distributed to the field through a Setup CD. We
> used the Installshield to create the setup program. Most of the times
> when the user tries to install the application it fails after MSDE
> install saying that "Your SQL Server is either corrupt or has been
> tampered with.". We try to install a named instance. I haven't been
> able to find a solution to this persistent and annoying problem. Most
> of my users use xp sp2 os.
> Sometimes i have noticed that there is already a default instance of
> MSDE on their laptops that came with some other application or the
> laptop itself. If I remove that installation and then re-run our
> installation process it goes smoothly.
> Any help is appreciated.
> Thanks
> Maan
you usually get this kind of exception when machine name has been changed,
like reported in
http://www.karaszi.com/sqlserver/inf...erver_name.asp
do you perform some "strange" operation at MSDE install time?
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.10.0 - DbaMgr ver 0.56.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||Nothing "Strange". We actually use the installation package provided by
microsoft and ship it with our CD and it is called from inside of the
installation program.
"Andrea Montanari" wrote:
> hi Maan,
> Maan Thakur wrote:
> you usually get this kind of exception when machine name has been changed,
> like reported in
> http://www.karaszi.com/sqlserver/inf...erver_name.asp
> do you perform some "strange" operation at MSDE install time?
> --
> Andrea Montanari (Microsoft MVP - SQL Server)
> http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
> DbaMgr2k ver 0.10.0 - DbaMgr ver 0.56.0
> (my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
> interface)
> -- remove DMO to reply
>
>
application is distributed to the field through a Setup CD. We used the
Installshield to create the setup program. Most of the times when the user
tries to install the application it fails after MSDE install saying that
"Your SQL Server is either corrupt or has been tampered with.". We try to
install a named instance. I haven't been able to find a solution to this
persistent and annoying problem. Most of my users use xp sp2 os.
Sometimes i have noticed that there is already a default instance of MSDE on
their laptops that came with some other application or the laptop itself. If
I remove that installation and then re-run our installation process it goes
smoothly.
Any help is appreciated.
Thanks
Maan
hi Maan,
Maan Thakur wrote:
> We have a custom client/server application that runs against MSDE.
> This application is distributed to the field through a Setup CD. We
> used the Installshield to create the setup program. Most of the times
> when the user tries to install the application it fails after MSDE
> install saying that "Your SQL Server is either corrupt or has been
> tampered with.". We try to install a named instance. I haven't been
> able to find a solution to this persistent and annoying problem. Most
> of my users use xp sp2 os.
> Sometimes i have noticed that there is already a default instance of
> MSDE on their laptops that came with some other application or the
> laptop itself. If I remove that installation and then re-run our
> installation process it goes smoothly.
> Any help is appreciated.
> Thanks
> Maan
you usually get this kind of exception when machine name has been changed,
like reported in
http://www.karaszi.com/sqlserver/inf...erver_name.asp
do you perform some "strange" operation at MSDE install time?
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.10.0 - DbaMgr ver 0.56.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||Nothing "Strange". We actually use the installation package provided by
microsoft and ship it with our CD and it is called from inside of the
installation program.
"Andrea Montanari" wrote:
> hi Maan,
> Maan Thakur wrote:
> you usually get this kind of exception when machine name has been changed,
> like reported in
> http://www.karaszi.com/sqlserver/inf...erver_name.asp
> do you perform some "strange" operation at MSDE install time?
> --
> Andrea Montanari (Microsoft MVP - SQL Server)
> http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
> DbaMgr2k ver 0.10.0 - DbaMgr ver 0.56.0
> (my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
> interface)
> -- remove DMO to reply
>
>
Monday, February 20, 2012
MSDE exchange
hi there,
How do i have a server side code/software that will connect all the field of
my exchange server to a MSDE database? i need custom fields and all address
fields? i need it to be a link if pos?
dorling
In message <46D35AD2-0C3E-47E9-9755-443F87EA5BF2@.microsoft.com>, dorling
<dorling@.discussions.microsoft.com> writes
>hi there,
>How do i have a server side code/software that will connect all the field of
>my exchange server to a MSDE database? i need custom fields and all address
>fields? i need it to be a link if pos?
>dorling
One simple answer is to use Forms in the Public Folders. Using Outlook
you can design and Publish these forms using templates and adding your
own custom fields as you go. You don't need MSDE or any other database
for that matter.
If you really need to hook Exchange into a backend database like MSDE
then the next real step would be to right your own plugin / extension
for Outlook. This would enable you to tie the two together but requires
learning more than T-SQL.
Andrew D. Newbould E-Mail: newsgroups@.NOSPAMzadsoft.com
ZAD Software Systems Web : www.zadsoft.com
|||hi there,
thanks for that, is there some code/software or a web site that i could use
to help me, hook Exchange into a backend database like MSDE? i want the data
to be live/link not copy if possible in to the Database?
Jonathan
"Andrew D. Newbould" wrote:
> In message <46D35AD2-0C3E-47E9-9755-443F87EA5BF2@.microsoft.com>, dorling
> <dorling@.discussions.microsoft.com> writes
> One simple answer is to use Forms in the Public Folders. Using Outlook
> you can design and Publish these forms using templates and adding your
> own custom fields as you go. You don't need MSDE or any other database
> for that matter.
> If you really need to hook Exchange into a backend database like MSDE
> then the next real step would be to right your own plugin / extension
> for Outlook. This would enable you to tie the two together but requires
> learning more than T-SQL.
> --
> Andrew D. Newbould E-Mail: newsgroups@.NOSPAMzadsoft.com
> ZAD Software Systems Web : www.zadsoft.com
>
|||It depends on the programming language you want to use. However, try
these sites out for starters as they cover more than one programming
language:
Planet Source Code - http://www.pscode.com
Developers Dex - http://www.codecomments.com
Developer Fusion - http://www.developerfusion.com
The Code Project - http://www.codeproject.com
Source Forge - http://www.sourceforge.net
Kind Regards,
Andrew.
In message <65FEA908-558A-4B05-8ACF-93EA81C5D17D@.microsoft.com>, dorling
<dorling@.discussions.microsoft.com> writes[vbcol=seagreen]
>hi there,
>thanks for that, is there some code/software or a web site that i could use
>to help me, hook Exchange into a backend database like MSDE? i want the data
>to be live/link not copy if possible in to the Database?
>Jonathan
>"Andrew D. Newbould" wrote:
Andrew D. Newbould E-Mail: newsgroups@.NOSPAMzadsoft.com
ZAD Software Systems Web : www.zadsoft.com
|||hi there,
I am going to be builting this apps in VB6!!
Jonathan
"Andrew D. Newbould" wrote:
> It depends on the programming language you want to use. However, try
> these sites out for starters as they cover more than one programming
> language:
> Planet Source Code - http://www.pscode.com
> Developers Dex - http://www.codecomments.com
> Developer Fusion - http://www.developerfusion.com
> The Code Project - http://www.codeproject.com
> Source Forge - http://www.sourceforge.net
> Kind Regards,
> Andrew.
>
> In message <65FEA908-558A-4B05-8ACF-93EA81C5D17D@.microsoft.com>, dorling
> <dorling@.discussions.microsoft.com> writes
> --
> Andrew D. Newbould E-Mail: newsgroups@.NOSPAMzadsoft.com
> ZAD Software Systems Web : www.zadsoft.com
>
|||Then also check out these other good sites:
VB Net - http://vbnet.mvps.org
VB City - http://www.vbcity.com
VB IP - http://www.vbip.com
Kind Regards,
Andrew
In message <D1A6DB20-A3B8-4A77-ADEA-3A423B54D664@.microsoft.com>, dorling
<dorling@.discussions.microsoft.com> writes[vbcol=seagreen]
>hi there,
>I am going to be builting this apps in VB6!!
>Jonathan
>"Andrew D. Newbould" wrote:
<Snip>
Andrew D. Newbould E-Mail: newsgroups@.NOSPAMzadsoft.com
ZAD Software Systems Web : www.zadsoft.com
How do i have a server side code/software that will connect all the field of
my exchange server to a MSDE database? i need custom fields and all address
fields? i need it to be a link if pos?
dorling
In message <46D35AD2-0C3E-47E9-9755-443F87EA5BF2@.microsoft.com>, dorling
<dorling@.discussions.microsoft.com> writes
>hi there,
>How do i have a server side code/software that will connect all the field of
>my exchange server to a MSDE database? i need custom fields and all address
>fields? i need it to be a link if pos?
>dorling
One simple answer is to use Forms in the Public Folders. Using Outlook
you can design and Publish these forms using templates and adding your
own custom fields as you go. You don't need MSDE or any other database
for that matter.
If you really need to hook Exchange into a backend database like MSDE
then the next real step would be to right your own plugin / extension
for Outlook. This would enable you to tie the two together but requires
learning more than T-SQL.
Andrew D. Newbould E-Mail: newsgroups@.NOSPAMzadsoft.com
ZAD Software Systems Web : www.zadsoft.com
|||hi there,
thanks for that, is there some code/software or a web site that i could use
to help me, hook Exchange into a backend database like MSDE? i want the data
to be live/link not copy if possible in to the Database?
Jonathan
"Andrew D. Newbould" wrote:
> In message <46D35AD2-0C3E-47E9-9755-443F87EA5BF2@.microsoft.com>, dorling
> <dorling@.discussions.microsoft.com> writes
> One simple answer is to use Forms in the Public Folders. Using Outlook
> you can design and Publish these forms using templates and adding your
> own custom fields as you go. You don't need MSDE or any other database
> for that matter.
> If you really need to hook Exchange into a backend database like MSDE
> then the next real step would be to right your own plugin / extension
> for Outlook. This would enable you to tie the two together but requires
> learning more than T-SQL.
> --
> Andrew D. Newbould E-Mail: newsgroups@.NOSPAMzadsoft.com
> ZAD Software Systems Web : www.zadsoft.com
>
|||It depends on the programming language you want to use. However, try
these sites out for starters as they cover more than one programming
language:
Planet Source Code - http://www.pscode.com
Developers Dex - http://www.codecomments.com
Developer Fusion - http://www.developerfusion.com
The Code Project - http://www.codeproject.com
Source Forge - http://www.sourceforge.net
Kind Regards,
Andrew.
In message <65FEA908-558A-4B05-8ACF-93EA81C5D17D@.microsoft.com>, dorling
<dorling@.discussions.microsoft.com> writes[vbcol=seagreen]
>hi there,
>thanks for that, is there some code/software or a web site that i could use
>to help me, hook Exchange into a backend database like MSDE? i want the data
>to be live/link not copy if possible in to the Database?
>Jonathan
>"Andrew D. Newbould" wrote:
Andrew D. Newbould E-Mail: newsgroups@.NOSPAMzadsoft.com
ZAD Software Systems Web : www.zadsoft.com
|||hi there,
I am going to be builting this apps in VB6!!
Jonathan
"Andrew D. Newbould" wrote:
> It depends on the programming language you want to use. However, try
> these sites out for starters as they cover more than one programming
> language:
> Planet Source Code - http://www.pscode.com
> Developers Dex - http://www.codecomments.com
> Developer Fusion - http://www.developerfusion.com
> The Code Project - http://www.codeproject.com
> Source Forge - http://www.sourceforge.net
> Kind Regards,
> Andrew.
>
> In message <65FEA908-558A-4B05-8ACF-93EA81C5D17D@.microsoft.com>, dorling
> <dorling@.discussions.microsoft.com> writes
> --
> Andrew D. Newbould E-Mail: newsgroups@.NOSPAMzadsoft.com
> ZAD Software Systems Web : www.zadsoft.com
>
|||Then also check out these other good sites:
VB Net - http://vbnet.mvps.org
VB City - http://www.vbcity.com
VB IP - http://www.vbip.com
Kind Regards,
Andrew
In message <D1A6DB20-A3B8-4A77-ADEA-3A423B54D664@.microsoft.com>, dorling
<dorling@.discussions.microsoft.com> writes[vbcol=seagreen]
>hi there,
>I am going to be builting this apps in VB6!!
>Jonathan
>"Andrew D. Newbould" wrote:
<Snip>
Andrew D. Newbould E-Mail: newsgroups@.NOSPAMzadsoft.com
ZAD Software Systems Web : www.zadsoft.com
Subscribe to:
Posts (Atom)