OLAP AS Connection Weirdness

I have a stand alone win2k3 report server(i.e. SQL is not on the box).
RS SP1 is installed
I have a SQLRS report developed in visual studio (also loaded on RS
box) that runs MDX against an analysis services cube. I am using the
OLE DB provider for OLAP services 8.0. (Note that we had to run
ptsfull.exe to get the pivot table service and 8.0 provider to be
available)
I can successfully preview the report in visual studio.
When I upload the report to Report Manger, the report bombs with...
An error has occurred during report processing. (rsProcessingAborted)
Get Online Help
Cannot create a connection to data source 'AAHP'.
(rsErrorOpeningConnection) Get Online Help
Database '<source name>' does not exist.
Am I missing something on the report server?
Thanks!Jim wrote:
> When I upload the report to Report Manger, the report bombs with...
> An error has occurred during report processing. (rsProcessingAborted)
> Get Online Help
> Cannot create a connection to data source 'AAHP'.
> (rsErrorOpeningConnection) Get Online Help
> Database '<source name>' does not exist.
> Am I missing something on the report server?
The report bombs while uploading?
Do you tried to open the AS-DB in the analysis-manager on the reportserver?
regards
Frank|||Sorry, no. The report bombs when I try to run it via report manager. I
can open the AS-DB and cube in Analysis Manger (which is Not on the
report server). I have a role setup that should allow the stored
credentials to successfully authenticate.|||Jim wrote:
> Sorry, no. The report bombs when I try to run it via report manager. I
> can open the AS-DB and cube in Analysis Manger (which is Not on the
> report server). I have a role setup that should allow the stored
> credentials to successfully authenticate.
Jim,
lets have a look into the eventlog of the server where the analysis cube
resides.
Source MSSQLSERVEROLAPSERVER.
If there errors with something like "NT-Authority/Anonymous" your
security-settings on the report-server are not valid (especially the
settings in internet service manager)
If there aren't any errors it become more difficult...Do you run ptsfull on
reportserver either?
regards
Frank|||Thanks for your replies.
No errors unfortunately.
I ran ptsfull on the reportserver.
As I mentioned I can connect to the AS server via Visual Studio. As
soon as I deploy the report (using a stored connection or shared
connection) to report manager it won't run. I'm running MDAC 2.8 on the
report server.|||Jim wrote:
> As I mentioned I can connect to the AS server via Visual Studio.
Yes..i know. You can connect to the AS from YOUR workstation and your
reportserver can't as you wrote.
The problem should be between reportserver and AS-server but wich problem? I
dont know!
regards
frank|||Just to clarify...
Visual Studio - where I am developing the reports - is on the report
server.|||Jim,
I am having same problems and was wondering if you found solution of this
one. Thanks.
"Jim" wrote:
> Just to clarify...
> Visual Studio - where I am developing the reports - is on the report
> server.
>

Okay to install sp3a over sp3?

We intended to install sp3a but ended up installing sp3 by mistake. According to the web site, if you have installed sp3, "you don't need to install sp3a," but my question is would there be any harm in doing so? We know that an issue we're having is fix
ed in sp3a and we don't want to pull individual hotfixes.
>> We know that an issue we're having is fixed in sp3a and we don't want to
pull individual hotfixes.
Which issue is that? AFAIK, there were no changes to the database engine
itself between sp3 and sp3a. The changes were in the setup program, MDAC
and net libraries.
A
|||It's an issue with performance on a few ERP applications. We believe it is due to MDAC 2.7 and will be fixed with MDAC 2.71a, as other ERP customers have posted along those lines. Would it make more sense/be possible simply to upgrade MDAC instead of th
e SQL service pack? Or, as per my original question, will there be any problem with just upgrading to sp3a?
"Aaron [SQL Server MVP]" wrote:

> pull individual hotfixes.
> Which issue is that? AFAIK, there were no changes to the database engine
> itself between sp3 and sp3a. The changes were in the setup program, MDAC
> and net libraries.
> A
>
>
|||> Would it make more sense/be possible simply to upgrade MDAC instead of the
SQL service pack?
Yes!
http://www.aspfaq.com/
(Reverse address to reply.)
|||Okay. But... If we still experience the issue, is it okay to go from sp3
to sp3a?
"Aaron [SQL Server MVP]" wrote:

> SQL service pack?
> Yes!
> --
> http://www.aspfaq.com/
> (Reverse address to reply.)
>
>
|||You're more than welcome to, but I really don't think that's going to solve
any performance issues.
http://www.aspfaq.com/
(Reverse address to reply.)
"smaas@.newsgroups.nospam" <smaasnewsgroupsnospam@.discussions.microsoft.com >
wrote in message news:265021CB-C08C-4054-B0CE-B5E53FA58F1C@.microsoft.com...[vbcol=seagreen]
> Okay. But... If we still experience the issue, is it okay to go from
> sp3
> to sp3a?
> "Aaron [SQL Server MVP]" wrote:
sql

Okay to install sp3a over sp3?

We intended to install sp3a but ended up installing sp3 by mistake. Accordi
ng to the web site, if you have installed sp3, "you don't need to install sp
3a," but my question is would there be any harm in doing so? We know that a
n issue we're having is fix
ed in sp3a and we don't want to pull individual hotfixes.>> We know that an issue we're having is fixed in sp3a and we don't want to
pull individual hotfixes.
Which issue is that? AFAIK, there were no changes to the database engine
itself between sp3 and sp3a. The changes were in the setup program, MDAC
and net libraries.
A|||It's an issue with performance on a few ERP applications. We believe it is
due to MDAC 2.7 and will be fixed with MDAC 2.71a, as other ERP customers ha
ve posted along those lines. Would it make more sense/be possible simply to
upgrade MDAC instead of th
e SQL service pack? Or, as per my original question, will there be any prob
lem with just upgrading to sp3a?
"Aaron [SQL Server MVP]" wrote:

