ODBC Error

Hi All,
I am getting the following error message when I am trying to connect to SQL 2000 Server from SQL 7 Server using BCP/OSQL/ISQL etc., Can any one help me in fixing this problem.
NULL
COULD NOT CONNECT TO SQL SERVER
NULL
SQLState: 08001 Native Error: 6
Info. Message: [Microsoft][ODBC SQL Server Driver][Named Pipes]Specified SQL server not found.
NULL
SQLState: 01000 Native Error: 53
Info. Message: [Microsoft][ODBC SQL Server Driver][Named Pipes]ConnectionOpen (CreateFile()).
Thanks & Regards
Balaji Prabhu.TBalaji,
What is the respective OS?Do you have only 'Named pipes' enabled?
--
Dinesh
SQL Server MVP
--
--
SQL Server FAQ at
http://www.tkdinesh.com
"Balaji Prabhu.T" <Balaji Prabhu.T@.discussions.microsoft.com> wrote in
message news:C15C3280-F0A5-418B-912B-018EE518AF14@.microsoft.com...
> Hi All,
> I am getting the following error message when I am trying to connect to
SQL 2000 Server from SQL 7 Server using BCP/OSQL/ISQL etc., Can any one help
me in fixing this problem.
> NULL
> COULD NOT CONNECT TO SQL SERVER
> NULL
> SQLState: 08001 Native Error: 6
> Info. Message: [Microsoft][ODBC SQL Server Driver][Named Pipes]Specified
SQL server not found.
> NULL
> SQLState: 01000 Native Error: 53
> Info. Message: [Microsoft][ODBC SQL Server Driver][Named
Pipes]ConnectionOpen (CreateFile()).
> Thanks & Regards
> Balaji Prabhu.T
>

ODBC Driver to Connect With IBM AS/400 System

Good Morning All:
I am trying to find an ODBC Driver that will connect my current
Microsoft Access Databas with our IBM AS/400 System. We have the
driver in Excel, but I don't believe it is the same driver for
Access. Any input would be greatly appreciated.
-Anthony Morano
Pension Fund Intern.
The ODBC driver for DB2 on AS/400 as provided by IBM; it is the same driver
for all client applications. Contact you IBM SE to purchase the client
connectivity software if you don't already have it. Otherwise try an SQL/400
newsgroup.
<antmorano@.gmail.com> wrote in message
news:1184852139.438805.176820@.e9g2000prf.googlegro ups.com...
> Good Morning All:
> I am trying to find an ODBC Driver that will connect my current
> Microsoft Access Databas with our IBM AS/400 System. We have the
> driver in Excel, but I don't believe it is the same driver for
> Access. Any input would be greatly appreciated.
> -Anthony Morano
> Pension Fund Intern.
>
sql

ODBC Driver to Connect With IBM AS/400 System

Good Morning All:
I am trying to find an ODBC Driver that will connect my current
Microsoft Access Databas with our IBM AS/400 System. We have the
driver in Excel, but I don't believe it is the same driver for
Access. Any input would be greatly appreciated.
-Anthony Morano
Pension Fund Intern.The ODBC driver for DB2 on AS/400 as provided by IBM; it is the same driver
for all client applications. Contact you IBM SE to purchase the client
connectivity software if you don't already have it. Otherwise try an SQL/400
newsgroup.
<antmorano@.gmail.com> wrote in message
news:1184852139.438805.176820@.e9g2000prf.googlegroups.com...
> Good Morning All:
> I am trying to find an ODBC Driver that will connect my current
> Microsoft Access Databas with our IBM AS/400 System. We have the
> driver in Excel, but I don't believe it is the same driver for
> Access. Any input would be greatly appreciated.
> -Anthony Morano
> Pension Fund Intern.
>

ODBC Driver for SQLServer Everywhere/Compact from Access

So far I've been unable to connect to a test SQLServer Everywhere/Compact database with MS Access. I installed the new SQLServer 2005 Native Client to no avail. Has anyone done this?

If you are trying to sync the data between Access and the SQLServer Compact edition, you might need to download the synchronizer. The following link should provide you a quick overview and the access to the software. If this is not what you intended to do, please provide more details on what you are trying to accomplish:

