Connect from Visual Basic 6 to SQL Server 2005 express

Hi people,
I downloaded sql server 2005 express and I installed it. I have Visual
Basic 6 application, that work with MS access with ado connection. This
connection give me seek and findfirst methods. I want migrate this access db
to sql sever 2005, but i don't make any change in vb6 code (only the
connection).
My first question is, can i connect from vb6 application to sql sever
2005 express? Moreover,how must i connect the application to sql sever and
work with seek and findfirst methods?
If it's possible, you will put a code example to connect...
Thanks!> Hi people,
> I downloaded sql server 2005 express and I installed it. I have Visual
> Basic 6 application, that work with MS access with ado connection. This
> connection give me seek and findfirst methods. I want migrate this access
db
> to sql sever 2005, but i don't make any change in vb6 code (only the
> connection).
> My first question is, can i connect from vb6 application to sql sever
> 2005 express? Moreover,how must i connect the application to sql sever
and
> work with seek and findfirst methods?
> If it's possible, you will put a code example to connect...
> Thanks!
--
You can't use SEEK and FINDFIRST methods against a SQL Server table. Those
methods will only work against an Access Jet database.
You need to use T-SQL statements such as SELECT...WHERE to accomplish
similar results. Code changes are inevitable.
Hope this helps,
--
Eric Cárdenas
Senior support professional
This posting is provided "AS IS" with no warranties, and confers no rights.

Connect from Visual Basic 6 to SQL Server 2005 express

Hi people,
I downloaded sql server 2005 express and I installed it. I have Visual
Basic 6 application, that work with MS access with ado connection. This
connection give me seek and findfirst methods. I want migrate this access db
to sql sever 2005, but i don't make any change in vb6 code (only the
connection).
My first question is, can i connect from vb6 application to sql sever
2005 express? Moreover,how must i connect the application to sql sever and
work with seek and findfirst methods?
If it's possible, you will put a code example to connect...
Thanks!

> Hi people,
> I downloaded sql server 2005 express and I installed it. I have Visual
> Basic 6 application, that work with MS access with ado connection. This
> connection give me seek and findfirst methods. I want migrate this access
db
> to sql sever 2005, but i don't make any change in vb6 code (only the
> connection).
> My first question is, can i connect from vb6 application to sql sever
> 2005 express? Moreover,how must i connect the application to sql sever
and
> work with seek and findfirst methods?
> If it's possible, you will put a code example to connect...
> Thanks!
You can't use SEEK and FINDFIRST methods against a SQL Server table. Those
methods will only work against an Access Jet database.
You need to use T-SQL statements such as SELECT...WHERE to accomplish
similar results. Code changes are inevitable.
Hope this helps,
Eric Crdenas
Senior support professional
This posting is provided "AS IS" with no warranties, and confers no rights.

Confusion over SP versions

Hi,
I have downloaded and run the file sql2ksp3.exe for
SQL Server 2000.
However, when I run select @.@.version in SQL Analyser it
returns the details for version 2.
ie,
Microsoft SQL Server 2000 - 8.00.534 (Intel X86) Nov 19
2001 13:23:50
Is this OK? Has the SP deployed correctly?
regards
john
Hi,
After the SP3 upgrade the build number should be Microsoft SQL Server
2000 - 8.00.760.
You could check this in SQL 2000 using the below command in query analyzer:-
select serverproperty('ProductLevel')
Can you down load the SP3a from below site and try applying it. After the
upgrade execute the above statement
to get service pack level.
http://www.microsoft.com/sql/downloads/2000/sp3.asp
Thanks
Hari
MCDBA
"John Mullen" <anonymous@.discussions.microsoft.com> wrote in message
news:c4ea01c47a35$714a3300$a501280a@.phx.gbl...
> Hi,
> I have downloaded and run the file sql2ksp3.exe for
> SQL Server 2000.
> However, when I run select @.@.version in SQL Analyser it
> returns the details for version 2.
> ie,
> Microsoft SQL Server 2000 - 8.00.534 (Intel X86) Nov 19
> 2001 13:23:50
> Is this OK? Has the SP deployed correctly?
> regards
> john
>
|||IIRC, if you run the sp3.exe file, it just extracts the contents into a
folder. You need to go to that folder and run setup.exe ...
http://www.aspfaq.com/
(Reverse address to reply.)
"John Mullen" <anonymous@.discussions.microsoft.com> wrote in message
news:c4ea01c47a35$714a3300$a501280a@.phx.gbl...
> Hi,
> I have downloaded and run the file sql2ksp3.exe for
> SQL Server 2000.
> However, when I run select @.@.version in SQL Analyser it
> returns the details for version 2.
> ie,
> Microsoft SQL Server 2000 - 8.00.534 (Intel X86) Nov 19
> 2001 13:23:50
> Is this OK? Has the SP deployed correctly?
> regards
> john
>
|||Thanks Aaron,
sometimes the most obvious things are the most elusive
regards
john

>--Original Message--
>IIRC, if you run the sp3.exe file, it just extracts the
contents into a
>folder. You need to go to that folder and run
setup.exe ...
>--
>http://www.aspfaq.com/
>(Reverse address to reply.)
>
>
>"John Mullen" <anonymous@.discussions.microsoft.com> wrote
in message[vbcol=seagreen]
>news:c4ea01c47a35$714a3300$a501280a@.phx.gbl...
19
>
>.
>

Confusion over SP versions

