Putting SQL Server 05 Database On GoDaddy Server. Argh!!!
Apr 5, 2007
I have a simple Website and Database created in VWD exp.
I've just added a windows account to GoDaddy.com.
Unfortunately there is no way to port your database on to the GoDaddy server directly, but it says you must instead, recreate the database by copying and running SQL statements from a file called "personal-add.sql". (their "help" page: http://help.godaddy.com/article.php?article_id=695)
I can't find any such file. Can someone please let me know what I'm missing here?
Thanks.
View 4 Replies
ADVERTISEMENT
May 1, 2008
Hello, we have the hosting account with GoDaddy Server. We have using Visualstudio.net and MSSSQL Server 2005.
For hosting the files for the remote server ( Godaddy ) we are using FTP Cute client to upload the files. For Uploading a database they given a seperate login and we are hosted my data as a Transact SQL File. Up to this its going fine.
After that I want to retrieve my data from GoDaddy Database server. They are not allow the remote connections directly. But they told to use the File DSN to retrieve the data from thier server ( GoDaddy Server ). I don't Know how to use thier File DSN to connect My ASP.Net 2.0 Application to thier GoDaddy Database Server.
If I asked to GoDaddy Support team they are sending this file.
Connecting to a Microsoft SQL Server Database Using ASP/ADO
View 10 Replies
View Related
Mar 13, 2000
I missed the days of 6.5 when I can take a database from one server create a device for LOAD on another sever and use the LOAD database command to put that database on another server that has MS SQL SERVER on it..
So what is the trick with 7.0 if DTS is out of the question??
View 4 Replies
View Related
May 30, 2006
Hi,I'm accessing a pair of databases with ASP/ADO,and using stored procedures on the first access.The first access works OK - everything gets writtento where it's supposed to be.On attempting to write to a pair of database tablesin the second database (second access attempt),the server crashes, as does the app, and I get the following error:--------------------------------------------------------------------Server Error in '/Webfolder01' Application.Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.Exception Details: System.Data.SqlClient.SqlException: A transport-level error has occurred when receiving results from the server. (provider: Shared Memory Provider, error: 0 - The pipe has been ended.)--------------------------------------------------------------------After this, I have to go into the services panel and restart SQL 2005.This doesn't happen if I use small test data sets in the first access,and I can comment out the second access attempt, and the first accessexecutes just fine with both the large and small data sets,so I'm thinking that this has something to do with synchronisation:Perhaps the second attempt is being made before the server is ready.Is there something that I need to do to make certain that SQL 2005is ready to receive data?I'm using SqlBulkCopy with both accesses, but I don't see how thatcould be a problem.--------------------------------------------------------------------[SqlException (0x80131904): A transport-level error has occurred when receiving results from the server. (provider: Shared Memory Provider, error: 0 - The pipe has been ended.)] System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) +857370 System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) +734982 System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) +188 System.Data.SqlClient.TdsParserStateObject.ReadSniError(TdsParserStateObject stateObj, UInt32 error) +556 System.Data.SqlClient.TdsParserStateObject.ReadSni(DbAsyncResult asyncResult, TdsParserStateObject stateObj) +164 System.Data.SqlClient.TdsParserStateObject.ReadPacket(Int32 bytesExpected) +34 System.Data.SqlClient.TdsParserStateObject.ReadBuffer() +30 System.Data.SqlClient.TdsParserStateObject.ReadByte() +17 System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) +59 System.Data.SqlClient.SqlBulkCopy.WriteToServerInternal() +1327 System.Data.SqlClient.SqlBulkCopy.WriteRowSourceToServer (Int32 columnCount) +916 System.Data.SqlClient.SqlBulkCopy.WriteToServer(DataTable table, DataRowState rowState) +176 System.Data.SqlClient.SqlBulkCopy.WriteToServer(DataTable table) +6 Database_control.DB_ctrl_class.load_datatable_to_DB_table(DB_ref_class src_table) in i:Virtual WebfoldersDBctrl.cs:978--------------------------------------------------------------------THANK YOU VERY MUCH!!!
View 4 Replies
View Related
Dec 29, 2006
I don't know if this is unique to GoDaddy: I found the program for working with a MySQL database very intuitive (to the point of compliments). Today I started work with ASP.NET and SQL, and when I went to work with SQL Server (on GoDaddy), it wasn't intuitive, and there was almost nothing on which to click. By chance might there be a tutorial that would help a person who needs to work with SQL Server on a provider like GoDaddy?
View 4 Replies
View Related
Jan 31, 2006
Where can I further educate myself on this subject?
Right off from the start I would assume that installing SQL Server 2000 or 2005 on Windows Server 2003 that is set up as a web server hosting a website would be against "best practices." Is my assumption right?
Common sense tells me to not to host a website on a pc that is also hosting my database.
View 4 Replies
View Related
Oct 12, 2007
Hello,I just got a personal site with godaddy that I would like to be able to connect to using SQL Server management studioI try to connection using Server Name: sdhfuh928323984ujf.phx3.secureserver.netauthentication: sql serverUsername: my usernamepassword: my passwordThen it tries to connect and gives me an error that I can't and remote connections may not be allowed. I followed the directions it gave and turned on remote connections, restarted the server, but I still get the error.any ideas?
View 3 Replies
View Related
Mar 5, 2007
Facts:1. I am using my account on Godaddy trying to connect to my sql server db.2. I can get into my db using user id and password.3. Godaddy's help file shows this for a connection string: connectstr = "Driver={SQL Server};SERVER=" & db_server & ";DATABASE="
&db_name & ";UID=" & db_username & ";PWD=" &
db_userpassword4. My connection string: "Server=whsql-v09.prod.mesa1.secureserver.net;uid=dbasolutions;pwd=***;database=DB_87972;" & _ "Trusted_Connection=False providerName=System.Data.SqlClient"{password **** out}5. Get error message 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) I tried to email Godaddy's help desk with this information. There first response: We do not allow remote connections to our sql server database.There second response was to read the help file!Does anybody have any suggestions? Thanks in advance,bswanson
View 1 Replies
View Related
Nov 7, 2006
I have a vb.net web page which I created (a shopping cart). I created this site using vb.net 1.1 and SQL 2000 on my laptop. On my laptop everything works properly, but when I tried moving it to GoDaddy (http://currahee3-506.org/px/default.aspx). In the code, each query to the SQL server is done using stored procedures.
When you first go the page, a drop down is presented. When you select "Shirt" from the category drop down. A second drop down menu is then displayed and will let you select what type of shirt you are interested in purchasing. Select Polo Shirt Without Pocket. Upon doing so, I receive an error message:
Invalid object name 'tbl_LookupCategory'.Invalid object name 'tbl_pxProducts'.Invalid object name 'tbl_LookupColor'.Invalid object name 'tbl_LookupSizes'.Invalid object name 'tbl_pxQtySold'.Invalid object name 'tbl_pxImages'.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. Exception Details: System.Data.SqlClient.SqlException: Invalid object name 'tbl_LookupCategory'.Invalid object name 'tbl_pxProducts'.Invalid object name 'tbl_LookupColor'.Invalid object name 'tbl_LookupSizes'.Invalid object name 'tbl_pxQtySold'.Invalid object name 'tbl_pxImages'.Source Error:
Line 143: sqlCommand.Parameters.AddWithValue("@str_ItemName", Trim(DDL_Items.SelectedItem.Text))
Line 144:
Line 145: Dim dataReader As SqlDataReader = sqlCommand.ExecuteReader(CommandBehavior.CloseConnection)
Line 146:
Line 147: dl_Description.DataSource = dataReader
Source File: d:hostingcurraheepxdefault.aspx Line: 145
Keep in mind the Stored Procedure works in my testing environment, but not on GoDaddy. I moved the selected statement into a view on the GoDaddy SQL server, and the view worked perfectly. The tables do exist on the GoDaddy SQL Server.
This is the Stored Procedure:
CREATE PROCEDURE [dbo].[sp_GetItemInfo]
@str_ItemName VarChar(50)
AS
SELECT TOP 100 PERCENTtbl_pxProducts.int_ItemID,tbl_pxProducts.str_ItemName,tbl_pxProducts.int_RetailPrice,tbl_pxImages.str_SmallImageURL,tbl_pxImages.str_MediumImageURL,tbl_pxImages.str_MediumImageBackURL,tbl_pxImages.str_LargeImageBackURL,tbl_pxImages.str_LargeImageUrl,tbl_pxImages.str_SmallImageBackURL,tbl_pxProducts.int_Quantity - tbl_pxQtySold.int_QtySold AS int_QtyAvailable,tbl_LookupCategory.str_Category,tbl_pxProducts.Int_SizeID,tbl_LookupSizes.str_Size,tbl_pxProducts.Int_ColorID,tbl_LookupColor.str_Color
FROMtbl_LookupCategoryINNER JOINtbl_pxProductsONtbl_LookupCategory.int_CategoryID = tbl_pxProducts.int_CategoryIDINNER JOINtbl_LookupColorONtbl_pxProducts.Int_ColorID = tbl_LookupColor.int_ColorIDINNER JOINtbl_LookupSizesONtbl_pxProducts.Int_SizeID = tbl_LookupSizes.int_SizeIDLEFT OUTER JOINtbl_pxQtySoldONtbl_pxProducts.int_ItemID = tbl_pxQtySold.int_ItemIDLEFT OUTER JOINtbl_pxImagesONtbl_pxProducts.int_ItemID = tbl_pxImages.int_ItemID
WHERE(tbl_pxProducts.int_Quantity - tbl_pxQtySold.int_QtySold > 0)AND(tbl_pxProducts.str_ItemName = @str_ItemName)
ORDER BYtbl_LookupSizes.str_Size
Does anybody have any suggestions as to why this stored procedure is failing?
View 1 Replies
View Related
Feb 2, 2006
I'm trying to put a date into a SQL Server table. The database field type is "smalldatetime". The variable dDate is type "date" and contains: 2/2/2006 (although I think Cdate actually converts it to: #2/2/2006#). When I run the following code the date in the database is always ends up being: 1/1/1900.
Dim cmd As SqlCommand = New SqlCommand("INSERT INTO MyTable(MyDate) " & _ "VALUES (" & dDate & ")", SqlConn)daAppts.InsertCommand = cmddaAppts.InsertCommand.Connection = SqlConndaAppts.InsertCommand.ExecuteNonQuery()
Any other field types work fine, it's just dates that aren't working ???? Can someone please provide a code snippet showing me what I'm doing wrong??
View 3 Replies
View Related
Oct 7, 2015
Need getting data into XML format as shown in the last code block.The datatypes and table structures are pretty much fixed, but I can re-hash data into another Temp Table, CTE, etc..This is a server running SQL Server 2012, but I'd guess any version that understands FOR XML PATH should be fine.
Source tables and data
if object_id('Tempdb..#Element1') is not null drop table #Element1;
create table #Element1 (
[Attr1] varchar(10)
,[Attr2] varchar(4)
[code]...
View 9 Replies
View Related
May 5, 2005
Hello,
I created this DataTable, add rows of data to it, and then display the data on to a form via a repeater.
Dim ds As DataSet = New DataSetDim dtTableName As DataTable = New DataTable("dtTableName") dtTableName.Columns.Add("Description")dtTableName.Columns.Add("ItemNumber")dtTableName.Columns.Add("Quantity")dtTableName.Columns.Add("Price")ds.Tables.Add(dtTableName)
What I need to do now is create a table in SQL Server and update the database with the data I've collect in my dataset. How do I bind and update this data to a sql server table?
Thanks!James
View 1 Replies
View Related
Jan 28, 2015
how can i put multiple values in the variables.
for eg:
Declare @w_man as varchar
set @w_man = ('julial','BEVERLEYB', 'Lucy') and few more names.
I am getting syntax error(,)
View 5 Replies
View Related
Jan 30, 2015
I am building a query. I have a table with 4 columns and need to try and put the times together. There are some inconsistencies with this, and i'm hoping to exclude them.. Here is a sample table:
Function | Employee | DateTime
--------------------------------------------
1 | 1 | 1/30/2015 1:47 PM
2 | 1 | 1/30/2015 1:49 PM
2 | 1 | 1/30/2015 1:50 PM
3 | 2 | 1/30/2015 1:37 PM
3 | 2 | 1/30/2015 1:39 PM
3 | 1 | 1/30/2015 1:40 PM
4 | 1 | 1/30/2015 1:42 PM
4 | 1 | 1/30/2015 1:45 PM
Function 1 = Clock In Type 1
Function 2 = Clock Out Type 1
Function 3 = Clock In Type 2
Function 4 = Clock Out Type 2
Basically what I need to do is take the time from rows with Function 1 and match it with Function 2 so I can get a total time of the clock in. Function 3 rows need to match up with Function 4 rows so I can get another set of total times. There may be more clock in rows then clock out rows or more clock out rows then clock in rows, and there may be multiple clock ins & outs per day per employee. I'm basically trying to get totals for each Clock In/Out type.
View 8 Replies
View Related
Jan 10, 2006
hi guys,
Could any one tell me whats the best way to put encypted data into a table.i have a textfield that a single integer is entered into it. It is then encrypted using DES encrption algorithim.It converts the value to byte(Convert2ByteArray method) I pass the data to a stored procedure which converts it to char before inserting it into the table. when i checked the database all it entered was System.Byte[]. Does anyone know where im goin wrong?
Mairtin
View 3 Replies
View Related
Sep 20, 2006
I had an idea to put all my web design settings, css text and web content in the database..This way it would be easy for others to edit remotely. Do you guys think this would have an impact on performance if I do this?
View 7 Replies
View Related
Feb 18, 2006
hii all;
My question is from 2 sections:
1- Is it secure to put user accounts (userName and password ...) on the database?
2- How can I set username and password for SQL server 2005 express file?
Thanks
View 5 Replies
View Related
Nov 18, 2002
How do you put the master database in single user mode if you want to restore it. the options in the permissions are greyed out? Thanks
View 2 Replies
View Related
Dec 5, 2007
We recently had a problem were a webserver lost connection to sql 2000 database after we put in a new router. When we failed back to old router it was able to connect to database again. It is using a non standard port 2125 to connect to sql database. Why would a new router cause connection problems to a database.
View 4 Replies
View Related
Mar 9, 2007
I've got a report with several cascading parameters. When I preview the report, everything works fine. However, when I deploy the report, the very first (and thus the rest) of the cascading parameters is greyed out. Any idea what's going on?
I am passing one unrelated parameter into this report, and I also have three non-cascading parameters before this one, but none of them are used in the queries for the cascading parameters. They also appear correctly at the top of the report.
This is rather frustrating since the preview works fine -- making it pretty difficult to debug the issue!
View 3 Replies
View Related
Sep 27, 2006
First of all i do not know whether this is the right form to ask the question Let me describe the scenario iam using Iam generating xml files at a particular place and sending them to a server xml1|--------------------->dataset1------------------------------>adapter1.update(dataset1)xml2|----------------------->dataset2----------------------------->adapter2.update(dataset2)xml3|----------------------->dataset3------------------------------>adapter3.update(dataset3) all the three updates should happen in only one transaction if any one of the update fails then the transaction should rollbackcan anyone tell me a way to do iti am desperately in search of any ways to do it can anybody help please
View 2 Replies
View Related
Feb 6, 2004
I know this is probably user error, but here's the scoop:
I have a stored procedure...
CREATE PROCEDURE [dbo].[sp_Build_CurrentPortfolio_By_Date]
@NewDate smalldatetime
and when I try to run it in debug in the SQL Query Analyzer, I sent in the parameter via the debug interface as '2004/02/02', and as GETDATE(), and a number of other formats, but cannot even get into the procedure once debugger starts up!
I get the following error once I hit "execute" after putting in the above data in the parameter text box...
[Microsoft][ODBC SQL Server Driver]Invalid character value for cast specification
HELP PLEASE!!! (I'm about to punch my new monitor!!!)
View 2 Replies
View Related
Nov 18, 2005
I was wondering if anyone successfully managed to connect to the
asp.net 2.0 features (specifically authentication) with goDaddy. They
allow you to set up the schema for 2.0 in the SQL server, but I have
yet to manage to actually CONNECT to the SQL server using VS.NET 2005.
Anyone have any suggestions? Experiences?
View 1 Replies
View Related
Feb 12, 2006
CREATE TABLE [Sites]( [SiteID] [int] IDENTITY(1,1) NOT NULL, [SiteName] [nvarchar](500) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL, CONSTRAINT [PK_Sites] PRIMARY KEY CLUSTERED ( [SiteID] ASC)WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY]) ON [PRIMARY]GOWhat's wrong with that? Why won't godaddy take that?
View 5 Replies
View Related
Jul 13, 2007
Hello,First, I tried to find the answet to this question, but no luck - so I decided to post it.
When I was creating my applications in asp.net - for the first time I decided to start using external DataSets. I think they are great and work very nice!But once I pushed the application to GoDaddy, I got an error of this nature:I was trying to access the exterbal dataSet like this:Dim productsAdapter As New NorthwindTableAdapters.ProductsTableAdapter()
Dim products as Northwind.ProductsDataTable...And got an error saying that it couldn't find this type (but it worked fine on my local machine in visual studio).So did I miss something that prevented this application working on GoDaddy? or there are some limitations on GoDaddy? ...or something else.Thank you for looking into this for me.Valera
View 7 Replies
View Related
Jul 22, 2007
Hi all, I'm a newbie of SQL. I built a website using SQL 2005, and the data control was using a dataset and wizard,now when I'm uploading the website + database,I learned godaddy doesn't support database uploading.I have to create an empty SQL database on godaddy's sql server, and reDir the connection in config file. my question is, where should I copy my dataset commands to godaddy's sql server?2nd, how do I invoke them in asp.net? thanks in advanceyonk
View 1 Replies
View Related
Aug 27, 2007
I know this has to be answered somewhere, I just need to know, am I going crazy. I have a shared webhost account at Godaddy. My web config was working at one point, but now I am getting this error:
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: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)
Now, If I were to look at this, its telling me that it cannot locate the server I am trying to connect to. Below is my connection string and the address I am getting this from is in my information at godaddy. Tell me, is there something that I am doing wrong here?
<connectionStrings>
<add name="Personal" connectionString="Server=whsql-v20.prod.mesa1.secureserver.net;Database=azwd30;User ID=XXXXX;Password=XXXXX;Trusted_Connection=False" providerName="System.Data.SqlClient" /><remove name="LocalSqlServer"/>
<add name="LocalSqlServer" connectionString="Server=whsql-v20.prod.mesa1.secureserver.net;Database=azwd30;User ID=XXXX;Password=XXXXX;Trusted_Connection=False" providerName="System.Data.SqlClient" />
</connectionStrings>
With the same user name and password, I can access the database through Godaddy's site and see my records, and the address 'whsql-v20.prod.mesa1.secureserver.net' is the same as whats on Godaddy's SQL configuration page, the database name is the same, I have double, triple and spent hours checking all that could affect this... I may just be burnt out using Godaddy. It seems I fix one thing, then there is another thing, I fix that, then there is another. I talk to support, and they say, they dont support anything that they have in their sales page for what they offer. I'd rather get support to say somthing like: "You may want to go to google and press the I'm feeling Lucky button. It would be probably be faster and cheaper than using our department, or you can upgrade to our virtual server and have a little more control, not total control but a little more ... what do you say mr Chris?"
Well, I feel almost a little better venting here. Since I have been with GoDaddy, and I live in the same city where they host their servers, I have been in shambles wondering how they can offer all that they do in their sales pitch and then drop a ball and say, we dont support 90% of what you read in the beginning. It almost wants to make you put a huge NoDaddy.com sticker in your back window and drive around town all day in gas with the same money you give to them. Ok, now I am done venting, any Idea's anyone.???
View 2 Replies
View Related
Apr 8, 2008
I've transfered a site recently from reinvent
hosting to godaddy, the site works, but the pages that retrieve ms sql
(2005) queries now load about 5-8 seconds longer than they did on
reinvent (which was basically instantly)... the guy who i talked to at
godaddy said that i need to change the links on the site from external
linking to internal linking... as far as i understand it all the links
are linking internally (not using somedomain.com/page.asp?var=param....
but using ?var=param, or page2.asp?var=param), unless there's a
different use of the term that i'm not familiar with... anyway i'm
confused what he meant by it... and the asp seems to be structured ok
(and as mentioned the sql did work perfectly fine on another hosting)..
it connects to the db, retrieves the data and puts it into the array,
then loops the array for printing to page... then closes the array/db..
i think that should work perfectly fine as it did on the other
hosting... but does anyone out there know a solution to fix this on
godaddy hosting, they say it's nothing with their sql server as they
checked it and it's fine... here's the site: pccti.com ... and the
slowness is when retrieving the healthcare/IT courses and then also
displaying course details... please help
View 1 Replies
View Related
May 19, 2006
Hi,
I have two sql db's. One for company record info, other for users (aspnetdb) I created the users one using the login control and web administration wizard. This all worked well until I had to publish to godaddy. I had to rebuild my company db, but eventually I was able to pull info and all that is working. The problem is, how the heck do I add users? I noticed that it put users table in my db to start. So I manually went into the db on godaddy's servers, and added an application. Then when I tried to add a user manually, it kept giving me errors. Is there an easier way to add website users through godaddy? Something like the web admin tool that comes with visual studio? Man it is driving me crazy!!!
View 10 Replies
View Related
Apr 13, 2007
Hello all,
I am hosting at Godaddy and using their SQL 2000.
Before, I used to use "Try, Catch and Finally" for my SQL connection. However, I received this error "Timeout expired. The timeout period elapsed prior to obtaining a connection from the pool. This may have occurred because all pooled connections were in use and max pool size was reached." so often that I changed it to "Using { .... }". Yes, the error doesn't come back as often as before.
Today, I encounter that problem again and my connection to the db is locked, because of that error. Is there away to prevent this from happening? Should I check to see if the connection is still opened before open another one? In case like that, if the connection is still opened, should I close it first before opening a new one OR can I use it too?
Any advice would be appreciated. Cheer ...
View 8 Replies
View Related
Apr 22, 2006
Everything works great on my development box. I am using GoDaddy for production (ASP.Net v2, SQL 2000).
I am not receiving any errors, so I am stumped; no data from the database is displaying on the GoDaddy pages.
I updated the connection string in web.config to this:
< add name="snsb" connectionString="
Server=whsql-vXX.prod.mesaX.secureserver.net;
Database=DB_42706;
User ID=username;
Password=pw;
Trusted_Connection=False" providerName="System.Data.SqlClient" / >
But I am unsure if this is the issue?? Any insights? This is the page I am working on: www.sugarandspicebakery.com/demo/bakery/default.aspx. So, the page displays fine, but it should be showing data from the database. This particular page uses a DataList with ItemTemplate. There is definitely data in the database, and I have even ran the same exact query from the code using the Query Analayzer on GoDaddt and it returned results
I know there isn't much info to go by, but I am hoping someone has some insight since I have been trying to figure this out for days now!
Thank youJennifer
View 2 Replies
View Related
May 5, 2006
Okay... GoDaddy's driving me nuts!!! Anyone... please help.
I am doing an insert into a database with:
INSERT blah blah blah; SELECT @@IDENTITY;
On EVERY OTHER SERVER I have tried this on (local SQLExpress 2005's and my companies various SQL2000 servers, this always returns for me the row number (of autoIndex number of the row just added to the database). My autoIndex was created with the following code:
ALTER TABLE sites ADD autoIndex INT NOT NULL IDENTITY (1,1) PRIMARY KEY
The code I have tried getting the identity with is:
cmd.CommandText = "INSERT blah blah; SELECT @@IDENTITY;";
string autoIndex = Convert.ToString(cmd.ExecuteScalar());
cmd.Dispose();
I also tried:
// bulding of SQL INSERT here
cmd.ExecuteNonQuery();
cmd.Dispose();
cmd = new SqlCommand(SQLDataSource_pics.SelectCommand, conn);
cmd.CommandType = CommandType.Text;
cmd.CommandText = "SELECT @@IDENTITY;";
string autoIndex = Convert.ToString(cmd.ExecuteScalar());
Session.Add("autoIndex", autoIndex);
Most of the time, I get a value of "0" (zero) for autoIndex. Every now an then (5%) of the time I get back a correct value.
I don't know where to go from here.
Thank you.
Hayedid
View 4 Replies
View Related
Jun 29, 2007
I have an application that utilizes aspnet for membership.
The application utilizes the same database (in SQLServer) for storage of other things. I have a view as follows:
USE [DB_Name]
GO
/****** Object: View [dbo].[Authorization] Script Date: 06/29/2007 15:27:25 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE VIEW Authorization
AS
SELECT dbo.Domain.Domain_ID, dbo.Domain.Domain_Name, dbo.Alias.Alias_Name,
dbo.Alias.Alias_Authority, dbo.Domain.Domain_ProcessType, dbo.Domain.Domain_Status,
dbo.aspnet_Users.UserName AS Owner_Name
FROM dbo.Alias INNER JOIN
dbo.Domain ON dbo.Alias.Alias_Parent_ID = dbo.Domain.Domain_ID INNER JOIN
dbo.aspnet_Users ON dbo.Domain.Domain_Owner_ID = dbo.aspnet_Users.UserId
This works fine locally. However, I am hosting this on GoDaddy and though it allows me to create the table, it seems to have a problem (I'm guessing because it is referencing differing schemas?) and I get an error of: Incorrect syntax near the keyword 'Authorization'.through the SQLServer Web interface whenever I attempt to view the data from this view.
I don't doubt that there is some kind of difference between the manner that SQLServer has set up the schemas and how they are set up on my local version.
Any help would be greatly appreciated. I am at a loss of how to get this info and truly want to utilize the view as it would improve performance over a query - at least I believe so. My thinking is that although there may be a performance drop when the item is being added, I gain on the back-end where I really need the performance over utilizing a query.
Thanks,
Steven Henley
View 3 Replies
View Related
