Board index » delphi » General SQL Error. 13059

General SQL Error. 13059

Delphi 5
BDE 5.1
Connecting to MS SQL 7

It works fine on my computer, but when I installed on my friend's laptop, it
gives the error: General SQL Error.   13059    3

I have seen many posts that say it has to do with DAO, but PLEASE, SOMEONE
TELL ME HOW TO FIX THIS, IT IS EXTREMELY URGENT.

TS

 

Re:General SQL Error. 13059


TS,

   When you wrote "It works fine....", what did you mean by "it"?  Cannot
connect to the server?  Application won't start?

krf

Quote
TS wrote in message <8bgdpr$a...@bornews.borland.com>...
>Delphi 5
>BDE 5.1
>Connecting to MS SQL 7

>It works fine on my computer, but when I installed on my friend's laptop,
it
>gives the error: General SQL Error.   13059    3

>I have seen many posts that say it has to do with DAO, but PLEASE, SOMEONE
>TELL ME HOW TO FIX THIS, IT IS EXTREMELY URGENT.

>TS

Re:General SQL Error. 13059


My program connects to the database just fine from my computer, but when I
install it on my friend's laptop, it gives this error.  I have installed
Delphi on his laptop just to see if anything would change, but it (my
program) still won't connect.  I also tried connecting with SQL Explorer,
but same problem.  I think it has something to do with BDE drivers, but I
don't know what to do.  I have checked versions and they are all 5.1

Thanks for any help,
TS

Quote
"Kevin Frevert" <kfrev...@midwayusa.com> wrote in message

news:38dbcf09@dnews...
Quote
> TS,

>    When you wrote "It works fine....", what did you mean by "it"?  Cannot
> connect to the server?  Application won't start?

> krf

> TS wrote in message <8bgdpr$a...@bornews.borland.com>...
> >Delphi 5
> >BDE 5.1
> >Connecting to MS SQL 7

> >It works fine on my computer, but when I installed on my friend's laptop,
> it
> >gives the error: General SQL Error.   13059    3

> >I have seen many posts that say it has to do with DAO, but PLEASE,
SOMEONE
> >TELL ME HOW TO FIX THIS, IT IS EXTREMELY URGENT.

> >TS

Re:General SQL Error. 13059


I have also installed the SQL Client on the laptop and the Enterprise
manager can connect just fine.  Still no bde connection works.

TS

Quote
"Kevin Frevert" <kfrev...@midwayusa.com> wrote in message

news:38dbcf09@dnews...
Quote
> TS,

>    When you wrote "It works fine....", what did you mean by "it"?  Cannot
> connect to the server?  Application won't start?

> krf

> TS wrote in message <8bgdpr$a...@bornews.borland.com>...
> >Delphi 5
> >BDE 5.1
> >Connecting to MS SQL 7

> >It works fine on my computer, but when I installed on my friend's laptop,
> it
> >gives the error: General SQL Error.   13059    3

> >I have seen many posts that say it has to do with DAO, but PLEASE,
SOMEONE
> >TELL ME HOW TO FIX THIS, IT IS EXTREMELY URGENT.

> >TS

Re:General SQL Error. 13059


I am quite sure I have TCP/IP settings right because my program has worked
on about 10 other systems (Including systems with Windows 95,98,NT, and
2000).  This error has me greatly confused.

Any more suggestions?

(P.S.  Do you have ICQ or something where we can talk faster?)

TS

Quote
"Kevin Frevert" <kfrev...@midwayusa.com> wrote in message

news:38dbdd10@dnews...
Quote
> TS,

>    Weird.  You have installed the client, but did you configure the client
> (Named Pipes, TCP/IP)?  I've gotten bitten by that one.  Just as a
starting
> point, in the BDE, create a new alias pointing the desired server (making
> sure you have the MSSQL driver).  Does ODBC work?

> krf

> TS wrote in message <8bgjqt$a0...@bornews.borland.com>...
> >I have also installed the SQL Client on the laptop and the Enterprise
> >manager can connect just fine.  Still no bde connection works.

