Sybase to Access

[codercode]

I'm working on a Visual Basic .NET using Access database. However, my
client already have a 30MB database with Sybase ASA and Sybase is way
too much for that. Is there anyway I can migrate from a Sybase to
Access? or is it possible at all. If it is not, can these two databases
co-exist together?

[vbnetdev]

Re: Sybase to Access

see

http://72.14.205.104/search?q=cache:y_x6ncJ2vKwJ:www.datadirect.com/download/eval_docs/dotnet_sybase.pdf+.NET+sybase&hl=en&gl=us&ct=clnk&cd=3

"codercode" <wong.jamin@gma il.comwrote in message
news:1166120551 .784318.13300@8 0g2000cwy.googl egroups.com...

I'm working on a Visual Basic .NET using Access database. However, my
client already have a 30MB database with Sybase ASA and Sybase is way
too much for that. Is there anyway I can migrate from a Sybase to
Access? or is it possible at all. If it is not, can these two databases
co-exist together?
>

[Cor Ligthert [MVP]]

Re: Sybase to Access

Are you ending your career with that client, advising Access, while there
are 2 free SQL servers which do a better job?

Just my thought reading your message,

Cor

"codercode" <wong.jamin@gma il.comschreef in bericht
news:1166120551 .784318.13300@8 0g2000cwy.googl egroups.com...

I'm working on a Visual Basic .NET using Access database. However, my
client already have a 30MB database with Sybase ASA and Sybase is way
too much for that. Is there anyway I can migrate from a Sybase to
Access? or is it possible at all. If it is not, can these two databases
co-exist together?
>

[vbnetdev]

Re: Sybase to Access

LOL

"Cor Ligthert [MVP]" <notmyfirstname @planet.nlwrote in message
news:uMrpd6AIHH A.2632@TK2MSFTN GP06.phx.gbl...

Are you ending your career with that client, advising Access, while there
are 2 free SQL servers which do a better job?
>
Just my thought reading your message,
>
Cor
>
"codercode" <wong.jamin@gma il.comschreef in bericht
news:1166120551 .784318.13300@8 0g2000cwy.googl egroups.com...

>I'm working on a Visual Basic .NET using Access database. However, my
>client already have a 30MB database with Sybase ASA and Sybase is way
>too much for that. Is there anyway I can migrate from a Sybase to
>Access? or is it possible at all. If it is not, can these two databases
>co-exist together?
>>

>
>

[aaron.kempf@gmail.com]

Re: Sybase to Access

I agree.

Anyone using MDB for __anything__ in the year 2006 should be fired and
then spit upon

-Aaron




Cor Ligthert [MVP] wrote:

Are you ending your career with that client, advising Access, while there
are 2 free SQL servers which do a better job?
>
Just my thought reading your message,
>
Cor
>
"codercode" <wong.jamin@gma il.comschreef in bericht
news:1166120551 .784318.13300@8 0g2000cwy.googl egroups.com...

I'm working on a Visual Basic .NET using Access database. However, my
client already have a 30MB database with Sybase ASA and Sybase is way
too much for that. Is there anyway I can migrate from a Sybase to
Access? or is it possible at all. If it is not, can these two databases
co-exist together?

[Master Programmer]

Re: Sybase to Access

Access is a toy for storing "My CD Collection" or "My Favourite
Ponies". It is not a DB in any sense that that term "DB" is usually
used
in a professional environment.

Fucking grow up and use SQL Server.

The Grand Master


codercode wrote:

I'm working on a Visual Basic .NET using Access database. However, my
client already have a 30MB database with Sybase ASA and Sybase is way
too much for that. Is there anyway I can migrate from a Sybase to
Access? or is it possible at all. If it is not, can these two databases
co-exist together?

[aaron.kempf@gmail.com]

Re: Sybase to Access

Master;

Oh I fully agree.
But Access is also a replacement for Crystal Reports.. Access Data
Projects are a very powerful alternative; no DLL hell to play with.

Just simple bound forms.. much much better than VB6; but it's the same
architecture so it's all good

I hate MDB with a vengence.
But ADP is a great way to keep VB6 code without rewriting it.

We're a fully supported platform for VB6 ADO code against SQL Server.
you should check it out sometime..

-Aaron



Master Programmer wrote:

