Search results for query: *

THANKS! That did the trick.

Hi I hope some one can help me with this small piece of code. I have a button on a ASP page and when the user click the button the code have to open another page. However, nothing happens when I click on the button. I have tested the hyperlink by creating a ordinary hyperlink to the page at...

I tested the indexOf and it worked. Thanks for your help!

well, when moving the project from one server to another the DBserver (the IP address of the server) is changed manually in the global.xml. However, I would like that I don't have to change my part of the code every time I make a new version and move the it to the production server and therefore...

I am connected to the server and I do have the connection string so I can make a inStr search on the string, but is that the way to do it?

Do someone know how I test what SQL server I am connected to in vd.net? I am working on both a production server and a development server and the code will be slightly different depending on what SQL server the vb.net code is linked to. So I would like to be able to test the SQL server name or...

Hi cmmrfrds Yes, it was helpfull!!!

I keep getting the error: “Execution was cancelled by user” when running my DTS package from VBA or VB. This has only been a problem on my PC and not on the person who use the application for import of data. Now she has got her PC upgraded and now she has the problem as well. The DTS package...

You might be right. I just can't remember that it was installed before... but I might have a bad memory. So I will give it a go.

The import module to my SQL-server based database is developed as a DTS package and it is called from the ACCESS front-end with the following code: (my test in VB) Private Sub Command1_Click() Dim dtsChdPkg As DTS.Package2 'initialise child package Set dtsChdPkg = New Package2...

Hi MarleneD Did you solve your problem with connecting? I have the same problem and would very much like to know what you did to get on.... Thanks!

I am creating a database for scientist from a number of countries. They have asked for web access with pivottables to the database. So fare I have created a data warehouse with cubes in SQL server analysis services 2000 and now I have tried to create a pivottable. I have just taken the web...

Hi tb Thanks for your reply. As you can see I never programmed in VBscript before. I have tried your suggestion however, I get the error message; Type mismatch: 'ALKdll.ALK'. I can't see what I do wrong. The dll I call is a function returning a boolean.... and it works in VB. Could you help me...

Hi Out There I have tried to call a dll from a DTS ActiveX Script without any success. I have not been able to find an example on how to do it so this is my pure guess – and it is not good enough. Could anybody enlighten me please? DATRAS:-) The error is: Class not defined: fitALK ' Visual...

Hi There Just realised that the discussion on how to open and closing Excel from Access is still going on. Mine is working now. I have these two routines one to open and one to closing Excel. In between I have a fair bit off code so this might not be enough but try this first – Steven I think...

Well, that gave me this instead - a global temporay table: set @sqlstring = N'SELECT Country, Ship, [LineNumber]INTO ##Temp FROM ' + @tbl It doesn't seem to work with a local temp. tbl., so I must ensure that the table name change each time the procedure is called. However that is possible...

Hi again bperry What I am going for is more something like this: CREATE procedure upSU_CrossCheck @tbl nvarchar(10) as declare @sqlstring nvarchar(500) declare @tblIn table (Country char(4), Ship char(4), [LineNumber] int) Set nocount on set @sqlstring = N'INSERT into @tblIn SELECT...

Yes, that will work for a start! Thanks :-)

Yes I have and it was returning nothing as well. I have however got the answer in the SQL server forum. The code should be like this: CREATE procedure upSU_CrossCheck @tbl nvarchar(10) AS declare @sqlstring nvarchar(500) Set nocount on 'I had forgot this part SET @sqlstring = N'SELECT...

Hi Terry Thanks a lot! You are right it was very complicated and now it looks much more logic (-: