i was using VB 6.0 and MS access 2003 for my application.
now i have migrated from access 2003 to SQL Server 2005 Express.
the connection string i am using to connect to SQL serever from vb 6.0 is as follows
"Provider=SQLNCLI.1;Integrated Security=SSPI;" & _
"Persist Security Info=False;" & _
"AttachDBFileName=C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\Inventory.mdf;Data Source=USER-7FA6DB9CA9\SQLEXPRESS"
it is working fine, but iwant to know which string i have to use if i want to connect from a client , like if sql server is installed on a windows serever, and different computers want to connect to SQL serever.???
i am using crystal reports 8.5, and was using following connection string to connect with ms access 2003.
Report.Database.Tables(1).Location = \\serverws2\mydb\Inventory.mdb"
i tried same kind of string for SQL server 2005 express, but it gives an error
" Error opening file
file permission error"
so how to connect crystal reports 8.5 to SQL Server express 2005 express now???
thanks and regards.