OLAP Connection Error

Hi,
Background :
Am trying to connect to the OLAP Cubes from a Web Service.
The Web Service resides on my local machine, while the Analysis Server resid
es on a different domain.
Users have been created on the Analysis Server, and roles have been defined
for the cube am trying to access.
The processModel is configured with proper user id.
Problem :
When I do that I get an error "Undefined Error".
To my knowledge I have all the access to the Analysis Server, but still am n
ot able to connect to cube.
Could someone please help me resolve this as its very crucial and is hamperi
ng our to a great extent.
Thanks,
SrinivasThe user is created on the Analysis Server, and a role too has been defined
for the user, giving access to the cube.
For example :
Let us suppose my network user id is "ABC". Then a user called "ABC" is crea
ted on the Analysis server, and has been assigned a role.
Srinivas|||microsoft.public.sqlserver.olap is probably a better newsgroup for this, but
my initial guess is that your problem revolves around the statement below
"different domain". AS only supports Windows authentication in direct
client-server mode. You have a few options. First, you could use the old NT
matching-username password trick. If you have *local accounts* on both
systems with the same username password, then you will be able to connect
even if the two machines are in untrusted domains. You will have
administrative issues keeping the two passwords in-sync, but the connection
will go through OK. Second, if you are running on Enterprise Edition, you
can use http access. This will require you to run IIS on the AS server (see
BOL on how to configure it and look at the white paper
http://msdn.microsoft.com/library/e...ql_datapump.asp for
more technical details.
Hope that helps.
Dave Wickert [MS]
dwickert@.online.microsoft.com
Program Manager
BI Practices Team
SQL BI Product Unit (Analysis Services)
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"Srinivas" <svinjamoor@.worldbank.org> wrote in message
news:19E0A695-14C5-4E9C-8BB8-FB7C26A310BC@.microsoft.com...

quote:

---

> Hi,
> Background :
> Am trying to connect to the OLAP Cubes from a Web Service.
> The Web Service resides on my local machine, while the Analysis Server

---

resides on a different domain.

quote:

---

> Users have been created on the Analysis Server, and roles have been

---

defined for the cube am trying to access.

quote:

---

> The processModel is configured with proper user id.
> Problem :
> When I do that I get an error "Undefined Error".
> To my knowledge I have all the access to the Analysis Server, but still am

---

not able to connect to cube.

quote:

---

> Could someone please help me resolve this as its very crucial and is

---

hampering our to a great extent.

quote:

---

> Thanks,
> Srinivas

---

ok to install sql2005/2000,vs2005/2003 on same machine

Hi just wondering if anyone has run into any problems installing and running
vs2005 and sql 2005 prof with a machine that already has sql2000 and vs2003,
or if it will effect sql 2000 or vs2003 in any way, thanks.
--
Paul G
Software engineer.I run this configuration. It does work. I installed a certificate on my web
server and suddenly I couldn't connect to SQL 2000 anymore. Other than that
it was working well.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Paul" <Paul@.discussions.microsoft.com> wrote in message
news:A323C6DA-764B-4298-9CBB-3E751F55DD0F@.microsoft.com...
> Hi just wondering if anyone has run into any problems installing and
> running
> vs2005 and sql 2005 prof with a machine that already has sql2000 and
> vs2003,
> or if it will effect sql 2000 or vs2003 in any way, thanks.
> --
> Paul G
> Software engineer.|||thanks for the response. I think I am having problems with the installation
.
For components to install it lists SQL Server Database Services, Analysis
Services, Reporting Services, Integration Services, Workstations Components,
Books online and development tools. It seems to install without error but I
do not see SQL server management studio from the programs list.
--
Paul G
Software engineer.
"Hilary Cotter" wrote:

> I run this configuration. It does work. I installed a certificate on my we
b
> server and suddenly I couldn't connect to SQL 2000 anymore. Other than tha
t
> it was working well.
> --
> Hilary Cotter
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
> Looking for a FAQ on Indexing Services/SQL FTS
> http://www.indexserverfaq.com
> "Paul" <Paul@.discussions.microsoft.com> wrote in message
> news:A323C6DA-764B-4298-9CBB-3E751F55DD0F@.microsoft.com...
>
>|||Chances are this is because you installed SQL Express with Visual Studio
before you installed SQL Server 2005. This leaves you with the SQL Express
client utilities which don't include Management Studio. Try uninstalling
the client utilities and then reinstalling them from the full SQL Server
2005 release.
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm
"Paul" <Paul@.discussions.microsoft.com> wrote in message
news:CB9FDA44-C306-4A28-B054-D3CA726A5936@.microsoft.com...[vbcol=seagreen]
> thanks for the response. I think I am having problems with the
> installation.
> For components to install it lists SQL Server Database Services, Analysis
> Services, Reporting Services, Integration Services, Workstations
> Components,
> Books online and development tools. It seems to install without error but
> I
> do not see SQL server management studio from the programs list.
> --
> Paul G
> Software engineer.
>
> "Hilary Cotter" wrote:
>|||ok thanks that seemed to work!
--
Paul G
Software engineer.
"Roger Wolter[MSFT]" wrote:

> Chances are this is because you installed SQL Express with Visual Studio
> before you installed SQL Server 2005. This leaves you with the SQL Expres
s
> client utilities which don't include Management Studio. Try uninstalling
> the client utilities and then reinstalling them from the full SQL Server
> 2005 release.
> --
> This posting is provided "AS IS" with no warranties, and confers no rights
.
> Use of included script samples are subject to the terms specified at
> http://www.microsoft.com/info/cpyright.htm
> "Paul" <Paul@.discussions.microsoft.com> wrote in message
> news:CB9FDA44-C306-4A28-B054-D3CA726A5936@.microsoft.com...
>
>sql

ok to install sql2005/2000,vs2005/2003 on same machine

Hi just wondering if anyone has run into any problems installing and running
vs2005 and sql 2005 prof with a machine that already has sql2000 and vs2003,
or if it will effect sql 2000 or vs2003 in any way, thanks.
--
Paul G
Software engineer.I run this configuration. It does work. I installed a certificate on my web
server and suddenly I couldn't connect to SQL 2000 anymore. Other than that
it was working well.
--
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Paul" <Paul@.discussions.microsoft.com> wrote in message
news:A323C6DA-764B-4298-9CBB-3E751F55DD0F@.microsoft.com...
> Hi just wondering if anyone has run into any problems installing and
> running
> vs2005 and sql 2005 prof with a machine that already has sql2000 and
> vs2003,
> or if it will effect sql 2000 or vs2003 in any way, thanks.
> --
> Paul G
> Software engineer.|||thanks for the response. I think I am having problems with the installation.
For components to install it lists SQL Server Database Services, Analysis
Services, Reporting Services, Integration Services, Workstations Components,
Books online and development tools. It seems to install without error but I
do not see SQL server management studio from the programs list.
--
Paul G
Software engineer.
"Hilary Cotter" wrote:
> I run this configuration. It does work. I installed a certificate on my web
> server and suddenly I couldn't connect to SQL 2000 anymore. Other than that
> it was working well.
> --
> Hilary Cotter
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
> Looking for a FAQ on Indexing Services/SQL FTS
> http://www.indexserverfaq.com
> "Paul" <Paul@.discussions.microsoft.com> wrote in message
> news:A323C6DA-764B-4298-9CBB-3E751F55DD0F@.microsoft.com...
> > Hi just wondering if anyone has run into any problems installing and
> > running
> > vs2005 and sql 2005 prof with a machine that already has sql2000 and
> > vs2003,
> > or if it will effect sql 2000 or vs2003 in any way, thanks.
> > --
> > Paul G
> > Software engineer.
>
>|||Chances are this is because you installed SQL Express with Visual Studio
before you installed SQL Server 2005. This leaves you with the SQL Express
client utilities which don't include Management Studio. Try uninstalling
the client utilities and then reinstalling them from the full SQL Server
2005 release.
--
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm
"Paul" <Paul@.discussions.microsoft.com> wrote in message
news:CB9FDA44-C306-4A28-B054-D3CA726A5936@.microsoft.com...
> thanks for the response. I think I am having problems with the
> installation.
> For components to install it lists SQL Server Database Services, Analysis
> Services, Reporting Services, Integration Services, Workstations
> Components,
> Books online and development tools. It seems to install without error but
> I
> do not see SQL server management studio from the programs list.
> --
> Paul G
> Software engineer.
>
> "Hilary Cotter" wrote:
>> I run this configuration. It does work. I installed a certificate on my
>> web
>> server and suddenly I couldn't connect to SQL 2000 anymore. Other than
>> that
>> it was working well.
>> --
>> Hilary Cotter
>> Looking for a SQL Server replication book?
>> http://www.nwsu.com/0974973602.html
>> Looking for a FAQ on Indexing Services/SQL FTS
>> http://www.indexserverfaq.com
>> "Paul" <Paul@.discussions.microsoft.com> wrote in message
>> news:A323C6DA-764B-4298-9CBB-3E751F55DD0F@.microsoft.com...
>> > Hi just wondering if anyone has run into any problems installing and
>> > running
>> > vs2005 and sql 2005 prof with a machine that already has sql2000 and
>> > vs2003,
>> > or if it will effect sql 2000 or vs2003 in any way, thanks.
>> > --
>> > Paul G
>> > Software engineer.
>>|||ok thanks that seemed to work!
--
Paul G
Software engineer.
"Roger Wolter[MSFT]" wrote:
> Chances are this is because you installed SQL Express with Visual Studio
> before you installed SQL Server 2005. This leaves you with the SQL Express
> client utilities which don't include Management Studio. Try uninstalling
> the client utilities and then reinstalling them from the full SQL Server
> 2005 release.
> --
> This posting is provided "AS IS" with no warranties, and confers no rights.
> Use of included script samples are subject to the terms specified at
> http://www.microsoft.com/info/cpyright.htm
> "Paul" <Paul@.discussions.microsoft.com> wrote in message
> news:CB9FDA44-C306-4A28-B054-D3CA726A5936@.microsoft.com...
> > thanks for the response. I think I am having problems with the
> > installation.
> > For components to install it lists SQL Server Database Services, Analysis
> > Services, Reporting Services, Integration Services, Workstations
> > Components,
> > Books online and development tools. It seems to install without error but
> > I
> > do not see SQL server management studio from the programs list.
> > --
> > Paul G
> > Software engineer.
> >
> >
> > "Hilary Cotter" wrote:
> >
> >> I run this configuration. It does work. I installed a certificate on my
> >> web
> >> server and suddenly I couldn't connect to SQL 2000 anymore. Other than
> >> that
> >> it was working well.
> >>
> >> --
> >> Hilary Cotter
> >> Looking for a SQL Server replication book?
> >> http://www.nwsu.com/0974973602.html
> >>
> >> Looking for a FAQ on Indexing Services/SQL FTS
> >> http://www.indexserverfaq.com
> >>
> >> "Paul" <Paul@.discussions.microsoft.com> wrote in message
> >> news:A323C6DA-764B-4298-9CBB-3E751F55DD0F@.microsoft.com...
> >> > Hi just wondering if anyone has run into any problems installing and
> >> > running
> >> > vs2005 and sql 2005 prof with a machine that already has sql2000 and
> >> > vs2003,
> >> > or if it will effect sql 2000 or vs2003 in any way, thanks.
> >> > --
> >> > Paul G
> >> > Software engineer.
> >>
> >>
> >>
>
>

Offsite Database Mirroring for standby machine

Hi all,

we want to create a offsite redundant server which can be a standby machine if something happens to our primary machine, any input how to do this over internet? what type of bandwidth we need, and for security ssl or vpn? or anything i missed thats important to consider. Plans are to use sql server 2005. Thanks all

Well, there are a lot of options here:

1. "What type of bandwidth do we need?" Depends entirely on your load, specifically how much you log. So, find out how much you log at your peak and that should be the minimum bandwidth. Currently, I have an interstate deployment running in asynch mode, and they are doing well. There is not a backlog until they start to rebuild their indexes, at which point there can be a buildup of several GBytes. The solution to that is to rebuild the indexes less often.

2. Database mirroring has encryption built in.

3. "Anything else?" If you are trying to get automatic failover and running on the internet, then I would be worried that a surious or glitchy network would cause unwanted automatic failovers.

Thanks,

Mark

Odd connection problem

I (running SQL 7 client only) cannot connect to the
server via my machine, but CAN connect (after installing
client) to the server from ANY other machine on the LAN.
My SysAdmin and I have been workin on this for days but
have come up empty, any ideas?
Could it be some other software I'm running?
Specs:
Sql7 client attempting to connect to server fails via
client tools and isql command line...
client = XP Pro connected via LAN to server. Can ping
server... have re-installed client software multiple
times.
rcause,
What error message do you get when connecting from osql.exe? Do you have an
aliases set up in your client configuration utility?
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
"rcause" <rcausey@.med.unc.edu> wrote in message
news:fdb901c43ead$883f7160$a101280a@.phx.gbl...
> I (running SQL 7 client only) cannot connect to the
> server via my machine, but CAN connect (after installing
> client) to the server from ANY other machine on the LAN.
> My SysAdmin and I have been workin on this for days but
> have come up empty, any ideas?
> Could it be some other software I'm running?
> Specs:
> Sql7 client attempting to connect to server fails via
> client tools and isql command line...
> client = XP Pro connected via LAN to server. Can ping
> server... have re-installed client software multiple
> times.
|||Mark,
[Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server
does not exist or
access denied.
[Microsoft][ODBC SQL Server Driver][DBNETLIB]
ConnectionOpen (Connect()).
That's the osql error message.
Do not have alias set up?
Thanks
>--Original Message--
>rcause,
>What error message do you get when connecting from
osql.exe? Do you have an[vbcol=seagreen]
>aliases set up in your client configuration utility?
>--
>Mark Allison, SQL Server MVP
>http://www.markallison.co.uk
>Looking for a SQL Server replication book?
>http://www.nwsu.com/0974973602.html
>
>"rcause" <rcausey@.med.unc.edu> wrote in message
>news:fdb901c43ead$883f7160$a101280a@.phx.gbl...
installing[vbcol=seagreen]
LAN.
>
>.
>
|||Use SQL Server Authentication... Open up ODBC Control Panel, set up a DSN
and name it with your server's name. select sql server authentication. HTH.
=)
Ricky Artigas
"rcause" <rcausey@.med.unc.edu> wrote in message
news:fdb901c43ead$883f7160$a101280a@.phx.gbl...
> I (running SQL 7 client only) cannot connect to the
> server via my machine, but CAN connect (after installing
> client) to the server from ANY other machine on the LAN.
> My SysAdmin and I have been workin on this for days but
> have come up empty, any ideas?
> Could it be some other software I'm running?
> Specs:
> Sql7 client attempting to connect to server fails via
> client tools and isql command line...
> client = XP Pro connected via LAN to server. Can ping
> server... have re-installed client software multiple
> times.
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.688 / Virus Database: 449 - Release Date: 5/18/2004
|||Hi ricky
just goto the services in your client mechine.and find out the sql srevre services.
then if they are stop then start.
if they are start then go to the properits.
and go to the logon and check the authentication to local system
biswajit das
-- Ricky Artigas wrote: --
Use SQL Server Authentication... Open up ODBC Control Panel, set up a DSN
and name it with your server's name. select sql server authentication. HTH.
=)
Ricky Artigas
"rcause" <rcausey@.med.unc.edu> wrote in message
news:fdb901c43ead$883f7160$a101280a@.phx.gbl...
> I (running SQL 7 client only) cannot connect to the
> server via my machine, but CAN connect (after installing
> client) to the server from ANY other machine on the LAN.
> My SysAdmin and I have been workin on this for days but
> have come up empty, any ideas?
> Sql7 client attempting to connect to server fails via
> client tools and isql command line...
> server... have re-installed client software multiple
> times.
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.688 / Virus Database: 449 - Release Date: 5/18/2004

Odd connection problem

I (running SQL 7 client only) cannot connect to the
server via my machine, but CAN connect (after installing
client) to the server from ANY other machine on the LAN.
My SysAdmin and I have been workin on this for days but
have come up empty, any ideas?
Could it be some other software I'm running?
Specs:
Sql7 client attempting to connect to server fails via
client tools and isql command line...
client = XP Pro connected via LAN to server. Can ping
server... have re-installed client software multiple
times.rcause,
What error message do you get when connecting from osql.exe? Do you have an
aliases set up in your client configuration utility?
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
"rcause" <rcausey@.med.unc.edu> wrote in message
news:fdb901c43ead$883f7160$a101280a@.phx.gbl...
> I (running SQL 7 client only) cannot connect to the
> server via my machine, but CAN connect (after installing
> client) to the server from ANY other machine on the LAN.
> My SysAdmin and I have been workin on this for days but
> have come up empty, any ideas?
> Could it be some other software I'm running?
> Specs:
> Sql7 client attempting to connect to server fails via
> client tools and isql command line...
> client = XP Pro connected via LAN to server. Can ping
> server... have re-installed client software multiple
> times.|||Mark,
[Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server
does not exist or
access denied.
[Microsoft][ODBC SQL Server Driver][DBNETLIB]
ConnectionOpen (Connect()).
That's the osql error message.
Do not have alias set up?
Thanks
>--Original Message--
>rcause,
>What error message do you get when connecting from
osql.exe? Do you have an
>aliases set up in your client configuration utility?
>--
>Mark Allison, SQL Server MVP
>http://www.markallison.co.uk
>Looking for a SQL Server replication book?
>http://www.nwsu.com/0974973602.html
>
>"rcause" <rcausey@.med.unc.edu> wrote in message
>news:fdb901c43ead$883f7160$a101280a@.phx.gbl...
installing[vbcol=seagreen]
LAN.[vbcol=seagreen]
>
>.
>|||Use SQL Server Authentication... Open up ODBC Control Panel, set up a DSN
and name it with your server's name. select sql server authentication. HTH.
=)
Ricky Artigas
"rcause" <rcausey@.med.unc.edu> wrote in message
news:fdb901c43ead$883f7160$a101280a@.phx.gbl...
> I (running SQL 7 client only) cannot connect to the
> server via my machine, but CAN connect (after installing
> client) to the server from ANY other machine on the LAN.
> My SysAdmin and I have been workin on this for days but
> have come up empty, any ideas?
> Could it be some other software I'm running?
> Specs:
> Sql7 client attempting to connect to server fails via
> client tools and isql command line...
> client = XP Pro connected via LAN to server. Can ping
> server... have re-installed client software multiple
> times.
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.688 / Virus Database: 449 - Release Date: 5/18/2004|||Hi ricky
just goto the services in your client mechine.and find out the sql srevre se
rvices.
then if they are stop then start.
if they are start then go to the properits.
and go to the logon and check the authentication to local system
biswajit das
-- Ricky Artigas wrote: --
Use SQL Server Authentication... Open up ODBC Control Panel, set up a DSN
and name it with your server's name. select sql server authentication. HTH.
=)
Ricky Artigas
"rcause" <rcausey@.med.unc.edu> wrote in message
news:fdb901c43ead$883f7160$a101280a@.phx.gbl...
> I (running SQL 7 client only) cannot connect to the
> server via my machine, but CAN connect (after installing
> client) to the server from ANY other machine on the LAN.
> My SysAdmin and I have been workin on this for days but
> have come up empty, any ideas?
> Sql7 client attempting to connect to server fails via
> client tools and isql command line...
> server... have re-installed client software multiple
> times.
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.688 / Virus Database: 449 - Release Date: 5/18/2004

ODBC SQLINTEGER & (BADMEM) - Why?

Hi,
I have the ODBC tracing enabled on my development machine using the
"default" tracing DLL.
I thought it was just our applications causing this, but I'm also seeing
this when using isqlw (SQL Query Analyzer).
Is it an issue? The app. seems to have no issues. I know it is indicating
that the memory location is invalid. Why?
I would like to know what the cause is, what other tools are available to
track this down, in the event it is an issue. It doesn't seem like a
"normal" occurrence.
From our app:
12345678.A24 N 95c-cdcEXIT SQLSetEnvAttr with return code 0 (SQL_SUCCESS)
SQLHENV 008F1540
SQLINTEGER 200 <SQL_ATTR_ODBC_VERSION>
SQLPOINTER 0x00000003 (BADMEM)
SQLINTEGER 0
12345678.A24 N 95c-cdcEXIT SQLSetConnectAttr with return code 0
(SQL_SUCCESS)
SQLHDBC 008F15E8
SQLINTEGER 103 <SQL_ATTR_LOGIN_TIMEOUT>
SQLPOINTER 0x0000003C (BADMEM)
SQLINTEGER 0
From ISQLW:
isqlw edc-9c4EXIT SQLSetEnvAttr with return code 0 (SQL_SUCCESS)
SQLHENV 008D1540
SQLINTEGER 200 <SQL_ATTR_ODBC_VERSION>
SQLPOINTER 0x00000003 (BADMEM)
SQLINTEGER -5
isqlw edc-9c4EXIT SQLSetConnectAttrW with return code 0
(SQL_SUCCESS)
SQLHDBC 008D15E8
SQLINTEGER 103 <SQL_ATTR_LOGIN_TIMEOUT>
SQLPOINTER 0x0000000F (BADMEM)
SQLINTEGER -5
isqlw edc-9c4EXIT SQLSetStmtAttrW with return code 0
(SQL_SUCCESS)
SQLHSTMT 008D19B8
SQLINTEGER 3 <SQL_ATTR_MAX_LENGTH>
SQLPOINTER 0x0000FC00 (BADMEM)
SQLINTEGER -5
Thanks. Jeff
Hello,
This behavior seems to be normal because some parameters are not used when
calling this method. Also, the SQL_SUCCESS indicate these functions work
fine. For example:
SQLSetConnectAttr Function
http://msdn.microsoft.com/library/de...us/odbc/htm/od
bcsqlsetconnectattr.asp
ValuePtr
[Input]
Pointer to the value to be associated with Attribute. Depending on the
value of Attribute, ValuePtr will be a 32-bit unsigned integer value or
will point to a null-terminated character string. Note that if the
Attribute argument is a driver-specific value, the value in ValuePtr may be
a signed integer.
Sophie Guo
Microsoft Online Partner Support
Get Secure! - www.microsoft.com/security
================================================== ===
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
================================================== ===
This posting is provided "AS IS" with no warranties, and confers no rights.