> >TS

> >"Kevin Frevert" <kfrev...@midwayusa.com> wrote in message
> >news:38dbcf09@dnews...
> >> TS,

> >>    When you wrote "It works fine....", what did you mean by "it"?
Cannot
> >> connect to the server?  Application won't start?

> >> krf

> >> TS wrote in message <8bgdpr$a...@bornews.borland.com>...
> >> >Delphi 5
> >> >BDE 5.1
> >> >Connecting to MS SQL 7

> >> >It works fine on my computer, but when I installed on my friend's
> laptop,
> >> it
> >> >gives the error: General SQL Error.   13059    3

> >> >I have seen many posts that say it has to do with DAO, but PLEASE,
> >SOMEONE
> >> >TELL ME HOW TO FIX THIS, IT IS EXTREMELY URGENT.

> >> >TS

Re:General SQL Error. 13059


TS,

   Weird.  You have installed the client, but did you configure the client
(Named Pipes, TCP/IP)?  I've gotten bitten by that one.  Just as a starting
point, in the BDE, create a new alias pointing the desired server (making
sure you have the MSSQL driver).  Does ODBC work?

krf

Quote
TS wrote in message <8bgjqt$a0...@bornews.borland.com>...
>I have also installed the SQL Client on the laptop and the Enterprise
>manager can connect just fine.  Still no bde connection works.

>TS

>"Kevin Frevert" <kfrev...@midwayusa.com> wrote in message
>news:38dbcf09@dnews...
>> TS,

>>    When you wrote "It works fine....", what did you mean by "it"?  Cannot
>> connect to the server?  Application won't start?

>> krf

>> TS wrote in message <8bgdpr$a...@bornews.borland.com>...
>> >Delphi 5
>> >BDE 5.1
>> >Connecting to MS SQL 7

>> >It works fine on my computer, but when I installed on my friend's
laptop,
>> it
>> >gives the error: General SQL Error.   13059    3

>> >I have seen many posts that say it has to do with DAO, but PLEASE,
>SOMEONE
>> >TELL ME HOW TO FIX THIS, IT IS EXTREMELY URGENT.

>> >TS

Re:General SQL Error. 13059


TS,

   Sorry, no ICQ.  I am getting ready to go home, so I won't be able to
respond until Monday.   Did you start from scratch and create a whole new
(MSSQL) BDE alias?  Did you try connecting via ODBC?  Your right, you should
be connecting just fine (this is almost a no-brainer).  I'm sure it is
something simple we both are missing.  Maybe someone else can jump in and
give you a hand.

Good luck,
krf

Quote
TS wrote in message <8bgnjg$e...@bornews.borland.com>...
>I am quite sure I have TCP/IP settings right because my program has worked
>on about 10 other systems (Including systems with Windows 95,98,NT, and
>2000).  This error has me greatly confused.

>Any more suggestions?

>(P.S.  Do you have ICQ or something where we can talk faster?)

>TS

>"Kevin Frevert" <kfrev...@midwayusa.com> wrote in message
>news:38dbdd10@dnews...
>> TS,

>>    Weird.  You have installed the client, but did you configure the
client
>> (Named Pipes, TCP/IP)?  I've gotten bitten by that one.  Just as a
>starting
>> point, in the BDE, create a new alias pointing the desired server (making
>> sure you have the MSSQL driver).  Does ODBC work?

>> krf

>> TS wrote in message <8bgjqt$a0...@bornews.borland.com>...
>> >I have also installed the SQL Client on the laptop and the Enterprise
>> >manager can connect just fine.  Still no bde connection works.

>> >TS

>> >"Kevin Frevert" <kfrev...@midwayusa.com> wrote in message
>> >news:38dbcf09@dnews...
>> >> TS,

>> >>    When you wrote "It works fine....", what did you mean by "it"?
>Cannot
>> >> connect to the server?  Application won't start?

