Friday, March 30, 2012

Problems Linking to Oracle Server

Has anyone successfully linked to an Linux Oracle server running 9i? We are unable to get the link working.....have installe dvarious drivers and still get connection refused. Any thoughts?

If this is a Linked Server issue I would try the SQL Server Engine forum.

Donald

Problems linking Access to SQL replicated tables

Hello!
I was wondering if anyone could help me.
I am running an Access application that uses linked tables to connect to a SQL server.
Ever since I turned on replication on those tables, I cannot add records to the table using regular Access forms (and, for that matter, I cannot do it by just double-clicking on the table from Access and trying to enter records).

Any help will be greatly appreciated!!!!!Have you also refreshed those links i.e.(deleted the links and recreated them in Access) since you "turned on replication on those tables" (or not)?|||Yes, I have deleted the link and recreated it after turning on replication, but I still get the same error every time I add a record.|||You are able to add a row via query analyzer or EM, and the table is not a read only subscribed table you are attempting to add rows to? (just asking the obvious things)
If all that is in order you might check to see if the generated link schemas include columns that the system automatically populates with data. If there are some (replication related columns) or others such as identity, GUID, timestamp, etc. columns (that are automatically populated), try removing them from the Access link schemas (not the base tables) then recreate your link(s) and attempt a test row insert. If that does not work try creating a view (test insertion in QA / EM), then create a linked table to the view and test its behavior.sql

problems joing data that contains quotes.....

How can I do a join where the data contins single quotes?
eg we have two suburbs in canberra called
O'MALLEY
and
O'CONNER
I have to make a join between two tables based on the value of the
suburb...but the join fails and always returns null when joining on these
two suburbs - other suburbs work just fine. Given that I cant change the
name of the suburbs(!) how can I make the join work:
select c.surname, homesuburb,uluACTSuburbs.code from community c join
join addresses a on a.addressid=c.addressid
left join uluACTSuburbs on homesuburb=uluACTSuburbs.description
returns null where homesuburb = O'MALLEY or O'CONNOR
Is there any way to quote the entire value before making the join?
Al Blake, Canberra, AustraliaHi
create table #test1
(
col1 varchar(50)
)
insert into #test1 values ('John')
insert into #test1 values ('Bill')
insert into #test1 values ('O''Connor')
create table #test2
(
col1 varchar(50)
)
insert into #test2 values ('Alexl')
insert into #test2 values ('Tom')
insert into #test2 values ('O''Connor')
select a.col1,b.col1 from #test1 a join #test2 b
on a.col1=b.col1
Note: If it does not help you please post DDL + sample data + expected
result
"Al Blake" <al@._delete_this_.blakes.net> wrote in message
news:uw$%23rilEFHA.3492@.TK2MSFTNGP12.phx.gbl...
> How can I do a join where the data contins single quotes?
> eg we have two suburbs in canberra called
> O'MALLEY
> and
> O'CONNER
> I have to make a join between two tables based on the value of the
> suburb...but the join fails and always returns null when joining on these
> two suburbs - other suburbs work just fine. Given that I cant change the
> name of the suburbs(!) how can I make the join work:
> select c.surname, homesuburb,uluACTSuburbs.code from community c join
> join addresses a on a.addressid=c.addressid
> left join uluACTSuburbs on homesuburb=uluACTSuburbs.description
> returns null where homesuburb = O'MALLEY or O'CONNOR
> Is there any way to quote the entire value before making the join?
> Al Blake, Canberra, Australia
>|||Doh,
I this case it was my own fault ;)
The data had been imported from word and someone had used the ACCENT
character, not single quote for O'Malley.
When I changed the character the join works prefectly without any messing
about.
Thanks for your reply anyway.
Al
"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:e%237NCrlEFHA.3416@.TK2MSFTNGP09.phx.gbl...
> Hi
> create table #test1
> (
> col1 varchar(50)
> )
> insert into #test1 values ('John')
> insert into #test1 values ('Bill')
> insert into #test1 values ('O''Connor')
> create table #test2
> (
> col1 varchar(50)
> )
> insert into #test2 values ('Alexl')
> insert into #test2 values ('Tom')
> insert into #test2 values ('O''Connor')
>
> select a.col1,b.col1 from #test1 a join #test2 b
> on a.col1=b.col1
>
> Note: If it does not help you please post DDL + sample data + expected
> result
>
>
>
> "Al Blake" <al@._delete_this_.blakes.net> wrote in message
> news:uw$%23rilEFHA.3492@.TK2MSFTNGP12.phx.gbl...
>|||Hi
Check what type of quote is actually present: ' or `
It is a normal character, so a join does not care what type of character it
is.
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Al Blake" <al@._delete_this_.blakes.net> wrote in message
news:uw$#rilEFHA.3492@.TK2MSFTNGP12.phx.gbl...
> How can I do a join where the data contins single quotes?
> eg we have two suburbs in canberra called
> O'MALLEY
> and
> O'CONNER
> I have to make a join between two tables based on the value of the
> suburb...but the join fails and always returns null when joining on these
> two suburbs - other suburbs work just fine. Given that I cant change the
> name of the suburbs(!) how can I make the join work:
> select c.surname, homesuburb,uluACTSuburbs.code from community c join
> join addresses a on a.addressid=c.addressid
> left join uluACTSuburbs on homesuburb=uluACTSuburbs.description
> returns null where homesuburb = O'MALLEY or O'CONNOR
> Is there any way to quote the entire value before making the join?
> Al Blake, Canberra, Australia
>

