Search results for query: *

@PsychBiller Thank you for taking the time to help. No, I am a COMPLETE noob when it comes to understanding mssql->crystal Why is odbc needed? Doesnt mssql serve up the data? That's how basic i am. As for learning to use crystal, i am struggling.

it seems i figured out the basics. here's what i did: HOW to Restore to MSSQL 1)Start SSMS 2)FILE-> Connect Object Explorer 3)select 'local' with 'Windows authentication' 4)look at object explorer column on the left and right click on 'Databases' 5)select 'Restore' 6)in the dialog that pops up...

Thanks. That seems to have worked. For others who are following: HOW to Restore to MSSQL 1)Start SSMS 2)FILE-> Connect Object Explorer 3)select 'local' with 'Windows authentication' 4)look at object explorer column on the left and right click on 'Databases' 5)select 'Restore' 6)in the dialog...

Okay...since lytec is mssql based, I'll assume the liter.bak file can be restored by mssql.,.how do I restore a backup with mssql?

But that requires lytec at home, no?

Lytec is a propietary database app (that sucks but I am stuck with it) and it runs on mssql. I am trying to open its backup file at home on my mssql server. (I dont have enough licenses to install Lytec on my home pc as well as work- and I want to work on some reports at home using crystal...

well, please dont laugh... but i dont know how to open a .bak file that lytec generates....in mssql or mysql. I guess i need the mdf file. how do i open either of these filetypes with mssql?

Can a lytec backup database file (for example mydb.bak) be opened by a generic sql server lke mssql server 2008 or mysql?

yes. the lytec 2009 is running at the office and only has a 3 user license. I do not want to interfere with a 'production system' by loading crystal reports onto a pc and then monopolizing that pc to screw around with crystal reports. i'd rather take a backup of the database and work on it at...

tnx for your replies. so i guess installing mysql wont suffice ? (I tried it but I am such a noob that I dont even know how to start it after installing it as a service- I tried running odbcad32.exe to establish a system DSN but that asks for a sql server-even with mysql running i cant find one!)

sorry to be a noob but it sounds like you need lytec running to log on to the server to access the data. what if i just want to take the data to a workstation and use crystal with it but without lytec? is there a way to start a server without lytec?