August 25th, 2003, 01:26 PM
I got an MSSQL database which I'm trying to export to MySQL using DTS, the name of the database is MyDatabase.com and when I try to export the tables I get the following error:
My guess is that since the database name ends with .com DTS is thinking that it's a server and not a db...... I got 2 databases that end with .com and a few others that don't, if I try to export any of the ones that end with .com I get the same error, but if I try to export another one it works just fine.... My question is, is there any way I can rename the database to something else or is there any other way around this problem..?
Error Source: Microsoft OLE DB Provider for SQL Server
Error Description: Unspecified error
Could not find server 'MyDatabase.com' in sysservers. Execute sp_addlinkedserver to add the server to sysservers.
Context: Error calling GetRowset to get DBSCHEMA_TABLES schema info. Your provider does not support all the schema required by DTS.
Thanks in advance,
August 26th, 2003, 12:31 AM
The period is used as a component separator in SQL server object naming, the full form of which is :
because of the period in the databasename, it interpreted the first part of the name as servername and the second part of the name as databasename. You may have been able to get around this by enclosing the entire databasename in square brackets as:
However, I am not sure whether even the brackets will override the period separator although they do work for other disallowed characters (such as spaces)