Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Connection string for SQL Server Express
Message
 
 
À
15/05/2010 15:35:26
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Autre
Versions des environnements
SQL Server:
SQL Server 2005
Divers
Thread ID:
01464715
Message ID:
01464730
Vues:
39
Are you sure you have 32-bit ODBC 'SQL Server Driver' on the PC? It's SQL 2000 driver.

>Thank you. Then it must be that I am using it on Win 7 64.
>
>>No, there's no difference in connection string between different SQL Server editions.
>>
>>>
>>>Do I need to change anything in the connecting string when accessing database on SQLEXPRESS? I have moved a database from PC running SQL Server 2005 Devel Edition to the same version of SQL Server but EXPRESS edition. I use the following connecting string:
>>>
>>>
>>>nConnect = SQLSTRINGCONNECT([DRIVER=SQL Server;SERVER=(local);DATABASE=MyDbName;Trusted_Connection=Yes])
>>>
>>>
>>>But I get error on the PC with SQL Server Express. One of the errors is that the database is not accessible. I tried to run VFP 9 as Administrator (in case this is the issue) but still am getting error.
>>>
>>>I would appreciate any help.
--sb--
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform