new to sql please help

i use access 2000 as my front end. i had a form named main with a couple of unbound fields on it . i used to put in last name and first name and then in a query i would put "like [forms]![main]![text0] & "*"
and also "like [forms]![main]![text2] & "*"

the lookup patient button would open my patient form based on the query results of what i typed in on the main form . ex: i type in riley it would give me my patient form with all the riley's in it.

how do i get my access form to open from information i am looking for in a query now that my whole database is back on a sql server.

by the way i upsized to a adp file no longer using mdb. please if possible explain in detail how to do this as i am having trouble with the syntax of sql. i understand i cant use "*" as a wildcard now but % instead.

thanks in advance.Hoe are you connecting to SQL Sever?

You shouldn't have to change your code...did you create linked tables?|||im assuming they not linked tables since it is now a access project i dont see the little globe when i used to use link tables.

i think everything is useing passthorugh queries now all my tables are on the sql server. just the forms and macros are on the frontend now.

my code i had to change was something like

dim db as dao.database
dim rs as dao.recordset

i had to change that to
dim conn as adodb.connection
dim rs as new adodb.recordset

and quite a few other things

if i left them linked the queries should have stayed working but im trying to get away from passing things through the jet engine and using the full power of sql .|||this was my old code to make a chartnumber based on the first and last name fields. this is the one that didnt work .

Public Function chartlookup()
Dim db As DAO.Database <--believe to be the problem
Dim rs As DAO.Recordset <-- belive to be the problem
Dim SQL As String
Dim NewNum As Integer
Dim NeWChartNum As String

SQL = "Select max(Cint(Right([chartnumber],6))) As RecNum From tblpatientinfo WHERE UCase(Left([chartnumber],5)) = '" & UCase(Left([Forms]![fpatient]![lname], 3)) & UCase(Left([Forms]![fpatient]![fname], 2)) & "'"

Set db = CurrentDb() <-- -problem
Set rs = db.OpenRecordset(SQL) <--problem

If IsNull([Forms]![fpatient]![chartnumber]) = False Then GoTo 400

If rs.EOF = False Then
If IsNull(rs!RecNum) = False Then
NewNum = rs!RecNum + 1
Else
NewNum = 1
End If
End If
'If NewNum = 1 Then

[Forms]![fpatient]![chartnumber] = UCase(Left([Forms]![fpatient]![lname], 3)) & UCase(Left([Forms]![fpatient]![fname], 2)) & Format(NewNum, "000000")
'End If|||Well this is a TOTAL guess...

If you're doing passthrus, you'll need SQL Server syntax..

(Why not just call stored procedures if you're making such a radical change?)

anyway...

SQL = "SELECT (MAX(CONVERT(int,(RIGHT(chartnumber))))
FROM tblpatientinfo
WHERE UPPER(LEFT(chartnumber,5)) = " _
& "'" UCase(Left([Forms]![fpatient]![lname], 3)) & UCase(Left([Forms]![fpatient]![fname], 2)) & "'"

my front end skills have gotten rusty...

You might want to also look to post here:

http://www.sqlteam.com/forums/forum.asp?FORUM_ID=3|||i did get that code to work but my main real problem is how do i get user sitting at my main form where he has to enter a patients lst name and first then when he hits the lookup patient button it opens my patient record with only the patient he typed in from the previous form . this was easy on access just added the expression into the query . but sql doesnt seem to support forms based queries. so what i really need is what does sql use instead of forms based queries to prompt a user for what they want to fill a record with.

if i use select lname from tblpatientinfo where lname="riley"

my form will only give me patients with last name riley

but how do i get it to ask what name we are looking for i guess would be the real question here. do i make a stored procedure to prompt for the information and base the form on the stored procedure or does my from on open have to request what im looking for. i may not be useing the correct wording so please be patient but sql is a whole new world to me.
i tried useing a filter on my form but if i put the stored procedure in the filter it doesnt recognize the stored procedure name only access query names it seems.

New SQL 2005 instance using 2000 engine?

Hello,
I installed SQL 2005 Standard on the same server (2K3) with SQL 2000. My named instance I installed is coming up with "Version 8.00.2039" in the Server Management Studio and will not let me restore a database back-up I made on a 2005 development workstation (I'm assuming it's because it's trying to use the 2000 engine instead of the 2005). Is there a way I can force this instance to use the 2005 engine rather than the 2000?

Thanks,

Steve

SQL 2005 will not use the 2000 engine.

It sounds like your connecting to the wrong instance, try running

select @.@.VERSION

you should see something like :

Microsoft SQL Server 2005 - 9.00.1399.06 (Intel X86) Oct 14 2005 00:33:37 Copyright (c) 1988-2005 Microsoft Corporation Developer Edition on Windows NT 5.2 (Build 3790: Service Pack 1)

for 2005.

To double check you connection string, e.g. your instance name. Try the following :

Run SQL Server 2005 Surface Area Configuration
Click "Surface Area Configuration for Services and Connections

You will see your SQL2005 Instances, expand the SQL instance, expand Database Engine, click Service.

Note the Display Name "In my instance its SQL Server (SQLEXPRESS)"

Run services.msc

Select the SQL server name from the display named noted above.

Select properties

Copy the Path to execute, in my instances its :

"c:\Program Files (x86)\Microsoft SQL Server\MSSQL.4\MSSQL\Binn\sqlservr.exe" -sSQLEXPRESS

Run this from a cmd line.

Look at the output, you looking for :

Server local connection provider is ready to accept connection on [ \\.\pipe\SQLLocal\SQLEXPRESS ].

For me, I can connect on \\SERVERNAME\SQLExpress

for my SQL instance, eg not SQL Express I get :

Server local connection provider is ready to accept connection on [ \\.\pipe\SQLLocal\MSSQLSERVER ]

So, we have NO instance (MSSQLSERVER is the default), so to connect we just connect to \\SERVERNAME

Let me know if this helps.

Thanks

Steve

|||Yup, that was exactly what happened. I apparently created a 2000 instance instead of a 2005 instance in my late night stupor, and was convinced it was suppose to be 2005. =)

Thanks!|||

Yep, I have seen that done before, I have even seen someone rebuild a SQL server from stracth as they were convinced that somehow the instance was 'broke'

glad to be of help.

Steve

New partition (SSAS 2005) - named query not in "available tables"

I'm trying to create another partition in an existing measure group.
I start the new partition wizard and choose my data source view in the
"Look in", and then click "Find tables".
My named query does not appear in the list. What could be wrong?

I have saved and refreshed the data source view. The named query has the
same column names and data types that the original table has (that the
measure group is using now).

I also tried to make the named query a ordinary view in the source
database but that does not appear in the list either (I choose the
data source then instead of the data source view).

Hi,

I wouldn't suspect that you'd see a named query in the list of tables when you go to create a new partition. I'm not sure if that list of tables shows views from the underlying DB, either..But, you can make your partition query binding, instead of table binding, and you can make the partition source the same query you're using in your named query, or a subset of it with a where clause, or whatever you choose.

HTH,
C
|||

I don't understand...

In the "New partition wizard" there isn't a whole lot to choose from... Pick either a data source or a data source view, and then pick the "table" - which I suppose could be a view, table, named query... When I choose data source view I can only see the table that is already being used as a fact table in the measure group (and this is actually a named query and not a table). When I choose the data soure, eg. the underlying database, I get nothing.

|||

I found the answer myself.

I thought I had the same datatypes because I created my new named query from the original table that the first named query (the one being used in the measure group already) was based on. But it turned out that the first named query did not get the same datatypes i all columns as the underlying table.

In BOL it states that the tables (or named queries) used in the same measure group must be sufficiently similar - I would call it exactly the same :-)

New named instance.

I am going to be using our SQL Server to manage a project
database. SQL Server is installed on our Windows 2000
server using SBS. Currently there is a named
instance "SERVER1\BKUPEXEC" that is being used by Backup
Exec. Do I need to create a new named instance to use as
for my database manager or can I safely use the existing
instance?| I am going to be using our SQL Server to manage a project
| database. SQL Server is installed on our Windows 2000
| server using SBS. Currently there is a named
| instance "SERVER1\BKUPEXEC" that is being used by Backup
| Exec. Do I need to create a new named instance to use as
| for my database manager or can I safely use the existing
| instance?
--
In general, using a single instance of SQL Server for all database work is
best practice, to wit:
- You can have as many as 32, 767 databases per instance but you can only
have up to 16 instances on one server.
- Using 16 databases in one instances requires less resources than having 1
database for each of your 16 instances on the server.
The only advantage with using several instances is that if one instance
crashes for whatever reason, the other instances are not affected.
Hope this helps,
--
Eric Cárdenas
SQL Server support

