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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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.
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...
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.
:) 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 ...
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?
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?
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.