Microsoft SQL server 6.5 to 2005

Hi Fellas,
I would really appreciate if you could help me out with the following two questions?
1) Can 2005 server files be converted to 6.5? and how?
2) How easy it to upgrade from 6.5 to 2005? and how?
I would be really grateful by your help
NickNot so easy task to do as you have to compare each and every aspect of the database to ensure they work in compatibility of SQL 2005.

Refer to http://sqlserver-qa.net/blogs/tools/archive/2007/04/12/set-a-stage-for-smooth-upgrades-of-your-sql-server-environment.aspx & http://sqlserver-qa.net/blogs/tools/pages/easy-way-to-upgrade-from-previous-version-of-sql-server.aspx in this case.|||Thanks a lot, i appreciate.|||Maverick

I should imagine it would depend on the size & complexity of the 6.5 DB

For a simple DB I would probably just script out the Schema then, run script & right click - import the data on the 2005 box then - suck it & see fixing any issues (IF there are any) in testing.

Or you could spend your life reading up on the possible failures & effects that may occur as Satya suggests

GWsql

Microsoft SQL Server 2005 Reporting Services -- Error 1303

I am trying to install Microsoft SQL Server 2005 Reporting Services, Receiving the following error

Microsoft SQL Server 2005 Reporting Services -- Error 1303. The installer has insufficient privileges to access this directory: C:\Config.Msi. The installation cannot continue. Log on as administrator or contact your system administrator.

I am already logged in as Administrator and should have all the necessary permissions to install software

Please help me.

I think you accidentally got the wrong forum for this. This is the replication forum. I suggest reposting your question in the SQL Server Reporting Services forum.

Phil Garding

|||Thankssql

Microsoft SQL Server 2005 JDBC Driver

I'm getting the following exception when attempting to connect to SQL Server 2005 using Microsoft's new JDBC driver:

com.microsoft.sqlserver.jdbc.SQLServerException: The TCP/IP connection to the host has failed. java.net.ConnectException: Connection refused: connect

The help docs suggest checking connectivity using telnet. So attempting to connect via telnet to 127.0.0.1:1433 generates:

Could not open connection to the host, on port 23: Connect failed.

So I try to start telnet:

net start telnet

I get the following error message:

The service cannot be started either because it is disabled or because it has no enables devices associated with it.

Can anyone help?

Thanks

It seems that the TCP protocols is not enabled on your SQL Server.

You may need to enable TCP and *restart* SQL Server.

An article on how to do it for SQL Express is at http://blogs.msdn.com/sqlexpress/archive/2005/05/05/415084.aspx. The steps are similar for any other edition of SQL Server 2005.

|||

Thanks Peter; TCP/IP was enabled,I must have broken something else during my experimentation with Telnet. I reinstalled the OS and it worked OK.

Duncan

sql

Microsoft SQL Server 2000 JDBC Driver issue

