Access 2007 + SQL Server 2005 + Vista x64

Hello,

I am looking for a solution to the problem named Table was skipped, or export failed. Here's the story:

I have a desktop with Vista Ultimate x64 and Office 2007. I want to export a database from Access MDB (about 2Gb, 110 tables) to SQL Server Express Express (Advanced). The simple solution > upsize wizard.

- create new database

- server name, used trusted connection, some database name
- I select all tables
- I unselect table's attributes

- create new Access server/client application

and every time I have Table was skipped, or export failed. The same thing happens when I create new MDB with one table (some random values)!

The strange thing that on laptop with XP + SQL Sever 2005 Express (Simple) and Access XP upsizing the same database works fine!'

one other issues of a rookie:

I wanted to access a database (randomly created) on Vista with the Access on my laptop. Both PCs are in the same network I can ping both, but when I try to connect to IP_desktop\SQLEXPRESS Access posts connection error. Why?

P.S.

When installing SQL Server on Vista I have only a problem with IIS and ASP.NET, but it shouldn't be a problem.

For the first issue, plase post the complete error message, for the second quesstion, you should enable the SQL Server Browser service and make sure that remote connections are enabled to the SQL Server machines (for more information see the screencast on my site)

Jens K. Suessmeyer

http://www.sqlserver2005.de

about store procedure

i have write several store procedure for export data,
most of the code such as :insert into Table1(col1,col2)
from select (col1,col2) form Table2,and i execute it in
sql analyser,and the analyser will show "x rows affected"
and now ,i want write a app with C#,call these store
procedures ,and want to konw
1,how many rows affected,analyser can return this?
2.how many rows selected,must i rewrite the store
procedure? such as add a new select count(*) from table2?
but this will decrease the perfermance
thank youCheck out SET NOCOUNT ON/OFF and @.@.ROWCOUNT in SQL Server Books Online.
--
HTH,
SriSamp
Please reply to the whole group only!
http://www32.brinkster.com/srisamp
"frank" <anonymous@.discussions.microsoft.com> wrote in message
news:061e01c3bd2e$b6fe4bd0$a001280a@.phx.gbl...
> i have write several store procedure for export data,
> most of the code such as :insert into Table1(col1,col2)
> from select (col1,col2) form Table2,and i execute it in
> sql analyser,and the analyser will show "x rows affected"
> and now ,i want write a app with C#,call these store
> procedures ,and want to konw
> 1,how many rows affected,analyser can return this?
> 2.how many rows selected,must i rewrite the store
> procedure? such as add a new select count(*) from table2?
> but this will decrease the perfermance
> thank you|||Frank..
One way some people do this is by returning a return status... Normally a
return status of 0 means the stored procedure was successfull, and a
negative return status means an error... Some people use a positive return
status to indicate how many rows were affected /select by the sp...
After the insert/select etc capture @.@.rowcount into a local variable..
declare @.error int, @.rowcount int
set nocount on
update ....
select @.rowcount = @.@.rowcount, @.error = @.@.error --I always capture
errors also
return @.rowcount
I always Set nocount ON as the first executable statement in an sp as well..
To use the return status
declare @.ret_status int
exec @.ret_status = myproc
Hope this helps.
--
Wayne Snyder, MCDBA, SQL Server MVP
Computer Education Services Corporation (CESC), Charlotte, NC
www.computeredservices.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"frank" <anonymous@.discussions.microsoft.com> wrote in message
news:061e01c3bd2e$b6fe4bd0$a001280a@.phx.gbl...
> i have write several store procedure for export data,
> most of the code such as :insert into Table1(col1,col2)
> from select (col1,col2) form Table2,and i execute it in
> sql analyser,and the analyser will show "x rows affected"
> and now ,i want write a app with C#,call these store
> procedures ,and want to konw
> 1,how many rows affected,analyser can return this?
> 2.how many rows selected,must i rewrite the store
> procedure? such as add a new select count(*) from table2?
> but this will decrease the perfermance
> thank you

About SQL Mobile Server

I need to export(import) data from Pocket PC(SQL Mobile Server) to SQl Server 2005(central data storage) in real time, if anyone knows how it would be better and faster to do...Maybe someone have done something like this...

Sorry for my English, I use it at first for last 6 years...)))

What's "real time" in your case? Also, since you have to have connection at all times for "real time" synchronization, why could not you use SQL Client to talk to SQL Server 2005 directly?

|||Do you have wireless connection between the central database and pocket pc?
|||

