Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
SQL Server 7.0 Compatibility Level Error
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Client/serveur
Divers
Thread ID:
00226061
Message ID:
00226424
Vues:
29
I showed your suggestion to my system's adminitrator. He changed a couple properties and now it works. Thanks for your help.

>Mike,
>
>My guess is that the Upsizing Wizard tries to change the database's compatibility level to 65 (for SQL Server 6.5 compatibility). You probably don't have permission to do this. Ask your system admin to do it for you. If he or she doesn't know how, tell him or her to use the sp_dbcmptlevel stored procedure.
>
>>I have designed and tested a VFP 6.0 application prototype using local views. Just for my own learning experience I wanted to upsize the project to SQL Server. My system's administrator imported the VFP database to the server using SQL Server 7.0. We created a connection to the database and tested the connection. I tried to run the Upsizing Wizard and got to Step 5 - Select Target Database. Since the database was already there the Wizard identified it and "Existing" was checked. When I click Next, a message box pops up which reads, "The Upsizing Wizard could not set the SQL Server 7.0 database to proper compatibility level for upsizing.” The only option I am given is to click on Ok.
>>
>>Any ideas and suggestions would be greatly appreciated.
>>
>>Thanks,
Mike Coop
MIU - Data Analyst III
Kemper a Unitrin Business
(904) 245-5949
mcoop@eKemper.com
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform