location of ODBC drivers for SQL 2k5 x64 in Win Server 2003 x64 ST

Hi,
I've got Win Server 2003 Standard 64bit edition trying to work with SQL 2005
standard 64bit edition however there is a problem.
I need to locate the ODBC driver in Win Ser.
I know where they are in the 32bit edition but not in the 64bit version.
can anyone help?
Thanks
Olgun.Ucurel@.ccsmedia.comIs there a 64 bit ODBC Driver? I didnt think that there was. You might have
to compile your application in x86 or if you are using SSIS or DTS exec you
can use this post...
http://forums.microsoft.com/MSDN/Sh...603814&SiteID=1
Can you use the OLE DB Driver?
C:\WINDOWS\SysWOW64\odbcad32.exe
uses...
odbc32.dll
and
C:\WINDOWS\System32\odbcad32.exe
uses
odbc32.dll
I am sure others will have some thoughts as well.
/*
Warren Brunk - MCITP - SQL 2005, MCDBA
www.techintsolutions.com
*/
"Olgun" <Olgun@.discussions.microsoft.com> wrote in message
news:9BA59FAC-D013-4BF4-9700-A97D71D65545@.microsoft.com...
> Hi,
> I've got Win Server 2003 Standard 64bit edition trying to work with SQL
> 2005
> standard 64bit edition however there is a problem.
> I need to locate the ODBC driver in Win Ser.
> I know where they are in the 32bit edition but not in the 64bit version.
> can anyone help?
> Thanks
> Olgun.Ucurel@.ccsmedia.com|||Olgun wrote:
> Hi,
> I've got Win Server 2003 Standard 64bit edition trying to work with SQL 20
05
> standard 64bit edition however there is a problem.
> I need to locate the ODBC driver in Win Ser.
> I know where they are in the 32bit edition but not in the 64bit version.
> can anyone help?
> Thanks
> Olgun.Ucurel@.ccsmedia.com
As far as I know the ODBC driver is not working on 64 bits Windows. You
could use OLEDB instead, which is working fine.
Regards,
lucm

location of ODBC drivers for SQL 2k5 x64 in Win Server 2003 x64 ST

Hi,
I've got Win Server 2003 Standard 64bit edition trying to work with SQL 2005
standard 64bit edition however there is a problem.
I need to locate the ODBC driver in Win Ser.
I know where they are in the 32bit edition but not in the 64bit version.
can anyone help?
Thanks
Olgun.Ucurel@.ccsmedia.com
Is there a 64 bit ODBC Driver? I didnt think that there was. You might have
to compile your application in x86 or if you are using SSIS or DTS exec you
can use this post...
http://forums.microsoft.com/MSDN/Sho...03814&SiteID=1
Can you use the OLE DB Driver?
C:\WINDOWS\SysWOW64\odbcad32.exe
uses...
odbc32.dll
and
C:\WINDOWS\System32\odbcad32.exe
uses
odbc32.dll
I am sure others will have some thoughts as well.
/*
Warren Brunk - MCITP - SQL 2005, MCDBA
www.techintsolutions.com
*/
"Olgun" <Olgun@.discussions.microsoft.com> wrote in message
news:9BA59FAC-D013-4BF4-9700-A97D71D65545@.microsoft.com...
> Hi,
> I've got Win Server 2003 Standard 64bit edition trying to work with SQL
> 2005
> standard 64bit edition however there is a problem.
> I need to locate the ODBC driver in Win Ser.
> I know where they are in the 32bit edition but not in the 64bit version.
> can anyone help?
> Thanks
> Olgun.Ucurel@.ccsmedia.com
|||Olgun wrote:
> Hi,
> I've got Win Server 2003 Standard 64bit edition trying to work with SQL 2005
> standard 64bit edition however there is a problem.
> I need to locate the ODBC driver in Win Ser.
> I know where they are in the 32bit edition but not in the 64bit version.
> can anyone help?
> Thanks
> Olgun.Ucurel@.ccsmedia.com
As far as I know the ODBC driver is not working on 64 bits Windows. You
could use OLEDB instead, which is working fine.
Regards,
lucm

Local 2K5 server & Remote 2K server