Sorry that I didn't answer erlear but for my headake list of my problems is very big...and know I hate peoples who write viruses .....

You See SQL Client...it's not best idea, cause I will have dial-up connect from Pocket PC to central DataBase (6-10GB) and I dont need to see it all..only several tables...and can upgrade them if it need..So I think that it better to make programm which will work with SQL Mobile Server..and then connect to central SQL Server and upgrade it...So I have a question...how it would be better to do...the component which syncronize databases don't work(it's writes that she need .net framework v 2.0.50727 or something like this i have installed .net framework...and so i don't know what is she want from me) It's my first expeerence in programming for Pocket PC, so something that is seem very easy for you for me is not...Sorry for my English...If you know russian it's would be easer for me to tell you what I need thank's!

|||

He says he is using dial-up to connect the Pocket PC with the server. So it would make the most sense to me to store everything he needs locally and only once in a while make a connection to the server to synchronize stuff (RDA or merge).

About that Framework message you get; apart from .NET CF2 did you install SQL Client 2.0 and SQL Server Mobile 2005 on your Pocket PC?

|||

I'll connect them throw Internet...

Thank's.

Sorry for my English.

|||

I think same...

I install full SQL 2005 Server and Mobile Server with native Client..So also think that if i synchronize databaseses they will updates once when connected if it needed.....

Sorry for my english...it's auful I know...

Thank's

|||

Tom v E wrote:

About that Framework message you get; apart from .NET CF2 did you install SQL Client 2.0 and SQL Server Mobile 2005 on your Pocket PC?

Now I dont use now real Pocket PC and this is the biggest problem..I emulate Pocket PC and Pocket OS.

|||

Hi,

SqlClient Vs SqlServerCe

SqlClient does not create any local database (that is SQL Mobile DB)

SqlServerCe would create a local database.

I recommend you to go through Merge Replication and RDA topics in our books online in detail to have a better understanding on how to get your job done.

Thanks

Laxmi Narsimha Rao ORUGANTI, MSFT, SQL Everywhere, Microsoft Corporation

About SQL Mobile Server

I need to export(import) data from Pocket PC(SQL Mobile Server) to SQl Server 2005(central data storage) in real time, if anyone knows how it would be better and faster to do...Maybe someone have done something like this...

Sorry for my English, I use it at first for last 6 years...)))

What's "real time" in your case? Also, since you have to have connection at all times for "real time" synchronization, why could not you use SQL Client to talk to SQL Server 2005 directly?

|||Do you have wireless connection between the central database and pocket pc?
|||

Sorry that I didn't answer erlear but for my headake list of my problems is very big...and know I hate peoples who write viruses .....

You See SQL Client...it's not best idea, cause I will have dial-up connect from Pocket PC to central DataBase (6-10GB) and I dont need to see it all..only several tables...and can upgrade them if it need..So I think that it better to make programm which will work with SQL Mobile Server..and then connect to central SQL Server and upgrade it...So I have a question...how it would be better to do...the component which syncronize databases don't work(it's writes that she need .net framework v 2.0.50727 or something like this i have installed .net framework...and so i don't know what is she want from me) It's my first expeerence in programming for Pocket PC, so something that is seem very easy for you for me is not...Sorry for my English...If you know russian it's would be easer for me to tell you what I need thank's!

|||

He says he is using dial-up to connect the Pocket PC with the server. So it would make the most sense to me to store everything he needs locally and only once in a while make a connection to the server to synchronize stuff (RDA or merge).

About that Framework message you get; apart from .NET CF2 did you install SQL Client 2.0 and SQL Server Mobile 2005 on your Pocket PC?

|||

I'll connect them throw Internet...

Thank's.

Sorry for my English.

|||

I think same...

I install full SQL 2005 Server and Mobile Server with native Client..So also think that if i synchronize databaseses they will updates once when connected if it needed.....

Sorry for my english...it's auful I know...

Thank's

|||

Tom v E wrote:

About that Framework message you get; apart from .NET CF2 did you install SQL Client 2.0 and SQL Server Mobile 2005 on your Pocket PC?

Now I dont use now real Pocket PC and this is the biggest problem..I emulate Pocket PC and Pocket OS.

|||

Hi,

SqlClient Vs SqlServerCe

SqlClient does not create any local database (that is SQL Mobile DB)

SqlServerCe would create a local database.

I recommend you to go through Merge Replication and RDA topics in our books online in detail to have a better understanding on how to get your job done.

Thanks

Laxmi Narsimha Rao ORUGANTI, MSFT, SQL Everywhere, Microsoft Corporation