|
sql
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
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 Show quoteHide quote "Logan" <Lo***@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. Show quoteHide quote "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" <Lo***@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? -- Show quoteHide quoteTibor Karaszi, SQL Server MVP http://www.karaszi.com/sqlserver/default.asp http://www.solidqualitylearning.com/ "Logan" <Lo***@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" <Lo***@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.
Show quoteHide quote "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" <Lo***@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" <Lo***@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?
-- Show quoteHide quoteTibor Karaszi, SQL Server MVP http://www.karaszi.com/sqlserver/default.asp http://www.solidqualitylearning.com/ "Logan" <Lo***@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" <Lo***@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" <Lo***@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
Show quoteHide quote "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" <Lo***@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" <Lo***@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" <Lo***@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 Show quoteHide quote "Logan" <Lo***@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" <Lo***@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
Show quoteHide quote "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.  
Other interesting topics
|
|||||||||||||||||||||||