Hi,
I have downloaded and run the file sql2ksp3.exe for
SQL Server 2000.
However, when I run select @.@.version in SQL Analyser it
returns the details for version 2.
ie,
Microsoft SQL Server 2000 - 8.00.534 (Intel X86) Nov 19
2001 13:23:50
Is this OK? Has the SP deployed correctly?
regards
johnOn my version its saying Microsoft SQL Server 2000 -
8.00.760 (Intel X86) Dec 17 2002 14:22:05.
So my version seems to be ahead of yours.
Peter
>--Original Message--
>Hi,
>I have downloaded and run the file sql2ksp3.exe for
>SQL Server 2000.
>However, when I run select @.@.version in SQL Analyser it
>returns the details for version 2.
>ie,
>Microsoft SQL Server 2000 - 8.00.534 (Intel X86) Nov
19
>2001 13:23:50
>Is this OK? Has the SP deployed correctly?
>regards
>john
>.
>|||Hi,
After the SP3 upgrade the build number should be Microsoft SQL Server
2000 - 8.00.760.
You could check this in SQL 2000 using the below command in query analyzer:-
select serverproperty('ProductLevel')
Can you down load the SP3a from below site and try applying it. After the
upgrade execute the above statement
to get service pack level.
http://www.microsoft.com/sql/downloads/2000/sp3.asp
Thanks
Hari
MCDBA
"John Mullen" <anonymous@.discussions.microsoft.com> wrote in message
news:c4ea01c47a35$714a3300$a501280a@.phx.gbl...
> Hi,
> I have downloaded and run the file sql2ksp3.exe for
> SQL Server 2000.
> However, when I run select @.@.version in SQL Analyser it
> returns the details for version 2.
> ie,
> Microsoft SQL Server 2000 - 8.00.534 (Intel X86) Nov 19
> 2001 13:23:50
> Is this OK? Has the SP deployed correctly?
> regards
> john
>|||IIRC, if you run the sp3.exe file, it just extracts the contents into a
folder. You need to go to that folder and run setup.exe ...
--
http://www.aspfaq.com/
(Reverse address to reply.)
"John Mullen" <anonymous@.discussions.microsoft.com> wrote in message
news:c4ea01c47a35$714a3300$a501280a@.phx.gbl...
> Hi,
> I have downloaded and run the file sql2ksp3.exe for
> SQL Server 2000.
> However, when I run select @.@.version in SQL Analyser it
> returns the details for version 2.
> ie,
> Microsoft SQL Server 2000 - 8.00.534 (Intel X86) Nov 19
> 2001 13:23:50
> Is this OK? Has the SP deployed correctly?
> regards
> john
>|||Thanks Aaron,
sometimes the most obvious things are the most elusive
regards
john
>--Original Message--
>IIRC, if you run the sp3.exe file, it just extracts the
contents into a
>folder. You need to go to that folder and run
setup.exe ...
>--
>http://www.aspfaq.com/
>(Reverse address to reply.)
>
>
>"John Mullen" <anonymous@.discussions.microsoft.com> wrote
in message
>news:c4ea01c47a35$714a3300$a501280a@.phx.gbl...
>> Hi,
>> I have downloaded and run the file sql2ksp3.exe for
>> SQL Server 2000.
>> However, when I run select @.@.version in SQL Analyser it
>> returns the details for version 2.
>> ie,
>> Microsoft SQL Server 2000 - 8.00.534 (Intel X86) Nov
19
>> 2001 13:23:50
>> Is this OK? Has the SP deployed correctly?
>> regards
>> john
>
>.
>

Confusion over SP versions

Hi,
I have downloaded and run the file sql2ksp3.exe for
SQL Server 2000.
However, when I run select @.@.version in SQL Analyser it
returns the details for version 2.
ie,
Microsoft SQL Server 2000 - 8.00.534 (Intel X86) Nov 19
2001 13:23:50
Is this OK? Has the SP deployed correctly?
regards
johnHi,
After the SP3 upgrade the build number should be Microsoft SQL Server
2000 - 8.00.760.
You could check this in SQL 2000 using the below command in query analyzer:-
select serverproperty('ProductLevel')
Can you down load the SP3a from below site and try applying it. After the
upgrade execute the above statement
to get service pack level.
http://www.microsoft.com/sql/downloads/2000/sp3.asp
Thanks
Hari
MCDBA
"John Mullen" <anonymous@.discussions.microsoft.com> wrote in message
news:c4ea01c47a35$714a3300$a501280a@.phx.gbl...
> Hi,
> I have downloaded and run the file sql2ksp3.exe for
> SQL Server 2000.
> However, when I run select @.@.version in SQL Analyser it
> returns the details for version 2.
> ie,
> Microsoft SQL Server 2000 - 8.00.534 (Intel X86) Nov 19
> 2001 13:23:50
> Is this OK? Has the SP deployed correctly?
> regards
> john
>|||IIRC, if you run the sp3.exe file, it just extracts the contents into a
folder. You need to go to that folder and run setup.exe ...
http://www.aspfaq.com/
(Reverse address to reply.)
"John Mullen" <anonymous@.discussions.microsoft.com> wrote in message
news:c4ea01c47a35$714a3300$a501280a@.phx.gbl...
> Hi,
> I have downloaded and run the file sql2ksp3.exe for
> SQL Server 2000.
> However, when I run select @.@.version in SQL Analyser it
> returns the details for version 2.
> ie,
> Microsoft SQL Server 2000 - 8.00.534 (Intel X86) Nov 19
> 2001 13:23:50
> Is this OK? Has the SP deployed correctly?
> regards
> john
>|||Thanks Aaron,
sometimes the most obvious things are the most elusive
regards
john

>--Original Message--
>IIRC, if you run the sp3.exe file, it just extracts the
contents into a
>folder. You need to go to that folder and run
setup.exe ...
>--
>http://www.aspfaq.com/
>(Reverse address to reply.)
>
>
>"John Mullen" <anonymous@.discussions.microsoft.com> wrote
in message
>news:c4ea01c47a35$714a3300$a501280a@.phx.gbl...
19[vbcol=seagreen]
>
>.
>