Delete your system DSN, and create it the way I described in my post from August 28, 2010. It definitely DOES matter what your logon credentials are.
Going into the details of how the Lytec database is structured is really beyond the help I can offer in this forum.
Do you have any experience...
Again, I have limited SQL Server knowledge.
You're not likely to interfere with the office usage by developing and running Crystal Reports unless you are manipulating and/or sorting huge amounts of data, especially if Crystal is installed on your PC and not the server where Lytec resides...
My actual SQL Service knowledge is limited to interacting with the Lytec database, so I am not likely to be of much help. I would presume you would have to have the exact same version of the MSDE installed on the machine you're working on. Is there some reason you're making this so hard by not...
Although the Lytec billing program itself does not need to be running to access the database via an ODBC connection, the Lytec SQL Server instance must be running.
Depending on the version of Lytec, it may be bundled with the runtime environment of SQL Server 2000 or 2005.
I've been doing this for years with many versions of Lytec and Crystal Reports.
Create a System DSN. The server name will be something like \\SERVER\LYTEC_SQL, depending upon your installation type and version. Use SQL authentication, not Windows. The Login ID is "admin". The password for...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.