New Instance on SQL 2000 SP 4

Hi,
I have a server running SQL Server 2000 SP 4 on Windows Server 2003 SP 1. I
want to install a named instance (this is a development environment). As
far as I know, I will need start the install of the named instance from the
SQL 2000 RTM install file set.
What does this do to my existing SQL 2000 SP 4 instance(s)? Do I need to
re-patch them all to SP4? Will the new instance be RTM or SP4? Does
Microsoft have a SQL 2000 SP 4 install image?
--
Thank you,
Daniel Jameson
SQL Server DBA
Children's Oncology Group
www.childrensoncologygroup.orgThe named instance will be RTM. You will need to patch the named instance
to SP4, but you should not need to do anything to the existing instance.
There is not a SQL Server 2000 SP4 install image to my knowledge, such as
there is with operating systems.
K. Brian Kelley, brian underscore kelley at sqlpass dot org
http://www.truthsolutions.com/
> Hi,
> I have a server running SQL Server 2000 SP 4 on Windows Server 2003 SP
> 1. I want to install a named instance (this is a development
> environment). As far as I know, I will need start the install of the
> named instance from the SQL 2000 RTM install file set.
> What does this do to my existing SQL 2000 SP 4 instance(s)? Do I need
> to re-patch them all to SP4? Will the new instance be RTM or SP4?
> Does Microsoft have a SQL 2000 SP 4 install image?
> Daniel Jameson
> SQL Server DBA
> Children's Oncology Group
> www.childrensoncologygroup.org

New Instance on SQL 2000 SP 4

Hi,
I have a server running SQL Server 2000 SP 4 on Windows Server 2003 SP 1. I
want to install a named instance (this is a development environment). As
far as I know, I will need start the install of the named instance from the
SQL 2000 RTM install file set.
What does this do to my existing SQL 2000 SP 4 instance(s)? Do I need to
re-patch them all to SP4? Will the new instance be RTM or SP4? Does
Microsoft have a SQL 2000 SP 4 install image?
Thank you,
Daniel Jameson
SQL Server DBA
Children's Oncology Group
www.childrensoncologygroup.org
The named instance will be RTM. You will need to patch the named instance
to SP4, but you should not need to do anything to the existing instance.
There is not a SQL Server 2000 SP4 install image to my knowledge, such as
there is with operating systems.
K. Brian Kelley, brian underscore kelley at sqlpass dot org
http://www.truthsolutions.com/

> Hi,
> I have a server running SQL Server 2000 SP 4 on Windows Server 2003 SP
> 1. I want to install a named instance (this is a development
> environment). As far as I know, I will need start the install of the
> named instance from the SQL 2000 RTM install file set.
> What does this do to my existing SQL 2000 SP 4 instance(s)? Do I need
> to re-patch them all to SP4? Will the new instance be RTM or SP4?
> Does Microsoft have a SQL 2000 SP 4 install image?
> Daniel Jameson
> SQL Server DBA
> Children's Oncology Group
> www.childrensoncologygroup.org

New Instance on SQL 2000 SP 4

Hi,
I have a server running SQL Server 2000 SP 4 on Windows Server 2003 SP 1. I
want to install a named instance (this is a development environment). As
far as I know, I will need start the install of the named instance from the
SQL 2000 RTM install file set.
What does this do to my existing SQL 2000 SP 4 instance(s)? Do I need to
re-patch them all to SP4? Will the new instance be RTM or SP4? Does
Microsoft have a SQL 2000 SP 4 install image?
Thank you,
Daniel Jameson
SQL Server DBA
Children's Oncology Group
www.childrensoncologygroup.orgThe named instance will be RTM. You will need to patch the named instance
to SP4, but you should not need to do anything to the existing instance.
There is not a SQL Server 2000 SP4 install image to my knowledge, such as
there is with operating systems.
K. Brian Kelley, brian underscore kelley at sqlpass dot org
http://www.truthsolutions.com/

> Hi,
> I have a server running SQL Server 2000 SP 4 on Windows Server 2003 SP
> 1. I want to install a named instance (this is a development
> environment). As far as I know, I will need start the install of the
> named instance from the SQL 2000 RTM install file set.
> What does this do to my existing SQL 2000 SP 4 instance(s)? Do I need
> to re-patch them all to SP4? Will the new instance be RTM or SP4?
> Does Microsoft have a SQL 2000 SP 4 install image?
> Daniel Jameson
> SQL Server DBA
> Children's Oncology Group
> www.childrensoncologygroup.org

New Instance

I'd like to install a named instance of SQL server, if this is just for
testing in the dev lab do I still need to have a license for it?
In the prod version I have one instance with several databases can I give
another DBA rights to view and admin only one database of that list. How do
I restrict the other DBA from viewing other databases?
ThanksHi
This seems to be something I am never 100% sure about, so it would be better
to clarify it with you software provider. I think the answer depends on how
you have licenced your current copy and what version it is:
For Server + User Cal licencing
http://www.microsoft.com/sql/howtobuy/serverpluscal.asp
1. GRANT OF LICENSE. Microsoft grants you the following rights, provided you
comply with all terms and conditions of this EULA:
a. Installation-Server Software. You may install and use one copy of the
Server Software on a single Server. SQL Server Enterprise Edition. If
you have acquired the Enterprise Edition of the Server Software, you may
install any number of instances of the Server Software on
that Server. An "instance" shall mean a running copy of the Server Software.
Client Software. You may install the Client Software (SQL
Server Personal Edition) on any internal Device.
Server + Device cals seems to be similar to User Cal
http://www.microsoft.com/sql/howtobuy/servercal.asp
For processor licencing http://www.microsoft.com/sql/howtobuy/processor.asp:
1. GRANT OF LICENSE. Microsoft grants you the following rights, provided you
comply with all terms and conditions of this EULA:
a. License Structure. The Server Software is licensed on an individual
processor basis. You need one Server Software license for each of
your Server's processors. As an exception to that rule, if you have made a
processor inaccessible to all operating system copies on
which the Server Software is set up to run, you do not need a Server
Software license for that processor. Examples of processors that
you have made inaccessible to operating system copies are processors that
you have isolated by partitioning or other similar method.
You do not need more than one Server Software license for any processor.
b. Server Software. You may install and run any number of copies of the
Server Software on a single Server. You may use the
Management Tools, Books-Online, and Development Tools components of
Microsoft SQL Server (collectively "Tools") solely for
internal use in conjunction with your Server Software.
This would imply you can have multiple instances.
HTH
John
"Niles" <Niles@.discussions.microsoft.com> wrote in message
news:E2B9F076-111F-40F6-95CC-6266A19907C5@.microsoft.com...
> I'd like to install a named instance of SQL server, if this is just for
> testing in the dev lab do I still need to have a license for it?
> In the prod version I have one instance with several databases can I give
> another DBA rights to view and admin only one database of that list. How
> do
> I restrict the other DBA from viewing other databases?
> Thanks|||Niles wrote:
> I'd like to install a named instance of SQL server, if this is just
> for testing in the dev lab do I still need to have a license for it?
> In the prod version I have one instance with several databases can I
> give another DBA rights to view and admin only one database of that
> list. How do I restrict the other DBA from viewing other databases?
> Thanks
They can still "see" the other database names, but you can assign them
access to only the database they are supposed to maintain.
--
David Gugick
Imceda Software
www.imceda.com|||Per Server Licensing, you need additional Server License.
Per CPU, no additional licensing is required as long as you are properly
licenses for each CPU in the machine.
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"John Bell" <jbellnewsposts@.hotmail.com> wrote in message
news:ONsggru4EHA.1300@.TK2MSFTNGP14.phx.gbl...
> Hi
> This seems to be something I am never 100% sure about, so it would be
better
> to clarify it with you software provider. I think the answer depends on
how
> you have licenced your current copy and what version it is:
> For Server + User Cal licencing
> http://www.microsoft.com/sql/howtobuy/serverpluscal.asp
> 1. GRANT OF LICENSE. Microsoft grants you the following rights, provided
you
> comply with all terms and conditions of this EULA:
> a. Installation-Server Software. You may install and use one copy of the
> Server Software on a single Server. SQL Server Enterprise Edition. If
> you have acquired the Enterprise Edition of the Server Software, you may
> install any number of instances of the Server Software on
> that Server. An "instance" shall mean a running copy of the Server
Software.
> Client Software. You may install the Client Software (SQL
> Server Personal Edition) on any internal Device.
> Server + Device cals seems to be similar to User Cal
> http://www.microsoft.com/sql/howtobuy/servercal.asp
> For processor licencing
http://www.microsoft.com/sql/howtobuy/processor.asp:
> 1. GRANT OF LICENSE. Microsoft grants you the following rights, provided
you
> comply with all terms and conditions of this EULA:
> a. License Structure. The Server Software is licensed on an individual
> processor basis. You need one Server Software license for each of
> your Server's processors. As an exception to that rule, if you have made a
> processor inaccessible to all operating system copies on
> which the Server Software is set up to run, you do not need a Server
> Software license for that processor. Examples of processors that
> you have made inaccessible to operating system copies are processors that
> you have isolated by partitioning or other similar method.
> You do not need more than one Server Software license for any processor.
> b. Server Software. You may install and run any number of copies of the
> Server Software on a single Server. You may use the
> Management Tools, Books-Online, and Development Tools components of
> Microsoft SQL Server (collectively "Tools") solely for
> internal use in conjunction with your Server Software.
> This would imply you can have multiple instances.
> HTH
> John
>
> "Niles" <Niles@.discussions.microsoft.com> wrote in message
> news:E2B9F076-111F-40F6-95CC-6266A19907C5@.microsoft.com...
> > I'd like to install a named instance of SQL server, if this is just for
> > testing in the dev lab do I still need to have a license for it?
> >
> > In the prod version I have one instance with several databases can I
give
> > another DBA rights to view and admin only one database of that list.
How
> > do
> > I restrict the other DBA from viewing other databases?
> >
> > Thanks
>|||I haven't tested this yet but If I put a database under a named instance can
I then give them access to that instance only?
Thanks
"David Gugick" wrote:
> Niles wrote:
> > I'd like to install a named instance of SQL server, if this is just
> > for testing in the dev lab do I still need to have a license for it?
> >
> > In the prod version I have one instance with several databases can I
> > give another DBA rights to view and admin only one database of that
> > list. How do I restrict the other DBA from viewing other databases?
> >
> > Thanks
> They can still "see" the other database names, but you can assign them
> access to only the database they are supposed to maintain.
> --
> David Gugick
> Imceda Software
> www.imceda.com
>

