Upsizing wizard

A

aps

Hi all,

I an using the upsizing wizard to transfer my backend data to SQLServer. If
I use the wizard to write to a new database it works ok, but if I attempt to
upsize to an existing database I get the error
'[DBNETLIB][ConnectionOpen().]SpecifiedSQL Server not found.' This error
occurs when I specify the ODBC connection. The ODBC Connection connects when
I test it separately.

I have Access 2003.

Any help on this will be greatly appreciated.

Thanks,
 
A

aps

Hi,

Yes I did. I have also used the server name, not just the IP address (which
I believe is an issue). Using the DSN I can connect successfully to the
database.

Kind regards,
Arthur.

Alex Dybenko said:
Hi,
did you add a new DSN, which points to your database? control
panel-administrative tools-Data Sources?

--
Best regards,
___________
Alex Dybenko (MVP)
http://alexdyb.blogspot.com
http://www.PointLtd.com

aps said:
Hi all,

I an using the upsizing wizard to transfer my backend data to SQLServer.
If
I use the wizard to write to a new database it works ok, but if I attempt
to
upsize to an existing database I get the error
'[DBNETLIB][ConnectionOpen().]SpecifiedSQL Server not found.' This error
occurs when I specify the ODBC connection. The ODBC Connection connects
when
I test it separately.

I have Access 2003.

Any help on this will be greatly appreciated.

Thanks,
Click to expand...
Click to expand...
 
A

Alex Dybenko

Can you link some table from SQL Server to access database, or import some
table?

--
Best regards,
___________
Alex Dybenko (MVP)
http://alexdyb.blogspot.com
http://www.PointLtd.com


aps said:
Hi,

Yes I did. I have also used the server name, not just the IP address
(which
I believe is an issue). Using the DSN I can connect successfully to the
database.

Kind regards,
Arthur.

Alex Dybenko said:
Hi,
did you add a new DSN, which points to your database? control
panel-administrative tools-Data Sources?

--
Best regards,
___________
Alex Dybenko (MVP)
http://alexdyb.blogspot.com
http://www.PointLtd.com

aps said:
Hi all,

I an using the upsizing wizard to transfer my backend data to
SQLServer.
If
I use the wizard to write to a new database it works ok, but if I
attempt
to
upsize to an existing database I get the error
'[DBNETLIB][ConnectionOpen().]SpecifiedSQL Server not found.' This
error
occurs when I specify the ODBC connection. The ODBC Connection connects
when
I test it separately.

I have Access 2003.

Any help on this will be greatly appreciated.

Thanks,
Click to expand...
Click to expand...
Click to expand...
 
A

aps

Hi,

I can both link a new table and import a table from SQLServer into Access.

Kind regards,
Arthur.

Alex Dybenko said:
Can you link some table from SQL Server to access database, or import some
table?

--
Best regards,
___________
Alex Dybenko (MVP)
http://alexdyb.blogspot.com
http://www.PointLtd.com


aps said:
Hi,

Yes I did. I have also used the server name, not just the IP address
(which
I believe is an issue). Using the DSN I can connect successfully to the
database.

Kind regards,
Arthur.

Alex Dybenko said:
Hi,
did you add a new DSN, which points to your database? control
panel-administrative tools-Data Sources?

--
Best regards,
___________
Alex Dybenko (MVP)
http://alexdyb.blogspot.com
http://www.PointLtd.com

Hi all,

I an using the upsizing wizard to transfer my backend data to
SQLServer.
If
I use the wizard to write to a new database it works ok, but if I
attempt
to
upsize to an existing database I get the error
'[DBNETLIB][ConnectionOpen().]SpecifiedSQL Server not found.' This
error
occurs when I specify the ODBC connection. The ODBC Connection connects
when
I test it separately.

I have Access 2003.

Any help on this will be greatly appreciated.

Thanks,
Click to expand...
Click to expand...
Click to expand...
 
A

Alex Dybenko

Well, this is bit strange then, I actually used it 2 days ago, it worked
fine for existing database.
I would try one more thing - run cliconfg, add there alias to your server
(perhaps using IP address) and then use this alias in DSN

--
Best regards,
___________
Alex Dybenko (MVP)
http://alexdyb.blogspot.com
http://www.PointLtd.com


Alex Dybenko said:
Can you link some table from SQL Server to access database, or import some
table?

--
Best regards,
___________
Alex Dybenko (MVP)
http://alexdyb.blogspot.com
http://www.PointLtd.com


aps said:
Hi,

Yes I did. I have also used the server name, not just the IP address
(which
I believe is an issue). Using the DSN I can connect successfully to the
database.

Kind regards,
Arthur.

Alex Dybenko said:
Hi,
did you add a new DSN, which points to your database? control
panel-administrative tools-Data Sources?

--
Best regards,
___________
Alex Dybenko (MVP)
http://alexdyb.blogspot.com
http://www.PointLtd.com

Hi all,

I an using the upsizing wizard to transfer my backend data to
SQLServer.
If
I use the wizard to write to a new database it works ok, but if I
attempt
to
upsize to an existing database I get the error
'[DBNETLIB][ConnectionOpen().]SpecifiedSQL Server not found.' This
error
occurs when I specify the ODBC connection. The ODBC Connection
connects
when
I test it separately.

I have Access 2003.

Any help on this will be greatly appreciated.

Thanks,
Click to expand...
Click to expand...
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

sqlite-odbc write conflict 2
TransferSpreadsheet method question 2
Upsizing Wizard Access 2000 7
Error when run Upsizing Wizard 2
importing from SQL Server 2008 Express 0
Trouble upsizing Access to SQL 5
Upsizing wizard access Sql Server express 7
Connecting Excel 2007 to MySQL db? 0

Top