I was wondering if anybody has run into the following problem with ms's
jdbc driver. We're using cursors in our app - when we create a
java.sql.Statement object in the app, we're indicating that we want the
corresponding ResultSet object to have a TYPE_FORWARD_ONLY cursor.
We've noticed when we do this that if the app executes a query with
'UNION's in it, it never gets a ResultSet back from the server (I've
noticed on the SQL server profiler that it stays stuck doing the 'exec
sp_cursoropen' call). If we change the resultSetType to
TYPE_SCROLL_INSENSITIVE then the query returns in no time.
Any ideas?
Thanks.
--Yogesh
*** Sent via Developersdex http://www.codecomments.com ***
Don't just participate in USENET...get rewarded for it!
joe wrote:

> I was wondering if anybody has run into the following problem with ms's
> jdbc driver. We're using cursors in our app - when we create a
> java.sql.Statement object in the app, we're indicating that we want the
> corresponding ResultSet object to have a TYPE_FORWARD_ONLY cursor.
> We've noticed when we do this that if the app executes a query with
> 'UNION's in it, it never gets a ResultSet back from the server (I've
> noticed on the SQL server profiler that it stays stuck doing the 'exec
> sp_cursoropen' call). If we change the resultSetType to
> TYPE_SCROLL_INSENSITIVE then the query returns in no time.
If you can show an example of your code, it'll help.
If you do a trivial query like "select * from sysdatabases UNION select * from sysdatabases"
that hangs?
thanks
Joe

> Any ideas?
> Thanks.
> --Yogesh
> *** Sent via Developersdex http://www.codecomments.com ***
> Don't just participate in USENET...get rewarded for it!
sql

Microsoft SQL 2000 Login Problem

Hi,

I'm trying to slove this problem from last few hours. I cannot slove this problem. Getting following error message if i try to login in Microsoft SQL Server 2000. Programming in Visual Studio NET -> MFC...

Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection.



CDBVariant value;
CDatabase db;
char sql_statement [2048] = "";

//CDatabase object "db" created to connect database
db.OpenEx(_T("DSN=MQIS"),CDatabase::noOdbcDialog);
.
.
.
.

can someone please help me out, is something wrong with the code ??does your DSN include a username and a password ?|||well,

i didn't created one. I had a computer crash... and i had to reinstall everything. but know my sourcecode isnt working anymore. even with username dbo it isn't working

weird. must be wrong with the sql server 2000|||"db.OpenEx(_T("DSN=MQIS"),CDatabase::noOdbcDialog)"

you have to create a new DSN named MQSI
with a integrated user and a password
or specify them after after the DSN

"db.OpenEx(_T("DSN=MQIS;UID=sa;PWD=password")...|||how can i create a new dsn name ??

when installed last time before this time the sql server 2000 i used the beauty and could login with it as a dsn name. like "DSN=beauty" the name of my server is now "motherindia" but i cant login now anymore. i didnt did anything different then before.|||In your

> Config Pannel
> Administration Tools
> ODBC Data Sources

Add a new System Data Source
named "MQIS"|||i dont have these options in Microsofts sql server|||This is not done in SQL Server
but on your Computer ...|||lol

thx.. i had to choose the same name

works pefectsql

Microsoft Reporting Service

I have the following Question:

Is it possible to install a Reporting Service at IIS Webserver without
SQL Server 2000 on the same machine.

We have a Enterprise SQL Server at another machine and i don't want to
install another SQL Server at a IIS.

Thank you for all responses

Flecki"flecki" <thorsten.fleckenstein@.de.cpm-int.com> wrote in message
news:f2626ae2.0409222330.309f741f@.posting.google.c om...
>I have the following Question:
> Is it possible to install a Reporting Service at IIS Webserver without
> SQL Server 2000 on the same machine.
> We have a Enterprise SQL Server at another machine and i don't want to
> install another SQL Server at a IIS.
> Thank you for all responses
> Flecki

Yes - you can use a remote database:

http://msdn.microsoft.com/library/d...grs_v1_8k82.asp

Simon

Microsoft Query?

i am using the following criteria in the [DateTime] field;

>=#3/9/2007# And <=#3/12/2007 11:59:59 PM#

i am using microsft query and excel to create pivot tables, i created an odbc file to connect to my local server

[DateTime] [TagName] [Value]
2007-03-09 00:00:00.000 PS002_Pump1.Daily_Runtime 1.1833188533782959
2007-03-09 00:00:00.000 PS002_Pump2.Daily_Runtime 1.4499822854995728
2007-03-09 04:59:59.947 PS002_Pump1.Daily_Runtime 0.16666463017463684
2007-03-09 04:59:59.947 PS002_Pump2.Daily_Runtime 0.13333170115947723
2007-03-09 09:59:59.893 PS002_Pump1.Daily_Runtime 0.51666033267974854
2007-03-09 09:59:59.893 PS002_Pump2.Daily_Runtime 0.48332741856575012
2007-03-09 14:59:59.843 PS002_Pump1.Daily_Runtime 0.86665606498718262
2007-03-09 14:59:59.843 PS002_Pump2.Daily_Runtime 0.86665606498718262
2007-03-09 19:59:59.790 PS002_Pump1.Daily_Runtime 1.083320140838623
2007-03-09 19:59:59.790 PS002_Pump2.Daily_Runtime 1.1333194971084595
2007-03-10 05:59:59.683 PS002_Pump1.Daily_Runtime 0.18333110213279724
2007-03-10 05:59:59.683 PS002_Pump2.Daily_Runtime 0.18333110213279724
2007-03-10 10:59:59.630 PS002_Pump1.Daily_Runtime 0.49999389052391052
2007-03-10 10:59:59.630 PS002_Pump2.Daily_Runtime 0.56665974855422974
2007-03-10 15:59:59.577 PS002_Pump1.Daily_Runtime 0.83332318067550659
2007-03-10 15:59:59.577 PS002_Pump2.Daily_Runtime 0.93332195281982422
2007-03-10 20:59:59.527 PS002_Pump1.Daily_Runtime 1.1166530847549438
2007-03-10 20:59:59.527 PS002_Pump2.Daily_Runtime 1.2833176851272583
2007-03-11 07:59:59.420 PS002_Pump1.Daily_Runtime 0.14999817311763763
2007-03-11 07:59:59.420 PS002_Pump2.Daily_Runtime 0.24999694526195526
2007-03-11 12:59:59.367 PS002_Pump1.Daily_Runtime 0.56665974855422974
2007-03-11 12:59:59.367 PS002_Pump2.Daily_Runtime 0.69999146461486816
2007-03-11 17:59:59.317 PS002_Pump1.Daily_Runtime 0.81665670871734619
2007-03-11 17:59:59.317 PS002_Pump2.Daily_Runtime 0.98332130908966064
2007-03-11 22:59:59.263 PS002_Pump1.Daily_Runtime 1.1833188533782959
2007-03-11 22:59:59.263 PS002_Pump2.Daily_Runtime 1.3666499853134155
2007-03-12 03:59:59.210 PS002_Pump1.Daily_Runtime 0.11666524410247803
2007-03-12 03:59:59.210 PS002_Pump2.Daily_Runtime 0.08333231508731842
2007-03-12 08:59:59.157 PS002_Pump1.Daily_Runtime 0.23333048820495605
2007-03-12 08:59:59.157 PS002_Pump2.Daily_Runtime 0.28332987427711487
2007-03-12 13:59:59.107 PS002_Pump1.Daily_Runtime 0.66665852069854736
2007-03-12 13:59:59.107 PS002_Pump2.Daily_Runtime 0.76665729284286499
2007-03-12 18:59:59.053 PS002_Pump1.Daily_Runtime 0.89998900890350342
2007-03-12 18:59:59.053 PS002_Pump2.Daily_Runtime 1.0166542530059814
2007-03-12 23:59:59.000 PS002_Pump1.Daily_Runtime 1.1999853849411011
2007-03-12 23:59:59.000 PS002_Pump2.Daily_Runtime 1.3833163976669312

what i would like to do is not hard code the date for the data i need, is there a way to code the dates so that microsoft query
would pull those date from sql...ie;

[DateTime]

>= CONVERT(VARCHAR(20), GETDATE()-5, 100) 12:00:00 AM and <= CONVERT(VARCHAR(20), GETDATE(), 100) 11:59:59 PM

any ideas?

Can't you just use:

WHERE [DateTime] BETWEEN GETDATE() - 5 AND GETDATE()

Chris

|||no , because you only get the data for the current date and time. I need to code this so that it will pick up all data between 12:00:00 am and 11:5:59 pm for each date.|||

Just to clarify - if you ran the query now (15-Mar-2007 20:23:32.000) then you would expect to return data from 10-Mar-2007 00:00:00.000 to 15-Mar-2007 23:59:59.999 inclusive.

Is this correct?

If so, then this could help:

WHERE [DateTime] >= CAST(CONVERT(VARCHAR(8), GETDATE() - 5, 112) AS DATETIME)
AND [DateTime] < CAST(CONVERT(VARCHAR(8), GETDATE() + 1, 112) AS DATETIME)

Chris

|||Thank You Chris, that worked like a charm...Have a great weekend.

Microsoft OLEDB Provider Error (with SQL server and ASP)

Dear all,

Still i am having problem with connecting sql server with ASP (Intranet).

Following is the code which i am using for the connection now,

Set conn=Server.CreateObject("ADODB.Connection")
conn.open "DSN=aspfirst;Uid=;PWD=;"

The error mesage , generated by this code is attached with this mail. Please check the attachment and hel me in the same

Gracesonhttp://support.microsoft.com/default.aspx?scid=kb;en-us;q306518 To resolve.

HTH|||Thank you so much.

I could resolve the problem.

It was just add user IUSR_mechinename fromuser list.

Good finishing for a marathon...

bye

Thank you

gracesonsql

Microsoft OLE DB Provider for SQL Server error '80040e37'

I get Microsoft OLE DB Provider for SQL Server error '80040e37'

Invalid object name '#t_testTemp484883646'.
when I run the following ASP code:

Code is below

<!#Include File="../includes/adovbs.inc" -->

<HTML>
<HEAD>
<META NAME="GENERATOR" Content="Microsoft Visual Studio 6.0">
<TITLE></TITLE>
</HEAD>
<BODY>

<%
'-- Setup database connection
Set DataCmd = Server.CreateObject("ADODB.Connection")
Set rsData = Server.CreateObject("ADODB.RecordSet")
Dim varTempTableName
DataCmd.Open Application("DB")
'-- Use a Temp Table so that it gets destroyed automatically in case the page times out
'-- Use a Global Temp Table so that it is available across scopes when I open the record set below
'-- Append a semi unique number to the end because its global it could conflict with another browser running the same report
'varTempTableName = "##t_TestTemp" & Minute(Now()) & Second(Now())
varTempTableName = "#t_TestTemp" & Session.SessionID

strSQL = "Create Table " & varTempTableName & "(TestColumn2 int)"
DataCmd.Execute strSQL

strSQL = "select * from t_Test"
rsData.Open strSQL, DataCmd, adOpenForwardOnly,adLockReadOnly

Do While Not rsData.EOF
varTestColumn2 = rsData("TestColumn2")

'Error occurs when I place the following insert statement. Code works with the global variable

strSQL = "Insert into " & varTempTableName & " (TestColumn2) values (" & varTestColumn2 & ")"
DataCmd.Execute strSQL

rsData.MoveNext
Loop
rsData.Close

strSQL = "Drop Table " & varTempTableName
DataCmd.Execute strSQL

Set rsData = Nothing
Set DataCmd = Nothing
%>
</BODY>
</HTML>

If you have connection pooling enabled you will get *one* of the connection which *could* be actually not the same connection as this which created the temp table. So either use global temp tables (## instead of #) or disable connection pooling.

HTH, Jens K. Suessmeyer.

http://www.sqlserver2005.de

Microsoft OLE DB Provider for SQL Server error '80040e31'

Hi
Let me share the Possibilities & fix of the following error:
The error appeares only peak hrs. (when more request comes)
Microsoft OLE DB Provider for SQL Server error '80040e31'
Timeout expired
/News/Home.asp, line 121
Thanks in Advance
Dil
From Dil :
> Hi
> Let me share the Possibilities & fix of the following error:
> The error appeares only peak hrs. (when more request comes)
>
> Microsoft OLE DB Provider for SQL Server error '80040e31'
> Timeout expired
> /News/Home.asp, line 121
> Thanks in Advance
> Dil
Well, since you're not sharing, how about
http://www.aspfaq.com/show.asp?id=2287

Microsoft OLE DB Provider for SQL Server error 80004005

Hi friends,

Can anyone help me in connecting sql server and asp.
Wheneever try to do the connection, I am getting following error. All the connection string which i am using are correct.

can you help me.

Following are the error line

--------------------

Microsoft OLE DB Provider for SQL Server error '80004005'

Invalid connection string attribute

/MAsteringASP/global.asa, line 17

Microsoft OLE DB Provider for SQL Server error '80004005'

Invalid connection string attribute

/MAsteringASP/test2.asp, line 21
----------------

Please ckeck my code which I am using for connection

Thank you

Graceson MAthew

--------------------
<%@. Language =VBScript %>
<% option explicit %>

<Html>
<head>
<title> Database Connection </title>
</head>
<body>
<%

<!-- #INCLUDE FILE="adovbs.inc" -->

dim conn
dim sql
dim r
dim aConnectionString

Set conn=Server.CreateObject("ADODB.Connection")

conn.Mode=adModeReadWrite
conn.Open="Provider=SQLOLEDB;UID=Administrator;Password=passw d;Initial Catalog=nrth;Datasource=server ip;Port Number= 80"

Response.Write (" Database Connectivity")

%>
</body>
</html>try this type of connection string

driver={SQL Server};server=Server ip\DontForgetTheInstanceName;uid=Administrator;pwd =password;Database=nrth|||Also KBA (http://support.microsoft.com/default.aspx?scid=http://support.microsoft.com:80/support/kb/articles/Q169/3/77.asp&NoWebContent=1) to detail the connection between ASP & SQL Server.

HTH|||I don't recall Port NMumber being used in a connection string. Maybe if you took that part out?|||Ensure SQL uses that port and enabled on server or that port is not used by any other application.|||oh gosh, can't believe nobody saw this one!

replace uid with user id

:D :D :D :D :D|||Hehe. I guess that would be a problem for SQLOLEDB. Was UID phased out with the previous driver? Can't even remember what it was called. MSQL something-or-other.|||MSDASQL|||Dear karolyn,

Thank you for your reply, i attended the problem i the way you suggested .But now i am getting some other error, which is also could not rectify me,

now error is in following way
------
Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not exist or access denied.

//global.asa, line 17

Microsoft OLE DB Provider for ODBC Drivers error '80004005'

[Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not exist or access denied.

/test2.asp, line 21

----------------------

Will you please help me .

graceson


Originally posted by Karolyn
try this type of connection string

driver={SQL Server};server=Server ip\DontForgetTheInstanceName;uid=Administrator;pwd =password;Database=nrth|||http://support.microsoft.com/default.aspx?scid=kb;EN-US;Q328306 to deal the issue.|||i think you're trying to use windows authentication. in this case you need to try this:

conn.Open="Provider=SQLOLEDB;Integrated Security=SSPI;Initial Catalog=nrth;Datasource=server ip;Port Number= 80"

also, i noticed that if this is your "exact" connection string, you need to know the ip address of the server, as well as the actual port it's listening on. confirm it's port 80, otherwise the default is 1433 (port 80 is the default for http)

Microsoft OLE DB Provider for SQL Server

Why do I get the following error each time I am trying to create a new datasource view " SQL server does not exist"......

Could you please provide more information?

Thank you

|||

Hi

thanx but i have managed to resolve the problem. Instead of typing local sever name i typed localhost.....

Microsoft OLE DB Provider for SQL Server

Why do I get the following error each time I am trying to create a new datasource view " SQL server does not exist"......

Could you please provide more information?

Thank you

|||

Hi

thanx but i have managed to resolve the problem. Instead of typing local sever name i typed localhost.....

sql

Microsoft OLE DB Provider for ODBC Drivers error 80004005

Hi everybody
My problem with sql server is the following one:
I've got my backoffice manager application done with asp technology
that works on sql server installed on Win2000 and running on IIS5.
what I've done is simply doing a backup of my db and moving the asp
application on another server: Windows 2003 with IIS6 and sql server
vers.8.
Then I tried to set up everything as in the beginning on the previous
machine(Win2K), but I'm getting this error:

Microsoft OLE DB Provider for SQL Server error '80004005'
[DBNETLIB][ConnectionOpen (Connect()).]Server SQL inesistente o accesso
negato.
(translated would be "SQL Server doesn't exist or access denied")
/sitowebsite/bom/login.asp, line 13

...where in the line 13 is set the connection to the database:
Conn.Open Application("DBsource")

which should be driven by what is set inside the global.asa file:
Application("DBsource")="Provider=SQLOLEDB;server=127.0.0.1;database=db_nam e;uid=db_uid;pwd=db_pwd;"
Application("WS_DB_TYPE") = ( "SQLSERVER" )

I tried to restore the database just not losing information and nothing
happens.
I tried also to create a new user and modify the properties as it
should be from the previous settings in the db(db_owner,...etc), still
nothing.

any clue is appriciated.
many thanks in advance.ziottt (t.giommi@.gmail.com) writes:

Quote:

Originally Posted by

My problem with sql server is the following one:
I've got my backoffice manager application done with asp technology
that works on sql server installed on Win2000 and running on IIS5.
what I've done is simply doing a backup of my db and moving the asp
application on another server: Windows 2003 with IIS6 and sql server
vers.8.
Then I tried to set up everything as in the beginning on the previous
machine(Win2K), but I'm getting this error:
>
Microsoft OLE DB Provider for SQL Server error '80004005'
[DBNETLIB][ConnectionOpen (Connect()).]Server SQL inesistente o accesso
negato.
(translated would be "SQL Server doesn't exist or access denied")
/sitowebsite/bom/login.asp, line 13

This error message that the application cannot reach the SQL Server
you are trying to connect to. Thus, users or backups have no importance,
because you don't reach that far.

Quote:

Originally Posted by

...where in the line 13 is set the connection to the database:
Conn.Open Application("DBsource")
>
which should be driven by what is set inside the global.asa file:
>
>Application("DBsource")="Provider=SQLOLEDB;server=127.0.0.1;database=db_nam
>e;uid=db_uid;pwd=db_pwd;"

And SQL Server is running on the same server as the web server? Have you
verified that SQL Server is actually running?

Diclaimer: I don't know ASP, so if there are any problems with that
global.asa, I can't tell.

--
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pr...oads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodin...ions/books.mspx

Microsoft OLE DB Provider for ODBC Drivers

I am using an system ODBC created to access data on an AS/400.
I can access the data fine, using the following query.
SELECT F0101.* FROM CRPDTA.PILGRIM.CRPDTA.F0101 as F0101
where the first CRPDTA is the DSN name, PILGRIM is the AS/400 catalog,
the second CRPDTA is the SCHEMA, and F0101 is the file name.
When I try to save this query as a view, I receive the following error.
The operation could not be performed because the OLE DB provider
'MSDASQL' was unable to begin a distributed transaction.
[OLE/DB provider returned message: [IBM][Client Access Express ODBC
Driver (32-bit)]Option type out of range.]
OLE DB error trace [OLE/DB Provider 'MSDASQL'
ITransactionJoin::JoinTransaction returned 0x8004d00a]
Can anyone help?
PMGBoy
On several occasion a bug in the ODBC driver causes all sorts of problem
in the client. Try using any third party software, such as WinSQL
(http://synametrics.com/winsql) and see if you get the same behavior.
This would eliminate the possibility of a buggy driver.
jeff.jones@.papermagic.com wrote:
> I am using an system ODBC created to access data on an AS/400.
> I can access the data fine, using the following query.
> SELECT F0101.* FROM CRPDTA.PILGRIM.CRPDTA.F0101 as F0101
> where the first CRPDTA is the DSN name, PILGRIM is the AS/400 catalog,
> the second CRPDTA is the SCHEMA, and F0101 is the file name.
> When I try to save this query as a view, I receive the following error.
> The operation could not be performed because the OLE DB provider
> 'MSDASQL' was unable to begin a distributed transaction.
> [OLE/DB provider returned message: [IBM][Client Access Express ODBC
> Driver (32-bit)]Option type out of range.]
> OLE DB error trace [OLE/DB Provider 'MSDASQL'
> ITransactionJoin::JoinTransaction returned 0x8004d00a]
> Can anyone help?
> PMGBoy
>

Microsoft OLE DB Provider for ODBC Drivers

I am using an system ODBC created to access data on an AS/400.
I can access the data fine, using the following query.
SELECT F0101.* FROM CRPDTA.PILGRIM.CRPDTA.F0101 as F0101
where the first CRPDTA is the DSN name, PILGRIM is the AS/400 catalog,
the second CRPDTA is the SCHEMA, and F0101 is the file name.
When I try to save this query as a view, I receive the following error.
The operation could not be performed because the OLE DB provider
'MSDASQL' was unable to begin a distributed transaction.
[OLE/DB provider returned message: [IBM][Client Access Express O
DBC
Driver (32-bit)]Option type out of range.]
OLE DB error trace [OLE/DB Provider 'MSDASQL'
ITransactionJoin::JoinTransaction returned 0x8004d00a]
Can anyone help?
PMGBoyOn several occasion a bug in the ODBC driver causes all sorts of problem
in the client. Try using any third party software, such as WinSQL
(http://synametrics.com/winsql) and see if you get the same behavior.
This would eliminate the possibility of a buggy driver.
jeff.jones@.papermagic.com wrote:
> I am using an system ODBC created to access data on an AS/400.
> I can access the data fine, using the following query.
> SELECT F0101.* FROM CRPDTA.PILGRIM.CRPDTA.F0101 as F0101
> where the first CRPDTA is the DSN name, PILGRIM is the AS/400 catalog,
> the second CRPDTA is the SCHEMA, and F0101 is the file name.
> When I try to save this query as a view, I receive the following error.
> The operation could not be performed because the OLE DB provider
> 'MSDASQL' was unable to begin a distributed transaction.
> [OLE/DB provider returned message: [IBM][Client Access Express
ODBC
> Driver (32-bit)]Option type out of range.]
> OLE DB error trace [OLE/DB Provider 'MSDASQL'
> ITransactionJoin::JoinTransaction returned 0x8004d00a]
> Can anyone help?
> PMGBoy
>sql

Microsoft OLE DB Provider for Analysis Services error 80004005

Hello

I get the following error message in one of my ASP applications:
--------------------------
Microsoft OLE DB Provider for Analysis Services error '80004005'
Cannot connect to the server '172.16.103.14'. The server is either not started or too busy.
--------------------------
The IIS server is on a different machine to the MSOLAP server.

When I change the ASP code to point the 'localhost' it runs fine so Im fairly confident the necessary db conn libraries are installed on the IIS server.

There does not appear to be any traffic between the IIS/MSOLAP servers. Although all TCP ports are open. Interestingly, there are other pages on the same site that access a SQL Server resident on the MSOLAP servers & there are no issues.

Any assistance on this matter would be greatly appreciated. (I am a relative novice re: ASP/MSOLAP/IIS etc)Howdy

Talk to your networking guys & check the Default Gateway setting for TCPIP on the server. Sounds like it cant find the server.

Can you ping the IP address from a dos window on the server?

Cheers

SG|||You should check client-library/server-library settings. You prolly have named pipes only and no TCP-IP connection set-up.|||Originally posted by sqlguy7777
Howdy

Talk to your networking guys & check the Default Gateway setting for TCPIP on the server. Sounds like it cant find the server.

Can you ping the IP address from a dos window on the server?

Cheers

SG

Everything seems to be in order on this front. You will note that connectivity to a SQL Server database on the application/database server from the ASP pages on the web server function OK.|||Originally posted by beyond cool
You should check client-library/server-library settings. You prolly have named pipes only and no TCP-IP connection set-up.

Everything seems to be in order on this front. Note that connectivity to a SQL Server database on the application/database server from the ASP pages on the web server function OK...unless im missing something here....|||Howdy kalaa,

Can you confirm you can do these things :

(1) Ping the SQL box by name from the web server from a dos window on the web server e.g. ping <SQL_Server_name>. This will test if you have connectivity to the SQL box from the web server and more importantly confirm the SQL box is recognised in DNS.

(2) you have a valid SQL user ID set up on the SQL box, and that user ID has at least read access in the required database on the SQL box.
This is the user ID that the web application will use to talk to the SQL box.

Cheers,

SG

Microsoft ODBC sql driver cannot generate sspi context

Hi,
I am facing a connection error occasionally. Im using MSDE2000a and
Dbamgr2k. The connection seems to have the following error
occasionally. Can anyone of u help me to troubleshoot this problem?
thank you.
Connection Failed
SQLState: 'HY000'
SQL Server Error: 1364
[Microsoft][ODBC SQL Server Driver]Cannot generate SSPI context
Regards,
JustinJustin wrote:
> Hi,
> I am facing a connection error occasionally. Im using MSDE2000a and
> Dbamgr2k. The connection seems to have the following error
> occasionally. Can anyone of u help me to troubleshoot this problem?
> thank you.
> Connection Failed
> SQLState: 'HY000'
> SQL Server Error: 1364
> [Microsoft][ODBC SQL Server Driver]Cannot generate SSPI context
> Regards,
> Justin
>
Are you connecting with a Windows account in a domain? If so, the machine r
unning SQL Server may have lost connection
to the domain controller and can't authenticate your account credentials. S
earch MS support.|||Thanx Ed Enstrom for your reply. I don't really get what you meant.
Maybe i should elaborate more on this. The pc is a standalone pc, OS is
xp pro, database using msde2000a. The error comes out from no where.
There are times which im able to connect to the sql server but
sometimes it shows the error of microsoft odbc sql server cannot
generate sspi context. Should i connect using the "sa" or by "trusted
NT connection" in dbamgr2k'
p/s: sorry, im a newbie here. thanx for your patience.
regards,
justin|||What Ed means by "Search MS support" is to search the MSDN and/or TechNet,
including the KB. I searched an old version of the MSDN for "Cannot generate
SSPI context" and got one result that says that the "native error will
contain the Win32 error code".
"Justin" <justin@.smsit.com.my> wrote in message
news:1135235596.227999.154030@.z14g2000cwz.googlegroups.com...
> Thanx Ed Enstrom for your reply. I don't really get what you meant.

Microsoft JET Databse Engine Error Message

Hi,
When I try to import DBF files into the SQL Server,
I got the following error messages for some files.

Error Source: Microsoft JET Databse Engine
Error Destination: External table is not in the expected
format
Context: Error calling OpenRowset on the provider.

Does anyone know about this error?

I found that only files that have *.FPT (memo) files didn't work
and other files were imported successfully/

I installed sql server service pack and I checked that
the machine has the latest JET Database engine (4.0).

I'm using Microsoft SQL Server 2000 Standard Edition
w/ Service Pack 2 & Microsoft FoxPro 2.6.

Thank you in advance.

- Hyung -Did anyone ever answer this?sql

Microsoft EnterpriseLibrary connection

I hope this is the right place to ask this:

I am using the microsoft enterpriselibrary for accessing a sql server database. when I use the following code, I receive an error 'ExecuteScalar: Connection property has not been initialized.':

-----------------------

Database db = new SqlDatabase(p_ConnectionString);

DbCommand cmd = db.GetSqlStringCommand(p_Sql);

output = cmd.ExecuteScalar();

-----------------------

but when I use this code, everything works correctly:

-----------------------

Database db = new SqlDatabase(p_ConnectionString);

DbCommand cmd = db.GetSqlStringCommand(p_Sql);

output = db.ExecuteScalar(cmd);

-----------------------

I was assured by my supervisor that both snippets' syntax are correct. Can anyone shine some light on why the first snippet will throw an exception?

Thanks in advance,

Drew

Drew,

This is because entlib's Database object opens a new connection for you internally if there isn't already one open on the command object. The DbCommand implementation (either SqlCommand, OleDbCommand or OdbcCommand) does not do it for you, hence the error you get on an uninitialized connection.

-- Victor

|||

I guess my question is more of; how do i correct the first snippet?

|||

Not sure which version of EnterpriceLibrary you are using. If you use 2.0 and later, you don't need to create yourself connection. Instead you can use default if you only have one DB connection.

What you need to do is: in your web.config file, add these lines:

<configSections>

<sectionname="dataConfiguration"type="Microsoft.Practices.EnterpriseLibrary.Data.Configuration.DatabaseSettings, Microsoft.Practices.EnterpriseLibrary.Data, Version=2.0.0.0, Culture=neutral, PublicKeyToken=null"/>

</configSections>

<dataConfigurationdefaultDatabase="TestDB"/>

<connectionStrings>

<addname="TestDB"connectionString="YourConnectionStringForDBHere;"providerName="System.Data.SqlClient"/>

</connectionStrings>

Please note: <dataConfigurationdefaultDatabase="TestDB"/>

Then, in your code, just do:

Database db =DatabaseFactory.CreateDatabase();

string sqlCommand ="RetrieveCustomer";

DbCommand dbCommand = db.GetStoredProcCommand(sqlCommand);

db.ExecuteScalar(sqlCommand);

In your case, you can do

string p_ConnectionString = "TestDB";

Hope it helps.

|||

dhysong:

I guess my question is more of; how do i correct the first snippet?

To fix the first snippet you'll have to add code like this:

DbCommand command = db.GetSqlStringCommand("SELECT ...");if (command.Connection.State != ConnectionState.Open){command.Connection.Open();}

-- Victor