Snitz Forums 2000
Snitz Forums 2000
Home | Profile | Register | Active Topics | Members | Search | FAQ
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 Community Forums
 Code Support: ASP (Non-Forum Related)
 Possible to use DTS and preserve Primary Keys?
 New Topic  Topic Locked
 Printer Friendly
Previous Page
Author Previous Topic Topic Next Topic
Page: of 2

Astralis
Senior Member

USA
1218 Posts

Posted - 27 December 2004 :  13:28:45  Show Profile  Send Astralis a Yahoo! Message
I don't get any errors with QA, the queries running via ASP on those tables on the site work fine, the errors seem to be only on EM and with Upsize Wizard, both DBNETLIB errors.

CT said:

The only thing I can tell you for sure is that the issue isn't comiing
from your Webserver or Sql Server with Crystal Tech. My only suggestion to
you would be to send an email to the Microsoft Support and include the
entire error message. I tried searching their site, and couldn't find this
error. So, you need to submit a support request directly to them for futher
research into this problem. You may want to check their forum as well just
to see if anyone their has seen this problem be for you submit to Microsoft
Support.

Edited by - Astralis on 27 December 2004 13:32:14
Go to Top of Page

Astralis
Senior Member

USA
1218 Posts

Posted - 27 December 2004 :  14:08:28  Show Profile  Send Astralis a Yahoo! Message
I just tried this on a different computer with a different ISP and got the same errors.
Go to Top of Page

Doug G
Support Moderator

USA
6493 Posts

Posted - 27 December 2004 :  17:04:09  Show Profile
You might try using the network client tool and create an alias to the CT server.

I have a DTS job that pulls down my CT db nightly and have had no problems, fwiw.

Use the sql server OLEDB provider for your connections wherever possible.

======
Doug G
======
Computer history and help at www.dougscode.com
Go to Top of Page

Astralis
Senior Member

USA
1218 Posts

Posted - 27 December 2004 :  22:59:59  Show Profile  Send Astralis a Yahoo! Message
UPDATE: The upsizing wizard is now working. I don't have any explanation for it. But, I still can't open in EM two of the tables that I just upsized. I keep getting the DBNETLIB errors.

BTW, I can query the table in EM and in QA, so this something's wrong, somewhere.

I can even open it by "return top xxx" but not "return all rows".

There are only three rows in the table.

Edited by - Astralis on 27 December 2004 23:14:32
Go to Top of Page
Page: of 2 Previous Topic Topic Next Topic  
Previous Page
 New Topic  Topic Locked
 Printer Friendly
Jump To:
Snitz Forums 2000 © 2000-2021 Snitz™ Communications Go To Top Of Page
This page was generated in 0.16 seconds. Powered By: Snitz Forums 2000 Version 3.4.07