Access is a toy for storing "My CD Collection" or "My Favourite
Ponies". It is not a DB in any sense that that term "DB" is usually
used
in a professional environment.
>
Fucking grow up and use SQL Server.
>
The Grand Master
>
>
codercode wrote:

I'm working on a Visual Basic .NET using Access database. However, my
client already have a 30MB database with Sybase ASA and Sybase is way
too much for that. Is there anyway I can migrate from a Sybase to
Access? or is it possible at all. If it is not, can these two databases
co-exist together?

[Master Programmer]

Re: Sybase to Access

Aaron

Have you used database encryption for SQL Server before?

The Grand Master

aaron.kempf@gma il.com wrote:

Master;
>
Oh I fully agree.
But Access is also a replacement for Crystal Reports.. Access Data
Projects are a very powerful alternative; no DLL hell to play with.
>
Just simple bound forms.. much much better than VB6; but it's the same
architecture so it's all good
>
I hate MDB with a vengence.
But ADP is a great way to keep VB6 code without rewriting it.
>
We're a fully supported platform for VB6 ADO code against SQL Server.
you should check it out sometime..
>
-Aaron
>
>
>
Master Programmer wrote:

Access is a toy for storing "My CD Collection" or "My Favourite
Ponies". It is not a DB in any sense that that term "DB" is usually
used
in a professional environment.

Fucking grow up and use SQL Server.

The Grand Master


codercode wrote:

I'm working on a Visual Basic .NET using Access database. However, my
client already have a 30MB database with Sybase ASA and Sybase is way
too much for that. Is there anyway I can migrate from a Sybase to
Access? or is it possible at all. If it is not, can these two databases
co-exist together?

[aaron.kempf@gmail.com]

Re: Sybase to Access

to encrpyt text or the connection string argument?

ADP supports both without a problem

-aaron



Master Programmer wrote:

Aaron
>
Have you used database encryption for SQL Server before?
>
The Grand Master
>
aaron.kempf@gma il.com wrote:

Master;

Oh I fully agree.
But Access is also a replacement for Crystal Reports.. Access Data
Projects are a very powerful alternative; no DLL hell to play with.

Just simple bound forms.. much much better than VB6; but it's the same
architecture so it's all good

I hate MDB with a vengence.
But ADP is a great way to keep VB6 code without rewriting it.

We're a fully supported platform for VB6 ADO code against SQL Server.
you should check it out sometime..

-Aaron



Master Programmer wrote:

Access is a toy for storing "My CD Collection" or "My Favourite
Ponies". It is not a DB in any sense that that term "DB" is usually
used
in a professional environment.
>
Fucking grow up and use SQL Server.
>
The Grand Master
>
>
codercode wrote:
I'm working on a Visual Basic .NET using Access database. However, my
client already have a 30MB database with Sybase ASA and Sybase is way
too much for that. Is there anyway I can migrate from a Sybase to
Access? or is it possible at all. If it is not, can these two databases
co-exist together?

[aaron.kempf@gmail.com]

Re: Sybase to Access

like for passwords and stupid stuff like that?

yeah I've got a couple of functions to do it; i just dont know if i see
the point.

encryption within a database is fucking pointless.
you just can't use SQL authentication for ANYTHING on ANY SERVER and
you're fairly secure-- out of the box

-Aaron


Master Programmer wrote:

Aaron
>
Have you used database encryption for SQL Server before?
>
The Grand Master
>
aaron.kempf@gma il.com wrote:

Master;

Oh I fully agree.
But Access is also a replacement for Crystal Reports.. Access Data
Projects are a very powerful alternative; no DLL hell to play with.

Just simple bound forms.. much much better than VB6; but it's the same
architecture so it's all good

I hate MDB with a vengence.
But ADP is a great way to keep VB6 code without rewriting it.

We're a fully supported platform for VB6 ADO code against SQL Server.
you should check it out sometime..

-Aaron



Master Programmer wrote:

Access is a toy for storing "My CD Collection" or "My Favourite
Ponies". It is not a DB in any sense that that term "DB" is usually
used
in a professional environment.
>
Fucking grow up and use SQL Server.
>
The Grand Master
>
>
codercode wrote:
I'm working on a Visual Basic .NET using Access database. However, my
client already have a 30MB database with Sybase ASA and Sybase is way
too much for that. Is there anyway I can migrate from a Sybase to
Access? or is it possible at all. If it is not, can these two databases
co-exist together?

