Hi again,
I have paradox table linked in an access database. I want to migrate to SQL.
Can I link these tables in SQL ?
ThanksAccess does a better job of linking to ISAMs than SQLS does (which
uses the Jet provider). Is there any way you can migrate ALL of the
data? If linking to other ISAMs is a big part of your app, you might
be better keeping that part of it in Access/Jet. You can always link
to SQL Server tables as well.
-- Mary
Microsoft Access Developer's Guide to SQL Server
http://www.amazon.com/exec/obidos/ASIN/0672319446
On Thu, 6 Nov 2003 17:23:19 -0500, "Sylvain Provencher"
<sylvain.provencher@.nobelia.com> wrote:
>Hi again,
>I have paradox table linked in an access database. I want to migrate to SQL.
>Can I link these tables in SQL ?
>Thanks
>
Saturday, February 25, 2012
Migration ACCESS --> SQL date field
Hi,
I import an access table with date field in SQL with DTS import/export
wizard.
I got error : data overflow on date field. There is another way to do it ?In the DTS package, transform that column to varchar, and then run isdate()
against the new table to determine which rows need to be repaired.
"Sylvain Provencher" <sylvain.provencher@.nobelia.com> wrote in message
news:uZybbSLpDHA.2268@.TK2MSFTNGP12.phx.gbl...
> Hi,
> I import an access table with date field in SQL with DTS import/export
> wizard.
> I got error : data overflow on date field. There is another way to do it ?
>
I import an access table with date field in SQL with DTS import/export
wizard.
I got error : data overflow on date field. There is another way to do it ?In the DTS package, transform that column to varchar, and then run isdate()
against the new table to determine which rows need to be repaired.
"Sylvain Provencher" <sylvain.provencher@.nobelia.com> wrote in message
news:uZybbSLpDHA.2268@.TK2MSFTNGP12.phx.gbl...
> Hi,
> I import an access table with date field in SQL with DTS import/export
> wizard.
> I got error : data overflow on date field. There is another way to do it ?
>
Migration Access - Sql Server
Hi,
I am new to Sql Server.
I have a development done in MS Access, it is running on a server, splitted BE / FE and replications for we have 5 laptops that run and update the DB offline and then sync to the LAN, when they return to headquaters.
I want to migrate this to them syncing through the internet to a main BE, but I still want them to have an offline version for them to work during the day.
Can this me done in Sql Server? Can I easily re-use my Access development ?
The BE would be in a 3rds party ISP, what would my requirements be?
Cheers
Pata.
Pata,
to be honest I haven't seen the acronyms BE or FE before, but the main
principle is straightforward enough.
You could upgrade all your access instances entirely to SQL Server or you
could use heterogenous replication and have a central publisher at HO which
is SQL Server with remote subscribers which are access. Either way, we are
talking about merge replication, with pull subscriptions. As this is an
internet project, you might find this link useful:
http://support.microsoft.com/?id=321822.
Please can you post back with the BE/FE descriptions and I might then expand
on things a bit.
HTH,
Paul Ibison
I am new to Sql Server.
I have a development done in MS Access, it is running on a server, splitted BE / FE and replications for we have 5 laptops that run and update the DB offline and then sync to the LAN, when they return to headquaters.
I want to migrate this to them syncing through the internet to a main BE, but I still want them to have an offline version for them to work during the day.
Can this me done in Sql Server? Can I easily re-use my Access development ?
The BE would be in a 3rds party ISP, what would my requirements be?
Cheers
Pata.
Pata,
to be honest I haven't seen the acronyms BE or FE before, but the main
principle is straightforward enough.
You could upgrade all your access instances entirely to SQL Server or you
could use heterogenous replication and have a central publisher at HO which
is SQL Server with remote subscribers which are access. Either way, we are
talking about merge replication, with pull subscriptions. As this is an
internet project, you might find this link useful:
http://support.microsoft.com/?id=321822.
Please can you post back with the BE/FE descriptions and I might then expand
on things a bit.
HTH,
Paul Ibison
Migration 6.5 to 2000
I'm migrating sql 6.5 to 2000 on a test environnement.
Some old c++ programm are connecting to the sql server,
but they don't work after the migration to 2000 is done.
Here is an example of an error:
Catch exception at this line in the c++ programm:
PointeurProduitSet->Open(CRecordset::dynaset, strSQL,
CRecordset::none);
Yumg.exe has generated an error and will be closed..
The "scripting code page" suggested during upgrade is
1252, Is it possible that there is another code setting
in the sl6.5 server?This is a multi-part message in MIME format.
--=_NextPart_000_007C_01C35CC3.B987AAC0
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
Have you upgraded your client machines? Use your SQL Server 2000 CD to =install the Client Connectivity (MDAC) DLL's.
-- Tom
---
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinnaclepublishing.com/sql
"Jean-Francois Bouchard" <jeanfrancois_21@.hotmail.com> wrote in message =news:0a8d01c35ce2$85e07570$a501280a@.phx.gbl...
I'm migrating sql 6.5 to 2000 on a test environnement.
Some old c++ programm are connecting to the sql server, but they don't work after the migration to 2000 is done. Here is an example of an error:
Catch exception at this line in the c++ programm:
PointeurProduitSet->Open(CRecordset::dynaset, strSQL, CRecordset::none);
Yumg.exe has generated an error and will be closed..
The "scripting code page" suggested during upgrade is 1252, Is it possible that there is another code setting in the sl6.5 server?
--=_NextPart_000_007C_01C35CC3.B987AAC0
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
&
Have you upgraded your client =machines? Use your SQL Server 2000 CD to install the Client Connectivity (MDAC) DLL's.
-- Tom
---T=homas A. Moreau, BSc, PhD, MCSE, MCDBASQL Server MVPColumnist, SQL =Server ProfessionalToronto, ON Canadahttp://www.pinnaclepublishing.com/sql">www.pinnaclepublishing.com=/sql
"Jean-Francois Bouchard" wrote in message news:0a8d01c35ce2$85=e07570$a501280a@.phx.gbl...I'm migrating sql 6.5 to 2000 on a test environnement. Some =old c++ programm are connecting to the sql server, but they don't work after =the migration to 2000 is done. Here is an example of an error:Catch exception at this line in the c++ programm:PointeurProduitSet->Open(CRecordset::dynaset, strSQL, CRecordset::none);Yumg.exe has generated an error and will be closed..The "scripting code page" suggested during upgrade is =1252, Is it possible that there is another code setting in the sl6.5 server?
--=_NextPart_000_007C_01C35CC3.B987AAC0--|||I did try many things in the past like installing
different version of MDAC 2.5 and 2.7..
Right now I just installed IE5 & sql 2000 connectivity
tools from the sql server 2000 cd.. and it's not working
I get the same error as usual..
any other suggestion ?
>--Original Message--
>Have you upgraded your client machines? Use your SQL
Server 2000 CD to install the Client Connectivity (MDAC)
DLL's.
>--
>Tom
>----
--
>Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
>SQL Server MVP
>Columnist, SQL Server Professional
>Toronto, ON Canada
>www.pinnaclepublishing.com/sql
>
>"Jean-Francois Bouchard" <jeanfrancois_21@.hotmail.com>
wrote in message news:0a8d01c35ce2$85e07570
$a501280a@.phx.gbl...
>I'm migrating sql 6.5 to 2000 on a test environnement.
>Some old c++ programm are connecting to the sql server,
>but they don't work after the migration to 2000 is
done.
>Here is an example of an error:
>Catch exception at this line in the c++ programm:
>PointeurProduitSet->Open(CRecordset::dynaset, strSQL,
>CRecordset::none);
>Yumg.exe has generated an error and will be closed..
>The "scripting code page" suggested during upgrade is
>1252, Is it possible that there is another code setting
>in the sl6.5 server?
>|||This is a multi-part message in MIME format.
--=_NextPart_000_001A_01C35D0C.48ABB870
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
Not sure if the latest SP for SQL 2000 would help.
-- Tom
----
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinnaclepublishing.com/sql
.
"Jean-Francois Bouchard" <jeanfrancois_21@.hotmail.com> wrote in message =news:0b5801c35ceb$ed5cd5a0$a401280a@.phx.gbl...
I did try many things in the past like installing different version of MDAC 2.5 and 2.7..
Right now I just installed IE5 & sql 2000 connectivity tools from the sql server 2000 cd.. and it's not working I get the same error as usual..
any other suggestion ?
>--Original Message--
>Have you upgraded your client machines? Use your SQL Server 2000 CD to install the Client Connectivity (MDAC) DLL's.
>-- >Tom
>----
--
>Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
>SQL Server MVP
>Columnist, SQL Server Professional
>Toronto, ON Canada
>www.pinnaclepublishing.com/sql
>
>"Jean-Francois Bouchard" <jeanfrancois_21@.hotmail.com> wrote in message news:0a8d01c35ce2$85e07570
$a501280a@.phx.gbl...
>I'm migrating sql 6.5 to 2000 on a test environnement. >Some old c++ programm are connecting to the sql server, >but they don't work after the migration to 2000 is done. >Here is an example of an error:
>Catch exception at this line in the c++ programm:
>PointeurProduitSet->Open(CRecordset::dynaset, strSQL, >CRecordset::none);
>Yumg.exe has generated an error and will be closed..
>The "scripting code page" suggested during upgrade is >1252, Is it possible that there is another code setting >in the sl6.5 server?
>
--=_NextPart_000_001A_01C35D0C.48ABB870
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
&
Not sure if the latest SP for SQL 2000 =would help.
-- Tom
----Thomas A. =Moreau, BSc, PhD, MCSE, MCDBASQL Server MVPColumnist, SQL Server ProfessionalToronto, ON Canadahttp://www.pinnaclepublishing.com/sql">www.pinnaclepublishing.com=/sql.
"Jean-Francois Bouchard" wrote in message news:0b5801c35ceb$ed=5cd5a0$a401280a@.phx.gbl...I did try many things in the past like installing different version of =MDAC 2.5 and 2.7..Right now I just installed IE5 & sql 2000 =connectivity tools from the sql server 2000 cd.. and it's not working I get =the same error as usual..any other suggestion ? >--Original =Message-->Have you upgraded your client machines? Use =your SQL Server 2000 CD to install the Client Connectivity (MDAC) DLL's.>>-- >Tom>>---=---->Thomas A. Moreau, BSc, PhD, MCSE, MCDBA>SQL Server MVP>Columnist, =SQL Server Professional>Toronto, ON Canada>www.pinnaclepublishing.com/sql>>>"Jean=-Francois Bouchard" wrote in message news:0a8d01c35ce2$85e07570$a501280a@.phx.gbl...>I'm =migrating sql 6.5 to 2000 on a test environnement. >>Some old =c++ programm are connecting to the sql server, >but they don't work =after the migration to 2000 is done. >Here is an example of an error:>>Catch exception at this line in the c++ programm:>PointeurProduitSet->Open(CRecordset::dynaset, =strSQL, >CRecordset::none);>Yumg.exe has generated an error and =will be closed..>>The "scripting code page" suggested during =upgrade is >1252, Is it possible that there is another code setting =>in the sl6.5 server?>
--=_NextPart_000_001A_01C35D0C.48ABB870--|||Jean-Francois Bouchard (jeanfrancois_21@.hotmail.com) writes:
> I'm migrating sql 6.5 to 2000 on a test environnement.
> Some old c++ programm are connecting to the sql server,
> but they don't work after the migration to 2000 is done.
> Here is an example of an error:
> Catch exception at this line in the c++ programm:
> PointeurProduitSet->Open(CRecordset::dynaset, strSQL,
> CRecordset::none);
> Yumg.exe has generated an error and will be closed..
> The "scripting code page" suggested during upgrade is
> 1252, Is it possible that there is another code setting
> in the sl6.5 server?
It is not liklely you would get exceptions due to code-page problem. But
to review the setting on 6.5, use sp_helpsort.
What client library does the C++ programs use?
I'm afraid that you will have to debug your programs to get more
detailed information about where things go wrong.
--
Erland Sommarskog, SQL Server MVP, sommar@.algonet.se
Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinfo/productdoc/2000/books.asp|||After debugging the c++ application, I see that the
faulty line is this one:
try
{
PointeurSecuriteSet->Open
(CRecordset::dynaset, "{call sp_SelectSecurite()}",
CRecordset::none);
}
catch (CDBException *e)
The Open is failed, so it goes to the catch exception
part..
The connection to sql server is established through ODBC..
These properties are setted up before calling the open:
PointeurSecuriteSet = new (CSecuriteSet);
PointeurSecuriteSet->m_NomDsn = m_NomDsn;
PointeurSecuriteSet->m_NomUid = m_NomUid;
PointeurSecuriteSet->m_NomPwd = m_NomPwd;
I did try to trace what's happening via SQL trace, but I
didn't see the call of the stored proc
sp_selectsecurite.. any other things I can do to get it
working?
Thanks for your help!
>--Original Message--
>Jean-Francois Bouchard (jeanfrancois_21@.hotmail.com)
writes:
>> I'm migrating sql 6.5 to 2000 on a test
environnement.
>> Some old c++ programm are connecting to the sql
server,
>> but they don't work after the migration to 2000 is
done.
>> Here is an example of an error:
>> Catch exception at this line in the c++ programm:
>> PointeurProduitSet->Open(CRecordset::dynaset, strSQL,
>> CRecordset::none);
>> Yumg.exe has generated an error and will be closed..
>> The "scripting code page" suggested during upgrade is
>> 1252, Is it possible that there is another code
setting
>> in the sl6.5 server?
>It is not liklely you would get exceptions due to code-
page problem. But
>to review the setting on 6.5, use sp_helpsort.
>What client library does the C++ programs use?
>I'm afraid that you will have to debug your programs to
get more
>detailed information about where things go wrong.
>--
>Erland Sommarskog, SQL Server MVP, sommar@.algonet.se
>Books Online for SQL Server SP3 at
>http://www.microsoft.com/sql/techinfo/productdoc/2000/boo
ks.asp
>.
>|||The c++ programm was not working because the call to a
stored procedure in SQL 2000 must be without () if you
don't have parameters.
sp_SelectSecurite() must be :
sp_SelectSecurite
It's working well now.
Thanks guys
>--Original Message--
>I'm migrating sql 6.5 to 2000 on a test environnement.
>Some old c++ programm are connecting to the sql server,
>but they don't work after the migration to 2000 is
done.
>Here is an example of an error:
>Catch exception at this line in the c++ programm:
>PointeurProduitSet->Open(CRecordset::dynaset, strSQL,
>CRecordset::none);
>Yumg.exe has generated an error and will be closed..
>The "scripting code page" suggested during upgrade is
>1252, Is it possible that there is another code setting
>in the sl6.5 server?
>.
>|||Jean-Francois Bouchard (jeanfrancois_21@.hotmail.com) writes:
> After debugging the c++ application, I see that the
> faulty line is this one:
> try
> {
> PointeurSecuriteSet->Open
> (CRecordset::dynaset, "{call sp_SelectSecurite()}",
> CRecordset::none);
> }
> catch (CDBException *e)
> The Open is failed, so it goes to the catch exception
> part..
> The connection to sql server is established through ODBC..
> These properties are setted up before calling the open:
> PointeurSecuriteSet = new (CSecuriteSet);
> PointeurSecuriteSet->m_NomDsn = m_NomDsn;
> PointeurSecuriteSet->m_NomUid = m_NomUid;
> PointeurSecuriteSet->m_NomPwd = m_NomPwd;
> I did try to trace what's happening via SQL trace, but I
> didn't see the call of the stored proc
> sp_selectsecurite.. any other things I can do to get it
> working?
Does the exception come with any error message?
Since you don't see the call, it may be that things go wrong before
the call is issued.
Does the stored procedure run OK if you run it from Query Analyzer.
A general piece advice which is not likely to resolve this issue is
not use sp_ as the first letters in your procedure names. This prefix
is reserved for system procedure and SQL Server first looks in master
for these.
--
Erland Sommarskog, SQL Server MVP, sommar@.algonet.se
Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinfo/productdoc/2000/books.asp
Some old c++ programm are connecting to the sql server,
but they don't work after the migration to 2000 is done.
Here is an example of an error:
Catch exception at this line in the c++ programm:
PointeurProduitSet->Open(CRecordset::dynaset, strSQL,
CRecordset::none);
Yumg.exe has generated an error and will be closed..
The "scripting code page" suggested during upgrade is
1252, Is it possible that there is another code setting
in the sl6.5 server?This is a multi-part message in MIME format.
--=_NextPart_000_007C_01C35CC3.B987AAC0
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
Have you upgraded your client machines? Use your SQL Server 2000 CD to =install the Client Connectivity (MDAC) DLL's.
-- Tom
---
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinnaclepublishing.com/sql
"Jean-Francois Bouchard" <jeanfrancois_21@.hotmail.com> wrote in message =news:0a8d01c35ce2$85e07570$a501280a@.phx.gbl...
I'm migrating sql 6.5 to 2000 on a test environnement.
Some old c++ programm are connecting to the sql server, but they don't work after the migration to 2000 is done. Here is an example of an error:
Catch exception at this line in the c++ programm:
PointeurProduitSet->Open(CRecordset::dynaset, strSQL, CRecordset::none);
Yumg.exe has generated an error and will be closed..
The "scripting code page" suggested during upgrade is 1252, Is it possible that there is another code setting in the sl6.5 server?
--=_NextPart_000_007C_01C35CC3.B987AAC0
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
&
Have you upgraded your client =machines? Use your SQL Server 2000 CD to install the Client Connectivity (MDAC) DLL's.
-- Tom
---T=homas A. Moreau, BSc, PhD, MCSE, MCDBASQL Server MVPColumnist, SQL =Server ProfessionalToronto, ON Canadahttp://www.pinnaclepublishing.com/sql">www.pinnaclepublishing.com=/sql
"Jean-Francois Bouchard"
--=_NextPart_000_007C_01C35CC3.B987AAC0--|||I did try many things in the past like installing
different version of MDAC 2.5 and 2.7..
Right now I just installed IE5 & sql 2000 connectivity
tools from the sql server 2000 cd.. and it's not working
I get the same error as usual..
any other suggestion ?
>--Original Message--
>Have you upgraded your client machines? Use your SQL
Server 2000 CD to install the Client Connectivity (MDAC)
DLL's.
>--
>Tom
>----
--
>Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
>SQL Server MVP
>Columnist, SQL Server Professional
>Toronto, ON Canada
>www.pinnaclepublishing.com/sql
>
>"Jean-Francois Bouchard" <jeanfrancois_21@.hotmail.com>
wrote in message news:0a8d01c35ce2$85e07570
$a501280a@.phx.gbl...
>I'm migrating sql 6.5 to 2000 on a test environnement.
>Some old c++ programm are connecting to the sql server,
>but they don't work after the migration to 2000 is
done.
>Here is an example of an error:
>Catch exception at this line in the c++ programm:
>PointeurProduitSet->Open(CRecordset::dynaset, strSQL,
>CRecordset::none);
>Yumg.exe has generated an error and will be closed..
>The "scripting code page" suggested during upgrade is
>1252, Is it possible that there is another code setting
>in the sl6.5 server?
>|||This is a multi-part message in MIME format.
--=_NextPart_000_001A_01C35D0C.48ABB870
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
Not sure if the latest SP for SQL 2000 would help.
-- Tom
----
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinnaclepublishing.com/sql
.
"Jean-Francois Bouchard" <jeanfrancois_21@.hotmail.com> wrote in message =news:0b5801c35ceb$ed5cd5a0$a401280a@.phx.gbl...
I did try many things in the past like installing different version of MDAC 2.5 and 2.7..
Right now I just installed IE5 & sql 2000 connectivity tools from the sql server 2000 cd.. and it's not working I get the same error as usual..
any other suggestion ?
>--Original Message--
>Have you upgraded your client machines? Use your SQL Server 2000 CD to install the Client Connectivity (MDAC) DLL's.
>-- >Tom
>----
--
>Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
>SQL Server MVP
>Columnist, SQL Server Professional
>Toronto, ON Canada
>www.pinnaclepublishing.com/sql
>
>"Jean-Francois Bouchard" <jeanfrancois_21@.hotmail.com> wrote in message news:0a8d01c35ce2$85e07570
$a501280a@.phx.gbl...
>I'm migrating sql 6.5 to 2000 on a test environnement. >Some old c++ programm are connecting to the sql server, >but they don't work after the migration to 2000 is done. >Here is an example of an error:
>Catch exception at this line in the c++ programm:
>PointeurProduitSet->Open(CRecordset::dynaset, strSQL, >CRecordset::none);
>Yumg.exe has generated an error and will be closed..
>The "scripting code page" suggested during upgrade is >1252, Is it possible that there is another code setting >in the sl6.5 server?
>
--=_NextPart_000_001A_01C35D0C.48ABB870
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
&
Not sure if the latest SP for SQL 2000 =would help.
-- Tom
----Thomas A. =Moreau, BSc, PhD, MCSE, MCDBASQL Server MVPColumnist, SQL Server ProfessionalToronto, ON Canadahttp://www.pinnaclepublishing.com/sql">www.pinnaclepublishing.com=/sql.
"Jean-Francois Bouchard"
--=_NextPart_000_001A_01C35D0C.48ABB870--|||Jean-Francois Bouchard (jeanfrancois_21@.hotmail.com) writes:
> I'm migrating sql 6.5 to 2000 on a test environnement.
> Some old c++ programm are connecting to the sql server,
> but they don't work after the migration to 2000 is done.
> Here is an example of an error:
> Catch exception at this line in the c++ programm:
> PointeurProduitSet->Open(CRecordset::dynaset, strSQL,
> CRecordset::none);
> Yumg.exe has generated an error and will be closed..
> The "scripting code page" suggested during upgrade is
> 1252, Is it possible that there is another code setting
> in the sl6.5 server?
It is not liklely you would get exceptions due to code-page problem. But
to review the setting on 6.5, use sp_helpsort.
What client library does the C++ programs use?
I'm afraid that you will have to debug your programs to get more
detailed information about where things go wrong.
--
Erland Sommarskog, SQL Server MVP, sommar@.algonet.se
Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinfo/productdoc/2000/books.asp|||After debugging the c++ application, I see that the
faulty line is this one:
try
{
PointeurSecuriteSet->Open
(CRecordset::dynaset, "{call sp_SelectSecurite()}",
CRecordset::none);
}
catch (CDBException *e)
The Open is failed, so it goes to the catch exception
part..
The connection to sql server is established through ODBC..
These properties are setted up before calling the open:
PointeurSecuriteSet = new (CSecuriteSet);
PointeurSecuriteSet->m_NomDsn = m_NomDsn;
PointeurSecuriteSet->m_NomUid = m_NomUid;
PointeurSecuriteSet->m_NomPwd = m_NomPwd;
I did try to trace what's happening via SQL trace, but I
didn't see the call of the stored proc
sp_selectsecurite.. any other things I can do to get it
working?
Thanks for your help!
>--Original Message--
>Jean-Francois Bouchard (jeanfrancois_21@.hotmail.com)
writes:
>> I'm migrating sql 6.5 to 2000 on a test
environnement.
>> Some old c++ programm are connecting to the sql
server,
>> but they don't work after the migration to 2000 is
done.
>> Here is an example of an error:
>> Catch exception at this line in the c++ programm:
>> PointeurProduitSet->Open(CRecordset::dynaset, strSQL,
>> CRecordset::none);
>> Yumg.exe has generated an error and will be closed..
>> The "scripting code page" suggested during upgrade is
>> 1252, Is it possible that there is another code
setting
>> in the sl6.5 server?
>It is not liklely you would get exceptions due to code-
page problem. But
>to review the setting on 6.5, use sp_helpsort.
>What client library does the C++ programs use?
>I'm afraid that you will have to debug your programs to
get more
>detailed information about where things go wrong.
>--
>Erland Sommarskog, SQL Server MVP, sommar@.algonet.se
>Books Online for SQL Server SP3 at
>http://www.microsoft.com/sql/techinfo/productdoc/2000/boo
ks.asp
>.
>|||The c++ programm was not working because the call to a
stored procedure in SQL 2000 must be without () if you
don't have parameters.
sp_SelectSecurite() must be :
sp_SelectSecurite
It's working well now.
Thanks guys
>--Original Message--
>I'm migrating sql 6.5 to 2000 on a test environnement.
>Some old c++ programm are connecting to the sql server,
>but they don't work after the migration to 2000 is
done.
>Here is an example of an error:
>Catch exception at this line in the c++ programm:
>PointeurProduitSet->Open(CRecordset::dynaset, strSQL,
>CRecordset::none);
>Yumg.exe has generated an error and will be closed..
>The "scripting code page" suggested during upgrade is
>1252, Is it possible that there is another code setting
>in the sl6.5 server?
>.
>|||Jean-Francois Bouchard (jeanfrancois_21@.hotmail.com) writes:
> After debugging the c++ application, I see that the
> faulty line is this one:
> try
> {
> PointeurSecuriteSet->Open
> (CRecordset::dynaset, "{call sp_SelectSecurite()}",
> CRecordset::none);
> }
> catch (CDBException *e)
> The Open is failed, so it goes to the catch exception
> part..
> The connection to sql server is established through ODBC..
> These properties are setted up before calling the open:
> PointeurSecuriteSet = new (CSecuriteSet);
> PointeurSecuriteSet->m_NomDsn = m_NomDsn;
> PointeurSecuriteSet->m_NomUid = m_NomUid;
> PointeurSecuriteSet->m_NomPwd = m_NomPwd;
> I did try to trace what's happening via SQL trace, but I
> didn't see the call of the stored proc
> sp_selectsecurite.. any other things I can do to get it
> working?
Does the exception come with any error message?
Since you don't see the call, it may be that things go wrong before
the call is issued.
Does the stored procedure run OK if you run it from Query Analyzer.
A general piece advice which is not likely to resolve this issue is
not use sp_ as the first letters in your procedure names. This prefix
is reserved for system procedure and SQL Server first looks in master
for these.
--
Erland Sommarskog, SQL Server MVP, sommar@.algonet.se
Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinfo/productdoc/2000/books.asp
Migration 2005 beta to 2005 release
Hi Group,
Three quick questions about the 2005 beta.
1) Is it likely that restoring a 2005 beta database backup to a 2005
release environment (when it is released) will produce errors?
2) Will the .Net framework 1.1 be able to call SQL server 2005 beta
stored procedures?
3) Can I use Visual Studio .Net 1.1 to administer a SQL Server 2005
beta environment?
Cheers,
Stewart"Stewart" <windsurfing_stew@.yahoo.com.au> schrieb im Newsbeitrag
news:3e8a4d01.0504282031.4c10b786@.posting.google.com...
> Hi Group,
> Three quick questions about the 2005 beta.
> 1) Is it likely that restoring a 2005 beta database backup to a 2005
> release environment (when it is released) will produce errors?
There will be an whitepaper for the tap customers,perhpas that will be for
public download for release.
> 2) Will the .Net framework 1.1 be able to call SQL server 2005 beta
> stored procedures?
Sure.
> 3) Can I use Visual Studio .Net 1.1 to administer a SQL Server 2005
> beta environment?
Not sure, but I think thats possible, you only need to have to SQL Native
Client installed. I will try it on my box later.
> Cheers,
> Stewart
HTH, Jens Suessmeyer.
http://www.sqlserver2005.de
--|||Hi
Just be aware, ADO.NET 1.1 does not support the new datatypes that exist in
SQL Server 2005.
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Stewart" wrote:
> Hi Group,
> Three quick questions about the 2005 beta.
> 1) Is it likely that restoring a 2005 beta database backup to a 2005
> release environment (when it is released) will produce errors?
> 2) Will the .Net framework 1.1 be able to call SQL server 2005 beta
> stored procedures?
> 3) Can I use Visual Studio .Net 1.1 to administer a SQL Server 2005
> beta environment?
> Cheers,
> Stewart
>
Three quick questions about the 2005 beta.
1) Is it likely that restoring a 2005 beta database backup to a 2005
release environment (when it is released) will produce errors?
2) Will the .Net framework 1.1 be able to call SQL server 2005 beta
stored procedures?
3) Can I use Visual Studio .Net 1.1 to administer a SQL Server 2005
beta environment?
Cheers,
Stewart"Stewart" <windsurfing_stew@.yahoo.com.au> schrieb im Newsbeitrag
news:3e8a4d01.0504282031.4c10b786@.posting.google.com...
> Hi Group,
> Three quick questions about the 2005 beta.
> 1) Is it likely that restoring a 2005 beta database backup to a 2005
> release environment (when it is released) will produce errors?
There will be an whitepaper for the tap customers,perhpas that will be for
public download for release.
> 2) Will the .Net framework 1.1 be able to call SQL server 2005 beta
> stored procedures?
Sure.
> 3) Can I use Visual Studio .Net 1.1 to administer a SQL Server 2005
> beta environment?
Not sure, but I think thats possible, you only need to have to SQL Native
Client installed. I will try it on my box later.
> Cheers,
> Stewart
HTH, Jens Suessmeyer.
http://www.sqlserver2005.de
--|||Hi
Just be aware, ADO.NET 1.1 does not support the new datatypes that exist in
SQL Server 2005.
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Stewart" wrote:
> Hi Group,
> Three quick questions about the 2005 beta.
> 1) Is it likely that restoring a 2005 beta database backup to a 2005
> release environment (when it is released) will produce errors?
> 2) Will the .Net framework 1.1 be able to call SQL server 2005 beta
> stored procedures?
> 3) Can I use Visual Studio .Net 1.1 to administer a SQL Server 2005
> beta environment?
> Cheers,
> Stewart
>
Migration 2005 beta to 2005 release
Hi Group,
Three quick questions about the 2005 beta.
1) Is it likely that restoring a 2005 beta database backup to a 2005
release environment (when it is released) will produce errors?
2) Will the .Net framework 1.1 be able to call SQL server 2005 beta
stored procedures?
3) Can I use Visual Studio .Net 1.1 to administer a SQL Server 2005
beta environment?
Cheers,
Stewart
"Stewart" <windsurfing_stew@.yahoo.com.au> schrieb im Newsbeitrag
news:3e8a4d01.0504282031.4c10b786@.posting.google.c om...
> Hi Group,
> Three quick questions about the 2005 beta.
> 1) Is it likely that restoring a 2005 beta database backup to a 2005
> release environment (when it is released) will produce errors?
There will be an whitepaper for the tap customers,perhpas that will be for
public download for release.
> 2) Will the .Net framework 1.1 be able to call SQL server 2005 beta
> stored procedures?
Sure.
> 3) Can I use Visual Studio .Net 1.1 to administer a SQL Server 2005
> beta environment?
Not sure, but I think thats possible, you only need to have to SQL Native
Client installed. I will try it on my box later.
> Cheers,
> Stewart
HTH, Jens Suessmeyer.
http://www.sqlserver2005.de
|||Hi
Just be aware, ADO.NET 1.1 does not support the new datatypes that exist in
SQL Server 2005.
Regards
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Stewart" wrote:
> Hi Group,
> Three quick questions about the 2005 beta.
> 1) Is it likely that restoring a 2005 beta database backup to a 2005
> release environment (when it is released) will produce errors?
> 2) Will the .Net framework 1.1 be able to call SQL server 2005 beta
> stored procedures?
> 3) Can I use Visual Studio .Net 1.1 to administer a SQL Server 2005
> beta environment?
> Cheers,
> Stewart
>
Three quick questions about the 2005 beta.
1) Is it likely that restoring a 2005 beta database backup to a 2005
release environment (when it is released) will produce errors?
2) Will the .Net framework 1.1 be able to call SQL server 2005 beta
stored procedures?
3) Can I use Visual Studio .Net 1.1 to administer a SQL Server 2005
beta environment?
Cheers,
Stewart
"Stewart" <windsurfing_stew@.yahoo.com.au> schrieb im Newsbeitrag
news:3e8a4d01.0504282031.4c10b786@.posting.google.c om...
> Hi Group,
> Three quick questions about the 2005 beta.
> 1) Is it likely that restoring a 2005 beta database backup to a 2005
> release environment (when it is released) will produce errors?
There will be an whitepaper for the tap customers,perhpas that will be for
public download for release.
> 2) Will the .Net framework 1.1 be able to call SQL server 2005 beta
> stored procedures?
Sure.
> 3) Can I use Visual Studio .Net 1.1 to administer a SQL Server 2005
> beta environment?
Not sure, but I think thats possible, you only need to have to SQL Native
Client installed. I will try it on my box later.
> Cheers,
> Stewart
HTH, Jens Suessmeyer.
http://www.sqlserver2005.de
|||Hi
Just be aware, ADO.NET 1.1 does not support the new datatypes that exist in
SQL Server 2005.
Regards
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Stewart" wrote:
> Hi Group,
> Three quick questions about the 2005 beta.
> 1) Is it likely that restoring a 2005 beta database backup to a 2005
> release environment (when it is released) will produce errors?
> 2) Will the .Net framework 1.1 be able to call SQL server 2005 beta
> stored procedures?
> 3) Can I use Visual Studio .Net 1.1 to administer a SQL Server 2005
> beta environment?
> Cheers,
> Stewart
>
Migration 2005 beta to 2005 release
Hi Group,
Three quick questions about the 2005 beta.
1) Is it likely that restoring a 2005 beta database backup to a 2005
release environment (when it is released) will produce errors?
2) Will the .Net framework 1.1 be able to call SQL server 2005 beta
stored procedures?
3) Can I use Visual Studio .Net 1.1 to administer a SQL Server 2005
beta environment?
Cheers,
Stewart"Stewart" <windsurfing_stew@.yahoo.com.au> schrieb im Newsbeitrag
news:3e8a4d01.0504282031.4c10b786@.posting.google.com...
> Hi Group,
> Three quick questions about the 2005 beta.
> 1) Is it likely that restoring a 2005 beta database backup to a 2005
> release environment (when it is released) will produce errors?
There will be an whitepaper for the tap customers,perhpas that will be for
public download for release.
> 2) Will the .Net framework 1.1 be able to call SQL server 2005 beta
> stored procedures?
Sure.
> 3) Can I use Visual Studio .Net 1.1 to administer a SQL Server 2005
> beta environment?
Not sure, but I think thats possible, you only need to have to SQL Native
Client installed. I will try it on my box later.
> Cheers,
> Stewart
HTH, Jens Suessmeyer.
--
http://www.sqlserver2005.de
--|||Hi
Just be aware, ADO.NET 1.1 does not support the new datatypes that exist in
SQL Server 2005.
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Stewart" wrote:
> Hi Group,
> Three quick questions about the 2005 beta.
> 1) Is it likely that restoring a 2005 beta database backup to a 2005
> release environment (when it is released) will produce errors?
> 2) Will the .Net framework 1.1 be able to call SQL server 2005 beta
> stored procedures?
> 3) Can I use Visual Studio .Net 1.1 to administer a SQL Server 2005
> beta environment?
> Cheers,
> Stewart
>
Three quick questions about the 2005 beta.
1) Is it likely that restoring a 2005 beta database backup to a 2005
release environment (when it is released) will produce errors?
2) Will the .Net framework 1.1 be able to call SQL server 2005 beta
stored procedures?
3) Can I use Visual Studio .Net 1.1 to administer a SQL Server 2005
beta environment?
Cheers,
Stewart"Stewart" <windsurfing_stew@.yahoo.com.au> schrieb im Newsbeitrag
news:3e8a4d01.0504282031.4c10b786@.posting.google.com...
> Hi Group,
> Three quick questions about the 2005 beta.
> 1) Is it likely that restoring a 2005 beta database backup to a 2005
> release environment (when it is released) will produce errors?
There will be an whitepaper for the tap customers,perhpas that will be for
public download for release.
> 2) Will the .Net framework 1.1 be able to call SQL server 2005 beta
> stored procedures?
Sure.
> 3) Can I use Visual Studio .Net 1.1 to administer a SQL Server 2005
> beta environment?
Not sure, but I think thats possible, you only need to have to SQL Native
Client installed. I will try it on my box later.
> Cheers,
> Stewart
HTH, Jens Suessmeyer.
--
http://www.sqlserver2005.de
--|||Hi
Just be aware, ADO.NET 1.1 does not support the new datatypes that exist in
SQL Server 2005.
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Stewart" wrote:
> Hi Group,
> Three quick questions about the 2005 beta.
> 1) Is it likely that restoring a 2005 beta database backup to a 2005
> release environment (when it is released) will produce errors?
> 2) Will the .Net framework 1.1 be able to call SQL server 2005 beta
> stored procedures?
> 3) Can I use Visual Studio .Net 1.1 to administer a SQL Server 2005
> beta environment?
> Cheers,
> Stewart
>
Subscribe to:
Posts (Atom)