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.