http://www.microsoft.com/downloads/details.aspx?FamilyID=B967347A-5DD0-445C-8A9F-AEA3DB9EC4BC&displaylang=en

Regards,

Riyaz

|||

In Access, I'm simply trying to link to a SQLServer CE database using an ODBC driver, as you can do with other SQLServer servers. I've been the route you suggested, hoping that in the process I'd discover the driver I need. But to install that synchronizer, I have to install IIS and SQLServer 2005, which goes beyond what I'm trying to do. And I'm not interested in syncronizing to a mobile device in any case.

I was hoping to use SQLServer CE as a substitute for the normal Access Jet engine, to take advantage of encryption and security that Access does not provide (or does poorly). I want to deploy a single-user Access application with an easily deployable secure database. I'm doing it now with just Access, but I'd like to make the data tables inaccessible except through my application.

Thanks for the suggestion.

|||You can only connect to an instance of a SQL Server 2005 Mobile Edition database when it is running on a Windows CE-based OS or Tablet PC (you can create a SQL Server 2005 Mobile database in Visual Studio and, I believe, SQL Server Management Studio as part of the development process). When SQL Server Everywhere becomes available, it should, as you've surmised, fit your needs. In the meantime, you can check out the development experience using SQL Mobile today...take a look at http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnvs05/html/sqleverywhere.asp?frame=true for some additional info. If you'd like to have a runtime prototype of your app, however, you'll want to try using SQL Server 2005 Express.|||

I do have SQL Server 2005 Everywhere installed, (SQL Server 2005 Compact Edition), and I've created a database from VS 2005 (after installing VS 2005 SP1 Beta) and so far have not been able to connect to that database from Access. There is a .dll distributed with Everywhere: sqlceoledb30.dll that has a description "OLEDB Provider" that I am hoping will work, but it is not installed as an ODBC driver.

It seems impossible that I'm the first to attempt this. Any help will be appreciated.

Office 2003 SP2, Win XP SP2, VS 2005 SP1 Beta

Thanks

|||

The naming is a little tricky here...SQL Server 2005 Mobile Edition is the 3.0 version of the product formerly referred to as SQL Server Compact Edition (or SQL CE). The product formerly referred to as SQL Server Everywhere now appears to have the moniker of SQL Server 2005 Compact Edition...this version is the only one in this family that can be used on the desktop. A CTP version of this product was released in late August and the RC1 version is now available at http://www.microsoft.com/downloads/details.aspx?FamilyId=85E0C3CE-3FA1-453A-8CE9-AF6CA20946C3&displaylang=en

Given all of this, which version do you have? The RC1 file version appears to be 3.1 (the device only SQL Server 2005 Mobile Edition would be v3.0, I believe).

If you have the correct version but continue to have problems connecting, I'll move this thread into the SQL Server Compact Edition forum.

|||

If you read the last post I made, it's pretty clear that I have Compact Edition 3.1 RC1 Beta. I haven't ever installed the Mobile Edition. After installing CE, most references (like the installation directory) reflect the previous name (Everywhere).

I really want to link to a Compact Edition database through ODBC (as it happens, in Access). I can connect to it fine in VS 2005 VB.NET, so I don't think it's a lack of understanding.

Thanks, any help will be appreciated.

|||Thanks for claryifying the specific version that you have installed. Someone here in the SQL Server Compact Edition forum should be able to help you with the nuances of connecting to a local SQL Server CE database.|||

Although SQL CE 3.1 does expose an OLE DB provider, you cannot link to it via the regular ODBC link in Access. I have developed a set of tools that will help you with both converting to and from Access and also to edit the SDF on the desktop. These tools use the OLE DB provider at the low level and work with databases on the PC and on the device. You can try them here: http://www.primeworks-mobile.com

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 Driver for AS400

Hi,

I am presently using Client Access ODBC driver (32-bit) to connect to the AS400. I have set up a linked server that enables me to run queries against the AS400 using the driver. However I seek to have a driver that could give better performance. Right now I can extract 6 million rows from the AS400 table in like 2 hrs. Now is there an ODBC driver that can do better than that? Also I seek an evaluation edition of the driver if possible. Moreover I am the only developer and so a single user license is what I can have my supervisor budget.

