mandardighe
Programmer
i have a s/w developed in vb and SQL using crystal report for my reports[.rpt files].i load the setup using package and deployment of vb on the client node.my reports are made using the mssql server option.
when i load the s/w on a client node which is attached to the server whose name is a name other than the default 'server' say 'win98' my reports do not work.it gives me an error 'cannot open sql server'.however when i load the client network utility on the client node and give alias all reports work fine.
is there any way thru which i can set the client utility at run time or is there any way where in i can pass a string in the form of the server name.
i have different clients having the same s/w but different server names, so i cannot hardcode the server name in the report.give me a solution where in i can pass the server name dynamically.
plz let me know.
when i load the s/w on a client node which is attached to the server whose name is a name other than the default 'server' say 'win98' my reports do not work.it gives me an error 'cannot open sql server'.however when i load the client network utility on the client node and give alias all reports work fine.
is there any way thru which i can set the client utility at run time or is there any way where in i can pass a string in the form of the server name.
i have different clients having the same s/w but different server names, so i cannot hardcode the server name in the report.give me a solution where in i can pass the server name dynamically.
plz let me know.