Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. Guest091123

    CR v9 or CR 2008 Connecting to Lytec 2010 database

    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...
  2. Guest091123

    CR v9 or CR 2008 Connecting to Lytec 2010 database

    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...
  3. Guest091123

    CR v9 or CR 2008 Connecting to Lytec 2010 database

    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...
  4. Guest091123

    CR v9 or CR 2008 Connecting to Lytec 2010 database

    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.
  5. Guest091123

    CR v9 or CR 2008 Connecting to Lytec 2010 database

    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...

Part and Inventory Search

Back
Top