> pull individual hotfixes.
> Which issue is that? AFAIK, there were no changes to the database engine
> itself between sp3 and sp3a. The changes were in the setup program, MDAC
> and net libraries.
> A
>
>|||> Would it make more sense/be possible simply to upgrade MDAC instead of the
SQL service pack?
Yes!
http://www.aspfaq.com/
(Reverse address to reply.)|||Okay. But... If we still experience the issue, is it okay to go from sp
3
to sp3a?
"Aaron [SQL Server MVP]" wrote:

> SQL service pack?
> Yes!
> --
> http://www.aspfaq.com/
> (Reverse address to reply.)
>
>|||You're more than welcome to, but I really don't think that's going to solve
any performance issues.
http://www.aspfaq.com/
(Reverse address to reply.)
"smaas@.newsgroups.nospam" <smaasnewsgroupsnospam@.discussions.microsoft.com>
wrote in message news:265021CB-C08C-4054-B0CE-B5E53FA58F1C@.microsoft.com...[vbcol=seagreen]
> Okay. But... If we still experience the issue, is it okay to go from
> sp3
> to sp3a?
> "Aaron [SQL Server MVP]" wrote:
>

OK to delete sql2ksp3 folder after install?

I'm desperate for room on my "C" drive at the moment.
I've installed the SP3 for SQL Server 2000. Is it OK to remove the sql2ksp3
folder from my C drive now?
(and even though this is off topic, does anyone know how to increase the siz
e of the "C" partition on W2K AS?
I have 2 18GB drives in a RAID1 config. They are basic disks and are going
to stay that way. The system is
running in production mode, and between Dell, MSFT, and 2 partition tools I
cannot seem to find anyone who
can give me an authoritative 'yes' and how to do it. They all just want to
point to the other guys and have me
get the answer there.)
Thanks in advance for whatever help anyone can provide.
randyRandy,
Yes you should be able to remove that folder. As for increasing the
partition that's probably not an option. If it's a Raid 1 and you created
it initially with all the space in the primary partition you have no room to
grow. Can you be more specific as to where you need the room etc?
Andrew J. Kelly
SQL Server MVP
"randyvol" <randy.volters@.whaleyfoodservice.com> wrote in message
news:B5439337-990F-4542-8EC9-FF41701FDFFB@.microsoft.com...
> I'm desperate for room on my "C" drive at the moment.
> I've installed the SP3 for SQL Server 2000. Is it OK to remove the
sql2ksp3 folder from my C drive now?
> (and even though this is off topic, does anyone know how to increase the
size of the "C" partition on W2K AS?
> I have 2 18GB drives in a RAID1 config. They are basic disks and are
going to stay that way. The system is
> running in production mode, and between Dell, MSFT, and 2 partition tools
I cannot seem to find anyone who
> can give me an authoritative 'yes' and how to do it. They all just want
to point to the other guys and have me
> get the answer there.)
> Thanks in advance for whatever help anyone can provide.
> randy|||Hi Randy,
Thanks for using the newsgroup.
Yes, you could remove the sql2ksp3 folder because it is just a folder for
install files.
As for the question space of your Windows 2000 advanced server, we do have
related newsgroup and you could ask your question at:
http://communities2.microsoft.com/c...s/default.aspx?
dg=microsoft.public.win2000.advanced_server
OR
News:microsoft.public.win2000.advanced_server
Our related engineers there will help you with this issue.
Thanks.
Best regards
Baisong Wei
Microsoft Online Support
----
Get Secure! - www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only. Thanks.|||Thanks Andres and Baisong -
I'll check out the other group for my partition question.
Just to close it out here, I do have more room available. The two disks in
the RAID are both 18Giggers. So, I have
approx. 12 GB of unallocated space just beyond the initial 4GB "C" drive par
tition. Why not just create a "D" partition?
Well, we are holding out the possibility of rebuilding our cluster, and the
other server was just redone - however, this time
with a little more help from Dell using Server Asst. we got the full use of
the drive. So I'm trying to do this one the same.
At this point I'm pretty much resigned to having to blow this one away as so
on as we have the other server up.
Why do we need that big a "C" drive? Well besides having paid for the stora
ge and wanting to use it, believe it or
not there are still companies (like AVAYA) that build applications that MUST
be put in the C drive's programs folder.
ARRRRRRRGGGGGGGGGHHHHHHH. ;-)
Thanks again.|||Just FYI, it helps if you supply all the information to get correct
responses for your issue. You did not initially mention the drives only
had 4GB out of 18GB partitioned. That kind of information goes a long way.
Andrew J. Kelly
SQL Server MVP
"randyvol" <anonymous@.discussions.microsoft.com> wrote in message
news:5572D410-FF1B-43D9-BD01-EF04388DB162@.microsoft.com...
> Thanks Andres and Baisong -
> I'll check out the other group for my partition question.
> Just to close it out here, I do have more room available. The two disks
in the RAID are both 18Giggers. So, I have
> approx. 12 GB of unallocated space just beyond the initial 4GB "C" drive
partition. Why not just create a "D" partition?
> Well, we are holding out the possibility of rebuilding our cluster, and
the other server was just redone - however, this time
> with a little more help from Dell using Server Asst. we got the full use
of the drive. So I'm trying to do this one the same.
> At this point I'm pretty much resigned to having to blow this one away as
soon as we have the other server up.
> Why do we need that big a "C" drive? Well besides having paid for the
storage and wanting to use it, believe it or
> not there are still companies (like AVAYA) that build applications that
MUST be put in the C drive's programs folder.
> ARRRRRRRGGGGGGGGGHHHHHHH. ;-)
> Thanks again.|||Since you say that they are basic disks and not dynamic, Partition Magic
should be able to resize the 4 gig partitions.
David Walker

