ODBC Drivers error '80040e31'

We moved our SQL Server 2000 onto a Win 2003 box (with SQL
SP3a applied).
Lately, we have been experiencing intermittent ADO
timeouts on our webpages displaying the following error:
Microsoft OLE DB Provider for ODBC Drivers
error '80040e31'
[Microsoft][ODBC SQL Server Driver]Timeout expired
If anyone has any ideas as to possible reasons, it would be immensely apprec
iated?
Any help would be greatly appreciated.
Thank you.
- A l p e rMaybe some information here:
http://www.aspfaq.com/2287
Aaron Bertrand
SQL Server MVP
http://www.aspfaq.com/
"Alper" <anonymous@.discussions.microsoft.com> wrote in message
news:3F1AC249-81D0-498F-AB81-E8F628A1F98C@.microsoft.com...
> We moved our SQL Server 2000 onto a Win 2003 box (with SQL
> SP3a applied).
> Lately, we have been experiencing intermittent ADO
> timeouts on our webpages displaying the following error:
> Microsoft OLE DB Provider for ODBC Drivers
> error '80040e31'
> [Microsoft][ODBC SQL Server Driver]Timeout expired
> If anyone has any ideas as to possible reasons, it would be immensely
appreciated?
> Any help would be greatly appreciated.
> Thank you.
> - A l p e r
>|||Thanks Aaron!
I've changed the connection string and am connecting with OLE DB provider no
w...we'll see if it makes any difference...
But I have a feeling it will start throwing time outs any way... May be our
tables, queries, etc. need to be optimized...
Thanks,
- A l p e r
-- Aaron Bertrand - MVP wrote: --
Maybe some information here:
http://www.aspfaq.com/2287
Aaron Bertrand
SQL Server MVP
http://www.aspfaq.com/
"Alper" <anonymous@.discussions.microsoft.com> wrote in message
news:3F1AC249-81D0-498F-AB81-E8F628A1F98C@.microsoft.com...
> SP3a applied).
> timeouts on our webpages displaying the following error:
> error '80040e31'
> [Microsoft][ODBC SQL Server Driver]Timeout expired
appreciated?[vbcol=seagreen]
>sql

ODBC Drivers error '80040e31'

We moved our SQL Server 2000 onto a Win 2003 box (with SQL
SP3a applied).
Lately, we have been experiencing intermittent ADO
timeouts on our webpages displaying the following error:
Microsoft OLE DB Provider for ODBC Drivers
error '80040e31'
[Microsoft][ODBC SQL Server Driver]Timeout expired
If anyone has any ideas as to possible reasons, it would be immensely appreciated?
Any help would be greatly appreciated.
Thank you.
- A l p e r
Maybe some information here:
http://www.aspfaq.com/2287
Aaron Bertrand
SQL Server MVP
http://www.aspfaq.com/
"Alper" <anonymous@.discussions.microsoft.com> wrote in message
news:3F1AC249-81D0-498F-AB81-E8F628A1F98C@.microsoft.com...
> We moved our SQL Server 2000 onto a Win 2003 box (with SQL
> SP3a applied).
> Lately, we have been experiencing intermittent ADO
> timeouts on our webpages displaying the following error:
> Microsoft OLE DB Provider for ODBC Drivers
> error '80040e31'
> [Microsoft][ODBC SQL Server Driver]Timeout expired
> If anyone has any ideas as to possible reasons, it would be immensely
appreciated?
> Any help would be greatly appreciated.
> Thank you.
> - A l p e r
>
|||Thanks Aaron!
I've changed the connection string and am connecting with OLE DB provider now...we'll see if it makes any difference...
But I have a feeling it will start throwing time outs any way... May be our tables, queries, etc. need to be optimized...
Thanks,
- A l p e r
-- Aaron Bertrand - MVP wrote: --
Maybe some information here:
http://www.aspfaq.com/2287
Aaron Bertrand
SQL Server MVP
http://www.aspfaq.com/
"Alper" <anonymous@.discussions.microsoft.com> wrote in message
news:3F1AC249-81D0-498F-AB81-E8F628A1F98C@.microsoft.com...[vbcol=seagreen]
> SP3a applied).
> timeouts on our webpages displaying the following error:
> error '80040e31'
> [Microsoft][ODBC SQL Server Driver]Timeout expired
appreciated?
>

ODBC driver for MySQL

Hello,
I have a mysql database residing on a Linux box and a MS
SQL Server residing on a Win 2000 box. I have installed
a mysql ODBC driver that works fine with ACCESS, however
when I try to use that same Driver in SQL Server (as a
Linked server), I get errors.
For example, in Query Analyzer (or in a Stored Proc) when
I try this Select statement:
SELECT *
FROM OPENQUERY(DataMiner, 'SELECT account_type_name FROM
account_types')
I get this error:
OLE DB provider 'MSDASQL' returned an unexpected data
length for the fixed-length
column '[MSDASQL].account_type_name'. The expected data
length is 20, while the returned data length is 8.
I'm not sure why this is happening. May I be missing
something in my linked server connection? It sure seems
to work fine when hitting it from ACCESS, VB, etc..Hi:
From the error you have, I thin in the sql server field
'account_type_name', you use nchar or char which has a 20 bit, but the value
you want to give the database is 8 bit, you can changed the
'account_type_name' filed type to varchar or nvarchar and try again.
Best Wishes
Wei Ci Zhou|||yes you are right.
Diku
"Wei Ci Zhou" <weicizhou@.hotmail.com.discuss> wrote in message
news:O8Q4Txk5DHA.2736@.TK2MSFTNGP09.phx.gbl...

quote:

---

> Hi:
> From the error you have, I thin in the sql server field
> 'account_type_name', you use nchar or char which has a 20 bit, but the

---

value

quote:

---

> you want to give the database is 8 bit, you can changed the
> 'account_type_name' filed type to varchar or nvarchar and try again.
> Best Wishes
> Wei Ci Zhou
>

---

ODBC Driver for Linux

Hello,
We have an instance of oracle on linux and another with sqlserver on
windows.
We need an odbc driver for the linux box to connect to the sql server.
Does anybody have suggestions on what odbc drivers there are out there for
linux in order for us to connect these two boxes?
Thanks in advance for your help,
Steve K.
I replied to this message in another newsgroup already, but ...
You can connect to the Oracle server from the SQL Server by setting up a
linked server after installing the Oracle Client on the SQL Server.
Books Online contains information about linked servers, or you can check
these links:
http://www.microsoft.com/sql/techinf...ingoracle.mspx
http://www.windowsitpro.com/SQLServe...264/22264.html
It looks like you can use Oracle's Heterogeneous Services (HS) to make
the connection the other way.
http://techrepublic.com.com/5100-9592-5725974.html
Good luck,
Tony Sebion
"Steve Kitley" <steve@.[removethis]kitley.com> wrote in message
news:e8Q5xGtuFHA.1032@.TK2MSFTNGP12.phx.gbl:

> Hello,
> We have an instance of oracle on linux and another with sqlserver on
> windows.
> We need an odbc driver for the linux box to connect to the sql server.
> Does anybody have suggestions on what odbc drivers there are out there for
> linux in order for us to connect these two boxes?
> Thanks in advance for your help,
> Steve K.
|||Thanks a lot Tony.
One last question, you or anyone else know a driver that we could buy
without setting up the linked server?
Thanks again,
Steve
"Tony Sebion" <tony@.sebion.com> wrote in message
news:3p08t0F851inU1@.individual.net...
> I replied to this message in another newsgroup already, but ...
> You can connect to the Oracle server from the SQL Server by setting up a
> linked server after installing the Oracle Client on the SQL Server.
> Books Online contains information about linked servers, or you can check
> these links:
>
http://www.microsoft.com/sql/techinf...ingoracle.mspx[vbcol=seagreen]
> http://www.windowsitpro.com/SQLServe...264/22264.html
> It looks like you can use Oracle's Heterogeneous Services (HS) to make
> the connection the other way.
> http://techrepublic.com.com/5100-9592-5725974.html
> Good luck,
> Tony Sebion
> "Steve Kitley" <steve@.[removethis]kitley.com> wrote in message
> news:e8Q5xGtuFHA.1032@.TK2MSFTNGP12.phx.gbl:
for
>
|||Hi Tony,
the article you sent me for connecting oracle to sql server was based on
oracle 9i being on windows box. We are not using 9i on windows, we are
using 9i (actually 10g) on linux.
Hence, I still need an odbc driver for linux in which to connect to sql
server on a windows box.
Anybody know of any linux odbc drivers?
Thanks,
Steve K.
"Steve K." <steve[remove this]@.kitley.com> wrote in message
news:ODiRC6tuFHA.3764@.TK2MSFTNGP09.phx.gbl...
> Thanks a lot Tony.
> One last question, you or anyone else know a driver that we could buy
> without setting up the linked server?
> Thanks again,
> Steve
>
> "Tony Sebion" <tony@.sebion.com> wrote in message
> news:3p08t0F851inU1@.individual.net...
>
http://www.microsoft.com/sql/techinf...ingoracle.mspx
> for
>
|||Start with DataDirect http://www.datadirect.com/products/odbc/index.ssp This
is the most widely used solution.
OpenLink http://www.openlinksw.com/ also has a driver and Easysoft has an
ODBC-ODBC bridge
http://www.easysoft.com/products/dat...dge/index.html
Be sure to do your own due diligence.
"Steve K." <steve[remove this]@.kitley.com> wrote in message
news:u%23KRB15uFHA.2960@.tk2msftngp13.phx.gbl...
> Hi Tony,
> the article you sent me for connecting oracle to sql server was based on
> oracle 9i being on windows box. We are not using 9i on windows, we are
> using 9i (actually 10g) on linux.
> Hence, I still need an odbc driver for linux in which to connect to sql
> server on a windows box.
> Anybody know of any linux odbc drivers?
> Thanks,
> Steve K.
> "Steve K." <steve[remove this]@.kitley.com> wrote in message
> news:ODiRC6tuFHA.3764@.TK2MSFTNGP09.phx.gbl...
> http://www.microsoft.com/sql/techinf...ingoracle.mspx
>

ODBC Driver for Linux

Hello,
We have an instance of oracle on linux and another with sqlserver on
windows.
We need an odbc driver for the linux box to connect to the sql server.
Does anybody have suggestions on what odbc drivers there are out there for
linux in order for us to connect these two boxes?
Thanks in advance for your help,
Steve K.I replied to this message in another newsgroup already, but ...
You can connect to the Oracle server from the SQL Server by setting up a
linked server after installing the Oracle Client on the SQL Server.
Books Online contains information about linked servers, or you can check
these links:
http://www.microsoft.com/sql/techin...dingoracle.mspx
http://www.windowsitpro.com/SQLServ...2264/22264.html
It looks like you can use Oracle's Heterogeneous Services (HS) to make
the connection the other way.
http://techrepublic.com.com/5100-9592-5725974.html
Good luck,
Tony Sebion
"Steve Kitley" <steve@.[removethis]kitley.com> wrote in message
news:e8Q5xGtuFHA.1032@.TK2MSFTNGP12.phx.gbl:

> Hello,
> We have an instance of oracle on linux and another with sqlserver on
> windows.
> We need an odbc driver for the linux box to connect to the sql server.
> Does anybody have suggestions on what odbc drivers there are out there for
> linux in order for us to connect these two boxes?
> Thanks in advance for your help,
> Steve K.|||Thanks a lot Tony.
One last question, you or anyone else know a driver that we could buy
without setting up the linked server?
Thanks again,
Steve
"Tony Sebion" <tony@.sebion.com> wrote in message
news:3p08t0F851inU1@.individual.net...
> I replied to this message in another newsgroup already, but ...
> You can connect to the Oracle server from the SQL Server by setting up a
> linked server after installing the Oracle Client on the SQL Server.
> Books Online contains information about linked servers, or you can check
> these links:
>
http://www.microsoft.com/sql/techin...dingoracle.mspx
> http://www.windowsitpro.com/SQLServ...2264/22264.html
> It looks like you can use Oracle's Heterogeneous Services (HS) to make
> the connection the other way.
> http://techrepublic.com.com/5100-9592-5725974.html
> Good luck,
> Tony Sebion
> "Steve Kitley" <steve@.[removethis]kitley.com> wrote in message
> news:e8Q5xGtuFHA.1032@.TK2MSFTNGP12.phx.gbl:
>
for[vbcol=seagreen]
>|||Hi Tony,
the article you sent me for connecting oracle to sql server was based on
oracle 9i being on windows box. We are not using 9i on windows, we are
using 9i (actually 10g) on linux.
Hence, I still need an odbc driver for linux in which to connect to sql
server on a windows box.
Anybody know of any linux odbc drivers?
Thanks,
Steve K.
"Steve K." <steve[remove this]@.kitley.com> wrote in message
news:ODiRC6tuFHA.3764@.TK2MSFTNGP09.phx.gbl...
> Thanks a lot Tony.
> One last question, you or anyone else know a driver that we could buy
> without setting up the linked server?
> Thanks again,
> Steve
>
> "Tony Sebion" <tony@.sebion.com> wrote in message
> news:3p08t0F851inU1@.individual.net...
>
http://www.microsoft.com/sql/techin...dingoracle.mspx
> for
>|||Start with DataDirect http://www.datadirect.com/products/odbc/index.ssp This
is the most widely used solution.
OpenLink http://www.openlinksw.com/ also has a driver and Easysoft has an
ODBC-ODBC bridge
http://www.easysoft.com/products/da...idge/index.html
Be sure to do your own due diligence.
"Steve K." <steve[remove this]@.kitley.com> wrote in message
news:u%23KRB15uFHA.2960@.tk2msftngp13.phx.gbl...
> Hi Tony,
> the article you sent me for connecting oracle to sql server was based on
> oracle 9i being on windows box. We are not using 9i on windows, we are
> using 9i (actually 10g) on linux.
> Hence, I still need an odbc driver for linux in which to connect to sql
> server on a windows box.
> Anybody know of any linux odbc drivers?
> Thanks,
> Steve K.
> "Steve K." <steve[remove this]@.kitley.com> wrote in message
> news:ODiRC6tuFHA.3764@.TK2MSFTNGP09.phx.gbl...
> [url]http://www.microsoft.com/sql/techinfo/tips/administration/addingoracle.mspx[/url
]
>

ODBC connection

I am trying to connect to SQL Server using a 3rd party report generating software (dbextra). Everything is located on my local box. I am trying to establish connection through ODBC. Is this installed during setup or is this a function I have to manually set up and configure?

ODBC connections are defined in the "Data Sources (ODBC)" option in the system's "Administrative Tools". You have to set these up manually. Once done, you point the software to the "name" of the ODBC data source you've created.

-Ryan / Kardax

|||

You can connect using ODBC right out of the box through two different paths:

MDAC is already on your Windows computers, you write a normal ODBC connection string for SQL. This typcially uses TCP/IP, so you will need to enable the TCP/IP protocol in SQL Server (it's off by default) using SQL Configuration Manager.