I'm having a bit of trouble updating my script. I have a
script used for MS Access and I need to transfer it to be
compatible with MS SQL Server. When I run the script it
gives the error ''ODBC driver does not support the
requested properties.'' This is the line of the script
that I have to change to work with access:
''oRS.Open SqlTxt , oConn'' and the sql text is
:''Sqltxt = "SELECT MasterServer, Max(JobId) AS MaxJobId
FROM Jobs GROUP BY MasterServer ORDER BY MasterServer;".
Could anybody please help me out in solving this problem?
Cette action est irreversible, confirmez la suppression du commentaire ?
Signaler le commentaire
Veuillez sélectionner un problème
Nudité
Violence
Harcèlement
Fraude
Vente illégale
Discours haineux
Terrorisme
Autre
Sylvain Lafontaine
First, you should ask about your problem in an english discussion group, like microsoft.public.sqlserver.programming. This one is for french people.
Second, you should probably use OLEDB Driver for SQL-Server instead of ODBC but I'm not sure, as I don't know from what software (Access with DAO, Access with OLEDB, ASP, etc.) you are making your calls.
Finally, remove the « ; » at the end of your statement. It is also possible that your table Jobs has been created with an owner other than dbo, so you may try by putting the owner name before the name of the table. For example with OwnerName:
SELECT MasterServer, Max(JobId) AS MaxJobId FROM OwnerName.Jobs GROUP BY MasterServer ORDER BY MasterServer
S. L.
"Will" wrote in message news:23c8401c45eb8$fa08ca50$
Hi Folks,
I'm having a bit of trouble updating my script. I have a script used for MS Access and I need to transfer it to be compatible with MS SQL Server. When I run the script it gives the error ''ODBC driver does not support the requested properties.'' This is the line of the script that I have to change to work with access: ''oRS.Open SqlTxt , oConn'' and the sql text is :''Sqltxt = "SELECT MasterServer, Max(JobId) AS MaxJobId FROM Jobs GROUP BY MasterServer ORDER BY MasterServer;". Could anybody please help me out in solving this problem?
Cheers!
First, you should ask about your problem in an english discussion group,
like microsoft.public.sqlserver.programming. This one is for french people.
Second, you should probably use OLEDB Driver for SQL-Server instead of ODBC
but I'm not sure, as I don't know from what software (Access with DAO,
Access with OLEDB, ASP, etc.) you are making your calls.
Finally, remove the « ; » at the end of your statement. It is also possible
that your table Jobs has been created with an owner other than dbo, so you
may try by putting the owner name before the name of the table. For example
with OwnerName:
SELECT MasterServer, Max(JobId) AS MaxJobId FROM OwnerName.Jobs GROUP BY
MasterServer ORDER BY MasterServer
S. L.
"Will" <anonymous@discussions.microsoft.com> wrote in message
news:23c8401c45eb8$fa08ca50$a501280a@phx.gbl...
Hi Folks,
I'm having a bit of trouble updating my script. I have a
script used for MS Access and I need to transfer it to be
compatible with MS SQL Server. When I run the script it
gives the error ''ODBC driver does not support the
requested properties.'' This is the line of the script
that I have to change to work with access:
''oRS.Open SqlTxt , oConn'' and the sql text is
:''Sqltxt = "SELECT MasterServer, Max(JobId) AS MaxJobId
FROM Jobs GROUP BY MasterServer ORDER BY MasterServer;".
Could anybody please help me out in solving this problem?
First, you should ask about your problem in an english discussion group, like microsoft.public.sqlserver.programming. This one is for french people.
Second, you should probably use OLEDB Driver for SQL-Server instead of ODBC but I'm not sure, as I don't know from what software (Access with DAO, Access with OLEDB, ASP, etc.) you are making your calls.
Finally, remove the « ; » at the end of your statement. It is also possible that your table Jobs has been created with an owner other than dbo, so you may try by putting the owner name before the name of the table. For example with OwnerName:
SELECT MasterServer, Max(JobId) AS MaxJobId FROM OwnerName.Jobs GROUP BY MasterServer ORDER BY MasterServer
S. L.
"Will" wrote in message news:23c8401c45eb8$fa08ca50$
Hi Folks,
I'm having a bit of trouble updating my script. I have a script used for MS Access and I need to transfer it to be compatible with MS SQL Server. When I run the script it gives the error ''ODBC driver does not support the requested properties.'' This is the line of the script that I have to change to work with access: ''oRS.Open SqlTxt , oConn'' and the sql text is :''Sqltxt = "SELECT MasterServer, Max(JobId) AS MaxJobId FROM Jobs GROUP BY MasterServer ORDER BY MasterServer;". Could anybody please help me out in solving this problem?
Cheers!
William
G'Day
I tried your tips but none of them worked. The problem really is oRS.Open SqlTxt , oConn because the error is in that line. If that was originally for access and I want to use that function with SQL Server I have to change a term because when I run the script it dosen't want to open.
Cheers!
-----Message d'origine----- First, you should ask about your problem in an english
discussion group,
like microsoft.public.sqlserver.programming. This one
is for french people.
Second, you should probably use OLEDB Driver for SQL-
Server instead of ODBC
but I'm not sure, as I don't know from what software
(Access with DAO,
Access with OLEDB, ASP, etc.) you are making your calls.
Finally, remove the « ; » at the end of your statement.
It is also possible
that your table Jobs has been created with an owner
other than dbo, so you
may try by putting the owner name before the name of the
table. For example
with OwnerName:
SELECT MasterServer, Max(JobId) AS MaxJobId FROM
OwnerName.Jobs GROUP BY
MasterServer ORDER BY MasterServer
S. L.
"Will" wrote in
message
news:23c8401c45eb8$fa08ca50$
Hi Folks,
I'm having a bit of trouble updating my script. I have
a
script used for MS Access and I need to transfer it to
be
compatible with MS SQL Server. When I run the script it gives the error ''ODBC driver does not support the requested properties.'' This is the line of the script that I have to change to work with access: ''oRS.Open SqlTxt , oConn'' and the sql text is :''Sqltxt = "SELECT MasterServer, Max(JobId) AS
MaxJobId
FROM Jobs GROUP BY MasterServer ORDER BY
MasterServer;".
Could anybody please help me out in solving this
problem?
Cheers!
.
G'Day
I tried your tips but none of them worked. The problem
really is oRS.Open SqlTxt , oConn because the error is in
that line. If that was originally for access and I want
to use that function with SQL Server I have to change a
term because when I run the script it dosen't want to
open.
Cheers!
-----Message d'origine-----
First, you should ask about your problem in an english
discussion group,
like microsoft.public.sqlserver.programming. This one
is for french people.
Second, you should probably use OLEDB Driver for SQL-
Server instead of ODBC
but I'm not sure, as I don't know from what software
(Access with DAO,
Access with OLEDB, ASP, etc.) you are making your calls.
Finally, remove the « ; » at the end of your statement.
It is also possible
that your table Jobs has been created with an owner
other than dbo, so you
may try by putting the owner name before the name of the
table. For example
with OwnerName:
SELECT MasterServer, Max(JobId) AS MaxJobId FROM
OwnerName.Jobs GROUP BY
MasterServer ORDER BY MasterServer
S. L.
"Will" <anonymous@discussions.microsoft.com> wrote in
message
news:23c8401c45eb8$fa08ca50$a501280a@phx.gbl...
Hi Folks,
I'm having a bit of trouble updating my script. I have
a
script used for MS Access and I need to transfer it to
be
compatible with MS SQL Server. When I run the script it
gives the error ''ODBC driver does not support the
requested properties.'' This is the line of the script
that I have to change to work with access:
''oRS.Open SqlTxt , oConn'' and the sql text is
:''Sqltxt = "SELECT MasterServer, Max(JobId) AS
I tried your tips but none of them worked. The problem really is oRS.Open SqlTxt , oConn because the error is in that line. If that was originally for access and I want to use that function with SQL Server I have to change a term because when I run the script it dosen't want to open.
Cheers!
-----Message d'origine----- First, you should ask about your problem in an english
discussion group,
like microsoft.public.sqlserver.programming. This one
is for french people.
Second, you should probably use OLEDB Driver for SQL-
Server instead of ODBC
but I'm not sure, as I don't know from what software
(Access with DAO,
Access with OLEDB, ASP, etc.) you are making your calls.
Finally, remove the « ; » at the end of your statement.
It is also possible
that your table Jobs has been created with an owner
other than dbo, so you
may try by putting the owner name before the name of the
table. For example
with OwnerName:
SELECT MasterServer, Max(JobId) AS MaxJobId FROM
OwnerName.Jobs GROUP BY
MasterServer ORDER BY MasterServer
S. L.
"Will" wrote in
message
news:23c8401c45eb8$fa08ca50$
Hi Folks,
I'm having a bit of trouble updating my script. I have
a
script used for MS Access and I need to transfer it to
be
compatible with MS SQL Server. When I run the script it gives the error ''ODBC driver does not support the requested properties.'' This is the line of the script that I have to change to work with access: ''oRS.Open SqlTxt , oConn'' and the sql text is :''Sqltxt = "SELECT MasterServer, Max(JobId) AS
MaxJobId
FROM Jobs GROUP BY MasterServer ORDER BY
MasterServer;".
Could anybody please help me out in solving this
problem?
Cheers!
.
Sylvain Lafontaine
Then you should give us as much details as possible about your script for helping in resolving your problem; as the error may come from something before the attempted opening of the recordset. For exemple, it is quite possible that your connection to the SQL-Server is not correctly opened.
Also, if you have Enterprise Manager installed on your machine, you can open a SQL Query Analyser session and try your query directly to the database.
S. L.
"William" wrote in message news:23e5601c45ed6$c404d5c0$ G'Day
I tried your tips but none of them worked. The problem really is oRS.Open SqlTxt , oConn because the error is in that line. If that was originally for access and I want to use that function with SQL Server I have to change a term because when I run the script it dosen't want to open.
Cheers!
-----Message d'origine----- First, you should ask about your problem in an english
discussion group,
like microsoft.public.sqlserver.programming. This one
is for french people.
Second, you should probably use OLEDB Driver for SQL-
Server instead of ODBC
but I'm not sure, as I don't know from what software
(Access with DAO,
Access with OLEDB, ASP, etc.) you are making your calls.
Finally, remove the « ; » at the end of your statement.
It is also possible
that your table Jobs has been created with an owner
other than dbo, so you
may try by putting the owner name before the name of the
table. For example
with OwnerName:
SELECT MasterServer, Max(JobId) AS MaxJobId FROM
OwnerName.Jobs GROUP BY
MasterServer ORDER BY MasterServer
S. L.
"Will" wrote in
message
news:23c8401c45eb8$fa08ca50$
Hi Folks,
I'm having a bit of trouble updating my script. I have
a
script used for MS Access and I need to transfer it to
be
compatible with MS SQL Server. When I run the script it gives the error ''ODBC driver does not support the requested properties.'' This is the line of the script that I have to change to work with access: ''oRS.Open SqlTxt , oConn'' and the sql text is :''Sqltxt = "SELECT MasterServer, Max(JobId) AS
MaxJobId
FROM Jobs GROUP BY MasterServer ORDER BY
MasterServer;".
Could anybody please help me out in solving this
problem?
Cheers!
.
Then you should give us as much details as possible about your script for
helping in resolving your problem; as the error may come from something
before the attempted opening of the recordset. For exemple, it is quite
possible that your connection to the SQL-Server is not correctly opened.
Also, if you have Enterprise Manager installed on your machine, you can open
a SQL Query Analyser session and try your query directly to the database.
S. L.
"William" <anonymous@discussions.microsoft.com> wrote in message
news:23e5601c45ed6$c404d5c0$a401280a@phx.gbl...
G'Day
I tried your tips but none of them worked. The problem
really is oRS.Open SqlTxt , oConn because the error is in
that line. If that was originally for access and I want
to use that function with SQL Server I have to change a
term because when I run the script it dosen't want to
open.
Cheers!
-----Message d'origine-----
First, you should ask about your problem in an english
discussion group,
like microsoft.public.sqlserver.programming. This one
is for french people.
Second, you should probably use OLEDB Driver for SQL-
Server instead of ODBC
but I'm not sure, as I don't know from what software
(Access with DAO,
Access with OLEDB, ASP, etc.) you are making your calls.
Finally, remove the « ; » at the end of your statement.
It is also possible
that your table Jobs has been created with an owner
other than dbo, so you
may try by putting the owner name before the name of the
table. For example
with OwnerName:
SELECT MasterServer, Max(JobId) AS MaxJobId FROM
OwnerName.Jobs GROUP BY
MasterServer ORDER BY MasterServer
S. L.
"Will" <anonymous@discussions.microsoft.com> wrote in
message
news:23c8401c45eb8$fa08ca50$a501280a@phx.gbl...
Hi Folks,
I'm having a bit of trouble updating my script. I have
a
script used for MS Access and I need to transfer it to
be
compatible with MS SQL Server. When I run the script it
gives the error ''ODBC driver does not support the
requested properties.'' This is the line of the script
that I have to change to work with access:
''oRS.Open SqlTxt , oConn'' and the sql text is
:''Sqltxt = "SELECT MasterServer, Max(JobId) AS
Then you should give us as much details as possible about your script for helping in resolving your problem; as the error may come from something before the attempted opening of the recordset. For exemple, it is quite possible that your connection to the SQL-Server is not correctly opened.
Also, if you have Enterprise Manager installed on your machine, you can open a SQL Query Analyser session and try your query directly to the database.
S. L.
"William" wrote in message news:23e5601c45ed6$c404d5c0$ G'Day
I tried your tips but none of them worked. The problem really is oRS.Open SqlTxt , oConn because the error is in that line. If that was originally for access and I want to use that function with SQL Server I have to change a term because when I run the script it dosen't want to open.
Cheers!
-----Message d'origine----- First, you should ask about your problem in an english
discussion group,
like microsoft.public.sqlserver.programming. This one
is for french people.
Second, you should probably use OLEDB Driver for SQL-
Server instead of ODBC
but I'm not sure, as I don't know from what software
(Access with DAO,
Access with OLEDB, ASP, etc.) you are making your calls.
Finally, remove the « ; » at the end of your statement.
It is also possible
that your table Jobs has been created with an owner
other than dbo, so you
may try by putting the owner name before the name of the
table. For example
with OwnerName:
SELECT MasterServer, Max(JobId) AS MaxJobId FROM
OwnerName.Jobs GROUP BY
MasterServer ORDER BY MasterServer
S. L.
"Will" wrote in
message
news:23c8401c45eb8$fa08ca50$
Hi Folks,
I'm having a bit of trouble updating my script. I have
a
script used for MS Access and I need to transfer it to
be
compatible with MS SQL Server. When I run the script it gives the error ''ODBC driver does not support the requested properties.'' This is the line of the script that I have to change to work with access: ''oRS.Open SqlTxt , oConn'' and the sql text is :''Sqltxt = "SELECT MasterServer, Max(JobId) AS