OK to delete sql2ksp3 folder after install?

I'm desperate for room on my "C" drive at the moment
I've installed the SP3 for SQL Server 2000. Is it OK to remove the sql2ksp3 folder from my C drive now
(and even though this is off topic, does anyone know how to increase the size of the "C" partition on W2K AS
I have 2 18GB drives in a RAID1 config. They are basic disks and are going to stay that way. The system i
running in production mode, and between Dell, MSFT, and 2 partition tools I cannot seem to find anyone wh
can give me an authoritative 'yes' and how to do it. They all just want to point to the other guys and have m
get the answer there.
Thanks in advance for whatever help anyone can provide
randyRandy,
Yes you should be able to remove that folder. As for increasing the
partition that's probably not an option. If it's a Raid 1 and you created
it initially with all the space in the primary partition you have no room to
grow. Can you be more specific as to where you need the room etc?
--
Andrew J. Kelly
SQL Server MVP
"randyvol" <randy.volters@.whaleyfoodservice.com> wrote in message
news:B5439337-990F-4542-8EC9-FF41701FDFFB@.microsoft.com...
> I'm desperate for room on my "C" drive at the moment.
> I've installed the SP3 for SQL Server 2000. Is it OK to remove the
sql2ksp3 folder from my C drive now?
> (and even though this is off topic, does anyone know how to increase the
size of the "C" partition on W2K AS?
> I have 2 18GB drives in a RAID1 config. They are basic disks and are
going to stay that way. The system is
> running in production mode, and between Dell, MSFT, and 2 partition tools
I cannot seem to find anyone who
> can give me an authoritative 'yes' and how to do it. They all just want
to point to the other guys and have me
> get the answer there.)
> Thanks in advance for whatever help anyone can provide.
> randy|||Hi Randy,
Thanks for using the newsgroup.
Yes, you could remove the sql2ksp3 folder because it is just a folder for
install files.
As for the question space of your windows 2000 advanced server, we do have
related newsgroup and you could ask your question at:
http://communities2.microsoft.com/communities/newsgroups/en-us/default.aspx?
dg=microsoft.public.win2000.advanced_server
OR
News:microsoft.public.win2000.advanced_server
Our related engineers there will help you with this issue.
Thanks.
Best regards
Baisong Wei
Microsoft Online Support
----
Get Secure! - www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only. Thanks.|||Thanks Andres and Baisong -
I'll check out the other group for my partition question
Just to close it out here, I do have more room available. The two disks in the RAID are both 18Giggers. So, I have
approx. 12 GB of unallocated space just beyond the initial 4GB "C" drive partition. Why not just create a "D" partition
Well, we are holding out the possibility of rebuilding our cluster, and the other server was just redone - however, this time
with a little more help from Dell using Server Asst. we got the full use of the drive. So I'm trying to do this one the same
At this point I'm pretty much resigned to having to blow this one away as soon as we have the other server up
Why do we need that big a "C" drive? Well besides having paid for the storage and wanting to use it, believe it o
not there are still companies (like AVAYA) that build applications that MUST be put in the C drive's programs folder
ARRRRRRRGGGGGGGGGHHHHHHH. ;-
Thanks again.|||Just FYI, it helps if you supply all the information to get correct
responses for your issue. You did not initially mention the drives only
had 4GB out of 18GB partitioned. That kind of information goes a long way.
--
Andrew J. Kelly
SQL Server MVP
"randyvol" <anonymous@.discussions.microsoft.com> wrote in message
news:5572D410-FF1B-43D9-BD01-EF04388DB162@.microsoft.com...
> Thanks Andres and Baisong -
> I'll check out the other group for my partition question.
> Just to close it out here, I do have more room available. The two disks
in the RAID are both 18Giggers. So, I have
> approx. 12 GB of unallocated space just beyond the initial 4GB "C" drive
partition. Why not just create a "D" partition?
> Well, we are holding out the possibility of rebuilding our cluster, and
the other server was just redone - however, this time
> with a little more help from Dell using Server Asst. we got the full use
of the drive. So I'm trying to do this one the same.
> At this point I'm pretty much resigned to having to blow this one away as
soon as we have the other server up.
> Why do we need that big a "C" drive? Well besides having paid for the
storage and wanting to use it, believe it or
> not there are still companies (like AVAYA) that build applications that
MUST be put in the C drive's programs folder.
> ARRRRRRRGGGGGGGGGHHHHHHH. ;-)
> Thanks again.|||Since you say that they are basic disks and not dynamic, Partition Magic
should be able to resize the 4 gig partitions.
David Walker

Ok Im making a webpage but

with SQL desktop engine installed where do I even begin working with it?Hi,

You can get started with the use of this Guided Tour of Web Matrix/MSDE:
http://asp.net/webmatrix/guidedtour/section2/newconn.aspx

Regardssql

Ok button not responding

I installed the developer version of reporting services
and I am having problems getting things entered in the
admin screens. When I go to the "New Data Source"
screen, the OK button does nothing. I have no script
errors on the page, and have other .net applications
running on the web server. I also have problems when
trying to update roles/security. I get an error when
click the ok button telling me that I need to select at
least 1 role even though I have them selected.I ran this command and all my .net pages stopped
responding. I had to uninstall .net and reinstall, and
then uninstall RS and reinstall and I still have the same
problem.
Any suggestions?
Thanks,
Dan J
>--Original Message--
>Dan
>I also encountered this problem.
>Sometimes during the install the IIS registration fails.
If you run the
>following at the command line this resolves the problem.
>C:\WINDOWS\Microsoft.NET\Framework\v1.1.4322
\aspnet_regiis.exe -i
>This should fix your problem
>Cheers
>
>"Dan J" wrote:
>> I installed the developer version of reporting
services
>> and I am having problems getting things entered in the
>> admin screens. When I go to the "New Data Source"
>> screen, the OK button does nothing. I have no script
>> errors on the page, and have other .net applications
>> running on the web server. I also have problems when
>> trying to update roles/security. I get an error when
>> click the ok button telling me that I need to select
at
>> least 1 role even though I have them selected.
>>
>.
>|||Dan,
I ran into something like this before. Reporting services installs to your
default website. When things get moved around (like I tried to do), your root
website can be missing the aspnet_client folder (usually found in
c:\inetpub\wwwroot). Just copy this folder over to the root of your website.
That folder contains some java scripts that contain some generic code which
is required for RS to execute the commands in the manager.
- Matt
"Dan J" wrote:
> I ran this command and all my .net pages stopped
> responding. I had to uninstall .net and reinstall, and
> then uninstall RS and reinstall and I still have the same
> problem.
> Any suggestions?
> Thanks,
> Dan J
> >--Original Message--
> >Dan
> >
> >I also encountered this problem.
> >
> >Sometimes during the install the IIS registration fails.
> If you run the
> >following at the command line this resolves the problem.
> >
> >C:\WINDOWS\Microsoft.NET\Framework\v1.1.4322
> \aspnet_regiis.exe -i
> >
> >This should fix your problem
> >
> >Cheers
> >
> >
> >"Dan J" wrote:
> >
> >> I installed the developer version of reporting
> services
> >> and I am having problems getting things entered in the
> >> admin screens. When I go to the "New Data Source"
> >> screen, the OK button does nothing. I have no script
> >> errors on the page, and have other .net applications
> >> running on the web server. I also have problems when
> >> trying to update roles/security. I get an error when
> >> click the ok button telling me that I need to select
> at
> >> least 1 role even though I have them selected.
> >>
> >>
> >.
> >
>|||I havent moved any websites on my server. I tried
copying the aspnet_client to the root of both of the RS
virtual directories (out of frustration) but still no
luck. I assume it is an asp problem, just not sure what
it needs. I havent done anything "wierd" with the server
or any of the installs.
Please help!!!
Dan
>--Original Message--
>Dan,
>I ran into something like this before. Reporting
services installs to your
>default website. When things get moved around (like I
tried to do), your root
>website can be missing the aspnet_client folder (usually
found in
>c:\inetpub\wwwroot). Just copy this folder over to the
root of your website.
>That folder contains some java scripts that contain some
generic code which
>is required for RS to execute the commands in the
manager.
>- Matt
>"Dan J" wrote:
>> I ran this command and all my .net pages stopped
>> responding. I had to uninstall .net and reinstall,
and
>> then uninstall RS and reinstall and I still have the
same
>> problem.
>> Any suggestions?
>> Thanks,
>> Dan J
>> >--Original Message--
>> >Dan
>> >
>> >I also encountered this problem.
>> >
>> >Sometimes during the install the IIS registration
fails.
>> If you run the
>> >following at the command line this resolves the
problem.
>> >
>> >C:\WINDOWS\Microsoft.NET\Framework\v1.1.4322
>> \aspnet_regiis.exe -i
>> >
>> >This should fix your problem
>> >
>> >Cheers
>> >
>> >
>> >"Dan J" wrote:
>> >
>> >> I installed the developer version of reporting
>> services
>> >> and I am having problems getting things entered in
the
>> >> admin screens. When I go to the "New Data Source"
>> >> screen, the OK button does nothing. I have no
script
>> >> errors on the page, and have other .net
applications
>> >> running on the web server. I also have problems
when
>> >> trying to update roles/security. I get an error
when
>> >> click the ok button telling me that I need to
select
>> at
>> >> least 1 role even though I have them selected.
>> >>
>> >>
>> >.
>> >
>.
>sql

Offline Cube Refresh

I am having problems with offline cubes. I am using AS2005 SP1 with all the 6 hotfixes installed. Everything with the cube access is fine and I can use excel to create a local .cub file. My problem comes when I try to refresh the cub file. My understanding is that using the excel spreadsheet which created the cube file hitting the refresh button while the cube is offline should refresh the cub file.

This is where my issues start. I get various messages all pointing to either an OLE DB driver crashing or the .cub file being reported as corrupt.

This doesn't happen every time once in a while with no noticable pattern has anyone else experienced the same problems with refreshing offline cubes?

If you willing to try... Please see if installing CTP of SP2 will solve your problem.

You can install it from http://www.microsoft.com/downloads/details.aspx?FamilyID=d2da6579-d49c-4b25-8f8a-79d14145500d&DisplayLang=en

If your problems still persist, contact product support and report your problems.

Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights.

|||Thanks for you help I have now tried installing CTP SP2 but I still have an error when updating that says that the local cub file is corrupt however it is fine to use and only gives the error at refresh. I have upgraded to XL2003 SP2|||

The last suggestion I might have for you:

Try rebuilding your local cube using CTP2.

Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights.

odbc, linux, and mssql

