Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Oledb connection
Message
De
28/07/2006 09:38:27
Cetin Basoz
Engineerica Inc.
Izmir, Turquie
 
 
À
28/07/2006 09:34:20
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Versions des environnements
Visual FoxPro:
VFP 9 SP1
OS:
Windows XP SP2
Database:
MS SQL Server
Divers
Thread ID:
01141061
Message ID:
01141065
Vues:
17
>Hi!
>
>I have a problem with my connection OLEDB in SQLServer 2000. My connection string is create in runtime and it's work perfectly! I can execute all SQL commands and it works, but when I try to create a database with more than 8 characters the SQL Server doesn't create the database! My connection string is:
>Provider=SQLOLEDB.1;Password=<<>>;<<>>Persist Security Info=<<lcPersistSec>>;User ID=<<>>;Data Source=<<>>
>
>How may I solve this problem? Is there any configuration in OLEDB I forgot to set?
>
>Thanks all!
>
>Ricardo Pôssas

What's the error message returned by SQL server? I can create databases with long names.
PS: Your connection string is unreadable. Include in pre tags to preserve all. Send your create code besides that.
Cetin
Çetin Basöz

The way to Go
Flutter - For mobile, web and desktop.
World's most advanced open source relational database.
.Net for foxheads - Blog (main)
FoxSharp - Blog (mirror)
Welcome to FoxyClasses

LinqPad - C#,VB,F#,SQL,eSQL ... scratchpad
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform