Connection problem

Strange database problem.
I have 2 servers one running as webserver and the other as Database server running MSSQL 2000 SP3.
They are connected i 2 ways. Through a public net using static IP and through a direct cable using another IP.

My problem is that I cannot connect to or from the database through the crossed cable (I run a DTS which imports a zipped access file from an FTP account on the webserver).
Running through the public net works fine but not through the crossed/direct cable.
All other connecting (ping, filesharing, FTP not through DTS, etc) works fine through that cable but ODBC connections from the webserver don't and neither does DTS access from the database server.
Does anyone have a clue.I assume there is a different IP associated with the crossed-cable connection. Configure your ODBC to use that IP address instead of the server name.|||That's what I couldn't do. However everything worked out after restarting the webbserver. Seems like it was just a glitch.sqlsql

connection pooling for access jet connected ODBC tables?

Is 'connection pooling' available when using an access front end connecting
to sql server 2000 tables via jet connected ODBC (not an access
project/ado)?
If yes, is there any configurable options? if yes where? On client side or
server side or both?
any help is appreciated. Thanks.
You can configure ODBC connection properties in an Access mdb in
several places -- database options, query options, and in an ODBC
connection string (or DSN). However, I'm not sure about
resource/connection pooling. Access handles a lot of that under the
covers, spawning additonal connections when needed, say for opening a
complex form. What exactly are you trying to dos?
--Mary
On Mon, 24 May 2004 16:37:11 -0400, "djc" <noone@.nowhere.com> wrote:

>Is 'connection pooling' available when using an access front end connecting
>to sql server 2000 tables via jet connected ODBC (not an access
>project/ado)?
>If yes, is there any configurable options? if yes where? On client side or
>server side or both?
>any help is appreciated. Thanks.
>
sqlsql

connection pooling for access jet connected ODBC tables?

Is 'connection pooling' available when using an access front end connecting
to sql server 2000 tables via jet connected ODBC (not an access
project/ado)?
If yes, is there any configurable options? if yes where? On client side or
server side or both?
any help is appreciated. Thanks.You can configure ODBC connection properties in an Access mdb in
several places -- database options, query options, and in an ODBC
connection string (or DSN). However, I'm not sure about
resource/connection pooling. Access handles a lot of that under the
covers, spawning additonal connections when needed, say for opening a
complex form. What exactly are you trying to dos?
--Mary
On Mon, 24 May 2004 16:37:11 -0400, "djc" <noone@.nowhere.com> wrote:

>Is 'connection pooling' available when using an access front end connecting
>to sql server 2000 tables via jet connected ODBC (not an access
>project/ado)?
>If yes, is there any configurable options? if yes where? On client side or
>server side or both?
>any help is appreciated. Thanks.
>

Connection Pooling

Connection pooling is set on the connection -- you cannot modify it once you've already connected. -- Adam MachanicSQL Server MVPhttp://www.datamanipulation.net-- <Ian Logan@.discussions.microsoft.com> wrote in message news:36ba6025-224c-4418-9a85-a4567d54290f@.discussions.microsoft.com...I am using SQL 2000 and am trying to use sp_setapprole to set up user access. I am also using VB.NET with the MS Patterns and Practices Data Application Library for the database connection.I have discovered that connection pooling has to be set OFF for this SP to work. My question is this: If I have set connection pooling to OFF to run sp_setapprole, can I then set it back to ON and still run in the same session?To explain a little more:Application startsWindows Authentication is used to grant access to a User tableConnection Pooling set to OFFApplication sets the users role with sp_setapproleConnection Pooling set to ONData access is via Data Application LibraryUser enter data, etc...Many thanksIan LoganI am using SQL 2000 and am trying to use sp_setapprole to set up user access. I am also using VB.NET with the MS Patterns and Practices Data Application Library for the database connection.

I have discovered that connection pooling has to be set OFF for this SP to work. My question is this:
If I have set connection pooling to OFF to run sp_setapprole, can I then set it back to ON and still run in the same session?

To explain a little more:
Application starts
Windows Authentication is used to grant access to a User table
Connection Pooling set to OFF
Application sets the users role with sp_setapprole
Connection Pooling set to ON
Data access is via Data Application Library
User enter data, etc...

Many thanks
Ian Logan
|||That's difficult to know without an understanding of the application's architecture and usage patterns. If the application opens and closes a lot of database connections (on the order of >100/minute during peak periods), this can have a huge impact. If the app is low activity or holds connections open for long periods of time, connection pooling is much less important. -- Adam MachanicSQL Server MVPhttp://www.datamanipulation.net-- <Ian Logan@.discussions.microsoft.com> wrote in message news:cc4a415a-cd9e-4abe-8fa5-a793c496412b@.discussions.microsoft.com...AdamI had the feeling that might be the case.What impact would setting the Pooling to OFF have on the application performance?Kind RegardsIan|||Adam

I had the feeling that might be the case.

What impact would setting the Pooling to OFF have on the application performance?

Kind Regards
Ian

Connection of SQL server 2000 with ASP in IIS6.0

Dear Friend,

Please tell me how to connect sql server and ASP in IIS 6.0.Earlier in IIS 5 I have connected in SQL server with ASP with DSN connection,the same global.asa file is not working in IIS6.0.But Asp pages are not giving any error ,but they are no just taking value from Database.I mean server connection is not establishing..

Could you please help in matter

Thank you

Graceson MAthewIf you are not recieving an error, I highly doubt it is your connection string.

Connection error while already running code

I am using Access 2002 as a front end and SQL Server 2000 as a back end.
I am using an ODBC connection and TCP/IP
After I have connected, I use ADO to run a process that gets ten different
sum queries from various SQL Server tables and writes the results to local
Access table. This loops thru 300 to 800 records.
The second time thru this process, at any of the queries, I will almost
always get this error:
-2147467259, Sql Server does not exist or access denied. Now I am already
connected and I have run this same query many times.
If I debug and force the same line, it runs.
Why is it hanging occasionally, and more importantly, what can I do to fix
this?
TIA,
MikeCould be that the problem is timing related. What happens if you insert a
timer event to wait a few seconds prior to establishing a new connection?
What is the connection timeout setting? How many concurrent connections
are on the server when this happens?
Thanks,
Kevin McDonnell
Microsoft Corporation
This posting is provided AS IS with no warranties, and confers no rights.|||Kevin,
I am not establishing a new connection, I am using one that is already open.
The connection timeout is the default, 30 seconds.
The concurrent connection fluctuates between 159 and 175.
Hope this helps.
Mike
"Kevin McDonnell [MSFT]" <kevmc@.online.microsoft.com> wrote in message
news:dzu1LfLVEHA.2764@.cpmsftngxa10.phx.gbl...
> Could be that the problem is timing related. What happens if you insert a
> timer event to wait a few seconds prior to establishing a new connection?
> What is the connection timeout setting? How many concurrent connections
> are on the server when this happens?
> Thanks,
> Kevin McDonnell
> Microsoft Corporation
> This posting is provided AS IS with no warranties, and confers no rights.
>
>

Connection error while already running code

I am using Access 2002 as a front end and SQL Server 2000 as a back end.
I am using an ODBC connection and TCP/IP
After I have connected, I use ADO to run a process that gets ten different
sum queries from various SQL Server tables and writes the results to local
Access table. This loops thru 300 to 800 records.
The second time thru this process, at any of the queries, I will almost
always get this error:
-2147467259, Sql Server does not exist or access denied. Now I am already
connected and I have run this same query many times.
If I debug and force the same line, it runs.
Why is it hanging occasionally, and more importantly, what can I do to fix
this?
TIA,
Mike
Could be that the problem is timing related. What happens if you insert a
timer event to wait a few seconds prior to establishing a new connection?
What is the connection timeout setting? How many concurrent connections
are on the server when this happens?
Thanks,
Kevin McDonnell
Microsoft Corporation
This posting is provided AS IS with no warranties, and confers no rights.
|||Kevin,
I am not establishing a new connection, I am using one that is already open.
The connection timeout is the default, 30 seconds.
The concurrent connection fluctuates between 159 and 175.
Hope this helps.
Mike
"Kevin McDonnell [MSFT]" <kevmc@.online.microsoft.com> wrote in message
news:dzu1LfLVEHA.2764@.cpmsftngxa10.phx.gbl...
> Could be that the problem is timing related. What happens if you insert a
> timer event to wait a few seconds prior to establishing a new connection?
> What is the connection timeout setting? How many concurrent connections
> are on the server when this happens?
> Thanks,
> Kevin McDonnell
> Microsoft Corporation
> This posting is provided AS IS with no warranties, and confers no rights.
>
>

Connection error after already connected

I am using Access 2002 as a front end and SQL Server 2000 as a back end.
After I have connected, I use ADO to run a process that gets ten different
sum queries from various SQL Server tables and writes the results to local
Access table. This loops thru 300 to 800 records.
The second time thru this process, at any of the queries, I will almost
always get this error:
-2147467259, Sql Server does not exist or access denied. Now I am already
connected and I have run this same query many times.
If I debug and force the same line, it runs.
Why is it hanging occasionally, and more importantly, what can I do to fix
this?
TIA,
Mike
Are you using named pipes or tcp/ip ?
Vikram
"Michael Beck" <mikeb@.Nospamamuletc.com> wrote in message
news:OxuPzTwTEHA.3336@.TK2MSFTNGP10.phx.gbl...
> I am using Access 2002 as a front end and SQL Server 2000 as a back end.
> After I have connected, I use ADO to run a process that gets ten different
> sum queries from various SQL Server tables and writes the results to local
> Access table. This loops thru 300 to 800 records.
> The second time thru this process, at any of the queries, I will almost
> always get this error:
> -2147467259, Sql Server does not exist or access denied. Now I am already
> connected and I have run this same query many times.
> If I debug and force the same line, it runs.
> Why is it hanging occasionally, and more importantly, what can I do to fix
> this?
> TIA,
> Mike
>
|||TCP/IP
"Vikram Vamshi" <vikram.vamshi@.nospam.com> wrote in message
news:efh1gyyTEHA.3180@.TK2MSFTNGP11.phx.gbl...[vbcol=seagreen]
> Are you using named pipes or tcp/ip ?
> Vikram
> "Michael Beck" <mikeb@.Nospamamuletc.com> wrote in message
> news:OxuPzTwTEHA.3336@.TK2MSFTNGP10.phx.gbl...
different[vbcol=seagreen]
local[vbcol=seagreen]
already[vbcol=seagreen]
fix
>

Connection error after already connected

I am using Access 2002 as a front end and SQL Server 2000 as a back end.
After I have connected, I use ADO to run a process that gets ten different
sum queries from various SQL Server tables and writes the results to local
Access table. This loops thru 300 to 800 records.
The second time thru this process, at any of the queries, I will almost
always get this error:
-2147467259, Sql Server does not exist or access denied. Now I am already
connected and I have run this same query many times.
If I debug and force the same line, it runs.
Why is it hanging occasionally, and more importantly, what can I do to fix
this?
TIA,
MikeAre you using named pipes or tcp/ip ?
Vikram
"Michael Beck" <mikeb@.Nospamamuletc.com> wrote in message
news:OxuPzTwTEHA.3336@.TK2MSFTNGP10.phx.gbl...
> I am using Access 2002 as a front end and SQL Server 2000 as a back end.
> After I have connected, I use ADO to run a process that gets ten different
> sum queries from various SQL Server tables and writes the results to local
> Access table. This loops thru 300 to 800 records.
> The second time thru this process, at any of the queries, I will almost
> always get this error:
> -2147467259, Sql Server does not exist or access denied. Now I am already
> connected and I have run this same query many times.
> If I debug and force the same line, it runs.
> Why is it hanging occasionally, and more importantly, what can I do to fix
> this?
> TIA,
> Mike
>|||TCP/IP
"Vikram Vamshi" <vikram.vamshi@.nospam.com> wrote in message
news:efh1gyyTEHA.3180@.TK2MSFTNGP11.phx.gbl...
> Are you using named pipes or tcp/ip ?
> Vikram
> "Michael Beck" <mikeb@.Nospamamuletc.com> wrote in message
> news:OxuPzTwTEHA.3336@.TK2MSFTNGP10.phx.gbl...
different[vbcol=seagreen]
local[vbcol=seagreen]
already[vbcol=seagreen]
fix[vbcol=seagreen]
>

Connecting two computers

Hello there
I have two computers who connected on the same workgroup. on each one of
them sql server database is installed
I would like to connect them together so i can transfare data between them.
What i need to do so they will recognize each other?
Hi,
-Connection via a network protocol (e.g. tcp/ip)
-Authorisation between these two (in workgroups usally SQL Server
authentication)
HTH, Jens Suessmeyer.
|||Whell Jens
I've change on second computer to SQL Server Authentication.
But when i'm trying to access from first computer to second computer using
query analyser with this code:
select *
FROM Printer.Diseace.dbo.Client
I got the error:
Server: Msg 18456, Level 14, State 1, Line 1
Login failed for user 'PRINTER\Guest'.
The User Gest on the printer is not configured, and i would like to access
as dbo.
what i need to do now?
"Jens" <Jens@.sqlserver2005.de> wrote in message
news:1133619339.336140.15280@.g49g2000cwa.googlegro ups.com...
> Hi,
> -Connection via a network protocol (e.g. tcp/ip)
> -Authorisation between these two (in workgroups usally SQL Server
> authentication)
> HTH, Jens Suessmeyer.
>
|||So you are using a linked server. With this technique and without
authorisation through a windows domain, you have to set up the linked
server with a SQL Server login (usally if you want to have dbo right,
with a user whohas dbo rights on the remote server) to access the
database, otherwise it will try to use the guest account from your
Computer "Printer" which is unknown on the remote one.
HTH, Jens Suessmeyer.

Connecting two computers

Hello there
I have two computers who connected on the same workgroup. on each one of
them sql server database is installed
I would like to connect them together so i can transfare data between them.
What i need to do so they will recognize each other?Hi,
-Connection via a network protocol (e.g. tcp/ip)
-Authorisation between these two (in workgroups usally SQL Server
authentication)
HTH, Jens Suessmeyer.|||Whell Jens
I've change on second computer to SQL Server Authentication.
But when i'm trying to access from first computer to second computer using
query analyser with this code:
select *
FROM Printer.Diseace.dbo.Client
I got the error:
Server: Msg 18456, Level 14, State 1, Line 1
Login failed for user 'PRINTER\Guest'.
The User Gest on the printer is not configured, and i would like to access
as dbo.
what i need to do now?
"Jens" <Jens@.sqlserver2005.de> wrote in message
news:1133619339.336140.15280@.g49g2000cwa.googlegroups.com...
> Hi,
> -Connection via a network protocol (e.g. tcp/ip)
> -Authorisation between these two (in workgroups usally SQL Server
> authentication)
> HTH, Jens Suessmeyer.
>|||So you are using a linked server. With this technique and without
authorisation through a windows domain, you have to set up the linked
server with a SQL Server login (usally if you want to have dbo right,
with a user whohas dbo rights on the remote server) to access the
database, otherwise it will try to use the guest account from your
Computer "Printer" which is unknown on the remote one.
HTH, Jens Suessmeyer.

Connecting to SQL Server with a login form.

Hi all,

I'm new to VB and VB.net and forms and everything, so please bare with me :)

I am constructing an application which is connected to sql server 2000. What I want to do is have the Login form open upon startup then have an option group where the user states if he wants to use NT or SQL Server authentication. . Then I want a combobox which looks up all the current sql servers there are on the network, so that the user chooses the sql server that it connects to. or if that's not possible, just a textbox with the sql server and database name.