Hi,
I was wondering what the issues I might face if I were to upgrade my
local SQL server to 2005 while my remote hosting server is still SQL
2000. Are there huge differences in formats of dbs, tables, jobs, etc
or is it largely UI & feature enhancements?
There isn't a great deal of interation between the servers, but I would
like to be able to, for instance, continue exporting a nightly copy
down to my local server and it being useable without too having to
re-jig things too much.
Thanks for any help you can lend,
Mick
Mick
I have installed on my pc sql server 2005 and linked/connected to sql server
2000 . By saying "nightly copy" dod you mean a backup of the database and
then restore in on local server. It is also possible.
<mick.hodgson@.gmail.com> wrote in message
news:1162982342.259348.291440@.m73g2000cwd.googlegr oups.com...
> Hi,
> I was wondering what the issues I might face if I were to upgrade my
> local SQL server to 2005 while my remote hosting server is still SQL
> 2000. Are there huge differences in formats of dbs, tables, jobs, etc
> or is it largely UI & feature enhancements?
> There isn't a great deal of interation between the servers, but I would
> like to be able to, for instance, continue exporting a nightly copy
> down to my local server and it being useable without too having to
> re-jig things too much.
> Thanks for any help you can lend,
> Mick
>
|||Thanks Uri,
It is a nightly DTS Export which copies the database objects down to
the local server.
Do you have the full 2005 database engine on your PC or just the client
tools? I need to know i can develop on a SQL2005 db and it will work
when uploaded to the SQL2000 db.
Thanks again!
Mick
Uri Dimant wrote:[vbcol=seagreen]
> Mick
> I have installed on my pc sql server 2005 and linked/connected to sql server
> 2000 . By saying "nightly copy" dod you mean a backup of the database and
> then restore in on local server. It is also possible.
>
> <mick.hodgson@.gmail.com> wrote in message
> news:1162982342.259348.291440@.m73g2000cwd.googlegr oups.com...
|||Mick
> Do you have the full 2005 database engine on your PC or just the client
> tools? I need to know i can develop on a SQL2005 db and it will work
> when uploaded to the SQL2000 db.
Yes, I do. Using DTS/SSIS to move the data is a headache ,epsecially
between 2000/2005.
Most likely to backup database on the sql server 2000 and restore on sql
server 2005
<mick.hodgson@.gmail.com> wrote in message
news:1162986618.135708.111690@.m7g2000cwm.googlegro ups.com...
> Thanks Uri,
> It is a nightly DTS Export which copies the database objects down to
> the local server.
> Do you have the full 2005 database engine on your PC or just the client
> tools? I need to know i can develop on a SQL2005 db and it will work
> when uploaded to the SQL2000 db.
> Thanks again!
> Mick
> Uri Dimant wrote:
>

Local 2K5 server & Remote 2K server

Hi,
I was wondering what the issues I might face if I were to upgrade my
local SQL server to 2005 while my remote hosting server is still SQL
2000. Are there huge differences in formats of dbs, tables, jobs, etc
or is it largely UI & feature enhancements?
There isn't a great deal of interation between the servers, but I would
like to be able to, for instance, continue exporting a nightly copy
down to my local server and it being useable without too having to
re-jig things too much.
Thanks for any help you can lend,
MickMick
I have installed on my pc sql server 2005 and linked/connected to sql server
2000 . By saying "nightly copy" dod you mean a backup of the database and
then restore in on local server. It is also possible.
<mick.hodgson@.gmail.com> wrote in message
news:1162982342.259348.291440@.m73g2000cwd.googlegroups.com...
> Hi,
> I was wondering what the issues I might face if I were to upgrade my
> local SQL server to 2005 while my remote hosting server is still SQL
> 2000. Are there huge differences in formats of dbs, tables, jobs, etc
> or is it largely UI & feature enhancements?
> There isn't a great deal of interation between the servers, but I would
> like to be able to, for instance, continue exporting a nightly copy
> down to my local server and it being useable without too having to
> re-jig things too much.
> Thanks for any help you can lend,
> Mick
>|||Thanks Uri,
It is a nightly DTS Export which copies the database objects down to
the local server.
Do you have the full 2005 database engine on your PC or just the client
tools? I need to know i can develop on a SQL2005 db and it will work
when uploaded to the SQL2000 db.
Thanks again!
Mick
Uri Dimant wrote:
> Mick
> I have installed on my pc sql server 2005 and linked/connected to sql server
> 2000 . By saying "nightly copy" dod you mean a backup of the database and
> then restore in on local server. It is also possible.
>
> <mick.hodgson@.gmail.com> wrote in message
> news:1162982342.259348.291440@.m73g2000cwd.googlegroups.com...
> > Hi,
> >
> > I was wondering what the issues I might face if I were to upgrade my
> > local SQL server to 2005 while my remote hosting server is still SQL
> > 2000. Are there huge differences in formats of dbs, tables, jobs, etc
> > or is it largely UI & feature enhancements?
> >
> > There isn't a great deal of interation between the servers, but I would
> > like to be able to, for instance, continue exporting a nightly copy
> > down to my local server and it being useable without too having to
> > re-jig things too much.
> >
> > Thanks for any help you can lend,
> > Mick
> >|||Mick
> Do you have the full 2005 database engine on your PC or just the client
> tools? I need to know i can develop on a SQL2005 db and it will work
> when uploaded to the SQL2000 db.
Yes, I do. Using DTS/SSIS to move the data is a headache ,epsecially
between 2000/2005.
Most likely to backup database on the sql server 2000 and restore on sql
server 2005
<mick.hodgson@.gmail.com> wrote in message
news:1162986618.135708.111690@.m7g2000cwm.googlegroups.com...
> Thanks Uri,
> It is a nightly DTS Export which copies the database objects down to
> the local server.
> Do you have the full 2005 database engine on your PC or just the client
> tools? I need to know i can develop on a SQL2005 db and it will work
> when uploaded to the SQL2000 db.
> Thanks again!
> Mick
> Uri Dimant wrote:
>> Mick
>> I have installed on my pc sql server 2005 and linked/connected to sql
>> server
>> 2000 . By saying "nightly copy" dod you mean a backup of the database
>> and
>> then restore in on local server. It is also possible.
>>
>> <mick.hodgson@.gmail.com> wrote in message
>> news:1162982342.259348.291440@.m73g2000cwd.googlegroups.com...
>> > Hi,
>> >
>> > I was wondering what the issues I might face if I were to upgrade my
>> > local SQL server to 2005 while my remote hosting server is still SQL
>> > 2000. Are there huge differences in formats of dbs, tables, jobs, etc
>> > or is it largely UI & feature enhancements?
>> >
>> > There isn't a great deal of interation between the servers, but I would
>> > like to be able to, for instance, continue exporting a nightly copy
>> > down to my local server and it being useable without too having to
>> > re-jig things too much.
>> >
>> > Thanks for any help you can lend,
>> > Mick
>> >
>