ODBC SQLINTEGER & (BADMEM) - Why?

Hi,
I have the ODBC tracing enabled on my development machine using the
"default" tracing DLL.
I thought it was just our applications causing this, but I'm also seeing
this when using isqlw (SQL Query Analyzer).
Is it an issue? The app. seems to have no issues. I know it is indicating
that the memory location is invalid. Why?
I would like to know what the cause is, what other tools are available to
track this down, in the event it is an issue. It doesn't seem like a
"normal" occurrence.
From our app:
12345678.A24 N 95c-cdc EXIT SQLSetEnvAttr with return code 0 (SQL_SUCCESS
)
SQLHENV 008F1540
SQLINTEGER 200 <SQL_ATTR_ODBC_VERSION>
SQLPOINTER 0x00000003 (BADMEM)
SQLINTEGER 0
12345678.A24 N 95c-cdc EXIT SQLSetConnectAttr with return code 0
(SQL_SUCCESS)
SQLHDBC 008F15E8
SQLINTEGER 103 <SQL_ATTR_LOGIN_TIMEOUT>
SQLPOINTER 0x0000003C (BADMEM)
SQLINTEGER 0
From ISQLW:
isqlw edc-9c4 EXIT SQLSetEnvAttr with return code 0 (SQL_SUCCESS
)
SQLHENV 008D1540
SQLINTEGER 200 <SQL_ATTR_ODBC_VERSION>
SQLPOINTER 0x00000003 (BADMEM)
SQLINTEGER -5
isqlw edc-9c4 EXIT SQLSetConnectAttrW with return code 0
(SQL_SUCCESS)
SQLHDBC 008D15E8
SQLINTEGER 103 <SQL_ATTR_LOGIN_TIMEOUT>
SQLPOINTER 0x0000000F (BADMEM)
SQLINTEGER -5
isqlw edc-9c4 EXIT SQLSetStmtAttrW with return code 0
(SQL_SUCCESS)
SQLHSTMT 008D19B8
SQLINTEGER 3 <SQL_ATTR_MAX_LENGTH>
SQLPOINTER 0x0000FC00 (BADMEM)
SQLINTEGER -5
Thanks. JeffHello,
This behavior seems to be normal because some parameters are not used when
calling this method. Also, the SQL_SUCCESS indicate these functions work
fine. For example:
SQLSetConnectAttr Function
http://msdn.microsoft.com/library/d...-us/odbc/htm/od
bcsqlsetconnectattr.asp
ValuePtr
[Input]
Pointer to the value to be associated with Attribute. Depending on the
value of Attribute, ValuePtr will be a 32-bit unsigned integer value or
will point to a null-terminated character string. Note that if the
Attribute argument is a driver-specific value, the value in ValuePtr may be
a signed integer.
Sophie Guo
Microsoft Online Partner Support
Get Secure! - www.microsoft.com/security
========================================
=============
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
========================================
=============
This posting is provided "AS IS" with no warranties, and confers no rights.

