can i using linked Server in mssql server 64 bit version?

hi,
i always set the error when i used linked server to query data from other
server(32 bit) to my main server (64bit)
"Server: Msg 7399, Level 16, State 1, Line 1
OLE DB provider 'SQLOLEDB' reported an error.
[OLE/DB provider returned message: Unspecified error]
[OLE/DB provider returned message: The stored procedure required to complete
this operation could not be found on the server (they were supplied with the
ODBC setup disk for the SQL Server driver). Please contact your system
administrator.]
OLE DB error trace [OLE/DB Provider 'SQLOLEDB' IDBSchemaRowset::GetRowset
returned 0x80004005: ]."
do i miss something or i can using linked server in 64 bit edition?
thanks,
Suwito Kurniawan
Hi
Make sure that you have MDAC 2.8 on the 32 bit machine.
You can also run a Profiler trace to see what is being sent though.
SQL Server 64 and 32 can be linked to each other, in both directions,
without any problems.
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/
"Suwito Kurniawan" <suwito@.adira.co.id> wrote in message
news:#neP7OiLFHA.2764@.tk2msftngp13.phx.gbl...
> hi,
> i always set the error when i used linked server to query data from other
> server(32 bit) to my main server (64bit)
> "Server: Msg 7399, Level 16, State 1, Line 1
> OLE DB provider 'SQLOLEDB' reported an error.
> [OLE/DB provider returned message: Unspecified error]
> [OLE/DB provider returned message: The stored procedure required to
complete
> this operation could not be found on the server (they were supplied with
the
> ODBC setup disk for the SQL Server driver). Please contact your system
> administrator.]
> OLE DB error trace [OLE/DB Provider 'SQLOLEDB' IDBSchemaRowset::GetRowset
> returned 0x80004005: ]."
> do i miss something or i can using linked server in 64 bit edition?
>
> thanks,
> Suwito Kurniawan
>

can i using linked Server in mssql server 64 bit version?

hi,
i always set the error when i used linked server to query data from other
server(32 bit) to my main server (64bit)
"Server: Msg 7399, Level 16, State 1, Line 1
OLE DB provider 'SQLOLEDB' reported an error.
[OLE/DB provider returned message: Unspecified error]
[OLE/DB provider returned message: The stored procedure required to comp
lete
this operation could not be found on the server (they were supplied with the
ODBC setup disk for the SQL Server driver). Please contact your system
administrator.]
OLE DB error trace [OLE/DB Provider 'SQLOLEDB' IDBSchemaRowset::GetRowse
t
returned 0x80004005: ]."
do i miss something or i can using linked server in 64 bit edition?
thanks,
Suwito KurniawanHi
Make sure that you have MDAC 2.8 on the 32 bit machine.
You can also run a Profiler trace to see what is being sent though.
SQL Server 64 and 32 can be linked to each other, in both directions,
without any problems.
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/
"Suwito Kurniawan" <suwito@.adira.co.id> wrote in message
news:#neP7OiLFHA.2764@.tk2msftngp13.phx.gbl...
> hi,
> i always set the error when i used linked server to query data from other
> server(32 bit) to my main server (64bit)
> "Server: Msg 7399, Level 16, State 1, Line 1
> OLE DB provider 'SQLOLEDB' reported an error.
> [OLE/DB provider returned message: Unspecified error]
> [OLE/DB provider returned message: The stored procedure required to
complete
> this operation could not be found on the server (they were supplied with
the
> ODBC setup disk for the SQL Server driver). Please contact your system
> administrator.]
> OLE DB error trace [OLE/DB Provider 'SQLOLEDB' IDBSchemaRowset::GetRow
set
> returned 0x80004005: ]."
> do i miss something or i can using linked server in 64 bit edition?
>
> thanks,
> Suwito Kurniawan
>

can i using linked Server in mssql server 64 bit version?

