#1
  1. No Profile Picture
    Junior Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    Aug 2003
    Posts
    1
    Rep Power
    0

    Renaming Database


    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:

    Code:
    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.
    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..?

    Thanks in advance,
    Fernan
  2. #2
  3. No Profile Picture
    Average Intelligence
    Devshed Novice (500 - 999 posts)

    Join Date
    Apr 2003
    Location
    Ohio/Chicago
    Posts
    678
    Rep Power
    12
    The period is used as a component separator in SQL server object naming, the full form of which is :

    servername.databasename.ownername.objectname

    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:

    [mydatabase].ownername.objectname

    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)

IMN logo majestic logo threadwatch logo seochat tools logo