[aaron.kempf@gmail.com]

Re: Sybase to Access

and of course you need 'trust for delegation' and setspn


Master Programmer wrote:

Aaron
>
Have you used database encryption for SQL Server before?
>
The Grand Master
>
aaron.kempf@gma il.com wrote:

Master;

Oh I fully agree.
But Access is also a replacement for Crystal Reports.. Access Data
Projects are a very powerful alternative; no DLL hell to play with.

Just simple bound forms.. much much better than VB6; but it's the same
architecture so it's all good

I hate MDB with a vengence.
But ADP is a great way to keep VB6 code without rewriting it.

We're a fully supported platform for VB6 ADO code against SQL Server.
you should check it out sometime..

-Aaron



Master Programmer wrote:

Access is a toy for storing "My CD Collection" or "My Favourite
Ponies". It is not a DB in any sense that that term "DB" is usually
used
in a professional environment.
>
Fucking grow up and use SQL Server.
>
The Grand Master
>
>
codercode wrote:
I'm working on a Visual Basic .NET using Access database. However, my
client already have a 30MB database with Sybase ASA and Sybase is way
too much for that. Is there anyway I can migrate from a Sybase to
Access? or is it possible at all. If it is not, can these two databases
co-exist together?

[Master Programmer]

Re: Sybase to Access

Its the IT dept thats not trusted. They must not see the data. Think I
will just have to encrypt the fields that are sensitive.

The Grand Master

aaron.kempf@gma il.com wrote:

like for passwords and stupid stuff like that?
>
yeah I've got a couple of functions to do it; i just dont know if i see
the point.
>
encryption within a database is fucking pointless.
you just can't use SQL authentication for ANYTHING on ANY SERVER and
you're fairly secure-- out of the box
>
-Aaron
>
>
Master Programmer wrote:

Aaron

Have you used database encryption for SQL Server before?

The Grand Master

aaron.kempf@gma il.com wrote:

Master;
>
Oh I fully agree.
But Access is also a replacement for Crystal Reports.. Access Data
Projects are a very powerful alternative; no DLL hell to play with.
>
Just simple bound forms.. much much better than VB6; but it's the same
architecture so it's all good
>
I hate MDB with a vengence.
But ADP is a great way to keep VB6 code without rewriting it.
>
We're a fully supported platform for VB6 ADO code against SQL Server.
you should check it out sometime..
>
-Aaron
>
>
>
Master Programmer wrote:
Access is a toy for storing "My CD Collection" or "My Favourite
Ponies". It is not a DB in any sense that that term "DB" is usually
used
in a professional environment.

Fucking grow up and use SQL Server.

The Grand Master


codercode wrote:
I'm working on a Visual Basic .NET using Access database. However, my
client already have a 30MB database with Sybase ASA and Sybase is way
too much for that. Is there anyway I can migrate from a Sybase to
Access? or is it possible at all. If it is not, can these two databases
co-exist together?

[Master Programmer]

Re: Sybase to Access

At then end of the day the windows authentication system is that easy
to crack if they have physical access, that the only option seems to be
to encrypt the fields using the program

The Grand Master

aaron.kempf@gma il.com wrote:

and of course you need 'trust for delegation' and setspn
>
>
Master Programmer wrote:

Aaron

Have you used database encryption for SQL Server before?

The Grand Master

aaron.kempf@gma il.com wrote:

Master;
>
Oh I fully agree.
But Access is also a replacement for Crystal Reports.. Access Data
Projects are a very powerful alternative; no DLL hell to play with.
>
Just simple bound forms.. much much better than VB6; but it's the same
architecture so it's all good
>
I hate MDB with a vengence.
But ADP is a great way to keep VB6 code without rewriting it.
>
We're a fully supported platform for VB6 ADO code against SQL Server.
you should check it out sometime..
>
-Aaron
>
>
>
Master Programmer wrote:
Access is a toy for storing "My CD Collection" or "My Favourite
Ponies". It is not a DB in any sense that that term "DB" is usually
used
in a professional environment.

Fucking grow up and use SQL Server.

The Grand Master


