I've been experienceing probelms downloading any of the visual studio express tools. I keep getting a site not available error and/or the vwsetup.exe crashes.
Do you have a better place for me to post for this issue?
I'm running Vista Home Premium 32-bit on a AMD Turion64x2 Mobile
Please help!
I am trying to use Integration Services for something I've never done before; i.e., download a few files from an AS 400 and then turn around an email them to a user.
My basic problem is that I don't know where to start to get the files from the AS400 to a directory on the SQL Server. I have an Iseries ODBC connection configured correctly that will let me get to the files. Do I use a file system task to get the files from the AS 400 or do I use a data flow task? Don't know what task to start with. Once I get the files into a directory on the SQL server I don't think I will have any trouble emailing them.
I know it's a silly question but I've looked at a couple of books without any obvious answer popping out.
Steve Wells
hi all
i have the 2000 adition but i realy want the 7 version
and now microsoft offer as a shareware only the new 2000 to download as a limited pack
my questune is whare can i get the 7 version on the internet as a shareware
time trail or whatever
thanks in advance
Dear All,
I am new to SQL I download "sql2ksp3" to my laptop (Window Xp Pentium III) and then I start to setup MSDE:
>> setup SAPWD=pass SECURITYMODE=SQL
After I run this command it gives me the following statment!!!
Setup failed to configure the server.Refer to the server error logs and setup error logs for more information.
Please help me what i have to do to make this stuff works!!
Sincerely
Henok
I am looking for some material for downloading documents from sql
server. I can upload documents in my app but i would also like to
download those files too.
Thank you
Hi,
I want to download data to excel in which each filename varies depending on the day i download them.
Ex.
ExportFile_09272007.xls
Can this be possible?
cherriesh
Hi
This is to do with HTTPS merge replication. We were getting an error when downloading the initial snapshot. The snapshot was about 25 meg, over an average link. It returned an error after a few minutes - it did start to download the .cab file (it was compressed).
By not compressing the cabinet file, it worked fine - I can only presume it was some sort of timeout error. The downside was that the amount of data was much greater, with it not being compressed.
Questions therefore are:
a) is this time of timeout a known condition and if so what can I do about it
b) slightly unrelated- can an alternate location be given for the snapshot, like you can in non-HTTPS anonymous subscriptions.
Main properties in creating the subscription is as follows:
subscription.InternetUrl = webSyncUrl
subscription.InternetSecurityMode = AuthenticationMethod.BasicAuthentication
subscription.SubscriberType = MergeSubscriberType.Anonymous
subscription.SyncType = SubscriptionSyncType.None
and when synchronising....
subscription = New MergePullSubscription()
agent = subscription.SynchronizationAgent
agent.PublisherSecurityMode = SecurityMode.Standard
agent.DistributorSecurityMode = SecurityMode.Standard
agent.UseWebSynchronization = True
agent.InternetSecurityMode = SecurityMode.Standard
Thanks
Bruce
I keep getting eeror mess when downloading SQL server 2005. Micro soft cust service says they are not qualified to fix but if I pay $99.00 they can have someone help with it.
I think that is nuts since they are sending me the download. I tried to do it manually and some components installed but everyday I get update notifications
HELP! PLEASE!
what data type am i going to put to my uploadedFiles column in my database... uploaded files are in document format or .txt
also.. how can i make those files converted into pdf files.. also enable users to download it..
tnx!!!
forums.asp.net = "great help"
Our entire sales database sits on an Informix server and users run their reports directly to this server.
Because of the volume of data - upwards of 7 million rows in some tables we are finding performance is becoming an issue. We realise that Informix is not the best for running queries and so are looking to replicate to a SQL server and use that as a reporting server.
My chosen method is DTS using ODBC which works fine. However due to the sheer volume of data to be downloaded each night (over a 512K wan link) we only want to download changed data.
Is there any way we can get SQL2000 to download only change data - i.e a differential download or something? We don't have a unique field in the table (for whatever reason) such as sales date or transaction ID (shops might upload old / back-dated transactions for example due to a systems failure).
If I do have to download all the data every night is my method the most efficient or is there some other approach I could use?
Ultimatly the aim here is to relieve the Informix server of the reporting overhead so any alternative ideas are welcome!
Many thanks
hi guys,
i want to use SSIS package to download files from an http website.
i am tried using Http connection managers and webservice task but it asking me the wsdl file. i dont know where that file is.
can anyone please guide me? or suggest me any other way to do this?
I can not download sql express 2005 from microsoft website. Everytime I click on the download button I get error saying "this page can not be displayed. Possible reason... internet connection" I know my internet connection is working because I am browsing through the microsoft website and other websites. I had .net 1.0 in my computer so I unintalled that to try to intall the latest 3.0 version but when I click to download that I get the same error. Seems I can not download anything from microsoft website. I uninstalled windows intaller and automatic update downloaded latest version of windows installer. When I tried to download windows installer from microsoft website I got the same error.
I am using Windows XP home edition version 5.1 sp2.
Please help!!
Thank you,
Jay
Hello World,
I am trying to download the SQL Express Server 2005 software direct from Microsoft. I am having trouble locating the ENGLISH version. I am located in Frane but prefer using software in my native language....no pun intended. Every attempt to d/l gives me the French version. Can anyone provide me a link for the ENU version of SQL Express Server 2005.
Thank You in Advance,
Best Regards,
Richard J. Rothery Jr.
rjstinyc@hotmail.fr
Hi,
I am not able to download the trial edition of sql server 2005.
http://www.microsoft.com/downloads/details.aspx?FamilyId=6931FA7F-C094-49A2-A050-2D07993566EC&displaylang=en
From this page when I click continue to do the registration, it displays a page not found error !! Can you plz fix the link
thanks
Hi,
I'm merge replicating between SQL Server 2005 and SQL Server Compact on mobile devices. I recently had a problem with reinitialization of subscriber databases (please see my previous post, no responses yet...) which I couldn't resolve and had to get 15 subscribers to backup their dbs so I could manually restore each one onto the server. Most of the subscribers were able (yesterday) to then delete their local dbs, create new db files and sync with a snapshot. Today I'm trying to sync a new db with a newly created snapshot and getting the following errors:
2007/08/29 16:23:17 Thread=1118 RSCB=67 Command=SCHK Hr=8004563C An error occurred while reading the .bcp data file for the 'MSmerge_rowtrack' article. If the .bcp file is corrupt, you must regenerate the snapshot before initializing the Subscriber. -2147199428
2007/08/29 16:23:17 Thread=1118 RSCB=67 Command=SCHK Hr=80045017 The merge process was unable to deliver the snapshot to the Subscriber. If using Web synchronization, the merge process may have been unable to create or write to the message file. When troubleshooting, restart the synchronization with verbose history logging and specify an output file to which to write. -2147201001
The only difference from yesterday is that there was a server restart this morning. I have regenerated the snapshot but it still doesn't work. This is only affecting users with new (empty) databases, users who regenerated their dbs yesterday can sync ok.
I have read other posts about folder/file permissions affecting snapshot delivery, but there have been no changes to permissions since successful snapshot deliveries yesterday.
I would really appreciate any help with this. At the moment I have 3 users who can't use the system at all.
Regards,
Greg
Hello,
I have a problem downloading Microsoft SQL Server 2005 Express Edition with Advanced Services.
Every time I download the complete file (234 mb) I get an error that the downloaded file is corrupt. I've tried also downloading it on other locations but every time the file is corrupt.
Is there another way to obtain this version of SQL server 2005 ?
I'm having an error with merge replication my suscriber are downloading old data, all this start happen after I install SP4.
let explaint this with more details ,
if a made an update to a row in a table from the publisher , the agent history show that 1 change have downloaded to the suscriber, a put an audit in the suscriber and yes one update was downloaded but the row still the same, look like the suscriber downloaded old data instead of the curent change that i made.
If i delete the row, the rows gets delete at the suscriber, if a insert the row the row get insterted ok.
The problem only happen with rows inserted at the suscriber, that later on get update at the publisher. My suscriber has MSDE 2000 SP3 an my Server has SQL Enterprice 2000 SP4.
Any help would be apreciate. thxs.
I had a small requirement i had a table with embedded attachments and attachments are uploaded to the table and saved in varbinary field from front end. Want i want is i want to download particular embedded files in that table within SQL Server itself. I have tried googling but none of seems to be within SQl Server T-SQL. all are linked to Asp.NET how i can do?
View 6 Replies View RelatedI have a package with an FTP task in the Control Flow. Nothing complicated, its configured to download a file from FTP with overwrite true, and the get and download paths in variables. Once this step completes it goes to a sequence container that does stuff with the file, that part works fine.
The problem is if i run the package in debug mode using Visual Studio, everything works perfectly (even if run over and over). The problem occurs if i use my "driver" application to try and execute the package. All my driver does is use C# code to create an Application object, set the PackagePassword, LoadPackage based on the path and then .Execute().
Here is when the strangeness begins:. If the file exists in the destination path, then the FTP task fires. If the file does not exist (lets say i manually delete it after its being downloaded before using the IDE) the FTP task dose not fire and my Sequence Container fails to use the fail, since it is of course missing.
Monitoring the FTP server that i am running locally i can see commands firing when the file exists, but when the file is killed it never even tries to connect to my server. Very odd.
Am i missing something? Why would this work from the IDE but never from my driver?
Any help would be appreciated. Please let me know if any additional detail is required.
Dmitry
http://blog.lyalin.com
I'm looking for a sample Database that is well set up to learn from. Does anyone know where I can download one from?
View 1 Replies View RelatedHi,
I'm trying to work on a database when I'm not connected. I can't figure out how to get a local copy of a database.mdf that I created on the server, onto my hard drive, using SQL Management Studio Express. Does anyone have any suggestions? I'd be forever in your debt. Thanks
I am working in a secured company which doesn't allow live internet connection, therefore I can't install SSDT using Web Platform Installer and we also don't want to install the intire 2012 client tools.
View 2 Replies View RelatedHi there,
I have gone to the page http://www.microsoft.com/express/sql/download/default.aspx to download the 64 bit version of the Management Studio for Vista 64 bit... and its in Chinese.
This is the double astrix version at the very bottom of the page specifically for Vista 64...
Is this something I am doing or is this download link actually to a Chinese Download??
Can someone point me to a download link that is English...
Thanks in Advance
Simon
Hi
Can someone help debug this error while downloading to EXCEL format from RS? I notice that whenever i trim down the length of my report name, the error has not occurred.
The error encountered was:
have just implement Microsoft Dynamics NAV. and I'm trying to learn how to use this Excellent tool powerpivot add on, But when I'm trying to connect it to any SQL table that support Dynamics NAV I have an error message while downloading the table :"do not have enough memory or I should use Excel 64 bits instead 32 bits".when I check CPU memory Utilization we are just using less tha 20%. I'm working on a remote server and the using Excel 2010.
View 3 Replies View Related
Hi
Can someone help debug this error while downloading to EXCEL format from RS? I've notice that whenever I trimmed down the length of my report name, the error has not occurred.
The error encountered was:
Hi
I have noticed that four out of the 145 tables being replicated in my topology perform a mysterious update.
If I insert data at the subscriber then synchronise the upload is completed followed by immediate downloading of the same identical set of rows as updates.
Has anyone seen anything like this. I cannot see any difference in the filter joins or article settings compared to any other table in the system but these four consistently do this.
Publisher/Distributor: SQL 2005 SP1 on Win 2003 Server
Subscriber: SQL Express 2005 SP1 on Win XP SP2
Cheers
Rab
Hello.
I've been having an error when downloading the snapshot agent from our Publisher.
The articles selected are all the tables and all the stored procedures.
The Subscription is created programmatically and so is the synchronization. When trying to synchronize for the first time and when the subscriber tries to download the snapshot I have the following error:
Error messages:
The schema script 'Distrito_2.sch' could not be propagated to the subscriber. (Source: MSSQL_REPL, Error number: MSSQL_REPL-2147201001)
Get help: http://help/MSSQL_REPL-2147201001
The process could not read file 'GESZifuncAFRODITE$SILVITEST_GESZIF_GESZIF20070621182845Distrito_2.sch' due to OS error 3. (Source: MSSQL_REPL, Error number: MSSQL_REPL20143)
Get help: http://help/MSSQL_REPL20143
The system cannot find the path specified.
(Source: MSSQL_REPL, Error number: MSSQL_REPL3)
Get help: http://help/MSSQL_REPL3
The snapshot folder is at c:GESZifSnapshotFolder and the unc is \AfroditeSnapshot.
I'm getting a little desperate with this because we really need to propagate the schema changes around the subscribers.
Thanks in advance,
AVD
I everybody,
I'm trying to download Microsoft SQL Server Management Studio Express from
http://www.microsoft.com/downloads/details.aspx?displaylang=en&FamilyID=C243A5AE-4BD1-4E3D-94B8-5A0F62BF7796
However, the download never finishs.
If I try to download using a download manager it stops after 98% (the segment that stops is the first segment).
If I try to download without a download manager it stops after 1% (456Kb).
What can I do?
Is there an alternate place where I can download the file?
Thanks,
Nadav
Hi all,
One year ago, I did "Ruuning Setup to Install AdventureWorks Sample Databases and Sample" to install "AdventureWorks" in my SQL Server Management Studio Express. Now, It just have the name "AdventureWorks" on and no contents (no tables, schemas, etc.) in it. In my Control Panel, Add or Remove Programs, AdventureWorksDB (162.00 MB) is still there and AdventureWorks (Windows Installer Package [27,992 KB]) is in my C:/drive.
(1) Should I delete the name "AdventureWorks" in my SQL Server Management Studio Express, and remove AdventureWorksDB (162.00 MB) from the Add or Remove Program, before I re-install AdventureWorks, AdventureWorksDW, and Adventure Works DW sample databases and samples from Windows Installer Package [27,992 KB]? Is my old AdventureWorks (Windows Installer Package [27,992 KB]) still good and complete for installation?
(2) SQL Server 2005 Books Online (September 2007) presents "Reinstalling Sample Databases from Script". But (i) I can not find the file instawdb.sql for reinstalling AdventureWorks from script and I do not have AdventureWorks OLTP in my C:Program FilesMicrosoft SQL Server90ToolsSamples folder, (ii) I can not find the file instawdwdb.sql for reinstalling AdventureWorksDW from script and I do not have AdventureWorks Data Warehouse in my C:Program FilesMicrosoft SQL Server90ToolsSamples folder either!!??
Please help and tell me what is the best way and some detailed instructions/tips to have AdvenureWorks, AdventureWorksDW, and Adventure Works DW sample databases and samples installed in my SQL Server Management Studio Express.
Thanks in advance,
Scott Chang
I just got finished developing the company intranet site and thinking that everything was working I boasted about how good it was by getting my boss to login and submit a new job to the db (new job, its a work management app) while i did the same, the pland was to hit the submit button at the same time. He would send one to be read by me and I would send one to be read by him. We both hit submit and the following happened.
The db has somehow fused the two into one. I thought maybe we were to accurate in hitting the submit button together. But I even gave a five second delay between and for some reason the job is being overriden by one user tor the other. In other words we are both sharing the same jobid. I thought this could never happen with sql server supposing that it would lock one request until another was completed and vice versa. But I'm so new to this that I'm just so naieve to think that the db would do this for you. Problem is I'm about to move on and I can't leave the app in this state. Can anyone point to some articles or give some suggestions has to my situation. Most desperately in need!!
Thanks in advance
hello
i'm having touble getting my sp done. the problem is as follow..i've found an sp tokenize (which works fine) with the following signature:
CREATE PROCEDURE TOKENIZE (
S VARCHAR(10000),
DELIM CHAR(1))
RETURNS (
ID INTEGER,
TKN VARCHAR(10000))
AS
DECLARE VARIABLE I INTEGER;
DECLARE VARIABLE LEN INTEGER;
DECLARE VARIABLE FIRSTCHAR CHAR(1);
DECLARE VARIABLE S2 VARCHAR(10000);
begin
...
SUSPEND;
end^
then i build myself another sp (which also works fine) with this signature:
CREATE PROCEDURE GET_DICENTRIES_BY_ASDSKRPT (
ASDSKRPTINPUT VARCHAR(15))
RETURNS (
ID BIGINT)
AS
begin
...
suspend;
end^
now, what i'm trying to do is write another sp (get_dicentries_by_all_asdskrpts) that accepts a '.'-tokenized string as a parameter (e.g. 'bla.bli.blo.blu'; number of tokens NOT fixed at 4!) and returns the intersection of
GET_DICENTRIES_BY_ASDSKRPT('bla'), GET_DICENTRIES_BY_ASDSKRPT('bli'), GET_DICENTRIES_BY_ASDSKRPT('blo') AND GET_DICENTRIES_BY_ASDSKRPT('blu')
does any of you have an idea how to go about?
thanx,
martin
Could someone help me get the following SQL statement working?SELECTstandardgame.gamename,standardgame.rowteamname,standardgame.colteamname,standardgame.dollarvalue,standardgame.gameid,standardgame.cutoffdatetime,standardgame.gametype,standardgame.gameowner,(100-COUNT(purchasedsquares.gameid)) AS squaresremainingFROM standardgameLEFT OUTER JOINpurchasedsquares ON standardgame.gameid = purchasedsquares.gameidwhere gametype='$gametype' and dollarvalue = '$dollarvalue' andgameowner = 'GROUP BY standardgame.gameidorder byCASE squaresremaining WHEN 0 THEN 1 ELSE 0 END ASC,squaresremaining ASCThe problem is... MySQL doesn't seem to want to let me usesquaresremaining in that case statement since it's not an officialcolumn name. Any idea how I can reference squaresremaining in the casestatement?
View 2 Replies View Related