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 th
e
> 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...
>
>|||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...[vbcol=seagreen]
> This vbx receive a Server, BD, User and Pass it's supposed to return a val
ue
> different from 0 when log in, but it's returning a 0.
> In advance, thank you for your help.
> "John Bell" wrote:
>|||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 SQ
L Server allow SQL Server
> logins? Can you login from QA on the same machine using the same credentia
ls?
> --
> 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...
>|||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...[vbcol=seagreen]
> Yes, using the credentials, i can log in the QA.
> "Tibor Karaszi" wrote:
>|||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...
>|||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...[vbcol=seagreen]
> 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:
>|||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 usin
g
> VBSQL.VBX to access the sybase database, it's possible to use the sql 2000
> database with this .vbx i can't log in.