helloraza
asked on
how to connect crystal reports 8.5 with SQL server 2005 express through vb 6.0
hi
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;Integr ated Security=SSPI;" & _
"Persist Security Info=False;" & _
"AttachDBFileName=C:\Progr am Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\ Inventory. mdf;Data Source=USER-7FA6DB9CA9\SQL EXPRESS"
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.???
also
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.
raza
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;Integr
"Persist Security Info=False;" & _
"AttachDBFileName=C:\Progr
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.???
also
i am using crystal reports 8.5, and was using following connection string to connect with ms access 2003.
Report.Database.Tables(1).
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.
raza
ASKER
thanks mlmcc
i worked for Crystal reports, but there is a little problem still exist.
when i try to "verify database" it says that some changes in database has been occured and need to updat.
then "Map Field" dialog box appears and ask to map a field named as "NAME". but on canditate database field list there is no such field appears.
even this field exists in database.
actually report source is a view and this fied "NAME" is a result of concatination of three fields from a table.
so i cannot map it with any field, because it is not being shown in candidate database fields available to be maped.
what should i do now?
thanks.
raza
i worked for Crystal reports, but there is a little problem still exist.
when i try to "verify database" it says that some changes in database has been occured and need to updat.
then "Map Field" dialog box appears and ask to map a field named as "NAME". but on canditate database field list there is no such field appears.
even this field exists in database.
actually report source is a view and this fied "NAME" is a result of concatination of three fields from a table.
so i cannot map it with any field, because it is not being shown in candidate database fields available to be maped.
what should i do now?
thanks.
raza
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
thanks brother
After changing the database driver you can do it in a similar manner.
mlmcc