| Author |
Topic |
|
stuaz
Starting Member
16 Posts |
 Posted - 2009-10-31 : 13:47:13
|
| Hi,I am very new to SQL and while I know "basic" SQL queries this is my first time doing a task like this.What I have is a SQL Server (SQL Server 2008 Express), within that I have database. I also have another database (IBM Unidata) which is on another server.Now I have all the Database drivers set up to talk to that Unidata database (I can extract data via Excel and in MSQuery), however I am not sure how, withing SQL Server I can extract this data and place it into a table.Any help would be most appriceated!Thanks, |
|
|
afrika
Master Smack Fu Yak Hacker
2706 Posts |
Posted - 2009-10-31 : 15:37:23
|
| Yes, you can with sql server just simply use the IP,portnumber as the server instance. e.g 127.0.0.1,2433However you must configure it to accept remote connections. |
 |
|
|
stuaz
Starting Member
16 Posts |
Posted - 2009-10-31 : 18:52:22
|
| Sorry, it might be that I am not understanding, I thought an "instance" would be the SQL server? I can connect to the SQL server just fine. What I want to know is how within my Database in SQL I can extract data via ODBC from my UniData database.Thanks, |
|
|
|
afrika
Master Smack Fu Yak Hacker
2706 Posts |
Posted - 2009-11-01 : 07:10:03
|
| >> how within my Database in SQL I can extract data via ODBC from my UniData databaseam not understanding you,... do you mean via a web page or application ? |
|
|
|
stuaz
Starting Member
16 Posts |
Posted - 2009-11-01 : 07:54:36
|
| Well I need to extract data from my Unidata Database into my SQL database, (Via an ODBC link) but not sure how to do it. So it wouldn't be using an Web Page or Application, I litrally just want to populate tables that are in my SQL database with Tables that are in my Unidata database. |
|
|
|
afrika
Master Smack Fu Yak Hacker
2706 Posts |
Posted - 2009-11-03 : 17:40:39
|
| Yes you can simply connect by entering the IPaddress of your remote db and port number in management studio. e.g 127.0.0.1,2433 |
|
|
|
X002548
Not Just a Number
15586 Posts |
|
|
stuaz
Starting Member
16 Posts |
Posted - 2009-11-03 : 18:30:03
|
| Please excuse my noobness with this, but how do you do that. Is it possible in SQL Server 2008 Express.I can see how to connect to ohter SQL databases, but not another data source.Thanks again!! |
|
|
|
stuaz
Starting Member
16 Posts |
|
|
stuaz
Starting Member
16 Posts |
Posted - 2009-11-03 : 18:56:04
|
quote:
Originally posted by stuaz
quote:
Originally posted by X002548
do you know what a linked server is?Brett8-)Hint: Want your questions answered fast? Follow the direction in this linkhttp://weblogs.sqlteam.com/brettk/archive/2005/05/25/5276.aspxAdd yourself!http://www.frappr.com/sqlteam
I understand the concept yes, but no how to do it under SQL Server.
Nevermind I worked out how to get the linked server menu up, just need to work out the connection string. Thanks again for the help. |
|
|
|
|
Connection to another database to extract data