New Instance

I'd like to install a named instance of SQL server, if this is just for
testing in the dev lab do I still need to have a license for it?
In the prod version I have one instance with several databases can I give
another DBA rights to view and admin only one database of that list. How do
I restrict the other DBA from viewing other databases?
Thanks
Hi
This seems to be something I am never 100% sure about, so it would be better
to clarify it with you software provider. I think the answer depends on how
you have licenced your current copy and what version it is:
For Server + User Cal licencing
http://www.microsoft.com/sql/howtobuy/serverpluscal.asp
1. GRANT OF LICENSE. Microsoft grants you the following rights, provided you
comply with all terms and conditions of this EULA:
a. Installation-Server Software. You may install and use one copy of the
Server Software on a single Server. SQL Server Enterprise Edition. If
you have acquired the Enterprise Edition of the Server Software, you may
install any number of instances of the Server Software on
that Server. An "instance" shall mean a running copy of the Server Software.
Client Software. You may install the Client Software (SQL
Server Personal Edition) on any internal Device.
Server + Device cals seems to be similar to User Cal
http://www.microsoft.com/sql/howtobuy/servercal.asp
For processor licencing http://www.microsoft.com/sql/howtobuy/processor.asp:
1. GRANT OF LICENSE. Microsoft grants you the following rights, provided you
comply with all terms and conditions of this EULA:
a. License Structure. The Server Software is licensed on an individual
processor basis. You need one Server Software license for each of
your Server's processors. As an exception to that rule, if you have made a
processor inaccessible to all operating system copies on
which the Server Software is set up to run, you do not need a Server
Software license for that processor. Examples of processors that
you have made inaccessible to operating system copies are processors that
you have isolated by partitioning or other similar method.
You do not need more than one Server Software license for any processor.
b. Server Software. You may install and run any number of copies of the
Server Software on a single Server. You may use the
Management Tools, Books-Online, and Development Tools components of
Microsoft SQL Server (collectively "Tools") solely for
internal use in conjunction with your Server Software.
This would imply you can have multiple instances.
HTH
John
"Niles" <Niles@.discussions.microsoft.com> wrote in message
news:E2B9F076-111F-40F6-95CC-6266A19907C5@.microsoft.com...
> I'd like to install a named instance of SQL server, if this is just for
> testing in the dev lab do I still need to have a license for it?
> In the prod version I have one instance with several databases can I give
> another DBA rights to view and admin only one database of that list. How
> do
> I restrict the other DBA from viewing other databases?
> Thanks
|||Niles wrote:
> I'd like to install a named instance of SQL server, if this is just
> for testing in the dev lab do I still need to have a license for it?
> In the prod version I have one instance with several databases can I
> give another DBA rights to view and admin only one database of that
> list. How do I restrict the other DBA from viewing other databases?
> Thanks
They can still "see" the other database names, but you can assign them
access to only the database they are supposed to maintain.
David Gugick
Imceda Software
www.imceda.com
|||Per Server Licensing, you need additional Server License.
Per CPU, no additional licensing is required as long as you are properly
licenses for each CPU in the machine.
Regards
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"John Bell" <jbellnewsposts@.hotmail.com> wrote in message
news:ONsggru4EHA.1300@.TK2MSFTNGP14.phx.gbl...
> Hi
> This seems to be something I am never 100% sure about, so it would be
better
> to clarify it with you software provider. I think the answer depends on
how
> you have licenced your current copy and what version it is:
> For Server + User Cal licencing
> http://www.microsoft.com/sql/howtobuy/serverpluscal.asp
> 1. GRANT OF LICENSE. Microsoft grants you the following rights, provided
you
> comply with all terms and conditions of this EULA:
> a. Installation-Server Software. You may install and use one copy of the
> Server Software on a single Server. SQL Server Enterprise Edition. If
> you have acquired the Enterprise Edition of the Server Software, you may
> install any number of instances of the Server Software on
> that Server. An "instance" shall mean a running copy of the Server
Software.
> Client Software. You may install the Client Software (SQL
> Server Personal Edition) on any internal Device.
> Server + Device cals seems to be similar to User Cal
> http://www.microsoft.com/sql/howtobuy/servercal.asp
> For processor licencing
http://www.microsoft.com/sql/howtobuy/processor.asp:
> 1. GRANT OF LICENSE. Microsoft grants you the following rights, provided
you[vbcol=seagreen]
> comply with all terms and conditions of this EULA:
> a. License Structure. The Server Software is licensed on an individual
> processor basis. You need one Server Software license for each of
> your Server's processors. As an exception to that rule, if you have made a
> processor inaccessible to all operating system copies on
> which the Server Software is set up to run, you do not need a Server
> Software license for that processor. Examples of processors that
> you have made inaccessible to operating system copies are processors that
> you have isolated by partitioning or other similar method.
> You do not need more than one Server Software license for any processor.
> b. Server Software. You may install and run any number of copies of the
> Server Software on a single Server. You may use the
> Management Tools, Books-Online, and Development Tools components of
> Microsoft SQL Server (collectively "Tools") solely for
> internal use in conjunction with your Server Software.
> This would imply you can have multiple instances.
> HTH
> John
>
> "Niles" <Niles@.discussions.microsoft.com> wrote in message
> news:E2B9F076-111F-40F6-95CC-6266A19907C5@.microsoft.com...
give[vbcol=seagreen]
How
>
|||I haven't tested this yet but If I put a database under a named instance can
I then give them access to that instance only?
Thanks
"David Gugick" wrote:

