General information
Title:
MSDE - How to attach to a database using SQLDMO
Our company is attempting to use MSDE. I'm attempting to connect
the database files to SQL7/MSDE via the AttachDBWithSingleFile method
as follows:
x=CreateObject('SQLDMO.SqlServer')
x.Connect()
X.AttachDBWithSingleFile('demodb','C:\msde_demo\NorthwindCS.adp')
I'm not able to attach the file to SQl7/MSDE, regardless of file
type (I've tried the .MDE/.MDB datatypes). Does the file have to be
of type .MDF and if so, how is this file created????
Is there an easy way to create foxpro databases and migrate them
over to MSDE?
Thanks in advance....
Chester West (CWEST@PARITYCORP.COM)
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only