problem porting MySQL to SQLServer

Hi I am trying to port a mysql database to microsoft SQL server 2000. I
downloaded the mysql odbc driver, both versions 3.1 and 5.0. I am able to
create the odbc machine source and the connection to the MySQLmachine works
(using access)
but when I try to import a table into Access I get the error Microsoft acces
s
reserved error (-7701) there is no message for this error.
Anyhow just wondering if anyone has any ideas? I am hoping that the MySQL
tables are not too large.
thanks.
Paul G
Software engineer.Hello Paul,

> Hi I am trying to port a mysql database to microsoft SQL server 2000. I
> downloaded the mysql odbc driver, both versions 3.1 and 5.0. I am able to
> create the odbc machine source and the connection to the MySQLmachine
works
> (using access)
> but when I try to import a table into Access I get the error Microsoft
access
> reserved error (-7701) there is no message for this error.
> Anyhow just wondering if anyone has any ideas? I am hoping that the MySQL
> tables are not too large.
You might try our database tool: Database Workbench ( www.upscene.com )
It includes a Schema Migration and DataPump tool.
Connections to both mysql and MS SQL Server natively.
With regards,
Martijn Tonies
Database Workbench - tool for InterBase, Firebird, MySQL, Oracle & MS SQL
Server
Upscene Productions
http://www.upscene.com
Database development questions? Check the forum!
http://www.databasedevelopmentforum.com|||Hi thanks for the response. Just wondering if you have a demo, if it works
ok I can most likely get management to make a purchase if the price is not
too high.
thanks.
--
Paul G
Software engineer.
"Martijn Tonies" wrote:

> Hello Paul,
>
> works
> access
> You might try our database tool: Database Workbench ( www.upscene.com )
> It includes a Schema Migration and DataPump tool.
> Connections to both mysql and MS SQL Server natively.
>
> --
> With regards,
> Martijn Tonies
> Database Workbench - tool for InterBase, Firebird, MySQL, Oracle & MS SQL
> Server
> Upscene Productions
> http://www.upscene.com
> Database development questions? Check the forum!
> http://www.databasedevelopmentforum.com
>
>|||fixed the problem, seemed to work on another machine with more memory so mos
t
likely memory related.
--
Paul G
Software engineer.
"Paul" wrote:
[vbcol=seagreen]
> Hi thanks for the response. Just wondering if you have a demo, if it work
s
> ok I can most likely get management to make a purchase if the price is not
> too high.
> thanks.
> --
> Paul G
> Software engineer.
>
> "Martijn Tonies" wrote:
>|||On Mon, 12 Sep 2005 11:12:04 -0700, "Paul"
<Paul@.discussions.microsoft.com> wrote:
>fixed the problem, seemed to work on another machine with more memory so mo
st
>likely memory related.
If all else fails, export the data into flat files and BCP them into
SQLServer. Not a bad strategy in any case.
J.|||Thanks for the information, just wondering how to export the data into flat
files, can you do this using MySQLFront?
Paul G
Software engineer.
"jxstern" wrote:

> On Mon, 12 Sep 2005 11:12:04 -0700, "Paul"
> <Paul@.discussions.microsoft.com> wrote:
> If all else fails, export the data into flat files and BCP them into
> SQLServer. Not a bad strategy in any case.
> J.
>|||On Mon, 12 Sep 2005 12:15:04 -0700, "Paul"
<Paul@.discussions.microsoft.com> wrote:
>Thanks for the information, just wondering how to export the data into flat
>files, can you do this using MySQLFront?
Or CSV.
Sorry, I'm rather rusty on MySQL, but I'm sure it's doable.
J.|||
> Thanks for the information, just wondering how to export the data into
flat
> files, can you do this using MySQLFront?
And with our tool as well ;-)
That is, IF it's version mysql 4 and up.
You might want to try the DataPump tool in it -- that should not have
problems with mysql < 4... Haven't tried it though.
With regards,
Martijn Tonies
Database Workbench - tool for InterBase, Firebird, MySQL, Oracle & MS SQL
Server
Upscene Productions
http://www.upscene.com
Database development questions? Check the forum!
http://www.databasedevelopmentforum.com

problem porting MySQL to SQLServer

Hi I am trying to port a MySQL database to microsoft SQL server 2000. I
downloaded the mysql odbc driver, both versions 3.1 and 5.0. I am able to
create the odbc machine source and the connection to the MySQLmachine works
(using access)
but when I try to import a table into Access I get the error Microsoft access
reserved error (-7701) there is no message for this error.
Anyhow just wondering if anyone has any ideas? I am hoping that the MySQL
tables are not too large.
thanks.
Paul G
Software engineer.
Hello Paul,

> Hi I am trying to port a MySQL database to microsoft SQL server 2000. I
> downloaded the mysql odbc driver, both versions 3.1 and 5.0. I am able to
> create the odbc machine source and the connection to the MySQLmachine
works
> (using access)
> but when I try to import a table into Access I get the error Microsoft
access
> reserved error (-7701) there is no message for this error.
> Anyhow just wondering if anyone has any ideas? I am hoping that the MySQL
> tables are not too large.
You might try our database tool: Database Workbench ( www.upscene.com )
It includes a Schema Migration and DataPump tool.
Connections to both MySQL and MS SQL Server natively.
With regards,
Martijn Tonies
Database Workbench - tool for InterBase, Firebird, MySQL, Oracle & MS SQL
Server
Upscene Productions
http://www.upscene.com
Database development questions? Check the forum!
http://www.databasedevelopmentforum.com
|||Hi thanks for the response. Just wondering if you have a demo, if it works
ok I can most likely get management to make a purchase if the price is not
too high.
thanks.
Paul G
Software engineer.
"Martijn Tonies" wrote:

> Hello Paul,
> works
> access
> You might try our database tool: Database Workbench ( www.upscene.com )
> It includes a Schema Migration and DataPump tool.
> Connections to both MySQL and MS SQL Server natively.
>
> --
> With regards,
> Martijn Tonies
> Database Workbench - tool for InterBase, Firebird, MySQL, Oracle & MS SQL
> Server
> Upscene Productions
> http://www.upscene.com
> Database development questions? Check the forum!
> http://www.databasedevelopmentforum.com
>
>
|||fixed the problem, seemed to work on another machine with more memory so most
likely memory related.
Paul G
Software engineer.
"Paul" wrote:
[vbcol=seagreen]
> Hi thanks for the response. Just wondering if you have a demo, if it works
> ok I can most likely get management to make a purchase if the price is not
> too high.
> thanks.
> --
> Paul G
> Software engineer.
>
> "Martijn Tonies" wrote:
|||On Mon, 12 Sep 2005 11:12:04 -0700, "Paul"
<Paul@.discussions.microsoft.com> wrote:
>fixed the problem, seemed to work on another machine with more memory so most
>likely memory related.
If all else fails, export the data into flat files and BCP them into
SQLServer. Not a bad strategy in any case.
J.
|||Thanks for the information, just wondering how to export the data into flat
files, can you do this using MySQLFront?
Paul G
Software engineer.
"jxstern" wrote:

> On Mon, 12 Sep 2005 11:12:04 -0700, "Paul"
> <Paul@.discussions.microsoft.com> wrote:
> If all else fails, export the data into flat files and BCP them into
> SQLServer. Not a bad strategy in any case.
> J.
>
|||On Mon, 12 Sep 2005 12:15:04 -0700, "Paul"
<Paul@.discussions.microsoft.com> wrote:
>Thanks for the information, just wondering how to export the data into flat
>files, can you do this using MySQLFront?
Or CSV.
Sorry, I'm rather rusty on MySQL, but I'm sure it's doable.
J.
|||
> Thanks for the information, just wondering how to export the data into
flat
> files, can you do this using MySQLFront?
And with our tool as well ;-)
That is, IF it's version MySQL 4 and up.
You might want to try the DataPump tool in it -- that should not have
problems with MySQL < 4... Haven't tried it though.
With regards,
Martijn Tonies
Database Workbench - tool for InterBase, Firebird, MySQL, Oracle & MS SQL
Server
Upscene Productions
http://www.upscene.com
Database development questions? Check the forum!
http://www.databasedevelopmentforum.com
sql

problem porting MySQL to SQLServer

Hi I am trying to port a MySQL database to microsoft SQL server 2000. I
downloaded the mysql odbc driver, both versions 3.1 and 5.0. I am able to
create the odbc machine source and the connection to the MySQLmachine works
(using access)
but when I try to import a table into Access I get the error Microsoft access
reserved error (-7701) there is no message for this error.
Anyhow just wondering if anyone has any ideas? I am hoping that the MySQL
tables are not too large.
thanks.
--
Paul G
Software engineer.Hello Paul,
> Hi I am trying to port a MySQL database to microsoft SQL server 2000. I
> downloaded the mysql odbc driver, both versions 3.1 and 5.0. I am able to
> create the odbc machine source and the connection to the MySQLmachine
works
> (using access)
> but when I try to import a table into Access I get the error Microsoft
access
> reserved error (-7701) there is no message for this error.
> Anyhow just wondering if anyone has any ideas? I am hoping that the MySQL
> tables are not too large.
You might try our database tool: Database Workbench ( www.upscene.com )
It includes a Schema Migration and DataPump tool.
Connections to both MySQL and MS SQL Server natively.
With regards,
Martijn Tonies
Database Workbench - tool for InterBase, Firebird, MySQL, Oracle & MS SQL
Server
Upscene Productions
http://www.upscene.com
Database development questions? Check the forum!
http://www.databasedevelopmentforum.com|||Hi thanks for the response. Just wondering if you have a demo, if it works
ok I can most likely get management to make a purchase if the price is not
too high.
thanks.
--
Paul G
Software engineer.
"Martijn Tonies" wrote:
> Hello Paul,
> > Hi I am trying to port a MySQL database to microsoft SQL server 2000. I
> > downloaded the mysql odbc driver, both versions 3.1 and 5.0. I am able to
> > create the odbc machine source and the connection to the MySQLmachine
> works
> > (using access)
> > but when I try to import a table into Access I get the error Microsoft
> access
> > reserved error (-7701) there is no message for this error.
> > Anyhow just wondering if anyone has any ideas? I am hoping that the MySQL
> > tables are not too large.
> You might try our database tool: Database Workbench ( www.upscene.com )
> It includes a Schema Migration and DataPump tool.
> Connections to both MySQL and MS SQL Server natively.
>
> --
> With regards,
> Martijn Tonies
> Database Workbench - tool for InterBase, Firebird, MySQL, Oracle & MS SQL
> Server
> Upscene Productions
> http://www.upscene.com
> Database development questions? Check the forum!
> http://www.databasedevelopmentforum.com
>
>|||fixed the problem, seemed to work on another machine with more memory so most
likely memory related.
--
Paul G
Software engineer.
"Paul" wrote:
> Hi thanks for the response. Just wondering if you have a demo, if it works
> ok I can most likely get management to make a purchase if the price is not
> too high.
> thanks.
> --
> Paul G
> Software engineer.
>
> "Martijn Tonies" wrote:
> > Hello Paul,
> >
> > > Hi I am trying to port a MySQL database to microsoft SQL server 2000. I
> > > downloaded the mysql odbc driver, both versions 3.1 and 5.0. I am able to
> > > create the odbc machine source and the connection to the MySQLmachine
> > works
> > > (using access)
> > > but when I try to import a table into Access I get the error Microsoft
> > access
> > > reserved error (-7701) there is no message for this error.
> > > Anyhow just wondering if anyone has any ideas? I am hoping that the MySQL
> > > tables are not too large.
> >
> > You might try our database tool: Database Workbench ( www.upscene.com )
> > It includes a Schema Migration and DataPump tool.
> >
> > Connections to both MySQL and MS SQL Server natively.
> >
> >
> > --
> > With regards,
> >
> > Martijn Tonies
> > Database Workbench - tool for InterBase, Firebird, MySQL, Oracle & MS SQL
> > Server
> > Upscene Productions
> > http://www.upscene.com
> > Database development questions? Check the forum!
> > http://www.databasedevelopmentforum.com
> >
> >
> >|||On Mon, 12 Sep 2005 11:12:04 -0700, "Paul"
<Paul@.discussions.microsoft.com> wrote:
>fixed the problem, seemed to work on another machine with more memory so most
>likely memory related.
If all else fails, export the data into flat files and BCP them into
SQLServer. Not a bad strategy in any case.
J.|||Thanks for the information, just wondering how to export the data into flat
files, can you do this using MySQLFront?
--
Paul G
Software engineer.
"jxstern" wrote:
> On Mon, 12 Sep 2005 11:12:04 -0700, "Paul"
> <Paul@.discussions.microsoft.com> wrote:
> >fixed the problem, seemed to work on another machine with more memory so most
> >likely memory related.
> If all else fails, export the data into flat files and BCP them into
> SQLServer. Not a bad strategy in any case.
> J.
>|||On Mon, 12 Sep 2005 12:15:04 -0700, "Paul"
<Paul@.discussions.microsoft.com> wrote:
>Thanks for the information, just wondering how to export the data into flat
>files, can you do this using MySQLFront?
Or CSV.
Sorry, I'm rather rusty on MySQL, but I'm sure it's doable.
J.|||> Thanks for the information, just wondering how to export the data into
flat
> files, can you do this using MySQLFront?
And with our tool as well ;-)
That is, IF it's version MySQL 4 and up.
You might want to try the DataPump tool in it -- that should not have
problems with MySQL < 4... Haven't tried it though.
With regards,
Martijn Tonies
Database Workbench - tool for InterBase, Firebird, MySQL, Oracle & MS SQL
Server
Upscene Productions
http://www.upscene.com
Database development questions? Check the forum!
http://www.databasedevelopmentforum.com

problem on registering linked server in SQL2005

I have an InterBase 5 database, which has been registered as an ODBC System Data Source in my Windows 2000. When I try to add it as a linked server in SQL server 2005, the Add Linked Server page make me so frustrated. I can select the ODBC driver, but I don't know how to specify values for the fields such as Product Name, Database Source, and Provider string. I tried many combinations on these field values, all unsucceed . Anybody can tell me how to determine the values of these fields? Any reference articles about this? Please help me!There are examples in Books On Line have you looked at these?

Problem on Connecting to SQL Server on Network thru ODBC DSN

am using Sql Server 7 as my database and it resides on a server ruinning on
Windows XP.
I have used the ODBC DSN for sql server and it worked on stand alone
perfectly but
when i tried to reconfigure the ODBC DNS for other client syustems to
connect to the SERVer it is giving me this error
Connection Failed:
SQLstate:01000
SQL Server error:10061
[Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]ConnectionOpen (Connect())
Connection failed:
SQLstate:08001
SQL Server error: 17
[Microsoft][ODBC SQL Server DriverSQL Server does not exists or access denied.
Pls am highly frustrated and helpless, pls help me i need this thing to work
pls help me i need ur help
I have checked the Windows Firewall seetings and its even off, so what
exactly is blocking the connection or i dont know , pls just help me out.
I will be expecting ur reply earnestly
--
sammy dot comHello sammydotcom,
If you are connectin using the name of the SQL Server, make sure that Named
Pipes is turned on.
If you are connecting using an IP address, then IP access needs to be turned
on.
There should be a client tools in your SQL Server menu (off of All Programs)
that will allow you to configure the connection type. Additionaly, double
check the SQL Server setup itself and make sure that it can accept Remote
Connections.
Chris Anderson VB-MVP
> am using Sql Server 7 as my database and it resides on a server
> ruinning on
> Windows XP.
> I have used the ODBC DSN for sql server and it worked on stand alone
> perfectly but
> when i tried to reconfigure the ODBC DNS for other client syustems to
> connect to the SERVer it is giving me this error
> Connection Failed:
> SQLstate:01000
> SQL Server error:10061
> [Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]ConnectionOpen
> (Connect())
> Connection failed:
> SQLstate:08001
> SQL Server error: 17
> [Microsoft][ODBC SQL Server DriverSQL Server does not exists or access
> denied.
> Pls am highly frustrated and helpless, pls help me i need this thing
> to work
> pls help me i need ur help
> I have checked the Windows Firewall seetings and its even off, so what
> exactly is blocking the connection or i dont know , pls just help me
> out.
> I will be expecting ur reply earnestly
>

Problem on Connecting to SQL Server on Network thru ODBC DSN

am using Sql Server 7 as my database and it resides on a server ruinning on
Windows XP.
I have used the ODBC DSN for sql server and it worked on stand alone
perfectly but
when i tried to reconfigure the ODBC DNS for other client syustems to
connect to the SERVer it is giving me this error
Connection Failed:
SQLstate:01000
SQL Server error:10061
[Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]ConnectionOpen (Connect())
Connection failed:
SQLstate:08001
SQL Server error: 17
[Microsoft][ODBC SQL Server DriverSQL Server does not exists or access denied.
Pls am highly frustrated and helpless, pls help me i need this thing to work
pls help me i need ur help
I have checked the Windows Firewall seetings and its even off, so what
exactly is blocking the connection or i dont know , pls just help me out.
I will be expecting ur reply earnestly
sammy dot com
Hello sammydotcom,
If you are connectin using the name of the SQL Server, make sure that Named
Pipes is turned on.
If you are connecting using an IP address, then IP access needs to be turned
on.
There should be a client tools in your SQL Server menu (off of All Programs)
that will allow you to configure the connection type. Additionaly, double
check the SQL Server setup itself and make sure that it can accept Remote
Connections.
Chris Anderson VB-MVP

> am using Sql Server 7 as my database and it resides on a server
> ruinning on
> Windows XP.
> I have used the ODBC DSN for sql server and it worked on stand alone
> perfectly but
> when i tried to reconfigure the ODBC DNS for other client syustems to
> connect to the SERVer it is giving me this error
> Connection Failed:
> SQLstate:01000
> SQL Server error:10061
> [Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]ConnectionOpen
> (Connect())
> Connection failed:
> SQLstate:08001
> SQL Server error: 17
> [Microsoft][ODBC SQL Server DriverSQL Server does not exists or access
> denied.
> Pls am highly frustrated and helpless, pls help me i need this thing
> to work
> pls help me i need ur help
> I have checked the Windows Firewall seetings and its even off, so what
> exactly is blocking the connection or i dont know , pls just help me
> out.
> I will be expecting ur reply earnestly
>

Problem on Connecting to SQL Server on Network thru ODBC DSN

am using Sql Server 7 as my database and it resides on a server ruinning on
Windows XP.
I have used the ODBC DSN for sql server and it worked on stand alone
perfectly but
when i tried to reconfigure the ODBC DNS for other client syustems to
connect to the SERVer it is giving me this error
Connection Failed:
SQLstate:01000
SQL Server error:10061
[Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]ConnectionOpe
n (Connect())
Connection failed:
SQLstate:08001
SQL Server error: 17
[Microsoft][ODBC SQL Server DriverSQL Server does not exists or acce
ss denied.
Pls am highly frustrated and helpless, pls help me i need this thing to work
pls help me i need ur help
I have checked the Windows Firewall seetings and its even off, so what
exactly is blocking the connection or i dont know , pls just help me out.
I will be expecting ur reply earnestly
sammy dot comHello sammydotcom,
If you are connectin using the name of the SQL Server, make sure that Named
Pipes is turned on.
If you are connecting using an IP address, then IP access needs to be turned
on.
There should be a client tools in your SQL Server menu (off of All Programs)
that will allow you to configure the connection type. Additionaly, double
check the SQL Server setup itself and make sure that it can accept Remote
Connections.
Chris Anderson VB-MVP

> am using Sql Server 7 as my database and it resides on a server
> ruinning on
> Windows XP.
> I have used the ODBC DSN for sql server and it worked on stand alone
> perfectly but
> when i tried to reconfigure the ODBC DNS for other client syustems to
> connect to the SERVer it is giving me this error
> Connection Failed:
> SQLstate:01000
> SQL Server error:10061
> [Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]ConnectionO
pen
> (Connect())
> Connection failed:
> SQLstate:08001
> SQL Server error: 17
> [Microsoft][ODBC SQL Server DriverSQL Server does not exists or ac
cess
> denied.
> Pls am highly frustrated and helpless, pls help me i need this thing
> to work
> pls help me i need ur help
> I have checked the Windows Firewall seetings and its even off, so what
> exactly is blocking the connection or i dont know , pls just help me
> out.
> I will be expecting ur reply earnestly
>

Problem ODBC connection....

I have a porblem which windows 2000 couldn't connect to SQL server 2005 through ODBC. But I have no problem with the rest of my windows XP pro. Please help. thanksWhich error do you get ?

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de|||I have done the same step to connect to SQL through ODBC on windows XP pro. But I have 4 other PC which is run under windows 2000 that unable to connect the SQL server. It just counldn't find the server at all.|||

Hi GAN2006,

Like Jens asked, you'll need to post the exact error message that you're receiving. Also, providing your connection string and indicating which driver you're using (SQL Native client, MDAC) would be helpful. Please take a look at this guideline for insight on the type of information that'll make problem determination easier: http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=362498&SiteID=1

Thanks,
Il-Sung.

|||

I think I have faced the same problem.

All you need to do is to install MDAC 2.8. This is because SQL 2000 connector in windows 2000 is not there or not working properly. Install MDAC 2.8 and it shall work. For windows xp, you dont have to because by nature it already have mdac 2.8 components.

Problem inserting into a Text field in a temp table after SP3

I have a stored proc that is inserting data into a Text field. This was
working fine on Friday, but today throws the following error:
ODBC: Msg 0, Level 19, State 1
SqlDumpExceptionHandler: Process 55 generated fatal exception c0000005
EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this process.
Yesterday we upgraded our SQL server from SP2 to SP3, and today we upgraded
3 to 3a after finding this problem. We found the KB article 817359 which
seems to be related, but if we change their example from nText & nVarchar to
Text and Varchar we still get the error (the same one as above). Can anyone
tell me how to fix this problem?
TIA
Ron LounsburyRon,
You should contact PSS to report this. An AV normally means a bug in
sqlserver. You should not be charged for this incident.
--
-oj
RAC v2.2 & QALite!
http://www.rac4sql.net
"Ron Lounsbury" <rlounsbury AT Progeny DOT net> wrote in message
news:uwvRfPrsDHA.1788@.tk2msftngp13.phx.gbl...
> I have a stored proc that is inserting data into a Text field. This was
> working fine on Friday, but today throws the following error:
> ODBC: Msg 0, Level 19, State 1
> SqlDumpExceptionHandler: Process 55 generated fatal exception c0000005
> EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this process.
> Yesterday we upgraded our SQL server from SP2 to SP3, and today we
upgraded
> 3 to 3a after finding this problem. We found the KB article 817359 which
> seems to be related, but if we change their example from nText & nVarchar
to
> Text and Varchar we still get the error (the same one as above). Can
anyone
> tell me how to fix this problem?
> TIA
> Ron Lounsbury
>|||OJ
Thanks for the response. It was a bug that they have a fix for, but you
have to call them to get it.
Ron Lounsbury
"oj" <nospam_ojngo@.home.com> wrote in message
news:eJjF$jrsDHA.4056@.TK2MSFTNGP11.phx.gbl...
> Ron,
> You should contact PSS to report this. An AV normally means a bug in
> sqlserver. You should not be charged for this incident.
> --
> -oj
> RAC v2.2 & QALite!
> http://www.rac4sql.net
>
> "Ron Lounsbury" <rlounsbury AT Progeny DOT net> wrote in message
> news:uwvRfPrsDHA.1788@.tk2msftngp13.phx.gbl...
> > I have a stored proc that is inserting data into a Text field. This was
> > working fine on Friday, but today throws the following error:
> >
> > ODBC: Msg 0, Level 19, State 1
> > SqlDumpExceptionHandler: Process 55 generated fatal exception c0000005
> > EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this process.
> >
> > Yesterday we upgraded our SQL server from SP2 to SP3, and today we
> upgraded
> > 3 to 3a after finding this problem. We found the KB article 817359
which
> > seems to be related, but if we change their example from nText &
nVarchar
> to
> > Text and Varchar we still get the error (the same one as above). Can
> anyone
> > tell me how to fix this problem?
> >
> > TIA
> > Ron Lounsbury
> >
> >
>