Connecting to a Distant SQLServer Using ODBC

Anyone have any experience connecting to an instance of SQLServer on a 
server that is rather distant from your local office? (EX: Office in 
Chicago, Server in Atlanta) 


0
David
3/5/2010 12:10:37 AM
access.modulesdaovba 1670 articles. 0 followers. Follow

3 Replies
589 Views

Similar Articles

[PageSpeed] 4

On Thu, 4 Mar 2010 19:10:37 -0500, "David C. Holley" <David.C.Holley>
wrote:

Yes. Worked fine. What's your challenge?

-Tom.
Microsoft Access MVP


>Anyone have any experience connecting to an instance of SQLServer on a 
>server that is rather distant from your local office? (EX: Office in 
>Chicago, Server in Atlanta) 
>
0
Tom
3/5/2010 2:48:03 AM
Lack of experience with it and on a very-high profile project. I'm going 
into it blind as a bat.

"Tom van Stiphout" <tom7744.no.spam@cox.net> wrote in message 
news:p5s0p5le7pdp80h5mjloeebg2d8dcq00pr@4ax.com...
> On Thu, 4 Mar 2010 19:10:37 -0500, "David C. Holley" <David.C.Holley>
> wrote:
>
> Yes. Worked fine. What's your challenge?
>
> -Tom.
> Microsoft Access MVP
>
>
>>Anyone have any experience connecting to an instance of SQLServer on a
>>server that is rather distant from your local office? (EX: Office in
>>Chicago, Server in Atlanta)
>> 


0
David
3/5/2010 10:14:16 AM
Yes, slow.

Never had a user that actually liked the experience.

Never bad enough to make management think that
the users had a problem.

But bad enough to make management think that management
had a problem if management had to use the application.

And that was using a fairly well designed application.

Depends a lot on the network infrastructure, not so much
at all on how far physically.

Latency is more important than through-put. Or at least,
you can fix through-put problems just by fixing up your
design.

Exaggerates all of the problems of ODBC-linked table design.
-- complex multi-table joins will be candidates for re-design
as views.

(david)



"David C. Holley" <David.C.Holley> wrote in message 
news:u$7TJh$uKHA.3408@TK2MSFTNGP06.phx.gbl...
> Anyone have any experience connecting to an instance of SQLServer on a 
> server that is rather distant from your local office? (EX: Office in 
> Chicago, Server in Atlanta)
> 


0
david
3/9/2010 10:28:26 AM
Reply:

Similar Artilces:

using a variable for something
I am using the following line to write to a text box on a different form that is open: Forms![sheet2]![HVD] = Me!Text14 I would like to make this line more generic and use a information from the current form to substitute for part of the line: Dim tempDiv As String tempDiv = Me!division Forms![sheet2]![tempDiv] = Me!Text14 Is there a way to do this or a different set of commands to write to the object on a different form. Thanks for the help. You can code like this: Dim txt As Textbox Set txt = Forms!Sheet2!tempDiv txt = Me.Text15 If you need to pass the text...

Hiding Rows Using IF Statement
I would like to be able to hide a number of rows based on the response to a question.. The response to the question is a list box with either "yes" or "no" as the choices.. If the response = "no" then I would like to hide the next 3 rows, otherwise do nothing.. Is there a "hide" command of some sort that I can use as part of an IF statement or will I have to use a macro? -- Thanks Larry Larry, see my response in your other post - must be done with VBA code, and I provided code there: http://www.microsoft.com/office/communi...

unable to connect to the server
Unable to connect to the server. Outlook is unable to download folder from the IMAP e-mail server for account aolimap. Could it be I did not set up my e-mail account correctly and if so please help? I'm not too familar with AOL's mail usage with other mail clients but I found this page that might help you: http://members.aol.com/adamkb/aol/mailfaq/imap/ "Maria" <Maria@discussions.microsoft.com> wrote in message news:09162E1C-A6E4-48D4-B4E5-45DD96DDB833@microsoft.com... > Unable to connect to the server. Outlook is unable to download folder from > the IMAP e-...

Using the Join function on lines from an AutoCAD import
Hi, I use Visio 2007 and I have a problem joining lines and then filling the resultant shape on an AutoCAD import. So, I imported my DWG file. I've done a convert once it imported. I've discovered that there's a layer called DWGEntityColorOverrideLayer and that this has to be ticked to allow Visio to recolour lines, etc. I've got a selection of lines and arcs that touch up against each other to form a single shape. I want to fill that shape. So I select all the lines and use the Shapes > Operations > Join function and the join goes ahead but the fill ...

Using Excel DataBase to do e-mail merge
I'd like to send an e-mail to each person in my excel spreadsheet. How can I do this Outlook e-mail merge. Have you looked at the help files? --� Milly Staples [MVP - Outlook] Post all replies to the group to keep the discussion intact. Due to the (insert latest virus name here) virus, all mail sent to my personal account will be deleted without reading. After searching google.groups.com and finding no answer, Dennis asked: | I'd like to send an e-mail to each person in my excel | spreadsheet. How can I do this Outlook e-mail merge. ...

Mail Merge to Email using SFO
Everyone seems to recommend doing a mail merge to email from the web client. However, you can do this from SFO - and for some of my customers, they are more comfortable with the "Traditional" merge process. Could someone please clarify if the only difference is that MSCRM will not ttrack the body of the email - ie the Activity for that email will just have "Word Mail Merge"? I would really appreciate clarification on this issue - driving me nuts!! Thanks in advance! Cathy Hello Cathy! Yes, the difference is that MSCRM will not track the body of the email, if you do it...

Use Cell Containing Worksheet Name in Formula
I'm sure this can't be that hard, but I am trying to use a cell that contains a worksheet name in a formula, but can't get it to work. CellA1.value = "Sheet1" Formula is VLOOKUP($A$1,Sheet1!A1:B4,2,FALSE) but I don't want to use Sheet1, I want a reference to CellA1 that contains the sheet name. Any help would be appreciated! <jcurran13us@yahoo.com> wrote in message news:1167364842.447359.217560@h40g2000cwb.googlegroups.com... > I'm sure this can't be that hard, but I am trying to use a cell that > contains a worksheet name in a formula, but...

connecting excel to a database
how to prepare a form in excel so that it gets saved in the database and we can fill it and send it to the database. and we can retrieve it for future reference? Why not just create a form in Access? "bhanu" wrote: > how to prepare a form in excel so that it gets saved in the database > and we can fill it and send it to the database. and we can retrieve it > for future reference? > > On Jul 6, 7:53 am, bhanu <bhanupriy...@gmail.com> wrote: > how to prepare a form in excel so that it gets saved in the database > and we can fill it and send it to t...

Change Address Fields using Combo Dropdown List
I have a Form based on a Table called "VoterInformationTable". The Form has Name and Address Text Fields from the Table. I use Combo 48 to bring up a new record on the Form. I have another Combo called "cmb_Addr_Change" that I want to use to change the address of a record to another address I select from the combo dropdown List. A friend wrote the following code. I am getting a run-time error '3144' Syntax error in update statement cmb_Addr_change. Could someone check the statement below for errors. Private Sub Cmb_Addr_Change_AfterUpdate() Dim SQL_Text As S...

Formating excel multiple paragraphs and colums using one source of data
Scenario: Sheet#1: column #1 product names separated by category names. column#2 prices corresponding to products. Final sheet is basically all product pricing. To print this out i need to create lay out on sheet # 2 This sheet would have three vertical frames. this frames would have two columns(one for product names one for pricis) Sheet #1 would project the content to sheet #2 in such way that if sheet #1 content changes all the content would get formated in number #2 sheet accordingly .(This content will have multiple pages within a sheet. How can I achieve that?. ...

