Search results for query: *

Hi Tarwn , Thanks very much for your invaluable help, tips and suggestions on this. But I think I need to give you a bit more information at this stage so that we can take it to a bit more closer to reality. (1) The 2000 odd users will be scatterred all around the world and it will be only...

Hi freinds, Well I hope its right to ask this question in this forum. Basically I am from database design background and have been asked to design a database which will be driving some asp pages. I am no familiar with asp , but atleast people in this forum atleast knows whats expected from the...

Well I found the solution. DTS uses some form of bulk copy and hence the bulk insert dont get replicated. Now I import everything into a temporary table and then copy from the temporary table into the actual table using the insert into syntax. In this case all the newly added records got...

Hi, I am trying to setup a merge replication between our servers in UK and HK which is working quite well on various tests. But in one of the tables in Uk when I import data from an Excel file using a DTS package it works well and imports the data into the concerned table. Please note that...

Hello freinds, I have 4 DTS packages that imports different parts of an excel file into various tables based on some conditions. The DTS packages works very well. But then after executing the packages the following happens : (1) If I double click any excel file to open then MS Sexcel opens and...

I am re posting in this forum also as I didnt have any repsonse in the other forum. I expect thw Whiz kids in here to help me please. Apologies for posting again. Hello freinds, Most of you would have come across similar situations many times before and would have solved it in your own style...

Hello freinds, Most of you would have come across similar situations many times before and would have solved it in your own style and preference. let me explain the situation. I have the (1)ItemRefsLookup Table : CREATE TABLE [dbo].[ItemRefsLookUp] ( [ItemRef] [varchar] (25) NOT NULL ...

I thought SQl Sister would have given me some guidance or even the hard working ESquared.

Hi , This topic has been discussed a lot in this forum even before. Most of the people have asked to look in the example provided in Books online. Please note that I did try that example to get an understanding of how this works. Kindly note that the example view when updated does update...

Thanks very much to all your inputs. yes when I meant by using Stored procedure in VB is by dynamically creating stored procedure during run time of the VB program itself as compared to pre created compiles SP in the SQL server itself. Thanks very very much . I feel more enlightened now.

Hi, Is it the best practice to declare and define stored procedures using an ADO object within VB or is it better to declare and define and compile it in the SQL server itself. Can someone explain as to why one is better than the other. Rgds

Hiya, Thanks for the reply. Can you please explain mapping with reference to the following situation as an example:- (1)The static internal ip address of HK Server is 10.0.0.200 (2)The static fixed ip address of the HK is 218.243.123.138 (not the real ip, just an example) (3)The internal ip...

Hi freinds, I am trying to connect from a machine in the UK to our HK server via a VPN connection. The HK Server is a Windows 2003 SBS server and is also configured as a VPN server and accepts remote connections. The router at the HK end is all configured so that the relevant ports are opened...

Oh it was my mistake. I created a new file My.cnf and then tried to edit it. Infact the my.ini file was already created during the MySQl server installation. Anyway now after editing the correct ini file it is resolved. Thanks

Hello, I installed MySQl version 4.0.18 in our new Windows 2003 Small Business server. Insated of installing the database in the default location I changed it from c:\mysql to f:\mysql and location of data to f:\mysql\data . I created this my.cnf file and edited the contents of the it to...

Hi freinds Crystal reports - 8.5 MS Access 2000 Database Everything was working well when I connected the Crystal report directly to the Microsoft Access database (without using DSNs). When one opens the report in Visual linking expert it shows all tables linked and most importantly it shows...

Hello How do I design a report which works of an access database ( the location of which can keep changing). Dont want to change the path in the report every time the location of the database changes. Other than using DSNs Is there any other way. Rgds Rajeev.

Hello freinds, This may sound Naive. But still find it convenient as far as I am concerned. Well we have 3 overseas located offices where we are trying to migrate all the databases from whatever existing ( MySQl / Access) to SQL server. Now we get databases send across from those sites to us...

Thanks very much for the info bertrandkis. Can I ask some basic questions before i strart going indepth into replication. (1) Does the publisher role and the subscriber role has got to be fixed and cant it not be either way. Means A publicher can be a subscriber and a subscriber can be a...

Hello freinds, Can someone point me into the right direction for me to have some insights into Replication and publishing. I want to have an indepth idea on how to do this mainly to help enable our worldwide databases synchronise with the central database every so often. Any other ideas other...