hi,
i always set the error when i used linked server to query data from other
server(32 bit) to my main server (64bit)
"Server: Msg 7399, Level 16, State 1, Line 1
OLE DB provider 'SQLOLEDB' reported an error.
[OLE/DB provider returned message: Unspecified error]
[OLE/DB provider returned message: The stored procedure required to complete
this operation could not be found on the server (they were supplied with the
ODBC setup disk for the SQL Server driver). Please contact your system
administrator.]
OLE DB error trace [OLE/DB Provider 'SQLOLEDB' IDBSchemaRowset::GetRowset
returned 0x80004005: ]."
do i miss something or i can using linked server in 64 bit edition?
thanks,
Suwito KurniawanHi
Make sure that you have MDAC 2.8 on the 32 bit machine.
You can also run a Profiler trace to see what is being sent though.
SQL Server 64 and 32 can be linked to each other, in both directions,
without any problems.
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/
"Suwito Kurniawan" <suwito@.adira.co.id> wrote in message
news:#neP7OiLFHA.2764@.tk2msftngp13.phx.gbl...
> hi,
> i always set the error when i used linked server to query data from other
> server(32 bit) to my main server (64bit)
> "Server: Msg 7399, Level 16, State 1, Line 1
> OLE DB provider 'SQLOLEDB' reported an error.
> [OLE/DB provider returned message: Unspecified error]
> [OLE/DB provider returned message: The stored procedure required to
complete
> this operation could not be found on the server (they were supplied with
the
> ODBC setup disk for the SQL Server driver). Please contact your system
> administrator.]
> OLE DB error trace [OLE/DB Provider 'SQLOLEDB' IDBSchemaRowset::GetRowset
> returned 0x80004005: ]."
> do i miss something or i can using linked server in 64 bit edition?
>
> thanks,
> Suwito Kurniawan
>

Can I use 4 Gb memory for each instance of Standard Edition?

Hello!

I have installed SQL Server 2005 Standard Edition on 64 bit Windows 2003.

My question is if I can use more than 4 Gb Physical Memory?

Can I install another instance of SQL Server 2005 Standard Edition and use another 4 Gb Physical Memory for that instance?

Is the limitation of 4 Gb memory usage for the whole SQL Server or for each instance?

Hi Fari,

I am just curious as to why you would want multiple instances on one machine. Why dont you just have another database?|||

Hi!

It's "cheaper" to install another instance of sql server then buying another hardware and installing W2003! We are discussing differnt senarios. If buying another server is the only option, then thats the alternativ vi have to take.

|||

What is the physical memory available/installed on this server?

One of the article refers:

For 32-bit installations, the use of address windowing extensions (AWE) memory has been improved so that SQL Server 2005 Standard Edition can use more than 3GB of RAM. Also, with 64-bit processors increasingly more prolific and affordable, the benefits of 64-bit server installations are becoming much more accessible. A 64-bit architecture provides significantly larger directly addressable memory space (compared to 32-bit) for all database operations, and eliminates the need for the AWE mechanism.

|||

Hi!

We have 6 GB physical memory availabe on our 64- bit server.

I found in other places in books online that I can use as much memory as installed on the server and that I do not need to use AWE on the 64 bit server.

Is that true?

|||

Yes if its a 64 bit then need not use AWE settings.

Check on SQL Server properties about the memory settings to see how much is allocated, also run SYSMON to capture the resource usage.

|||Thanks for your help!

Can I set a default range for the identity values for merge replication?

Hello,

We have a couple of tables that can have quite a bit of data each day prior to replication. Can we increase the default values for a table for each subscription? For example we have a table called table1 and on the sqlexpress client they could enter in 10000 rows a day, on table2 it's just 100 rows a day. How can we increase the values to where we do not get the error for table1 stating that the insert failed because it conflicted with the identity range check constraint. Thanks in advance.

Hi, John

If I understand correctly, you actually want to set different identityrange from different article. For example, table1 identity range is 10,000 and table2 with identity range is 1,000. You can set it through sp_addmergearticle with control values of @.identityrangemanagementoption, @.pub_identity_range, and @.identity_range.

BTW, you are not allowed to set different identity range for different subscriptions which subscribe to the same publication.

Hope these information will help.

Thanks

Yunjing