Dear all,
We are using Ipswitch email application “ICS 2006’ with SQL 2000
enterprise edition as database. Occasionally web mail users are facing the
below
error on their web page.
‘ERROR [HY001][Microsoft][ODBC Microsoft Access Driver] Not enough space on
temporary disk. ERROR [IM006][Microsoft][ODBC Driver Manager] Driver’s
SQLSetConnectAttr failed ERROR [HY001][Microsoft][ODBC Microsoft Access
Driver] Not enough space on temporary disk.’
The problem gets rectified only after we restart the IIS service on the mail
server. What could be the reason for this problem? Kindly provide me with
your suggestions.
Regards
Ram
It's an error from MS Access - the cause depends on what you
are doing in Access, what version of Access, etc.
Try posting on one of the Access forums or newsgroups.
-Sue
On Sat, 17 Feb 2007 20:59:08 -0800, Ram
<Ram@.discussions.microsoft.com> wrote:
>Dear all,
> We are using Ipswitch email application ICS 2006 with SQL 2000
>enterprise edition as database. Occasionally web mail users are facing the
>below
>error on their web page.
> ERROR [HY001][Microsoft][ODBC Microsoft Access Driver] Not enough space on
>temporary disk. ERROR [IM006][Microsoft][ODBC Driver Manager] Drivers
>SQLSetConnectAttr failed ERROR [HY001][Microsoft][ODBC Microsoft Access
>Driver] Not enough space on temporary disk.
>The problem gets rectified only after we restart the IIS service on the mail
>server. What could be the reason for this problem? Kindly provide me with
>your suggestions.
>Regards
>Ram
>
Showing posts with label application. Show all posts
Showing posts with label application. Show all posts
Friday, March 30, 2012
ODBC error
Hi,
I've a Third-Party application using a ODBC connection on a remote Acces fil
e (mdb file) (the file reside on a other server, so I map a drive).
I got this error
[[Microsoft][ODBC Microsoft Access Driver] '(unknown)' is not a
valid path. Make sure that the path name is spelled correctly and that you a
re connected to the server on which the file resides.-1023]
Does someone have hints?
ThanksI'm not real clear on what is using what and where but in
general, you want to avoid mapped drives. Try using a UNC
path instead of a mapped drive.
-Sue
On Tue, 20 Apr 2004 07:51:05 -0700, RemCgi
<anonymous@.discussions.microsoft.com> wrote:
>Hi,
>I've a Third-Party application using a ODBC connection on a remote Acces fi
le (mdb file) (the file reside on a other server, so I map a drive).
>I got this error
>[[Microsoft][ODBC Microsoft Access Driver] '(unknown)' is not a
valid path. Make sure that the path name is spelled correctly and that you
are connected to the server on which the file resides.-1023]
>Does someone have hints?
>Thanks
I've a Third-Party application using a ODBC connection on a remote Acces fil
e (mdb file) (the file reside on a other server, so I map a drive).
I got this error
[[Microsoft][ODBC Microsoft Access Driver] '(unknown)' is not a
valid path. Make sure that the path name is spelled correctly and that you a
re connected to the server on which the file resides.-1023]
Does someone have hints?
ThanksI'm not real clear on what is using what and where but in
general, you want to avoid mapped drives. Try using a UNC
path instead of a mapped drive.
-Sue
On Tue, 20 Apr 2004 07:51:05 -0700, RemCgi
<anonymous@.discussions.microsoft.com> wrote:
>Hi,
>I've a Third-Party application using a ODBC connection on a remote Acces fi
le (mdb file) (the file reside on a other server, so I map a drive).
>I got this error
>[[Microsoft][ODBC Microsoft Access Driver] '(unknown)' is not a
valid path. Make sure that the path name is spelled correctly and that you
are connected to the server on which the file resides.-1023]
>Does someone have hints?
>Thanks
ODBC error
Dear all,
We are using Ipswitch email application “ICS 2006’ with SQL 2000
enterprise edition as database. Occasionally web mail users are facing the
below
error on their web page.
‘ERROR [HY001][Microsoft][ODBC Microsoft Access Driver] Not en
ough space on
temporary disk. ERROR [IM006][Microsoft][ODBC Driver Manager] Dr
iver’s
SQLSetConnectAttr failed ERROR [HY001][Microsoft][ODBC Microsoft
Access
Driver] Not enough space on temporary disk.’
The problem gets rectified only after we restart the IIS service on the mail
server. What could be the reason for this problem? Kindly provide me with
your suggestions.
Regards
RamIt's an error from MS Access - the cause depends on what you
are doing in Access, what version of Access, etc.
Try posting on one of the Access forums or newsgroups.
-Sue
On Sat, 17 Feb 2007 20:59:08 -0800, Ram
<Ram@.discussions.microsoft.com> wrote:
>Dear all,
> We are using Ipswitch email application ICS 2006 with SQL 2000
>enterprise edition as database. Occasionally web mail users are facing the
>below
>error on their web page.
> ERROR [HY001][Microsoft][ODBC Microsoft Access Driver] Not en
ough space on
>temporary disk. ERROR [IM006][Microsoft][ODBC Driver Manager] D
rivers
>SQLSetConnectAttr failed ERROR [HY001][Microsoft][ODBC Microsof
t Access
>Driver] Not enough space on temporary disk.
>The problem gets rectified only after we restart the IIS service on the mai
l
>server. What could be the reason for this problem? Kindly provide me with
>your suggestions.
>Regards
>Ram
>sql
We are using Ipswitch email application “ICS 2006’ with SQL 2000
enterprise edition as database. Occasionally web mail users are facing the
below
error on their web page.
‘ERROR [HY001][Microsoft][ODBC Microsoft Access Driver] Not en
ough space on
temporary disk. ERROR [IM006][Microsoft][ODBC Driver Manager] Dr
iver’s
SQLSetConnectAttr failed ERROR [HY001][Microsoft][ODBC Microsoft
Access
Driver] Not enough space on temporary disk.’
The problem gets rectified only after we restart the IIS service on the mail
server. What could be the reason for this problem? Kindly provide me with
your suggestions.
Regards
RamIt's an error from MS Access - the cause depends on what you
are doing in Access, what version of Access, etc.
Try posting on one of the Access forums or newsgroups.
-Sue
On Sat, 17 Feb 2007 20:59:08 -0800, Ram
<Ram@.discussions.microsoft.com> wrote:
>Dear all,
> We are using Ipswitch email application ICS 2006 with SQL 2000
>enterprise edition as database. Occasionally web mail users are facing the
>below
>error on their web page.
> ERROR [HY001][Microsoft][ODBC Microsoft Access Driver] Not en
ough space on
>temporary disk. ERROR [IM006][Microsoft][ODBC Driver Manager] D
rivers
>SQLSetConnectAttr failed ERROR [HY001][Microsoft][ODBC Microsof
t Access
>Driver] Not enough space on temporary disk.
>The problem gets rectified only after we restart the IIS service on the mai
l
>server. What could be the reason for this problem? Kindly provide me with
>your suggestions.
>Regards
>Ram
>sql
ODBC drivers errro '80040e14'
Hi Sir/Madam,
I have a error from my ASP, SQL application as :
Microsoft OLE DB Provider for ODBC Drivers error '80040e14'
[Microsoft][ODBC SQL Server Driver][SQL Server]Cannot sort a row
of size
8162, which is greater than the allowable maximum of 8094.
The SQL query in ASP code as:
SQL = "select * from Entry,Entrant where Entry.EntrantID=Entrant.EntrantID
and entry.Competition = 'MADC2004' order by CatID asc"
As long as I remove the 'order by CatID asc', the error gone. I don't
understand why the 'order by CatID' will cause the error. But I need to sort
the result.
Please help.....
Thank you very much
Ben LI'm guessing that the rows of your result set, since they come from two
tables, total more than 8094 bytes. Certainly you don't need to see
every column of each table, since at the least, you only need to display
EntrantID once, and if you can live with results without all the
columns, you may solve the problem. It's also possible that you really
don't ever have 8094+ bytes in any one row - this could be the case if
you have char or nchar columns where you might be fine with varchar or
nvarchar.
SK
B L wrote:
>Hi Sir/Madam,
>I have a error from my ASP, SQL application as :
>Microsoft OLE DB Provider for ODBC Drivers error '80040e14'
>[Microsoft][ODBC SQL Server Driver][SQL Server]Cannot sort a ro
w of size
>8162, which is greater than the allowable maximum of 8094.
>The SQL query in ASP code as:
>SQL = "select * from Entry,Entrant where Entry.EntrantID=Entrant.EntrantID
>and entry.Competition = 'MADC2004' order by CatID asc"
>As long as I remove the 'order by CatID asc', the error gone. I don't
>understand why the 'order by CatID' will cause the error. But I need to sor
t
>the result.
>Please help.....
>Thank you very much
>Ben L
>
>
>
>
>
>
>|||Hi Steve,
I selected less column and the query working now. Thank you very much for
the information.
Regards
Ben
"Steve Kass" <skass@.drew.edu> wrote in message
news:%23jGFhDZBEHA.3804@.TK2MSFTNGP09.phx.gbl...
> I'm guessing that the rows of your result set, since they come from two
> tables, total more than 8094 bytes. Certainly you don't need to see
> every column of each table, since at the least, you only need to display
> EntrantID once, and if you can live with results without all the
> columns, you may solve the problem. It's also possible that you really
> don't ever have 8094+ bytes in any one row - this could be the case if
> you have char or nchar columns where you might be fine with varchar or
> nvarchar.
> SK
> B L wrote:
>
Entry.EntrantID=Entrant.EntrantID
sort
>
I have a error from my ASP, SQL application as :
Microsoft OLE DB Provider for ODBC Drivers error '80040e14'
[Microsoft][ODBC SQL Server Driver][SQL Server]Cannot sort a row
of size
8162, which is greater than the allowable maximum of 8094.
The SQL query in ASP code as:
SQL = "select * from Entry,Entrant where Entry.EntrantID=Entrant.EntrantID
and entry.Competition = 'MADC2004' order by CatID asc"
As long as I remove the 'order by CatID asc', the error gone. I don't
understand why the 'order by CatID' will cause the error. But I need to sort
the result.
Please help.....
Thank you very much
Ben LI'm guessing that the rows of your result set, since they come from two
tables, total more than 8094 bytes. Certainly you don't need to see
every column of each table, since at the least, you only need to display
EntrantID once, and if you can live with results without all the
columns, you may solve the problem. It's also possible that you really
don't ever have 8094+ bytes in any one row - this could be the case if
you have char or nchar columns where you might be fine with varchar or
nvarchar.
SK
B L wrote:
>Hi Sir/Madam,
>I have a error from my ASP, SQL application as :
>Microsoft OLE DB Provider for ODBC Drivers error '80040e14'
>[Microsoft][ODBC SQL Server Driver][SQL Server]Cannot sort a ro
w of size
>8162, which is greater than the allowable maximum of 8094.
>The SQL query in ASP code as:
>SQL = "select * from Entry,Entrant where Entry.EntrantID=Entrant.EntrantID
>and entry.Competition = 'MADC2004' order by CatID asc"
>As long as I remove the 'order by CatID asc', the error gone. I don't
>understand why the 'order by CatID' will cause the error. But I need to sor
t
>the result.
>Please help.....
>Thank you very much
>Ben L
>
>
>
>
>
>
>|||Hi Steve,
I selected less column and the query working now. Thank you very much for
the information.
Regards
Ben
"Steve Kass" <skass@.drew.edu> wrote in message
news:%23jGFhDZBEHA.3804@.TK2MSFTNGP09.phx.gbl...
> I'm guessing that the rows of your result set, since they come from two
> tables, total more than 8094 bytes. Certainly you don't need to see
> every column of each table, since at the least, you only need to display
> EntrantID once, and if you can live with results without all the
> columns, you may solve the problem. It's also possible that you really
> don't ever have 8094+ bytes in any one row - this could be the case if
> you have char or nchar columns where you might be fine with varchar or
> nvarchar.
> SK
> B L wrote:
>
Entry.EntrantID=Entrant.EntrantID
sort
>
Wednesday, March 28, 2012
ODBC Driver Error - Timeout Expired
Very common error but wired scenario. Every client machine get this error in morning. VB application works fine until evening but when everyone goes home after shut down the machine and they come back again in morning and try to run the application they get this error. Application runs fine, It can access data, pull data, view data but It can not write any data. (Other words can not enter any data).
Application again starts working fine after I copy database on different SQL server. For temporary solution I swap database from one SQL Server to other one day and back to original SQL server next day. Every morning it takes about 2 hours to copy database. Im doing this from last few days as working solution. FYI, I have 2 different VB application, each has their own database. One working fine and other started giving me problem, the one I described above.
Few thing I want to let you know:
Recently I changed the SQL server. After I changed I started having this problem. But other application working fine. So I dont think that could be a problem. (Both application basically same in terms of development and tools they use. VB and SQL Server, ODBC connection, Crystal Reports).
In old SQL server both database had daily backup on third party backup built on different server using Client Network Backup. After I changed the SQL server I never modify backup setting. So after I moved SQL server , every night backup was trying to connect to old SQL server and but It couldnt take the backup cause I changed the machine. Again if thats the problem both application should not work but one working fine other is giving me problem.
One more thing I want to mention here is I started having this problem when I left the SQL server copying database overnight. Means, I started copying database and I left the machine ON when I came in the morning copying database was done and I just click on the OK and close the window. Basically It has finished copying database in around 2 hours after I started and I close the window when I came back next morning.
Thats the few things Im thinking about but I dont know what kind of database setting this might have changed and how to reset again. Any help will appreciated.
Dose any one know how to combine .mdf (Primary data file) and .ndf (secondary data file) ?To answer your direct question, use DBCC SHRINKFILE (http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_dbcc_8b51.asp) to empty the NDF file, then use ALTER DATABASE (http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_aa-az_4e5h.asp) to deactivate the NDF file. At that point, you can then simply delete the NDF file because it is no longer part of your database.
As a separate issue, I'd suspect that the third party backup is somehow causing your problem with users being unable to write data. I'm not sure how it is interfering. There are many third party backup solutions, with varying degrees of compatibility with SQL Server. Almost all of them work under their ideal conditions, almost all of them break down under other conditions.
Just as a point of curiousity, does the problem persist if you reboot NT on the machine that runs SQL Server? IF there is some problem with file locking, etc. that should clear up the problem for you a lot more quickly and simply than having to copy the database to another server. It would also give you some valuable information for trying to locate the real source of your problem.
-PatP|||Thanks for .ndf tip.
No, It wouldnt clear the problem if restart the NT machine. Just today I tried another solution, I dont know if its going to work but what I did is create the new database and import the data from the original database which already solved my .ndf file problem, now I have only one data file. I dont know if its going to work. I will find out tomorrow morning.
I also noticed one thing today someone created (there is couple of people have access to server) one more filegroup which is Primary_1. There was not any file in that group so I tried to delete that group but It would not delete It just kept freezing.
One question, If I created the new database with same name and import data using SQL server Import function where I choose Import all Objects. Is it going to have any problem in terms of data. I mean tables and views are all imported. It just changed 2 data file to one data file and also got rid of that Primary_1 file group. Just wondering if its going to make any difference in data. I mean I'm going to loose some data or anything like that. Application functions fine.
Thanks.sql
Application again starts working fine after I copy database on different SQL server. For temporary solution I swap database from one SQL Server to other one day and back to original SQL server next day. Every morning it takes about 2 hours to copy database. Im doing this from last few days as working solution. FYI, I have 2 different VB application, each has their own database. One working fine and other started giving me problem, the one I described above.
Few thing I want to let you know:
Recently I changed the SQL server. After I changed I started having this problem. But other application working fine. So I dont think that could be a problem. (Both application basically same in terms of development and tools they use. VB and SQL Server, ODBC connection, Crystal Reports).
In old SQL server both database had daily backup on third party backup built on different server using Client Network Backup. After I changed the SQL server I never modify backup setting. So after I moved SQL server , every night backup was trying to connect to old SQL server and but It couldnt take the backup cause I changed the machine. Again if thats the problem both application should not work but one working fine other is giving me problem.
One more thing I want to mention here is I started having this problem when I left the SQL server copying database overnight. Means, I started copying database and I left the machine ON when I came in the morning copying database was done and I just click on the OK and close the window. Basically It has finished copying database in around 2 hours after I started and I close the window when I came back next morning.
Thats the few things Im thinking about but I dont know what kind of database setting this might have changed and how to reset again. Any help will appreciated.
Dose any one know how to combine .mdf (Primary data file) and .ndf (secondary data file) ?To answer your direct question, use DBCC SHRINKFILE (http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_dbcc_8b51.asp) to empty the NDF file, then use ALTER DATABASE (http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_aa-az_4e5h.asp) to deactivate the NDF file. At that point, you can then simply delete the NDF file because it is no longer part of your database.
As a separate issue, I'd suspect that the third party backup is somehow causing your problem with users being unable to write data. I'm not sure how it is interfering. There are many third party backup solutions, with varying degrees of compatibility with SQL Server. Almost all of them work under their ideal conditions, almost all of them break down under other conditions.
Just as a point of curiousity, does the problem persist if you reboot NT on the machine that runs SQL Server? IF there is some problem with file locking, etc. that should clear up the problem for you a lot more quickly and simply than having to copy the database to another server. It would also give you some valuable information for trying to locate the real source of your problem.
-PatP|||Thanks for .ndf tip.
No, It wouldnt clear the problem if restart the NT machine. Just today I tried another solution, I dont know if its going to work but what I did is create the new database and import the data from the original database which already solved my .ndf file problem, now I have only one data file. I dont know if its going to work. I will find out tomorrow morning.
I also noticed one thing today someone created (there is couple of people have access to server) one more filegroup which is Primary_1. There was not any file in that group so I tried to delete that group but It would not delete It just kept freezing.
One question, If I created the new database with same name and import data using SQL server Import function where I choose Import all Objects. Is it going to have any problem in terms of data. I mean tables and views are all imported. It just changed 2 data file to one data file and also got rid of that Primary_1 file group. Just wondering if its going to make any difference in data. I mean I'm going to loose some data or anything like that. Application functions fine.
Thanks.sql
ODBC Driver development
Hi everybody,
I want to develop an ODBC driver to connect a normal windows application to
a middleware product.
I can't find any examples or hints with regard to ODBC driver development.
Here are the questions:
- Does anybody have experience with ODBC driver development?
- Can anybody provide me with an example of (rudimentary) ODBC driver code?
- Any hints / documentation tips / experiences?
Thanks already.
Kindest Regards,
Arthur.You may want to start by reviewing the ODBC Programmers Reference at:
http://msdn.microsoft.com/library/e...this_manual.asp
-Sue
On Thu, 3 Jun 2004 15:57:00 +0200, "Arthur van Rossum"
<arthurvanrossum@.mail.com> wrote:
>Hi everybody,
>I want to develop an ODBC driver to connect a normal windows application to
>a middleware product.
>I can't find any examples or hints with regard to ODBC driver development.
>Here are the questions:
>- Does anybody have experience with ODBC driver development?
>- Can anybody provide me with an example of (rudimentary) ODBC driver code?
>- Any hints / documentation tips / experiences?
>Thanks already.
>Kindest Regards,
>Arthur.
>|||Thank you Sue.
I have been browsed through this documentation.
Gives some more insight.
I'm still interrested in sample code etc.
Cheers,
Arthur.
"Sue Hoegemeier" <Sue_H@.nomail.please> schreef in bericht
news:k7hub09ev6ff65260iddc294f4h8k61ceq@.
4ax.com...
> You may want to start by reviewing the ODBC Programmers Reference at:
> http://msdn.microsoft.com/library/e...this_manual.asp
> -Sue
> On Thu, 3 Jun 2004 15:57:00 +0200, "Arthur van Rossum"
> <arthurvanrossum@.mail.com> wrote:
>
to[vbcol=seagreen]
development.[vbcol=seagreen]
code?[vbcol=seagreen]
>|||The ODBC SDK used to have samples - possibly the MDAC SDK
has some ODBC samples. The MDAC downloads and SDKs are
located at:
http://msdn.microsoft.com/data/mdac/default.aspx
-Sue
On Sat, 5 Jun 2004 17:40:23 +0200, "Arthur van Rossum"
<arthurvanrossum@.mail.com> wrote:
>Thank you Sue.
>I have been browsed through this documentation.
>Gives some more insight.
>I'm still interrested in sample code etc.
>Cheers,
>Arthur.
>
>"Sue Hoegemeier" <Sue_H@.nomail.please> schreef in bericht
> news:k7hub09ev6ff65260iddc294f4h8k61ceq@.
4ax.com...
>to
>development.
>code?
>
I want to develop an ODBC driver to connect a normal windows application to
a middleware product.
I can't find any examples or hints with regard to ODBC driver development.
Here are the questions:
- Does anybody have experience with ODBC driver development?
- Can anybody provide me with an example of (rudimentary) ODBC driver code?
- Any hints / documentation tips / experiences?
Thanks already.
Kindest Regards,
Arthur.You may want to start by reviewing the ODBC Programmers Reference at:
http://msdn.microsoft.com/library/e...this_manual.asp
-Sue
On Thu, 3 Jun 2004 15:57:00 +0200, "Arthur van Rossum"
<arthurvanrossum@.mail.com> wrote:
>Hi everybody,
>I want to develop an ODBC driver to connect a normal windows application to
>a middleware product.
>I can't find any examples or hints with regard to ODBC driver development.
>Here are the questions:
>- Does anybody have experience with ODBC driver development?
>- Can anybody provide me with an example of (rudimentary) ODBC driver code?
>- Any hints / documentation tips / experiences?
>Thanks already.
>Kindest Regards,
>Arthur.
>|||Thank you Sue.
I have been browsed through this documentation.
Gives some more insight.
I'm still interrested in sample code etc.
Cheers,
Arthur.
"Sue Hoegemeier" <Sue_H@.nomail.please> schreef in bericht
news:k7hub09ev6ff65260iddc294f4h8k61ceq@.
4ax.com...
> You may want to start by reviewing the ODBC Programmers Reference at:
> http://msdn.microsoft.com/library/e...this_manual.asp
> -Sue
> On Thu, 3 Jun 2004 15:57:00 +0200, "Arthur van Rossum"
> <arthurvanrossum@.mail.com> wrote:
>
to[vbcol=seagreen]
development.[vbcol=seagreen]
code?[vbcol=seagreen]
>|||The ODBC SDK used to have samples - possibly the MDAC SDK
has some ODBC samples. The MDAC downloads and SDKs are
located at:
http://msdn.microsoft.com/data/mdac/default.aspx
-Sue
On Sat, 5 Jun 2004 17:40:23 +0200, "Arthur van Rossum"
<arthurvanrossum@.mail.com> wrote:
>Thank you Sue.
>I have been browsed through this documentation.
>Gives some more insight.
>I'm still interrested in sample code etc.
>Cheers,
>Arthur.
>
>"Sue Hoegemeier" <Sue_H@.nomail.please> schreef in bericht
> news:k7hub09ev6ff65260iddc294f4h8k61ceq@.
4ax.com...
>to
>development.
>code?
>
ODBC Driver development
Hi everybody,
I want to develop an ODBC driver to connect a normal windows application to
a middleware product.
I can't find any examples or hints with regard to ODBC driver development.
Here are the questions:
- Does anybody have experience with ODBC driver development?
- Can anybody provide me with an example of (rudimentary) ODBC driver code?
- Any hints / documentation tips / experiences?
Thanks already.
Kindest Regards,
Arthur.
You may want to start by reviewing the ODBC Programmers Reference at:
http://msdn.microsoft.com/library/en...his_manual.asp
-Sue
On Thu, 3 Jun 2004 15:57:00 +0200, "Arthur van Rossum"
<arthurvanrossum@.mail.com> wrote:
>Hi everybody,
>I want to develop an ODBC driver to connect a normal windows application to
>a middleware product.
>I can't find any examples or hints with regard to ODBC driver development.
>Here are the questions:
>- Does anybody have experience with ODBC driver development?
>- Can anybody provide me with an example of (rudimentary) ODBC driver code?
>- Any hints / documentation tips / experiences?
>Thanks already.
>Kindest Regards,
>Arthur.
>
|||Thank you Sue.
I have been browsed through this documentation.
Gives some more insight.
I'm still interrested in sample code etc.
Cheers,
Arthur.
"Sue Hoegemeier" <Sue_H@.nomail.please> schreef in bericht
news:k7hub09ev6ff65260iddc294f4h8k61ceq@.4ax.com... [vbcol=seagreen]
> You may want to start by reviewing the ODBC Programmers Reference at:
> http://msdn.microsoft.com/library/en...his_manual.asp
> -Sue
> On Thu, 3 Jun 2004 15:57:00 +0200, "Arthur van Rossum"
> <arthurvanrossum@.mail.com> wrote:
to[vbcol=seagreen]
development.[vbcol=seagreen]
code?
>
|||The ODBC SDK used to have samples - possibly the MDAC SDK
has some ODBC samples. The MDAC downloads and SDKs are
located at:
http://msdn.microsoft.com/data/mdac/default.aspx
-Sue
On Sat, 5 Jun 2004 17:40:23 +0200, "Arthur van Rossum"
<arthurvanrossum@.mail.com> wrote:
>Thank you Sue.
>I have been browsed through this documentation.
>Gives some more insight.
>I'm still interrested in sample code etc.
>Cheers,
>Arthur.
>
>"Sue Hoegemeier" <Sue_H@.nomail.please> schreef in bericht
>news:k7hub09ev6ff65260iddc294f4h8k61ceq@.4ax.com.. .
>to
>development.
>code?
>
I want to develop an ODBC driver to connect a normal windows application to
a middleware product.
I can't find any examples or hints with regard to ODBC driver development.
Here are the questions:
- Does anybody have experience with ODBC driver development?
- Can anybody provide me with an example of (rudimentary) ODBC driver code?
- Any hints / documentation tips / experiences?
Thanks already.
Kindest Regards,
Arthur.
You may want to start by reviewing the ODBC Programmers Reference at:
http://msdn.microsoft.com/library/en...his_manual.asp
-Sue
On Thu, 3 Jun 2004 15:57:00 +0200, "Arthur van Rossum"
<arthurvanrossum@.mail.com> wrote:
>Hi everybody,
>I want to develop an ODBC driver to connect a normal windows application to
>a middleware product.
>I can't find any examples or hints with regard to ODBC driver development.
>Here are the questions:
>- Does anybody have experience with ODBC driver development?
>- Can anybody provide me with an example of (rudimentary) ODBC driver code?
>- Any hints / documentation tips / experiences?
>Thanks already.
>Kindest Regards,
>Arthur.
>
|||Thank you Sue.
I have been browsed through this documentation.
Gives some more insight.
I'm still interrested in sample code etc.
Cheers,
Arthur.
"Sue Hoegemeier" <Sue_H@.nomail.please> schreef in bericht
news:k7hub09ev6ff65260iddc294f4h8k61ceq@.4ax.com... [vbcol=seagreen]
> You may want to start by reviewing the ODBC Programmers Reference at:
> http://msdn.microsoft.com/library/en...his_manual.asp
> -Sue
> On Thu, 3 Jun 2004 15:57:00 +0200, "Arthur van Rossum"
> <arthurvanrossum@.mail.com> wrote:
to[vbcol=seagreen]
development.[vbcol=seagreen]
code?
>
|||The ODBC SDK used to have samples - possibly the MDAC SDK
has some ODBC samples. The MDAC downloads and SDKs are
located at:
http://msdn.microsoft.com/data/mdac/default.aspx
-Sue
On Sat, 5 Jun 2004 17:40:23 +0200, "Arthur van Rossum"
<arthurvanrossum@.mail.com> wrote:
>Thank you Sue.
>I have been browsed through this documentation.
>Gives some more insight.
>I'm still interrested in sample code etc.
>Cheers,
>Arthur.
>
>"Sue Hoegemeier" <Sue_H@.nomail.please> schreef in bericht
>news:k7hub09ev6ff65260iddc294f4h8k61ceq@.4ax.com.. .
>to
>development.
>code?
>
ODBC Driver (for SQL Server 2005) unable to retrive CRecorset''s fields values
I am using MFC ODBC classes in my VC++ application for database accesss (on a SQL Server 2005 Database).
After opening a Recordset I have to use the CRecordset::GetFieldValue( LPCTSTR lpszName, CDBVariant& varValue, short nFieldType = DEFAULT_FIELD_TYPE ) method of the CRecordset object to obtain field values. The above method works fine with ODBC drivers for Jet but when I use ODBC for SQL Server it throws the following exception.
After opening a Recordset I have to use the CRecordset::GetFieldValue( LPCTSTR lpszName, CDBVariant& varValue, short nFieldType = DEFAULT_FIELD_TYPE ) method of the CRecordset object to obtain field values. The above method works fine with ODBC drivers for Jet but when I use ODBC for SQL Server it throws the following exception.
State:S1002,Native:0,Origin:[Microsoft][
ODBC SQL Server Driver] Invalid
Descriptor Index
I don't understand why the Microsoft SQL Server ODBC Driver is throwing this
exception.
Please help me!
Michael.
I am having the same exact problem! Does anyone have any input?
Jon
|||Me too.|||I solved my problem. My situdation is: I use MFC wizard to generate the ODBC code and all the columns have been bound. I got the same error as your guys when I call GetFieldValue(). But since all columns have been bound, don't call GetFieldValue(), instead, directly access the member variable of the derived recordset class. Then problem disappeard.
ODBC Driver (for SQL Server 2005) unable to retrive CRecorset''s fields values
I am using MFC ODBC classes in my VC++ application for database accesss (on a SQL Server 2005 Database).
After opening a Recordset I have to use the CRecordset::GetFieldValue( LPCTSTR lpszName, CDBVariant& varValue, short nFieldType = DEFAULT_FIELD_TYPE ) method of the CRecordset object to obtain field values. The above method works fine with ODBC drivers for Jet but when I use ODBC for SQL Server it throws the following exception.
After opening a Recordset I have to use the CRecordset::GetFieldValue( LPCTSTR lpszName, CDBVariant& varValue, short nFieldType = DEFAULT_FIELD_TYPE ) method of the CRecordset object to obtain field values. The above method works fine with ODBC drivers for Jet but when I use ODBC for SQL Server it throws the following exception.
State:S1002,Native:0,Origin:[Microsoft][
ODBC SQL Server Driver] Invalid
Descriptor Index
I don't understand why the Microsoft SQL Server ODBC Driver is throwing this
exception.
Please help me!
Michael.
I am having the same exact problem! Does anyone have any input?
Jon
|||Me too.|||I solved my problem. My situdation is: I use MFC wizard to generate the ODBC code and all the columns have been bound. I got the same error as your guys when I call GetFieldValue(). But since all columns have been bound, don't call GetFieldValue(), instead, directly access the member variable of the derived recordset class. Then problem disappeard.
ODBC Driver (for SQL Server 2005) unable to retrive CRecorset's fields values
I am using MFC ODBC classes in my VC++ application for database accesss (on a SQL Server 2005 Database).
After opening a Recordset I have to use the CRecordset::GetFieldValue( LPCTSTR lpszName, CDBVariant& varValue, short nFieldType = DEFAULT_FIELD_TYPE ) method of the CRecordset object to obtain field values. The above method works fine with ODBC drivers for Jet but when I use ODBC for SQL Server it throws the following exception.
After opening a Recordset I have to use the CRecordset::GetFieldValue( LPCTSTR lpszName, CDBVariant& varValue, short nFieldType = DEFAULT_FIELD_TYPE ) method of the CRecordset object to obtain field values. The above method works fine with ODBC drivers for Jet but when I use ODBC for SQL Server it throws the following exception.
State:S1002,Native:0,Origin:[Microsoft][
ODBC SQL Server Driver] Invalid
Descriptor Index
I don't understand why the Microsoft SQL Server ODBC Driver is throwing this
exception.
Please help me!
Michael.
I am having the same exact problem! Does anyone have any input?
Jon
|||Me too.|||
I solved my problem. My situdation is: I use MFC wizard to generate the ODBC code and all the columns have been bound. I got the same error as your guys when I call GetFieldValue(). But since all columns have been bound, don't call GetFieldValue(), instead, directly access the member variable of the derived recordset class. Then problem disappeard.
sql
ODBC Driver (for SQL Server 2005) unable to retrive CRecorset's fields values
I am using MFC ODBC classes in my VC++ application for database accesss (on a SQL Server 2005 Database).
After opening a Recordset I have to use the CRecordset::GetFieldValue( LPCTSTR lpszName, CDBVariant& varValue, short nFieldType = DEFAULT_FIELD_TYPE ) method of the CRecordset object to obtain field values. The above method works fine with ODBC drivers for Jet but when I use ODBC for SQL Server it throws the following exception.
After opening a Recordset I have to use the CRecordset::GetFieldValue( LPCTSTR lpszName, CDBVariant& varValue, short nFieldType = DEFAULT_FIELD_TYPE ) method of the CRecordset object to obtain field values. The above method works fine with ODBC drivers for Jet but when I use ODBC for SQL Server it throws the following exception.
State:S1002,Native:0,Origin:[Microsoft][
ODBC SQL Server Driver] Invalid
Descriptor Index
I don't understand why the Microsoft SQL Server ODBC Driver is throwing this
exception.
Please help me!
Michael.
I am having the same exact problem! Does anyone have any input?
Jon
Monday, March 26, 2012
ODBC DataSource name problem
Hi All
We have an application which is used the ODBC Data Source to comunicate
with the database. So during the installation of the product the
installation creating
the database name like : VAPost and server = datasource name which is 'VAPos
t'
not the real server name in the Microsoft SQL server DSN Configuration optio
n.
Also the installation is created the Alias in SQL Server Client Network
Utility for
'VAPost' which has Server alias = 'VAPost', NetWork library = 'TCP/IP' and
the Connection parameters is the ip address of the server.
So my application is used the DSN name 'VAPost' to connect to the database b
ut
there is an error message regarding "Communication Link Failure". I could
not figure out where is the problem but the same configuration it works on
other server. Any help is greatly appreciated.
Thanks,
JodieHi Jodie,
You are using a system DSN? You should access that DSN using a ".Net
Providers\ODBC data providers" Connection. Configure it to use the DSN.
Then within the dataflow, create a DataReader data source. Set it to use th
e
DSN connection. You control what is being pulled by the SQLCommand on the
second tab.
-Steven
"Jodie" wrote:
> Hi All
> We have an application which is used the ODBC Data Source to comunicate
> with the database. So during the installation of the product the
> installation creating
> the database name like : VAPost and server = datasource name which is 'VAP
ost'
> not the real server name in the Microsoft SQL server DSN Configuration opt
ion.
> Also the installation is created the Alias in SQL Server Client Network
> Utility for
> 'VAPost' which has Server alias = 'VAPost', NetWork library = 'TCP/IP' and
> the Connection parameters is the ip address of the server.
> So my application is used the DSN name 'VAPost' to connect to the database
but
> there is an error message regarding "Communication Link Failure". I could
> not figure out where is the problem but the same configuration it works on
> other server. Any help is greatly appreciated.
> Thanks,
> Jodie
>
We have an application which is used the ODBC Data Source to comunicate
with the database. So during the installation of the product the
installation creating
the database name like : VAPost and server = datasource name which is 'VAPos
t'
not the real server name in the Microsoft SQL server DSN Configuration optio
n.
Also the installation is created the Alias in SQL Server Client Network
Utility for
'VAPost' which has Server alias = 'VAPost', NetWork library = 'TCP/IP' and
the Connection parameters is the ip address of the server.
So my application is used the DSN name 'VAPost' to connect to the database b
ut
there is an error message regarding "Communication Link Failure". I could
not figure out where is the problem but the same configuration it works on
other server. Any help is greatly appreciated.
Thanks,
JodieHi Jodie,
You are using a system DSN? You should access that DSN using a ".Net
Providers\ODBC data providers" Connection. Configure it to use the DSN.
Then within the dataflow, create a DataReader data source. Set it to use th
e
DSN connection. You control what is being pulled by the SQLCommand on the
second tab.
-Steven
"Jodie" wrote:
> Hi All
> We have an application which is used the ODBC Data Source to comunicate
> with the database. So during the installation of the product the
> installation creating
> the database name like : VAPost and server = datasource name which is 'VAP
ost'
> not the real server name in the Microsoft SQL server DSN Configuration opt
ion.
> Also the installation is created the Alias in SQL Server Client Network
> Utility for
> 'VAPost' which has Server alias = 'VAPost', NetWork library = 'TCP/IP' and
> the Connection parameters is the ip address of the server.
> So my application is used the DSN name 'VAPost' to connect to the database
but
> there is an error message regarding "Communication Link Failure". I could
> not figure out where is the problem but the same configuration it works on
> other server. Any help is greatly appreciated.
> Thanks,
> Jodie
>
odbc datagrida
Good Day,
I got a table with company details.I am using ODBC to conect to it.
OdbcCommand cmd = new OdbcCommand("use company", MyConnection);
The
ERROR [07002] [MySQL][ODBC 3.51 Driver][mysqld-5.0.27-community-nt]SQLBindParameter not used for all parameters
When line 3 is replaced by cmd.CommandText = "SELECT * FROM employee;"; the program works. fine.
I got a table with company details.I am using ODBC to conect to it.
I am writing a windows form application in C# 2005 express edition.The task is to search companies. my code is as below.
OdbcCommand cmd = new OdbcCommand("use company", MyConnection);
cmd.CommandText = "SELECT * FROM employee WHERE Name = ?;"; /****line 3*****/
cmd.Parameters.Add("@.Name", OdbcType.VarChar, 30);
cmd.Parameters["@.Name"].Value = textBox1.Text;
cmd.ExecuteNonQuery();
OdbcDataAdapter datadapter = new OdbcDataAdapter(cmd.CommandText, MyConnection);
DataSet dataset = new DataSet();
datadapter.Fill(dataset,"employee"); /**error line***/
dataGridView1.DataMember="employee";
dataGridView1.DataSource=dataset;
The
above code compiles cleanly but when you run it,it gives a error. the
error statemnet is as below and the line giving error is show above in
coment.
ERROR [07002] [MySQL][ODBC 3.51 Driver][mysqld-5.0.27-community-nt]SQLBindParameter not used for all parameters
When line 3 is replaced by cmd.CommandText = "SELECT * FROM employee;"; the program works. fine.
I can view all employees only.BUT not a specific employee.
the problem looks complex.If some-one can help me out,it would be much appreciated.
Thanx
Rahul SK
msn add:ar_kul@.hotmail.comDo you sure that 'Name' field is exists in this table?
odbc datagrida
Good Day,
I got a table with company details.I am using ODBC to conect to it.
OdbcCommand cmd = new OdbcCommand("use company", MyConnection);
The above code compiles cleanly but when you run it,it gives a error. the error statemnet is as below and the line giving error is show above in coment.
ERROR [07002] [MySQL][ODBC 3.51 Driver][mysqld-5.0.27-community-nt]SQLBindParameter not used for all parameters
When line 3 is replaced by cmd.CommandText = "SELECT * FROM employee;"; the program works. fine.
I got a table with company details.I am using ODBC to conect to it.
I am writing a windows form application in C# 2005 express edition.The task is to search companies. my code is as below.
OdbcCommand cmd = new OdbcCommand("use company", MyConnection);
cmd.CommandText = "SELECT * FROM employee WHERE Name = ?;"; /****line 3*****/
cmd.Parameters.Add("@.Name", OdbcType.VarChar, 30);
cmd.Parameters["@.Name"].Value = textBox1.Text;
cmd.ExecuteNonQuery();
OdbcDataAdapter datadapter = new OdbcDataAdapter(cmd.CommandText, MyConnection);
DataSet dataset = new DataSet();
datadapter.Fill(dataset,"employee"); /**error line***/
dataGridView1.DataMember="employee";
dataGridView1.DataSource=dataset;
The above code compiles cleanly but when you run it,it gives a error. the error statemnet is as below and the line giving error is show above in coment.
ERROR [07002] [MySQL][ODBC 3.51 Driver][mysqld-5.0.27-community-nt]SQLBindParameter not used for all parameters
When line 3 is replaced by cmd.CommandText = "SELECT * FROM employee;"; the program works. fine.
I can view all employees only.BUT not a specific employee.
the problem looks complex.If some-one can help me out,it would be much appreciated.
Thanx
Rahul SK
msn add:ar_kul@.hotmail.comDo you sure that 'Name' field is exists in this table?
sql
Friday, March 23, 2012
ODBC Connection Setup
I'm running SBS 2003 Premium SP1 and all is well. I've installed a new SQL
based application that requires a simple ODBC connection to the SQL database
.
I have about 50 PCs to setup this ODBC link to my SBS server and there must
be a faster way to do this via a script or through Group Policies.
Has anyone tried this and how? I've used GPs for simple things like folder
redirection, but I'm not that strong on it.
Thanks.
KenI've taken to using file-based DSNs placed in a server folder that everyone
can access. It's turned out to be the best solution in my case.
Randall Arnold
"shepcon" <shepcon@.discussions.microsoft.com> wrote in message
news:E02D79DC-D435-4C36-9FF8-4C541F6116D4@.microsoft.com...
> I'm running SBS 2003 Premium SP1 and all is well. I've installed a new
> SQL
> based application that requires a simple ODBC connection to the SQL
> database.
> I have about 50 PCs to setup this ODBC link to my SBS server and there
> must
> be a faster way to do this via a script or through Group Policies.
> Has anyone tried this and how? I've used GPs for simple things like
> folder
> redirection, but I'm not that strong on it.
> Thanks.
> Ken
>sql
based application that requires a simple ODBC connection to the SQL database
.
I have about 50 PCs to setup this ODBC link to my SBS server and there must
be a faster way to do this via a script or through Group Policies.
Has anyone tried this and how? I've used GPs for simple things like folder
redirection, but I'm not that strong on it.
Thanks.
KenI've taken to using file-based DSNs placed in a server folder that everyone
can access. It's turned out to be the best solution in my case.
Randall Arnold
"shepcon" <shepcon@.discussions.microsoft.com> wrote in message
news:E02D79DC-D435-4C36-9FF8-4C541F6116D4@.microsoft.com...
> I'm running SBS 2003 Premium SP1 and all is well. I've installed a new
> SQL
> based application that requires a simple ODBC connection to the SQL
> database.
> I have about 50 PCs to setup this ODBC link to my SBS server and there
> must
> be a faster way to do this via a script or through Group Policies.
> Has anyone tried this and how? I've used GPs for simple things like
> folder
> redirection, but I'm not that strong on it.
> Thanks.
> Ken
>sql
ODBC Connection Setup
I'm running SBS 2003 Premium SP1 and all is well. I've installed a new SQL
based application that requires a simple ODBC connection to the SQL database.
I have about 50 PCs to setup this ODBC link to my SBS server and there must
be a faster way to do this via a script or through Group Policies.
Has anyone tried this and how? I've used GPs for simple things like folder
redirection, but I'm not that strong on it.
Thanks.
Ken
I've taken to using file-based DSNs placed in a server folder that everyone
can access. It's turned out to be the best solution in my case.
Randall Arnold
"shepcon" <shepcon@.discussions.microsoft.com> wrote in message
news:E02D79DC-D435-4C36-9FF8-4C541F6116D4@.microsoft.com...
> I'm running SBS 2003 Premium SP1 and all is well. I've installed a new
> SQL
> based application that requires a simple ODBC connection to the SQL
> database.
> I have about 50 PCs to setup this ODBC link to my SBS server and there
> must
> be a faster way to do this via a script or through Group Policies.
> Has anyone tried this and how? I've used GPs for simple things like
> folder
> redirection, but I'm not that strong on it.
> Thanks.
> Ken
>
based application that requires a simple ODBC connection to the SQL database.
I have about 50 PCs to setup this ODBC link to my SBS server and there must
be a faster way to do this via a script or through Group Policies.
Has anyone tried this and how? I've used GPs for simple things like folder
redirection, but I'm not that strong on it.
Thanks.
Ken
I've taken to using file-based DSNs placed in a server folder that everyone
can access. It's turned out to be the best solution in my case.
Randall Arnold
"shepcon" <shepcon@.discussions.microsoft.com> wrote in message
news:E02D79DC-D435-4C36-9FF8-4C541F6116D4@.microsoft.com...
> I'm running SBS 2003 Premium SP1 and all is well. I've installed a new
> SQL
> based application that requires a simple ODBC connection to the SQL
> database.
> I have about 50 PCs to setup this ODBC link to my SBS server and there
> must
> be a faster way to do this via a script or through Group Policies.
> Has anyone tried this and how? I've used GPs for simple things like
> folder
> redirection, but I'm not that strong on it.
> Thanks.
> Ken
>
odbc connection multi domain no trust
If you have one domain of application servers running win2000 and seperate
user domains with no trust relationships accessing sql databases on the
application domain what needs to be done rights wise and is this possible
without connectivity issues. Currently these servers are standalone not in a
domain and users can currenlty access this through local logon sql rights on
the stand alone servers. Thanks.
If there is no domain trust then you will either need to use SQL
authentication or create NT accounts on the SQL Server machines that mirror
the accounts that the users logon to their client machines with. The
accounts will have to have the same name and password. Using this method
you can use NT authentication to SQL Server.
Rand
This posting is provided "as is" with no warranties and confers no rights.
user domains with no trust relationships accessing sql databases on the
application domain what needs to be done rights wise and is this possible
without connectivity issues. Currently these servers are standalone not in a
domain and users can currenlty access this through local logon sql rights on
the stand alone servers. Thanks.
If there is no domain trust then you will either need to use SQL
authentication or create NT accounts on the SQL Server machines that mirror
the accounts that the users logon to their client machines with. The
accounts will have to have the same name and password. Using this method
you can use NT authentication to SQL Server.
Rand
This posting is provided "as is" with no warranties and confers no rights.
odbc connection multi domain no trust
If you have one domain of application servers running win2000 and seperate
user domains with no trust relationships accessing sql databases on the
application domain what needs to be done rights wise and is this possible
without connectivity issues. Currently these servers are standalone not in
a
domain and users can currenlty access this through local logon sql rights on
the stand alone servers. Thanks.If there is no domain trust then you will either need to use SQL
authentication or create NT accounts on the SQL Server machines that mirror
the accounts that the users logon to their client machines with. The
accounts will have to have the same name and password. Using this method
you can use NT authentication to SQL Server.
Rand
This posting is provided "as is" with no warranties and confers no rights.sql
user domains with no trust relationships accessing sql databases on the
application domain what needs to be done rights wise and is this possible
without connectivity issues. Currently these servers are standalone not in
a
domain and users can currenlty access this through local logon sql rights on
the stand alone servers. Thanks.If there is no domain trust then you will either need to use SQL
authentication or create NT accounts on the SQL Server machines that mirror
the accounts that the users logon to their client machines with. The
accounts will have to have the same name and password. Using this method
you can use NT authentication to SQL Server.
Rand
This posting is provided "as is" with no warranties and confers no rights.sql
ODBC Connection Issue on Client Site
Hi,
It might be a basic question but could you please help me on that?
Working Environment:
I have developed application on SQL Server 2005 and now wants to Run on Client Site, I am using access as a front end and SQL server 2005 back end through ODBC (System Dsn) which is working good. (user has been added on SQL Server and on Database)
Question:
1) Do I need to create new System Dsn Or other DSN (Keep in mind I have already create System DSN in Server) at each client site to access application from Server?
(If yes then I am trying to do that, it allow me to create (with required database which is on Server) and verify but doesn’t save on ODBC list so I can’t use that name to run appliation on client site)
I am using windows authentication.
Thanks for help in advance
It's done the issue was admin rights on the client's computer.
Wednesday, March 21, 2012
ODBC connection frequently drops in routed network
Hello,
we are having serious problems with an application that uses an ODBC
connection (System DSN) to a SQL Server in another subnet. The network is
fine, all network tests reveal nothing of consequence. However, the problem
does not appear when SQL server and client are in the same subnet.
The ODBC connection from the client gets dropped at seemingly random
intervals and in the logs one can see the following:
{NIL, 10054, [01000][10054][Microsoft][ODBC SQL Server
Driver][DBNETLIB]ConnectionWrite (send()).}
{NIL, 59, [01000][59][Microsoft][ODBC SQL Server
Driver][DBNETLIB]ConnectionWrite (WrapperWrite()).}
{NIL, -1, [08S01][0][Microsoft][ODBC SQL Server
Driver]Communication link failure}
We honestly don't know what else to look for. Maybe anyone has an idea?
Thanks in advance,
Thomas Liss
Well, after configuring "Flow Control" on the network cards of the SQL
Server, the problems were gone.
"Thomas Liss" <liss@.uipugmbh.com> wrote in message
news:upFsIo9TFHA.2664@.TK2MSFTNGP15.phx.gbl...
> Hello,
> we are having serious problems with an application that uses an ODBC
> connection (System DSN) to a SQL Server in another subnet. The network is
> fine, all network tests reveal nothing of consequence. However, the
> problem does not appear when SQL server and client are in the same subnet.
> The ODBC connection from the client gets dropped at seemingly random
> intervals and in the logs one can see the following:
> {NIL, 10054, [01000][10054][Microsoft][ODBC SQL Server
> Driver][DBNETLIB]ConnectionWrite (send()).}
> {NIL, 59, [01000][59][Microsoft][ODBC SQL Server
> Driver][DBNETLIB]ConnectionWrite (WrapperWrite()).}
> {NIL, -1, [08S01][0][Microsoft][ODBC SQL Server
> Driver]Communication link failure}
> We honestly don't know what else to look for. Maybe anyone has an idea?
>
> Thanks in advance,
>
> Thomas Liss
>
|||Could you please explain what was the old setting and what is the new one?
Regards,
Marko Erzen
"Thomas Liss" <liss@.uipugmbh.com> wrote in message
news:e2wez$JUFHA.2172@.TK2MSFTNGP15.phx.gbl...[vbcol=seagreen]
> Well, after configuring "Flow Control" on the network cards of the SQL
> Server, the problems were gone.
>
> "Thomas Liss" <liss@.uipugmbh.com> wrote in message
> news:upFsIo9TFHA.2664@.TK2MSFTNGP15.phx.gbl...
is[vbcol=seagreen]
subnet.
>
|||Thomas,
I just read your post and we are experiencing the same kind of error
here. The communication link failure is only occurring for clients
connecting from outside of the server's home subnet and the failure is
intermittent. Did you ever resolve your problems?
*** Sent via Developersdex http://www.codecomments.com ***
we are having serious problems with an application that uses an ODBC
connection (System DSN) to a SQL Server in another subnet. The network is
fine, all network tests reveal nothing of consequence. However, the problem
does not appear when SQL server and client are in the same subnet.
The ODBC connection from the client gets dropped at seemingly random
intervals and in the logs one can see the following:
{NIL, 10054, [01000][10054][Microsoft][ODBC SQL Server
Driver][DBNETLIB]ConnectionWrite (send()).}
{NIL, 59, [01000][59][Microsoft][ODBC SQL Server
Driver][DBNETLIB]ConnectionWrite (WrapperWrite()).}
{NIL, -1, [08S01][0][Microsoft][ODBC SQL Server
Driver]Communication link failure}
We honestly don't know what else to look for. Maybe anyone has an idea?
Thanks in advance,
Thomas Liss
Well, after configuring "Flow Control" on the network cards of the SQL
Server, the problems were gone.
"Thomas Liss" <liss@.uipugmbh.com> wrote in message
news:upFsIo9TFHA.2664@.TK2MSFTNGP15.phx.gbl...
> Hello,
> we are having serious problems with an application that uses an ODBC
> connection (System DSN) to a SQL Server in another subnet. The network is
> fine, all network tests reveal nothing of consequence. However, the
> problem does not appear when SQL server and client are in the same subnet.
> The ODBC connection from the client gets dropped at seemingly random
> intervals and in the logs one can see the following:
> {NIL, 10054, [01000][10054][Microsoft][ODBC SQL Server
> Driver][DBNETLIB]ConnectionWrite (send()).}
> {NIL, 59, [01000][59][Microsoft][ODBC SQL Server
> Driver][DBNETLIB]ConnectionWrite (WrapperWrite()).}
> {NIL, -1, [08S01][0][Microsoft][ODBC SQL Server
> Driver]Communication link failure}
> We honestly don't know what else to look for. Maybe anyone has an idea?
>
> Thanks in advance,
>
> Thomas Liss
>
|||Could you please explain what was the old setting and what is the new one?
Regards,
Marko Erzen
"Thomas Liss" <liss@.uipugmbh.com> wrote in message
news:e2wez$JUFHA.2172@.TK2MSFTNGP15.phx.gbl...[vbcol=seagreen]
> Well, after configuring "Flow Control" on the network cards of the SQL
> Server, the problems were gone.
>
> "Thomas Liss" <liss@.uipugmbh.com> wrote in message
> news:upFsIo9TFHA.2664@.TK2MSFTNGP15.phx.gbl...
is[vbcol=seagreen]
subnet.
>
|||Thomas,
I just read your post and we are experiencing the same kind of error
here. The communication link failure is only occurring for clients
connecting from outside of the server's home subnet and the failure is
intermittent. Did you ever resolve your problems?
*** Sent via Developersdex http://www.codecomments.com ***
Subscribe to:
Posts (Atom)