DMO, VFP and SQL 2005

I have an application writing in VFP that is used to manage some database
processes, some of these processes are currently writing in DMO. We are in
the process of upgrading to sql 2005 and I’m running into some trouble. I
m
currently changing some of the process to t-sql statements but I have an
issue where I think I need to use DMO. I’ve installed the backwards
compatible objects but I can not seem to connect via DMO. I have a default
instance of sql 2000, a named instance 2000 and a named instance of 2005
running on laptop running XP Tablet edition.
Code
ox= CREATEOBJECT("SQLDMO.sqlServer")
?ox.Connect("MA-ENG-PCANINO2\sql2005","sa", "SASA")
Executing that returns this error.
OLE IDispatch exception code 55555 from Microsoft SQL-DMO (ODBC SQLState:
42000): [Microsoft][ODBC SQL Server Driver][SQL Server]To connect to this
server you must use SQL Server Management Studio or SQL Server Management
Objects (SMO)...
Thank you in advance.
Pauly CIt’s working now, I read in another post to unregistered and reregister th
e
SQLDMO.dll - \\Program Files\Microsoft SQL Server\80\Tools\Binn\SQLDMO.dll.
I did just that and now I’m able to successfully connect to SQL 2005 via D
MO.
YIPPEE
"Pauly C" wrote:

> I have an application writing in VFP that is used to manage some database
> processes, some of these processes are currently writing in DMO. We are i
n
> the process of upgrading to sql 2005 and I’m running into some trouble.
I’m
> currently changing some of the process to t-sql statements but I have an
> issue where I think I need to use DMO. I’ve installed the backwards
> compatible objects but I can not seem to connect via DMO. I have a defaul
t
> instance of sql 2000, a named instance 2000 and a named instance of 2005
> running on laptop running XP Tablet edition.
> Code
> ox= CREATEOBJECT("SQLDMO.sqlServer")
> ?ox.Connect("MA-ENG-PCANINO2\sql2005","sa", "SASA")
> Executing that returns this error.
> OLE IDispatch exception code 55555 from Microsoft SQL-DMO (ODBC SQLState:
> 42000): [Microsoft][ODBC SQL Server Driver][SQL Server]To connect to this
> server you must use SQL Server Management Studio or SQL Server Management
> Objects (SMO)...
> Thank you in advance.
> Pauly C
>