> Niles wrote:
> They can still "see" the other database names, but you can assign them
> access to only the database they are supposed to maintain.
> --
> David Gugick
> Imceda Software
> www.imceda.com
>

New Import/Export Wizard error

I am making the adjustment from SQL Server 2000 to SQL Server 2005. In the
past I have created named ranges in Excel that look like data tables (header
row followed by multiple data rows) and used DTS to create database tables i
n
SQL Server 2000. It has worked for several years. Now, using the SQL
Server 2005 import/export wizard, the same named ranges cause the following
error.
- Validating (Error)
Messages
Error 0xc00470fe: Data Flow Task: The product level is insufficient for
component "Source - B11Tbl" (1).
(SQL Server Import and Export Wizard)
Can anyone explain why it 'blows-up' and what I might do to fix it?
Thank you!Hi Mitch
Which version are you running?
John
"Mitch" wrote:

> I am making the adjustment from SQL Server 2000 to SQL Server 2005. In th
e
> past I have created named ranges in Excel that look like data tables (head
er
> row followed by multiple data rows) and used DTS to create database tables
in
> SQL Server 2000. It has worked for several years. Now, using the SQL
> Server 2005 import/export wizard, the same named ranges cause the followin
g
> error.
> - Validating (Error)
> Messages
> Error 0xc00470fe: Data Flow Task: The product level is insufficient f
or
> component "Source - B11Tbl" (1).
> (SQL Server Import and Export Wizard)
> Can anyone explain why it 'blows-up' and what I might do to fix it?
> Thank you!
>|||Microsoft SQL Server Management Studio 9.00.1399.00
Microsoft Analysis Services Client Tools 2005.090.1399.00
Microsoft Data Access Components (MDAC) 2000.085.1117.00
(xpsp_sp2_rtm.040803-2158)
Microsoft MSXML 2.6 3.0 4.0 5.0 6.0
Microsoft Internet Explorer 6.0.2900.2180
Microsoft .NET Framework 2.0.50727.42
Operating System 5.1.2600
I hope this gives the version info needed.
Mitch
"John Bell" wrote:
> Hi Mitch
> Which version are you running?
> John
> "Mitch" wrote:
>|||Hi
That does not tell me the edition!
You may want to test if it works with SP1.
John
"Mitch" wrote:
> Microsoft SQL Server Management Studio 9.00.1399.00
> Microsoft Analysis Services Client Tools 2005.090.1399.00
> Microsoft Data Access Components (MDAC) 2000.085.1117.00
> (xpsp_sp2_rtm.040803-2158)
> Microsoft MSXML 2.6 3.0 4.0 5.0 6.0
> Microsoft Internet Explorer 6.0.2900.2180
> Microsoft .NET Framework 2.0.50727.42
> Operating System 5.1.2600
> I hope this gives the version info needed.
> Mitch
> "John Bell" wrote:
>|||Microsoft SQL Server Standard Edition
"John Bell" wrote:
> Hi
> That does not tell me the edition!
> You may want to test if it works with SP1.
> John
> "Mitch" wrote:
>|||Hi Mitch
Then I can't see why you are getting this message! Have you tried this
without the named ranges or a different version of Excel?
John
"Mitch" wrote:
> Microsoft SQL Server Standard Edition
> "John Bell" wrote:
>|||I'll have the IT people check the installation settings for SQL Server 2005.
The 2000 version of DTS still works just fine... The problem is only with
the 2005 version. Thank you for your help!
"John Bell" wrote:
> Hi Mitch
> Then I can't see why you are getting this message! Have you tried this
> without the named ranges or a different version of Excel?
> John
> "Mitch" wrote:
>|||Hi Mitch
SQL 2005 has most thing off by default, but I can't remember having to
change anything special for excel files, although I haven't tried named
ranges.
John
"Mitch" wrote:
> I'll have the IT people check the installation settings for SQL Server 200
5.
> The 2000 version of DTS still works just fine... The problem is only with
> the 2005 version. Thank you for your help!
> "John Bell" wrote:
>|||I get the error message several seconds after identifying the source and it
does not progress (show any more windows) from that point. The message
suggests that it is a Microsoft Jet Database Engine error message. We
watched the server during the attempt (several times) and absolutely nothing
is happening on the server end (SQL Server). My workstation has 2.0 GB RAM
so I doubt that RAM is a problem. The funny part is that the data transfer
works using SQL Server 2000 (which I no longer have installed). Any
suggestions?
"John Bell" wrote:
> Hi Mitch
> SQL 2005 has most thing off by default, but I can't remember having to
> change anything special for excel files, although I haven't tried named
> ranges.
> John
>
> "Mitch" wrote:
>|||Hi
It does sound like a driver issue, I have tested importing named ranges
without any issues.
John
"Mitch" wrote:
> I get the error message several seconds after identifying the source and i
t
> does not progress (show any more windows) from that point. The message
> suggests that it is a Microsoft Jet Database Engine error message. We
> watched the server during the attempt (several times) and absolutely nothi
ng
> is happening on the server end (SQL Server). My workstation has 2.0 GB RA
M
> so I doubt that RAM is a problem. The funny part is that the data transfe
r
> works using SQL Server 2000 (which I no longer have installed). Any
> suggestions?
> "John Bell" wrote:
>