Showing posts with label attempt. Show all posts
Showing posts with label attempt. Show all posts

Monday, March 19, 2012

New Server Registration offers no Server Name options

Real newbie question this, I suppose. (Apologies if in the wrong forum!)

Have just downloaded and installed SQL Server Express. When I attempt to start it up, the New Server Registration dialogue box appears. When I attempt to enter a Server Name, there are no options in the drop-down box except <Browse for more>, which then offers me neither Local Servers or Network Servers.

The machine is running XP Pro and I wish to use the SQL package to develop on the PC as a stand-alone environment while I evaluate it.

So what am I doing wrong?

Many thanks in advance for any help.

I have been looking through previous threads and camce across an entry from Mike Wachal, who suggested typing the following into a command window.

SQLCmd -S .\sqlexpress -E

The response was 'SQLCmd is not recognized as an internal or external command, operable program or batch file'. Is this anything to do with my problem?

|||

Duh! I realized that I had only downloaded the Management Studio package and not SQL Server itself. All working now ...

Monday, February 20, 2012

New Crystal Report Question

Hi guyz! i have a problem with my crystal report 9. im using vb6 in win xp. my prob is when i print my report in second attempt it will just eject the paper without print. but in first, its fine..

here's my code:

MyReportPrintCheck.DiscardSavedData
Set printer = Printers(cmbprinter.ListIndex)
MyReportPrintCheck.SelectPrinter printer.DriverName, printer.DeviceName, printer.Port
MyReportPrintCheck.PaperOrientation = crDefaultPaperOrientation
MyReportPrintCheck.PaperSize = crPaperLetter
MyReportPrintCheck.PrintOut False <-- i think the "False" here is the problem because when i remove the false it will print though it will take time coz it will prompt me a message if i will print all or selection..thats why i put "False" here so that when i click the Print button.. it will automatically print. can anyone help me?

Set MyReportPrintCheck = Nothing

i really appreciate ur reply...

atzMake sure the second page is not empty|||yes, my second report is already empty... but still it will never print... it still eject the paper... when i install my vb6 and cr9 in win 98 and try, it works fine! but when i transfer, i mean install it in win xp. there goes the problem... i think mybe there something with my code... can you give me an example? thanks for your reply... :)