Thanks,

VivekLook at www.hitsw.com. I've never used their drivers, but a friend of mine did and he praised their performance to the sky.

Regards,

hmscott

Hi,

I am presently using Client Access ODBC driver (32-bit) to connect to the AS400. I have set up a linked server that enables me to run queries against the AS400 using the driver. However I seek to have a driver that could give better performance. Right now I can extract 6 million rows from the AS400 table in like 2 hrs. Now is there an ODBC driver that can do better than that? Also I seek an evaluation edition of the driver if possible. Moreover I am the only developer and so a single user license is what I can have my supervisor budget.

Thanks,

Viveksql

ODBC Driver for Access and AS/400

Good Morning All:
I am trying to find an ODBC driver for Microsoft Access that will
allow me to connect to our IBM AS/400 system. All inpout would be
appreciated.
-Anthony Morano
Pension Fund InternYou can use the Client Access driver you get with the client
for the AS/400.
You may want to post future questions to one of the Access
newsgroups. This group addresses ODBC and SQL Server.
-Sue
On Thu, 19 Jul 2007 14:06:15 -0000, antmorano@.gmail.com
wrote:

>Good Morning All:
>I am trying to find an ODBC driver for Microsoft Access that will
>allow me to connect to our IBM AS/400 system. All inpout would be
>appreciated.
>-Anthony Morano
>Pension Fund Intern

ODBC Driver for Access and AS/400

Good Morning All:
I am trying to find an ODBC driver for Microsoft Access that will
allow me to connect to our IBM AS/400 system. All inpout would be
appreciated.
-Anthony Morano
Pension Fund Intern
You can use the Client Access driver you get with the client
for the AS/400.
You may want to post future questions to one of the Access
newsgroups. This group addresses ODBC and SQL Server.
-Sue
On Thu, 19 Jul 2007 14:06:15 -0000, antmorano@.gmail.com
wrote:

>Good Morning All:
>I am trying to find an ODBC driver for Microsoft Access that will
>allow me to connect to our IBM AS/400 system. All inpout would be
>appreciated.
>-Anthony Morano
>Pension Fund Intern

ODBC driver error

I am all of a sudden getting this error message on a
system, when trying to connect to sql server data:
Unable to load SQL Server ODBC driver resource DLL. The
application cannot continue.
I've reinstalled mdac (2.6 and 2.8), but this has not
helped. I need to get this system up and running asap, so
any help would be greatly appreciated.
Thank you,
Tom
PS I posted this first in the ODBC\data.odbc group, but
there doesn't appear to be too much activity there....Hi Tom,
Please check
http://mcse.ms/arch/66/2003/5/790826
http://mcse.ms/arch/66/2003/1/588214
Surely will help.
Sankar Renganathan
DBA, SPAR Group Inc.,
Please reply only to the newsgroups.
This posting is provided AS IS with no warranties, and confers no rights.
"TomT" <tomt@.tomt.com> wrote in message
news:03a901c3d8d7$8e9d5630$a101280a@.phx.gbl...

quote:

---

> I am all of a sudden getting this error message on a
> system, when trying to connect to sql server data:
> Unable to load SQL Server ODBC driver resource DLL. The
> application cannot continue.
> I've reinstalled mdac (2.6 and 2.8), but this has not
> helped. I need to get this system up and running asap, so
> any help would be greatly appreciated.
> Thank you,
> Tom
> PS I posted this first in the ODBC\data.odbc group, but
> there doesn't appear to be too much activity there....

---

|||Sankar,
Thanks for your help. I checked versions of the files,
and then replaced them since there was a mis-match.

quote:

---

>--Original Message--
>Hi Tom,
>Please check
>http://mcse.ms/arch/66/2003/5/790826
>http://mcse.ms/arch/66/2003/1/588214
>Surely will help.
>Sankar Renganathan
>DBA, SPAR Group Inc.,
>Please reply only to the newsgroups.
>This posting is provided AS IS with no warranties, and