codercode wrote:
I'm working on a Visual Basic .NET using Access database. However, my
client already have a 30MB database with Sybase ASA and Sybase is way
too much for that. Is there anyway I can migrate from a Sybase to
Access? or is it possible at all. If it is not, can these two databases
co-exist together?

[aaron.kempf@gmail.com]

Re: Sybase to Access

windows authentication isn't easy to crack if they have physical access

sql authentication is 'impossible to secure'

but that doesn't make windows authentication impossible to secure

how are you going to crack in.. guest accounts? escalation due to trust
of the network account?

I dont let anyone hit the database; they can all do read only through a
cube for all I care

-Aaron



Master Programmer wrote:

At then end of the day the windows authentication system is that easy
to crack if they have physical access, that the only option seems to be
to encrypt the fields using the program
>
The Grand Master
>
aaron.kempf@gma il.com wrote:

and of course you need 'trust for delegation' and setspn


Master Programmer wrote:

Aaron
>
Have you used database encryption for SQL Server before?
>
The Grand Master
>
aaron.kempf@gma il.com wrote:
Master;

Oh I fully agree.
But Access is also a replacement for Crystal Reports.. Access Data
Projects are a very powerful alternative; no DLL hell to play with.

Just simple bound forms.. much much better than VB6; but it's the same
architecture so it's all good

I hate MDB with a vengence.
But ADP is a great way to keep VB6 code without rewriting it.

We're a fully supported platform for VB6 ADO code against SQL Server.
you should check it out sometime..

-Aaron



Master Programmer wrote:
Access is a toy for storing "My CD Collection" or "My Favourite
Ponies". It is not a DB in any sense that that term "DB" is usually
used
in a professional environment.
>
Fucking grow up and use SQL Server.
>
The Grand Master
>
>
codercode wrote:
I'm working on a Visual Basic .NET using Access database. However, my
client already have a 30MB database with Sybase ASA and Sybase is way
too much for that. Is there anyway I can migrate from a Sybase to
Access? or is it possible at all. If it is not, can these two databases
co-exist together?

[Master Programmer]

Re: Sybase to Access

Windows authentication is childishly easy to crack if you have physical
access to the box. There are lots of brute force crackers availble,
they work offline on the SAM file containing the users/passwords. I
bought a used dell box a while ago and didn't have the password. I
found a web site that allows you to boot your PC from a floppy, it then
grabs the sam file and saves it to the floppy. Then you upload the
file to the web site and 24 hours later they send you all of the
usernames and passwords. There are other methods too, including
downloadable ISO files allowing you to create a CD that has a bootable
linux and a brute force cracker and dictionary.

The Grand Master


aaron.kempf@gma il.com wrote:

windows authentication isn't easy to crack if they have physical access
>
sql authentication is 'impossible to secure'
>
but that doesn't make windows authentication impossible to secure
>
how are you going to crack in.. guest accounts? escalation due to trust
of the network account?
>
I dont let anyone hit the database; they can all do read only through a
cube for all I care
>
-Aaron
>
>
>
Master Programmer wrote:

At then end of the day the windows authentication system is that easy
to crack if they have physical access, that the only option seems to be
to encrypt the fields using the program

The Grand Master

aaron.kempf@gma il.com wrote:

and of course you need 'trust for delegation' and setspn
>
>
Master Programmer wrote:
Aaron

Have you used database encryption for SQL Server before?

The Grand Master

aaron.kempf@gma il.com wrote:
Master;
>
Oh I fully agree.
But Access is also a replacement for Crystal Reports.. Access Data
Projects are a very powerful alternative; no DLL hell to play with.
>
Just simple bound forms.. much much better than VB6; but it's the same
architecture so it's all good
>
I hate MDB with a vengence.
But ADP is a great way to keep VB6 code without rewriting it.
>
We're a fully supported platform for VB6 ADO code against SQL Server.
you should check it out sometime..
>
-Aaron
>
>
>
Master Programmer wrote:
Access is a toy for storing "My CD Collection" or "My Favourite
Ponies". It is not a DB in any sense that that term "DB" is usually
used
in a professional environment.

Fucking grow up and use SQL Server.

The Grand Master


codercode wrote:
I'm working on a Visual Basic .NET using Access database. However, my
client already have a 30MB database with Sybase ASA and Sybase is way
too much for that. Is there anyway I can migrate from a Sybase to
Access? or is it possible at all. If it is not, can these two databases
co-exist together?