Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. MalcUK

    connecting to remote sql server

    Could we look at this another way for a minute. A new user downloads my application from the internet onto a stand alone laptop. The application knows the server IP, port, a SQL username and password. Assume the server is running properly. What would need to be set up for the laptop to...
  2. MalcUK

    connecting to remote sql server

    I'm working from home on XP SP2. I'm writing an application that needs to connect from any pc to the SQL server at the office. ODBC works okay connecting to a local server on my home network. It also works connecting to the office server from another pc on the internal office network. The bit...
  3. MalcUK

    connecting to remote sql server

    Good idea, SQLBill but as pointed out later, I am the sysadmin for the XP SP2 workstation. Yes, I'm using system DSN, and I've deleted all other DSNs Re:Registering the server in enterprise manager ... Is that rightclicking on (local) and selecting Add SQL server registration? I can edit...
  4. MalcUK

    connecting to remote sql server

    Thx for suggestion, Jeff. I turned off client firewall. Tests with ODBC wizard, ping, telnet and odbcping all still fail. :( We're missing something.
  5. MalcUK

    connecting to remote sql server

    Hi Jeff On the server I rightclick (Local), select Properties. Click Network configuration button. Named Pipes and TCP/IP are enabled. Force encyption is off, enable winsock proxy is off. I highlight TCP/IP and click properties. Default port says 1433 Hide server is off. I've also...
  6. MalcUK

    connecting to remote sql server

    Thx for your help, guys. Much appreciated. Getting nowhere fast here though. :( In summary From the client ... Client settings are for TCP, port 1433 Ping the server IP works Telnet the server IP port 1433 fails Odbcping server IP and port, user name, password fails with errors 17 and...
  7. MalcUK

    connecting to remote sql server

    ok. ... tech people on the server say firewall *is* set to allow port 1433. :( They ask, "Does it need UDP as well as TCP port enabled?" and "Are there any other ports which SQL server might need to use in addition to the default one?" Could someone enlighten me? Is there a situation where a...
  8. MalcUK

    connecting to remote sql server

    Hi James. Thx for your quick and useful reply. Ping works, but Telnet with port 1433 returns Connect Failed. Unfortunately, the chap who handles the firewall that end is off today :( but it looks like the problem is to do with their firewall, doesn't it, despite what they say about having...
  9. MalcUK

    connecting to remote sql server

    I am trying to set up an odbc connection to a remote SQL Server 2000 database. I have access to the server via remote desktop connection and can ping its IP successfully, but I cant get through odbc setup. In Create New Data Source, I select the SQL Server driver, For server I put the correct...
  10. MalcUK

    Problem with Browser activex control

    Sure ... sorry I wasn't clear. Eg I use Navigate2 to display www.google.co.uk. On that page I click a link. My google preferences are set to open the selected link in a new window, but the default behaviour of the control is to display it in IE. The control automatically calls the...
  11. MalcUK

    Problem with Browser activex control

    I'm writing a small browser app in vfp around the Microsoft Browser control. All works fine except any page that opens a new window, opens it in IE. I have put code into Newwindow3 method which opens up a new instance of my browser, with the correct page, but the page still opens in IE as...
  12. MalcUK

    fading an image

    Words of wisdom from Craig and Mike. Yeah, although I use XP I cant guarantee that others wont still be using 98 :( The VFP example fadeaway.scx fades a form, not an image, but I think I might be able to get round that by creating a borderless form to hold the jpeg, though I'll have to stop...
  13. MalcUK

    fading an image

    Here is a tough one. I want to be able to fade a jpg image on the form. It's easy to do this on a web page by setting opacity but how about in VFP? There isn't a property like that on an image control, but is there something using Activex or API that would do this? BTW I cant do it by...
  14. MalcUK

    Making a Word doc non-editable

    Hmmm ... this is indeed a possibility. I could use automation to output the document to PDF format, and then bring up the PDF viewer. Thanks Mark. I'll give it a go.
  15. MalcUK

    Making a Word doc non-editable

    I need users to preview a document without being able to edit it at all. Opening a file as Read Only still allows editing (even though it blocks a save) PrintPreview looks good, but on closing that, the user is back to an editable view. Is there a way of opening a document in word basic so...
  16. MalcUK

    Reading data from a Salter Weigh-Tronix

    Yes thanks, Alainsat In the end I found out the codes and settings the hard way testing each possible combination. All now works fine and client is very happy.
  17. MalcUK

    Reading data from a Salter Weigh-Tronix

    :) Yes. Half a dozen emails not replied to, and calls not returned. Dont want to spend too much time on the phone to America from UK either! I hoped to get the info online from someone who's already done this stuff ... but looks like I may just have to pick up the phone again ...
  18. MalcUK

    Reading data from a Salter Weigh-Tronix

    I need to read data from a Salter Weigh-Tronix PC-3632B weighing machine. I have no documentation. Does anyone know A) what the speed and protocol of the serial port should be set to and B) how to get the machine to send data?
  19. MalcUK

    Reading rs232 Serial data in FoxPro 2.6 for windows

    I have weighing scales connected to PC via rs232 serial port (com1). Is there a way I can read the incoming data into FoxPro 2.6. Have tried using FOPEN("com1") but get no result. Help file says Foxpro for windows doesn't support opening ports. Any ideas how I can get this to work?

Part and Inventory Search

Back
Top