Accesing information from an Informix database

Hi,

I d like to know if there is any way to access an Informix database from sqlserver 2005.

We are trying to build a data warehouse in SS2005, and I want to know If I could avoid the generation of hundreds of flats files from Informix and loading them into SS2005, directly recovering all information from SS2005 across any kind of migration or connection.

Any help would be very appreciated

Regards.We access an Informix database from SQLSVR 2000 via an ODBC connection using a driver named MERANT 3.50 32-BIT INFORMIX.|||That's the way we do it as well. ODBC connection, linked server ... start moving the data !

Gr,
Yveau

Absolut Noob here.

Hi all,
I've been working with SQL Server 2000 for most of the development I do but
now we're looking to build a small database that can run locally on the
client machine along with the application with which it will be distributed.
The following are my questions regarding this.
What do I need to do to properly create a database that will be accessible
by MSDE on a client machine?What is the best way to access it once it's
there (ie creating an ODBC System DSN)?
Can I do all of the database design work in SQL Server 2000?
Thanks in advance for the help.
Regards,
Daniel Hobert
hi Daniel,
Daniel Hobert wrote:
> Hi all,
> I've been working with SQL Server 2000 for most of the development I
> do but now we're looking to build a small database that can run
> locally on the client machine along with the application with which
> it will be distributed.
as you are used to SQL Server, MSDE is the same engine (with some
limitations) and all you know about SQL Server is valid for MSDE as long as
you do not hit it's limitations...

> The following are my questions regarding this.
> What do I need to do to properly create a database that will be
> accessible by MSDE on a client machine?
you have all the SQL Server possibilities available, from detach-attach,
backup/restore and script/exec...
I am an estimator of the latter, where you get the DDL code from your source
control system to create the user's database(s) your application need, where
you inherit from destination model database all the available settings as
long as included objects/users...
just for your note, the best article I read about such a kind of
installation, including database schema support is
http://msdn.microsoft.com/msdnmag/is...einstaller/...

>What is the best way to access
> it once it's there (ie creating an ODBC System DSN)?
it really depends on your coding standard... personally I always use
DSN-less connections as ADO/Ado.Net support them very well...

> Can I do all of the database design work in SQL Server 2000?
yes and you should... MSDE is intended as a distribution platform and not as
a development paltform, with all of your dev tools available, like EM, Query
Analyzer, Index Tuning, Profiler and the like..
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.12.0 - DbaMgr ver 0.58.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||Hi Andrea,
Thanks a ton for the quick response and the link to the article .
Cheers,
Daniel
"Andrea Montanari" <andrea.sqlDMO@.virgilio.it> wrote in message
news:3h65jcFf4sp8U1@.individual.net...
> hi Daniel,
> Daniel Hobert wrote:
>
> as you are used to SQL Server, MSDE is the same engine (with some
> limitations) and all you know about SQL Server is valid for MSDE as long
> as you do not hit it's limitations...
>
> you have all the SQL Server possibilities available, from detach-attach,
> backup/restore and script/exec...
> I am an estimator of the latter, where you get the DDL code from your
> source control system to create the user's database(s) your application
> need, where you inherit from destination model database all the available
> settings as long as included objects/users...
> just for your note, the best article I read about such a kind of
> installation, including database schema support is
> http://msdn.microsoft.com/msdnmag/is...einstaller/...
>
> it really depends on your coding standard... personally I always use
> DSN-less connections as ADO/Ado.Net support them very well...
>
> yes and you should... MSDE is intended as a distribution platform and not
> as a development paltform, with all of your dev tools available, like EM,
> Query Analyzer, Index Tuning, Profiler and the like..
> --
> Andrea Montanari (Microsoft MVP - SQL Server)
> http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
> DbaMgr2k ver 0.12.0 - DbaMgr ver 0.58.0
> (my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
> interface)
> -- remove DMO to reply
>

About SQL Server Management Studio Express CTP

All,

I downloaded SQL Server Management Studio Express CTP (v9.00.1399) dated 11/11/05. May I know if this is the latest stable build of the application to be used for SQL Server 2005 Express (final release version)?

Why it is CTP?
Thanks,
WilliamThe November 11 CTP is the latest stable build.

Management Studio Express is a new product that hasn't had all the testing that SQL Server 2005 Management Studio has had and isn't quite ready to be released. The CTP lets a broad range of users try the product out while we can still easily fix any problems that are found.

Also, the feature set for Management Studio Express is not yet final, so we want to use the CTP to gather feedback on how well the current set of features work for people. Depending on what feedback we get, we can still make feature set changes in a pre-release product.

About ReportViewer Control

I build a web page,display a report with ReportViewer ,I set its height 100% ,but the page doesn't display anything, why?

thanks for any helps.

Can you attach an RDL (or .rdlc) file with report definition to this post?

Thanks,

|||

100% height doesn't work. For a description, see http://www.gotreportviewer.com (FAQ #14).

This is on my list of things to figure out, but just haven't had the time. It must be possible since it works in the MS Report Manager and the Dundas demo (http://demos2.dundas.com/ReportingServices/).

What I would like to find is a sample asp.net application that interfaces with the reportviewer by resizing the height and modifying report parameters.

about analysis manager data mining model

i use sql server analysis manager and build a cube,
the i right click the cube ,select new mining model,
a messege box tell me: 'unable to get list of data mining
model algorithms,object or provider is not capabel of
performing requested operation'
what shall i do? install a new service pack?Please do not post the same question to multiple groups.
--
Dejan Sarka, SQL Server MVP
FAQ from Neil & others at: http://www.sqlserverfaq.com
Please reply only to the newsgroups.
PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org
"frank" <wang_jidong@.founder.com.cn> wrote in message
news:0db101c3858d$6c8d7a40$a301280a@.phx.gbl...
> i use sql server analysis manager and build a cube,
> the i right click the cube ,select new mining model,
> a messege box tell me: 'unable to get list of data mining
> model algorithms,object or provider is not capabel of
> performing requested operation'
> what shall i do? install a new service pack?