Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
MSDE - How to attach to a database using SQLDMO
Message
General information
Forum:
Visual FoxPro
Category:
Client/server
Title:
MSDE - How to attach to a database using SQLDMO
Miscellaneous
Thread ID:
00251681
Message ID:
00251681
Views:
65
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
Map
View

Click here to load this message in the networking platform