connect to lytec database with mssql

[bwanaaa]

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 reports)

I am trying to open the backup file with mssql but am stumped. When i go into the mssql manager app, it looks for a .mdf file. Do i need to detach the original database from work and transfer it to my home? or is there a better way?

 

[simian336]

You can just do a back up from work and restore it at home...

Simi

 

[bwanaaa]

But that requires lytec at home, no?

 

[djj55]

If you do a backup using MSSQL no.

djj
The Lord is my shepherd (Psalm 23) - I need someone to lead me!

 

[bwanaaa]

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?

 

[djj55]

I would suggest using SSMS (or Enterprise Manager for 2000).
There you can right click the instance and select restore database.

djj
The Lord is my shepherd (Psalm 23) - I need someone to lead me!

 

[bwanaaa]

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 that pops up, type 'test' (or whatever) in the 'To database' field (in the 'Destination for Restore' Section)
7) select 'From device' radio button in the next section
8) click the button with the three dots in it (on the same line as the 'From device' button)
9)navigate to the lytec backup file
10) hit ok

Now when you expand the 'Databases' entry in the object explorer, you will see the name of your test database
.

The next step is to set up a dsn.

If you are running windows 64 bit OS
Go to Windows->SYSWOW64 and find odbcad32.exe
this is the 32 bit version of the data source administrator
it is important to run the 32 bit version because crystal reports is not 64 bit and you will have this problem

http://social.msdn.microsoft.com/Fo...s/thread/1c63e3ae-e001-4066-9eac-ad9162116603

Click on System DSN tab
Click on 'add'
in the dialog that appeas, name your dsn
in the dropdown list under 'Which SQL Server do you want to connect to' select 'local'
click next
select 'With Integrated Windows authentication'
make sure checkbox labeled 'Connect to SQL Server...' is checked
click next
click next again
click 'Test Data Source...'
you should get success
click ok

now start crystal reports
click File->New->Standard Report
Click the '+' sign in front of the 'Create new connection' in the dialog that appeared
CLick the '+' sign in front of the 'ODBC'
a dialog appears, select the dsn you just created
click next
NOW I DONT KNOW WHAT TO DO!
it seems it doesnt matter what login what the login credentials are?

 

[simian336]

You don't know how to create a crystal report or you don't see data?

Simi