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 |
|
CortexWayne
Starting Member
4 Posts |
 Posted - 2003-01-20 : 10:09:34
|
| Hi! I'm a french Canadian so excuse my poor english...I have a SQL 2000 Server on my PDC and I have a dedicated server for our production management system with an ODBC database.On my SQL 2000 server, I can import data via ODBC...Here is my problem. My production management system requiere lisence that worth 3000$ each. I have 13 of them. But we implemented a new program linked to our production management system which use the ODBC to connect with. Now this new program need 42 connections to the production management system... The whole laboratory. To save 87 000$ I need to link my SQL 2000 Server directly to my production management system. This way, instead of connecting my new program to The ODBC, I'll connect it to my SQL Server and it will have only 1 connection. What I'm unable to do is linking my SQL Server to my ODBC management system. I can import but not link. All help would be greatly appreciated.Martin Lamontagne. |
|
|
ValterBorges
Master Smack Fu Yak Hacker
1429 Posts |
Posted - 2003-01-20 : 10:35:33
|
| Can you post what commands you are using so we can test. |
 |
|
|
CortexWayne
Starting Member
4 Posts |
Posted - 2003-01-20 : 11:04:31
|
| Now this is my problem, I know only a bit of SQL. I want a copy of my management system table in SQL but I want it to be linked so it update automaticaly. I know how to do it in access but it's really really too slow. I can import it just with the wizard but it is not linked so when I change data in it it does change into the database... |
|
|
|
|
|
|
LINKED Database To ODBC