---

confers no rights.

quote:

---

>
>"TomT" <tomt@.tomt.com> wrote in message
>news:03a901c3d8d7$8e9d5630$a101280a@.phx.gbl...
so[QUOTE]
>
>.
>

---

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?
>

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?
>

ODBC data source

I am trying to use the ADO.NET bridge to connect to an old database on RISC6000 via an ODBC connection, but I receive an error.

So, I would use a script component to retrieve data directly from an ODBC connection, using a stored procedure.

Any sample code ?

Any idea ?

Thanks

You can use the DataReader source in the data flow as another option connecting to an ODBC source.

ODBC Connectivity Issues

I have a windows 98 pc trying to connect to a sql server running on Windows Server 2003 via a frame relay. The 98 pc will connect to the domain and it is able to ping the server. However, when I try to use my MS Access program that connects to the sql server, I get this error message:

Connection Failed
SqlState: '01000'
Sql ServerError: 11001
[Microsoft][ODBC Sql Server Driver][TCP/IP Sockets] Connection Open (Connect ()).
Connection Failed
SqlState: '08001'
Sql ServerError: 6
[Microsoft][ODBC Sql Server Driver][TCP/IP Sockets] Specified Sql server not found.

I have other pcs that connect to the Sql Server fine but they are located locally in the same building as the server. I've tried connecting through named pipes but for some reason, I get the same error. I have downloaded and installed the new MDAC drivers for the 98 pc. Any suggestions?Just a couple of things to check:

1. Are all the DSN names the same on all machines (are you using linked tables into MSAccess?) Does a DSN name exist on the PC?
2. If they are linked tables into MSAccess, when you linked the table in MSAccess, did you check the "Save Password".
3. Does the user have permissions to the tables in SQL Server? Is their loginID or their domain group set up for permissions to the database?

Hope any of these helps.|||Yes, the DSN names are the same, and the user name and password are the same. There are multiple users that use the "generic" username and password and it works fine for them. I looked into the linked tables idea and this is what happened. When I link the tables in Access, it worked. However, when I exited the program and went back into it, it did not work anymore. Now when I try to link the tables again, it will not let me and the program will not work and I get that error message again. Any other ideas?

ODBC connections and SSIS

so im trying to connect to an odbc source and use ado.net to pass some sql queries and then write back into this odbc connection. i am aware that ssis does not have direct capabilities to do this, but i wanted to see if anyone knew of generic help docs/url's that show how to do this? i am new to ssis, and am just trying to get general information.

See Douglas post here:
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=70469&SiteID=1

The code is also in SQL Books Online.|||

to be honest with you, i did see that thread you mention above, probably the only thread with realistic information. I am looking for something specifically in C#.

I am also wondering if there is any way to not have the SQL Command line filled for the ODBC connection source and use ODBC and a combination of ADO.net? Anyone have success with this?

I did search books online for the particualar phrase mentioned in the above thread..not too helpful.

Just wondering if anyone has had success writing C# ado.net to read and write using ODBC as a source?

thanks!

|||

If that's what you are after then I would try a dev forum if I were you: http://forums.microsoft.com/MSDN/default.aspx?ForumGroupID=12&SiteID=1

-Jamie

sql

ODBC Connections

I have a network with 6 machines sitting on it.
All PC`s are configued in the same way. 5 of the machines connect to a SQL
server via ODBC with no problems.
The sixth PC however does not connect to the server giving the following :-
Connection Failed
SQL State '01000;
SQL Server Error: 11001
TCP/IP Sockets Connection Open
GetHosting Name
General network error.
I`m connecting via aTCP/IP on port 1433.
Does anyone have any idea why I am encountering these problems ?did you try 'telnet YourDBServerIP 1433'?
"Simon" wrote:

> I have a network with 6 machines sitting on it.
> All PC`s are configued in the same way. 5 of the machines connect to a SQL
> server via ODBC with no problems.
> The sixth PC however does not connect to the server giving the following :
-
> Connection Failed
> SQL State '01000;
> SQL Server Error: 11001
> TCP/IP Sockets Connection Open
> GetHosting Name
> General network error.
>
> I`m connecting via aTCP/IP on port 1433.
>
> Does anyone have any idea why I am encountering these problems ?
>|||I`m probably being a sponge but I don`t seem to get anything using that
command from any of the PC`s.
"AAO" wrote:
[vbcol=seagreen]
> did you try 'telnet YourDBServerIP 1433'?
> "Simon" wrote:
>|||You should get an error if SQL Server isn't listening on
1433. Or you should blank screen with the title of the
window changing to Telnet <Your Server> if you have
successfully established a telnet connection on that port.
It just sounds like you are connecting.
-Sue
On Fri, 12 May 2006 07:22:02 -0700, Simon
<Simon@.discussions.microsoft.com> wrote:
[vbcol=seagreen]
>I`m probably being a sponge but I don`t seem to get anything using that
>command from any of the PC`s.
>"AAO" wrote:
>|||Firewall?
/Henning
"Simon" <Simon@.discussions.microsoft.com> skrev i meddelandet
news:1359348E-85DA-43DD-AA79-313F4F92DF94@.microsoft.com...[vbcol=seagreen]
> I`m probably being a sponge but I don`t seem to get anything using that
> command from any of the PC`s.
> "AAO" wrote:
>
SQL[vbcol=seagreen]
following :-[vbcol=seagreen]|||The firewall setup is the same accross all the machines so I don`t think is
causing the problem.
"Henning" wrote:

> Firewall?
> /Henning
> "Simon" <Simon@.discussions.microsoft.com> skrev i meddelandet
> news:1359348E-85DA-43DD-AA79-313F4F92DF94@.microsoft.com...
> SQL
> following :-
>
>

ODBC connection to SQL server failing