using a name label within an index function
I have defined a name label which contains a path to an external lookup workbook. If I put the path in each formula in each cell the formula looks like this: INDEX('c:\directory to workbook\workbook.xls'!MYDEFINEDRANGE;10, 12) I want to use it like this: INDEX(NameLabelThatContainsThePathToWorkbook!MYDEFINEDRANGE;10, 12) But this doesn't work. I'm using Excel 2002. Please help me. Thank you... Hi not possible with Excel's build in functions. Have a look at: http://tinyurl.com/2c62u -- Regards Frank Kabel Frankfurt, Germany "Floran Stuyt" <nospam@nospa...

How do I write text on a bar chart using VBA
I have a worksheet with various bar charts. I want to write text inside the bar but cannot figure out the correct control name to modify the text. Any help is appreciated You can add a data label to the data point. With ActiveChart.SeriesCollection(1).Points(1) .HasDataLabel = True With .Datalabel .Caption = "Hello" .Position = xlLabelPositionCenter .Orientation = xlUpward '' and more if desired End With End With - Jon ------- Jon Peltier Peltier Technical Services, Inc. http://peltiertech.com/ Barney wrote: > ...

A) 140 fields in a record -- OK ?? --- B) Do empty fields use disk space?
1 - I've got a record with 140 fields - should I expect any problems because of so many fields in each record? 2 - How does Access treat fields in which the user enters no data? if it is a text field with 50 charcters of space allowed... does Access see that it is an empty field... or a field in which on a few characters are entered... and compact it... or does it simply save 50 bytes for the field even though none or only some of them are used? thanks for any help. Mel 1) I can't imagine a properly normalized table that would require 140 fields. 30 fields is considered a large n...

Group DB columns to be used in pivot table
Hi, I have the following problems to prepare the DB. I need to create a Pivot Table and my source DB is Excel. Headings go from Column A to AT, but only columns A to N will be used to play around with the pivot, while columns O to AT are only to input values. How can I: 1) Transform the many columns O to AT in one field called Product so that once placed into the Column part of the Pivot I can see all the headings from O to AT 2) How to make all the O to AT cells active so that the user can enter values and see the changes or analyse using the A to N fields? Examle: A B C D E F G H I...

Outlook can not connect to Exchange Server
The OWA and POP3 work fine on my Exchange Server 2003, I can use Outlook to send/receive emails via POP3 protocol, but there's an error when I try to use MS Outlook connect to Exchange directly, the details: 1. I open the control pannel, User Accounts --- Email 2. Creat a new email account, select email Server "Mircrosoft Exchange Server" 3. Input the Server IP address: 192.168.1.1, then, check name, done! there's an underline under the user name and Server name, so I think the connection is no problem. 4. Finish the settings, open MS Outlook 2003. 5. When I open the MS ...

How do I connect to our Microsoft Exchange server for my emails?
I have installed Outlook 2007 and it will not connect to my company's Exchange server from my house. It will connect though if I'm at the office. My IT guy said everything is configured correctly on my machine. What am I missing? It's hard to say wtihout knowing your configuration for remote access. Do you have a valid internet connection? Are you using VPN? Are you being challenged for your credentials? When your IT person tests your remote access, does it work? Are there any error messages and/or numbers? -- Kathleen Orland - MVP Outlook Outlook Tips: http://www.outl...

Sending Mail using SMTP via Exchange Server
We have recently installed Windows Small Business Server in our company and we are beginning to investigate using Microsoft Exchange. We have set up a couple of test accounts and we can receive mail fine by using the POP3 connector in Exchange Server Management but we have been unable to send any mail at all. I have written several test email to send in the test accounts and after spending a few seconds in the outbox they appear in the sent items folder but are never actually received. This morning I received a Delivery Status Notification for each of the sent emails saying that deliver...

Using Dates and Numbers
Here is my problem. im trying to figure out how to add days to dates. for example if it is august 12, 2004, i would like to create a function that lets me know the date 12 days from now. basically a function in which i could put in a starting date and then type 3 days later and find the new date. If I understand correctly, in A1 enter the date you require, in B1, =A1+12 will give the date twelve days on, Regards, Alan "Andrew" <anonymous@discussions.microsoft.com> wrote in message news:033b01c3a497$cf74ef70$a101280a@phx.gbl... > Here is my problem. im trying to figure...

