Search results for query: *

I am stumped. In VB6 I did this LabelToPrint.SetUserPaperSize (5 * 1440 / 2.54), (10.2 * 1440 / 2.54) And all worked well. On conversion to VB 2005 I can only choose from a set list of papersizes when I use .PrintOptions.PaperSize. I have searched endlessly and I think that I have just lost...

Wow. I just found this trick, courtesy of Greg Robidoux ( 3/18/2008 on mssqltips). If you do backups often you may see that the System event log will fill quite quickly with Backup notifications. To STOP this logging you can try this DBCC TRACEON (3226,-1) And to turn it back on DBCC...

Help!!!! I have a backup that I have created using vb 2005 with a password of "!cp0p#Adm1n1strat0r". Now, when I go to restore it I am told that the password is invalid. I am guessing that it is the "!" and "#" causing problem. any ideas on how I can resolve this? Cheers

Hello ALL I am trying to stop the unauthorised attachment of a database. Yes, I have asked this before and yes ... I am using encryption. But I have become intrigued with tee DDL triggers. In principle I want to detach on attach, as I have scripted below Create Trigger [All_Events] On Database...

Damn CR9! I can run the same report n times but on n+1 my program just crashes with that lovely windows message telling me that I may send the error to Microsoft. There is absolutely NO rhyme nor reason to it: same report, same sql stored procedure, same parameters, same every damn thing...

My instance of mssql 2005 has no Administrator rights, ergo I have effectively "forced" a logon with user name and password. Well ... thats great for MY instance but there is nothing stopping an unscrupulous user from stopping my instance, copying the database, attaching it to an Administrator...

the current VPFOLEDB.DLL does not allow updates nor deletes with a linked server. So ... I want to create my own. Is this possible?? and if so ... how??? Thanks

I have a mssql 2005 database with a linked server to a FoxPro9 database. As you can see below I just want to dynamically construct an openquery. Please help or direct me. Thanx Fetch Next from OOS into @OrderDate, @Company, @DrugCode, @Message, @QtySupplied, @QtyOrdered While @@Fetch_Status...

I am implementing a MSSQL 2005 express instance as the "back end" to my app. This app will be self-installed onto networks where (I just know) all users have been setup as Admin, therefore they can access my database with Windows Authentication: not a good thing. As I cannot change the end-users...

First I assign the correct printer to the printer object then I assign that printer to the report as with ReportToDisplay.SelectPrinter Printer.DriverName, Printer.DeviceName, Printer.Port But it VIEWS in the font of the default printer. What the &%@$? And, of course, the report prints in...

I wish to add "C:\Program Files\Microsoft SQL Server\MSSQL.x\MSSQL\Binn\sqlservr.exe" to the firewall list of exceptions where "x" is the number of the instance. How do I determine the instance number during installation? For reference I am using innosetup.

I have a service (a data access level) that happily does it's thing. Great. But to talk to it I need to know its IP address or its PC name. But like a good mammal on heat how do I get a program to find the service without knowing its IP address or similar? Is this just a STUPID question? Do I...

I have a date/time critical application that must not allow the user the retrospectively add records to the database. In other words they are NOT allowed to change the system date to , say, yesterday and then add(or for that matter alter or delete) a record. I would love to "ping" off a time...

Other than a) capture form image in picture b) rotate picture (as necessary) c) use paintpicture method is there another way to print a form to a Zebra LP 2844 such that it lines up within a 5 part label (on to the part that I want to use) such that it prints at x,y on the label? This is hair...

What the ^%$@? When I double click on the title bar of my form it jumps 1/6 of its height above the visible screen. This only happens in 1024x768 setting. Possibly the dumb award for me but ... why???

Am I just dumb or what? SQLDMO does not list the SQL2005 instances. Any ideas?

VB6 - MSSQL 2005 - CR9 I have many reports based on data returned by parameter-fed stored procedures. The first time I run any of these reports I get NO data. Every time thereafter I get what I expect. And yes, on my dev box this is NOT a problem nor is it a problem when I remotely connect to...

I produce reports using stored procs to which I pass x parameters. On my dev box all works well. As soon as I run the exe on my live environment I get the above error. Moreover, with the live environment the reports do not retreive data on the first attempt. I have to re-execute the report to...

All thing being equal how does one trap a connection error with an ADODC during application startup thus stopping the same error occuring with other ADODCs? Or, put another way, am I doing the wrong thing by "hard-coding" the connection details of the ADODC into the IDE?

I have "a.pdf". I view it perfectly. I now store it (data stream) as a nvarbin(max) in a sql 2005 table (the reason I do this is NOT the issue). I now retrieve it (data stream) and I cannot view it. I get the error message "file does not begin with %PDF-" within the standard version 8 viewer. I...