Search results for query: *

OK - You've been a big help regardless! Thanks

Sorry - also you are right on all points you listed above... db hosted on godaddy Access front end Import data to the db on the web

I'm dealing with about 5,000 rows of data right now but I expect that number could grow to 50,000 at some point.

One more question - I need a quick way to append data to my sql db on the web. Using an append query in Access takes litterally hours. Any ideas?

nvarchar worked - not sure why ntext didn't - maybe operator error. Thanks for the help!

Thanks George. I tried NText because I am using an access frontend and I'm afraid changing the data type to an nvarchar will blow up my queries and reports. I still get the ??? with the NText so I'm going to try the nvarchar anyway and see what happens

I have an SQL db hosted on godaddy. I need some of my table fields to handle both English and Chinese characters. I have imported some table data with both languages but the Chinese shows up as a bunch of (??????) question marks. Is there a setting I'm missing to make this work? My fields are...

Thanks for your help - the page works well enough now but I do have another question. I'd like to execute a query on the database that would download the results to a spreadsheet on my local machine or into a spreadsheet, CSV, or text file that I can then save to my local machine. I can put...

So how do you setup users for remote access?

Thanks - I'm getting closer. Now my connection string is correct to access the database on godaddy but I have integrated security setup on the website also. I've used the logged in view to allow users to make changes to the data. So now I can see the data but when I try to login I get another...

Ok I changed the connection string to include user name and password to access the godaddy db - now I get this error: Configuration Error Description: An error occurred during the processing of a configuration file required to service this request. Please review the specific error details...

Thanks I'll check this out - also the database on godaddy has a user name and password and I'm also using loginviews and security on the webpages will i need 2 connection strings 1 to access the database and the other to access the data?

I've created a website in visual studio 2005 that access a database and allows users to view, add, change, and delete data. I've hosted the site on godaddy - I realized that i had to import my database tables into the database i created on godaddy - now i need to change my connection string to...

I agree it would be better to code it myself but I lack the skill. Do you have a suggestion for a video or tutorial that would help me get started? Thanks

Ok, so now I can get the data to show in the gridview - set the auto-regenerate columns to "True". But now I lose my data formatting. I want to be able to set 2 columns to currency and 1 to a fixed number. Can I add formatting at connection time? <asp:SqlDataSource ID="SqlDataSource2"...

I've set up to GridViews on my page - 1 receives a parameter from a previously clicked page the other receives a parameter from the first GridView when a row is selected. The second one does not work. I think the reason is I do not have a mechanism for firing the data source for the second...

Thanks for the help - I'll investigate the options you suggested.

I'm using GP 8.0 and have gotten a message that "this company's database size is 1.90 GB. The limit is 2 GB. Remove history from your company, ... etc." I tried using the SHRINKDATABASE function to reduce the size of the DB and eliminate the message but it didn't work. What else can be done...

Thanks for the help!

Hi I dropped the ball on this a few weeks ago and am trying to get started again. Since you don't use tableadapters and so forth what do you use? To be honest your last thread was way over my head. If there is an easier method I'd rahter go that route. Thanks