April 10, 2008 at 5:54 am
Hi everyone! I'm EXTREMELY new to sql server. I downloaded SQL Server 2005 Express with the hopes of converting all of my Access databases to sql server databases. The first thing I need to do is connect to our CMS (I work in a call center in the telecom department). I use Access to connect to it using ODBC, and the connection string looks like this:
ODBC;DRIVER={OpenLink Generic 32 Bit Driver};UID=ilumifi;NoLoginBox=No;FetchBufferSize=30;ReadOnly=No;Host=19.92.60.34;Protocol=TCP/IP;ServerType=Informix 7.2;ServerOptions=;Options=19.92.60.34;Database=CMS;Server=OpenLink;
I've entered this in the Query window (correct term?) and it of course does not work. I'm hoping it's just the syntax. I recorded me connecting to our CMS database using Excel, then I just copied and pasted the connection string. Can anyone help me out with this? I've been googling this for the last few days and I can't seem to find any help with this. A few people pointed out http://www.connectionstrings.com, but I can't get that to work either. Thanks for any help!
Dave
April 11, 2008 at 6:27 am
You have to create connection to that CMS system using linked server functionality. Read about linked servers in BOL.
Piotr
...and your only reply is slàinte mhath
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply