December 27, 2004 at 9:47 am
I'm upgrading an Access DB to SQL Server via DTS using a hosted SQL Server.
Often, the tables that I send don't work right and don't even get copied without major error. I haven't figured this out yet.
But, the problem I'm having now is that the tables I recently upgraded via DTS are impossible to open and pull records via Enterprise Manager.
In EM, I'm able to open and save a table in the 'design table' process. But, it won't let me open it up to pull all the records. I can re-transfer the data with no problem and the site can open the data that's in there, and I can open up other tables that are in the DB with no problems. I know there are rows in those tables because I exported them back into a new Access DB.
In EM, when I try to open one of these newly transfered tables, I get this error:
[MS Design Tools] - ODBC error: [Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionRead (recv()).
[Microsoft][ODBC SQL Server Driver][DBNETLIB]General network error. Check your network documentation.
Then I click okay and it tells me I lost my connection to the database and asks if I want to reconnect.
My host has said they are certain it's not a SQL Server problem, not a webserver problem, and that it probably has to do with the EM software.
What's going on here? I've done a search on MS's support site and found nothing I thought was related.
December 27, 2004 at 10:55 am
Strange. Can you upgrade the Access db locally and then transfer the data to the server?
December 27, 2004 at 11:01 am
No. I can't do that either. I get the following DBNETLIB error when I try:
[DBNETLIB][ConnectionOpen(Connect()).]Specified SQL Server not found.
I know I typed in the correct db because it tests correctly.
Any ideas?
December 31, 2004 at 12:17 am
If you have a firewall or XP SP2, try disabling while using DTS.
Paul Edrupt
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply