MDB DATA REPLICATE To SQL 2000

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

General SQL Server Forums

New to SQL Server Programming

MDB DATA REPLICATE To SQL 2000

Author

Topic

guruchi_20
Starting Member

24 Posts

Posted - 2009-01-21 : 03:48:33

hi friends,
i am joey joya from philippines 23 years old and software developer engineer trainee. m question is......
"is it possible to replicate the microsoft access (mdb) data to SQL table without using the Data Transformation Services (DTS)
because i have a project now and i want the data from .mdb to sql table at a real time. "
because when you used the DTS the minimum time is one minute, so it means you'll wait 1 minute to update your data.
friend hope you help me for my problem.
this is my number 09203537081

THANK YOU VERY MUCH

sodeep
Master Smack Fu Yak Hacker

7174 Posts

Posted - 2009-01-21 : 10:48:35

See this:
http://www.sqlteam.com/article/replicating-sql-server-2000-across-heterogeneous-databases

guruchi_20
Starting Member

24 Posts

Posted - 2009-01-21 : 18:28:47

Thanks a lot sodeep,

because i have a tester excel application and it is produced the data once to used it and saved it to microsoft access,
then the microsoft access send the data through SQL database using the Data Transformation Services (DTS) but the DTS minimum update is 1 minute. and i want to replicate the Access Data to SQL table using 2000 server. in a real time.
how is it possible?

thanks for the link it's very helpful for new knowledge to me.
thanks again.

sodeep
Master Smack Fu Yak Hacker

7174 Posts

Posted - 2009-01-21 : 19:18:05

Did you follow the link? It is explained clearly in steps.

guruchi_20
Starting Member

24 Posts

Posted - 2009-01-21 : 19:39:59

yeap but the error on the first step is SQL Server replication does not support the nicknames.....
Delete the SQL Server registration for this server and register it using the actual server name.

sir, i have an active server now. it is capable to delete it.
please help me. thanks

sodeep
Master Smack Fu Yak Hacker

7174 Posts

Posted - 2009-01-21 : 19:44:12

That is because you are using local for default instance.

Run this in SQL Server:

Select @@Servername and put that in Servername(Your host name).

guruchi_20
Starting Member

24 Posts

Posted - 2009-01-21 : 19:47:37

where do i run?

sodeep
Master Smack Fu Yak Hacker

7174 Posts

Posted - 2009-01-21 : 19:49:56

New Query button in SQL Server.

guruchi_20
Starting Member

24 Posts

Posted - 2009-01-21 : 19:56:58

in QUERY ANALYZER, sir i used sql 2000 server
i can't find new query button
thank you

sodeep
Master Smack Fu Yak Hacker

7174 Posts

Posted - 2009-01-21 : 20:03:06

Yes sir, that is correct one.

guruchi_20
Starting Member

24 Posts

Posted - 2009-01-21 : 20:06:44

here is new error.
Server: Msg 137, Level 15, State 2, Line 1
Must declare the variable '@@sptlmes02'.

sorry and thank you for everything

sodeep
Master Smack Fu Yak Hacker

7174 Posts

Posted - 2009-01-21 : 20:08:17

Run:

Select @@Servername in Query analyzer

guruchi_20
Starting Member

24 Posts

Posted - 2009-01-21 : 20:20:41

i run in query analyzer
Select @@Servername

the result is
SPTLMES02

and then..

guruchi_20
Starting Member

24 Posts

Posted - 2009-01-21 : 20:30:44

the same error
SQL Server replication does not support the nicknames.....
Delete the SQL Server registration for this server and register it using the actual server name.

i can't go to the next step of the link because of the said error.
please help

guruchi_20
Starting Member

24 Posts

Posted - 2009-01-21 : 22:08:56

anyone can help me please???......

guruchi_20
Starting Member

24 Posts

Posted - 2009-01-22 : 08:59:13

help me please

sodeep
Master Smack Fu Yak Hacker

7174 Posts

Posted - 2009-01-22 : 09:29:29

Connect with your Actual Servername which is SPTLMES02 (not localhost).

guruchi_20
Starting Member

24 Posts

Posted - 2009-01-22 : 19:08:45

sptlmes02 is my active server
i'll connect there by using remote desktop,

guruchi_20
Starting Member

24 Posts

Posted - 2009-01-25 : 22:41:40

Help!!!
Help!!!
Help!!!
Help!!!

sodeep
Master Smack Fu Yak Hacker

7174 Posts

Posted - 2009-01-26 : 10:06:13

I am not getting what you are trying. Do exactly as link says?

guruchi_20
Starting Member

24 Posts

Posted - 2009-02-04 : 19:28:29

hi sodeep do you know how to transfer the data from access file to sql database at the same computer without using the DTS
because dts tranfer the data is minimum is 1 minute.
what if once the access application save another data on the field automatically saved into sql at a real time
access application saved on drive e of the sptlmes02 computer
sql databse saved on drive e of the sptlmes02 computer

you know this kind of problem?
what can i used to improve my system without using the Data Tranformation Services (DTS)

thanks

Next Page

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources