Using the MS SQL Server 2005 CTP on os win2k prof.
I have set up two datasets in a report that are supposed to be referencing
to separate data sources where the following connection strings are aimed at
separate files in the same target folder: -
DataSource1: -
Dsn=Excel
Files;dbq=<drive>:\<folder>\<file1.xls>;defaultdir=<drive>:\<folder>;driverid=790;maxbuffersize=2048;pagetimeout=5
DataSource2: -
Dsn=Excel
Files;dbq=<drive>:\<folder>\<file2.xls>;defaultdir=<drive>:\<folder>;driverid=790;maxbuffersize=2048;pagetimeout=5
I can correctly import the columns of File1.xls to DataSet1 but when
attempting to import File2.xls to DataSet2, the columns of DataSet1 are only
visible.
I have definitely referenced the correct data sources to each dataset.
Any ideas why DataSource2 is not appearing?
Cheers
TrevI have found the solution - set up individual File DSNs for each file and
point to these; they can be generic too.
Thx to those who may have provided feedback if I had not answered my own
question!!!
"auldreidy" wrote:
> Using the MS SQL Server 2005 CTP on os win2k prof.
> I have set up two datasets in a report that are supposed to be referencing
> to separate data sources where the following connection strings are aimed at
> separate files in the same target folder: -
> DataSource1: -
> Dsn=Excel
> Files;dbq=<drive>:\<folder>\<file1.xls>;defaultdir=<drive>:\<folder>;driverid=790;maxbuffersize=2048;pagetimeout=5
> DataSource2: -
> Dsn=Excel
> Files;dbq=<drive>:\<folder>\<file2.xls>;defaultdir=<drive>:\<folder>;driverid=790;maxbuffersize=2048;pagetimeout=5
> I can correctly import the columns of File1.xls to DataSet1 but when
> attempting to import File2.xls to DataSet2, the columns of DataSet1 are only
> visible.
> I have definitely referenced the correct data sources to each dataset.
> Any ideas why DataSource2 is not appearing?
> Cheers
> Trev|||how did you get the excel file to import into the dataset?
i can't seem to figure this out in the Query String window after setting up
the dsn...
"auldreidy" <auldreidy@.discussions.microsoft.com> wrote in message
news:E7921576-2D35-45CC-A742-540C46D2E13B@.microsoft.com...
> Using the MS SQL Server 2005 CTP on os win2k prof.
> I have set up two datasets in a report that are supposed to be referencing
> to separate data sources where the following connection strings are aimed
> at
> separate files in the same target folder: -
> DataSource1: -
> Dsn=Excel
> Files;dbq=<drive>:\<folder>\<file1.xls>;defaultdir=<drive>:\<folder>;driverid=790;maxbuffersize=2048;pagetimeout=5
> DataSource2: -
> Dsn=Excel
> Files;dbq=<drive>:\<folder>\<file2.xls>;defaultdir=<drive>:\<folder>;driverid=790;maxbuffersize=2048;pagetimeout=5
> I can correctly import the columns of File1.xls to DataSet1 but when
> attempting to import File2.xls to DataSet2, the columns of DataSet1 are
> only
> visible.
> I have definitely referenced the correct data sources to each dataset.
> Any ideas why DataSource2 is not appearing?
> Cheers
> Trev|||I set up a shared data source and then referenced it in the report dataset.
When you're setting up the data source, RD allows you to browse for the dsn
so you don't need to figure it out!
Trev
"TroyS" wrote:
> how did you get the excel file to import into the dataset?
> i can't seem to figure this out in the Query String window after setting up
> the dsn...
>
> "auldreidy" <auldreidy@.discussions.microsoft.com> wrote in message
> news:E7921576-2D35-45CC-A742-540C46D2E13B@.microsoft.com...
> > Using the MS SQL Server 2005 CTP on os win2k prof.
> >
> > I have set up two datasets in a report that are supposed to be referencing
> > to separate data sources where the following connection strings are aimed
> > at
> > separate files in the same target folder: -
> >
> > DataSource1: -
> >
> > Dsn=Excel
> > Files;dbq=<drive>:\<folder>\<file1.xls>;defaultdir=<drive>:\<folder>;driverid=790;maxbuffersize=2048;pagetimeout=5
> >
> > DataSource2: -
> >
> > Dsn=Excel
> > Files;dbq=<drive>:\<folder>\<file2.xls>;defaultdir=<drive>:\<folder>;driverid=790;maxbuffersize=2048;pagetimeout=5
> >
> > I can correctly import the columns of File1.xls to DataSet1 but when
> > attempting to import File2.xls to DataSet2, the columns of DataSet1 are
> > only
> > visible.
> >
> > I have definitely referenced the correct data sources to each dataset.
> >
> > Any ideas why DataSource2 is not appearing?
> >
> > Cheers
> > Trev
>
>
Showing posts with label win2k. Show all posts
Showing posts with label win2k. Show all posts
Wednesday, March 28, 2012
Tuesday, February 21, 2012
Replication/Admin Help
We run a small business with a LAN of 2 pcs, a laptop pc, and a web server that runs Win2k Server with Exchange on it. My pc is used for most of the development and it also houses SQL Server (Developer) 2k. We have SQL Server (Developer) installed on the other network pc as well.
Here's the problem: We sometimes have to take my pc with us to use at different sites (with no internet connectivity at the time). When this happens, any data access on our web site is 'down' because our web data is in the sql server db on my machine. I want to replicate the db on the other pc so that we can take that machine to the different sites. I am having trouble getting this done.
Can someone give me some direction? Is there a good tutorial or a book or whatever somewhere? I am really in need of some sql server admin knowledgebase.
Thanks!!Have you considered merge replication? you could then publish to your network sites from either computer with transactional publications and have the two "master" databases have a merge publication between them. When the machine goes off site, the other will continue to provide data to the site and when the other machine returns, any update made to it can be merged with the local machine.
if this will do the trick, books online should have all you need as far as setting it up goes...|||Have you considered merge replication? you could then publish to your network sites from either computer with transactional publications and have the two "master" databases have a merge publication between them. When the machine goes off site, the other will continue to provide data to the site and when the other machine returns, any update made to it can be merged with the local machine.
if this will do the trick, books online should have all you need as far as setting it up goes...
Here's the problem: We sometimes have to take my pc with us to use at different sites (with no internet connectivity at the time). When this happens, any data access on our web site is 'down' because our web data is in the sql server db on my machine. I want to replicate the db on the other pc so that we can take that machine to the different sites. I am having trouble getting this done.
Can someone give me some direction? Is there a good tutorial or a book or whatever somewhere? I am really in need of some sql server admin knowledgebase.
Thanks!!Have you considered merge replication? you could then publish to your network sites from either computer with transactional publications and have the two "master" databases have a merge publication between them. When the machine goes off site, the other will continue to provide data to the site and when the other machine returns, any update made to it can be merged with the local machine.
if this will do the trick, books online should have all you need as far as setting it up goes...|||Have you considered merge replication? you could then publish to your network sites from either computer with transactional publications and have the two "master" databases have a merge publication between them. When the machine goes off site, the other will continue to provide data to the site and when the other machine returns, any update made to it can be merged with the local machine.
if this will do the trick, books online should have all you need as far as setting it up goes...
Subscribe to:
Posts (Atom)