Search results for query: *

I did a little work around, so I didn't need to install the service pack on the client machine :) myReport.Database.Tables(1).Location = sDatabase & ".dbo." & myReport.Database.Tables(1).Location Thanks for your help vidru!

Hmm probably isn't only the p2soledb.dll file enough..

I'm using OLEDB, the KB article you refere to seems to be the problem! Thanks vidru, last question... A customer has this application installed, and when they get te new version of the app with the new report, do you think that I only have to distribute the new P2soledb.dll or do I have to...

Permissions are ok, public does have execute rights. Ive tried using the same account from both machines. /lechuck

I have a report created with RDC in VB6 with Crystal Reports 8.5. The report gets data from a stored procedure (MS SQL2000). All works fine from my development machine, the report publish the data and can be viewd in the crystal viewer component. But when I put my application on a client...

I have one Stored procedure that looks like this CREATE PROCEDURE sp_test @c AS SELECT a, b, c FROM my_table WHERE c=@c Now I want to execute this sp whithin another sp. To store the result in a variable when selecting from a table is easy (select @myVar=a FROM my_table) but how does it...

I suppose that UniqueID is not designed as unique in your table?

Thanks AngelTampaBay! Your tip realy did the trick.

I have two procedures, that returns data from the same table, but with diffrent where clauses. In some cases the procedures returns a row that exist in the result from both procedures. (I have an ID field in the table) Now I need help with a third procedure that executes sp1 and sp2, and if...

I have a stored procedure that i need to check which SQL-user who is processing the current procedure. Is this possible and how do I accomplish that?

WITH INIT argument worked fine, thanks!

I need some help whith an sql query. the query "select date, user, location, ip from myTable" returns this date user location ip ----------------------------------------------------- 2003-11-08 23:32:12.000 bob Uptime 1.2.3.4 2003-11-08 23:31:52.000...

Hi I've created a litle backup database script that users that don't have the MS SQL Server Enterprise Manager could use. The script looks like this DECLARE @dbName varchar(100) DECLARE @backupFolder varchar(200) DECLARE @path varchar(250) DECLARE @db varchar(150) /***** CHANGE this...

Thank you very much!

I have two tables usrTable and testTable. select * from usrTable u_id usr ----------- ------------ 1 sa 2 bob 3 john select * from testTable t_id usr1 usr2 usr3 ---------- ---------- ---------- ---------- 1 1...

I want to convert the user SID to varChar, I have successfully converted a local SQL users SID to varChar, se the code below. Q: SELECT SUSER_SID('MyUser') A: 0x15489420B0A30543B2CD88D4EE4E6C37 Q: SELECT SUSER_SNAME(0x15489420B0A30543B2CD88D4EE4E6C37) A: MyUser Q: SELECT...

The column is varChar(50). I found this in SQL Server Books Online: Checking the Validity of Saved Data When Using the Automatic ANSI to OEM Conversion Option Another way to reveal the code page is to set Automatic ANSI to OEM conversion to OFF and query the data from SQL Server Query Analyzer...

I've noticed that a string I stored into SQL server does not appeare to be the same as the orginal string. If I have the string "Œ‘•" and store it into the database field that is of type varChar, then I read the string and get the value: "O_'¤". I'm using the VB code...

I have a table MyTable that contain too columns: Col1 that stores chars and a ID column configured as a counter. I did a test on SQL7.0 Server with the following code: INSERT INTO MyTable(Col1) VALUES('MyValue') SELECT @@IDENTITY AS 'NewID'; It insert MyValue into table MyTable, then it...

My generated script file is over 1200 rows, I made a smaller database and generated a script. In my new example i called the database 'Test' and made a table 'myTable' with a few columns. I generated the script: if exists (select * from sysobjects where id = object_id(N'[dbo].[myTable]') and...