I'm not really experenced with databases or odbc but I have a need to connect to a mssql 2000 server for work. I have installed openlink odbc client on my Red Hat 7.3 box. The docs are very confusing and I'm really stumped on what I need here to connect. Any help here will keep me from pulling anymore of my hair out!

I hope I am providing enough information.

I'm using the the " OpenLink Generic ODBC Driver" and when I try to connect I get the following:

Failed
SQLDriverConnect on Client failed.
DB_Connect Error
[OpenLink][ODBC]RPC: Remote system error, SQLSTATE=08004
[OpenLink][ODBC]Connection rejected by data source, SQLSTATE=08004

my odbc.inc file looks like this:

; portfolio, please check out our web site at:
;
; http://www.openlinksw.com
;
; or contact us at:
;
; general.information@.openlinksw.com
;
; If you have any technical questions, please contact our support
; staff at:
;
; technical.support@.openlinksw.com
;
[ODBC Data Sources]
OpenLink = OpenLink Generic ODBC Driver
trackit = OpenLink Generic ODBC Driver

[Default]
Driver = /usr/openlink/lib/oplodbc.so.1

[OpenLink]
Driver = /usr/openlink/lib/oplodbc.so.1
ServerType = Oracle 8.1.x
Username =
Password =
Database =
Options =
FetchBufferSize = 99
ReadOnly = no
DeferLongFetch = no
Host = localhost
Protocol = TCP/IP
Description = Sample Oracle 8.1.x Connection

[trackit]
Description = Sample DSN
Options = trackit
Port = 5000
Host = trackit.premdor.com
UserName = JR
ServerType = SQLServer 2000
Protocol = TCP/IP
Driver = /usr/openlink/lib/oplodbc.so.1
Database = trackit
ReadOnly = Yes
NoLoginBox = No
FetchBufferSize = 99Hi,

I haven't tried using this "open link ODBC driver" yet but i guess you need to use the 'SQL Server ODBC driver for Linux".

hth!|||Your odbc.inc file does not include an entry for SQL server ....

odbc timeout

Hallo,
we have to installed a new nic on a w2k-server with sql-server2000. The
proberties TCP/IP are the same like on the old nic. SQL-Connection are okay,
but not the odbc-connection! During the configuratin of the odbc-connection
on the client we recieve an timeout error. 1.-3. or 4. try are succesful. But
than timeout. Nameresolution seems okay. We have no error massage or id. Only
timeout, connection failed!
What´s the reason for this? Only a new network-card!
Thanks for help!Hi Ralf
I am not sure why you need to create a new ODBC connection if this
previously existed? If this did not previously exist then you can not say for
certain it is the NIC that is causing this, therefore check to see if you can
ping the server and/or connect via osql, check that the firewall is not
blocking any port being used. Other things to look out for would be faulty
cabling, a problem with a hub or switch, out-of-date drivers.
John
"Ralf Temme" wrote:
> Hallo,
> we have to installed a new nic on a w2k-server with sql-server2000. The
> proberties TCP/IP are the same like on the old nic. SQL-Connection are okay,
> but not the odbc-connection! During the configuratin of the odbc-connection
> on the client we recieve an timeout error. 1.-3. or 4. try are succesful. But
> than timeout. Nameresolution seems okay. We have no error massage or id. Only
> timeout, connection failed!
> What´s the reason for this? Only a new network-card!
> Thanks for help!|||Hi John,
we create a new odbc connection only for testing. The error is the same like
the old one. We have applications as sql-clients, works normaly. So I´m sure
network connection is okay. One application needs the odbc connection. These
one failed with timeout error. Try to connect passed 3-4 times, than
timeout. After a few seconds I can start again: the same (passed 3-4 times,
than timeout). ODBCPING passed. Ping passed. Firewall is not activ. MDAC is
new. SP4 for SQL-Server is installed. Driver for the NIC (Intel) is the new.
It seems like an limit of odbc-requests, but I don´t know!
"John Bell" schrieb:
> Hi Ralf
> I am not sure why you need to create a new ODBC connection if this
> previously existed? If this did not previously exist then you can not say for
> certain it is the NIC that is causing this, therefore check to see if you can
> ping the server and/or connect via osql, check that the firewall is not
> blocking any port being used. Other things to look out for would be faulty
> cabling, a problem with a hub or switch, out-of-date drivers.
> John
> "Ralf Temme" wrote:
> > Hallo,
> > we have to installed a new nic on a w2k-server with sql-server2000. The
> > proberties TCP/IP are the same like on the old nic. SQL-Connection are okay,
> > but not the odbc-connection! During the configuratin of the odbc-connection
> > on the client we recieve an timeout error. 1.-3. or 4. try are succesful. But
> > than timeout. Nameresolution seems okay. We have no error massage or id. Only
> > timeout, connection failed!
> > What´s the reason for this? Only a new network-card!
> >
> > Thanks for help!|||Hi Ralf
If there is a limit on your connections then I would expect other systems to
experience problems as well! You could set ODBC tracing on, but I am not sure
that it will tell you anything extra. You may also want to try a different
NIC that you know is working. You may also want to try plugging the maching
into the same hub/switch as the server using different cables.
John
"Ralf Temme" wrote:
> Hi John,
> we create a new odbc connection only for testing. The error is the same like
> the old one. We have applications as sql-clients, works normaly. So I´m sure
> network connection is okay. One application needs the odbc connection. These
> one failed with timeout error. Try to connect passed 3-4 times, than
> timeout. After a few seconds I can start again: the same (passed 3-4 times,
> than timeout). ODBCPING passed. Ping passed. Firewall is not activ. MDAC is
> new. SP4 for SQL-Server is installed. Driver for the NIC (Intel) is the new.
> It seems like an limit of odbc-requests, but I don´t know!
> "John Bell" schrieb:
> > Hi Ralf
> >
> > I am not sure why you need to create a new ODBC connection if this
> > previously existed? If this did not previously exist then you can not say for
> > certain it is the NIC that is causing this, therefore check to see if you can
> > ping the server and/or connect via osql, check that the firewall is not
> > blocking any port being used. Other things to look out for would be faulty
> > cabling, a problem with a hub or switch, out-of-date drivers.
> >
> > John
> >
> > "Ralf Temme" wrote:
> >
> > > Hallo,
> > > we have to installed a new nic on a w2k-server with sql-server2000. The
> > > proberties TCP/IP are the same like on the old nic. SQL-Connection are okay,
> > > but not the odbc-connection! During the configuratin of the odbc-connection
> > > on the client we recieve an timeout error. 1.-3. or 4. try are succesful. But
> > > than timeout. Nameresolution seems okay. We have no error massage or id. Only
> > > timeout, connection failed!
> > > What´s the reason for this? Only a new network-card!
> > >
> > > Thanks for help!|||You say that one app is having problems. What is the MDAC for the app software?
Is the app using 'generic' odbc or is it writing to the API?
Also, during the set up of the ODBC driver in ODBC Administrator,t here is a
'test connection' option. When you do that test does it fail?
"John Bell" wrote:
> Hi Ralf
> If there is a limit on your connections then I would expect other systems to
> experience problems as well! You could set ODBC tracing on, but I am not sure
> that it will tell you anything extra. You may also want to try a different
> NIC that you know is working. You may also want to try plugging the maching
> into the same hub/switch as the server using different cables.
> John
>
> "Ralf Temme" wrote:
> > Hi John,
> > we create a new odbc connection only for testing. The error is the same like
> > the old one. We have applications as sql-clients, works normaly. So I´m sure
> > network connection is okay. One application needs the odbc connection. These
> > one failed with timeout error. Try to connect passed 3-4 times, than
> > timeout. After a few seconds I can start again: the same (passed 3-4 times,
> > than timeout). ODBCPING passed. Ping passed. Firewall is not activ. MDAC is
> > new. SP4 for SQL-Server is installed. Driver for the NIC (Intel) is the new.
> > It seems like an limit of odbc-requests, but I don´t know!
> >
> > "John Bell" schrieb:
> >
> > > Hi Ralf
> > >
> > > I am not sure why you need to create a new ODBC connection if this
> > > previously existed? If this did not previously exist then you can not say for
> > > certain it is the NIC that is causing this, therefore check to see if you can
> > > ping the server and/or connect via osql, check that the firewall is not
> > > blocking any port being used. Other things to look out for would be faulty
> > > cabling, a problem with a hub or switch, out-of-date drivers.
> > >
> > > John
> > >
> > > "Ralf Temme" wrote:
> > >
> > > > Hallo,
> > > > we have to installed a new nic on a w2k-server with sql-server2000. The
> > > > proberties TCP/IP are the same like on the old nic. SQL-Connection are okay,
> > > > but not the odbc-connection! During the configuratin of the odbc-connection
> > > > on the client we recieve an timeout error. 1.-3. or 4. try are succesful. But
> > > > than timeout. Nameresolution seems okay. We have no error massage or id. Only
> > > > timeout, connection failed!
> > > > What´s the reason for this? Only a new network-card!
> > > >
> > > > Thanks for help!