Hi, I have an access 2003 database which connect to sql server via a
DSN that goes through a VPN. The database works fine and everyone can
coonect from their normal computers but for anyone working on their
Laptops (IBM Think Pad T42's) they cannnot connect to the datasource.
The DSN fails upon connection attempt with :

Connection Failed:
SQLState: '01000'
SQL Server Error: 1326
[Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionOpen
(Connect()).
Connection Failed:
SQLState: '08001'
SQL Server Error: 17
[Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not exist
or access is denied.

This has been driving me insane as i cannot understand why it works for
our desktop computers and not for our laptops. The version of MDAC is
the same on a computer that connects as it is on a laptop that doesn't.
TCP/IP is enabled on the server and is using the default 1433 port.
severs, desktops and laptops all patches and up to date with the latest
SP's. DSN has been dropped and re-created. Domain user has been put in
localAdmin group for laptop.

I hope i'm mising something really obvious...can someone please please
put me out of my misery and tell me they have come accross this before
and have a solution. Ive tried everything i can think of.

Cheers

DanDan (dan_barber2003@.hotmail.com) writes:
> Hi, I have an access 2003 database which connect to sql server via a
> DSN that goes through a VPN. The database works fine and everyone can
> coonect from their normal computers but for anyone working on their
> Laptops (IBM Think Pad T42's) they cannnot connect to the datasource.
> The DSN fails upon connection attempt with :
> Connection Failed:
> SQLState: '01000'
> SQL Server Error: 1326
> [Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionOpen
> (Connect()).
> Connection Failed:
> SQLState: '08001'
> SQL Server Error: 17
> [Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not exist
> or access is denied.

The problem is that the laptop somehow does not find the SQL Server.
This KB article discusses posible reasons:
http://support.microsoft.com/defaul...B;EN-US;q328306

--
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techin.../2000/books.asp|||Thanks, Erland. I had found that article and gone through (as best i
could) all the options but still had no joy. I have finally solved it
though. On our desktops we have microsoft firewall client installed and
enabled but on the laptops we dont. For some reason it seems that we
cannot connect through our proxy server and a connection to sql server
has to be done through this firewall client?? Even though i have solved
the problem i am still not sure why this happened??

Thanks again

Dan|||Dan (dan_barber2003@.hotmail.com) writes:
> Thanks, Erland. I had found that article and gone through (as best i
> could) all the options but still had no joy. I have finally solved it
> though. On our desktops we have microsoft firewall client installed and
> enabled but on the laptops we dont. For some reason it seems that we
> cannot connect through our proxy server and a connection to sql server
> has to be done through this firewall client?? Even though i have solved
> the problem i am still not sure why this happened??

It sounds a little funny, I will have to admit. But being nowhere
close to a Windows networking expert, I don't have any explanations.

But if you have the SQL connection working, and also have the firewall
enabled on the laptops, that sounds like a double win to me.

--
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techin.../2000/books.asp

ODBC Connection to SQL

I have a network with 6 machines sitting on it.
All PC`s are configued in the same way. 5 of the machines connect to a SQL
server via ODBC with no problems.
The sixth PC however does not connect to the server giving the following :-
Connection Failed
SQL State '01000;
SQL Server Error: 11001
TCP/IP Sockets Connection Open
GetHosting Name
General network error.
I`m connecting via aTCP/IP on port 1433.
Does anyone have any idea why I am encountering these problems ?Is there error actually GetHostByName?
On the PC that can't connect, try pinging the server by
server name and try pinging the server by IP and see if
there are any issues with pinging by name. If there are then
check that client for network issues as it's having problems
resolving the server name.
Otherwise, the issue you are seeing is often due to MDAC
issues. Try updating or reinstalling on that PC. You may
also
want to check the MDAC installation using component
checker. You can download component checker and MDAC
versions from:
http://msdn.microsoft.com/data/mdac...ds/default.aspx
-Sue
On Fri, 12 May 2006 01:17:02 -0700, Simon
<Simon@.discussions.microsoft.com> wrote:

>I have a network with 6 machines sitting on it.
>All PC`s are configued in the same way. 5 of the machines connect to a SQL
>server via ODBC with no problems.
>The sixth PC however does not connect to the server giving the following :-
>Connection Failed
>SQL State '01000;
>SQL Server Error: 11001
>TCP/IP Sockets Connection Open
>GetHosting Name
>General network error.
>
>I`m connecting via aTCP/IP on port 1433.
>
>Does anyone have any idea why I am encountering these problems ?
>

ODBC connection prompting for 'sa' password

We use Pivot Tables in Excel to provide users with reports. The Pivot Tables connect to SQL Server via an ODBC connection. In the ODBC connection, SQL Server authentication is specified and the 'sa' user name and password are entered. In prior versions
of Excel, the password would be saved in the Pivot Table. However, in Excel 2003 the user is prompted to enter the 'sa' password in order for the pivot table to update. Is there a way to have Excel 2003 pivot tables function as they did in prior versio
ns so that the password in the ODBC connection does not have to be re-entered?
Don't know much about Excel. But can you create another account (not sa)
to access the DB? This way you can keep your sa password secret.
Eric
Mike wrote:

> We use Pivot Tables in Excel to provide users with reports. The Pivot Tables connect to SQL Server via an ODBC connection. In the ODBC connection, SQL Server authentication is specified and the 'sa' user name and password are entered. In prior versio
ns of Excel, the password would be saved in the Pivot Table. However, in Excel 2003 the user is prompted to enter the 'sa' password in order for the pivot table to update. Is there a way to have Excel 2003 pivot tables function as they did in prior vers
ions so that the password in the ODBC connection does not have to be re-entered?
Eric Li
SQL DBA
MCDBA

ODBC connection problems in SSIS

I'm trying to connect to a Postgres database via ODBC from SSIS. The odbc connection is defined on my PC and works perfectly with other applications, including Access. However, when I set up the connection in SSIS, everything appears to connect fine (test connection works, etc.) but when I look at the data connection in Server Explorer, there are no tables, no views, and no procedures. Also, the name of the data connection is ODBC.csidb. csidb is the name of the server where the postgres database resides, but the database name itself isn't showing up. Can someone please let me know what I'm doing wrong? Thanks!

Laurie

Further investigation has proved that I am, in fact, connecting successfully to the database but for some reason the metadata is not being shown. Any ideas?|||

Can you repro the same problem elsewhere? (i.e. not in SSIS)

-Jamie

|||No, I can't. It works in other places.