Database Name with dot(.) in it

[pgthyagu]

I have a database with name IE2.4 on SQL 7.0.
When i try to run Import/Export wizard on a table on this db, i get the following message :

Error MSG : Error Source Microsoft OLE DB provider For SQL Server
Error Description : Unspecified Error
Could not find server IE2 in sysservers. Execute sp_addlinkedserver to add the server to sysservers.
Context : Error Calling GetRowset to get DBSchema_tables schema info. Your provideer does not support all the schema rowset required by DTS.

Is there any workaround or setting i can do so that import/export works fine with this db.

 

[tlbroadbent]

Try enclosing the database name in brackets [IE2.4]. You should avoid using periods in server, table and object names. SQL Server uses the period as a delmiter for names. When you attempt to use the name IE2.4, SQL will interpret that as server name = IE2 and database name = 4. Terry L. Broadbent - DBA
Computing Links:

http://tlbroadbent.home.attbi.com/prog.htm

faq183-874 contains "Suggestions for Getting Quick and Appropriate Answers" to your questions.

 

[thyagu]

Thanks for the quick reply.

Though u have given a valid apoint, how is it that i can give the database name on the Import/Export Wizard, it list the database and u need to choose from it.

Thee how do i enclose it with in [] ?