odbc sql server does not exist or access denied

I just installed SQL 2005 on a backup/test server. When I connected with ODBC to the new server I lost all of my ODBC connections, even to the working server (SQL 2000). I did a full repair on XP and got the ODBC to connect. Why would connecting to SQL 2005 cause my ODBC to crash ?. I tried using SQL Native as well, with no joy to either server. My ODBC isn't working again. The problem began as being intermittent, i.e. connected one minute, lost connection the next. Now it's permanently disconnected and I'm not even sure the reinstall was a solution.

Take a look at - http://support.microsoft.com/kb/328306

Hope this helps

|||Also got the error from another machine "does not allow remote connections" when connecting to ODBC.

The fix was to ensure that SQL Server Surface Area Configuration (via Start / etc) , Remote Connections set to "Using both TCP/IP and named pipes" (which was already default in my instance), and instead of using the name of the server in the ODBC drop-down list, use the servier IP, i.e. 10.0.0.XXX.|||

Is your issue resolved? If so, please mark your question anwserred.

If you are able to connect using IP address, but not with machine name, most likely you have a DNS problem on your network.

odbc sql native client

I've installed the SQL Server 2005 client utilities on a laptop that's used
for development. When I try to create an odbc connect to SQL Native Client
2005.90.1399.00 that specific driver doesn't appear in the list of drivers
available for selection. I've verified that it is in fact installed.
What's the problem, why doesn't it appear?
It's hard to say where exactly you are seeing this issue but
I would guess you are trying to create a DSN using the SQL
Native Client. Try updating your MDAC and verify that the
MDAC installation is correct on the laptop. You can check
the MDAC installation using component checker. You can
download component checker as well as the latest MDAC
versions from:
http://msdn2.microsoft.com/en-us/data/aa937730.aspx
-Sue
On Tue, 24 Jul 2007 09:12:01 -0700, gracie
<gracie@.discussions.microsoft.com> wrote:

