| Author |
Topic |
|
davers
Starting Member
14 Posts |
 Posted - 2008-04-09 : 09:38:07
|
Hi everyone. I'm trying to switch from using Access, to using Sql Server to create my databases. The first thing I'd like to do, is connect to our CMS (Call Management System) to start creating reports on some of our data. I can't seem to figure out how to connect to it though. In Access, I use an ODBC connection. I installed a "Generic 32 Bit Driver" and I created a .dsn file called Lucent.dsn that Access uses to connect to the Informix database. I guess my question is, what is the connection string and where does it go?  I've searched on this forum and on a few others and I can't seem to find help for someone as new as me!  Thanks for any help!DaveWindows XP, Office XP |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2008-04-09 : 09:42:02
|
www.connectionstrings.com
E 12°55'05.25"N 56°04'39.16" |
 |
|
|
davers
Starting Member
14 Posts |
Posted - 2008-04-09 : 09:48:39
|
| Hi Peso, yes, I found that website as well. But it doesn't tell me "where" to put the connection strings. Here is their answer for that: "Okey, I get it, but where are those connection strings located?Well, the connection string is really just a string inside your application. There is no ODBC DSN admin kind of program for connection strings. You just write your connection string and pass it on to your connection object. The property is named ConnectionString or is passed through the Open function of your connection object." That doesn't answer my question as to where I put that. In Access, I can put it in a module. Or I just choose, File/Get External Data/Link Tables...I'm really new here and I haven't a clue as to how to go about this...Thanks again for any help!DaveWindows XP, Office XP |
|
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2008-04-09 : 09:50:33
|
If you are trying to make a LINKED SERVER, you put the connection string there.
E 12°55'05.25"N 56°04'39.16" |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-04-09 : 09:51:43
|
| If you have already ODBC setup for informix and trying to connect to SQL Server, Use Linked server with Provider:MSDASQL and get connected to Informix. |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-04-09 : 09:52:36
|
| Peso, Technical Echo!!! |
|
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2008-04-09 : 09:59:15
|
quote:
Originally posted by sodeep
Peso, Technical Echo!!!
That can be expressed as  MadhivananFailing to plan is Planning to fail |
|
|
|
davers
Starting Member
14 Posts |
Posted - 2008-04-09 : 10:04:34
|
| Hi sodeep..thanks, I do already have it setup...but I don't know what you mean by:"Use Linked server with Provider:MSDASQL and get connected to Informix."Can you point a noob in the right direction..preferably close enough so I bump my nose on the solution! Thanks again,DaveWindows XP, Office XP |
|
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2008-04-09 : 10:13:25
|
Something simmilar toUSE [master]GOEXEC master.dbo.sp_addlinkedserver @server = N'INFORMIX', @srvproduct=N'A', @provider=N'Ifxoledbc.2', @datasrc=N'dbName@serverName', @location=N'D', @provstr=N'Password=myPassword;User ID=myUsername;Persist Security Info=true;', @catalog=N'E'GO
E 12°55'05.25"N 56°04'39.16" |
|
|
|
davers
Starting Member
14 Posts |
Posted - 2008-04-09 : 10:18:27
|
| Hi Peso, does that go in as a query? :-/ Thanks again for the help..I really appreciate it!DaveWindows XP, Office XP |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-04-09 : 10:18:40
|
| Choose ODBC provider:MSDASQL in linked server. |
|
|
|
davers
Starting Member
14 Posts |
Posted - 2008-04-09 : 11:56:46
|
| Maybe it's the version that's causing problems for me? I found that same thing online...MSDASQL in linked server. But I can't find "linked server" anywhere in "Server Manager Studio Express". I'm using SQL Server 2005 Express. Does that make a difference?Thanks again! I'm such a noob! :-/DaveWindows XP, Office XP |
|
|
|
|
Connect to Informix database