>>>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.
>>
>>
>>If you installed EXPRESS edition just clicking NEXT button, then it creates an INSTANCE of the SQL Server names SQLEXPRESS (if I remember correctly).
>
>Thank you, Borislav. Are you saying that the reason I am getting access problem is because the name of the server is incorrect?
No, I didn't said that.
I just said that if you attached your DBs in SQL Express that is installed as in instance (default SQLXPRESS) tnen you can't connect to your DB.
When you run SSMS what you see?
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.