>I've installed the SQL Server 2005 client utilities on a laptop that's used
>for development. When I try to create an odbc connect to SQL Native Client
>2005.90.1399.00 that specific driver doesn't appear in the list of drivers
>available for selection. I've verified that it is in fact installed.
>What's the problem, why doesn't it appear?
>
>
|||I have a similar issue with one desktop in our office. The SQL Native
Client doesn't appear in the ODBC list when opening up "User DSN".
Nothing seems to be different on this system from the 20 others that
it does appear on. MDAC is the latest one also. Have any other ideas
of what I might look for?
Sue Hoegemeier wrote:[vbcol=seagreen]
> It's hard to say where exactly you are seeing this issue but
> I would guess you are trying to create a DSN using the SQL
> Native Client. Try updating your MDAC and verify that the
> MDAC installation is correct on the laptop. You can check
> the MDAC installation using component checker. You can
> download component checker as well as the latest MDAC
> versions from:
> http://msdn2.microsoft.com/en-us/data/aa937730.aspx
> -Sue
> On Tue, 24 Jul 2007 09:12:01 -0700, gracie
> <gracie@.discussions.microsoft.com> wrote:

ODBC SQL 2005 and Named Instance - won't connect

We have two instances of SQL 2005 installed, with static TCP/IP ports, one
instance on one IP address, port 1433 and the other instance on a different
IP address, port 1433.
Try to create an ODBC System DSN using SQL Native Client and it won't
connect.
If we do the same thing but using a default instance of SQL 2005, ODBC
connects fine.
Any help anyone can give as to why ODBC won't connect to the SQL 2005 names
instances?
I've tried searching thru MSDN and TechNet and such but found nothing of any
help.
Michael MacGregor
Database Architect
Never mind, got it to work, having taken a sledgehammer to the server.
Disabled all IP addresses other than the one specified for the instance,
then restarted the whole box, and hey presto it finally worked.
Now we just have to get LDAP to recognise the named instances. Yeah I know,
old technology and all that stuff.
MTM
"Michael MacGregor" <nospam@.nospam.com> wrote in message
news:emWQtlFGGHA.3728@.tk2msftngp13.phx.gbl...
> We have two instances of SQL 2005 installed, with static TCP/IP ports, one
> instance on one IP address, port 1433 and the other instance on a
> different IP address, port 1433.
> Try to create an ODBC System DSN using SQL Native Client and it won't
> connect.
> If we do the same thing but using a default instance of SQL 2005, ODBC
> connects fine.
> Any help anyone can give as to why ODBC won't connect to the SQL 2005
> names instances?
> I've tried searching thru MSDN and TechNet and such but found nothing of
> any help.
> Michael MacGregor
> Database Architect
>

ODBC SQL 2005 and Named Instance - won't connect

We have two instances of SQL 2005 installed, with static TCP/IP ports, one
instance on one IP address, port 1433 and the other instance on a different
IP address, port 1433.
Try to create an ODBC System DSN using SQL Native Client and it won't
connect.
If we do the same thing but using a default instance of SQL 2005, ODBC
connects fine.
Any help anyone can give as to why ODBC won't connect to the SQL 2005 names
instances?
I've tried searching thru MSDN and technet and such but found nothing of any
help.
Michael MacGregor
Database ArchitectNever mind, got it to work, having taken a sledgehammer to the server.
Disabled all IP addresses other than the one specified for the instance,
then restarted the whole box, and hey presto it finally worked.
Now we just have to get LDAP to recognise the named instances. Yeah I know,
old technology and all that stuff.
MTM
"Michael MacGregor" <nospam@.nospam.com> wrote in message
news:emWQtlFGGHA.3728@.tk2msftngp13.phx.gbl...
> We have two instances of SQL 2005 installed, with static TCP/IP ports, one
> instance on one IP address, port 1433 and the other instance on a
> different IP address, port 1433.
> Try to create an ODBC System DSN using SQL Native Client and it won't
> connect.
> If we do the same thing but using a default instance of SQL 2005, ODBC
> connects fine.
> Any help anyone can give as to why ODBC won't connect to the SQL 2005
> names instances?
> I've tried searching thru MSDN and technet and such but found nothing of
> any help.
> Michael MacGregor
> Database Architect
>

ODBC Port

Hi, I have just installed a default instance of SQL server 2000 and can
connect ok with Query Analyser. I can connect ok with ODBC via a DSN if I
don't specify the port. However if I specify the port (which is 1433 I've
double checked) in the DSN or a JDBC connection it fails! Can somebody help
me?
Thanks
Adam Sankey
on the sql serve box :
check the programs->sqlserver2000>sql server network utilitity
click tcp and check properties
you should be able to see the port configured, if tcp is enabled
thanks
"Adam Sankey" <AdamSankey@.discussions.microsoft.com> wrote in message
news:5F774885-4F36-436F-9AF9-6AA5A4586426@.microsoft.com...
> Hi, I have just installed a default instance of SQL server 2000 and can
> connect ok with Query Analyser. I can connect ok with ODBC via a DSN if I
> don't specify the port. However if I specify the port (which is 1433 I've
> double checked) in the DSN or a JDBC connection it fails! Can somebody
> help
> me?
> Thanks
> Adam Sankey

ODBC Port

Hi, I have just installed a default instance of SQL server 2000 and can
connect ok with Query Analyser. I can connect ok with ODBC via a DSN if I
don't specify the port. However if I specify the port (which is 1433 I've
double checked) in the DSN or a JDBC connection it fails! Can somebody help
me?
Thanks
Adam Sankeyon the sql serve box :
check the programs->sqlserver2000>sql server network utilitity
click tcp and check properties
you should be able to see the port configured, if tcp is enabled
thanks
"Adam Sankey" <AdamSankey@.discussions.microsoft.com> wrote in message
news:5F774885-4F36-436F-9AF9-6AA5A4586426@.microsoft.com...
> Hi, I have just installed a default instance of SQL server 2000 and can
> connect ok with Query Analyser. I can connect ok with ODBC via a DSN if I
> don't specify the port. However if I specify the port (which is 1433 I've
> double checked) in the DSN or a JDBC connection it fails! Can somebody
> help
> me?
> Thanks
> Adam Sankey