Problems ith Connection string to SQL Express

My application is usningtraditional connection string:

<

addkey="DbConnection"value="driver={SQL Native Driver}; provider=SQLNCLI;server=localhost;trusted_connection=yes;database=ebay" />

It works fine with database attached to SQL Server, how do I make this working with SQL Express attachable file in data directory?

I have tried this, but it does not work:

Provider=SQLNCLI;Server=RAF001\SQLExpress;AttachDbFilename=..\TestSite\App_Data\ebay.mdf;Database=ebay;Trusted_Connection=Yes;

Problems integrating reporting services into a web app

Hello

I have an existing web app on my web server, and reporting services on my app server. I'm trying to integrate the reports into the web app.

The problem is, when the user clicks 'execute report', the app, predictably, falls over, because the aspx page thinks it's on the same server as reporting services, whereas it's not.

Does anybody know how these requests from the aspx page can be redirected to a different server? The way I see it, if I can't get the integration working through url access, I'll have to use the soap api, which will involve dynamically creating drop downs for the report parameters, etc, which is moving away from utilising the advantages that reporting services brings!

Any thoughts would be greatly appreciated.

Thanks in advance
Dominic

Hi Dominic,

this article will help you embed the report in your web application:
http://msdn2.microsoft.com/en-us/library/ms153563.aspx

regards
Helen|||

Thanks for the reply helen. My problem is that in our architecture the client can't access the report server directly. I've decided to go with the reportviewer control instead.

Cheers

Dominic

Problems instancing Reporting Services

I set up Reporting Services as a Web Reference and when I try to instance it, I get a "type expected" error message. Let's say the web reference is named SQLRS. When I do a DIM rs as NEW SQLRS, a blue squiggly appears under SQLRS and it displays the type expected error message.

What am I missing? Anyone know or have a link to an example I could look at? Thanks for any help.Additional information:

When I bring up the Reporting Services as a web reference, I don't get a drop down list of the methods and properties that are listed in the Add a Web Reference dialogue box and from what I've seen in examples online. For instance, there should be a ListChildren method, but I don't see it when intellisense kicks in.

Example: Let's say I name the web service ReportingService. If I try to instance it by going DIM rs as NEW ReportingService, I get the blue squiggly line complaining that "Type expected". If I type ReportingService. intellisense kicks in, but what appears in the drop down box is not what I expect. There are no ListChildren, ListEvents, ListJobs, etc.

What I suspect is that I need to DIM the ReportingService with one of the selections from the intellisense dropdown box, but I have no idea which one as all the examples I've seen online show differently. Has there been changes to this with service pack 2 that I'm not aware of? Any help would be appreciated.|||Ok, I just love answering my own questions.

It turns out that all the examples I've been trying to follow are a bit off. To create an instance of the Reporting Services as a web service, first add the web service as a web reference to your project. (i.e., right click on references in the solution explorer and type in the web address of the reporting services: http://myserver/ReportServer/ReportService.asmx)

Then, to create an instance, use something like:

DIM rs as NEW ReportingService.ReportingService

Now you will have an object called rs that will have the properties and methods of the ReportingService web service such as ListChildren, ListJobs, Render, etc.

Problems installing/accessing SQL server via web

Hello,
I am doing some development for a client who has an IIS server running
webmail on the same box as the SQL server 2000 sp3 install. I am trying to connect to
this box but do not know how to set it up to connect. The IIS for SQL server
tool lets me add a virtual directory just fine but will not connect. This
problem is not firewall based, as the 1433 port is open, and the database is
running just fine, as those in the LAN can connect ok. My problem is with
the 'external' face and my concern that the running IIS process is
preventing web-based connection. How do I modify/change the IIS for SQL
virtual directory to respond?
If you need more information, please let me know.
Thanks,
Donald Wheeler
What error do you get when you attempt to connect?
Rand
This posting is provided "as is" with no warranties and confers no rights.
|||I get the standard server not found or access denied error - both via ASP calls and the SQL Server Query analyzer. I don't think that it's an authentication problem because I've tried using both valid and invalid passwords, as well as trying to the connec
t to the Northwind database, and received the same error
Donald
|||Just to clarify, I am trying to enable web access to a SQL Server 2k sp3 database on a machine that already has a set of active IIS directories for webmail. I think the firewall is ok but the connections are getting 'swallowed' by the active IIS and not h
itting the SQL server - does this make sense and if so, how may I remedy it?
Thanks,
Donald Wheeler
sql