>> >> krf

>> >> TS wrote in message <8bgdpr$a...@bornews.borland.com>...
>> >> >Delphi 5
>> >> >BDE 5.1
>> >> >Connecting to MS SQL 7

>> >> >It works fine on my computer, but when I installed on my friend's
>> laptop,
>> >> it
>> >> >gives the error: General SQL Error.   13059    3

>> >> >I have seen many posts that say it has to do with DAO, but PLEASE,
>> >SOMEONE
>> >> >TELL ME HOW TO FIX THIS, IT IS EXTREMELY URGENT.

>> >> >TS

Re:General SQL Error. 13059


I tried ODBC and it connects just fine, same to ADO

but the BDE still isn't connecting.  I want to use the BDE (I don't want to
explain right now), so please no comments on alternatives.

???????????? :(

HHHHHHHHHEEEEEEEEEELLLLLLLLLLLPPPPPPPP!

ts

Quote
"Kevin Frevert" <kfrev...@midwayusa.com> wrote in message

news:38dbe593@dnews...
Quote
> TS,

>    Sorry, no ICQ.  I am getting ready to go home, so I won't be able to
> respond until Monday.   Did you start from scratch and create a whole new
> (MSSQL) BDE alias?  Did you try connecting via ODBC?  Your right, you
should
> be connecting just fine (this is almost a no-brainer).  I'm sure it is
> something simple we both are missing.  Maybe someone else can jump in and
> give you a hand.

> Good luck,
> krf

> TS wrote in message <8bgnjg$e...@bornews.borland.com>...
> >I am quite sure I have TCP/IP settings right because my program has
worked
> >on about 10 other systems (Including systems with Windows 95,98,NT, and
> >2000).  This error has me greatly confused.

> >Any more suggestions?

> >(P.S.  Do you have ICQ or something where we can talk faster?)

> >TS

> >"Kevin Frevert" <kfrev...@midwayusa.com> wrote in message
> >news:38dbdd10@dnews...
> >> TS,

> >>    Weird.  You have installed the client, but did you configure the
> client
> >> (Named Pipes, TCP/IP)?  I've gotten bitten by that one.  Just as a
> >starting
> >> point, in the BDE, create a new alias pointing the desired server
(making
> >> sure you have the MSSQL driver).  Does ODBC work?

> >> krf

> >> TS wrote in message <8bgjqt$a0...@bornews.borland.com>...
> >> >I have also installed the SQL Client on the laptop and the Enterprise
> >> >manager can connect just fine.  Still no bde connection works.

> >> >TS

> >> >"Kevin Frevert" <kfrev...@midwayusa.com> wrote in message
> >> >news:38dbcf09@dnews...
> >> >> TS,

> >> >>    When you wrote "It works fine....", what did you mean by "it"?
> >Cannot
> >> >> connect to the server?  Application won't start?

> >> >> krf

> >> >> TS wrote in message <8bgdpr$a...@bornews.borland.com>...
> >> >> >Delphi 5
> >> >> >BDE 5.1
> >> >> >Connecting to MS SQL 7

> >> >> >It works fine on my computer, but when I installed on my friend's
> >> laptop,
> >> >> it
> >> >> >gives the error: General SQL Error.   13059    3

> >> >> >I have seen many posts that say it has to do with DAO, but PLEASE,
> >> >SOMEONE
> >> >> >TELL ME HOW TO FIX THIS, IT IS EXTREMELY URGENT.

> >> >> >TS

Re:General SQL Error. 13059


TS,

  Good morning.   Any luck?  I have some silly questions:

1.  What version of Delphi 5 (Enterprise, Professional, Standard) did you
install on your friend's laptop?  Did the BDE install OK?
2.  Did you create a new (MSSQL) BDE alias, independent from your
application?
3.  Can you connect to your target database through the BDE Administrator?

I suspect something didn't get installed correctly.

Good luck,
krf

Quote
TS wrote in message <8bgp8t$d...@bornews.borland.com>...
>I tried ODBC and it connects just fine, same to ADO

>but the BDE still isn't connecting.  I want to use the BDE (I don't want to
>explain right now), so please no comments on alternatives.