I already have the option group (although I don't know how to get their values, I worked with plain old MS Access before this)

#1: What will my connection string look like?
#2: How will I tell my application which type the user selected?
#3: How can I save the credentials in my application when the user logs in so that I can use that credentials throughout the application?

Thanks

Rudi

if (rdoUseSqlAuth.Checked==true)
{
// user chose sql auth
}
else if (rdoUseWindowsAuth.Checked==true)
{
/// user chose windows auth
}

http://www.connectionstrings.com for information about connection strings
To save the information and be able to use it throughout the class you may look at use the Singleton class model
you would copy their code snippet and simply add public members or properties to store your information in.
|||Hi Marc,

Thanks for the help, but I don't have a clue how to use that singletone thing. How would I go about making the connection public and carrying over the connection string to main main form (MDI Container) and then use it in my mdi child forms?

Another thing, I'm battling this stupid as to when clicking the login button to get the login box closed (not hidden) and opening the main form. Up until now the main form flashes on the screen and the application ends.

Any ideas?

btw, I'm using vb.net as my language.

Thanks|||Your form is disappearing probably because whenever the startup form is closed that signals the application to exit.

|||

Dear MarcD,

If i'm using MS Access as my database..
Will I need sum ting as tis too?

if (rdoUseSqlAuth.Checked==true)
{
// user chose sql auth
}
else if (rdoUseWindowsAuth.Checked==true)
{
/// user chose windows auth
}

And I do not know how to code my login verification.
Please giv sum guide!

Thanks & GOD bless!
Jesse

|||

In case of sqlserver we are having differnt types of values for connection for examle

con.connectionstring=" Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=sridb;Data Source=xvz;"

ok

Ur 2nd ?

Regarding the type of user u want to select

We are having (Windows) Principal and permission classes U have to include the libraries and u have to write the code

Dim MyIdentity As WindowsIdentity = WindowsIdentity.GetCurrent()

'Put the previous identity into a principal object.
Dim MyPrincipal As New WindowsPrincipal(MyIdentity)

'Principal values.
Dim PrincipalName As String = MyPrincipal.Identity.Name
Dim PrincipalType As String = MyPrincipal.Identity.AuthenticationType
Dim PrincipalAuth As String = MyPrincipal.Identity.IsAuthenticated.ToString()

'Identity values.
Dim IdentName As String = MyIdentity.Name
Dim IdentType As String = MyIdentity.AuthenticationType
Dim IdentIsAuth As String = MyIdentity.IsAuthenticated.ToString()
Dim IsG As String = MyIdentity.IsGuest.ToString()
Dim IsSys As String = MyIdentity.IsSystem.ToString()
Dim Token As String = MyIdentity.Token.ToString()

Connecting to SQL Server with a login form.

Hi all,

I'm new to VB and VB.net and forms and everything, so please bare with me :)

I am constructing an application which is connected to sql server 2000. What I want to do is have the Login form open upon startup then have an option group where the user states if he wants to use NT or SQL Server authentication. . Then I want a combobox which looks up all the current sql servers there are on the network, so that the user chooses the sql server that it connects to. or if that's not possible, just a textbox with the sql server and database name.

I already have the option group (although I don't know how to get their values, I worked with plain old MS Access before this)

#1: What will my connection string look like?
#2: How will I tell my application which type the user selected?
#3: How can I save the credentials in my application when the user logs in so that I can use that credentials throughout the application?

Thanks

Rudi

if (rdoUseSqlAuth.Checked==true)
{
// user chose sql auth
}
else if (rdoUseWindowsAuth.Checked==true)
{
/// user chose windows auth
}

http://www.connectionstrings.com for information about connection strings
To save the information and be able to use it throughout the class you may look at use the Singleton class model
you would copy their code snippet and simply add public members or properties to store your information in.
|||Hi Marc,

Thanks for the help, but I don't have a clue how to use that singletone thing. How would I go about making the connection public and carrying over the connection string to main main form (MDI Container) and then use it in my mdi child forms?

Another thing, I'm battling this stupid as to when clicking the login button to get the login box closed (not hidden) and opening the main form. Up until now the main form flashes on the screen and the application ends.

Any ideas?

btw, I'm using vb.net as my language.

Thanks|||Your form is disappearing probably because whenever the startup form is closed that signals the application to exit.

|||

Dear MarcD,

If i'm using MS Access as my database..
Will I need sum ting as tis too?

if (rdoUseSqlAuth.Checked==true)
{
// user chose sql auth
}
else if (rdoUseWindowsAuth.Checked==true)
{
/// user chose windows auth
}

And I do not know how to code my login verification.
Please giv sum guide!

Thanks & GOD bless!
Jesse

|||

In case of sqlserver we are having differnt types of values for connection for examle

con.connectionstring=" Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=sridb;Data Source=xvz;"

ok

Ur 2nd ?

Regarding the type of user u want to select

We are having (Windows) Principal and permission classes U have to include the libraries and u have to write the code

Dim MyIdentity As WindowsIdentity = WindowsIdentity.GetCurrent()

'Put the previous identity into a principal object.
Dim MyPrincipal As New WindowsPrincipal(MyIdentity)

'Principal values.
Dim PrincipalName As String = MyPrincipal.Identity.Name
Dim PrincipalType As String = MyPrincipal.Identity.AuthenticationType
Dim PrincipalAuth As String = MyPrincipal.Identity.IsAuthenticated.ToString()

'Identity values.
Dim IdentName As String = MyIdentity.Name
Dim IdentType As String = MyIdentity.AuthenticationType
Dim IdentIsAuth As String = MyIdentity.IsAuthenticated.ToString()
Dim IsG As String = MyIdentity.IsGuest.ToString()
Dim IsSys As String = MyIdentity.IsSystem.ToString()
Dim Token As String = MyIdentity.Token.ToString()

Connecting to SQL Server with a login form.

Hi all,

I'm new to VB and VB.net and forms and everything, so please bare with me :)

I am constructing an application which is connected to sql server 2000. What I want to do is have the Login form open upon startup then have an option group where the user states if he wants to use NT or SQL Server authentication. . Then I want a combobox which looks up all the current sql servers there are on the network, so that the user chooses the sql server that it connects to. or if that's not possible, just a textbox with the sql server and database name.

I already have the option group (although I don't know how to get their values, I worked with plain old MS Access before this)

#1: What will my connection string look like?
#2: How will I tell my application which type the user selected?
#3: How can I save the credentials in my application when the user logs in so that I can use that credentials throughout the application?

Thanks

Rudi

if (rdoUseSqlAuth.Checked==true)
{
// user chose sql auth
}
else if (rdoUseWindowsAuth.Checked==true)
{
/// user chose windows auth
}

http://www.connectionstrings.com for information about connection strings
To save the information and be able to use it throughout the class you may look at use the Singleton class model
you would copy their code snippet and simply add public members or properties to store your information in.
|||Hi Marc,

Thanks for the help, but I don't have a clue how to use that singletone thing. How would I go about making the connection public and carrying over the connection string to main main form (MDI Container) and then use it in my mdi child forms?

Another thing, I'm battling this stupid as to when clicking the login button to get the login box closed (not hidden) and opening the main form. Up until now the main form flashes on the screen and the application ends.

Any ideas?

btw, I'm using vb.net as my language.

Thanks|||Your form is disappearing probably because whenever the startup form is closed that signals the application to exit.

|||

Dear MarcD,

If i'm using MS Access as my database..
Will I need sum ting as tis too?

if (rdoUseSqlAuth.Checked==true)
{
// user chose sql auth
}
else if (rdoUseWindowsAuth.Checked==true)
{
/// user chose windows auth
}

And I do not know how to code my login verification.
Please giv sum guide!

Thanks & GOD bless!
Jesse

|||

In case of sqlserver we are having differnt types of values for connection for examle

con.connectionstring=" Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=sridb;Data Source=xvz;"

ok

Ur 2nd ?

Regarding the type of user u want to select

We are having (Windows) Principal and permission classes U have to include the libraries and u have to write the code

Dim MyIdentity As WindowsIdentity = WindowsIdentity.GetCurrent()

'Put the previous identity into a principal object.
Dim MyPrincipal As New WindowsPrincipal(MyIdentity)

'Principal values.
Dim PrincipalName As String = MyPrincipal.Identity.Name
Dim PrincipalType As String = MyPrincipal.Identity.AuthenticationType
Dim PrincipalAuth As String = MyPrincipal.Identity.IsAuthenticated.ToString()

'Identity values.
Dim IdentName As String = MyIdentity.Name
Dim IdentType As String = MyIdentity.AuthenticationType
Dim IdentIsAuth As String = MyIdentity.IsAuthenticated.ToString()
Dim IsG As String = MyIdentity.IsGuest.ToString()
Dim IsSys As String = MyIdentity.IsSystem.ToString()
Dim Token As String = MyIdentity.Token.ToString()

Connecting to SQL server Over Internet/ Phone line etc.

Hi,
I am have an application that is running on table PC and connecting to SQL server using wireless network. But I want to be able also connected to the SQL server from other locations. Is there a way to do that? Without changing all my routines with web se
rvices? I am looking for a way for example to change basically MyConnection if possible.
Any help/ Article will be greatly appreciated
Thanks
Lisa
In order for the application to work you need to be authenticated on the
wireless network. This really has nothing to do with SQL Server.
Thanks,
Kevin McDonnell
Microsoft Corporation
This posting is provided AS IS with no warranties, and confers no rights.
|||Hi Kevin,
Well the application work in 802.11g network.. but I want now it be able to work outside the wireless network say view phone line connection or Internet. That is my question. Any help will be appreciated.
Regards
Lisa
|||Hi Lisa,
The same rules apply. If you're going to allow access via phone line,
then as long as the application can recover from a dropped line, there's no
reason why you couldn't do this. There may be some tcp parameters that you
might need to adjust to account for the slow line speed. You could also
experiment with changing the packetsize in SQL to 512.
Across the internet, you have much more bandwidth. The connection quality
and stability relies on the ISP provider.
Hope this helps
Kevin McDonnell
Microsoft Corporation
This posting is provided AS IS with no warranties, and confers no rights.