Whatever you do, don't try aspwebhosting.com . One day recently I got
an email from them saying that my account had been suspended for using
too much cpu time. There was no further explanation. Those bastards
took my site offline, removed my email account, blocked my ftp access
and even refused to let me get a backup of sql-server data. I sent
them an email (using a yahoo account since they had shut down my own
server) to ask what I could do to get my data. Rather than answer my
email they simply put me their BLOCK list. All of my emails are now
automatically bounced. I only sent them one email and it was very
polite. My website is gone. My data is gone. All of my files are
gone. The loss of time and effort combined with damage to my business
is unforgivable
I use a SQL Server 2000 and I am trying to use function instead of a ad hoc query because I REALLY have to do it, but some issues must be solved. SQL Server is using a optimal execution plan when I run query and the worst execution plan for function.
Here are the informations you might need to help me:
Code Snippet name description keys IRES_CPF clustered located on PRIMARY CPF_CNPJ IRES_IMPED nonclustered located on PRIMARY IMPEDIMENTO
PERFORMANCE INFO
QUERY - it takes 2s to run and server makes an index seek on IRES_CPMF index
Code Snippet select 'query ad-hoc',* from IRES where CPF_CNPJ = '000002230' and TIPO = 'F'
EXECUTION PLAN Clustered Index Seek(OBJECT:([bmcires].[dbo].[IRES].[IRES_CPF]), SEEK:([IRES].[CPF_CNPJ]='000002230'), WHERE:([IRES].[TIPO]='F') ORDERED FORWARD)
FUNCTION - it takes 20s to run and server makes a index scan on IRES_IMPED index!!!!
Code Snippet CREATE FUNCTION fn_ires_crivo ( @cpfcnpj nvarchar(9) ) RETURNS table AS RETURN ( SELECT CPF_CNPJ, TIPO, IMPEDIMENTO, GRAU, DT_ULT_OCOR FROM dbo.ires WITH (INDEX (IRES_CPF) NOLOCK) WHERE CPF_CNPJ = @cpfcnpj and TIPO = 'F' ) go
I am trying to connect to a remote MSSQL database through a manager program called "SQL Manager Lite". The first thing that the wizard asks me is the "host name".
How do I find this host name? I just mention that I am trying to connect to a database on a shared hosting.
I'm in the midst of planning how to build an NT box to host SQL 7.0 and was wondering if there is any advantage to segregating the RAID 5 Array (5 x 18GB drives) into numerous *logical* partitions to separate database and log files (I can't see what advantage there would be if the disks are all on the same array, but..)
If anyone has any pointers or links to recommended NT configurations for hosting SQL, I'd appreciate hearing them.
hi, I change the PC name. so now @@servername returns the oldname. I try sp_dropserver and I got an error:
Msg 15015, Level 16, State 1, Procedure sp_dropserver, Line 42 The server '[IBM-E81EB247FF3]' does not exist. Use sp_helpserver to show available servers.
Hi all,I'm new to SQLServer (Express edition) so I was wondering: if the webhost supports SQLServer 2005 do I just need to move the .MDF file to mydirectory on the web host to be able to use it?Thanks,Lorenzo
I am looking for a free ms sql database for my programs, but i don't want to host it on my computer, because my web host does not allow servers to be run and people connecting to thme.
when I run the Query "Select @@ServerName" it is providing the server name which is not same as I connect to SQL Server.example : My SQL Server Name is "XXX123" and when I run the above query it is Printing as "YYY123"
I am trying to send files over to an ftp server on Mainframe using scripts that is provided in this link, but I can't get it to work. The problem is the sendfile method concatinates the source file name to the MVS dataset name which causes the issue.
Here's my code (FTPConn is a connecation mgr for FTP):
Imports System
Imports System.Data
Imports System.Math
Imports Microsoft.SqlServer.Dts.Runtime
Public Class ScriptMain
Public Sub Main()
Dim mgr As ConnectionManager
mgr = Dts.Connections("FTPConn")
Dim conn As FtpClientConnection
conn = New FtpClientConnection(mgr.AcquireConnection(DBNull.Value))
Dim toFiles As String
toFiles = "ftpp.a.b.xxxxx.yyyyyy.int"
Dim fromFiles(0) As String
fromFiles(0) = "c: est.txt"
Try
conn.Connect()
conn.SendFiles(fromFiles, toFiles, True, True)
Catch ex As Exception
Finally
conn.Close()
End Try
Dts.TaskResult = Dts.Results.Success
End Sub
End Class
Output:
SSIS package "Package.dtsx" starting.
Error: 0xC001602A at Package, Connection manager "FTPConn": An error occurred in the requested FTP operation. Detailed error description: 200 Representation type is Ascii NonPrint
200 Port request OK.
501 Invalid data set name "ftpp.a.b.xxxxx.yyyyyy.int/test.txt". Use MVS Dsname conventions.
Hi, I'm using SqlServer 2000 at a web host, and share this db with about 200 others (it's an inexpensive web host so I guess there is not very much traffic on most of them, but I can only see their db IDs so I don't know what organisations they are or the urls they have). Usually, my web site runs fine, but lately it's really really slow (as in non-functioning in reality). I'm in the middle of coding my seach functionality, so I fear that I'm causing this myself. ;-) However, there are only ten posts in my test db, so it should be a piece of cake for SqlServer. The other .aspx pages runs rather slow too now, but when I start a programming session they have worked fine (this has happened three times now so I don't know what to conclude). When the server slows down, it can stay down for hours. I've also tried to access my site from other computers but get the same result, so I guess it has nothing to do with caching (I also tried emptying my browser's - IE7 - cache). I have several asp web sites with Access dbs at the same web host, and they all work fine. In addition, I have no problem viewing and editing my db at the web host via SqlServer Management Studio Express. What do you think of this problem? Should I go for a more expensive web host? Should I give them the "It's not you, it's me" speech? ;-) Or is it really me? Below's my search code, and as you can see, there are some integers there to make sure the loops don't run ad infinitum. I don't really think the problem actually lies with my search code, as everything worked well a week ago, but I don't know... BTW, if you think my code can run much faster without getting too tricky, please let me know. Please help! Pettrer If Page.IsPostBack Then Dim soktext As String = Trim(SokTextBox.Text) + " " Dim tillagg As String = "" Dim varv As Integer = 1 Dim loopvarv As Integer = 0 soktext = Replace(soktext, vbCrLf, " ") 'vbCrLf = mellanslag i VB-terminologi Do While InStr(soktext, " ") And varv < 100 soktext = Replace(soktext, " ", " ") loopvarv += 1 Loop While Trim(soktext).Length > 0 And varv <= 20 'Loop för att identifiera ord och lägga till dem i sqlsatsen, ett i taget Dim icke As String = " "
Dim ordet As String = soktext.Substring(0, soktext.IndexOf(" ")) 'Det godkända ordet läggs till i tmp-strängen soktext = soktext.Remove(0, soktext.IndexOf(" ") + 1) 'Tar bort det som just använts (eller varit för kort) If ordet.Length > 1 Then 'Blanksteg och ensamma bokstäver förhindras att komma med i sql-satsen If ordet.StartsWith("-") Then 'Det är ett minusord icke = " NOT " 'I sqlsatsen blir det alltså AND NOT (...) ordet = ordet.Remove(0, 1) 'Tar bort minusttecknet från söksträngen End If tillagg += " AND " & icke & " (artistnamn LIKE '%" & ordet & "%' OR " & _ "beskrivning LIKE '%" & ordet & "%' OR " & _ "kulturhemvist LIKE '%" & ordet & "%' OR " & _ "kontaktnamn LIKE '%" & ordet & "%') " End If varv += 1 End While Dim kat As String = "" If KategoriDropDownList.SelectedValue <> 0 Then kat = " AND (kategori1 = " & KategoriDropDownList.SelectedValue & _ " OR kategori2 = " & KategoriDropDownList.SelectedValue & _ " OR kategori3 = " & KategoriDropDownList.SelectedValue & _ " OR kategori4 = " & KategoriDropDownList.SelectedValue & ") " End If Dim lan As String = "" If LanDropDownList.SelectedValue <> "alla" Then lan = " AND lan = '" & LanDropDownList.SelectedValue & "' " End If ResultatDataSource.SelectCommand = "SELECT DISTINCT TOP 200 folknuID, kategori1, kategori2, kategori3, kategori4, initial, artistnamn, lan, kontakthemsida, kategori1, (COALESCE(audio1,'') + COALESCE(audio2,'') + COALESCE(audio3,'')) As audio, (COALESCE(video1,'') + COALESCE(video2,'') + COALESCE(video3,'')) As video, (COALESCE(pressbild1,'') + COALESCE(pressbild2,'') + COALESCE(pressbild3,'')) As pressbild " & _ "FROM Mytable " & _ "WHERE shown = 1 AND shownadm = 1 " & _ tillagg & _ kat & _ lan & _ "ORDER BY initial" ResultatLabel.Text = "SelectCmd: " & ResultatDataSource.SelectCommand ResultatGridView.DataBind() End If '*** på sökkoden
Are there any restrictions, limitations or anything to prevent the use of SQL Express database being used with my ASP.NET 2.0 application on a public web host? If so, what are they? Thanks.
HiAs i have read, there have been discussions before how to move a local MDF databas to MSsql server at a webhost.But i cant figure it out, i know the answere is out there but i cant find it.I have downloaded the Host Deployment tool that generates a .sql file from my database, it looks ok.The problem is that my host dont allow me to execute this. I have also tried to run a file called RunSql.aspx that should help me execute my .sql file.But i recieve errors Opening url http://mydomainz1.com/mydbfile.mdf.sqlAn error occured: System.Net.WebException: The remote server returned an error: (404) Not Found. at System.Net.HttpWebRequest.GetResponse() at ASP.runsql_aspx.__Render__control1(HtmlTextWriter __w, Control parameterContainer) in d:hsadminaccoundidmydomainz1.comRunSQL.aspx:line 58The line 58 is empty Is there anyway that a mdf file that i have build in VWD 2005 can work as a standalone database?I would like it to be as a .mdb database that is simple to move and so on. Or do the mdf database have to have a MSsql Express or a MSsql Server? Grateful for help! / mitmit
I have a DNN install on my local PC that I would now like to transfer to my remote host server. What is the best way to do this? I have exported the db locally but see no way to import it on the host.
I created a sqlexpress database in visual studio 2005 and can't figure out to move the database to my hosting company( godaddy ). I can't connect remotely to the database on my hosting company. Whats the best way to go about this?
At work, we are in the process of moving a server running SQL Server 7 from one domain to another. A part of this domain change will necessitate that the server be renamed. In a couple of tests that we ran we found that changing the domain does not cause problems, but changing the server name does. How does one register the databases with the new server name without reinstalling everything from scratch?
Any assistance would be greatly appreciated as we are under a time crunch here. Please reply to my email as I am unable to check this board often.
Has anyone developed a workaround to have SQL 6.5 and SQL 7.0 simultaneously active on the same NT 4.0 Server host. The use of VSWITCH.EXE to switch between SQL 6.5 and SQL 7.0 in not an acceptable solution. There are several applications that are only supported under SQL 6.5 and will not be upgraded to SQL 7.0 for another 3 to 6 months.
There are other applications (ERP and data mart) that were developed specifically for SQL 7.0 to take advantage of its new DTS, OLAP, and query capabilities.
All these applications need full-time access to their respective databases.
The obvious solution is to host SQL 6.5 and SQL 7.0 on separate servers. The client has a "monster" database server which would be too expensive to duplicate. Using a "standard" PC to host SQL 6.5 would significantly compromise performance of those applications.
Any advice or suggestions would be appreciated.
Andrew Dominguez, IMS ajd@cwix.com 909.625.4066 / 7826 fax
I have change the name of my host by "network neighborhood" and user sp_dropserver and sp_addserver. But when rebooting the host, I have this following message.
"Your SQL Server installation is either corrupt or has been tampered with (unknown package id). Please run setup."
But I change the name of the hostanme to the former name, there is no error.
My reseller web host (DIY) migrated a few weeks ago to a new data center. Unfortunately, my MS SQL databases were not migrating properly. (as well as other things). I have multiple sites that are not functional due to problems with their migration.
When I looked at some of the databases, the table structure had been migrated, but not the data and apparently something else.
Some of the databases of this error when trying to access it: --- error --- Error for database: DATABASENAME Microsoft OLE DB Provider for SQL Server error '80040e37' Invalid object name 'TABLENAME'. --- end error---
Some of the databases I can actually access but get:
Microsoft OLE DB Provider for SQL Server error '80040e2f' Cannot insert the value NULL into column 'TABLENAME', table 'DATABASENAME.dbo.TABLENAME'; column does not allow nulls. INSERT fails. Everything in all databases worked perfectly before the migration.
They tell me that they have done what they can. They tell me that they are at the mercy of Psoft who assisted with the migration.
Does anyone know of anything that can my host that can help them figure out the problem.
I was trying to allow remote user to access sql server 2005 database.I have done configuration and tested on my computer,it works well.But from other computer,I can not use the new user to login.
Hi. I have a client with a database hosted on SQL Server 2005. I don't have a paid version of SQL Server at home so am just using SQL Server Express. I'm getting INCREDIBLY FRUSTRATED that I can't use the "copy database" wizard from SQL Server Express.
Am I just out of luck on this? I can't use the "copy database" feature since I'm using Express. I can't get the actual files since the database is on a shared server. I know I'm not the only person with this issue; I see people asking the question but I don't see any answers.
Hi, I've been a SQL Server dba for about 10 years, so i know SQL quite well. I've recently started using VWD express, and as it says, its quick and easy to create a website, which I've done. It all works great on my local machine. I've just signed up with an isp and duly ftp'd the project files plus the mdf and ldf that lives in App_Data into their content area, and rather naively I expected it all to work. The pages come up fine until some database access is called for, then i get the seemingly infamous error:
I've researched this for 2 solid days now, examined forums and posts, followed advice and enabled protocols and so on. Support at the isp in question does not really have a clue about databases and connections strings. Then I started looking closely at the words used by the isp's, none of the isp's explicitly say they support sql 2005 express. They do say SQL 2005, but not express. They do say VWD Express, but not SQL 2005 Express. So does anyone know what is/is not possible with regard to deployment of SQL 2005 express. Does anyone have experience of running SQL express on a production server, or a shared hosters machine? Its been out now for nearly a year I think, so hopefully someone has the answer.
VPC is configured to use the wireless card on the host. Firewalls on both systems are completely disabled. Machines can ping each other. Both machines can access the Internet. I can browse the SQL Reporting Services Web Site on the Host from the Guest. Host SQL Install has remote connections enabled. If I browse for Network server from teh connect dialog on teh Guest, it finds the Host.
Why can't I connect to the Databse Engine on the Host from the Guest? I have tried both TCP/IP and Named Pipes and both show a connection failure. (Not a login failure)
If it matters, the Guest OS also has a SQL Database Engine running. But I don't know why that would stop me from connecting to a remote instance.
I am very confused. I've finally gotten everything to work the way I want on my pc, but when I ftp to the Internet (URL is hosted on GoDaddy), everything goes haywire. I had to create a new database on the host server, and when I use an aspx login, I get the following message:
The SSE Provider did not find the database file specified in the connection string. At the configured trust level (below High trust level), the SSE provider can not automatically create the database file.
I know what the connection string to the database is, but where do I enter that information? I'm obviously new at asp.net and sql, and I need major help.
Hi All, i am trying to host the system.messaging.dll in SQL Server. I get the usual warnings about not being fully trusted. I am prepared for MS not supporting. But, when i execute my trigger (which writes to message queue), the trigger fails with an exception of 'That assembly does not allow partially trusted callers'. So. is there no way for me to write to MSMQ using triggers? Do i have to rethink my strategy?
imports System.Messaging
Dim msmq As MessageQueue = MessageQueue.Create(".TestQueue", False)
HiI am having trouble connecting to aspnetdb on the shared host. On my local server this is my connection string which works fine: <add name="MyLocalSqlServer" connectionString="Data Source=.SQLExpress;Integrated Security=SSPI;Initial Catalog=aspnetdb;User Instance=false"providerName="System.Data.SqlClient" />But, this doesn't work on the host (just putting in host address):<add name="MyLocalSqlServer" connectionString="190.40....232,1444;Integrated Security=SSPI;Initial Catalog=aspnetdb_booksale;User Instance=false"providerName="System.Data.SqlClient" />,and I get the error :Login failed for user ''. The user is not associated with a trusted SQL Server connection.so I put in the user id and password that i used when I created the aspnetdb_booksale db<add name="MyLocalSqlServer" connectionString="Data Source=196....232,1444;Integrated Security=False;User ID=aspnetdbbooksale; password=amanda;Initial Catalog=aspnetdb_booksale;User Instance=false"providerName="System.Data.SqlClient" />and I get the error:The ConnectionString property has not been initialized. Any ideas for me?Amanda
I have a page that connects to SQL server. It works fine when running in local host but when I publish to the server, I get the following: An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) Any ideas on where to start? Thanks,Mark
Hi, I have a hard time copying my db (or instance?) from a SQL Server 2000 db which resides at my web host. I have Sql Server 2005 Express and Sql Server Management Studio Express on my computer and, well, there is no "ftp-like" option so I don't have a clue about how to proceed. I've read many posts on the net on this matter but nothing seems to apply to this, in my mind, rather common, configuration. I have receieved Excel docs that should be appended to tables in my db. I have successfully installed DTS (see http://mobiledeveloper.wordpress.com/ for details - it's really simple but takes two hours) so I have a wizard for the actual import from Excel. My plan is now to 1. download/detach/whatever my table/db/part of the web host's db and download it to my computer. Then 2. fill the tables with the data from Excel. And finally, to 3. upload/attach/whatever my local db or table to the web host again. I'm sooo confused, please, please help me out here! Pettrer
Hey I've been trying to upload a sql express database to my webserver with out much success :( When I upload it I get permission problems so I think anyway I've been reading around and it looks like i'm stuck with having to let the server create the database file again Is there anyway i can upload this file to the webserver and get it working 100%?
Hi,What is the preferred way to maintain SQL tables on a remote host?I am a newbie to building ASP.NET websites on a remote host.A stumbling point has been the maintenance of SQL tables on the remote host.I understand about doing complete backup and restores,but I am seeking a quicker way to maintain individual files.I would like to click and edit but instead am going through the following 30+ clicks.Is there a easier way?Thanks. For example, what I do now to build a new data table for a hosted website.1) Design table 1a) Name 1b) Fields & Types 2) SQL Server Management Studio Express (assuming existing database) 2a) Select Database & Tables 2b) Add new table 2c) Add fields, Key must be INT for ACCESS 2d) Save as (Name_Table) 3) MS Access (requires ODBC to be setup first through the Windows control panel) 3a) Tables / New / Link / ODBC /Machine_Data_Source 3b) Pick table 3c) Edit data, as needed 4) To transfer data, first:Select the database in the VWD solution explorer, then right-click and select the new "Publish to Provider" 4a) Database Publishing Wizard 4b) Choose table to script a backup from 4c) Build script & Copy 5) Start Ipswitch FTP ( this step can be rplaced by 6e below) 5a) locate folder & sql script file and choose destination directory 5b) Transfer file 6) Login to remote host host (1and1) 6a) MS SQL Administration 6b) Admin (MyLittleTools Admin) 6c) Tools 6d) Quey Analyser 6e) Paste script (from step 4) 6f) Submit (Run) 6g) Verify table built FYI: Script to build and populate the new table "Name_Table"Built by step 4c above, pasted into remote Hosts Query Analyzer by step 6e above. /****** Object: Table [dbo].[Name_Table] Script Date: 10/28/2007 18:03:58 ******/IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Name_Table]') AND type in (N'U'))DROP TABLE [dbo].[Name_Table]GO/****** Object: Table [dbo].[Name_Table] Script Date: 10/28/2007 18:03:58 ******/SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGOIF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Name_Table]') AND type in (N'U'))BEGINCREATE TABLE [dbo].[Name_Table]( [ID] [int] NOT NULL, [Name] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [Address] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [City] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [State] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [Zip] [nchar](10) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [Acsz] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [Phone] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [Fax] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, CONSTRAINT [PK_Name_Table_1] PRIMARY KEY CLUSTERED ( [ID] ASC)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON))ENDGOINSERT [dbo].[Name_Table] ([ID], [Name], [Address], [City], [State], [Zip], [Acsz], [Phone], [Fax]) VALUES (1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL)INSERT [dbo].[Name_Table] ([ID], [Name], [Address], [City], [State], [Zip], [Acsz], [Phone], [Fax]) VALUES (2, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL)INSERT [dbo].[Name_Table] ([ID], [Name], [Address], [City], [State], [Zip], [Acsz], [Phone], [Fax]) VALUES (3, N'Third name', NULL, NULL, NULL, NULL, NULL, NULL, NULL)
Issues on Changing Name of our SQL Server Host Michael G (m1g@hotmail.com)
We are going to rename the Server machine Host Name that our SQL2000 (named instance) Server now resides on.
* I am searching for all references in Operating System items, such as .cmd, .bat. ftp files referring to it (eg., sqlservNM) * I am searching for all references in Operating System items, such as ODBC, VB ADO, DOA and DSN-less connections that refer to it. These references will be changed manually on the day of the change.
I am NOT so certain that I need to search for all SQL Server Objects referring to it, (eg., DTS packages and scheduled Jobs). Must these objects be changed manually or will they be redirected somehow?