Access 2007
Hi, I’m using access 2007. I would like to use one of my reports as the body of an outlook 2007 email message. I’m able to export the report as an HTML file but can’t figure out how to use either as body of the email message. Is this possible in VBA? Can anyone help with an example or sample code if possible? Thanks All Cris You can send HTML e-mail using Outlook automation. Sample code can be found at http://www.devhut.net/index.php?lang=en&pid=0000000013#SendHTMLEmail However, you will first need to read your html file into vba so you can use it as the subject v...

Using calculated filenames
Ok, Here's another thing I'm having trouble getting to work. I would like to concatenate a file and cell name to use to retrieve a value. I have a master sheet that contains a filename value in a cell. I would then use the filename value contained in that cell to call a value from another sheet. Here is an example of what I mean: File_Names.xls!FILE_SALES_JUNE_2006 ['FILE_SALES_JUNE_2006' is concatenated, cell contains value...] ---- Sales_June_2006.xls ---- I would then use that value to call a concatenated cell value from another sheet Sales_June_2006.xls!S_1001...

VBA Quotes using IIF
In CODE 1 below, I have a working SELECT statement that is the RowSource for a combo box named cbotrackID. I'm trying to write it out in VBA, but I'm having a lot of trouble with the quotes. I didn't put my failed code in CODE 2 because I didn't want to confuse anyone. Can someone help me convert the SQL in CODE 1 into a VBA statement that I can use in VBA to set the RowSource with a code version of the sql? CODE 1 ********** SELECT t.trackID, t.trackNum, [trackNum] & ") " & [trackSong] & IIf(IsNull([trackTime]),""," (" & [...

64-bit ODBC driver for MS Access
I have several websites that use MS Access as the backend. I've now replacedmy development machine and installed Vista 64-bit, with Office 2007.I am able to continue to develop the sites (Dreamweaver), but I'm unable totest them locally due to the lack of an 64-bit ODBC driver.I've read various discussions regarding recompiling for x86 32-bitenvironment, but that doesn't work for me as this is IIS based, not a VB.NETor C++ application.Can anyone help me with a pointer or two in how to get around this problem.The ideal situation of course is for Microsoft to produce a 64-bit ODB...

Using the registry in Vista.
I haven't started programming to target Vista yet. (First, I need to buy a new computer that has Vista.) Currently, depending on my program, they run on either XP or Server 2003. Can I access the same areas of the registry in Vista? I've been putting everything in local machine. Can I continue to do that? If I can't, what do I do? If I write a service... They start up before a login. Right? So how do I use the registry in that case? >Can I access the same areas of the registry in Vista? You can - if you (the user running your program) has permission to do so. >I&#...

"Office for Mac 2008" on the Microsoft "Home Use Program"????
When will "Office for Mac 2008" be available to the "Home Use Program"? Thanks... All flavors of Office 2008 were released today, including the Home & Student package... What do you mean by "Home Use Program"? -- Regards |:>) Bob Jones [MVP] Office:Mac <Matt@officeformac.com> wrote in message news:ee888a9.-1@webcrossing.caR9absDaxw... When will "Office for Mac 2008" be available to the "Home Use Program"? Thanks... Home Use Program (HUP) is a program MS has with some companies that provides copies to the company's em...

Using Excel with multiple monitors
Hi, I'm using Excel 97 on Win2k with 2 monitors. No matter what I try, I cannot increase the width of a workbook to more than the size of a monitor. Its like the window has a maximum size. Is there a solution? thanks, Mark. Mark, I use two monitors for audio work, and have to restore (non-maximize) the window, then manually adjust it (drag the borders) to fill the two monitors, and leave it that way (non-maximized). The same seems to be true with Excel. Mine is a Radeon 7500. I've asked a colleague, who has a two-monitor setup. If I get anything back, I'll reply again. --...