Is possible?

I have an vb4 application (i know it's old, but it's not my fault), and i
need to change the used database (sybase) to sql (sql 2000). They are using
VBSQL.VBX to access the sybase database, it's possible to use the sql 2000
database with this .vbx i can't log in.Hi
I am not familiar with sybase and this vbx! But with SQL 2000 you audit the
logins with profiler so you can see how it is trying to connect. I would
assume that you have the configured/changed the servername and also any
other setting that are require such as a DSN.
John
"Logan" <Logan@.discussions.microsoft.com> wrote in message
news:55932181-6449-4520-8EBA-8C2D213A4206@.microsoft.com...
>I have an vb4 application (i know it's old, but it's not my fault), and i
> need to change the used database (sybase) to sql (sql 2000). They are
> using
> VBSQL.VBX to access the sybase database, it's possible to use the sql 2000
> database with this .vbx i can't log in.|||This vbx receive a Server, BD, User and Pass it's supposed to return a value
different from 0 when log in, but it's returning a 0.
In advance, thank you for your help.
"John Bell" wrote:
> Hi
> I am not familiar with sybase and this vbx! But with SQL 2000 you audit the
> logins with profiler so you can see how it is trying to connect. I would
> assume that you have the configured/changed the servername and also any
> other setting that are require such as a DSN.
> John
> "Logan" <Logan@.discussions.microsoft.com> wrote in message
> news:55932181-6449-4520-8EBA-8C2D213A4206@.microsoft.com...
> >I have an vb4 application (i know it's old, but it's not my fault), and i
> > need to change the used database (sybase) to sql (sql 2000). They are
> > using
> > VBSQL.VBX to access the sybase database, it's possible to use the sql 2000
> > database with this .vbx i can't log in.
>
>|||VBSQL.VBX is soo old. It uses the old DbLibrary API... Anyhow, does the SQL Server allow SQL Server
logins? Can you login from QA on the same machine using the same credentials?
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Logan" <Logan@.discussions.microsoft.com> wrote in message
news:653CEA89-C956-4A43-A252-A96AA9339E3F@.microsoft.com...
> This vbx receive a Server, BD, User and Pass it's supposed to return a value
> different from 0 when log in, but it's returning a 0.
> In advance, thank you for your help.
> "John Bell" wrote:
>> Hi
>> I am not familiar with sybase and this vbx! But with SQL 2000 you audit the
>> logins with profiler so you can see how it is trying to connect. I would
>> assume that you have the configured/changed the servername and also any
>> other setting that are require such as a DSN.
>> John
>> "Logan" <Logan@.discussions.microsoft.com> wrote in message
>> news:55932181-6449-4520-8EBA-8C2D213A4206@.microsoft.com...
>> >I have an vb4 application (i know it's old, but it's not my fault), and i
>> > need to change the used database (sybase) to sql (sql 2000). They are
>> > using
>> > VBSQL.VBX to access the sybase database, it's possible to use the sql 2000
>> > database with this .vbx i can't log in.
>>|||Yes, using the credentials, i can log in the QA.
"Tibor Karaszi" wrote:
> VBSQL.VBX is soo old. It uses the old DbLibrary API... Anyhow, does the SQL Server allow SQL Server
> logins? Can you login from QA on the same machine using the same credentials?
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "Logan" <Logan@.discussions.microsoft.com> wrote in message
> news:653CEA89-C956-4A43-A252-A96AA9339E3F@.microsoft.com...
> > This vbx receive a Server, BD, User and Pass it's supposed to return a value
> > different from 0 when log in, but it's returning a 0.
> >
> > In advance, thank you for your help.
> >
> > "John Bell" wrote:
> >
> >> Hi
> >>
> >> I am not familiar with sybase and this vbx! But with SQL 2000 you audit the
> >> logins with profiler so you can see how it is trying to connect. I would
> >> assume that you have the configured/changed the servername and also any
> >> other setting that are require such as a DSN.
> >>
> >> John
> >>
> >> "Logan" <Logan@.discussions.microsoft.com> wrote in message
> >> news:55932181-6449-4520-8EBA-8C2D213A4206@.microsoft.com...
> >> >I have an vb4 application (i know it's old, but it's not my fault), and i
> >> > need to change the used database (sybase) to sql (sql 2000). They are
> >> > using
> >> > VBSQL.VBX to access the sybase database, it's possible to use the sql 2000
> >> > database with this .vbx i can't log in.
> >>
> >>
> >>
>|||It is not a named SQL Server instance, I hope?
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Logan" <Logan@.discussions.microsoft.com> wrote in message
news:38232FBF-885E-41DF-9B34-BFC5C87C3C46@.microsoft.com...
> Yes, using the credentials, i can log in the QA.
> "Tibor Karaszi" wrote:
>> VBSQL.VBX is soo old. It uses the old DbLibrary API... Anyhow, does the SQL Server allow SQL
>> Server
>> logins? Can you login from QA on the same machine using the same credentials?
>> --
>> Tibor Karaszi, SQL Server MVP
>> http://www.karaszi.com/sqlserver/default.asp
>> http://www.solidqualitylearning.com/
>>
>> "Logan" <Logan@.discussions.microsoft.com> wrote in message
>> news:653CEA89-C956-4A43-A252-A96AA9339E3F@.microsoft.com...
>> > This vbx receive a Server, BD, User and Pass it's supposed to return a value
>> > different from 0 when log in, but it's returning a 0.
>> >
>> > In advance, thank you for your help.
>> >
>> > "John Bell" wrote:
>> >
>> >> Hi
>> >>
>> >> I am not familiar with sybase and this vbx! But with SQL 2000 you audit the
>> >> logins with profiler so you can see how it is trying to connect. I would
>> >> assume that you have the configured/changed the servername and also any
>> >> other setting that are require such as a DSN.
>> >>
>> >> John
>> >>
>> >> "Logan" <Logan@.discussions.microsoft.com> wrote in message
>> >> news:55932181-6449-4520-8EBA-8C2D213A4206@.microsoft.com...
>> >> >I have an vb4 application (i know it's old, but it's not my fault), and i
>> >> > need to change the used database (sybase) to sql (sql 2000). They are
>> >> > using
>> >> > VBSQL.VBX to access the sybase database, it's possible to use the sql 2000
>> >> > database with this .vbx i can't log in.
>> >>
>> >>
>> >>
>>|||No, i'm using the IP
"Tibor Karaszi" wrote:
> It is not a named SQL Server instance, I hope?
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "Logan" <Logan@.discussions.microsoft.com> wrote in message
> news:38232FBF-885E-41DF-9B34-BFC5C87C3C46@.microsoft.com...
> > Yes, using the credentials, i can log in the QA.
> >
> > "Tibor Karaszi" wrote:
> >
> >> VBSQL.VBX is soo old. It uses the old DbLibrary API... Anyhow, does the SQL Server allow SQL
> >> Server
> >> logins? Can you login from QA on the same machine using the same credentials?
> >>
> >> --
> >> Tibor Karaszi, SQL Server MVP
> >> http://www.karaszi.com/sqlserver/default.asp
> >> http://www.solidqualitylearning.com/
> >>
> >>
> >> "Logan" <Logan@.discussions.microsoft.com> wrote in message
> >> news:653CEA89-C956-4A43-A252-A96AA9339E3F@.microsoft.com...
> >> > This vbx receive a Server, BD, User and Pass it's supposed to return a value
> >> > different from 0 when log in, but it's returning a 0.
> >> >
> >> > In advance, thank you for your help.
> >> >
> >> > "John Bell" wrote:
> >> >
> >> >> Hi
> >> >>
> >> >> I am not familiar with sybase and this vbx! But with SQL 2000 you audit the
> >> >> logins with profiler so you can see how it is trying to connect. I would
> >> >> assume that you have the configured/changed the servername and also any
> >> >> other setting that are require such as a DSN.
> >> >>
> >> >> John
> >> >>
> >> >> "Logan" <Logan@.discussions.microsoft.com> wrote in message
> >> >> news:55932181-6449-4520-8EBA-8C2D213A4206@.microsoft.com...
> >> >> >I have an vb4 application (i know it's old, but it's not my fault), and i
> >> >> > need to change the used database (sybase) to sql (sql 2000). They are
> >> >> > using
> >> >> > VBSQL.VBX to access the sybase database, it's possible to use the sql 2000
> >> >> > database with this .vbx i can't log in.
> >> >>
> >> >>
> >> >>
> >>
> >>
>|||Hi
Does this mean that profiler says the login is successful? In which case the
issue is not with SQL Server!
John
"Logan" <Logan@.discussions.microsoft.com> wrote in message
news:653CEA89-C956-4A43-A252-A96AA9339E3F@.microsoft.com...
> This vbx receive a Server, BD, User and Pass it's supposed to return a
> value
> different from 0 when log in, but it's returning a 0.
> In advance, thank you for your help.
> "John Bell" wrote:
>> Hi
>> I am not familiar with sybase and this vbx! But with SQL 2000 you audit
>> the
>> logins with profiler so you can see how it is trying to connect. I would
>> assume that you have the configured/changed the servername and also any
>> other setting that are require such as a DSN.
>> John
>> "Logan" <Logan@.discussions.microsoft.com> wrote in message
>> news:55932181-6449-4520-8EBA-8C2D213A4206@.microsoft.com...
>> >I have an vb4 application (i know it's old, but it's not my fault), and
>> >i
>> > need to change the used database (sybase) to sql (sql 2000). They are
>> > using
>> > VBSQL.VBX to access the sybase database, it's possible to use the sql
>> > 2000
>> > database with this .vbx i can't log in.
>>|||Thank you for your help
"Logan" wrote:
> I have an vb4 application (i know it's old, but it's not my fault), and i
> need to change the used database (sybase) to sql (sql 2000). They are using
> VBSQL.VBX to access the sybase database, it's possible to use the sql 2000
> database with this .vbx i can't log in.