>>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.
>
>These work for me on Win7-64 (and also SQL server itself is 64 bits version 2008 and 2008 R2):
>
>
lnHandle = SQLStringConnect("Driver={SQL Server Native Client 10.0};server=.\SQLExpress;Trusted_Connection=yes")
>
>PS: Prefer not using ODBC driver but ADO driver. VFP have serious problems with ODBC to new SQL server datatypes.
>Cetin
Thank you, Cetin. Just so that I understand, the SQL Server Native Client driver that you have in your connecting string is ADO driver?
"The creative process is nothing but a series of crises." Isaac Bashevis Singer
"My experience is that as soon as people are old enough to know better, they don't know anything at all." Oscar Wilde
"If a nation values anything more than freedom, it will lose its freedom; and the irony of it is that if it is comfort or money that it values more, it will lose that too." W.Somerset Maugham