>Hi,
>
>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.

Hi Dmitry,

You need to give the name like this connectionString="Data Source=ServerName\SQLEXPRESS;Initial Catalog=DatabaseName

You can find the name of the server by running select @@SERVERNAME