Click to See Complete Forum and Search --> : Problems with SQLDMO


joecre
February 21st, 2003, 03:14 AM
I have a problem with SQLDMO, in my MFC Application I use DMO to restore/backup a SQL DB; when I specify a path that contains blank spaces DMO fail to perform the operation because the resulting path is a merge from my path and the default one.
i.e. mypath = "D:\My Folder" resulting path =" C:\ProgramFiles\Microsoft SQL Server\.......\My Folder"
Can anyone suggest me any possible solutions ?
Thank you all!!!!

antares686
February 21st, 2003, 06:25 AM
Please post you code example. Also if you are using the .RelocateFiles proterty of the SQLRestore method are you putting [] around the path data as required. Keep in mind this is a multipart string and requires the []'s.

joecre
February 21st, 2003, 08:50 AM
Thank you antares686.
With your help I resolve the problem.
Thank you again