ODBC driver for MySQL

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

quote:

---

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

---

value

quote:

---

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

---

ODBC Driver for Linux

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

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

ODBC Driver for Linux

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

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