odbc link failed

Hello,
I have a windows SBS2003 server with msde installed.
I created some odbc datalinks in microsoft acces to one of my sql databases.
The links are ok end i can access the odbc links in microsoft acces on my
server.
Problem :
When i open the access database on my workstation and try to connect to one
of the odbc links, i getr the followin error.
ODBC-connection to 'SQL Server<servername> failed
Microsoft Access can't open the table in Datasheet View
Any suggestions?
Thank you,
Hi
Your MSDE instance was probably installed without the network protocols
See http://support.microsoft.com/?kbid=814130 on how to run svrnetcn.exe.
John
"Ponch" wrote:

> Hello,
> I have a windows SBS2003 server with msde installed.
> I created some odbc datalinks in microsoft acces to one of my sql databases.
> The links are ok end i can access the odbc links in microsoft acces on my
> server.
> Problem :
> When i open the access database on my workstation and try to connect to one
> of the odbc links, i getr the followin error.
> ODBC-connection to 'SQL Server<servername> failed
> Microsoft Access can't open the table in Datasheet View
> Any suggestions?
> Thank you,
>
>
|||Hello, Thanks for the tip, it solved my problem.
"John Bell" <jbellnewsposts@.hotmail.com> wrote in message
news:4FD2882D-37A0-4EE7-B7A2-1C8BDEF50908@.microsoft.com...[vbcol=seagreen]
> Hi
> Your MSDE instance was probably installed without the network protocols
> See http://support.microsoft.com/?kbid=814130 on how to run svrnetcn.exe.
> John
> "Ponch" wrote:

odbc link failed

Hello,
I have a windows SBS2003 server with msde installed.
I created some odbc datalinks in microsoft acces to one of my sql databases.
The links are ok end i can access the odbc links in microsoft acces on my
server.
Problem :
When i open the access database on my workstation and try to connect to one
of the odbc links, i getr the followin error.
ODBC-connection to 'SQL Server<servername> failed
Microsoft Access can't open the table in Datasheet View
Any suggestions?
Thank you,Hi
Your MSDE instance was probably installed without the network protocols
See http://support.microsoft.com/?kbid=814130 on how to run svrnetcn.exe.
John
"Ponch" wrote:

> Hello,
> I have a windows SBS2003 server with msde installed.
> I created some odbc datalinks in microsoft acces to one of my sql database
s.
> The links are ok end i can access the odbc links in microsoft acces on my
> server.
> Problem :
> When i open the access database on my workstation and try to connect to on
e
> of the odbc links, i getr the followin error.
> ODBC-connection to 'SQL Server<servername> failed
> Microsoft Access can't open the table in Datasheet View
> Any suggestions?
> Thank you,
>
>|||Hello, Thanks for the tip, it solved my problem.
"John Bell" <jbellnewsposts@.hotmail.com> wrote in message
news:4FD2882D-37A0-4EE7-B7A2-1C8BDEF50908@.microsoft.com...[vbcol=seagreen]
> Hi
> Your MSDE instance was probably installed without the network protocols
> See http://support.microsoft.com/?kbid=814130 on how to run svrnetcn.exe.
> John
> "Ponch" wrote:
>

odbc link failed

Hello,
I have a windows SBS2003 server with msde installed.
I created some odbc datalinks in microsoft acces to one of my sql databases.
The links are ok end i can access the odbc links in microsoft acces on my
server.
Problem :
When i open the access database on my workstation and try to connect to one
of the odbc links, i getr the followin error.
ODBC-connection to 'SQL Server<servername> failed
Microsoft Access can't open the table in Datasheet View
Any suggestions?
Thank you,Hi
Your MSDE instance was probably installed without the network protocols
See http://support.microsoft.com/?kbid=814130 on how to run svrnetcn.exe.
John
"Ponch" wrote:
> Hello,
> I have a windows SBS2003 server with msde installed.
> I created some odbc datalinks in microsoft acces to one of my sql databases.
> The links are ok end i can access the odbc links in microsoft acces on my
> server.
> Problem :
> When i open the access database on my workstation and try to connect to one
> of the odbc links, i getr the followin error.
> ODBC-connection to 'SQL Server<servername> failed
> Microsoft Access can't open the table in Datasheet View
> Any suggestions?
> Thank you,
>
>|||Hello, Thanks for the tip, it solved my problem.
"John Bell" <jbellnewsposts@.hotmail.com> wrote in message
news:4FD2882D-37A0-4EE7-B7A2-1C8BDEF50908@.microsoft.com...
> Hi
> Your MSDE instance was probably installed without the network protocols
> See http://support.microsoft.com/?kbid=814130 on how to run svrnetcn.exe.
> John
> "Ponch" wrote:
>> Hello,
>> I have a windows SBS2003 server with msde installed.
>> I created some odbc datalinks in microsoft acces to one of my sql
>> databases.
>> The links are ok end i can access the odbc links in microsoft acces on my
>> server.
>> Problem :
>> When i open the access database on my workstation and try to connect to
>> one
>> of the odbc links, i getr the followin error.
>> ODBC-connection to 'SQL Server<servername> failed
>> Microsoft Access can't open the table in Datasheet View
>> Any suggestions?
>> Thank you,
>>
>>