It seems you need to do some changes in your website's web.config file as well - it is down now, complaining about "Login failed for user 'hanovershoefarms" :)
> -----Original Message----- > From: [email protected] [mailto:profoxtech- > [email protected]] On Behalf Of James E Harvey > Sent: Monday, January 24, 2011 8:37 PM > To: [email protected] > Subject: RE: insert into ms sql 2005 table > > OMG, I'd fire myself if I could, how can I be so GD stupid!!! > > James E Harvey > Corresponding Officer/M.I.S. > Hanover Shoe Farms, Inc. > [email protected] > 717-637-8931 > fax: 717-637-6766 > cell: 717-887-2565 > > > -----Original Message----- > From: [email protected] [mailto:[email protected]] On > Behalf Of Ted Roche > Sent: Monday, January 24, 2011 12:58 PM > To: [email protected] > Subject: Re: insert into ms sql 2005 table > > On Mon, Jan 24, 2011 at 11:40 AM, James E Harvey > <[email protected]> > wrote: > > I'm trying to insert records into a table on the ms sql godaddy > > database, but this isn't working. Does anyone have any advice as to > > what I'm doing wrong? > > You're giving us (and the entire internet) your passwords. Your machine > should be owned by now. > > You say it isn't working, but you don't say if you've: > - tested to confirm the connection is working > - verified that the SQL statement is correct > - tried to get back an error message to determine what's wrong > - done any troubleshooting what-so-ever. > > My advice? Read: http://www.catb.org/~esr/faqs/smart-questions.html > > But first, please read on... > > > m.lcxn=("Driver={SQL Server}; > > Server=hanovershoefarms.db.6386843.hostedresource.com; > > Database=hanovershoefarms; Uid=hanovershoefarms; Pwd=r5V0n18") > > > > m.lih=Sqlstringconnect(m.lcxn) > > I've tested this much. From Linux, using unixODBC, FreeTDS and isql. > It does, in fact work. Now that you've posted this to the internet, any > malicious user can come along and issue DROP ALL, or change your password. > Someone's going to... Please change your UID and password. > NOW. > > In the future, please don't share user ids and passwords. > > > > > lc_selectcommand = "SELECT * into hsf_broodmares FROM > > c:\foxdat\hsf_broodmare" > > This is unusual syntax. Are you sure this is right? > > Does the GoDaddy MS SQL server have a local c:\foxdat\hsf_broodmare file? > > -- > Ted Roche > Ted Roche & Associates, LLC > http://www.tedroche.com > [excessive quoting removed by server] _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/[email protected] ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