ODBC SQL Server database reconnect questions

I have an ODBC 3.0 Application on Windows NT Server maintaining a
connection to a SQL Server 2000 database on the same machine. When an
error occurs, I'd like to be able to determine whether the error is
serious enough that the database connection has been lost, so I can
have the application try to reconnect automatically. My understanding
is that any error of severity 20 or above includes a broken connection,
but I'm having difficulty retrieving the error severity through ODBC.
So my first question is, how do I retrieve the error severity through
ODBC?

Also, as a test, I stopped the database while my application is still
running, and the first error I received had a native error code of 55.
There is no 55 error in the sysmessages table, so I'm confused as to
what the severity of the error is. Can anyone shed some light on why I
would be receiving an error code that is not in the sysmessages table,
and where I might be able to find more information about the error?

Thanks in advance,
AbramI'm not at all familiar with ODBC, however if there's a fatal error
which breaks the connection, it seems unlikely that the server will be
able to inform the client, so I don't see how you could guarantee that
you'll get the MSSQL severity level in a client application (although
it should be logged on the server).

I think you should probably have a look at whatever ODBC errors might
be raised in this situation, although as I said I don't know much about
ODBC, so I may be on the wrong track. In any case, it might be worth
asking the question in an ODBC group as well - handling unexpected
disconnections from a remote data source is probably not specific to
MSSQL.

As for error 55, it's probably Windows error 55 - try typing this at a
command prompt:

NET HELPMSG 55

Simon|||Thanks Simon. I've cross-posted on microsoft.public.data.odbc as well.
I think you're right about error 55. Thanks again!

Abram

ODBC SQL Driver Timeout Expired from MS Access

Hi

I'm running a machine with windows xp pro sp2. I have a MS Access 2000 database on that machine. The database contains 1 odbc linked table
and 1 Access query.

The odbc linked table is connected to a MS SQL Server 2000 database with a ODBC SQL Server System DSN.

The table on SQL Server to which the table in Access is linked has about
3 million + rows.

When I open the ODBC linked table in Access, it opens without a problem.

However, if I use even so much as one criterion such as "where company = ABC" for example, then it "thinks" for a while and returns the dreaded:
[Microsoft][ODBC SQL Driver] Timeout Expired (#0).

I have to use MS Access 2000 as the front end for this SQL Database table.

How do I get around the timeout issue. Is there a setting in SQL?

Please keep in mind that
I can't write the queries as Store procs because the requirement of the client is that there be one Linked Access table that the users can use
to write various access queries. No user are not techies.

please helpread this post:
http://www.mcse.ms/message1582144.html

I don't test.
Tell me.
Bye.