Local 2K5 server & Remote 2K server

Hi,
I was wondering what the issues I might face if I were to upgrade my
local SQL server to 2005 while my remote hosting server is still SQL
2000. Are there huge differences in formats of dbs, tables, jobs, etc
or is it largely UI & feature enhancements?
There isn't a great deal of interation between the servers, but I would
like to be able to, for instance, continue exporting a nightly copy
down to my local server and it being useable without too having to
re-jig things too much.
Thanks for any help you can lend,
MickMick
I have installed on my pc sql server 2005 and linked/connected to sql server
2000 . By saying "nightly copy" dod you mean a backup of the database and
then restore in on local server. It is also possible.
<mick.hodgson@.gmail.com> wrote in message
news:1162982342.259348.291440@.m73g2000cwd.googlegroups.com...
> Hi,
> I was wondering what the issues I might face if I were to upgrade my
> local SQL server to 2005 while my remote hosting server is still SQL
> 2000. Are there huge differences in formats of dbs, tables, jobs, etc
> or is it largely UI & feature enhancements?
> There isn't a great deal of interation between the servers, but I would
> like to be able to, for instance, continue exporting a nightly copy
> down to my local server and it being useable without too having to
> re-jig things too much.
> Thanks for any help you can lend,
> Mick
>|||Thanks Uri,
It is a nightly DTS Export which copies the database objects down to
the local server.
Do you have the full 2005 database engine on your PC or just the client
tools? I need to know i can develop on a SQL2005 db and it will work
when uploaded to the SQL2000 db.
Thanks again!
Mick
Uri Dimant wrote:[vbcol=seagreen]
> Mick
> I have installed on my pc sql server 2005 and linked/connected to sql serv
er
> 2000 . By saying "nightly copy" dod you mean a backup of the database and
> then restore in on local server. It is also possible.
>
> <mick.hodgson@.gmail.com> wrote in message
> news:1162982342.259348.291440@.m73g2000cwd.googlegroups.com...|||Mick
> Do you have the full 2005 database engine on your PC or just the client
> tools? I need to know i can develop on a SQL2005 db and it will work
> when uploaded to the SQL2000 db.
Yes, I do. Using DTS/SSIS to move the data is a headache ,epsecially
between 2000/2005.
Most likely to backup database on the sql server 2000 and restore on sql
server 2005
<mick.hodgson@.gmail.com> wrote in message
news:1162986618.135708.111690@.m7g2000cwm.googlegroups.com...
> Thanks Uri,
> It is a nightly DTS Export which copies the database objects down to
> the local server.
> Do you have the full 2005 database engine on your PC or just the client
> tools? I need to know i can develop on a SQL2005 db and it will work
> when uploaded to the SQL2000 db.
> Thanks again!
> Mick
> Uri Dimant wrote:
>