>???????????? :(

>HHHHHHHHHEEEEEEEEEELLLLLLLLLLLPPPPPPPP!

>ts

>"Kevin Frevert" <kfrev...@midwayusa.com> wrote in message
>news:38dbe593@dnews...
>> TS,

>>    Sorry, no ICQ.  I am getting ready to go home, so I won't be able to
>> respond until Monday.   Did you start from scratch and create a whole new
>> (MSSQL) BDE alias?  Did you try connecting via ODBC?  Your right, you
>should
>> be connecting just fine (this is almost a no-brainer).  I'm sure it is
>> something simple we both are missing.  Maybe someone else can jump in and
>> give you a hand.

>> Good luck,
>> krf

>> TS wrote in message <8bgnjg$e...@bornews.borland.com>...
>> >I am quite sure I have TCP/IP settings right because my program has
>worked
>> >on about 10 other systems (Including systems with Windows 95,98,NT, and
>> >2000).  This error has me greatly confused.

>> >Any more suggestions?

>> >(P.S.  Do you have ICQ or something where we can talk faster?)

>> >TS

>> >"Kevin Frevert" <kfrev...@midwayusa.com> wrote in message
>> >news:38dbdd10@dnews...
>> >> TS,

>> >>    Weird.  You have installed the client, but did you configure the
>> client
>> >> (Named Pipes, TCP/IP)?  I've gotten bitten by that one.  Just as a
>> >starting
>> >> point, in the BDE, create a new alias pointing the desired server
>(making
>> >> sure you have the MSSQL driver).  Does ODBC work?

>> >> krf

>> >> TS wrote in message <8bgjqt$a0...@bornews.borland.com>...
>> >> >I have also installed the SQL Client on the laptop and the Enterprise
>> >> >manager can connect just fine.  Still no bde connection works.

>> >> >TS

>> >> >"Kevin Frevert" <kfrev...@midwayusa.com> wrote in message
>> >> >news:38dbcf09@dnews...
>> >> >> TS,

>> >> >>    When you wrote "It works fine....", what did you mean by "it"?
>> >Cannot
>> >> >> connect to the server?  Application won't start?

>> >> >> krf

>> >> >> TS wrote in message <8bgdpr$a...@bornews.borland.com>...
>> >> >> >Delphi 5
>> >> >> >BDE 5.1
>> >> >> >Connecting to MS SQL 7

>> >> >> >It works fine on my computer, but when I installed on my friend's
>> >> laptop,
>> >> >> it
>> >> >> >gives the error: General SQL Error.   13059    3

>> >> >> >I have seen many posts that say it has to do with DAO, but PLEASE,
>> >> >SOMEONE
>> >> >> >TELL ME HOW TO FIX THIS, IT IS EXTREMELY URGENT.

>> >> >> >TS

Re:General SQL Error. 13059


Kevin,

1. Enterprise 5, BDE Installed Fine, but would not connect to MS SQL 7
2. My program has an internal alias, but I tried creating an alias in SQL
Explorer, but it won't connect either.  I made sure parameters were
identical to those on my programming computer.
3.  No, I have tried but no success

P.S.  Thank yo for taking the time to help me out, I think you were the
person who helped me on my last problem too :)

TS

Quote
"Kevin Frevert" <kfrev...@midwayusa.com> wrote in message

news:38df68e8@dnews...
Quote
> TS,

>   Good morning.   Any luck?  I have some silly questions:

> 1.  What version of Delphi 5 (Enterprise, Professional, Standard) did you
> install on your friend's laptop?  Did the BDE install OK?
> 2.  Did you create a new (MSSQL) BDE alias, independent from your
> application?
> 3.  Can you connect to your target database through the BDE Administrator?

> I suspect something didn't get installed correctly.

