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.
| Author |
Topic |
|
ArviL
Starting Member
25 Posts |
 Posted - 2010-09-07 : 06:45:34
|
| HiI have my applications running on 64bit SQL Server 2005, and I need periodically reread some data from dbf-tables (and form Access databases). It looks like an 64bit MS ODBC driver was published lately, but surely there doesn't exist 64bit ODBC driver for FoxPro tables.We installed SQL Server 2005 Express on another virtual server, along with needed ODBC drivers, and I'm planning a couple of tables there and a couple of stored procedures, which read data from dbf-tables and Access applications, and stores refreshed info in tables.The problem is with sheduled refreshing of the data. I know it is possible using sheduled tasks (somewhat cumbersome), but I'm curious, cant I do it from main (64bit) SQL Server? I.e. I create there a job, which starts stored procedure(s) on 32bit SQL server Express!Thanks in advance!Arvi Laanemets |
|
|
ArviL
Starting Member
25 Posts |
Posted - 2010-09-10 : 05:15:42
|
| The case resolved!I defined SQL Server Express instance as linked server on 64bit SQL server. |
 |
|
|
|
|
|
Running a stored procedure on another SQL Server