General discussion

Locked

how to connect microsoft visual basic 6.0 to sql server 2000

By kirankumar4488 ·
explain how to connect Microsoft Visual basic 6.0 to sql sever 2000

This conversation is currently closed to new comments.

5 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Collapse -

solution to that is

by creative2002guy In reply to how to connect microsoft ...

"Provider=SQLOLEDB.1;Password=<your password>;Persist Security Info=True;User ID=<user name>;Initial Catalog=<database name>"

Collapse -

Regarding Access to Sqlserver

by muthu19485 In reply to solution to that is

Hi,
We hav developed a software with VB6.0 as frontend and access2000 as a backend.
And now am interested to convert the database access to sql sever2000.For that wat are the steps I have to do?

Collapse -

Depends on the app.

by Tony Hopkinson In reply to Regarding Access to Sqlse ...

First as posted simply change the connection string.

Then test, see if you've got any access specific non standard SQL

How easy that is depends on how modular your code is.

Then potentially ( almost certainly) optimise.
Generally when scaling a desktop backend to a full DBMS, your problem areas will be
locking, transaction isolation and it being dog slow because you did a lot of the data processing in code instead of in the database.
How much work the above is depends on way too many factors, in my experience having done this sort of thing several times it always turns out to be a lot more management hoped.

Collapse -

SOFTWARE ENGINEER

by SANJAY_NCCB In reply to Regarding Access to Sqlse ...

SOFTWARE ENGINEER PROJECT DEVLOPMENT

Collapse -

Download the Resume

by krg_b In reply to how to connect microsoft ...

Download the Resume

Back to Networks Forum
5 total posts (Page 1 of 1)  

Hardware Forums