> Good luck,
> krf

> TS wrote in message <8bgp8t$d...@bornews.borland.com>...
> >I tried ODBC and it connects just fine, same to ADO

> >but the BDE still isn't connecting.  I want to use the BDE (I don't want
to
> >explain right now), so please no comments on alternatives.

> >???????????? :(

> >HHHHHHHHHEEEEEEEEEELLLLLLLLLLLPPPPPPPP!

> >ts

> >"Kevin Frevert" <kfrev...@midwayusa.com> wrote in message
> >news:38dbe593@dnews...
> >> TS,

> >>    Sorry, no ICQ.  I am getting ready to go home, so I won't be able to
> >> respond until Monday.   Did you start from scratch and create a whole
new
> >> (MSSQL) BDE alias?  Did you try connecting via ODBC?  Your right, you
> >should
> >> be connecting just fine (this is almost a no-brainer).  I'm sure it is
> >> something simple we both are missing.  Maybe someone else can jump in
and
> >> give you a hand.

> >> Good luck,
> >> krf

> >> TS wrote in message <8bgnjg$e...@bornews.borland.com>...
> >> >I am quite sure I have TCP/IP settings right because my program has
> >worked
> >> >on about 10 other systems (Including systems with Windows 95,98,NT,
and
> >> >2000).  This error has me greatly confused.

> >> >Any more suggestions?

> >> >(P.S.  Do you have ICQ or something where we can talk faster?)

> >> >TS

> >> >"Kevin Frevert" <kfrev...@midwayusa.com> wrote in message
> >> >news:38dbdd10@dnews...
> >> >> TS,

> >> >>    Weird.  You have installed the client, but did you configure the
> >> client
> >> >> (Named Pipes, TCP/IP)?  I've gotten bitten by that one.  Just as a
> >> >starting
> >> >> point, in the BDE, create a new alias pointing the desired server
> >(making
> >> >> sure you have the MSSQL driver).  Does ODBC work?

> >> >> krf

> >> >> TS wrote in message <8bgjqt$a0...@bornews.borland.com>...
> >> >> >I have also installed the SQL Client on the laptop and the
Enterprise
> >> >> >manager can connect just fine.  Still no bde connection works.

> >> >> >TS

> >> >> >"Kevin Frevert" <kfrev...@midwayusa.com> wrote in message
> >> >> >news:38dbcf09@dnews...
> >> >> >> TS,

> >> >> >>    When you wrote "It works fine....", what did you mean by "it"?
> >> >Cannot
> >> >> >> connect to the server?  Application won't start?

> >> >> >> krf

> >> >> >> TS wrote in message <8bgdpr$a...@bornews.borland.com>...
> >> >> >> >Delphi 5
> >> >> >> >BDE 5.1
> >> >> >> >Connecting to MS SQL 7

> >> >> >> >It works fine on my computer, but when I installed on my
friend's
> >> >> laptop,
> >> >> >> it
> >> >> >> >gives the error: General SQL Error.   13059    3

> >> >> >> >I have seen many posts that say it has to do with DAO, but
PLEASE,
> >> >> >SOMEONE
> >> >> >> >TELL ME HOW TO FIX THIS, IT IS EXTREMELY URGENT.

> >> >> >> >TS

Re:General SQL Error. 13059


TS,

   I just did a search on Deja.com and found something on DAO and the only
solution was to un-install Microsoft Office.  There was no response that
un-installing actually worked, but it may be worth a try.

Good luck,
krf

Re:General SQL Error. 13059


Passed that step long ago, even before I came to the newsgroup :)
Didn't work :(

TS

Quote
"Kevin Frevert" <kfrev...@midwayusa.com> wrote in message

news:38df80e9@dnews...
Quote
> TS,

>    I just did a search on Deja.com and found something on DAO and the only
> solution was to un-install Microsoft Office.  There was no response that
> un-installing actually worked, but it may be worth a try.

> Good luck,
> krf

Other Threads